Dev Ahmed
25-07-2015, 02:41 AM
الموضوع مش جديد ويمكن ناس كتير عارفه الحاجات دي بس انا قولت افيد ناس العايزه الحاجات دي
بعض ال query المهمه :
1-Reset Skill
USE SRO_VT_SHARD
DECLARE @CharName varchar (64)
DECLARE @CharID int
DECLARE @GiveSP int
SET @CharName = 'Name Char Here'--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
2-Remove Premium
USE SRO_VT_SHARD
GO
DECLARE @CharName Varchar (MAX)
DECLARE @CharID INT
SET @CharName = 'Name Char Here'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
DELETE FROM _TimedJob WHERE CharID = @CharID
3-Remove PK From Char
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar(max)
SET @CharName = 'Name Char Name'
UPDATE _Char SET
RemainHwanCount = 5,
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
WHERE CharName16 = @CharName
4- Add Title To Char
USE SRO_VT_SHARD--_INIT
Declare @CharNick varchar(64)
Declare @Hwanlvl tinyint
SET @CharNick = 'Name Char Here' --Your Ingame Nick
SET @Hwanlvl = 'rkm l title here' --Your desired Hwan Title e.g. '6'
/* Hwan Title Explanation:
CH '1' Captain
CH '2' General
CH '3' Senior General
CH '4' Chief General
CH '5' Vice General Lord
CH '6' General Lord
EU '1' Knight
EU '2' Baronet
EU '3' Baron
EU '4' Count
EU '5' Marquis
EU '6' Duke */
UPDATE dbo._Char
SET HwanLevel = @Hwanlvl
WHERE CharName16 like @CharNick
5- Plus Devil
UPDATE dbo._Items set OptLevel='plus devil here'WHERE ID64='id devil here'
6-Plus Weapon & Full Blue 100% & Stats 100%
UPDATE dbo._Items set OptLevel='plus weapon here',Variance='34359738367',MagParamNum='5 ',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='id weapon here'
Print 'WEP'
7-Plus Accsossry & Full Blue 100% & Stats 100%
UPDATE dbo._Items set OptLevel='plus accsorssry here',Variance='34359738367',MagParamNum='7',MagPa ram1='30064771144',MagParam2= '30064771150',MagParam3='85899346088',MagParam4= '85899346100',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346094'WHERE ID64='id accsossry here'
Print 'ACC'
8-Plus Set & Full Blue 100% & Stats 100%
(Hands - Shoulder - Foot)in smc (shoulder-gauntlet-Boots)
UPDATE dbo._Items set OptLevel='plus set here',Variance='34359738367',Data='3000',MagParamN um='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'WHERE ID64='id set here'
Print 'shoulder-gauntlet-Boots'
9-Plus Set & Full Blue 100% & Stats 100%
(Head - Legs - Chest)in smc (Helm-Mail-Pants)
UPDATE dbo._Items set OptLevel='plus set here',Variance='34359738367',MagParamNum='6' ,MagParam1='30064771144',MagParam2= '5583457484950',MagParam3='858993459290',MagParam4 = '5583457484962',MagParam5= '30064771150',MagParam6= '257698037898'WHERE ID64='id set here'
Print 'Helm-Mail-Pants'
10-change moob to unique
USE SRO_VT_SHARD
GO
update _RefObjCommon set Rarity = 3 where CodeName128 = 'code moob here'
Print 'Mob has been changed to unique'
11-remove item from players
USE [SRO_VT_SHARD]
/* ***** Hamza * ***** */
DECLARE @Codename128 VARCHAR(128)SET @Codename128 = 'ITEM_MALL_GLOBAL_CHATTING' -- Write code to delete item
UPDATE _Inventory SET ItemID = 0 FROM _Inventory JOIN _Items ON _Items.ID64 = _Inventory.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _Chest SET ItemID = 0 FROM _Chest JOIN _Items ON _Items.ID64 = _Chest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _GuildChest SET ItemID = 0 FROM _GuildChest JOIN _Items ON _Items.ID64 = _GuildChest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _InvCOS SET ItemID = 0 FROM _InvCOS JOIN _Items ON _Items.ID64 = _InvCOS.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
ملحوظه : للناس الي متعرفش تضيف query ازاي
open sql >>open database >>right click on SRO_VT_SHARD >> New Query >>Paste The Query
بعض ال query المهمه :
1-Reset Skill
USE SRO_VT_SHARD
DECLARE @CharName varchar (64)
DECLARE @CharID int
DECLARE @GiveSP int
SET @CharName = 'Name Char Here'--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
2-Remove Premium
USE SRO_VT_SHARD
GO
DECLARE @CharName Varchar (MAX)
DECLARE @CharID INT
SET @CharName = 'Name Char Here'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
DELETE FROM _TimedJob WHERE CharID = @CharID
3-Remove PK From Char
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar(max)
SET @CharName = 'Name Char Name'
UPDATE _Char SET
RemainHwanCount = 5,
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
WHERE CharName16 = @CharName
4- Add Title To Char
USE SRO_VT_SHARD--_INIT
Declare @CharNick varchar(64)
Declare @Hwanlvl tinyint
SET @CharNick = 'Name Char Here' --Your Ingame Nick
SET @Hwanlvl = 'rkm l title here' --Your desired Hwan Title e.g. '6'
/* Hwan Title Explanation:
CH '1' Captain
CH '2' General
CH '3' Senior General
CH '4' Chief General
CH '5' Vice General Lord
CH '6' General Lord
EU '1' Knight
EU '2' Baronet
EU '3' Baron
EU '4' Count
EU '5' Marquis
EU '6' Duke */
UPDATE dbo._Char
SET HwanLevel = @Hwanlvl
WHERE CharName16 like @CharNick
5- Plus Devil
UPDATE dbo._Items set OptLevel='plus devil here'WHERE ID64='id devil here'
6-Plus Weapon & Full Blue 100% & Stats 100%
UPDATE dbo._Items set OptLevel='plus weapon here',Variance='34359738367',MagParamNum='5 ',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='id weapon here'
Print 'WEP'
7-Plus Accsossry & Full Blue 100% & Stats 100%
UPDATE dbo._Items set OptLevel='plus accsorssry here',Variance='34359738367',MagParamNum='7',MagPa ram1='30064771144',MagParam2= '30064771150',MagParam3='85899346088',MagParam4= '85899346100',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346094'WHERE ID64='id accsossry here'
Print 'ACC'
8-Plus Set & Full Blue 100% & Stats 100%
(Hands - Shoulder - Foot)in smc (shoulder-gauntlet-Boots)
UPDATE dbo._Items set OptLevel='plus set here',Variance='34359738367',Data='3000',MagParamN um='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'WHERE ID64='id set here'
Print 'shoulder-gauntlet-Boots'
9-Plus Set & Full Blue 100% & Stats 100%
(Head - Legs - Chest)in smc (Helm-Mail-Pants)
UPDATE dbo._Items set OptLevel='plus set here',Variance='34359738367',MagParamNum='6' ,MagParam1='30064771144',MagParam2= '5583457484950',MagParam3='858993459290',MagParam4 = '5583457484962',MagParam5= '30064771150',MagParam6= '257698037898'WHERE ID64='id set here'
Print 'Helm-Mail-Pants'
10-change moob to unique
USE SRO_VT_SHARD
GO
update _RefObjCommon set Rarity = 3 where CodeName128 = 'code moob here'
Print 'Mob has been changed to unique'
11-remove item from players
USE [SRO_VT_SHARD]
/* ***** Hamza * ***** */
DECLARE @Codename128 VARCHAR(128)SET @Codename128 = 'ITEM_MALL_GLOBAL_CHATTING' -- Write code to delete item
UPDATE _Inventory SET ItemID = 0 FROM _Inventory JOIN _Items ON _Items.ID64 = _Inventory.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _Chest SET ItemID = 0 FROM _Chest JOIN _Items ON _Items.ID64 = _Chest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _GuildChest SET ItemID = 0 FROM _GuildChest JOIN _Items ON _Items.ID64 = _GuildChest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _InvCOS SET ItemID = 0 FROM _InvCOS JOIN _Items ON _Items.ID64 = _InvCOS.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
ملحوظه : للناس الي متعرفش تضيف query ازاي
open sql >>open database >>right click on SRO_VT_SHARD >> New Query >>Paste The Query