Newbie Spellweaver
- Joined
- Feb 22, 2006
- Messages
- 22
- Reaction score
- 1
On the account part from the query below how do we create a user and password and is the User & PW have to be the same as the one "sa" or it could be different
how do you create a User & PW from this code, i am should on which parts should you change it bit confusing me
Code:
Use account;
Go
---Account Query By Warmonger---
DECLARE userNO varchar(16), accountID varchar(16), PASsword varchar(32), email varchar(50), secretA varchar(22), secretQ varchar(22)
SET userNO= '09101410275532'
SET accountID = 'Account ID'
SET PASsword = 'Account Password'
SET email = 'E-Mail'
SET secretA = 'Secret Answer'
SET secretQ = 'Secret Question'
Insert Into [USER_PROFILE] Values userNO accountID PASsword,'801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')
Use account;
Go
---Account Query By Warmonger---
DECLARE [USER=1335]user[/USER]NO varchar(16), [USER=162874]account[/USER]ID varchar(16), [USER=1333464713]PAS[/USER]sword varchar(32), [USER=213273]email[/USER] varchar(50), [USER=38426]secret[/USER]A varchar(22), [USER=38426]secret[/USER]Q varchar(22)
SET [USER=1335]user[/USER]NO= '[COLOR="#FF0000"]1[/COLOR]'
SET [USER=162874]account[/USER]ID = '[COLOR="#FF0000"]Farrol[/COLOR]'
SET [USER=1333464713]PAS[/USER]sword = '[COLOR="#FF0000"]008c5926ca861023c1d2a36653fd88e2[/COLOR]'
SET [USER=213273]email[/USER] = '[COLOR="#FF0000"]asd[/COLOR]'
SET [USER=38426]secret[/USER]A = '[COLOR="#FF0000"]asd[/COLOR]'
SET [USER=38426]secret[/USER]Q = '[COLOR="#FF0000"]asd[/COLOR]'
Insert Into [USER_PROFILE] Values [USER=1335]user[/USER]NO [USER=162874]account[/USER]ID [USER=1333464713]PAS[/USER]sword,'801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')
REMOVED
Anyone know how to fix this?! , help me please.