01.06.2011, 14:45
Hello all, I want to make only 2 accounts for one ip. I tried to do it, but I can create up to 2 accounts =/
pawn Код:
new Query[131];
format(Query, 85, "SELECT VARDAS FROM `zaidejudb` WHERE `Vardas`='%s' LIMIT 2", EscapeName(playerid));
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows())
{
format(Query, 67, "SELECT IP FROM `zaidejudb` WHERE `IP`='%s' LIMIT 2", GetPlayerIpEx(playerid));
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() > 2)
{
SendClientMessage(playerid, -1, "{FFFFFF}[ {FFFF00}INFORMACIJA {FFFFFF}]: J?s jau turite {FF0000}2 {FFFFFF}s?skaitas ?iame serveryje!");
Kick(playerid);
return true;
}
else
{
format(Query, 131, "{FFFFFF}Sveiki atvykж, {FFFF00}%s.\n{FFFFFF}Jыs neesate uюsiregistravж, praрome suvesti norimа slaptaюodб!", GetPlayerNameEx(playerid, true));
ShowPlayerDialog(playerid, REGISTRATION, DIALOG_STYLE_INPUT, "{FFFFFF}Registracija", Query, "Registruotis", "");
}
mysql_free_result();
}
else
{
format(Query, 108, "SELECT VARDAS AND IP FROM `zaidejudb` WHERE `Vardas`='%s' LIMIT 2", EscapeName(playerid), GetPlayerIpEx(playerid));
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows())
{
SendClientMessage(playerid, -1, "{FFFFFF}[ {FFFF00}INFORMACIJA {FFFFFF}]: Jыs esate prijungtas {6EF83C}automatiрkai!");
pData[playerid][pPrisijunges] = 2;
pData[playerid][pNewbie] = false;
}
else
{
format(Query, 130, "{FFFFFF}Sveiki sugrбюж, {FFFF00}%s.\n{FFFFFF}Jыsш IP {FF0000}nesutapo. {FFFFFF}Suveskite savo slaptaюodб!", GetPlayerNameEx(playerid, true));
ShowPlayerDialog(playerid, LOGIN, DIALOG_STYLE_INPUT, "{FFFFFF}Prisijungimas", Query, "Prisijungti", "");
}
}
format(Query, 96, "{FFFFFF}[ {FFFF00}PRISIJUNGIMAS {FFFFFF}]: %s prisijungл prie serverio!", GetPlayerNameEx(playerid, true));
SendClientMessageToAll(-1, Query);
mysql_free_result();