Experienced Elementalist
- Joined
- Oct 9, 2012
- Messages
- 226
- Reaction score
- 76
Ty for share. Can you share a 4.6 DB?
I don't have a clean 4.6 DB and i don't know how far he is with updating exisiting ones to EP 4.6 so you probably have to wait or do it on your own... sorry
Oh okey. Then is there any alternative database you can suggest ?
============================
- Item Event Check
[Edit Account DB]
ti_ItemEvent (+2 Fields for GiveItemAtTime as datetime, ChannelingType as int)
[Edit Produce]
atum_GetEventItemList (+1 Select for CheckWithCharacterUID)
atum_insert_Log_ItemEvent (+1 Fields for CheckWithCharacterUID)
atum_update_Log_ItemEvent_fixed_period (+1 Fields for CheckWithCharacterUID)
atum_Load_ItemEvent (+2 GiveItemAtTime, ChannelingType)
=====================
- Combat Power
[Create DB]
atum_log_combatpower ([Time] as datetime ,[TotalANI] as int ,[TotalBCU] as int)
[Create Produce]
atum_Insert_CombatPowerLog (@time as vachar 30,@ani as int,@bcu as int) insert to atum_log_combatpower
==================
- Change Inf Count *Produce that might be already have, but require
[Create DB]
atum_NumberOfChangeInfl (AccountUniqueNumber as int ,NumberOfChangeInfl as tinyint)
[Create Produce]
atum_GetNumberOfChangeInfl (Select [USER=420555]Aid[/USER] as int, select NumberOfChangeInfl where [USER=420555]Aid[/USER], if empty return 0)
atum_SetNumberOfChangeInfl (2 param [USER=420555]Aid[/USER] int [USER=138004]count[/USER] as tinyint. if exist use update instend of insert, )
=========================
- Happy Hour extend
[Edit Account DB]
ti_HappyHourEvent (+8 field as float HPRecoveryRate, SHDRecoveryRate, SPRecoveryRate, WeaponEnchantRate, ArmorEnchantRate, ETCItemEnchantRate, SPIDiscountRate, WPDiscountRate)
* dont forget edit produce select for +8 fields
=========================
SP Level Log
[Edit 1 DB]
atum_log_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel)
[Edit Produce]
atum_log_Insert_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel)
[Add Produce]
atum_Get_Summon_SPLevel (1 param for @LogType as tinyint / select top one from 2 fields for BCUNextSPLevel, ANINextSPLevel where param->logtype order by SPWarEndTime desc)
===========================
Armor Event
[Edit Account DB]
td_MonthlyArmorEvent (+1 Field int for Duration)
[Edit 1 DB]
td_Collection (+2 Fields for MAEOptionItemNum as int , MAEDurationTime as datetime)
atum_GetCollectionList (+2 select MAEOptionItemNum, MAEDurationTime)
atum_UpdateCollectionInfo (+2 update MAEOptionItemNum as int, MAEDurationTime as datetime *also add update line)
atum_GetMonthlyArmorEventByServer (+1 Select for Duration)
=========================
Tradecenter & Destroy Auction
[Require Produce]
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetItemList
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetAuctionItem
atum_DestroyAuction_UpdateBiddingInfo
atum_DestroyAuction_GetBiddingInfo
atum_DestroyAuction_SetClearDestroyAuction
atum_DestroyAuction_InsertDestroyAuctionListup
atum_DestroyAuction_Get_LogData_byItem
atum_DestroyAuction_Get_LogData_byCondition
atum_Market_Insert_ItemRegist
atum_Market_Get_Enchant_Info
atum_Market_Get_td_Enchant
atum_Market_BuyTradeItem
atum_Market_GetTradeItem
atum_Market_Get_SaleList
atum_Market_Get_MarketList
atum_Market_RemoveInfo
atum_Market_Get_LogData
=========================
Additional Produce that not much important (check source if want to upgrade, it have some sql line there)
atum_GetCashBuyDateByAccountExtUID
atum_InsertCashBuyDate
atum_InsertFirstPurchaseFromXMLRPC
atum_GetFirstPurchaseFromXMLRPC
atum_GetCombatPowerFromTOOL
Where should i apply this code ?maybe you can waiting for relase db, or upgrade from ep4.3there not much thing different.
PHP:============================ - Item Event Check [Edit Account DB] ti_ItemEvent (+2 Fields for GiveItemAtTime as datetime, ChannelingType as int) [Edit Produce] atum_GetEventItemList (+1 Select for CheckWithCharacterUID) atum_insert_Log_ItemEvent (+1 Fields for CheckWithCharacterUID) atum_update_Log_ItemEvent_fixed_period (+1 Fields for CheckWithCharacterUID) atum_Load_ItemEvent (+2 GiveItemAtTime, ChannelingType) ===================== - Combat Power [Create DB] atum_log_combatpower ([Time] as datetime ,[TotalANI] as int ,[TotalBCU] as int) [Create Produce] atum_Insert_CombatPowerLog (@time as vachar 30,@ani as int,@bcu as int) insert to atum_log_combatpower ================== - Change Inf Count *Produce that might be already have, but require [Create DB] atum_NumberOfChangeInfl (AccountUniqueNumber as int ,NumberOfChangeInfl as tinyint) [Create Produce] atum_GetNumberOfChangeInfl (Select [USER=420555]Aid[/USER] as int, select NumberOfChangeInfl where [USER=420555]Aid[/USER], if empty return 0) atum_SetNumberOfChangeInfl (2 param [USER=420555]Aid[/USER] int [USER=138004]count[/USER] as tinyint. if exist use update instend of insert, ) ========================= - Happy Hour extend [Edit Account DB] ti_HappyHourEvent (+8 field as float HPRecoveryRate, SHDRecoveryRate, SPRecoveryRate, WeaponEnchantRate, ArmorEnchantRate, ETCItemEnchantRate, SPIDiscountRate, WPDiscountRate) * dont forget edit produce select for +8 fields ========================= SP Level Log [Edit 1 DB] atum_log_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel) [Edit Produce] atum_log_Insert_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel) [Add Produce] atum_Get_Summon_SPLevel (1 param for @LogType as tinyint / select top one from 2 fields for BCUNextSPLevel, ANINextSPLevel where param->logtype order by SPWarEndTime desc) =========================== Armor Event [Edit Account DB] td_MonthlyArmorEvent (+1 Field int for Duration) [Edit 1 DB] td_Collection (+2 Fields for MAEOptionItemNum as int , MAEDurationTime as datetime) atum_GetCollectionList (+2 select MAEOptionItemNum, MAEDurationTime) atum_UpdateCollectionInfo (+2 update MAEOptionItemNum as int, MAEDurationTime as datetime *also add update line) atum_GetMonthlyArmorEventByServer (+1 Select for Duration) ========================= Tradecenter & Destroy Auction [Require Produce] atum_DestroyAuction_AddItem atum_DestroyAuction_GetItemList atum_DestroyAuction_AddItem atum_DestroyAuction_GetAuctionItem atum_DestroyAuction_UpdateBiddingInfo atum_DestroyAuction_GetBiddingInfo atum_DestroyAuction_SetClearDestroyAuction atum_DestroyAuction_InsertDestroyAuctionListup atum_DestroyAuction_Get_LogData_byItem atum_DestroyAuction_Get_LogData_byCondition atum_Market_Insert_ItemRegist atum_Market_Get_Enchant_Info atum_Market_Get_td_Enchant atum_Market_BuyTradeItem atum_Market_GetTradeItem atum_Market_Get_SaleList atum_Market_Get_MarketList atum_Market_RemoveInfo atum_Market_Get_LogData ========================= Additional Produce that not much important (check source if want to upgrade, it have some sql line there) atum_GetCashBuyDateByAccountExtUID atum_InsertCashBuyDate atum_InsertFirstPurchaseFromXMLRPC atum_GetFirstPurchaseFromXMLRPC atum_GetCombatPowerFromTOOL
the code is not done.It is only giving you the clues where you have to add or edit and what procedures are missing so that everything can work.Where should i apply this code ?
You can use anywhich client can use?
You can use any
You can't fix a simple mistake xDDbut,server side crash ,like :
08-01 01:01:27.286|Socket Closed SocketIndex[ 3] SocketType[7] PeerIP[ 192.168.1.200] Port[26634] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
08-01 01:01:48.382|[ERROR] CIOCP::Worker() IOCPSocket End 3 error[64] Overlapped[45687668] Overlapped Type[2], ThreadID[17940]
08-01 01:01:48.382|Socket Closed SocketIndex[ 1] SocketType[5] PeerIP[ 192.168.1.200] Port[26495] MaxWriteBufCounts[ 1] ==> reason 5[0X000005]
08-01 01:01:48.383| Closed FieldServer( 192.168.1.200:26495), ServerGroupName( Test46)
You can't fix a simple mistake xDD
I ask myself the following question.
Could you add everything missing in the DB?
So you try to enter it will give you errors for not having everything you need in the DB