[ThatFag]

hej there as the title says i dont really know how to make this same command but into mysqlr39 and basicly that what im looking for someone who is willing to help me out of this
the command is this one.

Код HTML:

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;
}