|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
10-04-2011, 12:08 PM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
13thFloor items
So.. i feel bad for two posts but this doesnt follow my last. but i just Dld the new 13thfloor item db. its .txt. how in the world do i put it into my db?
|
10-04-2011, 12:55 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
I've already merged it into PEQ. Look for a commit today of the database with the newest items in.
|
10-04-2011, 01:23 PM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
on PEQ's site?
|
10-04-2011, 01:40 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Well, Google SVN https://code.google.com/p/projecteqdb/
SVN is uploading now, downloads section will be updated after.
|
10-04-2011, 01:47 PM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
woot ty! You do an amazing job!
|
10-04-2011, 02:56 PM
|
Demi-God
|
|
Join Date: Aug 2010
Posts: 1,743
|
|
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.
|
10-04-2011, 03:58 PM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
Ah crap... items dont show up now in game.....
|
|
|
|
10-04-2011, 04:19 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Quote:
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 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.
|
|
|
|
10-04-2011, 05:23 PM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
Yeah probably. but everytime i try to compile my own server i just get tons of errors.
Edit: btw i was using the rev1887 EqEmu server from http://code.google.com/p/projecteqemu/downloads/list to run my server. with the updated revs sqls
|
10-04-2011, 06:36 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Revision 2022 is being uploaded now. It should fix your problem as the item limit was increased since your last update.
|
10-04-2011, 09:45 PM
|
Demi-God
|
|
Join Date: Aug 2010
Posts: 1,743
|
|
Cool, thanks for the info on stackable. The blanket approach seemed wrong, but I couldn't see anything in the data that made sense to set it based on anything else.
Do you do anything special with bagslots?
|
10-05-2011, 02:04 AM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
Hmm i was getting a error missing perl58.dll
got the dll and now get
Quote:
The procedure entry point Perl_newXS_Flags could not be located in the dynamic link library perl58.dll
|
i'm stumped..
|
10-05-2011, 06:36 AM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Quote:
Originally Posted by Rakkoraz05
Hmm i was getting a error missing perl58.dll
got the dll and now get
i'm stumped..
|
Perl issue not related to DB/Source updates. See here:
http://www.eqemulator.org/forums/showthread.php?t=26643
|
10-05-2011, 11:16 AM
|
Fire Beetle
|
|
Join Date: Apr 2009
Location: UTah
Posts: 28
|
|
Not to be rude. but with some of the fixes. the versions of Perl i would need i can not find... setting me back..
|
10-05-2011, 12:34 PM
|
Sarnak
|
|
Join Date: Jun 2003
Posts: 75
|
|
In general, to fix your pearl related issues:
1) download the currently available version (5.14? sorry, it's been awhile)
2) change your references to the same version
3) recompile the code
As Trev pointed out, Pearl related issues are a codebase issue (on your end) and not a DB issue. (Also, don't freak out too much if Cary gives you grief; he's a linux guy and can't help being that way.)
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:05 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|