| cavedude |
10-04-2011 04:19 PM |
Quote:
Originally Posted by Rakkoraz05
(Post 203688)
Ah crap... items dont show up now in game.....
|
Not sure why you're having trouble, the new items have been on PEQ for a couple days now which has seen 2 reboots. They also work on my local test server. I know there was a commit to EQEmu that upped the item limit a while back, perhaps your binaries are older?
I just add the missing columns then use the basic 13th floor import script. Also, here are the queries for the stackable column:
Code:
update items set stackable = 1 where clickeffect = -1 and maxcharges = 1;
update items set stackable = 1 where itemtype in (14,18,28,55,15,19,37,56,17,27,38,53);
update items set stackable = 1 where name like 'Song:%' and itemtype = 20;
update items set stackable = 1 where name like 'Spell:%' and itemtype = 20;
update items set stackable = 1 where stacksize > 1 and maxcharges = 1 and itemtype = 21;
update items set stackable = 1 where id in (10420,10423,10424,10434,10440,10441,10466,10467,21347,22093,22094,22097,29999,96911);
The first queries were derived from the source code of Lucy's item collector a while back. The last one is hackish, and the fact that it is required indicates Sony's formula for stackable has changed since I last looked at Lucy's code. But, you can't just set stackable to 1 where stacksize > 1. 2,430 stacklable items have a stacksize of 1, and 3,803 items that should not stack have a stacksize > 1 in the current database. I had to figure out the correct queries the first time I imported items because players were reporting that armor and such were trying to stack. Sure enough when I looked, they had a stacksize greater than 1. Why, I do not know. |