high all
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