help with wesite

02/05/2018 10:42 dasaver#1
I am having a problem i have just about everything set up for the website. when i go to make an account for my flyff server it creates the account but it only creates the account in ACCOUNT_TBL_DETAIL and not in the ACCOUNT_TBL. so every time i go to log into this new account it says that the log in is incorrect because the account isnt in the ACCOUNT_TBL.
hoping someone can help me.
02/05/2018 10:50 _Halloween_#2
What happens, if you move it to the right path?
02/05/2018 11:04 dasaver#3
yes i was looking for how to do that i think this is the part i need to fix.

odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$checkacc = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_POST['reg_username']).'\'');
$checkmail = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL_DETAIL] WHERE email=\''.mssql_escape_string($_POST['reg_email']).'\'');
$errors = array();

but I dont know exactly what to change.
02/05/2018 11:23 xTwiLightx#4
It depends on how the website is creating the account.
Is it using a stored procedure? -> Edit the procedure in SQL to also insert values into the ACCOUNT_TBL.
Is is using raw queries in it's code? -> Edit the code to also insert values into the ACCOUNT_TBL.
02/05/2018 11:54 dasaver#5
I fixed it
thank you for your help.