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())
|