22-08-2014, 05:55 PM
|
#2
|
|
|
• الانـتـسـاب » Jul 2011
|
|
• رقـم العـضـويـة » 89501
|
|
• المشـــاركـات » 841
|
|
• الـدولـة » EGYPT
|
|
• الـهـوايـة » Editor DB + Media And Have More Solving
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 21
|
|
|
|
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
|