max item id is 20000. i see 27788, 27931, 28069 ... what is the problem
fixed in http://code.google.com/p/onetimexi/source/detail?r=2191
r2182 build problem
Forum rules
NO LONGER BEING MAINTAINED!
NO LONGER BEING MAINTAINED!
Re: r2182 build problem
that would still work (there's a check for NULL) but dia found out what it was, the max id.whasf wrote:I had the same problem on the old-school server, I ran the delete and it's loading. See below:
gets me:Code: Select all
select * FROM item_mods WHERE itemId NOT IN (SELECT itemid FROM item_basic);
So there are mods for items that dont exist!Code: Select all
"itemId" "modId" "value" "10552" "73" "2" "10281" "369" "2" "10282" "369" "1" "10288" "369" "1" "10467" "369" "1" "10492" "369" "1" "10564" "369" "1" "11876" "369" "1" "27788" "369" "2" "27791" "369" "2" "27792" "369" "2" "27797" "369" "2" "10468" "370" "3" "10491" "370" "2" "11875" "370" "1" "27788" "370" "2" "27931" "370" "2" "28069" "370" "1"
if anyone is curious, it's because zedingo used the list on ffxiah to find all items with refresh and included abyssea stuff (i told him to because many of the scripts i deleted were for 75+ items, and i didn't want to lose them)
(ex: 27791 is marduk's jubbah+1, lvl 99 body armor)
Re: r2182 build problem
Fantastic. Thanks for the quick fix guys!
I can confirm the fix is working great, at least on Linux, cheers!
I can confirm the fix is working great, at least on Linux, cheers!
Code: Select all
mysql> select * FROM item_mods WHERE itemId NOT IN (SELECT itemid FROM item_basic);
+--------+-------+-------+
| itemId | modId | value |
+--------+-------+-------+
| 10552 | 73 | 2 |
| 10281 | 369 | 2 |
| 10282 | 369 | 1 |
| 10288 | 369 | 1 |
| 10467 | 369 | 1 |
| 10492 | 369 | 1 |
| 10564 | 369 | 1 |
| 11876 | 369 | 1 |
| 10468 | 370 | 3 |
| 10491 | 370 | 2 |
| 11875 | 370 | 1 |
+--------+-------+-------+
11 rows in set (0.04 sec)