SERVER MERGE ini file, but what it does not understand such a thing as
I'm getting errors when I added it in the following
like this
[SERVER]
SERVER_MERGE = 1
005D83D4: 'ITEM_NUM2',0
005D83E0: 'PREMIUM_ITEM',0
005D83F0: 'ITEM_NUM1',0
005D83FC: 'SERVER',0
005D8404: 'SERVER_MERGE',0
005D8414: 'ZONE_INFO',0
005D8420: 'GROUP_INFO',0
005D8434: 'SESSION',0
005D8444: 'LOG_PWD',0
005D8450: 'LOG_UID',0
005D845C: 'LOG_DSN',0
005D8468: 'GAME_PWD',0
005D8474: 'GAME_UID',0
005D8480: 'GAME_DSN',0
005D848C: 'ACCOUNT_PWD',0
005D849C: 'ACCOUNT_UID',0
005D84AC: 'ODBC',0
005D84B4: 'ACCOUNT_DSN',0
005D84C4: 'KN_Data',0
005D84D0: 'Knight_Account',0
005D84E4: 'hy27671626',0
005D84F4: 'sknight',0
005D8500: 'KN_Online',0
005D850C: 'NATION',0
005D8514: 'NATION_ID',0
005D8520: '%s\Aujard.ini',0
aujard read this procedures
may be helpful to write the procedure to friends
005DA2AC: '{call LOAD_USER_DATA (',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DA2DC: '{call smg_LOAD_USER_DATA (',27h,'%s',27h,', ',27h,'%s',27h,', %d, ?)}',0
005DA3B0: '{call UPDATE_USER_DATA ( ',27h,'%s',27h,', %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,?,?,?,?, %d,%d)}',0
005DA45C: '{call smg_UPDATE_USER_DATA ( ',27h,'%s',27h,', %d, %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,?,?,?,?, %d,%d)}',0
005DA5A0: '{call ACCOUNT_LOGIN( ',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DA5CC: '{call smg_ACCOUNT_LOGIN( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ?)}',0
005DA614: '{call NATION_SELECT ( ?, ',27h,'%s',27h,', %d)}',0
005DA640: '{call smg_NATION_SELECT ( ?, ',27h,'%s',27h,', %d, %d)}',0
005DA684: '{call CREATE_NEW_CHAR ( ?, ',27h,'%s',27h,', %d, ',27h,'%s',27h,', %d,%d,%d,%d,%d,%d,%d,%d,%d)}',0
005DA6DC: '{call smg_CREATE_NEW_CHAR ( ?, ',27h,'%s',27h,', %d, ',27h,'%s',27h,', %d,%d,%d,%d,%d,%d,%d,%d,%d, %d)}',0
005DA74C: '{ call DELETE_CHAR ( ',27h,'%s',27h,', %d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,', ?, ? )}',0
005DA790: '{ call smg_DELETE_CHAR ( ',27h,'%s',27h,', %d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ?, ? )}',0
005DA808: '{call LOAD_CHAR_INFO (',27h,'%s',27h,', ?)}',0
005DA830: '{call smg_LOAD_CHAR_INFO (',27h,'%s',27h,',%d,?)}',0
005DA88C: '{? = call LOAD_ACCOUNT_CHARID (',27h,'%s',27h,')}',0
005DA8BC: '{ call smg_LOAD_ACCOUNT_CHARID2 (',27h,'%s',27h,', %d, ? )}',0
005DA908: '{call CREATE_KNIGHTS ( ?, %d, %d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,' )}',0
005DA9A4: '{call UPDATE_KNIGHTS ( ?, %d, ',27h,'%s',27h,', %d, %d)}',0
005DA9EC: '{call DELETE_KNIGHTS ( ?, %d )}',0
005DAA30: '{call LOAD_KNIGHTS_MEMBERS ( %d )}',0
005DAA7C: '{call UPDATE_CONCURRENT ( %d,%d,%d,%d, %d,%d,%d,%d,%d, %d,%d)}',0
005DAAF4: 'UPDATE CONCURRENT SET zone3_count = %d WHERE serverid = %d',0
005DAB3C: 'UPDATE CONCURRENT SET zone2_count = %d WHERE serverid = %d',0
005DAB84: 'UPDATE CONCURRENT SET zone1_count = %d WHERE serverid = %d',0
005DAD50: 'SELECT nMoney, dwTime, WarehouseData, strSerial FROM WAREHOUSE WHERE strAccountID = ',27h,'%s',27h,0
005DADBC: 'SELECT nMoney, dwTime, WarehouseData, strSerial FROM WAREHOUSE WHERE strAccountID = ',27h,'%s',27h,' and nServerIndex = %d',0
005DAE5C: 'SELECT nMoney, dwTime, WarehouseData, strSerial, strWarehousePW FROM WAREHOUSE WHERE strAccountID = ',27h,'%s',27h,0
005DAEDC: 'SELECT nMoney, dwTime, WarehouseData, strSerial, strWarehousePW FROM WAREHOUSE WHERE strAccountID = ',27h,'%s',27h,' and nServerIndex=%d',0
005DAF9C: '{call UPDATE_WAREHOUSE ( ',27h,'%s',27h,', %d,%d,?,?)}',0
005DAFD0: '{call smg_UPDATE_WAREHOUSE ( ',27h,'%s',27h,', %d,%d,%d,?,?)}',0
005DB038: '{call UPDATE_WAREHOUSE_PW ( ',27h,'%s',27h,',',27h,'%s',27h,', %d,%d,?,?)}',0
005DB078: '{call smg_UPDATE_WAREHOUSE_PW ( ',27h,'%s',27h,',',27h,'%s',27h,', %d,%d,%d,?,?)}',0
005DB138: 'SELECT IDNum, Nation, IDName, Members, Points FROM KNIGHTS WHERE IDNum=%d',0
005DB1D0: 'SELECT sMarkVersion FROM KNIGHTS WHERE IDNum=%d',0
005DB220: 'UPDATE KNIGHTS SET sMarkVersion = 0 WHERE IDNum=%d',0
005DB2A4: '{call UPDATE_KNIGHTS_MARK ( ?, %d, %d, ?)}',0
005DB2E8: '{call PROC_UPDATE_CURRENTUSER ( ',27h,'%s',27h,', %d, ',27h,'%s',27h,', ?, ?, ?)}',0
005DB330: '{call PROC_INSERT_CURRENTUSER ( ',27h,'%s',27h,',',27h,'%s',27h,',%d,',27h,'%s',27h,',',27h,'%s',27h,', ?)}',0
005DB378: '{call PROC_INSERT_CURRENTUSER ( ',27h,'%s',27h,',',27h,'%s',27h,',%d,',27h,'%s',27h,',',27h,'%s',27h,',%d, ?)}',0
005DB42C: '{call ACCOUNT_LOGOUT( ',27h,'%s',27h,', %d )}',0
005DB4AC: 'SELECT dwTime, [Exp] FROM USERDATA WHERE strUserID=',27h,'%s',27h,' and nServerIndex=%d',0
005DB508: 'SELECT dwTime, nMoney FROM WAREHOUSE WHERE strAccountID=',27h,'%s',27h,' and nServerIndex=%d',0
005DB5AC: 'SELECT a.IDNum, a.Points, b.nRank FROM KNIGHTS as a, KNIGHTS_RATING as b WHERE b.shIndex=a.IDNum and a.Points <> 0 ORDER BY a.Points DESC',0
005DB674: '{call UPDATE_BATTLE_RESULT( ',27h,'%s',27h,', %d, %d )}',0
005DB6BC: '{call CHECK_COUPON_EVENT (',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DB708: '{call UPDATE_COUPON_EVENT (',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d)}',0
005DB760: 'UPDATE ITEMUP_PROBABILITY SET nCurSuccess=%d, nCurFail=%d WHERE bType=%d',0
005DB7E8: 'SELECT byElmoArea FROM BATTLE WHERE sIndex=1',0
005DB834: '{call UPDATE_BATTLE_HERO( ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', %d )}',0
005DB890: 'DELETE FROM HERO_USER',0
005DB8F4: '{call UPDATE_KNIGHTS_WAR( %d, %d, %d )}',0
005DB934: '{call CHECK_PPCARD_EVENT (',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DB978: '{call UPDATE_PPCARD_EVENT( ',27h,'%s',27h,', ',27h,'%s',27h,', %d )}',0
005DB9C8: '{call CREATE_NEWACCOUNT( ',27h,'%s',27h,', %d,%d,%d, ?)}',0
005DBA18: 'UPDATE CURRENTUSER SET nUsedTime = %d WHERE strAccountID = ',27h,'%s',27h,0
005DBA64: 'UPDATE CURRENTUSER SET nValidTime = %d WHERE strAccountID = ',27h,'%s',27h,0
005DBAF4: 'UPDATE CURRENTUSER SET nValidTime = %d, nCardType = %d WHERE strAccountID = ',27h,'%s',27h,0
005DBE3C: '{call LOAD_WEB_ITEMMALL ( ',27h,'%s',27h,' )}',0
005DBE9C: '{ call SHOPPINGMALL_BUY ( ?, ',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d )}',0
005DBF38: '{call UPDATE_KNIGHTS_ALLIANCE( %d, %d, %d, %d, %d )}',0
005DBF90: 'UPDATE KNIGHTS SET Flag = %d, sCape=0 WHERE IDNum = %d',0
005DBFD4: 'UPDATE KNIGHTS SET Flag = %d, sCape=-1 WHERE IDNum = %d',0
005DC028: 'SELECT COUNT(*) FROM CURRENTUSER WHERE strAccountID = ',27h,'%s',27h,0
005DC084: 'INSERT FORBID_USER VALUES(',27h,'%s',27h,',GETDATE(),DATEADD(HH,%d,GETDATE()))',0
005DC118: '{call UPDATE_SIEGE ( %d, %d, %d, %d, %d, %d, %d)}',0
005DC1A4: '{call UPDATE_SIEGE_CHALLENGER2 ( %d, %d,%d,%d,%d,%d, %d,%d,%d,%d,%d, ?)}',0
005DC260: '{call UPDATE_SIEGE_DECIDE_CHALLENGER ( %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)}',0
005DC2C4: '%s : %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d',0
005DC324: '{call LOAD_SAVED_MAGIC ( ',27h,'%s',27h,', ?)}',0
005DC368: '{call UPDATE_SAVED_MAGIC ( ',27h,'%s',27h,', %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d)}',0
005DC3EC: '{call CHANGE_NEW_ID( %d, ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DC424: '{call smg_CHANGE_NEW_ID( %d, ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ?, ?)}',0
005DC484: '{call CHANGE_KNIGHTS_CAPE( %d, %d )}',0
005DC4D4: '{call CHANGE_CASTLE_COMMERCE ( %d, %d, %d, %d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,' )}',0
005DC530: '{call CHECK_GAMEBANG_IP( ',27h,'%s',27h,', ?, ?)}',0
005DC570: 'SELECT * FROM FRIEND_LIST WHERE strUserID = ',27h,'%s',27h,0
005DC5BC: '{call DELETE_FRIEND_LIST( ',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DC5F0: '{call INSERT_FRIEND_LIST( ',27h,'%s',27h,', ',27h,'%s',27h,', ?)}',0
005DC6CC: '{call LOAD_PREMIUM_SERVICE_USER ( ',27h,'%s',27h,', ?, ?)}',0
005DC724: '{call UPDATE_PREMIUM_SERVICE_USER (',27h,'%s',27h,', %d)}',0
005DC774: '{call INSERT_HACKTOOL_USER (',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,')}',0
005DC7FC: '{call MAKE_HOUR_REPORT_NOAH ( %d, ?, ?, ?)}',0
005DC830: '{call MAKE_MONSTER_REPROT_DAILY ( %d, ',27h,'%s',27h,', %d, %d )}',0
005DC870: '{call MAKE_MONSTER_ITEM_REPROT ( %d, %d, %d )}',0
005DC8A8: '{call UPDATE_EMIGRATION_EVENT (',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, %d)}',0
005DC8EC: '{call INSERT_BATTLE_STATISTICS_CHINA ( %d, %d, %d, %d, %d, %d )}',0
005DC950: '{call CLEAR_REMAIN_USERS (',27h,'%s',27h,')}',0
005DCBD8: '{call REGISTER_PREMIUM (',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, %d, ?)}',0
005DCC18: '{call REGISTER_PREMIUM_CHINA (',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, %d, ?)}',0
005DCDC0: '{call LOAD_RENTAL_DATA ( ',27h,'%s',27h,' )}',0
005DCE4C: '{call RENTAL_ITEM_REGISTER ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d,%d,%d,%d,%d, %d,%d, ?, ?, ? )}',0
005DCF04: '{call RENTAL_ITEM_LEND ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, ? )}',0
005DCFA8: '{call RENTAL_ITEM_CANCEL ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, ? )}',0
005DD050: '{call RENTAL_ITEM_DESTORY ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, %d, ? )}',0
005DD240: '{call RENTAL_ITEM_DURABILITY_UPDATE ( %d, %d )}',0
005DD2BC: '{call RESET_LOYALTY_MONTHLY}',0
005DD2FC: '{call GET_GAMEBANG_DATA ( ',27h,'%s',27h,', %d, ?, ?, ? )}',0
005DD334: '{call GET_GAMEBANG_LOTTERY_ITEM ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ? )}',0
005DD378: '{call GET_GAMEBANG_EVENT_ITEM ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ? )}',0
005DD3B8: '{call CHECK_GAMEBANG_USER ( ',27h,'%s',27h,', ? )}',0
005DD410: 'INSERT WEB_ITEMMALL(strAccountID,strCharID,ServerNo,ItemID,ItemCount,TransactionID) VALUES(',27h,'%s',27h,',',27h,'%s',27h,',%d,%d,%d,%d)',0
005DD4E0: '{call POWERUP_SHOPPINGMALL_WRIGHTLOG (',27h,'%s',27h,',',27h,'%s',27h,',%d,%d,%d)}',0
005DD540: '{call CHECK_KJWAR_ACCOUNT ( ',27h,'%s',27h,', ? )}',0
005DD584: '{call GET_KJWAR_DATA ( ',27h,'%s',27h,', %d, ',27h,'%s',27h,', %d, ?, ?, ? )}',0
005DD5DC: '{call CHECK_LOGTIME_ACCOUNT ( ',27h,'%s',27h,', ? )}',0
005DD628: '{call GET_LOGTIME_DATA ( ',27h,'%s',27h,', %d, ',27h,'%s',27h,', %d, ?, ?, ? )}',0
005DD68C: '{call LOAD_ACCOUNT_AUTHORITY( ',27h,'%s',27h,', ? )}',0
005DD700: '{call ACCOUNT_FORBID ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ? )}',0
005DD734: '{call UPDATE_GAMEBANG_LEVEL_EVENT (',27h,'%s',27h,', ',27h,'%s',27h,', %d, %d, ',27h,'%s',27h,')}',0
005DD79C: '{call KING_CANDIDACY_RECOMMEND ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ? )}',0
005DD7F0: '{call KING_ELECTION_PROC ( ',27h,'%s',27h,', ',27h,'%s',27h,', %d, ',27h,'%s',27h,', ? )}',0
005DD8BC: '{call KING_CANDIDACY_NOTICE_BOARD_PROC ( ',27h,'%s',27h,', %d, %d, ?)}',0
005DD914: '{call KING_CHANGE_TAX ( %d, %d, %d, %d, %d, %d, %d, %d )}',0
005DD978: '{call KING_UPDATE_NOAH_OR_EXP_EVENT ( %d, %d, %d, %d, %d, %d, %d )}',0
005DD9E0: '{call KING_INSERT_PRIZE_EVENT ( %d, %d, %d, ',27h,'%s',27h,' )}',0
005DDA3C: '{call KING_UPDATE_ELECTION_STATUS ( %d, %d )}',0
005DDA90: '{call KING_UPDATE_ELECTION_LIST ( %d, %d, %d, %d, %d, ',27h,'%s',27h,' )}',0
005DDAF8: '{call KING_UPDATE_ELECTION_SCHDULE ( %d, %d, %d, %d, %d, %d, %d )}',0
005DDB64: '{call KING_UPDATE_IMPEACHMENT_STATUS ( %d, %d, %d, %d, %d, %d, %d, ',27h,'%s',27h,' )}',0
005DDBE8: '{call KING_IMPEACHMENT_REQUEST_ELECTION ( %d, %d, ',27h,'%s',27h,' )}',0
005DDC50: '{call KING_IMPEACHMENT_ELECTION ( %d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,', ? )}',0
005DDCB4: '{call KING_IMPEACHMENT_RESULT ( %d, ?, ? )}',0
005DDD00: '{call PPCardTradeResultRecord (',27h,'%s',27h,', %d, %d, ? )}',0
005DDD5C: '{call InsertPPCardSellList (%d, %d, ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,', ?, ? )}',0
005DDDCC: '{call INQUIRY_TRADE_MONEY (',27h,'%s',27h,', ? )}',0
005DDE18: '{call INQUIRY_PPCARDTRADE_RESULT (',27h,'%s',27h,')}',0
005DDE70: '{call INQUIRY_PPCARDTRADE_RESULT_AFTER (',27h,'%s',27h,', %d)}',0
005DDED0: '{call INQUIRY_TRADE_SELLMONEY (',27h,'%s',27h,', ?, ? )}',0
005DDF28: '{call PPCard_TRADE_DRAWOUT (',27h,'%s',27h,')}',0
005DDF54: '{call CHECK_OLYMPIC_ACCOUNT ( ',27h,'%s',27h,', ? )}',0
005DDF88: '{call OLYMPIC_ITEM_LOG (',27h,'%s',27h,',',27h,'%s',27h,',%d,%d,%d)}',0
005DDFD8: '{call SKILLSHORTCUT_SAVE (',27h,'%s',27h,',%d,?)}',0
005DE020: '{call SKILLSHORTCUT_LOAD (',27h,'%s',27h,')}',0
005DE058: '{call INSERT_PROGRAM_CHECK_USER (',27h,'%s',27h,', ',27h,'%s',27h,', ',27h,'%s',27h,')}',0
005DE0B0: '{call TREASURE_CHECK( ?, ?, ?, ? )}',0
005DE0F4: '{call PROC_CHECK_WEB_ITEM_COUNT ( ?, ? )}',0
005DE13C: '{call PROC_WEB_STORE_GET_ITEM ( ?, ? ,?, ?, ?, ?)}',0
005DE194: '{call PROC_WEB_STORE_GET_LETTER ( ?, ?, ? )}',0
005DE1E4: '{call PROC_REQUEST_WEB_ITEM_LIST ( ? )}',0
005DE214: '{call PROC_REQUEST_WEB_ITEM_HISTORY ( ? )}',0
005DE248: '{call smg_CHECK_USERID_DUPLICATION ( ?, ?)}',0 |
