PDA

View Full Version : Either a problem with the latest dumped items, or the code


Elkay
11-06-2004, 05:20 PM
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.