19.03.2016, 17:41
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
I will rep+ if you help me
Код:
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; }