الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**Ŗυĭή** · 25-02-2013, 10:21 PM

انا عايز :
اعميل ال database cap 110
عايز احط items في npc
انا بستخديم database castaway و FW مش شغاله عايز اشغلها
عاير احط honor buff لplayer معين

**King0fFire** · 25-02-2013, 10:29 PM

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

يا ريت اكون افدتك

**™Anas™** · 25-02-2013, 11:08 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Ŗυĭή عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

انا عايز :
اعميل ال database cap 110
عايز احط items في npc
انا بستخديم database castaway و fw مش شغاله عايز اشغلها
عاير احط honor buff لplayer معين

د إنتا جميييييييييييييل :))
وجاي على نفسك أوي كده ليه ^.^

**MR ! HЄRO** · 25-02-2013, 11:10 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة ™Anas™ عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

د إنتا جميييييييييييييل :))
وجاي على نفسك أوي كده ليه ^.^

انتا برنس

**BomBom** · 26-02-2013, 12:42 AM

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

4-اعمل ال query دى

كود:

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

**BomBom** · 27-02-2013, 06:34 AM

يغلق #

**TYKE** · 27-02-2013, 01:17 PM

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات