		elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
banear per time is update for leavejoin

You last visited: Today at 01:33

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

Advertise with us!

banear per time is update for leavejoin

Discussion on banear per time is update for leavejoin within the Shaiya PServer Development forum part of the Shaiya Private Server category.

02/17/2021, 15:51

jvczxc

elite*gold: 0

The Black Market: 0/0/0

Join Date: May 2012

Posts: 35

Received Thanks: 11

banear per time is update for leavejoin

Easy if you want to ban someone for longer than we thought.

For 10-year-old ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(year, +10, GETDATE()) WHERE UserID =''

For 10-day ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(day, +10, GETDATE()) WHERE UserID =''

For 10-hour ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(hour, +10, GETDATE()) WHERE UserID =''

For 10-minute ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(minute, +10, GETDATE()) WHERE UserID =''

For 10-week ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(week, +10, GETDATE()) WHERE UserID =''

For 10-Months ban

Quote:

UPDATE PS_UserData.dbo.Users_Master SET [LeaveDate]=DATEADD(month, +10, GETDATE())

Thanks

2 Users

« Español / Ingles Script auto | Illegal Anti GM Script, Illegal Permanent Anti-Desbaneo and Anti-Inject registration. »

Similar Threads
Update user_master every time the player enters the game, update to current ip (Help 09/09/2019 - Shaiya PServer Development - 1 Replies I noticed that during the registration on shaiya server, goes to table user_master the ip performed in the registration. Knowing that players' IP can change frequently, I tried to write a procedure, that whenever the player enters the game, the ip is updated to the current IP This is the code I wrote in an attempt to do this functionality, but it is not working, someone with more experience in sql can help I will enjoy it :) IF ( ActionType = 107 ) BEGIN
[QUESTION] skill time/regen time pointer 12/10/2008 - Ace Online / AirRivals - 0 Replies hi question is: how to change all skill timer/regen timer at once and static addresses in ayoris trainer there are boxes for it but i am using the EU version and there they do not work i also wrote into the RA root address topic that i can't find it for EU (i know how to get pointers and how to single edit skills/weapons/radar/etc) i already found some static addresses but they do not work ^^
Suche Game Time Card oder sonst wie Game Time 10/04/2008 - World of Warcraft Trading - 0 Replies Topic sagt alles. Brauche Game Time für meinen WoW Account :)
Removed Time on TIME QUEST. 01/09/2008 - 9Dragons - 4 Replies Like the title said, if you have a quest that required time to pass the QUEST will you can do this.. Ex. If you are Demon the GC8 is the very difficult quest if no healer helping on you. If you deside to get that quest, will after you talk to WU YUNYAN he will tele you to the DEMON CLAN Place. then you will see some Animation, after that you are now Near to the DMEON BULL and he says that you will get schimeraHORN, it is very difficult to get 5 BloodChimeraHorn in 5mins. This...
Lucky Time HACK, for when u get lucky time 10/24/2006 - CO2 Exploits, Hacks & Tools - 6 Replies when u go sit in guys thing given lucky time, light off firecracker to do another emotion becuse when doing it, it wont let, so lightfirecracker, then sit, when he leaves, ull still be getting lucky time

All times are GMT +1. The time now is 01:34.