Edit/Delete Message Reply With Quote Multi-Quote This Message Quick reply to this message #1
Hello i have problem with sms plugin.
i use fortumo sms services
Everything works but there are little bug with when anyone makes admin in server (id1) and wanna make admin in server2 (id2) with same name he maked id1. then mysql database not make admin in server2 (id2) but adding more admin time to server id1 admin.
Everything works ok if u dont use same names when sending sms to server1 and server2..
both are using 1 mysql database..
Sorry my bad english im from Estonian
And thanks.
PHP Code:
<?php
function createRandomPassword() {
$chars = "abcdefghijkmnopqrstuvwxyz0123456789";
srand((double)microtime()*1000000);
$i = 0;
$pass = '' ;
while ($i <= 6) {
$num = rand() % 33;
$tmp = substr($chars, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
$nimi =
$_GET['message'];
$db_host =
"localhost"; // MySQL Serveri URL/IP
$db_name =
"amxbans"; // MySQL Andmebaas
$db_user =
"username"; // MySQL Konto
$db_pass =
"password"; // MySQLi Parool
$access =
"bitn"; // Õigused, mis SMSi saatjale antakse.
$reply_noname =
"Viga: Te ei sisestanud nime!"; // Viga, mida kuvatakse SMSi saatjale, kui ta ei sisestanud nime
$reply_error =
"Viga: Skriptis esines viga, v6ta yhendust:www.oika-servers.eu."; // Viga, mida kuvatakse SMSi saatjale, kui skriptis on sees viga
$days =
30; // Mitu päeva kestab SMS pakett
$created =
mktime();
$expires =
$created + $days*86400;
$ashow =
1; // Kas näitab admini listis?
$flags =
"ab";
$parool2 =
createRandomPassword(); // Loob parooli, mis kuvatakse SMSi saatjale.
$parool =
md5($parool2); // Sama asi mis $parool2, kuid see pannakse MYSQL andmebaasi md5 cryptiga.
$server_id =
2; // Serveri ID, kuhu antakse õigused
$add_or_new =
0;
mysql_connect(
$db_host,
$db_user,
$db_pass); // Ühendame MySQLiga
mysql_select_db(
$db_name); // Valime andmebaasi
$result = mysql_query("SELECT * FROM amx_amxadmins WHERE username='$nimi'");
$row = mysql_fetch_array($result);
if (!$nimi) // Kui nime ei sisestatud SMSi
{
$endreply = "Te ei sisestanud nime!";
echo $endreply;
exit;
}
if (!$row) // Kui pole kehtivat admini staatust, siis lisame mysql kirje
{
mysql_query("INSERT INTO `amx_amxadmins` (username, password, access, flags, steamid, nickname, ashow, created, expired, days) VALUES('$nimi', '$parool', '$access', '$flags', '$nimi', '$nimi', '$ashow', '$created', '$expires', '$days')") or die($reply_error);
$adminid = mysql_insert_id();
mysql_query("INSERT INTO `amx_admins_servers` (admin_id, server_id) VALUES ('$adminid', '$server_id')") or die($reply_error);
$endreply = "T寡me! Tellisite endale vip ******************sed ****************** surfpubi. Nimi:'$nimi' Parool:'$parool2'";
}
else // Kui on kehtiv admini staatus
{
$dayz = 30;
$g_admin_expire = mktime() + $dayz*86400;
$vana_days = $row['days'];
$vana_expired = $row['expired'];
$vana_created = $row['created'];
$kokku = $vana_expired - $vana_created;
$kokku2 = $g_admin_expire + $kokku;
$days = $dayz + $vana_days;
mysql_query("UPDATE amx_amxadmins SET access='$access', expired='$kokku2', days='$days' WHERE username='$nimi'") or die($reply_error);
$endreply = "T寡me! Pikendasite ****************** vipi aega 30 p妶a v******************. Teil on n******************vip staatus $days p妶a.";
}
echo $endreply; // Saadame vastus SMSi.
?>
i can help you in private ;p
please 
Linear Mode
