Serialization
I was having trouble with emumans serialization script, apparently the columns are serialized different with the db i use. I'm using cavedude's db and this serialization script works great for me.
SELECT CONCAT_WS('|',itemclass,name,lore,idfile,id,weight ,norent,nodrop,size,slots,price,icon,UNK012,UNK013 ,benefitflag,tradeskills,cr,dr,pr,mr,fr,astr,asta, aagi,adex,acha,aint,awis,hp,mana,ac,deity,UNK033,s killmodvalue,skillmodtype,banedmgrace,banedmgamt,b anedmgbody,magic,casttime_,reqlevel,bardtype,bardv alue,light,delay,reclevel,recskill,elemdmgtype,ele mdmgamt,range,damage,color,classes,races,UNK054,ma xcharges,itemtype,material,sellrate,UNK059,casttim e,UNK061,procrate,combateffects,shielding,stunresi st,strikethrough,extradmgskill,extradmgamt,spellsh ield,avoidance,accuracy,charmfileid,factionmod1,fa ctionmod2,factionmod3,factionmod4,factionamt1,fact ionamt2,factionamt3,factionamt4,charmfile,augtype, augslot1type,augslot2type,augslot3type,augslot4typ e,augslot5type,ldontheme,ldonprice,ldonsold,bagtyp e,bagslots,bagsize,bagwr,book,booktype,filename,ba nedmgraceamt,augrestrict,loreflag,pendingloreflag, artifactflag,summonedflag,favor,fvnodrop,endur,dot shielding,attack,regen,manaregen,haste,damageshiel d,recastdelay,recasttype,guildfavor,augdistiller,U NK117,UNK118,attuneable,nopet,UNK121,pointtype,pot ionbelt,UNK124,stacksize,clickeffect,clicktype,cli cklevel,UNK129,proceffect,proctype,proclevel,UNK13 3,worneffect,worntype,wornlevel,UNK137,focuseffect ,focustype,focuslevel,UNK141,scrolleffect,scrollty pe,scrolllevel,UNK145,verified)
FROM items;
Assuming you're using mysqlfront,every time you make changes you run that script. A list containing every item's serialization will show up, just use the find feature and copy the serialized data into the serialization column of the item you edited. Click teh check mark in the top right corner and restart your server. All the changes should take effect.
If the script messes up the item, our db's must be different, so always make a backup before you mess around.
|
Hybrid Mode
