here a small tip to fix the registration with using my registration script
Open your SQL Server Enterprise Manager , go to the Database account , search table Tbl_user and USER_PROFILE , make a right click on it and click to Design Table.
Edit the Data Type of user_no to int and NOT allowed nulls, and set primary key on it.
change Identity to Yes and save the tables.
close Enterprise Manager.
Open now the mssql_register.php and search this :
PHP Code:
$result = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE ORDER BY user_no DESC",$con); $row = mssql_fetch_row($result); $row[0] = $row[0]+1;
and Delete it , now search :
PHP Code:
mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('".$row[0]."','".$_POST['accname']."','".$accpass."','801011000000','1','0','Y','".$date."',null,null,null,'000')",$con); mssql_query("INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('".$row[0]."','".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','".$_POST['accquest']."','".$_POST['accansw']."')",$con);
and edit it to :
PHP Code:
mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('".$_POST['accname']."','".$accpass."','801011000000','1','0','Y','".$date."',null,null,null,'000')",$con); mssql_query("INSERT INTO account.dbo.Tbl_user (user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','".$_POST['accquest']."','".$_POST['accansw']."')",$con);
Save it and ready.
For ODBC :
Search this :
PHP Code:
$result = odbc_exec($odbc_acc_con,"SELECT user_no FROM account.dbo.USER_PROFILE ORDER BY user_no DESC"); $row = odbc_result($result,1); $row = $row+1;
and delete it.
now search this :
PHP Code:
odbc_exec($odbc_acc_con,"INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('".$row."','".$_POST['accname']."','".$accpass."','0','1','0','Y',null,null,null,null,'000')"); odbc_exec($odbc_acc_con,"INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('".$row."','".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','".$_POST['accquest']."','".$_POST['accansw']."')");
and edit it to :
PHP Code:
odbc_exec($odbc_acc_con,"INSERT INTO account.dbo.USER_PROFILE (user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('".$_POST['accname']."','".$accpass."','0','1','0','Y',null,null,null,null,'000')"); odbc_exec($odbc_acc_con,"INSERT INTO account.dbo.Tbl_user (user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','".$_POST['accquest']."','".$_POST['accansw']."')");
Save and ready.
You will no more have problems with two and more double user_no's
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'user_no', table 'account.dbo.USER_PROFILE'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecDirect in E:\***\***\***\odbc_register.php on line 50
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'user_no', table 'account.dbo.Tbl_user'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecDirect in E:\***\***\***\odbc_register.php on line 51
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'user_no', table 'account.dbo.USER_PROFILE'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecDirect in E:\***\***\***\odbc_register.php on line 50
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'user_no', table 'account.dbo.Tbl_user'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecDirect in E:\***\***\***\odbc_register.php on line 51
with the fixed version?? DUDE any of his script are done and work perfectly I guess its just your bad setup. Take a look at everything back again and you'll maybe find where did you failed good luck
After i have edited what was said i got that new error, before that user_no dublicated. So i did everything ok, I have deleted that 3 rows and changed those 2 rows to the new ones. What could be wrong? i know what i do And look at the error it says that "can not put null into the column" or something like that.
Open your SQL Server Enterprise Manager , go to the Database account , search table Tbl_user and USER_PROFILE , make a right click on it and click to Design Table.
Edit the [B]Data Type[/B] of [B]user_no[/B] to [B]int[/B] and [B]NOT allowed nulls[/B], and [B]set primary key[/B] on it.
change [B]Identity[/B] to [B]Yes[/B] and [B]save the tables[/B].
close Enterprise Manager.
ah the stupid guy with his stupid n00b server
he banned me for playn on 2 computer
well,gl with ur retarted server
What do you have for problems?
I dont have ban anyone for play with two accounts , but its right , on our server it is not allowed to play on 2 accounts to the self time in the self party. You can play with 2 accounts , but not in a party with your self.
Search for a Ransack script/bot 06/09/2010 - Archlord - 13 Replies Hi all,
I want to do alchemie up to rank level 10 and i need a lot of material for it.
I have not a lot of money to buy the material and the collecting takes a lot of time -.- I want to ask you if someone can make a working script/or bot for it OR someone know a working Bot/script at the moment.
Please sent me a pm.
Thanks ;-)
Sorry for my bad english ;-(
Search PHP-Script for checking PSC 12/09/2009 - Web Development - 4 Replies Hello,
i had a PHP Script to check the cash of a paysafecard, but since the psc website update its not working anymore.
It checked the psc and set a password on it.
So i ask here, if someone has a working psc script.
I could pay money for it, if you want (but only if it is really working.. i need a proof)
If someine has such a script, please help me :P
Best regards, nico
[Big-Search] Ideas for Conquer 04/18/2009 - CO2 Private Server - 16 Replies hey im creating a new source based on infamousnoones source.
ofcourse i can just use the basic quests and ideas of the orriginal conquer but i would like to know the ideas that the people want and some totally new quests.
please be detailed so everyone can understand, when my source is done i will call it "EPVPs Reflexis Source" and yes it will be free to download.
so let your fantasie working and tell me all the good ideas you have and ill try to make them come true;)
Goodbye, and...
Search Script for Summoner 05/24/2005 - Lineage 2 - 1 Replies Someone can help me please, i don't know how make script for Summoner on L2 walker.... Thks very much
Merci
