Forsaken Website[Help]

[brent2121]

i used forsaken website but i got ann error

SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'OldPassword'., SQL state S0022 in SQLExecDirect in C:\xampp\htdocs\\register.php on line 34


i tried everthing replace oldpassword , insert new column oldpassword on mssql
nothung happen ,

anyone can fix this?

[Lumi]

Can you show us the the line where the error comes?

[brent2121]

Here's the line 34 that can cause error ,
and when i register icant login on the site ,on the account tbl this information not restored account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword,TempPassword cash

 Spoiler

odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword,TempPassword cash) VALUES (N\''.mssql_escape_string($_POST['reg_username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwdsalt'].$_POST['reg_password'])).'\', N\'T\', N\'A\', NULL, 0, N\'P\', NULL, 0, NULL, 0)');/

heres the line 35 ,where the user successfully register to insert the information that they register , but i cant to login

 Spoiler

odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, secession, email) VALUES (N\''.mssql_escape_string($_POST['reg_username']).'\', N\'A000\', N\'2\', N\'F\', \''.mssql_escape_string(date('Ymd H:i:s')).'\', N\'20010101\', N\'20990101\', N\'20050101\', N\'O\', NULL, N\''.mssql_escape_string($_POST['reg_email']).'\')');

[W.o.F]

it have readme.txt on that file?

make a column

TempPassword
and
OldPassword

[brent2121]

have no readme.text on the file

[W.o.F]

You can fix it just add TempPassword and OldPassword

by adding column

[brent2121]

i put OldPassword and Tempassword error

odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement., SQL state 21S01 in SQLExecDirect in C:\xampp\htdocs\ProjectX\register.php on line 34