[BomBom]

1- استخدم دى

--By Geo ( Adel ) --
USE [SRO_VT_SHARD] 
GO
-------------------------------- 
DECLARE @ChrID INT; 
DECLARE @Char**** VARCHAR(64); 
DECLARE @AccJID INT; 
---------------------------------
SET @Char**** = 'Char'
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE Char****16=@Char****)
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],
[Char****],
[CharInfo],
[PosInfo] ,
[Guide],
[De******ion],
[RaiseTime],
[BlockStartTime],
[BlockEndTime],
[PunishTime],
[Status]
)
VALUES 
(
@AccJID,
1,
1,
0,
@Char****,
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
-----------------------------------------------------------------
--By Geo ( Adel ) --

للunblock استخدم دى

-By Geo ( Adel ) --
USE [SRO_VT_SHARD] 
GO
-------------------------------- 
DECLARE @ChrID INT; 
DECLARE @Char**** VARCHAR(64); 
DECLARE @AccJID INT; 
---------------------------------
SET @Char**** = 'Char'
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE Char****16=@Char****)
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

--By Geo ( Adel ) -- 

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------

بالنسبة لل Drop استخدم دى

USE SRO_VT_SHARD -----> ( MaDenGo ) <-----
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50% 
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop


INSERT _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, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

عشان تعرف كود ال mob

Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'

عشان تعرف كود ال item

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'