[Dokins]

pawn Код:

forward GetRecord(playerid);
public GetRecord(playerid)
{
    new r_msg[500], dialogstring[500];
    new n = 0;
    if(cache_num_rows() < 1)return SendClientMessage(playerid, COLOUR_GREY, "No records found.");
    while(cache_get_row(0, 0, r_msg))
    {
        sscanf(r_msg, "p<|>e<iiiis[24]iiii>", PlayerArrests[n]);
        if(n == 0)
        {
            format(dialogstring, sizeof(dialogstring), ""#COL_WHITE"%s", PlayerArrests[n][ar_cr]);
        }
        else
        {
            format(dialogstring, sizeof(dialogstring), "%s\n"#COL_WHITE"%s", dialogstring, PlayerArrests[n][ar_cr]);
        }
        strcpy(Pdialogstring[playerid], dialogstring, 200);
        n++;
    }
    ShowPlayerDialog(playerid, DIALOG_RECORDS, DIALOG_STYLE_LIST, "Showing 10 Latest Records.", dialogstring, "Select", "Black");
    return 1;
}

pawn Код:

else if(dialogid == DIALOG_SHOWPERSON)   //if the player responsed to the dialog (ID = 0, as we've set it as such - you'll use your definition) then the script continues here
            {
                if(response == 0)   //response 0 is always the SECOND BUTTON! (in our case this was "Close".
                {
                    return 1;
                }
                else //If the player did not press the close button, but the "Select" button, the script reads the following.
                {
                    new string[256];
                    format(string, sizeof(string), "SELECT * FROM `arecords` WHERE `PSQLID` = %d ORDER BY `id` DESC LIMIT 10", psql[playerid]);
                    mysql_tquery(dbHandle, string, "GetRecord", "i", playerid);
                }
            }

Title says all. I can't get the dialog to display.

[Dokins]

BUMP.

[IstuntmanI]

pawn Код:

forward GetRecord(playerid);
public GetRecord(playerid)
{
    new r_msg[500], dialogstring[500], liRows = cache_get_row_count( );

    if(liRows < 1)
        return SendClientMessage(playerid, COLOUR_GREY, "No records found.");

    for( new n = 0; n < liRows; n ++ )
    {
        cache_get_row(n, 0, r_msg);
        sscanf(r_msg, "p<|>e<iiiis[24]iiii>", PlayerArrests[n]);
        format(dialogstring, sizeof(dialogstring), "%s"#COL_WHITE"%s\n", dialogstring, PlayerArrests[n][ar_cr]);
    }

    strcpy(Pdialogstring[playerid], dialogstring, 200);
    ShowPlayerDialog(playerid, DIALOG_RECORDS, DIALOG_STYLE_LIST, "Showing 10 Latest Records.", dialogstring, "Select", "Black");
    return 1;
}

[Dokins]

Not working, won't display the results in the dialog.

[Beckett]

Your code is really confusing, can you show me how are you calling that callback through mysql_tquery function?