[RELEASE] Query Register Account

Syloxx · 04/01/2015, 20:53

Code:

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