something to get working

norsan · #1 08-17-2009, 05:01 AM

would anyone like to assist me in getting the items tables up to date with whats on eqitems.13th-floor.org it would be awesome if we could once again keep the items table up to date

**joligario** · #2 08-17-2009, 05:31 AM

Cavedude did a 13th floor dump not too long ago. His PEQ database is probably pretty up-to-date.

norsan · #3 08-17-2009, 09:16 AM

i use the peq db theres alot of items missing

**trevius** · #4 08-17-2009, 09:53 PM

PEQ DB can only update to what 13 floor has collected so far. I would say it probably has about 95% of all items available on Live atm. The missing ones are probably just the items that people haven't collected while running the 13 floor tools to log them yes. Are you finding a bunch missing stuff in the PEQ DB that you can actually find with a 13 floor website search? When was the last time you updated your items table to PEQ? The last time I did it, I just removed the part of the SQL that removes and rebuilds the table, so I didn't lose any existing items (custom or not) that I already had in my table. Then, I just made sure that the schema for my table matched the PEQ table perfectly. Once that was done, I just sourced in the SQL entries and allowed it to error for all existing items in my table. I hadn't updated in over a year, and this last time I got about 12k new items added, which was really nice. The updated items are great if you are using SoF on your server.

laxative · #5 08-25-2009, 01:41 PM

Hi,

I have futzed around with the items much at all. But I did notice that everytime I update the database I'm not seeing any new items.

I have 76214 items that load when I start the server. Does this information seem about right? I guess I need to do some reading regarding 13th floor.

Laxa

**joligario** · #6 08-25-2009, 03:17 PM

That number looks right.

Andrew80k · #7 08-25-2009, 04:24 PM

Quote:

Originally Posted by trevius

PEQ DB can only update to what 13 floor has collected so far. I would say it probably has about 95% of all items available on Live atm. The missing ones are probably just the items that people haven't collected while running the 13 floor tools to log them yes. Are you finding a bunch missing stuff in the PEQ DB that you can actually find with a 13 floor website search? When was the last time you updated your items table to PEQ? The last time I did it, I just removed the part of the SQL that removes and rebuilds the table, so I didn't lose any existing items (custom or not) that I already had in my table. Then, I just made sure that the schema for my table matched the PEQ table perfectly. Once that was done, I just sourced in the SQL entries and allowed it to error for all existing items in my table. I hadn't updated in over a year, and this last time I got about 12k new items added, which was really nice. The updated items are great if you are using SoF on your server.

It's funny, I was playing live last night, and someone mentioned a post by sony on one of its boards stating that there were around 80,000 items and around 3000 still undiscovered.

**AndMetal** · #8 08-27-2009, 02:51 AM

From the 13th Floor's website:

Quote:

There are 79493 items in the database and 0 waiting to be approved.

Lowest item id is 1001. Highest item id is 119463.

demonstar55 · #9 08-27-2009, 08:44 AM

If someone does take on this task make sure they contact CD about the patches he applies after he would import a new dump from 13th floor.

**cavedude** · #10 08-27-2009, 11:37 AM

I already dumped 13th floor, a couple of days ago. It'll be in the next PEQ SVN dump. I just had to make sure all was well with the items on TGC and it looks so.

bergalas · #11 08-27-2009, 12:24 PM

Im curious do you source them all by hand or use some kind of parser?

**cavedude** · #12 08-27-2009, 12:47 PM

There is a parser in the utils folder of the EQEmu SVN that does the actual sourcing. I have to manually add any new columns as the parser complains about them. Lastly, I source in an updates sql, which some have asked to be released but the problem is it changes nearly every time I update items. Before I release the table to the public, it's first tested on TGC. Once they have nailed down the major bugs (of which so far, there was only one small oversight on my part) it's then considered release worthy.

bergalas · #13 08-27-2009, 12:50 PM

I tried the parser in the eqemu repository, but it didnt work for me at all told me there was an error in my mysql syntax.any chance you could update that parser or am i using the wrong one? I used load_13thfloor_items.pl

**cavedude** · #14 08-27-2009, 12:57 PM

Nope, it works fine. That's the same one I used.

bergalas · #15 08-27-2009, 01:08 PM

C:\Perl>perl load_13thfloor_items.pl -d eqemu_config.xml <items.txt
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
'' at line 1 at load_13thfloor_items.pl line 72, <STDIN> line 2.