Hello guys,im in need of some help to convert this SQL to NON-SQL if there's anyone able to do it,here's the code down
Код:
COMMAND:foff(playerid)
{
if(PlayerInfo[playerid][playerteam] == CIV)
return SendClientError(playerid, CANT_USE_CMD);
new query[300], savingstring[20], rank[24], username[24], tier, factionpay, laston[ 35 ];
format(query, sizeof(query), "SELECT ranklvl, lastonline, user, rankname, fpay FROM PlayerInfo WHERE playerteam=%d", PlayerInfo[playerid][playerteam]);
mysql_query(query);
mysql_store_result();
SendClientMSG(playerid, COLOR_HELPEROOC, "{4985d7}[%s] -{a7c2e6} Faction Offline Members", PlayerInfo[playerid][PTeamName]);
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "ranklvl");
tier = strval(savingstring);
mysql_fetch_field_row(savingstring, "user");
myStrcpy(username, savingstring);
mysql_fetch_field_row(savingstring, "rankname");
myStrcpy(rank, savingstring);
mysql_fetch_field_row(savingstring, "fpay");
factionpay = strval(savingstring);
mysql_fetch_field_row(savingstring, "lastonline");
myStrcpy(laston, savingstring);
//=============================================================================
new Online = GetPlayerId(username);
if(!IsPlayerConnected(Online))
{
format(iStr, sizeof(iStr),"%s [Rank: %s] [Tier: %d] [Payment: %s] [Last online: %s]",username,rank,tier, number_format(factionpay),laston);
SendClientMessage(playerid,COLOR_GREY,iStr);
}
}
mysql_free_result();
return 1;
}