Register for your free account! | Forgot your password?

You last visited: Today at 02:39

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Ban Player with Charname

Discussion on [Release] Ban Player with Charname within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
Nexus7's Avatar
 
elite*gold: 0
Join Date: May 2006
Posts: 427
Received Thanks: 66
[Release] Ban Player with Charname

Code:
--By Nexus2oo7 --
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
-----------------------------------------------------------------
--By Nexus2oo7 --
Nexus7 is offline  
Thanks
1 User
Old 03/04/2013, 12:01   #2
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
Join Date: May 2008
Posts: 16,304
Received Thanks: 6,460
#approved
PortalDark is offline  
Reply


Similar Threads Similar Threads
[RELEASE]How to Ban IP By CharName :D
09/06/2016 - SRO PServer Guides & Releases - 10 Replies
:mofo: Credits to :handsdown:@Caipi:handsdown: query to create table to store the ip of the players USE Log_DB CREATE TABLE _IPLogs ( int IDENTITY(1,1) PRIMARY KEY, int, varchar(max), varchar(max), datetime
[Release]How to Ban Player By CharName (100% Work)
03/26/2015 - SRO PServer Guides & Releases - 5 Replies
It took almost three hours doing it! but worth it works 100% You only need to enter the name of the char time of the ban (I recommend leaving like this) Ban reason hey, please Click --By Leandro ( nukertube ) -- USE
[Release]How to Ban Player By CharName (100% Work)
05/13/2012 - SRO Private Server - 1 Replies
It took almost three hours doing it! but worth it works 100% You only need to enter the name of the char time of the ban (I recommend leaving like this) Ban reason Query To Unban Acc By CharName
[RELEASE] Ban by CharName SQL script
09/13/2011 - Shaiya PServer Development - 11 Replies
I'm releasing this to assist those having issues with the ban chat trigger not functioning. Its a simple script but infinitely useful on several scales. With this you can ban or unban accounts simply by inputting your desired Status and the CharName of the player in question. This includes ingoring the return on deleted toons as well. Check it out. UPDATE .. SET = 'NewStatus' WHERE UserUID = (SELECT UserUID FROM .. WHERE Del = 0 and CharName...
[Release]Give DP through CharName SQL
01/25/2011 - Shaiya PServer Guides & Releases - 11 Replies
I know this script is kind of silly, and probably badly coded, but I wanted to try. It works, so I thought I'd give it out to others. ._. USE PS_GameData DECLARE @CharName varchar(30), @UserUID int, @UserID varchar(18), @Point int, @Points int, @Point2 int



All times are GMT +1. The time now is 02:39.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.