[cavedude]

Originally Posted by Rakkoraz05

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 posted a script here that I used to import the items. http://www.eqemulator.org/forums/showthread.php?t=34226

It may be a bit hacky, but it worked for the items I was interested in.

Any chance you could post the script you used Cavedude? I'm guessing it's prettier.

I just add the missing columns then use the basic 13th floor import script. Also, here are the queries for the stackable column:

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.