|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة |
19-08-2013, 09:42 PM
|
#1
|
|
• الانـتـسـاب » Aug 2013
|
• رقـم العـضـويـة » 113815
|
• المشـــاركـات » 14
|
• الـدولـة »
|
• الـهـوايـة »
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
مشكله فى ال SR_GameServer
دلوقتى انا ضفت موضوع ال 7 صفح بتوع ال pet من موضوع العضو cursed.. ونسيت اخد backup ومن بعد ما عملتها السيرفر مش بيفتح وبيجيبلى الايرور ده
وده اخر حاجه بتجيبى من ال FatalLog
كود PHP:
2013-08-18 03:01:29 [GlobalManager] server cord established : 1 (25.167.122.207:32000)
2013-08-18 03:01:29 [GlobalManager] GlobalManager is initialized successfully
2013-08-18 03:01:35 [GlobalManager] server cord established : 2 (25.167.122.207:61215)
2013-08-18 03:01:36 [GlobalManager] server cord established : 3 (25.167.122.207:61216)
2013-08-18 03:01:37 [GlobalManager] server cord established : 4 (25.167.122.207:61217)
2013-08-18 03:01:38 IBUV: StringSize: 1, CharSet: ABCDEF1234567890
2013-08-18 03:01:38 IBUV: CharSet(ABCDEF1234567890)
2013-08-18 03:01:38 IBUV: Preserved image created : (dwImageCount)
2013-08-18 03:01:38 [FarmManager] server cord established : 1 (25.167.122.207:15880)
2013-08-18 03:01:38 [FarmManager] FarmManager is initialized successfully
2013-08-18 03:01:38 [GlobalManager] server cord established : 5 (25.167.122.207:61218)
2013-08-18 03:01:39 [FarmManager] server cord established : 2 (25.167.122.207:61219)
2013-08-18 03:01:39 [AgentServer] server cord established : 1 (25.167.122.207:15882)
2013-08-18 03:01:40 [AgentServer] AgentServer is initialized successfully
2013-08-18 03:01:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 03:01:42 [FarmManager] server cord established : 3 (25.167.122.207:61221)
2013-08-18 03:01:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 03:01:42 [SR_ShardManager] server cord established : 1 (25.167.122.207:15882)
2013-08-18 03:01:42 [AgentServer] server cord established : 2 (25.167.122.207:15883)
2013-08-18 03:01:48 [FarmManager] server cord established : 4 (25.167.122.207:61226)
2013-08-18 03:01:48 [SR_GameServer] server cord established : 1 (25.167.122.207:15882)
2013-08-18 03:01:48 [SR_GameServer] server cord established : 2 (25.167.122.207:61225)
2013-08-18 03:01:48 [AgentServer] server cord established : 3 (25.167.122.207:15885)
2013-08-18 03:01:49 [SR_ShardManager] server cord established : 3 (25.167.122.207:61227)
2013-08-18 03:01:49 [SR_GameServer] server cord established : 3 (25.167.122.207:15883)
2013-08-18 03:02:23 [SR_ShardManager] Not found RefServerEvent[30001]. Check service and date value. progress next data
2013-08-18 03:02:23 [SR_ShardManager] Not found RefServerEvent[30002]. Check service and date value. progress next data
2013-08-18 03:02:23 [SR_ShardManager] Not found RefServerEvent[30003]. Check service and date value. progress next data
2013-08-18 03:02:23 [SR_ShardManager] Not found RefServerEvent[30004]. Check service and date value. progress next data
2013-08-18 03:02:24 [SR_ShardManager] SR_ShardManager is initialized successfully
2013-08-18 03:02:24 [SR_ShardManager] BillingServer is Dead!!
2013-08-18 03:02:24 [SR_GameServer] server cord closed : 3
2013-08-18 03:02:24 [AgentServer] 705:SR_ShardManager is blind : 0 users are banned
2013-08-18 03:02:25 [AgentServer] server cord closed : 2
2013-08-18 03:02:25 [FarmManager] server cord closed : 3
2013-08-18 03:02:56 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:02:57 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:02:58 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:02:59 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:00 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:01 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:02 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:03 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:04 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:05 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:06 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:07 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:08 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:09 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:10 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:11 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:12 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:13 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:14 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:15 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:16 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:17 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:18 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:18 [SR_GameServer] Failed To Load Reference Data
2013-08-18 03:03:18 [SR_GameServer] SR_GameServer is initialized successfully
2013-08-18 03:03:19 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:20 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:21 [SR_GameServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 03:03:21 [SR_GameServer] OnExit() Called
2013-08-18 03:03:21 [AgentServer] 713:SR_GameServer is blind : 0 users are banned
2013-08-18 03:03:21 [AgentServer] server cord closed : 3
2013-08-18 03:03:21 [FarmManager] server cord closed : 4
2013-08-18 03:03:22 [FarmManager] server cord closed : 2
2013-08-18 03:03:23 [GlobalManager] server cord closed : 5
2013-08-18 03:03:24 [GlobalManager] server cord closed : 4
2013-08-18 03:03:25 [GlobalManager] server cord closed : 3
2013-08-18 03:03:26 [GlobalManager] server cord closed : 2
2013-08-18 15:53:05 [GlobalManager] server cord established : 1 (25.167.122.207:32000)
2013-08-18 15:53:05 [GlobalManager] GlobalManager is initialized successfully
2013-08-18 15:53:09 [GlobalManager] server cord established : 2 (25.167.122.207:64808)
2013-08-18 15:53:09 [GlobalManager] server cord established : 3 (25.167.122.207:64809)
2013-08-18 15:53:09 [FarmManager] server cord established : 1 (25.167.122.207:15880)
2013-08-18 15:53:09 [FarmManager] FarmManager is initialized successfully
2013-08-18 15:53:10 [GlobalManager] server cord established : 4 (25.167.122.207:64810)
2013-08-18 15:53:12 [GlobalManager] server cord established : 5 (25.167.122.207:64811)
2013-08-18 15:53:13 IBUV: StringSize: 1, CharSet: ABCDEF1234567890
2013-08-18 15:53:13 IBUV: CharSet(ABCDEF1234567890)
2013-08-18 15:53:13 IBUV: Preserved image created : (dwImageCount)
2013-08-18 15:53:15 [FarmManager] server cord established : 2 (25.167.122.207:64812)
2013-08-18 15:53:15 [AgentServer] server cord established : 1 (25.167.122.207:15882)
2013-08-18 15:53:15 [AgentServer] AgentServer is initialized successfully
2013-08-18 15:53:17 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:17 [FarmManager] server cord established : 3 (25.167.122.207:64814)
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:53:18 [SR_ShardManager] server cord established : 1 (25.167.122.207:15882)
2013-08-18 15:53:18 [SR_ShardManager] server cord established : 2 (25.167.122.207:64815)
2013-08-18 15:53:18 [AgentServer] server cord established : 2 (25.167.122.207:15883)
2013-08-18 15:53:21 [FarmManager] server cord established : 4 (25.167.122.207:64817)
2013-08-18 15:53:21 [SR_GameServer] server cord established : 1 (25.167.122.207:15882)
2013-08-18 15:53:21 [SR_GameServer] server cord established : 2 (25.167.122.207:64818)
2013-08-18 15:53:21 [AgentServer] server cord established : 3 (25.167.122.207:15885)
2013-08-18 15:53:22 [SR_ShardManager] server cord established : 3 (25.167.122.207:64819)
2013-08-18 15:53:22 [SR_GameServer] server cord established : 3 (25.167.122.207:15883)
2013-08-18 15:53:42 [SR_ShardManager] Not found RefServerEvent[30001]. Check service and date value. progress next data
2013-08-18 15:53:42 [SR_ShardManager] Not found RefServerEvent[30002]. Check service and date value. progress next data
2013-08-18 15:53:42 [SR_ShardManager] Not found RefServerEvent[30003]. Check service and date value. progress next data
2013-08-18 15:53:42 [SR_ShardManager] Not found RefServerEvent[30004]. Check service and date value. progress next data
2013-08-18 15:53:42 [SR_ShardManager] SR_ShardManager is initialized successfully
2013-08-18 15:54:52 [SR_GameServer] Failed To Load Reference Data
2013-08-18 15:54:52 [SR_GameServer] SR_GameServer is initialized successfully
2013-08-18 15:56:19 [SR_GameServer] OnExit() Called
2013-08-18 15:56:19 [AgentServer] 713:SR_GameServer is blind : 0 users are banned
2013-08-18 15:56:19 [AgentServer] server cord closed : 3
2013-08-18 15:56:19 [SR_ShardManager] server cord closed : 3
2013-08-18 15:56:19 [FarmManager] server cord closed : 4
2013-08-18 15:56:51 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:56:53 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:56:53 [SR_ShardManager] OnExit() Called
2013-08-18 15:56:54 [AgentServer] 705:SR_ShardManager is blind : 0 users are banned
2013-08-18 15:56:54 [AgentServer] server cord closed : 2
2013-08-18 15:56:54 [FarmManager] server cord closed : 3
2013-08-18 15:56:55 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:56:58 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:01 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:04 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:07 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:10 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:13 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:16 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:19 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:22 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:25 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:28 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:31 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:34 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:37 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:40 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:41 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:43 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:44 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:46 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:47 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:49 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:50 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:52 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:53 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:55 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:56 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:57:58 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:57:59 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:01 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:02 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:04 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:05 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:07 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:08 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:10 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:11 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:13 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:14 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:16 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:17 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:19 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:20 [AgentServer] cannot establish keep alive session : 25.167.122.207 15883 (bind 0.0.0.0)
2013-08-18 15:58:21 [FarmManager] server cord established : 5 (25.167.122.207:65016)
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2013-08-18 15:58:21 [SR_ShardManager] server cord established : 1 (25.167.122.207:15882)
2013-08-18 15:58:22 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:22 [SR_ShardManager] server cord established : 2 (25.167.122.207:65017)
2013-08-18 15:58:22 [AgentServer] server cord established : 4 (25.167.122.207:15883)
2013-08-18 15:58:24 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:26 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:28 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:30 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:32 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:34 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:35 [SR_ShardManager] Not found RefServerEvent[30001]. Check service and date value. progress next data
2013-08-18 15:58:35 [SR_ShardManager] Not found RefServerEvent[30002]. Check service and date value. progress next data
2013-08-18 15:58:35 [SR_ShardManager] Not found RefServerEvent[30003]. Check service and date value. progress next data
2013-08-18 15:58:35 [SR_ShardManager] Not found RefServerEvent[30004]. Check service and date value. progress next data
2013-08-18 15:58:35 [SR_ShardManager] SR_ShardManager is initialized successfully
2013-08-18 15:58:36 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:38 [AgentServer] cannot establish keep alive session : 25.167.122.207 15885 (bind 0.0.0.0)
2013-08-18 15:58:38 [FarmManager] server cord established : 6 (25.167.122.207:65027)
2013-08-18 15:58:38 [SR_GameServer] server cord established : 1 (25.167.122.207:15882)
2013-08-18 15:58:39 [SR_GameServer] server cord established : 2 (25.167.122.207:65028)
2013-08-18 15:58:39 [AgentServer] server cord established : 5 (25.167.122.207:15885)
2013-08-18 15:58:40 [SR_ShardManager] server cord established : 3 (25.167.122.207:65029)
2013-08-18 15:58:40 [SR_GameServer] server cord established : 3 (25.167.122.207:15883)
2013-08-18 16:00:09 [SR_GameServer] Failed To Load Reference Data
2013-08-18 16:00:09 [SR_GameServer] SR_GameServer is initialized successfully
2013-08-18 16:00:34 [SR_GameServer] OnExit() Called
2013-08-18 16:00:35 [SR_ShardManager] server cord closed : 3
2013-08-18 16:00:35 [FarmManager] server cord closed : 6
2013-08-18 16:00:35 [AgentServer] 713:SR_GameServer is blind : 0 users are banned
2013-08-18 16:00:35 [AgentServer] server cord closed : 5
2013-08-18 16:00:36 [FarmManager] server cord closed : 2
2013-08-18 16:00:36 [SR_ShardManager] server cord closed : 2
2013-08-18 16:00:37 [GlobalManager] server cord closed : 5
2013-08-18 16:00:38 [GlobalManager] server cord closed : 4
2013-08-18 16:00:38 [GlobalManager] server cord closed : 3
2013-08-18 16:00:38 [SR_ShardManager] server cord closed : 1
2013-08-18 16:01:35 [SR_ShardManager] OnExit() Called
وده الكويرى اللى انا استخدمته
كود PHP:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 08/05/2013 06:44:58 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as
begin tran
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -5
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
end
commit tran
return @COS_ID
ياريت حل للمشكله دى علشان السيرفر مبيفتحش خالص بسببها
|
|
|
إعلانات google |
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
|
|
ضوابط المشاركة
|
تستطيع إضافة مواضيع جديدة
تستطيع الرد على المواضيع
تستطيع إرفاق ملفات
تستطيع تعديل مشاركاتك
كود HTML معطلة
|
|
|
الساعة الآن 01:41 PM.
|