Some stuff that should be in the database:
CHARACTER_TBL
Code:
db 'CREATE view seghope as select a.m_idPlayer, a.m_Inventory, a.m_apIndex, a.m_dwObjIndex, b.m_extInventory, b.m_InventoryPiercing, c.m_Bank, c.m_apIndex_Bank, c.m_dwObjIndex_Bank, d.m_extBank, d.m_BankPiercing, e.playerslot from INVENTORY_TBL a(nolock), INVENTORY_EXT_TBL b(nolock), BANK_TBL c(nolock), BANK_EXT_TBL d(nolock), CHARACTER_TBL e(nolock) where a.serverindex = b.serverindex and b.serverindex = c.serverindex and c.serverindex = d.serverindex and d.serverindex = e.serverindex and e.serverindex = ',27h,'%02d',27h,' and a.m_idPlayer = b.m_idPlayer and b.m_idPlayer = c.m_idPlayer and c.m_idPlayer = d.m_idPlayer and d.m_idPlayer = e.m_idPlayer',0
Code:
db 'UPDATE CHARACTER_TBL SET m_dwGold = m_dwGold + %d where m_idPlayer = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
ITEM_SEND_TBL
Code:
db 'insert ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, End_Time, m_bItemResist, m_nResistAbilityOption, m_bCharged) VALUES (',27h,'%06d',27h,',',27h,'%02d',27h,',',27h,'%d',27h,',%d,%d,NULL,%d,%d,1)',0
INVENTORY_TBL
Code:
db 'CREATE view seghope as select a.m_idPlayer, a.serverindex, a.m_Inventory, a.m_apIndex, a.m_dwObjIndex, a.m_adwEquipment, b.m_extInventory, b.m_InventoryPiercing from INVENTORY_TBL a, INVENTORY_EXT_TBL b where a.m_idPlayer = b.m_idPlayer and a.serverindex = b.serverindex and a.serverindex = ',27h,'%02d',27h,0
Code:
db 'UPDATE INVENTORY_TBL SET m_Inventory = ',27h,'%s',27h,', m_apIndex = ',27h,'%s',27h,', m_dwObjIndex = ',27h,'%s',27h,' where m_idPlayer = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
INVENTORY_EXT_TBL
Code:
db 'UPDATE INVENTORY_EXT_TBL SET m_extInventory = ',27h,'%s',27h,', m_InventoryPiercing = ',27h,'%s',27h,' where m_idPlayer = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
GUILD_BANK_EXT_TBL
Code:
db 'UPDATE GUILD_BANK_EXT_TBL SET m_extGuildBank = ',27h,'%s',27h,', m_GuildBankPiercing = ',27h,'%s',27h,' where m_idGuild = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
GUILD_BANK_TBL
Code:
db 'UPDATE GUILD_BANK_TBL SET m_GuildBank = ',27h,'%s',27h,' where m_idGuild = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
Code:
db 'UPDATE GUILD_TBL SET m_nGuildGold = m_nGuildGold + %d where m_idGuild = ',27h,'%06d',27h,' and serverindex = ',27h,'%02d',27h,0
I'll post more when i'm back
Some of them could be a procedure too