Guide for updating ITEMS with the PEQ database

Zandig · #1 06-23-2006, 08:09 AM

Here is how to update the ITEMS for the PEQ database using the 13th Floor Items:

Guide moved to the wiki
http://www.eqemulator.net/wiki/wikka...=Load13thFloor

Let it do it's thing and you should be updated!
It took me a while to figure it out on my own but I thought I would post it here becuase maybe someone else finds it useful?

Angelox · #2 06-23-2006, 09:05 AM

Sounds good to me, thanks.
I'm wondering how old they are though - I'm thinking there isn't much, if any "public" updates since WindowsServer70 was released

Zandig · #3 06-23-2006, 10:15 AM

I think it was about 550 extra items or so...

**fathernitwit** · #4 06-23-2006, 11:22 AM

guides belong on the wiki.

Zandig · #5 06-23-2006, 11:52 AM

Quote:

Originally Posted by fathernitwit

guides belong on the wiki.

Added to the wiki:
http://www.eqemulator.net/wiki/wikka...=Load13thFloor

- Zandig Slaytanic

njlinus · #6 06-26-2006, 10:00 AM

hm this didnt seem to work for me after i did
6) Type "drop items" (without the quotes)

7) Type "source items.sql" (without the quotes)
Now close the window. do i hit enter? or ;enter
and i cant get my cmd window to go to C:\perl\ any ideas?
im not advanced on this at all sorry for the problems

Zandig · #7 06-26-2006, 12:54 PM

After you're done with the sql commands<hitting ENTER after each command>, close the window.
Then you must naviagte to your command prompt.
For example: Hit "Start"/"Command Prompt" or "Start"/"Run"/then type "cmd" (all without the quotes of course).

Then, the easiest way to get to the Perl directory is:
cd\
Then: cd perl

then you can run the command.

- Zandig Slaytanic

njlinus · #8 06-26-2006, 01:46 PM

That worked thanks Zandig!

Justsomeguy · #9 07-23-2006, 09:46 AM

Worked well.

I had problems with my perl so I updated to the latest version. Also, I had to correct for DBI and DBD/mysql error. Just installed followed by installing DBI and DBD-Mysql by going to start > run > ppm install DBI and finally start>run>ppm install DBD-mysql

After that, following your steps worked like a charm (regardless of what the wiki guide says about 13th floor importing).

sylverwolf · #10 08-20-2006, 09:55 AM

From the wiki:

'load_13thfloor_items.pl' which is located in your EQEmu\Source\0.7.0\utils directory

I was unable to find this. There was no Source folder.