Kroeg
10-31-2003, 02:40 AM
I have a server up and running off and on, on the master eqlogin server list. I've noticed people getting db items to show up and npcs are starting to work too.
------------
Ok, I've got npcs, doors, weather sequences, and many other things working right. the ONLY thing I don't have working is the item list. Is there a new table convention used in 0.5.0? How come eqemu runs perfectly with all worlds populated, and all doors in place - nearly 80% efficiently, and yet when world.exe is first loaded, I get the following output:
------------------------Start of World.exe Output Window-----------------
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=23980, max id=67382
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: xx.xxx.xxx.xxx:xxxx
World server listening on: xx.xxx.xxx.xxx:xxxx
Connected to LoginServer: eqlogin1.eqemulator.net:5997
-------------------EOF-----------------------------------------------------
I've gone into my database and tried to rebuild the table for 'items' with no luck. No matter what I do, even dropping the item table from the database, along with the item dump table... I still get that error.
Even though I get these errors, people can login to my server with about 90% stability over 5 hours, and I have somewhat interactable and casting npcs with working doors and weather cycles.
My only question is, how is 0.5.0 DR4 meant to interact with the new database structure for the items table / dump table? Blindly editing the code is teadious and almost makes it impossible to get things exactly stable. There are servers up that have made the item tables work, so it must be a simple fix somewhere.
------------
Ok, I've got npcs, doors, weather sequences, and many other things working right. the ONLY thing I don't have working is the item list. Is there a new table convention used in 0.5.0? How come eqemu runs perfectly with all worlds populated, and all doors in place - nearly 80% efficiently, and yet when world.exe is first loaded, I get the following output:
------------------------Start of World.exe Output Window-----------------
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=23980, max id=67382
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: xx.xxx.xxx.xxx:xxxx
World server listening on: xx.xxx.xxx.xxx:xxxx
Connected to LoginServer: eqlogin1.eqemulator.net:5997
-------------------EOF-----------------------------------------------------
I've gone into my database and tried to rebuild the table for 'items' with no luck. No matter what I do, even dropping the item table from the database, along with the item dump table... I still get that error.
Even though I get these errors, people can login to my server with about 90% stability over 5 hours, and I have somewhat interactable and casting npcs with working doors and weather cycles.
My only question is, how is 0.5.0 DR4 meant to interact with the new database structure for the items table / dump table? Blindly editing the code is teadious and almost makes it impossible to get things exactly stable. There are servers up that have made the item tables work, so it must be a simple fix somewhere.