[FunnyBear]

Hey,

I've created a function to check whether a player is banned. If they are, a dialog will show up giving them their ban details then kicking them. However, the information from the database isn't there in the dialog.

For example, it should say:

Ban Reason: Hacks
Banned By: Anti - Cheat

But it will come out as

Ban Reason:
Banned By:

Here is the code,

pawn Code:

forward OnBanLoad(playerid);
public OnBanLoad(playerid)
{
    new rows, fields, temp[120];
    new
        bReason,
        bannedBy,
        bName,
        Dialog[403],
        bIP,
        bExpiration,
        bID;

    cache_get_data(rows, fields, mysql);

    if(rows != 0)
    {
        cache_get_field_content(1, "Name", temp), bName = strval(temp);
        cache_get_field_content(3, "Reason", temp), bReason = strval(temp);
        cache_get_field_content(4, "BannedBy", temp), bannedBy = strval(temp);
        cache_get_field_content(2, "IP", temp), bIP = strval(temp);
        cache_get_field_content(0, "BanID", temp), bID = strval(temp);
        cache_get_field_content(7, "Expiration", temp), bExpiration = strval(temp);

        /*bName = cache_get_field_content_int(1, "Name");
        bReason = cache_get_field_content_int(3, "Reason");
        bannedBy = cache_get_field_content_int(4, "BannedBy");
        bIP = cache_get_field_content_int(2, "IP");
        bID = cache_get_field_content_int(0, "BanID");
        bExpiration = cache_get_field_content_int(7, "Expiration");
        #pragma unused temp*/


        if(bExpiration > 0)
        {
            if(gettime() >= bExpiration)
            {
                new query[74];
                mysql_format(mysql, query, sizeof(query), "UPDATE `bans` SET `Status`=0 WHERE `BanID` = '%d'", bID);
                mysql_tquery(mysql, query, "", "");
            }
            else
            {
                format(Dialog, sizeof(Dialog), "{FF0000}You are banned from this server! Ban details:\n\n{FF0000}Name:{FFFFFF} %s \n{FF0000}IP:{FFFFFF} %s\n{FF0000}Reason:{FFFFFF} %s \n{FF0000}Banned By:{FFFFFF} %s\n\n{FF0000}You will be unbanned in %d day(s)!\n\n{FF0000}If you think this ban is unfair, you can apply for an unban appeal at our forums\n{FF0000}Note - We do not unban hackers, or people who lie in their appeal", bName, bIP, bReason, bannedBy, (bExpiration-gettime()+86400)/86400);
                ShowPlayerDialog(playerid, DIALOG_BAN, DIALOG_STYLE_MSGBOX, "{FF0000}Banned!", Dialog, "Close", "");
                SetTimerEx( "KickPlayer",100, false, "i", playerid);
            }
        }
        else
        {
            format(Dialog, sizeof(Dialog), "{FF0000}You are banned from this server! Ban details:\n\n{FF0000}Name:{FFFFFF} %s \n{FF0000}IP:{FFFFFF} %s\n{FF0000}Reason:{FFFFFF} %s \n{FF0000}Banned By:{FFFFFF} %s\n\n{FF0000}You are banned forever!\n\n{FF0000}If you think this ban is unfair, you can apply for an unban appeal at our forums\n{FF0000}Note - We do not unban hackers, or people who lie in their appeal", bName, bIP, bReason, bannedBy);
            ShowPlayerDialog(playerid, DIALOG_BAN, DIALOG_STYLE_MSGBOX, "{FF0000}Banned!", Dialog, "Close", "");
            SetTimerEx( "KickPlayer",100, false, "i", playerid);
        }
    }
    return 1;
}

How am I able to fix this problem?

Thanks