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 14:58

  • 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: 561
Received Thanks: 154
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 05/13/2012, 00:45   #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 05/13/2012, 10:22   #3
 
elite*gold: 0
Join Date: May 2010
Posts: 561
Received Thanks: 154
zuaaaaaaaaahahahahahahahaha >D

i'm Crazy

hhhhhhhh


i'm Add Querry To Unban Player
xxnukertube is offline  
Thanks
1 User
Old 05/17/2012, 22:17   #4
 
elite*gold: 0
Join Date: May 2010
Posts: 561
Received Thanks: 154
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 03/08/2015, 23:20   #5
 
elite*gold: 0
Join Date: Feb 2015
Posts: 80
Received Thanks: 14
nice
marko1000 is offline  
Old 03/26/2015, 19:18   #6
 
elite*gold: 0
Join Date: Jun 2010
Posts: 49
Received Thanks: 2
xD


xxxnukertube is offline  
Reply



« [Release] EmergencySRO Website | Adv c & d & s »

Similar Threads
[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...
Experienced player looking for work as [GS], [GMA], or [GM]
06/15/2011 - Shaiya Private Server - 3 Replies
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 Experience as a . I have a little over 1 year Experience as a . and i have about 6 months experience as a . I have played OS, Sinful Shaiya ( where i was a ), briefly Chaotic Shaiya ( where i was a or whichever you prefer, and i had started my own server in which i was a but had to move so sold all my server equipment. i have also played on...
[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
Paar Kleinigkeiten Release (GM faken; Längeren Charname)
08/19/2010 - Metin2 PServer - Discussions / Questions - 0 Replies
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 wir an ~~ locale_de.epk entpacken (erklär ich nicht extra) nun haben wir einen Source/locale/de/ui Ordner (bei bereits entpackten clients einfach in locale/de/ui reingehen)



All times are GMT +1. The time now is 14:58.


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

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