[Info] SQL Produce translate PROCEDURE_080827

[Info] SQL Produce translate PROCEDURE_080827_XXX (for newbie)

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)

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

Re: [Info] SQL Produce translate PROCEDURE_080827_XXX (for newbie)

Don't forget to check all procedure bodies as well since masang tends to call those from other procedures as well.

Re: [Info] SQL Produce translate PROCEDURE_080827_XXX (for newbie)

Quote:

Originally Posted by St34lth4ng3l

Don't forget to check all procedure bodies as well since masang tends to call those from other procedures as well.

yeah your right haha
* i decide to just make a produce sheet. for avoid newbie get error from that