Register for your free account! | Forgot your password?

Go Back   elitepvpers > Silkroad Online > SRO PServer - Discussions / Questions > SRO PServer Guides & Releases
You last visited: Today at 02:48

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

 

[Release]How to Ban Player By CharName (100% Work)

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2010
Posts: 523
Received Thanks: 139
Thumbs up [Release]How to Ban Player By CharName (100% Work)

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 [THANKS]
PHP Code:
--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[email protected]CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID[email protected]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 Leandro nukertube ) -- 
Edited ->Querry To Unban Acc By CharName
PHP Code:
--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[email protected]CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID[email protected]ChrID)
--------------------------------
USE [
SRO_VT_ACCOUNT]
--------------------------------
DELETE FROM [dbo].[_BlockedUser]
WHERE UserJID = @AccJID
DELETE FROM 
[dbo].[_Punishment]
WHERE UserJID = @AccJID

--By Leandro nukertube ) --  

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

the results box will appear banned player ID to facilitate the Disconect



PLZZ CLICK [THANKS]



xxnukertube is offline  
Thanks
3 Users
Old   #2
 
elite*gold: 0
Join Date: Apr 2009
Posts: 1,245
Received Thanks: 245
Thanks useful, but I lol'ed at this


Quote:
Originally Posted by xxnukertube View Post
F*.CK Joymax, Search for private server
and ur nick

xxnukertube
JOYMAX MANAGER


xDD


bubabuba is offline  
Old   #3
 
elite*gold: 0
Join Date: May 2010
Posts: 523
Received Thanks: 139
zuaaaaaaaaahahahahahahahaha >D

i'm Crazy

hhhhhhhh


i'm Add Querry To Unban Player
xxnukertube is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: May 2010
Posts: 523
Received Thanks: 139
EDITED --~(Not For Kids)


IP:
Port:Version:

and

Max Lvl 120 ( Cap Item 13 Degree, Cap Skill 120)
Free Silks
XP/SP Individual:XP/SP Party:Drop:Gold:
Fortress War Days:


Don't H'ave 60% resurrection scroll and 100% resurrection scroll Free

Events All Days

Itens, etc.

[GM]BlackBerry -


COMMING SOON Evolust SRO 2 (Ezma Files)
COMMING SOON Evolust SRO 3 (Ezma Files Cap 90)


xxnukertube is offline  
Old   #5
 
elite*gold: 0
Join Date: Feb 2015
Posts: 75
Received Thanks: 14
nice
marko1000 is offline  
Old   #6
 
elite*gold: 0
Join Date: Jun 2010
Posts: 49
Received Thanks: 2
xD


xxxnukertube is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[RELEASE] Ban by CharName SQL script
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...
11 Replies - Shaiya PServer Development
Experienced player looking for work as [GS], [GMA], or [GM]
Hello, I am an experienced Shaiya Player and Staff Member, i have almost 5 years of total Experience playing shaiya. I have almost 2 years...
3 Replies - Shaiya Private Server
[Release]Give DP through CharName SQL
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...
11 Replies - Shaiya PServer Guides & Releases
Paar Kleinigkeiten Release (GM faken; Lšngeren Charname)
So ich geb das hier in die Discussions-Section da ich finde das es nicht wirklich viel von nem Release hat. Nr1 Lšngeren Charname fangen...
0 Replies - Metin2 PServer - Discussions / Questions



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


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.