Vienas klausimėlis dėl IPO.

[White`]

GetPlayerIp(playerid, plrIP, sizeof(plrIP));
format(newtext, sizeof(newtext), "ID: %s", pID);
TextDrawSetString(LoginTD[17], newtext);
TextDrawShowForPlayer(playerid, LoginTD[17]);

man kazkodel nerodo IPO ir:

new query[100];
new rows, fields;
cache_get_data(rows, fields, mysql);
mysql_format(mysql, query, sizeof(query), "SELECT `username` FROM `profiliai`");
if(rows)
{
format(newtext, sizeof(newtext), "Uzregistruotas: Taip");
TextDrawSetString(LoginTD[18], newtext);
TextDrawShowForPlayer(playerid, LoginTD[18]);
}
else
{
format(newtext, sizeof(newtext), "Uzregistruotas: Ne");
TextDrawSetString(LoginTD[18], newtext);
TextDrawShowForPlayer(playerid, LoginTD[18]);
}

nezinau kaip ten be rasyti select username ar kas.. bet nors ir uzregistrotas vardas, raso kad neregistruotas mano vardas.. tai kaip isgauti normaliai?

[ES.^]

GetPlayerIp(playerid, plrIP, 16);

format(newtext, 20, "ID: %s", plrIP);

TextDrawSetString(LoginTD[17], newtext);

TextDrawShowForPlayer(playerid, LoginTD[17]);

new pName[21], str[77];

GetPlayerName(playerid, pName, 21);

mysql_format(connectionHandle, str, 77, "SELECT `username` FROM `profiliai` WHERE `username` = '%s'", pName);

mysql_function_query(MYSQL_ARG, str, true, "ShowResult", "d", playerid);

forward ShowResult(playerid);

public ShowResult(playerid)

{

new rows, fields;

cache_get_data(rows, fields);

TextDrawSetString(LoginTD[18], (rows) ? ("Uzregistruotas: Taip") : ("Uzregistruotas: Ne"));

TextDrawShowForPlayer(playerid, LoginTD[18]);

return 1;

}