Account automatically deleted

Have you created a useful tool? or Do you want to get help building one? This is the right place!
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
r0x
Posts: 168
Joined: Sun Jul 26, 2009 10:13 pm
Location: Brazil

Account automatically deleted

Post by r0x »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4300
L2JDP Revision Number: 7517


my account activation system in php with this problem.
I create the account and active, but she disappears from the table "accounts".
the error is not in php, php and mysql server are 100% correct.
and protected against any inject.

I think the server is deleting the new records for some reason.

my php code:

Code: Select all

$id = antiInjection($_GET['id']);$sql = mysql_query ("SELECT * FROM usuarios WHERE confirmacao = '$id' AND registro = 0") or die(sql_error(mysql_error(),$doc_file));$sqlreg = mysql_num_rows($sql);if($sqlreg > 0){$sqlreg_user = mysql_result($sql,0,"login");$sqlreg_pass = l2j_encrypt(mysql_result($sql,0,"senha"));mysql_query("UPDATE usuarios SET confirmacao = '0', registro = '1' WHERE confirmacao = '$id'") or die(sql_error(mysql_error(),$doc_file));mysql_close($mysql_conn);include"include/mysql_l2j.php";mysql_query("INSERT INTO accounts VALUES ('$sqlreg_user','$sqlreg_pass','".time()."','0','$ip','0',null,null,null,null,null,null)") or die(sql_error(mysql_error(),$doc_file));}else{header("Location: /lineage2/erro.php");}
if anyone has any idea what might be, please post. (:

edit:
is not always what happens, but it happens very often
User avatar
r0x
Posts: 168
Joined: Sun Jul 26, 2009 10:13 pm
Location: Brazil

Re: Account automatically deleted

Post by r0x »

anyone have any idea what could be?
User avatar
r0x
Posts: 168
Joined: Sun Jul 26, 2009 10:13 pm
Location: Brazil

Re: Account automatically deleted

Post by r0x »

the problem continues and no one has a solution?
User avatar
r0x
Posts: 168
Joined: Sun Jul 26, 2009 10:13 pm
Location: Brazil

Re: Account automatically deleted

Post by r0x »

anyone? Oo
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: Account automatically deleted

Post by LasTravel »

Post Reply