New Items (13th Floor)

[mrea]

I was wondering if by any means you could get the current item db from the 13th floor to work with 6.0. I realize the structure of the item database was changed with 6.1 and so you can't just run the perl loader for items.txt. However, If possible I'd like to get all the items somehow ;-)

If there is some way to get that working with 6.0 I'd greatly appreciate the knowledge.

[kouhei]

I was able to get the items in from the 13th floor in my db. So it is possible.
What I did was.. I made my own script and had it take there data and insert it into my db.

[mrea]

Alright, well, I'll have to examine the script for loading it into 6.1 I guess. I don't know perl though. If I get it working I'll post it

[kouhei]

post your item fields let me take a loot to see what fields you have.

[mrea]

Here is my items table:
"id"|"minstatus"|"Name"|"aagi"|"ac"|"accuracy"|"acha"|"adex"|"aint"|"artifactflag"|"asta"|"astr"|"attackbonus"|"augmentrestriction"|"augslot1type"|"augslot2type"|"augslot3type"|"augslot4type"|"augslot5type"|"augtype"|"avoidance"|"awis"|"bagsize"|"bagslots"|"bagtype"|"bagwr"|"banedmgamt"|"banedmgamt2"|"banedmgbody"|"banedmgrace"|"bardtype"|"bardvalue"|"booktype"|"casttime"|"casttime2"|"charges"|"charmfile"|"charmformula"|"classes"|"collected_inst_id"|"collected_slot_id"|"color"|"combateffects"|"combatskill"|"combatskilldmg"|"cost"|"cr"|"damage"|"damageshield"|"deity"|"delay"|"distiller"|"dotshielding"|"dr"|"effecttype"|"elemdmgtype"|"elemdmgamt"|"endur"|"factionamt1"|"factionamt2"|"factionamt3"|"factionamt4"|"factionmod1"|"factionmod2"|"factionmod3"|"factionmod4"|"filename"|"focusid"|"fr"|"gmflag"|"hastepercent"|"hasteproclvl"|"hp"|"hpregen"|"icon"|"idfile"|"itemclass"|"itemtype"|"ldonpointcost"|"ldonpointtheme"|"ldonsold"|"light"|"lore"|"loreflag"|"magic"|"mana"|"manaregen"|"material"|"maxcharges"|"merchantprice"|"mr"|"nodrop"|"norent"|"pendingloreflag"|"pr"|"proc_rate_mod"|"races"|"range"|"reclevel"|"recskill"|"reqlevel"|"sellrate"|"shielding"|"size"|"skillmodtype"|"skillmodvalue"|"slots"|"spellid"|"spellshield"|"strikethrough"|"stunresist"|"summonedflag"|"tradeskills"|"tribute"|"weight"|"unknown001"|"unknown002"|"unknown003"|"unknown004"|"unknown005"|"unknown006"|"unknown007"|"unknown018"|"unknown019"|"unknown020"|"unknown021"|"unknown022"|"unknown023"|"unknown061"|"unknown064"|"unknown067"|"unknown069"|"unknown070"|"unknown072"|"unknown081"|"unknown105"|"unknown108"|"unknown122"|"unknown123"|"unknown124"|"unknown125"|"unknown126"|"unknown127"|"unknown128"|"unknown129"|"unknown130"|"unknown131"|"unknown132"|"unknown133"|"updated"|"comment"|"SpellCharges"|"attuneable"

[sdabbs65]

I was wondering if by any means you could get the current item db from the 13th floor to work with 6.0. I realize the structure of the item database was changed with 6.1 and so you can't just run the perl loader for items.txt. However, If possible I'd like to get all the items somehow ;-)

If there is some way to get that working with 6.0 I'd greatly appreciate the knowledge.

epics 2.0 are not on any of the 6.0 servers.
unless they have compiled a new binary supporting more items.
than the limit that is now in place on it.
I wish I knew how to compile a new one to support 13th floor items but
I don't know how to compile it correctly yet.
I heard someone had modified the perl loader to work with 6.0
but I don't think he wants to share.
also im not sure when epics came out but you have to be patched up to that date to see them.

[kouhei]

Well you must not have come to Dark Blades. We have all 13th floor items on my server. I run 6.0 Dr2. If you want to know how to upload the items to your db all (13th Floor items) Please send me a PM I will tell ya or catch me on AOL subme503

[sdabbs65]

Well you must not have come to Dark Blades. We have all 13th floor items on my server. I run 6.0 Dr2. If you want to know how to upload the items to your db all (13th Floor items) Please send me a PM I will tell ya or catch me on AOL subme503


uploading the items isn't the problem,that workd great.
you need the new binarys to support it.
Lowest item id is 1001. Highest item id is 92992.
and patched to whenever the EPICS 2.0 came out.
im currently patched to 12/15/04 so I doubt there in there.

[kouhei]

Here is the current Items as of 6/23/05 of the 13th floor. This is my DB items it also has some custom items in there. This will work with 6.0 dr2
You will need a recompile of eqemu to use it just source it will update your db so no need to delete it.

http://www.darkblades.net/items.zip

[sdabbs65]

Thanks but thats not the problem...
I can get the loaditems.pl to work great...
but we are not 6.1. so it's useless untill I figgure out how to complie a new binary.

[sdabbs65]

I finally got it to compile..
I was missing a few include dirs and after I got that fixed it compiled like a charm...
I will be useing your items databse now thanks for the help.

[wraithlord98]

Old thread - I know - but how does one use the script with the newer Emu releases (0.6.3/0.6.4)? I followed the few walkthroughs I found - but it keeps erroring out. I imagine it's because there's that many changes in the two schema's?

[kouhei]

Are you using 6.0 or the newer 6.3 or 6.4? If the newer version. If you do a search on the loaditem.pl. You will need the latest 13thfloor.txt and the loaditem.pl file. If I remember right make sure they are in the same dir. Then there was a couple options you had to use but there is a command line you have to type for it to use the that .pl and 13th floor. Maybe someone with the newer version if thats what your trying to setup might have some insite on this.

[fathernitwit]

it wont work on the new items from 13th floor, we havent taken the time to map all the new fields back to their pre-DoD counterparts. Mainly complicated because they completely changed the way some fields work.

[wraithlord98]

I wasn't too specific - but the question was answered.. Using Emu 0.6.4 r 590..