>>> أكبر مكتبة 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