ازاى اعمل بان ip

[ღ♥_iMoRy_♥ღ]

فيورى او اى حاجة

[N00b™]

كود PHP:

USE [SRO_VT_SHARD]
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @Char**** VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @Char**** = 'Char****Here'---
---------------------------------
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 


-----------------------------------------------------------------

كود PHP:

UnBan

USE [SRO_VT_SHARD]
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @Char**** VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @Char**** = 'Char****Here'---
---------------------------------
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



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


[Dallin]

او ممكن من ال filezile لو عندك

[ღ♥_iMoRy_♥ღ]

عندى بس ازاى بان ip

[Arafa]

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 
----------------------------------------------------------------- 
  

....................................................

un ban

--By Leandro ( nukertube ) -- 
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 
-----------------------------------------------------------------

[ღ♥_iMoRy_♥ღ]

يا جماعة بان ip
مش بان id

[ღ♥_iMoRy_♥ღ]

# thx