| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
05-01-2014, 11:56 PM
|
#16 | ||||||||||
  
|
أيوة أعمــل إيه علشان أشيــل الــ BUG  |
||||||||||
|
|
| إعلانات google |
|
|
|
06-01-2014, 01:31 AM
|
#17 | ||||||||||
 
|
طب نجرب الاول نمسح السطور اللى فى ال table ده _SiegeFortressStruct ونحط دول بدلهم كود:
1 0 84 19538 936000 2011.10.20. 15:06:00 0 1 0 85 19521 464000 2011.10.20. 15:06:00 0 1 0 86 19521 464000 2011.10.20. 15:06:00 0 1 0 87 19521 464000 2011.10.20. 15:06:00 0 1 0 88 19504 936000 2011.10.20. 15:06:00 0 1 0 89 19504 936000 2011.10.20. 15:06:00 0 1 0 90 19504 936000 2011.10.20. 15:06:00 0 1 0 91 19509 0 2011.10.20. 15:06:00 0 1 0 92 19509 0 2011.10.20. 15:06:00 0 1 0 93 19509 0 2011.10.20. 15:06:00 0 1 0 94 19509 0 2011.10.20. 15:06:00 0 1 0 95 19509 0 2011.10.20. 15:06:00 0 1 0 96 19509 0 2011.10.20. 15:06:00 0 1 0 97 19515 0 2011.10.20. 15:06:00 0 1 0 98 19515 0 2011.10.20. 15:06:00 0 1 0 99 19515 0 2011.10.20. 15:06:00 0 1 0 100 19515 0 2011.10.20. 15:06:00 0 1 0 101 19515 0 2011.10.20. 15:06:00 0 1 0 102 19515 0 2011.10.20. 15:06:00 0 1 0 103 19515 0 2011.10.20. 15:06:00 0 1 0 104 19515 0 2011.10.20. 15:06:00 0 1 0 105 19515 0 2011.10.20. 15:06:00 0 1 0 106 19515 0 2011.10.20. 15:06:00 0 1 0 107 19515 0 2011.10.20. 15:06:00 0 1 0 108 19515 0 2011.10.20. 15:06:00 0 1 0 127 19543 0 2011.10.20. 16:25:00 0 1 0 128 19543 0 2011.10.20. 16:25:00 0 1 0 129 19543 0 2011.10.20. 16:25:00 0 1 0 130 19543 0 2011.10.20. 16:25:00 0 1 0 131 19543 0 2011.10.20. 16:25:00 0 1 0 132 19543 0 2011.10.20. 16:25:00 0 1 0 133 19543 0 2011.10.20. 16:25:00 0 1 0 134 19543 0 2011.10.20. 16:25:00 0 1 0 135 19543 0 2011.10.20. 16:25:00 0 1 0 136 19543 0 2011.10.20. 16:25:00 0 3 0 180 19610 936000 2011.10.19. 22:00:00 0 3 0 181 19521 464000 2011.10.19. 22:00:00 0 3 0 182 19521 464000 2011.10.19. 22:00:00 0 3 0 183 19521 464000 2011.10.19. 22:00:00 0 3 0 184 19575 936000 2011.10.19. 22:00:00 0 3 0 185 19575 936000 2011.10.19. 22:00:00 0 3 0 186 19575 936000 2011.10.19. 22:00:00 0 3 0 187 19509 0 2011.10.19. 22:00:00 0 3 0 188 19509 0 2011.10.19. 22:00:00 0 3 0 189 19509 0 2011.10.19. 22:00:00 0 3 0 190 19509 0 2011.10.19. 22:00:00 0 3 0 191 19509 0 2011.10.19. 22:00:00 0 3 0 192 19509 0 2011.10.19. 22:00:00 0 3 0 193 19515 0 2011.10.19. 22:00:00 0 3 0 194 19515 0 2011.10.19. 22:00:00 0 3 0 195 19515 0 2011.10.19. 22:00:00 0 3 0 196 19515 0 2011.10.19. 22:00:00 0 3 0 197 19515 0 2011.10.19. 22:00:00 0 3 0 198 19515 0 2011.10.19. 22:00:00 0 3 0 199 19515 0 2011.10.19. 22:00:00 0 3 0 200 19515 0 2011.10.19. 22:00:00 0 3 0 201 19515 0 2011.10.19. 22:00:00 0 3 0 202 19515 0 2011.10.19. 22:00:00 0 3 0 224 19543 0 2011.10.19. 22:00:00 0 3 0 225 19543 0 2011.10.19. 22:00:00 0 3 0 226 19543 0 2011.10.19. 22:00:00 0 3 0 227 19543 0 2011.10.19. 22:00:00 0 3 0 228 19543 0 2011.10.19. 22:00:00 0 3 0 229 19543 0 2011.10.19. 22:00:00 0 3 0 230 19543 0 2011.10.19. 22:00:00 0 3 0 231 19543 0 2011.10.19. 22:00:00 0 6 0 137 19625 464000 2011.10.19. 15:10:00 0 6 0 138 19521 464000 2011.10.19. 15:10:00 0 6 0 139 19521 464000 2011.10.19. 15:10:00 0 6 0 140 19590 464000 2011.10.19. 15:10:00 0 6 0 141 19590 464000 2011.10.19. 15:10:00 0 6 0 142 19509 0 2011.10.19. 15:10:00 0 6 0 143 19509 0 2011.10.19. 15:10:00 0 6 0 144 19509 0 2011.10.19. 15:10:00 0 6 0 145 19509 0 2011.10.19. 15:10:00 0 6 0 146 19515 0 2011.10.19. 15:10:00 0 6 0 147 19515 0 2011.10.19. 15:10:00 0 6 0 148 19515 0 2011.10.19. 15:10:00 0 6 0 149 19515 0 2011.10.19. 15:10:00 0 6 0 150 19515 0 2011.10.19. 15:10:00 0 6 0 151 19515 0 2011.10.19. 15:10:00 0 6 0 152 19515 0 2011.10.19. 15:10:00 0 6 0 153 19515 0 2011.10.19. 15:10:00 0 6 0 154 19515 0 2011.10.19. 15:10:00 0 6 0 155 19515 0 2011.10.19. 15:10:00 0 6 0 172 19543 0 2011.10.19. 15:10:00 0 6 0 173 19543 0 2011.10.19. 15:10:00 0 6 0 174 19543 0 2011.10.19. 15:10:00 0 6 0 175 19543 0 2011.10.19. 15:10:00 0 6 0 176 19543 0 2011.10.19. 15:10:00 0 6 0 177 19543 0 2011.10.19. 15:10:00 0 6 0 178 19543 0 2011.10.19. 15:10:00 0 6 0 179 19543 0 2011.10.19. 15:10:00 0 1 0 118 19641 80000 2011.10.20. 17:42:59 0 3 0 221 23934 80000 2011.10.20. 17:43:26 0 1 0 117 19641 80000 2011.10.20. 17:43:37 0 1 0 116 19642 80000 2011.10.20. 17:44:14 0 1 0 124 19642 80000 2011.10.20. 17:44:50 0 1 0 126 19550 80000 2011.10.20. 17:45:29 0 1 0 114 19641 80000 2011.10.20. 17:46:09 0 1 0 113 19641 80000 2011.10.20. 17:46:46 0 3 0 222 23934 80000 2011.10.20. 17:47:11 0 1 0 122 19643 80000 2011.10.20. 17:47:22 0 3 0 220 19640 80000 2011.10.20. 17:47:53 0 1 0 121 19643 80000 2011.10.20. 17:48:07 0 3 0 215 19640 80000 2011.10.20. 17:48:54 0 1 0 120 19643 80000 2011.10.20. 17:49:10 0 3 0 213 19640 80000 2011.10.20. 17:49:48 0 1 0 119 19643 80000 2011.10.20. 17:49:54 0 1 0 112 19641 80000 2011.10.20. 17:50:44 0 3 0 211 19640 80000 2011.10.20. 17:50:59 0 1 0 111 19641 80000 2011.10.20. 17:51:23 0 3 0 210 19640 80000 2011.10.20. 17:51:48 0 1 0 115 19642 80000 2011.10.20. 17:52:27 0 1 0 123 19642 80000 2011.10.20. 17:53:17 0 3 0 219 19640 80000 2011.10.20. 17:53:27 0 3 0 217 19640 80000 2011.10.20. 17:55:13 0 1 0 110 19643 80000 2011.10.20. 17:56:16 0 3 0 218 19640 80000 2011.10.20. 17:56:34 0 3 0 216 19640 80000 2011.10.20. 17:57:10 0 1 0 109 19643 80000 2011.10.20. 17:57:54 0 3 0 214 19640 80000 2011.10.20. 17:58:15 0 3 0 212 19640 80000 2011.10.20. 17:59:14 0 3 0 223 19640 80000 2011.10.20. 17:59:51 0 3 0 209 19640 80000 2011.10.20. 18:00:30 0 3 0 208 19640 80000 2011.10.20. 18:01:29 0 3 0 207 19640 80000 2011.10.20. 18:02:15 0 6 0 167 19640 80000 2011.10.20. 18:02:20 0 3 0 206 23933 80000 2011.10.20. 18:02:56 0 6 0 171 19640 80000 2011.10.20. 18:03:36 0 3 0 205 23933 80000 2011.10.20. 18:03:45 0 3 0 204 23933 80000 2011.10.20. 18:04:25 0 3 0 203 23933 80000 2011.10.20. 18:05:10 0 6 0 169 23932 80000 2011.10.20. 18:05:16 0 6 0 168 23932 80000 2011.10.20. 18:05:55 0 6 0 166 19640 80000 2011.10.20. 18:06:32 0 6 0 156 19640 80000 2011.10.20. 18:07:08 0 6 0 162 23932 80000 2011.10.20. 18:07:49 0 6 0 163 23932 80000 2011.10.20. 18:08:27 0 6 0 164 23932 80000 2011.10.20. 18:09:04 0 6 0 165 23932 80000 2011.10.20. 18:09:47 0 6 0 170 19640 80000 2011.10.20. 18:10:29 0 6 0 161 19640 80000 2011.10.20. 18:11:13 0 6 0 157 19640 80000 2011.10.20. 18:11:59 0 6 0 160 19640 80000 2011.10.20. 18:12:36 0 6 0 158 23932 80000 2011.10.20. 18:13:14 0 6 0 159 23932 80000 2011.10.20. 18:13:59 0 |
||||||||||
|
|
|
06-01-2014, 01:32 AM
|
#18 | ||||||||||
|
وابقى اعمل Clean للداتابيز كلها كمان |
||||||||||
|
|
|
06-01-2014, 01:35 AM
|
#19 | ||||||||||
|
لو الاكواد اللى فوق جابو مشاكل امسحهم وجرب دول كود:
1 384 84 19538 1170000 22.08.2009 11:00:00 0 1 384 85 19521 580000 22.08.2009 11:00:00 0 1 384 86 19521 580000 22.08.2009 11:00:00 0 1 384 87 19521 580000 22.08.2009 11:00:00 0 1 384 88 19504 1170000 22.08.2009 11:00:00 0 1 384 89 19504 1170000 22.08.2009 11:00:00 0 1 384 90 19504 1170000 22.08.2009 11:00:00 0 1 384 91 19509 0 22.08.2009 11:00:00 0 1 384 92 19509 0 22.08.2009 11:00:00 0 1 384 93 19509 0 22.08.2009 11:00:00 0 1 384 94 19509 0 22.08.2009 11:00:00 0 1 384 95 19509 0 22.08.2009 11:00:00 0 1 384 96 19509 0 22.08.2009 11:00:00 0 1 384 97 19515 0 22.08.2009 11:00:00 0 1 384 98 19515 0 22.08.2009 11:00:00 0 1 384 99 19515 0 22.08.2009 11:00:00 0 1 384 100 19515 0 22.08.2009 11:00:00 0 1 384 101 19515 0 22.08.2009 11:00:00 0 1 384 102 19515 0 22.08.2009 11:00:00 0 1 384 103 19515 0 22.08.2009 11:00:00 0 1 384 104 19515 0 22.08.2009 11:00:00 0 1 384 105 19515 0 22.08.2009 11:00:00 0 1 384 106 19515 0 22.08.2009 11:00:00 0 1 384 107 19515 0 22.08.2009 11:00:00 0 1 384 108 19515 0 22.08.2009 11:00:00 0 6 863 137 19628 1024000 17.08.2011 12:44:42 0 6 863 138 19532 1024000 17.08.2011 12:42:48 0 6 863 139 19532 1024000 17.08.2011 12:43:59 0 6 863 140 19593 1024000 17.08.2011 12:43:01 0 6 863 141 19593 1024000 17.08.2011 12:43:31 0 6 863 142 19513 416000 17.08.2011 12:43:05 0 6 863 143 19513 416000 17.08.2011 12:43:08 0 6 863 144 19513 416000 17.08.2011 12:43:25 0 6 863 145 19513 416000 17.08.2011 12:43:37 0 6 863 146 19519 416000 17.08.2011 12:42:58 0 6 863 147 19519 416000 17.08.2011 12:43:19 0 6 863 148 19519 416000 17.08.2011 12:44:06 0 6 863 149 19519 416000 17.08.2011 12:43:53 0 6 863 150 19519 416000 17.08.2011 12:42:37 0 6 863 151 19519 416000 17.08.2011 12:42:45 0 6 863 152 19519 416000 17.08.2011 12:44:32 0 6 863 153 19519 416000 17.08.2011 12:44:37 0 6 863 154 19519 416000 17.08.2011 12:44:19 0 1 0 127 19543 0 20.08.2011 15:30:00 0 1 0 128 19543 0 20.08.2011 15:30:00 0 1 0 129 19543 0 20.08.2011 15:30:00 0 1 0 130 19543 0 20.08.2011 15:30:00 0 1 0 131 19543 0 20.08.2011 15:30:00 0 1 0 132 19543 0 20.08.2011 15:30:00 0 1 0 133 19543 0 20.08.2011 15:30:00 0 1 0 134 19543 0 20.08.2011 15:30:00 0 1 0 135 19543 0 20.08.2011 15:30:00 0 1 0 136 19543 0 20.08.2011 15:30:00 0 6 863 155 19519 416000 17.08.2011 12:44:12 0 3 848 180 19613 1632000 16.08.2011 10:25:04 0 3 848 181 19532 1024000 16.08.2011 10:24:03 0 3 848 182 19524 1024000 16.08.2011 10:24:55 0 3 848 183 19528 1024000 16.08.2011 10:24:45 0 3 848 184 19578 1632000 16.08.2011 10:23:33 0 3 848 185 19578 1632000 16.08.2011 10:24:18 0 3 848 186 19578 1632000 16.08.2011 10:23:41 0 3 848 187 19513 416000 16.08.2011 10:23:23 0 3 848 188 19513 416000 16.08.2011 10:23:13 0 3 848 189 19513 416000 16.08.2011 10:24:13 0 3 848 190 19513 416000 16.08.2011 10:24:23 0 3 848 191 19513 416000 16.08.2011 10:23:46 0 3 848 192 19513 416000 16.08.2011 10:23:52 0 3 848 193 19519 416000 16.08.2011 10:23:58 0 3 848 194 19519 416000 16.08.2011 10:24:07 0 3 848 195 19519 416000 16.08.2011 10:24:40 0 6 0 172 19543 0 20.08.2011 15:30:00 0 6 0 173 19543 0 20.08.2011 15:30:00 0 6 0 174 19543 0 20.08.2011 15:30:00 0 6 0 175 19543 0 20.08.2011 15:30:00 0 6 0 176 19543 0 20.08.2011 15:30:00 0 6 0 177 19543 0 20.08.2011 15:30:00 0 6 0 178 19543 0 20.08.2011 15:30:00 0 6 0 179 19543 0 20.08.2011 15:30:00 0 3 848 196 19519 416000 16.08.2011 10:24:35 0 3 848 197 19519 416000 16.08.2011 10:24:31 0 3 848 198 19519 416000 16.08.2011 10:24:48 0 3 848 199 19519 416000 16.08.2011 10:25:00 0 3 848 200 19517 256000 16.08.2011 10:25:25 0 3 848 201 19517 256000 16.08.2011 10:25:16 0 3 848 202 19519 416000 16.08.2011 10:25:07 0 3 0 224 19543 0 20.08.2011 15:30:00 0 3 0 225 19543 0 20.08.2011 15:30:00 0 3 0 226 19543 0 20.08.2011 15:30:00 0 3 0 227 19543 0 20.08.2011 15:30:00 0 3 0 228 19543 0 20.08.2011 15:30:00 0 3 0 229 19543 0 20.08.2011 15:30:00 0 3 0 230 19543 0 20.08.2011 15:30:00 0 3 0 231 19543 0 20.08.2011 15:30:00 0 |
||||||||||
|
|
|
06-01-2014, 01:36 AM
|
#20 | ||||||||||
|
SQL Fix كود:
set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[_InsertSiegeFortressStruct] @FortressID INT AS DECLARE @RefEventStructID INT DECLARE @StructCodeName VARCHAR(129) DECLARE @FortressName VARCHAR(129) IF @FortressID <= 0 BEGIN RETURN -1 END -- Get the FortressName (FORTRESS_JANGAN) SELECT @FortressName = CodeName128 FROM _RefSiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID --print(@FortressName) -- Get the GroupCodeName (GROUP_FORTRESS_JANGAN) DECLARE @FortressGroupCodeName VARCHAR(129) SELECT @FortressGroupCodeName = GroupCodeName128 FROM _RefGame_World_Config WHERE [Value] = @FortressName --print(@FortressGroupCodeName) -- Get the WorldCodeName (INS_FORT_JA) DECLARE @FortressWorldCodeName VARCHAR(129) SELECT @FortressWorldCodeName = WorldCodeName128 FROM _RefGame_World WHERE ConfigGroupCodeName128 = @FortressGroupCodeName --print(@FortressWorldCodeName) DECLARE FortressStructCursor CURSOR FOR SELECT [ID],strParam1 FROM _RefEventZone WITH (NOLOCK) WHERE Service = 1 AND strParam2 = @FortressWorldCodeName OPEN FortressStructCursor FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName WHILE (@@fetch_status = 0) BEGIN DECLARE @RefObjID INT DECLARE @Link INT SET @RefObjID = 0 SET @Link = 0 SELECT @RefObjID = [ID], @Link = Link FROM _RefObjCommon WITH (NOLOCK) WHERE CodeName128 = @StructCodeName IF @RefObjID <= 0 BEGIN FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName CONTINUE END DECLARE @MaxHP INT SELECT @MaxHP = MaxHP FROM _RefObjChar WITH (NOLOCK) WHERE [ID] = @Link IF @MaxHP < 0 BEGIN FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName CONTINUE END IF NOT EXISTS (SELECT * FROM _SiegeFortressStruct WITH (NOLOCK) WHERE RefEventStructID = @RefEventStructID) BEGIN -- ·¹ئغ·±½؛ إ×ہج؛ي؟،¼* ئ÷ئ®¸®½؛ ہخ½؛إد½؛¸¦ ¹ج¸® ¸¸µç´ظ. °ھہ؛ ¸ًµخ default·خ ¼¼ئأ! -- Translation: Create a table in advance on the fortress instance reference. All values are set to default! INSERT INTO [dbo]._SiegeFortressStruct VALUES ( @FortressID, 0, @RefEventStructID, @RefObjID, @MaxHP, GetDate(), 0) END FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName END CLOSE FortressStructCursor DEALLOCATE FortressStructCursor RETURN 0 -- by Daxter كود:
-- Jangan EXEC [dbo].[_InsertSiegeFortressStruct] @FortressID = 1 -- Hotan EXEC [dbo].[_InsertSiegeFortressStruct] @FortressID = 3 -- Bandit EXEC [dbo].[_InsertSiegeFortressStruct] @FortressID = 6 |
||||||||||
|
|
|
06-01-2014, 01:36 AM
|
#21 | ||||||||||
|
حضرتك بقى جرب وقولى ايه الكلام |
||||||||||
|
|
|
06-01-2014, 01:54 AM
|
#22 | ||||||||||
  
|
استخدم Auto Query هتلاقية موجود في قسم الشروحات موجود في تصليح باج الفورترس |
||||||||||
|
|
|
06-01-2014, 02:03 AM
|
#23 | ||||||||||
|
|
||||||||||
|
|
|
07-01-2014, 02:37 PM
|
#24 | ||||||||||
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] Done تسسلم ياباشا ومتحرمش منــك كـله تمــام  |
||||||||||
|
|
|
07-01-2014, 03:12 PM
|
#25 | ||||||||||
|
تمام تم الحل ## |
||||||||||
|
|
|
07-01-2014, 07:43 PM
|
#26 | ||||||||||
 
|
 |
||||||||||
|
|
|
| يتصفح الموضوع حالياً : 2 (0 عضو و 2 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| مشكـلة مش عارٍِف من إيه ؟؟ | MR_SiLva | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 3 | 18-01-2014 12:39 AM |
| مشكـلة بخصـوص الـ Southless Upgrading System | King_Cribo | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 12 | 27-10-2013 11:01 AM |
.gif){kind=icon}
العرض العادي
