» 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");}
edit:
is not always what happens, but it happens very often