How Create/Edit a item pre5/11 Velious Beta1

[Emuman2098]

Well i noticed that the zone.exe seems to load the items from the "Serialized" Column in the database, not the way it used to, i have created a lits of the items in the serialized column and in what order they fall.

For example:

0|Shroud of Longevity|Shroud of Longevity|IT63|1137|1|255|0|2|131072|1|1126|1|1|0| 0|10|10|10|10|10|15|20|15|0|0|0|0|100|0|20|0|0|0|0 |0|0|0|1|-1|0|0|0|0|0|0|0|0|0|0|0|1973790|64|4097|0|-1|10|16|4.000000|0|-1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|7|0|0 |0|0|0|0|0|0|0|0|0|0|0||0|0|1|0|0|0|0|0|0|0|0|15|0 |0|0|0|-1|0|0|-1|0|0|0|0|0|0|0|20|-1|0|0|0|-1|0|0|0|-1|0|0|0|-1|0|0|0|-1|0|0|0

Is the serialized version of the Shroud of Longevity, i have found that the data goes in this order.

itemclass,name,lore,idfile,id,weight,norent,nodrop ,size,slots,price,icon,unk012,unk013,unk054,unk059 ,unk061,loreflag,pendingloreflag,artifactflag,summ onedflag,Favor,FVNoDrop,GuildFavor,PointType,Unk11 7,Unk118,Unk121,Unk124,BenefitFlag,Tradeskills,CR, DR,PR,MR,FR,AStr,ASta,AAgi,ADex,ACha,AInt,AWis,HP, Mana,AC,Deity,SkillModValue,SkillModType,BaneDmgRa ce,BaneDmgAmt,BaneDmgBody,Magic,CastTime_,ReqLevel ,BardType,BardValue,Light,Delay,RecLevel,RecSkill, ElemDmgType,ElemDmgAmt,Range,Damage,Color,Classes, Races,MaxCharges,ItemType,Material,SellRate,CastTi me,ProcRate,CombatEffects,Shielding,StunResist,Str ikeThrough,ExtraDmgSkill,ExtraDmgAmt,SpellShield,A voidance,Accuracy,CharmFileID,FactionMod1,FactionM od2,FactionMod3,FactionMod4,FactionAmt1,FactionAmt 2,FactionAmt3,FactionAmt4,CharmFile,AugType,AugSlo t1Type,AugSlot2Type,AugSlot3Type,AugSlot4Type,AugS lot5Type,LDoNTheme,LDoNPrice,LDoNSold,BaneDmgRaceA mt,AugRestrict,Endur,DotShielding,Attack,Regen,Man aRegen,Haste,DamageShield,RecastDelay,RecastType,A ugDistiller,Attuneable,NoPet,PotionBelt,StackSize, clickeffect,clicktype,clicklevel,Unk129,proceffect ,proctype,proclevel,unk133,worneffect,worntype,wor nlevel,unk137,focuseffect,focustype,focuslevel,unk 141,scrolleffect,scrolltype,scrolllevel,unk145,bag type,bagslots,bagsize,bagwr,book,booktype

I made a Sql Script that seems to generate a Serialized text version of everything in the Database and I tried to copy/paste it into the database and it won't take it. Try this to generate a serialized text.

SELECT CONCAT_WS('|',itemclass,name,lore,idfile,id,weight ,norent,nodrop,size,slots,price,icon,unk012,unk013 ,unk054,unk059,unk061,loreflag,pendingloreflag,art ifactflag,summonedflag,Favor,FVNoDrop,GuildFavor,P ointType,Unk117,Unk118,Unk121,Unk124,BenefitFlag,T radeskills,CR,DR,PR,MR,FR,AStr,ASta,AAgi,ADex,ACha ,AInt,AWis,HP,Mana,AC,Deity,SkillModValue,SkillMod Type,BaneDmgRace,BaneDmgAmt,BaneDmgBody,Magic,Cast Time_,ReqLevel,BardType,BardValue,Light,Delay,RecL evel,RecSkill,ElemDmgType,ElemDmgAmt,Range,Damage, Color,Classes,Races,MaxCharges,ItemType,Material,S ellRate,CastTime,ProcRate,CombatEffects,Shielding, StunResist,StrikeThrough,ExtraDmgSkill,ExtraDmgAmt ,SpellShield,Avoidance,Accuracy,CharmFileID,Factio nMod1,FactionMod2,FactionMod3,FactionMod4,FactionA mt1,FactionAmt2,FactionAmt3,FactionAmt4,CharmFile, AugType,AugSlot1Type,AugSlot2Type,AugSlot3Type,Aug Slot4Type,AugSlot5Type,LDoNTheme,LDoNPrice,LDoNSol d,BaneDmgRaceAmt,AugRestrict,Endur,DotShielding,At tack,Regen,ManaRegen,Haste,DamageShield,RecastDela y,RecastType,AugDistiller,Attuneable,NoPet,PotionB elt,StackSize,clickeffect,clicktype,clicklevel,Unk 129,proceffect,proctype,proclevel,unk133,worneffec t,worntype,wornlevel,unk137,focuseffect,focustype, focuslevel,unk141,scrolleffect,scrolltype,scrollle vel,unk145,bagtype,bagslots,bagsize,bagwr,book,boo ktype)
FROM items;

Maybe someone knows why the Database won't accept this text, maybe you have to manually enter it, i tried to change the properties of the Serialized column, but it made the serialized column only accept the number "0" and nothing else, not sure what i did.

***Edit***
For some reason in some of my quotes random spaces were added, so if you try to copy/paste be aware of that.
***Edit #2***
I have made a SQL script i run on my database to create serialized data that seems to make all the item changes take effect, you must run it after every set of changes you make to the items table though =/

UPDATE items SET serialization = 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);

Isuggest making a backup of your database before running this as i cannot guarantee it working with your specific database, I ran it on mine and every item change i made seems to be present, use this at your own risk.