ios there someway to fix up my db with mysql or smth ?

[daryl]

high all :D
am trying to get my old npc and items db working with 0.7.0 but when i check the sql files theres stuff in the tables missing does anyone know a way to add the missing stuff to my old sql files with mysql or some other way, am noobish at mysql and dont know much lol check below for difference with the old npc_types table and the new quite a lot missing :(


(`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `gender`, `texture`, `helmtexture`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `npc_spells_id`, `npc_faction_id`, `mindmg`, `maxdmg`, `npcspecialattks`, `banish`, `aggroradius`, `social`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_beardcolor`, `fixedz`, `d_meele_texture1`, `d_meele_texture2`, `walkspeed`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `ipc`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`)


(`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `gender`, `texture`, `helmtexture`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `npc_spells_id`, `npc_faction_id`, `mindmg`, `maxdmg`, `npcspecialattks`, `banish`, `aggroradius`, `social`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `fixedz`, `d_meele_texture1`, `d_meele_texture2`, `walkspeed`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `ipc`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`)
wonder if someone can help would be great to get all the old stuff working with latest eqemu :D

[daryl]

thanks for the help :D i figured how to do it manually /yawn my db be sorted sometime next few years lol :D

[csb4623]

What Where the updated columns in the items table?