الموضوع: ممكن طلب
عرض مشاركة واحدة
قديم 22-08-2014, 05:55 PM   #2

MeMo@Love
عضو مميز



الصورة الرمزية MeMo@Love


• الانـتـسـاب » Jul 2011
• رقـم العـضـويـة » 89501
• المشـــاركـات » 841
• الـدولـة » EGYPT
• الـهـوايـة » Editor DB + Media And Have More Solving
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 21
MeMo@Love صـاعـد

MeMo@Love غير متواجد حالياً


إرسال رسالة عبر Yahoo إلى MeMo@Love

افتراضي



For Chinese
كود:
USE SRO_VT_SHARD DECLARE @CharName varchar (64) DECLARE  @CharID int DECLARE @GiveSP int SET @CharName = 'CharName' --Your Char Name SET @GiveSP   = '10000000' --Write the amount of Skill Point SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change  -- edit by InPanic Kev -- update _ClientConfig set Data = '0' where CharID = @CharID -- edit by InPanic Kev --  --- Do Not Change Here --- --- made by ModGift for RZ --- DELETE [dbo].[_CharSkill]    WHERE [CharID] = @CharID and [SkillID] > '2' and SkillID<'40'   DELETE [dbo].[_CharSkill]    WHERE [CharID] = @CharID and [SkillID] > '40' and SkillID<'70'   DELETE [dbo].[_CharSkill]    WHERE [CharID] = @CharID and [SkillID] > '70'   UPDATE [dbo].[_CharSkillMastery]    SET        [Level] = '0'  WHERE CharID= @CharID  UPDATE [dbo].[_Char]   SET RemainSkillPoint= @GiveSP   WHERE CharName16 = @CharName GO













For ERU
كود:
USE SRO_VT_SHARD DECLARE @CharName varchar (64) DECLARE  @CharID int DECLARE @GiveSP int SET @CharName = 'CharName' --Your Char Name SET @GiveSP   = '10000000' --Write the amount of Skill Point SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change  -- edit by InPanic Kev -- update _ClientConfig set Data = '0' where CharID = @CharID -- edit by InPanic Kev --  --- Do Not Change Here --- --- made by ModGift for RZ  --- DELETE [dbo].[_CharSkill]    WHERE [CharID] = @CharID and [SkillID] > '2'  INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID            ,'8421'            ,'1') INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID 		   ,'8419'            ,'1')  INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '8420'            ,'1')  INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '9354'            ,'1')  INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '9355'            ,'1')  INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '9944'            ,'1') INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '10625'            ,'1') INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '11162'            ,'1') INSERT INTO [dbo].[_CharSkill]            ([CharID]            ,[SkillID]            ,[Enable])      VALUES            (@CharID,            '11526'            ,'1') UPDATE [dbo].[_CharSkillMastery]    SET        [Level] = '0'  WHERE CharID= @CharID UPDATE [dbo].[_Char]   SET RemainSkillPoint= @GiveSP   WHERE CharName16 = @CharName GO











































































التعديل الأخير تم بواسطة MeMo@Love ; 22-08-2014 الساعة 05:59 PM