| Dev Toxido |
14-02-2015 11:33 PM |
Querry Auto Notice Start From +8
Some Querry
1-Querry Change Place Of NPC
كود PHP:
USE [SRO_VT_SHARD]
----------------------------Made By Toxido----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
SET @KINGEDITOR1 = 'NPC_RANGO' ----- Your Npc Name
SET @CHARNAME = 'test2' ----- Charactar name [ where you Want to set npc ]
Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)
Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)
UPDATE Tab_RefNest
SET nregiondbid = @ASpos1,
flocalposx = @ASpos2,
flocalposy = @ASpos3,
flocalposz = @ASpos4
WHERE dwnestid = @AS3 and dwtacticsid = @AS2
Print 'Done Change Place Of NPC'
Print 'Querry By Toxido'
2-Querry Add Drop
كود PHP:
USE/**/SRO_VT_SHARD
--Credits By Toxido
/*Edited By Toxido*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_EV_WINTER_WHITEKNIGHT_100'/*Monster Code*/
SET @Item = 'ITEM_ETC_ARENA_COIN'/*Item Code*/
SET @DropAmountMin = 30 /*Drop Min*/
SET @DropAmountMax = 50 /*Drop Max*/
SET @DropRatio = 1.0 /*1.0 = '100%' */
-------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/
3-Querry Change Mob To Uniqe
كود PHP:
USE SRO_VT_SHARD
GO
update _RefObjCommon set Rarity = 3 where CodeName128 = 'MOB_JUPITER_THE_EARTH1'
Print 'Mob has been changed to unique'
Print 'Query Has Created by Toxido'
4-Querry Restar Skill's
كود PHP:
USE SRO_VT_SHARD
DECLARE @CharName varchar (64)
DECLARE @CharID int
DECLARE @GiveSP int
SET @CharName = 'NoTryVsMe' --Your Char Name
SET @GiveSP = '100000000' --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
Print 'Mob has been changed to unique'
Print 'Query Has Created by Toxido'
|
