r2182 build problem

Forum rules
NO LONGER BEING MAINTAINED!
User avatar
diatanato
Developer
Posts: 112
Joined: Thu Aug 30, 2012 9:59 pm

Re: r2182 build problem

Post by diatanato » Sat Jan 05, 2013 11:45 pm

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

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: r2182 build problem

Post by kjLotus » Sun Jan 06, 2013 2:18 am

whasf wrote:I had the same problem on the old-school server, I ran the delete and it's loading. See below:

Code: Select all

select * FROM item_mods WHERE itemId NOT IN (SELECT itemid FROM item_basic);
gets me:

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"
So there are mods for items that dont exist!
that would still work (there's a check for NULL) but dia found out what it was, the max id.

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)

metronet
Posts: 10
Joined: Mon Dec 03, 2012 7:46 pm

Re: r2182 build problem

Post by metronet » Sun Jan 06, 2013 5:22 am

Fantastic. Thanks for the quick fix guys!

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)

Post Reply