عاوز كويري

[man_lok2002]

عاوز اعمل رسيت سكيلز و رموف بيرميم بالشرح

[Hero]

ال Sscrol فى قسم الشروحات

كود PHP:

if(@JobID= '10000')
        begin 
        DECLARE @CharName Varchar (64)
        declare @ID INT
SET   @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) DELETE FROM _TimedJob WHERE CharID = @CharID  
  DELETE FROM _TimedJob WHERE Category = '5' OR Category = '3' OR Category = '0'
end 


[llg9g9g9gll]

ده Reset Chines Skill

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 omarahmed500 -- 
update _ClientConfig 
set Data = '0' 
where CharID = @CharID 
-- edit by omarahmed500 -- 

--- Do Not Change Here --- 
--- made by omarahmed500 for S4a --- 
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

بتحط اسم الكراكنر مكان CharName
----------------------------------------------------------------
وده Reset EU skill

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

نفس الكلام هتحط اسم الكراكتر مكان CharName
-----------------------------------------------------------------------------------

وده علشان تشيل البريميم بس خالي بالك ده بيشيل اي سكرول وكمان بيشيل honor buff

USE SRO_VT_SHARD
DELETE FROM _TimedJob WHERE CharID = 'CharID'

هتجيب ID الكراكتر وتحطه مكان CharID

[Hero]

و انا مديك ال Scrol اللى بتشيل البرميم فوق

[man_lok2002]

انا عاوز اعملهم فى الداتا مش موجودين عاندي

[man_lok2002]

عاوز اعملهم من الاول و انزلهم فى ال NPC

[Hero]

قدامك الاكواد ضفها

[che_9299]

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

[man_lok2002]

انا اقصد انى عاوز اعملها شكل فى اللعبة و انزلها فى ال NPC دي بشلها بأيدي لكل واحد

[man_lok2002]

اعمل اية دلوقتى انا عاوز انزلهم فى الجيم مش اعملهم بى ايدي

[Hero]

يعنى عايز حد يدخل عندك ينزلهملك :]