MySQL newest 10 - Printable Version

MySQL newest 10 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL newest 10 (/showthread.php?tid=616962)

MySQL newest 10 - Ahmed21 - 13.09.2016

Hello, I have a table, it is a log table, (used to see some logs in the server), anyway, I've made a command in-game to view the newest 10 inserted rows into this table, how will the "for" function be?

Can it be like this?

PHP код:



cache_get_row_count();

    new count = cache_get_row_count();

    for(new i = count-1; i = count-11; i--)

    {

        SCM(i, -1, "hi");

    }

    return 1

Re: MySQL newest 10 - Misiur - 13.09.2016

Why won't you just use ORDER BY in your query?

Quote:

SELECT * FROM logs ORDER BY id DESC LIMIT 10

Re: MySQL newest 10 - Ahmed21 - 13.09.2016

Look to the MySQL table picture then to the script then look to the SAMP picture.

PHP код:



CMD:xplog(playerid, params[])

{

    if(!IsAdminLevel(playerid, 4)) return NoPermsMSG(playerid);

    

    new query[200], dialogfinal[1000], string[128], amount, reason[30], givenid, givenbyid;

    mysql_format(mysql, query, sizeof(query), "SELECT * FROM `xplog` ORDER BY `ID` DESC LIMIT 10");

    new Cache: result = mysql_query(mysql, query);


    strcat(dialogfinal, "Player\tGiven By\tAmount\tReason\n");

    cache_get_row_count();

    new count = cache_get_row_count();

    if(count == 0) return ErrorMSG(playerid, "The XP log is empty.");

    for(new i = 0; i < count; i++)

    {

        cache_get_row(i, 3, reason);

        givenid = cache_get_field_content_int(i, "GivenID");

        givenbyid = cache_get_field_content_int(i, "GivenByID");

        amount = cache_get_field_content_int(i, "Amount");

        format(string, sizeof(string), "%s\t%s\t%d\t%s\n", GetNameFromMySQLID(givenid), GetNameFromMySQLID(givenbyid), amount, reason);

        strcat(dialogfinal, string);

    }

    cache_delete(result);

    ShowPlayerDialog(playerid, DIALOG_XPLOG, DIALOG_STYLE_TABLIST_HEADERS, ""COL_WHITE"XP Log", dialogfinal, "Close", "");

    return 1;

}