I need help converting this to Non-SQL
#1

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 On‌line = 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;
}
I will rep+ if you help me
Reply


Messages In This Thread
I need help converting this to Non-SQL - by CopKing123 - 19.03.2016, 17:41
Respuesta: I need help converting this to Non-SQL - by Harty - 20.03.2016, 20:09

Forum Jump:


Users browsing this thread: 1 Guest(s)