create account!

[xRAZOR [BR]]

when I try to use the command that javier passed this one ......

1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
Use account;
Go
Insert Into [TBL_USER] Values ('091014102755323, 'teste', 'teste', 'teste@teste', 'tester', 'teste')
Insert Into [USER_PROFILE] Values ('09101410275533','ID','Password','091014102755323 ','1','0','Y','01/01/2006 00:00:00',nul

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Anyone know where is wrong?

[Ultimo ☼]

Hope this help:

Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', '[COLOR="Red"]YOUR ID[/COLOR]', '[COLOR="red"]YOUR PASSW[/COLOR]', ' [COLOR="red"]YOUR E-Mail[/COLOR]', '[COLOR="red"]Secret Answer[/COLOR]', '[COLOR="red"]Secret Question[/COLOR]')
Insert Into [USER_PROFILE] Values ('09101410275532','[COLOR="red"]YOUR ID[/COLOR]','[COLOR="red"]YOUR HASHED Password[/COLOR]','801011000000','1','0','Y','01/01/2012 00:00:00',null,null,null,'000')

[xRAZOR [BR]]

thanks I will test if it works thank you come XD


EDIT!!!!
did not work use a clean DB gave this error here ;/

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values ​​does not match table definition.

[Ultimo ☼]

Try this:

Use account;
Go
Insert Into [TBL_USER] Values ('09101410275510', 'Razor', '12345x', ' ', 'rofl', 'lmao')
Insert Into [USER_PROFILE] Values ('09101410275510','Razor','143e5423f0efc15dd2050c8bed1297ab','801011000000','1','0','Y','01/01/2012 00:00:00',null,null,null,'000')

Account info are: ID: Razor Passw:12345x

[imissblood]

If you can't do it like that try this way. I made some SS.







To general the pw use this.

[Element~]

i think that is best if you use register.php :P

[freeskier4lif3]

lol... Does no one here read error messages?

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

This means that your table probably has a different number of fields than described. For example, if you're using OSDS janvier's script adds a field to USER_PROFILE.

to solve this, right click on dbo.USER_PROFILE and select "design" either take a screen shot or list what all your fields are. Then I can see what the actual issue with your script is. (TBL_USER is useless and only a security risk, you should just delete that from your database)

example of what you'll see when you click design. (this is on sql 2008 so yours may look a bit different)

[freeskier4lif3]

*double post: delete please.