//ranks.inc by Jimmy (a_sampdb.inc)

#include "a_samp"

new DB:rankdb;
new DBResult:result;
new DBResult:resulttwo;
new query[256];

public OnGameModeInit()
{
	rankdb = db_open("ranks.db");
	return CallLocalFunction("_OnGameModeInit", "");
}
forward _OnGameModeInit();

stock createrank(rankname[]){

	format(query, 50, "SELECT * FROM %s", rankname);
    result = db_query(rankdb, query);

    if(!db_num_rows(result)){

    	query[0] = EOS;
    	format(query, 150, "CREATE TABLE IF NOT EXISTS %s (ID INTEGER PRIMARY KEY AUTOINCREMENT, NOME TEXT DEFAULT '', PONTOS INTEGER DEFAULT 0)", rankname);
    	db_query(rankdb, query);
    }
	return 1;
}

stock atualizarrank(rankname, name[], pontos){

	query[0] = EOS;
	format(query, 150, "SELECT NOME FROM %s WHERE NOME='%s' LIMIT 1" , rankname, name);
    result = db_query(rankdb, query);

    if(db_num_rows(result)){

        format(query, 150, "UPDATE %s SET 'PONTOS'='%d' WHERE (`NOME` = '%s')" , rankname, pontos, name);
        db_free_result(db_query(rankdb, query));
    }
    else if(!db_num_rows(result)){

        format(query, 160,  "INSERT INTO %s (`NOME`, 'PONTOS') VALUES('%s',%d)" , rankname, name, pontos);
        db_free_result(db_query(rankdb, query));
    }
	return 1;
}

stock getrank(rankname, maxrank = 10){

	format(query, 200, "SELECT `NOME` FROM %s ORDER BY ('PONTOS' * 1 ) DESC limit %d", rankname, maxrank);
    result = db_query(rankdb, query);

    new zStrFormat[150], zStringTwo[128], zStrDlg[1024],;

    for(new a , zTotal = db_num_rows(result); a < zTotal ;a++ )
    {
        db_get_field(result, 0 , zStrFormat , 128 );
        format(query, sizeof(query) , "SELECT 'PONTOS' FROM %s WHERE `NOME` ='%s'" , rankname, zStrFormat );
        resulttwo = db_query(rankdb, query);
        db_get_field(resulttwo, 0 , zStringTwo , 128 );

        format(zStrDlg , 1023 , "Lugar: %02d  | Pontos: %d    | Player: %s \n" , ( a + 1 ) , zStringTwo , zStrFormat );

        db_next_row(result);
        db_free_result(resulttwo);
    }
    db_free_result(result);
    ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "ranks", zStrDlg, "Fechar", "");
	return 1;
}

#if defined _ALS_OnGameModeInit
    #undef OnGameModeInit
#else
    #define _ALS_OnGameModeInit
#endif
#define OnGameModeInit _OnGameModeInit