[RELEASE] Query Register Account

[Syloxx]

DECLARE @Username VARCHAR(16) = 'Username' --enter username
    , @Password VARCHAR(16) = 'Password' --enter password
    , @GM BIT = 0 --0 = normal user, 1 = GM
    , @MD5 VARCHAR(32)
    , @NewJID INT

/**_# get MD5 hash of password*/
SET @MD5 = CONVERT(VARCHAR(32), HashBytes('MD5', @Password) ,2)

/**_# insert user into user table*/
INSERT TB_User (StrUserID, [password], sec_primary, sec_content)
VALUES (@Username, @MD5, CASE WHEN @GM = 1 THEN 1 ELSE 3 END, CASE WHEN @GM = 1 THEN 1 ELSE 3 END)

/**_# get JID of the new user*/
SET @NewJID = SCOPE_IDENTITY()

/**_# insert user into silk table*/
INSERT INTO SK_Silk
VALUES (@NewJID, 0, 0, 0)

here that's how i do a April fool, useless **** is useless

[Aaron*]

I hate april. I hate you. I hate my life xD

[X-Vortex]

Originally Posted by Leonius*

I hate april. I hate you. I hate my life xD

I Agree With You

[Syloxx]

Changelog:
added comments

[X-Vortex]

Syloxx We Are Love You So We Add This Comments Don't Be Angry xD

[tschulian]

[Apollo*]

quud jub menemenz

[Justin1337*]

Thanks given, now I will comment.

[Syloxx]

actually my "adding comments"

i mean i added comments to query not your post to that useless release

[Gummieֆ']

Originally Posted by Syloxx

actually my "adding comments"

i mean i added comments to query not your post to that useless release

hhhhhhhhhhhh