Newbie Spellweaver
- Joined
- Feb 2, 2015
- Messages
- 77
- Reaction score
- 53
some SQL produce that was named about PRODUCE_080827 / PROCEDURE_121121_0001
it might be hard if you want to modify that. but some time you dont understand what that produce do.
category
- atum_tool produce that query from tool like monitor
- atum_dbeditor product that query from admin tool (or maybe it just swap with tool. not sure)
- etc product that query from server core
List (StringDefineProcedure.h)
it might be hard if you want to modify that. but some time you dont understand what that produce do.
category
- atum_tool produce that query from tool like monitor
- atum_dbeditor product that query from admin tool (or maybe it just swap with tool. not sure)
- etc product that query from server core
List (StringDefineProcedure.h)
Code:
PROCEDURE_080827_0001 atum_tool_LoadAccountInfo
PROCEDURE_080827_0002 atum_tool_UpdateAccountInfo
PROCEDURE_080827_0003 atum_tool_LoadBlockAccountList
PROCEDURE_080827_0004 atum_tool_UpdateInflLeaderCharacter
PROCEDURE_080827_0005 atum_tool_UpdateInflSub1LeaderCharacter
PROCEDURE_080827_0006 atum_tool_UpdateInflSub2LeaderCharacter
PROCEDURE_080827_0007 atum_tool_LoadInfWarData
PROCEDURE_080827_0008 atum_tool_InitInfWarData
PROCEDURE_080827_0009 atum_tool_InitGuildMonthFame
PROCEDURE_080827_0010 atum_tool_SearchLogTable
PROCEDURE_080827_0014 atum_tool_LoadAccountCashStore
PROCEDURE_080827_0015 atum_tool_InsertAccountCashStore
PROCEDURE_080827_0017 atum_tool_GetGuildInfo
PROCEDURE_080827_0019 atum_tool_GetGuildMemberInfo
PROCEDURE_080827_0020 atum_tool_GetGuildItemInfo
PROCEDURE_080827_0021 atum_tool_GetGuildItemInfo_Enchant
PROCEDURE_080827_0022 atum_tool_SearchGuildName
PROCEDURE_080827_0023 atum_tool_UpdateGuildInfo
PROCEDURE_080827_0024 atum_tool_UpdateGuildInfo_Character
PROCEDURE_080827_0025 atum_tool_LoadHappyHour
PROCEDURE_080827_0026 atum_tool_InsertHappyHour
PROCEDURE_080827_0027 atum_tool_UpdateHappyHour
PROCEDURE_080827_0028 atum_tool_UpdateHappyHour_Period
PROCEDURE_080827_0029 atum_tool_LoadItemEvent
PROCEDURE_080827_0030 atum_tool_CheckEnbaleInsertCouponEvent
PROCEDURE_080827_0031 atum_tool_GetAccountBlockState
PROCEDURE_080827_0032 atum_tool_GetItemByItemNum
PROCEDURE_080827_0033 atum_tool_DeleteItemByItemNum
PROCEDURE_080827_0034 atum_tool_DeleteItemByItemNum_Enchant
PROCEDURE_080827_0035 atum_tool_UpdateItemByItemNum
PROCEDURE_080827_0036 atum_tool_UpdateItemByItemNum_Enchant
PROCEDURE_080827_0037 atum_tool_GetAccountInfoByParam
PROCEDURE_080827_0041 atum_tool_GetAccountType
PROCEDURE_080827_0042 atum_tool_GetInfluenceLeaderCharacterInfo
PROCEDURE_080827_0043 atum_tool_GetInfluenceSub1LeaderCharacterInfo
PROCEDURE_080827_0044 atum_tool_GetInfluenceSub2LeaderCharacterInfo
PROCEDURE_080827_0045 atum_tool_GetStoreWithItemInfo
PROCEDURE_080827_0046 atum_tool_GetEnchantByItemUID
PROCEDURE_080827_0047 atum_tool_GetCharacterByName
PROCEDURE_080827_0048 atum_tool_UpdateCharacterInfo
PROCEDURE_080827_0049 atum_tool_CheckItemIsExist
PROCEDURE_080827_0050 atum_tool_GetFindLogTable
PROCEDURE_080827_0051 atum_tool_InsertEventMonster
PROCEDURE_080827_0052 atum_tool_UpdateEventMonster
PROCEDURE_080827_0053 atum_tool_DeleteEventMonster
PROCEDURE_080827_0054 atum_tool_GetGuildInfoByMaskState
PROCEDURE_080827_0055 atum_tool_UpdateGuildMaskState
PROCEDURE_080827_0056 atum_Load_ti_ItemInfo
PROCEDURE_080827_0057 atum_Load_ti_EnchantInfo
PROCEDURE_080827_0058 atum_Load_ti_ItemMixingInfo
PROCEDURE_080827_0059 atum_Load_ti_RareItemInfo
PROCEDURE_080827_0060 atum_Load_ti_MapObject
PROCEDURE_080827_0061 atum_Load_ti_BuildingNPC
PROCEDURE_080827_0062 atum_Load_ti_Monster_Server
PROCEDURE_080827_0063 atum_Load_ti_Monster_Client
PROCEDURE_080827_0064 atum_Load_ti_MapInfo
PROCEDURE_080827_0065 atum_Outdate_Load_PcMemBranch
PROCEDURE_080827_0066 atum_DeletePCbang
PROCEDURE_080827_0067 atum_InsertPCbang
PROCEDURE_080827_0068 atum_LoadInfluenceLeader
PROCEDURE_080827_0069 atum_LoadInfluenceSub1Leader
PROCEDURE_080827_0070 atum_LoadInfluenceSub2Leader
PROCEDURE_080827_0071 atum_LoadEachInflueceTypeCount
PROCEDURE_080827_0072 atum_LoadInfluenceWarInfo
PROCEDURE_080827_0073 atum_LoadEventMonster
PROCEDURE_080827_0074 atum_AuthAdminToolUser
PROCEDURE_080827_0075 atum_LoadInfluenceWarData
PROCEDURE_080827_0076 atum_InsertInfluenceWarData
PROCEDURE_080827_0077 atum_CheckGuildCommander
PROCEDURE_080827_0078 atum_CheckGuildCommanderAndGetMemberCapacity
PROCEDURE_080827_0079 atum_OutdateGetGuildInfoByUID
PROCEDURE_080827_0080 atum_GetGuildMemberByUID
PROCEDURE_080827_0081 atum_GetGuildCommanderUID
PROCEDURE_080827_0082 atum_GetLeaderGuildUID
PROCEDURE_080827_0083 atum_CheckGuildStateDisMemberReady
PROCEDURE_080827_0084 atum_GetGuildCommanderName
PROCEDURE_080827_0087 atum_InitConnectingServerGroupID
PROCEDURE_080827_0120 atum_CheckPasswordAndRace
PROCEDURE_080827_0122 atum_dbeditor_run_exec
PROCEDURE_080827_0125 atum_dbeditor_GetPlayerPlayTimeInfo
PROCEDURE_080827_0129 atum_dbeditor_GetPCbangInfo
PROCEDURE_080827_0133 atum_dbeditor_GetPCbangPlayTimeByEachDay
PROCEDURE_080827_0134 atum_dbeditor_GetCharacterListLimitRow
PROCEDURE_080827_0135 atum_dbeditor_GetRegisterDate
PROCEDURE_080827_0136 atum_dbeditor_GetCountRegisterDateSameDay
PROCEDURE_080827_0137 atum_dbeditor_GetUnRegAccount
PROCEDURE_080827_0138 atum_dbeditor_GetCountBirthDay
PROCEDURE_080827_0141 atum_dbeditor_GetCountClientInLogServerMap
PROCEDURE_080827_0142 atum_dbeditor_GetLastAccountUID
PROCEDURE_080827_0143 atum_dbeditor_GetCountAllAccountNum
PROCEDURE_080827_0144 atum_dbeditor_GetCountAllDeleteAccount
PROCEDURE_080827_0145 atum_dbeditor_GetCountExpectAccount
PROCEDURE_080827_0155 atum_dbeditor_GetCountUserTimeLineByHour
PROCEDURE_080827_0160 atum_dbeditor_GetCountUserTimeLineByDate
PROCEDURE_080827_0165 atum_dbeditor_GetCountUserTimeLineByDateHour
PROCEDURE_080827_0168 atum_dbeditor_GetLevelRanking
PROCEDURE_080827_0171 atum_dbeditor_GetLevelRanking2
PROCEDURE_080827_0175 atum_dbeditor_GetLevelRankingOrderByLevelAsc
PROCEDURE_080827_0178 atum_dbeditor_GetLevelRankingOrderByLevelDesc
PROCEDURE_080827_0180 atum_dbeditor_GetLogItemBuySell
PROCEDURE_080827_0183 atum_dbeditor_GetCharacterInfoList
PROCEDURE_080827_0186 atum_dbeditor_GetCharacterInfoList2
PROCEDURE_080827_0187 atum_dbeditor_GetCountableItemTotalCount
PROCEDURE_080827_0188 atum_dbeditor_OutdateCountItemNum
PROCEDURE_080827_0195 atum_dbeditor_GetCountMoneyItemTableFromCharacter
PROCEDURE_080827_0198 atum_dbeditor_GetCharacterInfoListLimitCount
PROCEDURE_080827_0199 atum_dbeditor_GetSumCountOfItem
PROCEDURE_080827_0200 atum_dbeditor_GetCharacterInfoListWithPK
PROCEDURE_080827_0201 atum_dbeditor_DropTempViewTable
PROCEDURE_080827_0202 atum_dbeditor_Exec
PROCEDURE_080827_0203 atum_dbeditor_GetDateFromTempView
PROCEDURE_080827_0204 atum_dbeditor_DropTempViewTable2
PROCEDURE_080827_0205 atum_dbeditor_Exec2
PROCEDURE_080827_0206 atum_dbeditor_GetDateFromTempView2
PROCEDURE_080827_0207 atum_dbeditor_DropTempViewTable3
PROCEDURE_080827_0208 atum_dbeditor_Exec3
PROCEDURE_080827_0209 atum_dbeditor_GetDateFromTempView3
PROCEDURE_080827_0210 atum_dbeditor_DropTempViewTable4
PROCEDURE_080827_0211 atum_dbeditor_Exec4
PROCEDURE_080827_0212 atum_dbeditor_GetDateFromTempView4
PROCEDURE_080827_0213 atum_dbeditor_DropTempViewTable5
PROCEDURE_080827_0214 atum_dbeditor_Exec5
PROCEDURE_080827_0215 atum_dbeditor_GetDateFromTempViewByLogType
PROCEDURE_080827_0216 atum_dbeditor_GetCharacterQuest
PROCEDURE_080827_0217 atum_dbeditor_GetCharacterQuest2
PROCEDURE_080827_0218 atum_dbeditor_DropTempViewTable6
PROCEDURE_080827_0219 atum_dbeditor_Exec6
PROCEDURE_080827_0220 atum_dbeditor_GetBossKillerInfo
PROCEDURE_080827_0221 atum_dbeditor_GetCharacterDataByName
PROCEDURE_080827_0222 atum_dbeditor_GetGuildMemberList
PROCEDURE_080827_0223 atum_dbeditor_GetCharaterList
PROCEDURE_080827_0224 atum_dbeditor_DropTmUserConnection
PROCEDURE_080827_0225 atum_dbeditor_Exec7
PROCEDURE_080827_0226 atum_dbeditor_GetSelectInfMaskGroupByMask
PROCEDURE_080827_0227 atum_dbeditor_DropTmUserConnection2
PROCEDURE_080827_0228 atum_dbeditor_Exec8
PROCEDURE_080827_0229 atum_dbeditor_GetConnectedDate
PROCEDURE_080827_0236 atum_dbeditor_GetAccountWithPassword
PROCEDURE_080827_0237 atum_dbeditor_BackupAccount
PROCEDURE_080827_0238 atum_dbeditor_UpdateAccountPassword
PROCEDURE_080827_0239 atum_dbeditor_UndoUpdateAccountPassword
PROCEDURE_080827_0240 atum_dbeditor_DeleteBackupAccount
PROCEDURE_080827_0241 atum_dbeditor_InsertBlockAccount
PROCEDURE_080827_0242 atum_dbeditor_DeleteBlockAccount
PROCEDURE_080827_0243 atum_dbeditor_LoadBlockAccount
PROCEDURE_080827_0244 atum_Load_ti_MapObject_MapWorkSpace
PROCEDURE_080827_0246 atum_Load_ti_ItemInfo_FieldServer
PROCEDURE_080827_0247 atum_LoadMonsterItemList
PROCEDURE_080827_0248 atum_Load_ti_CityTargetWarpMap
PROCEDURE_080827_0249 atum_AuthLogin
PROCEDURE_080827_0250 atum_CheckGuildNameisExist
PROCEDURE_080827_0251 atum_CheckGuildLeaderValid
PROCEDURE_080827_0252 atum_CheckGuildDismember
PROCEDURE_080827_0253 atum_CheckGuildNameCanChange
PROCEDURE_080827_0254 atum_UpdateGuildNameChange
PROCEDURE_080827_0255 atum_CheckFriendNameCharacter
PROCEDURE_080827_0256 atum_GetFriendList
PROCEDURE_080827_0257 atum_Load_ti_ItemInfo_NPCServer
PROCEDURE_080827_0258 atum_CheckIsExistAccount
PROCEDURE_080827_0259 atum_tool_DeleteAccountCashStore
PROCEDURE_080827_0260 atum_tool_UpdateAccountCashStore
PROCEDURE_080827_0261 atum_tool_DeleteHappyHourEvent
PROCEDURE_080827_0262 atum_tool_OutdateInsertHappyHourEvent
PROCEDURE_080827_0263 atum_tool_OutdateUpdateHappyHourEvent
PROCEDURE_080827_0264 atum_tool_InsertHappyHourEvent
PROCEDURE_080827_0265 atum_tool_UpdateHappyHourEvent
PROCEDURE_080827_0266 atum_tool_InsertItemEvent
PROCEDURE_080827_0267 atum_tool_DelteItemEvent
PROCEDURE_080827_0268 atum_tool_UpdateItemEvent
PROCEDURE_080827_0269 atum_tool_OutpostUpdateInfo
PROCEDURE_121121_0001 atum_tool_DeleteEnchant
Last edited:
