EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   ios there someway to fix up my db with mysql or smth ? (https://www.eqemulator.org/forums/showthread.php?t=23685)

daryl 09-24-2007 07:14 PM

ios there someway to fix up my db with mysql or smth ?
 
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 09-25-2007 06:19 AM

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

csb4623 10-19-2010 10:35 AM

What Where the updated columns in the items table?


All times are GMT -4. The time now is 06:48 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.