[vales]

The thing is that if I add one, another error pops up. If I source it using the loaditems.pl I get no errors, however, when I start up thge EMU, I get the items errors all over again in the server window. It's quite baffling.

You might be right on that one. I think there was a communication breakdown somewhere. :p Was working fine before the September 20th update. I still don't have any answer or clue on which one I should be using to source with though. This is from the 13th floor forum:

ALTER TABLE items CHANGE UNK061 UNK060 int not null;
ALTER TABLE items CHANGE UNK123 UNK122 int not null;
ALTER TABLE items CHANGE UNK124 UNK123 int not null;
ALTER TABLE items CHANGE UNK127 UNK126 int not null;
ALTER TABLE items CHANGE UNK134 UNK138 varchar(255) not null default "";

ALTER TABLE items ADD UNK132 int not null AFTER notransfer;
ALTER TABLE items ADD UNK133 int not null AFTER UNK132;
ALTER TABLE items ADD UNK134 int not null AFTER UNK133;
ALTER TABLE items ADD UNK135 int not null AFTER UNK134;
ALTER TABLE items ADD UNK136 int not null AFTER UNK135;
ALTER TABLE items ADD UNK137 varchar(255) not null default "" AFTER UNK136;

ALTER TABLE items ADD svcorruption int not null AFTER scrolllevel;
ALTER TABLE items ADD UNK160 int not null AFTER svcorruption;
ALTER TABLE items ADD UNK161 int not null AFTER UNK160;

So you might want to check it if you're updating items.

Starting all over again, I sourced in the items table, then added the above code. Then I used loaditems.pl and got no errors of course, but got this when I started up the EMU.

[09.23. - 14:19:00] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,updated from items order by id', #1054: Unknown column 'UNK061' in 'field list'
[09.23. - 14:19:00] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql