Code: Select all
<?php
require('config.php');
require("inc/smtp.php");
$con = mysql_connect($adresa,$dbuser,$dbpass);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($numedb, $con);
$nick = $_POST["nickname"];
$password= $_POST["password"] ? md5($_POST["password"]) : '';
$servernr = $_POST["addtoserver"];
if ($servernr == 1) {
$svnum = "[Clasic]CS.XXX.RO:27015";
} elseif ($servernr == 2) {
$svnum = "[GunGame]CS.XXXU.RO:27018";
} elseif ($servernr == 11) {
$svnum = "[ZM Infection]CS.XXX.RO:27019";
} elseif ($servernr == 12) {
$svnum = "[ZM PLAGUE]WAR.XXX.RO:27015";
}
$q = "SELECT id FROM amx_amxadmins WHERE nickname='$nick'";
$result = mysql_query($q);
if ( mysql_num_rows ( $result ) > 0 )
{
$admin_id = mysql_result($result, 0, 'id');
$query = "SELECT server_id FROM amx_admins_servers WHERE admin_id=$admin_id";
$result = mysql_query($query);
$server_id = mysql_result($result, 0, 'server_id');
if ($server_id == $servernr)
die("<div style='width:574px; background-color:#121212; color:#bec923; padding:10px;'>Name <b>$nick</b> already exists on <b>$svnum</b></div>");
}
$add_to_client_query = "insert into amx_amxadmins (nickname, email, password, access, flags, steamid, username, icq, ashow, created, expired, days) values ('$_POST[nickname]','$_POST[email]','$password','b','a','$_POST[nickname]','','','1',UNIX_TIMESTAMP(),'0','0')";
mysql_query($add_to_client_query);
$adminid=mysql_insert_id();
$add_to_booking_query = "insert into amx_admins_servers (admin_id, server_id, custom_flags, use_static_bantime) values ('$adminid','$_POST[addtoserver]','','yes')";
mysql_query($add_to_booking_query);
mysql_close($con)
?>
this is my insert.php code. Now the problem is this:
for example i add player John only to server 1, after that i can`t add him again to server 1 because it tells me that he is already added. But if i add player the same john to server 2, after that i cand add duplicates of that name to server 1 and server 2 and i don`t know why