>>> أكبر مكتبة SQL- Query <<<

[[MoDa]]

Search About item on char

Use SRO_VT_SHARD GO ----------------------------------- 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'

Teleport All Players to Char name

USE SRO_VT_SHARD GO ---------------------------------------------------------------------- DECLARE @CHARNAME Varchar (18) ----------------------------------------------------------------------- SET @CHARNAME = 'Player' -- Type Charname Here ----------------------------------------------------------------------- DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME) DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) ------------------------------------------------------------------------ UPDATE [dbo].[_Char] SET PosX = @POSX2, PosY = @POSY2, PosZ = @POSZ2, LatestRegion = @REGION2, WorldID = @WORLDID

Delete item from all players

USE [SRO_VT_SHARD] GO ------------------------------- Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM Code Name' ] --Type Here Code Name

Add Silk to all players

INSERT INTO SK_SILK (JID, silk_own, silk_gift, silk_point) SELECT JID, '0', '0', '0' FROM TB_User WHERE not exists (select * from SK_Silk WHERE SK_SILK.JID = TB_User.JID); -------------------------------------------------------- UPDATE SK_Silk SET silk_own=silk_own+10 --Change +10 To Amount You Want

Ban Player

USE [SRO_VT_SHARD] GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere' ---type Charname --------------------------------- 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 -----------------------------------------------------------------

Remove PK By Char Name

USE [SRO_VT_SHARD] GO ------------------------------ DECLARE @CharName Varchar(max) ------------------------------ SET @CharName = 'Player' --Type Player Name Here ------------------------------ UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName