|
You last visited: Today at 02:39
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.
03/04/2013, 08:58
|
#1
|
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 --
|
|
|
03/04/2013, 12:01
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,304
Received Thanks: 6,460
|
#approved
|
|
|
|
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.
|
|