[Scrillex]

Hello dear samp members.. I need sme help with this..

So I have some problem with mysql update IDK it really well so I'm asking for help in this case...


So still trying to update and understand how it is working....
ERROR:

pawn Код:

(628) : error 035: argument type mismatch (argument 1)
(1009) : error 035: argument type mismatch (argument 1)
(1397) : error 035: argument type mismatch (argument 1)
(1424) : error 035: argument type mismatch (argument 1)
(1430) : error 017: undefined symbol "mysql_fetch_int"
(2173) : error 035: argument type mismatch (argument 1)
(2184) : error 035: argument type mismatch (argument 1)
(2188) : error 025: function heading differs from prototype
(2196) : warning 235: public function lacks forward declaration (symbol "OnQueryFinish")

CODE":

pawn Код:

mysql_query("UPDATE playeraccounts SET playerStatus = '0' WHERE playerStatus = '1'");//LINE 628

pawn Код:

stock loadATMs() {
    mysql_query("SELECT * FROM atms", THREAD_LOAD_ATMS);//1009
    return 1;
}

pawn Код:

format(szMessage, sizeof(szMessage), "SELECT `banID` FROM `bans` WHERE `IPBanned` = '%s'", playerVariables[playerid][pConnectionIP]);
    mysql_query(szMessage, THREAD_CHECK_BANS_LIST, playerid);//LINE 1397

pawn Код:

format(szQueryOutput, sizeof(szQueryOutput), "SELECT `playerID` FROM `playeraccounts` WHERE `playerName` = '%e'", szEsc);
    mysql_query(szQueryOutput);//1424

pawn Код:

if(mysql_num_rows() > 1) {
        mysql_retrieve_row();
        new iResult = mysql_fetch_int();// LINE 1430
        mysql_free_result();
        return iResult;
    } else return -1;

pawn Код:

pawn Код:

format(aString, sizeof(aString), "INSERT INTO bans (playerNameBanned, playerBannedBy, playerBanReason, IPBanned) VALUES('%s', 'System', '%s', '%s')", szPlayerName, reason, playerIP);
    mysql_query(aString);//LINE 2173

pawn Код:

stock IPBan(ip[], reason[], name[] = "Nobody") {
    new
        cleanReason[64],
        querySz[150]; // To be on the safe side.

    mysql_real_escape_string(reason, cleanReason);
    format(querySz, sizeof(querySz), "INSERT INTO Bans (playerNameBanned, playerBanReason, IPBanned) VALUES('%s', '%s', '%s')", name, reason, ip);
    mysql_query(querySz);//LINE 2184
    return 1;
}

pawn Код:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {//LINE 2188
    if(IsPlayerConnected(extraid) && resultid == THREAD_CHECK_BANS_LIST) {
        ShowPlayerDialog(extraid, 0, DIALOG_STYLE_MSGBOX, "MySQL problem!", "You missed a step! Here's a list of the potential causes:\n\n- the MySQL connection details are invalid\n- the database dump wasn't imported correctly\n- an unexpected error ocurred\n\nPlease revisit the installation instructions.", "OK", "");
    }
    
    return printf("errorid: %d | error: %s | resultid: %d | extraid: %d | callback: %s | query: %s", errorid, error, resultid, extraid, callback, query);
}

pawn Код:

public OnQueryFinish(query[], resultid, extraid, connectionHandle) { //LINE 2196

[ZBits]

Are you sure you're using the correct a_mysql.inc file?