EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Bug Reports (https://www.eqemulator.org/forums/forumdisplay.php?f=591)
-   -   Either a problem with the latest dumped items, or the code (https://www.eqemulator.org/forums/showthread.php?t=16838)

Elkay 11-06-2004 05:20 PM

Either a problem with the latest dumped items, or the code
 
Not sure which one is right and which one is wrong, but the latest item dump SQL file creates an item table not compatible with the latest CVS. Error on launching World:

[Status] Loading items from database: count=20375
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,SpellCharges,itemcl ass,name,lore,idfile,id,weight
,norent,nodrop,attuneable,size,slots,cost,icon,unk nown018,unknown019,unknown020,
tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,ach a,aint,awis,hp,mana,ac,deity,s
killmodvalue,skillmodtype,banedmgrace,banedmgamt,b anedmgbody,magic,casttime2,has
teproclvl,reqlevel,bardtype,bardvalue,light,delay, reclevel,recskill,elemdmgtype,
elemdmgamt,effecttype,range,damage,color,classes,r aces,unknown061,spellid,maxcha
rges,itemtype,material,sellrate,unknown067,casttim e,unknown069,proc_rate_mod,foc
usid,combateffects,shielding,stunresist,strikethro ugh,combatskill,combatskilldmg
,spellshield,avoidance,accuracy,unknown081,faction mod1,factionmod2,factionmod3,f
actionmod4,factionamt1,factionamt2,factionamt3,fac tionamt4,charmfile,augtype,aug
slot1type,augslot2type,augslot3type,augslot4type,a ugslot5type,ldonpointtheme,ldo
npointcost,ldonsold,bagtype,bagslots,bagsize,bagwr ,unknown105,booktype,filename,
banedmgamt2,augmentrestriction,loreflag,pendinglor eflag,artifactflag,summonedfla
g,tribute,gmflag,endur,dotshielding,attackbonus,hp regen,manaregen,hastepercent,d
amageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'unknown002
' in 'field list'
[Error] If you got an error related to the 'SpellCharges' field, run the followi
ng SQL Query: ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11) DE
FAULT "0" NOT NULL;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring


The problem is not unknown008, but rather unknown002.

sotonin 11-06-2004 06:20 PM

Try using the items table from the kunark release. it's compatible with cvs unless they've changed something without our knowledge.

it has 2000 ish new items than any previous item table as well, it's the most complete out.

Edgar1898 11-06-2004 07:20 PM

The items dump has the new field names that we are going to be switching over to soon. This is a large update to the items table that will hit cvs within the new few days (after DM is done playing with it) :) So until we have the new code up to take advantage of the new fields, hold off on downloading the new format.

sotonin 11-06-2004 07:54 PM

You will be releasing a ALTER update for this right?

Edgar1898 11-07-2004 05:22 AM

of course

Elkay 11-07-2004 06:10 AM

Awesome, thanks for the head's up LE.


All times are GMT -4. The time now is 11:19 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.