[Kaperstone]

Quote:

Originally Posted by [IL]HeHu Here is the whole command: PHP код: CMD:statement(playerid, params[]) {     if(!IsPlayerInRangeOfPoint(playerid,50.0,2315.952880,-1.618174,26.742187))         return SendClientMessage(playerid,C_RED,"You have to be inside the bank");     if(!PlayerInfo[playerid][pIDCard])         return SendClientMessage(playerid,C_RED,"You are not registered in San Andreas");     new         acc,         pass      ;      if(sscanf(params,"ii",acc,pass))          return SendClientMessage(playerid,C_NICE,"[Usage] {FFFFFF}/statement [account-number] [account-password]");     if(acc < 1)         return SendClientMessage(playerid,C_NICE,"[Usage] {FFFFFF}/statement [account-number] [account-password]");     if(!DoesBankAccountExist(acc))         return SendClientMessage(playerid,C_RED,"Bank account doesn't exist");     if(!IsBankPasswordTrue(acc,pass))         return SendClientMessage(playerid,C_RED,"Bank password is wrong");     new         string[526]      ;     format(string, sizeof(string), "SELECT `string` FROM `blogs` WHERE `bid` = '%i' LIMIT 5", acc);     mysql_query(string);     mysql_store_result();     if(mysql_num_rows() > 0)     {         format(string,sizeof(string),"{FF6347}BANK STATEMENT:\n\n{B1C8FB}%s\n",string);         ShowPlayerDialog(playerid,DIALOG_BANK_STAT,DIALOG_STYLE_MSGBOX,"{24FF0A}Bank - {FFFFFF}Statement",string,"OK","");         mysql_free_result();     }     else return             ShowPlayerDialog(playerid, DIALOG_BANK_STAT, DIALOG_STYLE_MSGBOX, "{24FF0A}Bank - {FFFFFF}Statement", "No record was found on this account", "OK", "");     return 1; }

look:

Код:

%d	 Inserts an integer (whole) number
%i	 Inserts an integer.

that mean:
if you put %i it will show only few numbers
if you will put %d it will show the WHOLE number that the player has typed

____________________________________
try thismybe it will work :\ i dont have a VERY high knowladge at MySQL)

pawn Код:

CMD:statement(playerid, params[])
{
    new
        acc,
        pass;
    new string[526];
    if(!IsPlayerInRangeOfPoint(playerid,50.0,2315.952880,-1.618174,26.742187)) {
        SendClientMessage(playerid,C_RED,"You have to be inside the bank");
    }
    else {
        if(!PlayerInfo[playerid][pIDCard]) {
            SendClientMessage(playerid,C_RED,"You are not registered in San Andreas");
        }
        else {
            if(sscanf(params,"ii",acc,pass)) {
                SendClientMessage(playerid,C_NICE,"[Usage] {FFFFFF}/statement [account-number] [account-password]");
            }
            else {
                if(acc < 1) {
                    SendClientMessage(playerid,C_NICE,"[Usage] {FFFFFF}/statement [account-number] [account-password]");
                }
                else {
                    if(!DoesBankAccountExist(acc)) {
                        SendClientMessage(playerid,C_RED,"Bank account doesn't exist");
                    }
                    else {
                        if(!IsBankPasswordTrue(acc,pass)) {
                            SendClientMessage(playerid,C_RED,"Bank password is wrong");
                        }
                        else {
                            format(string, sizeof(string), "SELECT `string` FROM `blogs` WHERE `bid` = '%i' LIMIT 5", acc);
                            mysql_query(string);
                            mysql_store_result();
                            if(mysql_num_rows() > 0) {
                                format(string,sizeof(string),"{FF6347}BANK STATEMENT:\n\n{B1C8FB}%s\n",string);
                                ShowPlayerDialog(playerid,DIALOG_BANK_STAT,DIALOG_STYLE_MSGBOX,"{24FF0A}Bank - {FFFFFF}Statement",string,"OK","");
                                mysql_free_result();
                            }
                            else {
                                ShowPlayerDialog(playerid, DIALOG_BANK_STAT, DIALOG_STYLE_MSGBOX, "{24FF0A}Bank - {FFFFFF}Statement", "No record was found on this account", "OK", "");
                            }
                        }
                    }
                }
            }
        }
    }
    return 1;
}