ODY Moderator
المساهمات : 5 نقاط : 1184 تاريخ التسجيل : 26/07/2021 العمر : 24
| موضوع: Queries Collection الإثنين يوليو 26, 2021 9:33 pm | |
| Add new Teleport - الكود:
-
USE SRO_VT_SHARD /* Add new Teleport By ODY */ Go DECLARE @Teleport VARCHAR (64) DECLARE @CHARNAME1 VARCHAR (30) DECLARE @CHARNAME2 VARCHAR (30) DECLARE @OwnTeleport INT DECLARE @Fee INT DECLARE @RequiredLVL INT /* Put your settings here */ SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE SET @CHARNAME1 = 'CHARNAME1' -- Teleport position SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople SET @Fee = 50000 -- Gold amount to Pass the teleport SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport /* settings area end here */ IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport) BEGIN raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport); RETURN; END DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1 DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1 SET IDENTITY_INSERT _RefObjCommon ON INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES (1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link) SET IDENTITY_INSERT _RefObjCommon OFF print '' print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link) print '' print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder' print '' print '1 '+'SN_STORE_'+@Teleport+' '+@Teleport print '' print '' SET IDENTITY_INSERT _RefObjStruct ON INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES (@LINK,0) SET IDENTITY_INSERT _RefObjStruct OFF DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1 DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2) DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2) INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES (1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0) print '' print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0' print '' print '' IF @RequiredLVL = 0 BEGIN INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) print '' print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0' print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0' print '' END ELSE BEGIN INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0) print '' print '' print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max),@RequiredLVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0' print '' END print '' print 'Done!' Add Unique Spot - الكود:
-
USE SRO_VT_SHARD /* Add Unique Spot By ODY */ Go DECLARE @UNIQUE VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) DECLARE @mindealy INT DECLARE @maxdelay int DECLARE @INITRADIUS INT DECLARE @RADIUS int DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1 /* put your settings here */ SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 60 -- Minimum time before appears in seconds SET @maxdelay = 120 -- Maximum time before appears in seconds SET @INITRADIUS = 100 -- Radius around spot unique can generated at SET @RADIUS = 500 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES (@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE) SET IDENTITY_INSERT Tab_RefTactics OFF SET IDENTITY_INSERT Tab_RefHive ON INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE) SET IDENTITY_INSERT Tab_RefHive OFF /* get position coordinates of your character */ DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) SET IDENTITY_INSERT Tab_RefNest ON INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0) SET IDENTITY_INSERT Tab_RefNest OFF print '' print '' print 'Done!' All Player Go To Jangan - الكود:
-
USE [SRO_VT_SHARD] UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0 Change Character title - الكود:
-
use SRO_VT_SHARD Update _Char set HwanLevel = 'Title Num' where CharName16 = 'Cher Name' Change MaxStack - الكود:
-
EXEC _ChangeMaxStack @ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */ @MAXSTACK = 100 /* NEW MAXSTACK */ Change Name - الكود:
-
USE SRO_VT_SHARD GO Update _Char set CharName16 = 'New Name' where CharName16 = 'Last Name' Change Stone Rate D13 Change Rate 60 - الكود:
-
USE(SRO_VT_SHARD) GO() Update(_RefObjItem) Param4 = 60 WHERE ID BETWEEN 21385 AND 21412
Change Stone Rate Daggre 1 to 12 Change 60 - الكود:
-
USE(SRO_VT_SHARD) GO() Update(_RefObjItem) Param4 = 60 WHERE ID BETWEEN 4630 AND 5013
ADD DROP Uniques - الكود:
-
USE [SRO_VT_SHARD]
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT -------------------------------------------------------------------------- SET @Mob = 'MOB_SD_NEITH'/*Monster Code*/ SET @Item = 'ITEM_ETC_SD_TOKEN_01'/*Item Code*/ SET @DropAmountMin = 1 /*Drop Min*/ SET @DropAmountMax = 1 /*Drop Max*/ SET @DropRatio = 1 /*0.5 = '50%' */ -------------------------------------------------------------------------- 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')/**/
Close Item - الكود:
-
UPDATE [dbo].[_RefShopGoods] SET Service = 1 WHERE RefPackageItemCodeName like 'PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14' Delete Select item from all game - الكود:
-
USE [SRO_VT_SHARD]
Exec [Dbo].[_SEEK_N_DESTROY_ITEM] 'ITEM_COS_P_RABBIT_SCROLL' Find Mob Code - الكود:
-
USE SRO_VT_SHARD GO select ID from _RefObjCommon where CodeName128 like 'MOB_CH_TIGERWOMAN' Fix F1 Bug AYou have to add this in _AddNewChar - الكود:
-
-- Slotbug Fix (ODY) UPDATE _RefCharDefault_Quest SET Service = 1 -- this line must be executed only once, so don't add it to the SP DELETE FROM _CharQuest WHERE QuestID=1 AND CharID=@NewCharID INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2) VALUES (@NewCharID,1,5,0, getdate(),getdate(),31458135,0) For Low Ram Computer - الكود:
-
USE([SRO_VT_SHARD]) GO() UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/3
Give 120 Mastry to Char - الكود:
-
USE [SRO_VT_SHARD] GO Declare @CharName Varchar (64) Set @CharName = 'ODY'
UPDATE [dbo].[_CharSkillMastery] SET Level= 110 WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) How to Make Devil Spirit Full Blue - الكود:
-
Put the Devil Sprit to charecter's bag and open SMC > SR_UserEdit > CharItem > Type the name of the character make a call. Later, search charecter bag and find the array of Devil Spirit item ID. Then use the following query.
Query : USE SRO_VT_SHARD UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898'WHERE ID64='HereITEMID' Insert From Txt - الكود:
-
DELETE FROM [SRO_VT_SHARD].[dbo].[_RefAbilityByItemOptLevel] /* Table TO Insert */ USE([SRO_VT_SHARD]) GO() BULK INSERT _RefAbilityByItemOptLevel FROM 'D:\S\_RefAbilityByItemOptLevel.txt' WITH (FIELDTERMINATOR = '\t') /* Taxt Place From ur Computer */
Insert Table From DB to DB - الكود:
-
USE SRO_VT_SHARD GO TRUNCATE TABLE [dbo].[_RefMonster_AssignedItemDrop] /* Your Table Name */ GO insert into SRO_VT_SHARD.dbo._RefMonster_AssignedItemDrop select * from SRO_VT_SHARD1.dbo._RefMonster_AssignedItemDrop /* Your Databse Name - Table Name - Other Database */
Add item to char - الكود:
-
USE SRO_VT_SHARD --Usage: --exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl declare @CharName varchar(64) set @CharName = '[GM] ODY'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_03',10000,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARENA_COIN',10000,1 Job EXP - الكود:
-
USE [SRO_VT_SHARD] DECLARE @Rate INT SET @Rate = '100' -- Rate here UPDATE [dbo].[_RefLevel] SET
[JobExp_Trader] = [JobExp_Trader]/@Rate , [JobExp_Robber] = [JobExp_Robber]/@Rate , [JobExp_Hunter] = [JobExp_Hunter]/@Rate WHERE [Lvl] BETWEEN 1 and 7
SELECT * FROM _RefLevel WHERE Lvl BETWEEN 1 AND 140; Last Log-in - الكود:
-
[center][u][b][font=Arial Black][size=24]Job EXP[/size][/font][/b][/u][/center]
[code]USE [SRO_VT_SHARD] DECLARE @Rate INT SET @Rate = '100' -- Rate here UPDATE [dbo].[_RefLevel] SET
[JobExp_Trader] = [JobExp_Trader]/@Rate , [JobExp_Robber] = [JobExp_Robber]/@Rate , [JobExp_Hunter] = [JobExp_Hunter]/@Rate WHERE [Lvl] BETWEEN 1 and 7
SELECT * FROM _RefLevel WHERE Lvl BETWEEN 1 AND 140; [/code]
Lucky Powder Rate 1 - الكود:
-
USE [SRO_VT_SHARD] DECLARE @RATE INT SET @RATE=1 UPDATE dbo._RefObjItem SET Param2=(Param2*@RATE) WHERE ID BETWEEN '2033' AND '2054' UPDATE dbo._RefObjItem SET Param3=(Param3*@RATE) WHERE ID BETWEEN '2033' AND '2054' UPDATE dbo._RefObjItem SET Param4=(Param4*@RATE) WHERE ID BETWEEN '2033' AND '2054' Max Stack Elixir - الكود:
-
use(SRO_VT_SHARD) Update(dbo._RefObjItem) MaxStack = 50 WHERE ID BETWEEN 3679 AND 3682
Querey To Ban Player By Char Name - الكود:
-
USE [SRO_VT_SHARD] GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere'--- --------------------------------- SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName) SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID) ----------------------------------------------------------------- USE SRO_VT_ACCOUNT DECLARE @ID VARCHAR (64) DECLARE @Reason VARCHAR(128) DECLARE @Begin DATETIME DECLARE @End DATETIME SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)
--------------------------------- SET @Reason = 'Ban Reason Here' SET @Begin = '2012-05-01 00:00:00.000' -- Time Begin -- SET @End = '2040-01-01 00:00:00.000' -- Time End -- --------------------------------- ---------------------------
INSERT [dbo].[_Punishment] ( [UserJID], [Type], [Executor], [Shard], [CharName], [CharInfo], [PosInfo] , [Guide], [Description], [RaiseTime], [BlockStartTime], [BlockEndTime], [PunishTime], [Status] ) VALUES ( @AccJID, 1, 1, 0, @CharName, 1, 1, @Reason, @Reason, @Begin, @Begin, @End, @End, 0); ---------------------------------------------------------- DECLARE @ReasonID INT SET @ReasonID = (Select SerialNo FROM _Punishment Where UserJID = @AccJID) ---------------------------------------------------------- INSERT [dbo].[_BlockedUser] ( [UserJID], [UserID], [Type], [SerialNo], [TimeBegin], [TimeEnd]) VALUES ( @AccJID, @ID, 1, @ReasonID, @Begin, @End);
----------------------------------------------------------------- SELECT StrUserID FROM TB_User WHERE JID = @AccJID ----------------------------------------------------------------- Ban IP - الكود:
-
USE [SRO_VT_SHARD] GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere'--- --------------------------------- SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName) SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID) ----------------------------------------------------------------- USE SRO_VT_ACCOUNT DECLARE @ID VARCHAR (64) DECLARE @Reason VARCHAR(128) DECLARE @Begin DATETIME DECLARE @End DATETIME SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID) --------------------------------- SET @Reason = 'Ban Reason Here' SET @Begin = '2012-05-01 00:00:00.000' -- Time Begin -- SET @End = '2040-01-01 00:00:00.000' -- Time End -- --------------------------------- --------------------------- INSERT [dbo].[_Punishment] ( [UserJID], [Type], [Executor], [Shard], [CharName], [CharInfo], [PosInfo] , [Guide], [Description], [RaiseTime], [BlockStartTime], [BlockEndTime], [PunishTime], [Status] ) VALUES ( @AccJID, 1, 1, 0, @CharName, 1, 1, @Reason, @Reason, @Begin, @Begin, @End, @End, 0); ---------------------------------------------------------- DECLARE @ReasonID INT SET @ReasonID = (Select SerialNo FROM _Punishment Where UserJID = @AccJID) ---------------------------------------------------------- INSERT [dbo].[_BlockedUser] ( [UserJID], [UserID], [Type], [SerialNo], [TimeBegin], [TimeEnd]) VALUES ( @AccJID, @ID, 1, @ReasonID, @Begin, @End); ----------------------------------------------------------------- SELECT StrUserID FROM TB_User WHERE JID = @AccJID ----------------------------------------------------------------- Query delete banned Player by char name - الكود:
-
USE [SRO_VT_SHARD] GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere'--- --------------------------------- SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName) SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID) -------------------------------- USE [SRO_VT_ACCOUNT] -------------------------------- DELETE FROM [dbo].[_BlockedUser] WHERE UserJID = @AccJID DELETE FROM [dbo].[_Punishment] WHERE UserJID = @AccJID
----------------------------------------------------------------- SELECT StrUserID FROM TB_User WHERE JID = @AccJID ----------------------------------------------------------------- Query change quest FGW for Degree13 - الكود:
-
USE SRO_VT_SHARD GO DECLARE @NewItem1 varchar(128) DECLARE @NewItem2 varchar(128) DECLARE @NewItem3 varchar(128) DECLARE @NewItem4 varchar(128) DECLARE @NewItem5 varchar(128) DECLARE @NewItem6 varchar(128) DECLARE @NewItem7 varchar(128) DECLARE @NewItem8 varchar(128) DECLARE @NewItem9 varchar(128) DECLARE @NewItem10 varchar(128) DECLARE @NewItem11 varchar(128) DECLARE @NewItem12 varchar(128) DECLARE @NewItem13 varchar(128) DECLARE @NewItem14 varchar(128) /* Script New Itens */ SET @NewItem1='ITEM_CH_SWORD_13_C_RARE' -- New Items SET @NewItem2='ITEM_CH_BLADE_13_C_RARE' -- New Items SET @NewItem3='ITEM_CH_SPEAR_13_C_RARE' -- New Items SET @NewItem4='ITEM_CH_TBLADE_13_C_RARE' -- New Items SET @NewItem5='ITEM_CH_BOW_13_C_RARE' -- New Items SET @NewItem6='ITEM_EU_SWORD_13_C_RARE' -- New Items SET @NewItem7='ITEM_EU_TSWORD_13_C_RARE' -- New Items SET @NewItem8='ITEM_EU_AXE_13_C_RARE' -- New Items SET @NewItem9='ITEM_EU_DAGGER_13_C_RARE' -- New Items SET @NewItem10='ITEM_EU_CROSSBOW_13_C_RARE' -- New Items SET @NewItem11='ITEM_EU_TSTAFF_13_C_RARE' -- New Items SET @NewItem12='ITEM_EU_DARKSTAFF_13_C_RARE' -- New Items SET @NewItem13='ITEM_EU_STAFF_13_C_RARE' -- New Items SET @NewItem14='ITEM_EU_HARP_13_C_RARE' -- New Items /* End Script New Itens */
/* Script Update New Itens */ UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem1 WHERE ItemCodeName='ITEM_CH_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem2 WHERE ItemCodeName='ITEM_CH_BLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem3 WHERE ItemCodeName='ITEM_CH_SPEAR_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem4 WHERE ItemCodeName='ITEM_CH_TBLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem5 WHERE ItemCodeName='ITEM_CH_BOW_11_SET_A_RARE' /*HeroSilkroad Revolution*/ UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem6 WHERE ItemCodeName='ITEM_EU_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem7 WHERE ItemCodeName='ITEM_EU_TSWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem8 WHERE ItemCodeName='ITEM_EU_AXE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem9 WHERE ItemCodeName='ITEM_EU_DAGGER_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem10 WHERE ItemCodeName='ITEM_EU_CROSSBOW_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem11 WHERE ItemCodeName='ITEM_EU_TSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem12 WHERE ItemCodeName='ITEM_EU_DARKSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem13 WHERE ItemCodeName='ITEM_EU_STAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems SET ItemCodeName=@Newitem14 WHERE ItemCodeName='ITEM_EU_HARP_11_SET_A_RARE' /* End Script Update New Itens */
/* Insert Shield Degree13 Europe and Chinese in quest Forgotten */ INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'ITEM_CH_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx') INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'ITEM_EU_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx') /* End insert Shield Degree13 Europe and Chinese in quest Forgotten */ Query To Active All Daggre - الكود:
-
UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID = 38620
Query Add Honor To Char - الكود:
-
USE [SRO_VT_SHARD] DECLARE @CharName Varchar (MAX) DECLARE @Graduates INT DECLARE @HonorPoints INT DECLARE @CharID INT DECLARE @CampID INT SET @CharName = '*[YourCharName]' SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID) SET @Graduates = '1234[Number Of Graduates] ' SET @HonorPoints= @Graduates * 39
--------------------
UPDATE [Dbo].[_TrainingCamp] SET GraduateCount = @Graduates WHERE [Dbo].[_TrainingCamp].[ID] = @CampID UPDATE [dbo].[_TrainingCampMember] SET HonorPoint = @HonorPoints WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID Query to back all item to +20 or change 20 to any thing you want - الكود:
-
UPDATE _Items SET OptLevel = 20 WHERE OptLevel BETWEEN '20' and '50' Query to Change Graduate and Honor Point - الكود:
-
USE [SRO_VT_SHARD] DECLARE @CharName Varchar (MAX) DECLARE @Graduates INT DECLARE @HonorPoints INT DECLARE @CharID INT DECLARE @CampID INT SET @CharName = 'Charname' SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID) SET @Graduates = '1234' SET @HonorPoints= @Graduates * 39
--------------------
UPDATE [Dbo].[_TrainingCamp] SET GraduateCount = @Graduates WHERE [Dbo].[_TrainingCamp].[ID] = @CampID UPDATE [dbo].[_TrainingCampMember] SET HonorPoint = @HonorPoints WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID Query to Show amount silk by User ID
Quote: USE [SRO_VT_ACCOUNT] SELECT * FROM SK_Silk WHERE JID = (SELECT JID FROM TB_USER WHERE StrUserID = 'xxx')
Query to Remove PK by CharName
Quote: USE [SRO_VT_SHARD] DECLARE @CharName Varchar(max) SET @CharName = 'Charname'
UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName Query To Change Pw Sql - الكود:
-
USE [master]
GO ALTER LOGIN [sa] WITH PASSWORD=N'New Password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO Query to Show amount silk by User ID - الكود:
-
USE [SRO_VT_ACCOUNT] SELECT * FROM SK_Silk WHERE JID = (SELECT JID FROM TB_USER WHERE StrUserID = 'xxx') Query To Show How Much GM In Your Game - الكود:
-
USE SRO_VT_ACCOUNT SELECT *FROM [dbo].[TB_User] WHERE sec_primary BETWEEN '1' and '1' Query to show hwanLevel (Zerk) change 1 and 10 to any thing you want - الكود:
-
USE SRO_VT_SHARD SELECT *FROM [dbo].[_Char] WHERE HwanLevel BETWEEN '1' and '10' Query for make item FB - الكود:
-
UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898'WHERE ID64='?TEM ID ' Remove All Skill By Char - الكود:
-
USE [SRO_VT_SHARD] GO Declare @CharName Varchar (64) Set @CharName = 'ODY'
UPDATE [dbo].[_CharSkill] SET CharID= 0 WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) Remove PK All Players - الكود:
-
USE([SRO_VT_SHARD]) UPDATE _Char SET DailyPK= 0, TotalPK= 0, PKPenaltyPoint = 0
Remove PK By Char Name - الكود:
-
USE [SRO_VT_SHARD] DECLARE @CharName Varchar(max) SET @CharName = 'ODY'
UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName
لو عاوز تمنع اي تريد اي ايتم بي سيلك - الكود:
-
UPDATE _RefObjCommon SET CanTrade = 0 WHERE Codename128 ='ITEM_MALL_GLOBAL_CHATTING' Search About Item in Char - الكود:
-
Use SRO_VT_SHARD Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF Right Join _Items As IT On IT.RefItemID = REF.ID Right Join _Inventory As INV On INV.ItemID = IT.ID64 Right Join _Char as CH On CH.CharID = INV.CharID Where CodeName128 like 'TSWORD_12_C_RARE' Query Clean All Database - الكود:
-
USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[Test_HN] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog] TRUNCATE TABLE [dbo].[SK_ItemSaleLog] TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog] TRUNCATE TABLE [dbo].[SK_PK_UpdateLog] TRUNCATE TABLE [dbo].[SK_ResetSkillLog] TRUNCATE TABLE [dbo].[SK_Silk] TRUNCATE TABLE [dbo].[SK_SilkBuyList] TRUNCATE TABLE [dbo].[SK_SilkGoods] TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_paygate_trans] --------- USE [SRO_VT_SHARD] GO truncate table _OpenMarket print 'Cleaned _OpenMarket' truncate table _CharSkill print 'Cleaned _CharSkill' truncate table _CharSkillMastery print 'Cleaned _CharSkillMastery' truncate table _GuildMember print 'Cleaned _GuildMember' truncate table _BlockedWhisperers print 'Cleaned _BlockedWhisperers' truncate table _Inventory print 'Cleaned _Inventory' truncate table _InventoryForAvatar print 'Cleaned _InventoryForAvatar' truncate table _InventoryForLinkedStorage print 'Cleaned _InventoryForLinkedStorage' truncate table _TrainingCampMember print 'Cleaned _TrainingCampMember' truncate table _TrainingCampSubMentorHonorPoint print 'Cleaned _TrainingCampSubMentorHonorPoint' update _TrainingCampHonorRank set CampID = NULL, Rank = NULL print 'Cleaned _TrainingCampHonorRank' truncate table _TrainingCampBuffStatus print 'Cleaned _TrainingCampBuffStatus' delete from _TrainingCamp print 'Cleaned _TrainingCamp' truncate table _StaticAvatar print 'Cleaned _StaticAvatar' truncate table _User print 'Cleaned _User' truncate table _Friend print 'Cleaned _Friend' truncate table _Memo print 'Cleaned _Memo' truncate table _TimedJob print 'Cleaned _TimedJob' truncate table _CharTrijobSafeTrade print 'Cleaned _CharTrijobSafeTrade' delete from _CharTrijob print 'Cleaned _CharTrijob' truncate table _InvCOS print 'Cleaned _InvCOS' delete from _CharCOS where ID > 0 print 'Cleaned _CharCOS' delete from _Char where charid > 0 print 'Cleaned _Char' truncate table _Chest print 'Cleaned _Chest' truncate table _ChestInfo print 'Cleaned _ChestInfo' truncate table _ItemPool print 'Cleaned _ItemPool' delete from _Items where ID64 > 0 print 'Cleaned _Items' delete from _AccountJID print 'Cleaned _AccountJID' update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 print 'Cleaned _AlliedClans' truncate table _GuildWar print 'Cleaned _GuildWar' truncate table _CharNameList print 'Cleaned _CharNameList' truncate table _CharQuest print 'Cleaned _CharQuest' truncate table _ClientConfig print 'Cleaned _ClientConfig' truncate table _DeletedChar print 'Cleaned _DeletedChar' truncate table _SiegeFortressStoneState print 'Cleaned _SiegeFortressStoneState' truncate table _SiegeFortressRequest print 'Cleaned _SiegeFortressRequest' truncate table _SiegeFortressObject print 'Cleaned _SiegeFortressObject' truncate table _SiegeFortressItemForge print 'Cleaned _SiegeFortressItemForge' truncate table _SiegeFortressBattleRecord print 'Cleaned _SiegeFortressBattleRecord' update _SiegeFortressStruct SET OwnerGuildID = '0' print 'Cleaned _SiegeFortressStruct' UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL print 'Cleaned _SiegeFortress' truncate table _CharNickNameList print 'Cleaned _CharNickNameList' truncate table _GPHistory print 'Cleaned _GPHistory' truncate table _GuildChest print 'Cleaned _GuildChest' delete from _Guild where ID > 0 print 'Cleaned _Guild' delete from _AlliedClans where ID > 0 print 'Cleaned _AlliedClans' ------ USE [SRO_VT_SHARDLOG] GO TRUNCATE TABLE [dbo].[_LogCashItem] TRUNCATE TABLE [dbo].[_LogEventChar] TRUNCATE TABLE [dbo].[_LogEventItem] TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] TRUNCATE TABLE [dbo].[_LogSchedule] TRUNCATE TABLE [dbo].[_LogServerEvent]
Query Clean Pservercms Database - الكود:
-
USE [pserverCMS] GO
TRUNCATE TABLE [dbo].[user] TRUNCATE TABLE [dbo].[user2role]
Query Clean Char - الكود:
-
Use [SRO_VT_SHARD] Update _Inventory Set ItemID = 0 Where CharID = (Select CharID From _Char Where CharName16 = 'char name') and Slot Between 13 and 200 Query Change Unique / NPC Spot - الكود:
-
USE [SRO_VT_SHARD] ----------------------------Made By ODY(ELGAML)---------------------------- 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 Query Off or On Skill -Off = 0 / On = 1- - الكود:
-
Use [SRO_VT_SHARD] GO
Update _RefSkill Set Service = 0 Where Basic_Code Like '%CODEHERE%'
Remove Blue Avatars from all players - الكود:
-
USE SRO_VT_SHARD UPDATE _Items SET MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE RefItemID in (SELECT ID FROM _RefObjCommon WHERE TypeID1 = 3 and TypeID2 = 1 and TypeID3 = 13 and TypeID4 in (1,2,3) and Country = 3) Remove drop from all unique - الكود:
-
USE SRO_VT_SHARD DELETE FROM _RefMonster_AssignedItemDrop where RefitemID like (Select ID From dbo._RefObjCommon Where CodeName128 like 'ITEM_EVENT_RENT_HWAN_POTION') Remove Premium From ALl Players - الكود:
-
DELETE FROM SRO_VT_SHARD.._TimedJob where JobID in (select ID from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%pre%') DELETE FROM SRO_VT_SHARD.._TimedJob where JobID in (select ID from SRO_VT_SHARD.._RefSkill where Basic_Code like '%pre%')
To Town Jangan By Char Name - الكود:
-
USE [SRO_VT_SHARD]
UPDATE _Char
SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 where CharName16 = 'CHAR NAME'
Add Unique Spot - الكود:
-
USE [SRO_VT_SHARD]
DECLARE @UNIQUE VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) DECLARE @mindealy INT DECLARE @maxdelay int DECLARE @INITRADIUS INT DECLARE @RADIUS int DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */ SET @UNIQUE = 'MOB_ARABIA_UNKNOWN_INT_12' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'ODY' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 1800 -- Minimum time before appears in seconds SET @maxdelay = 1800 -- Maximum time before appears in seconds SET @INITRADIUS = 100 -- Radius around spot unique can generated at SET @RADIUS = 600 -- Radius around spot Unique can move in /* end of settings area */
/* get ID of mob by code name */ Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES (@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE) SET IDENTITY_INSERT Tab_RefTactics OFF
SET IDENTITY_INSERT Tab_RefHive ON INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE) SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
SET IDENTITY_INSERT Tab_RefNest ON INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0) SET IDENTITY_INSERT Tab_RefNest OFF
print '' print '' print 'Done!'
| |
|