Register for your free account! | Forgot your password?

You last visited: Today at 06:59

  • 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,132
Received Thanks: 608
[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 04/01/2015, 20:56   #2

 
elite*gold: 2
Join Date: Jan 2015
Posts: 1,261
Received Thanks: 776
I hate april. I hate you. I hate my life xD


Craine- is offline  
Thanks
2 Users
Old 04/01/2015, 21:02   #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 04/01/2015, 21:04   #4
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,132
Received Thanks: 608
Changelog:
added comments


Syloxx is offline  
Old 04/01/2015, 21:12   #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 04/01/2015, 21:19   #6



 
elite*gold: 894
Join Date: Sep 2013
Posts: 1,393
Received Thanks: 627
tschulian is offline  
Old 04/01/2015, 23:21   #7

 
elite*gold: 0
Join Date: Dec 2014
Posts: 358
Received Thanks: 524
quud jub menemenz
Apollo* is offline  
Old 04/02/2015, 06:23   #8
 
elite*gold: 480
Join Date: Jan 2012
Posts: 655
Received Thanks: 575
Thanks given, now I will comment.
Justin1337* is offline  
Old 04/02/2015, 09:03   #9
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,132
Received Thanks: 608
actually my "adding comments"

i mean i added comments to query not your post to that useless release
Syloxx is offline  
Old 04/02/2015, 12:38   #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



« [Release]Best I've seen Database SR-SRO | [HOT]Pionner Sro Database - Client - Website Files »

Similar Threads
register using sql query analyzer
07/31/2013 - Dekaron Private Server - 11 Replies
http://img203.imageshack.us/img203/7087/kwvx.jpgcan someone help me with register using query analyzer the secound password thing i need something to make it a cod please look at the photohttp://imageshack.us/photo/my-images/203/kwvx.jpg/
[Release] some useful Query's
09/29/2012 - SRO PServer Guides & Releases - 2 Replies
Query to Plvl Char Query to Change Graduate and Honor Point Query to Show amount silk by User ID
[Release] Query To Un-ban Account [Database]
08/04/2012 - SRO PServer Guides & Releases - 6 Replies
--By Leandro ( nukertube ) -- USE GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere'--- ---------------------------------
[Help] need help here register query error
01/22/2009 - EO PServer Hosting - 3 Replies
i cant querry my register account it has error when i run the queryy its says Table account.account doesnt exist. anyboby?



All times are GMT +1. The time now is 06:59.


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

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