[Tutorial] How to block accounts using DB

[hemaprince]

Hi again RageZone
another tutorial for blocking account using database
at table C9Unity ->Admin->TblAccountBlock

all u need to do is excute this code

USE [C9Unity]
GO


DECLARE @pBlockHisNo bigint


EXEC [Admin].[UspSetBlock]
@pAccNo = 1,--put here account no u want to block
@pDesc='ur own description here',-- ur own description
@pDateEnd = N'2015-12-28 23:59',--when will the block auto end
@pReasonCode = 22,--reason code from list
@pBlockType = 19,--block type from list
--unkown yet--
@pAttachAccId=1,-- related to TblAccountBlockHistory table but i dnt know its usage hehe
@pChatBlkLeft = 0,--as he blocked and cant enter his account why chat block !!!
@pBoardBlkLeft = 0,--rekated to forum block which here i think its useless
@pBlockHisNo = @pBlockHisNo OUTPUT


GO

here is a list of block type

1 banned from posting in the fourms for 1 hour
2 banned from posting in the fourms for 3 hours
3 banned from posting in the fourms for 5 hours
4 banned from posting in the fourms for 1 day
5 banned from posting in the fourms for 3 days
6 banned from posting in the fourms for 5 days
7 You are banned from posting chat messages for 1 hour.
8 You are banned from posting chat messages for 3 hours.
9 You are banned from posting chat messages for 5 hours.
10 You are banned from posting chat messages for 1 day.
11 You are banned from posting chat messages for 3 days.
12 You are banned from posting chat messages for 5 days.
13 Your account has been suspended for 1 days.
14 Your account has been suspended for 3 days.
15 Your account has been suspended for 5 days.
16 Your account has been suspended for 10 days.
17 Your account has been suspended for 15 days.
18 Your account has been suspended for 30 days.
19 Your account has been permanently suspended.
20 This account has been suspended by your own request.
21 Your account has been suspended for 7 days.
22 Your account has been blocked for 30 min.

block reason code

1 revealing personal information2 Hacking or sabotaging game servers or webpages
3 interrupting other players or acting inappropriately
4 Trading accounts
5 Stealing accounts
6 Suspicion of account theft
7 Using an inappropriate name (character name, guild name, or title)
8 Using illegal software
9 Distributing illegal software
10 Fraud
11 Impersonation
12 Identity theft
13 Commercial advertising
14 Abusing or extorting systems or bugs
15 Foul language, slander, or insults
16 Displaying obscene content
17 Malicious actions intended to sabotage others
17 Spamming chat window
18 False reports
19 Cash trades
20 Spamming game forums
21 Sabotaging game management
22 Other

note : dnt put another codes or client will crash when user login with his account (as in my case)
strings from gamestring file u can modify it
--if i helped like & rep+ tt1:tt1:tt1:

 

[CrazyGuardian]

thanks

 

[Oraclebr]

nice !

 

[Tcheckella]

Nice , thank you !