Register for your free account! | Forgot your password?

You last visited: Today at 19:45

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

 

[RELEASE] Query Register Account

Reply
 
Old   #1
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
[RELEASE] Query Register Account

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



Syloxx is offline  
Thanks
3 Users
Old   #2

 
elite*gold: 0
Join Date: Jan 2015
Posts: 1,233
Received Thanks: 686
I hate april. I hate you. I hate my life xD


Craine- is offline  
Thanks
2 Users
Old   #3
 
elite*gold: 0
Join Date: Jan 2015
Posts: 94
Received Thanks: 115
Quote:
Originally Posted by Leonius* View Post
I hate april. I hate you. I hate my life xD
I Agree With You
X-Vortex is offline  
Old   #4
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
Changelog:
added comments


Syloxx is offline  
Old   #5
 
elite*gold: 0
Join Date: Jan 2015
Posts: 94
Received Thanks: 115
Syloxx We Are Love You So We Add This Comments Don't Be Angry xD
X-Vortex is offline  
Old   #6


 
elite*gold: 894
Join Date: Sep 2013
Posts: 1,390
Received Thanks: 624
tschulian is offline  
Old   #7

 
elite*gold: 0
Join Date: Dec 2014
Posts: 332
Received Thanks: 499
quud jub menemenz
Apollo* is offline  
Old   #8
 
elite*gold: 480
Join Date: Jan 2012
Posts: 654
Received Thanks: 574
Thanks given, now I will comment.
Justin1337* is offline  
Old   #9
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
actually my "adding comments"

i mean i added comments to query not your post to that useless release
Syloxx is offline  
Old   #10
 
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
Quote:
Originally Posted by Syloxx View Post
actually my "adding comments"

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


Gummieֆ' is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
register using sql query analyzer
http://img203.imageshack.us/img203/7087/kwvx.jpgcan someone help me with register using query analyzer the secound password thing i need something to...
11 Replies - Dekaron Private Server
[Release] some useful Query's
Query to Plvl Char Query to Change Graduate and Honor Point Query to Show amount silk by User ID
2 Replies - SRO PServer Guides & Releases
[Release] Query To Un-ban Account [Database]
--By Leandro ( nukertube ) -- USE GO -------------------------------- DECLARE @ChrID INT; ...
6 Replies - SRO PServer Guides & Releases
[Help] need help here register query error
i cant querry my register account it has error when i run the queryy its says Table account.account doesnt exist. anyboby?
3 Replies - EO PServer Hosting



All times are GMT +1. The time now is 19:45.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.