I am a bit dizzy now
@silkbotter
1.using your 1 click- registration in my IP and from my friends house elsewhere is easy
but when I did a dedicated server with dynamic IP after following Warmongers tut on server installation & database configuration,after port forwarding game and http values in my router, after installing xampp, after configuring the ini.s in the HTDOC, I get an error after I hit SUBMIT button in the register.php?? HERES THE ERROR:
Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_user'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\register.php on line 34
Warning: odbc_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\register.php on line 35
Warning: odbc_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\register.php on line 36
Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'user_profile'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\register.php on line 81
Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_user'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\register.php on line 82
NOTE: I am able to register an account through SQL Analyser through warmongers tut, and made a [GM]account succesfully..Only problem is when using your registration.php when you hit SUBMIT. It gives error and It does not even register in the Database/account/table/tbl_user.. i made a link of account in ODBC following warmongers tut. Succesfull registration with his. Kindly enlighten me, thanks..
EDIT:
OKAY I find the right answer
- GO BACK TO YOUR ODBC/SYSTEM DSN/next-->next-->login/pw(this is ur database user/pw in register.php)--NEXT-->"CHANGE DEFAULT DATABASE WINDOW, choose "ACCOUNT" -->next-->FINISH
refresh database server (right click small server icon in taskbar, choose OPEN SQL SERVERMANAGER then click refresh..after refresh..type again in the browser http:/[your localhost]/register.php...fill up the form then click SUBMIT, now everyting should be succesful...CHECK ur Enterprise Manager / Database / Account / Table / tbl_user (right click that), open tables/ return all rows..YOU SHOULD BE ABLE TO SEE WHAT YOU ENTERED IN THE REGISTER.php ^_^..it works for me.