قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
25-02-2013, 10:21 PM | #1 | ||||||||||
|
انا عايز : اعميل ال database cap 110 عايز احط items في npc انا بستخديم database castaway و FW مش شغاله عايز اشغلها عاير احط honor buff لplayer معين |
||||||||||
|
25-02-2013, 10:29 PM | #2 | ||||||||||
|
Cap بيتعدل من Sro_Client و ده كويرى للاكونت بف كود:
USE [SRO_VT_SHARD] DECLARE @CharName Varchar (MAX) DECLARE @Graduates INT DECLARE @HonorPoints INT DECLARE @CharID INT DECLARE @CampID INT SET @CharName = 'Char Name' SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID) SET @Graduates = '1234' SET @HonorPoints= @Graduates * 39 -------------------- UPDATE [Dbo].[_TrainingCamp] SET GraduateCount = @Graduates WHERE [Dbo].[_TrainingCamp].[ID] = @CampID UPDATE [dbo].[_TrainingCampMember] SET HonorPoint = @HonorPoints WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID |
||||||||||
|
25-02-2013, 11:08 PM | #3 | |||||||||||
|
اقتباس:
وجاي على نفسك أوي كده ليه ^.^ |
|||||||||||
|
25-02-2013, 11:10 PM | #4 | |||||||||||
|
اقتباس:
انتا برنس |
|||||||||||
|
26-02-2013, 12:42 AM | #5 | ||||||||||
|
1-عاوز تعدل على الmax lvl يبقى من ال Sr gameserver من البرنامج ده عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] 2-من الموضوع ده عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] 3-امسح كل الى فى _SiegeFortressStruct فى sro_Vt_shard و حط ده كود:
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 كود:
USE SRO_VT_SHARD TRUNCATE TABLE _TrainingCampHonorRank INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50) exec _TRAINING_CAMP_UPDATEHONORRANK كود:
USE SRO_VT_SHARD exec _TRAINING_CAMP_UPDATEHONORRANK |
||||||||||
|
27-02-2013, 06:34 AM | #6 | ||||||||||
|
يغلق # |
||||||||||
|
27-02-2013, 01:17 PM | #7 | ||||||||||
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
أدوات الموضوع | |
انواع عرض الموضوع | |
|
|
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
شوية طلبات | Alber Maher | قسم المواضيع المكررة و المخالفة | 7 | 18-07-2013 05:40 PM |
شوية طلبات | N0 L0VE | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 4 | 12-06-2013 04:28 PM |
شوية طلبات ^^ | Abd ElHamid Samy | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 12 | 03-06-2013 03:06 PM |
شوية طلبات | Alber Maher | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 6 | 29-05-2013 06:20 PM |
$ شوية معلومات كدا خفيفه :) $ | TUNNER§ | قسم المواضيع المكررة و المخالفة | 12 | 10-11-2010 06:35 PM |