[Barnwell]

How to switch from R6 to R39? Anyone can help me? I have a old script and its use MySQL r6 how to change it to R39 MYSQL?
Here is the Pawn Code OF SQL:

pawn Code:

mysql_real_escape_string
mysql_query
mysql_store_result();
mysql_free_result();
mysql_num_rows

CONNECT MYSQL R6:

pawn Code:

public ConnectMySQL() {
    mysql_connect("localhost","root","testserver",""); //LIVE SCRIPT
    if(mysql_ping()==1) {
        printf("[MySQL]: Connected successfully to database '%s'", DB_);
    } else {
        printf("[MySQL]: Connection failed to database '%s'", DB_);
    }
    return 1;
}

[Banditul18]

-Deleted(Sorry i don't read well)-

[Barnwell]

Its R33 not R6.

[Vince]

Pretty much impossible without overhauling the complete script. Takes hours upon hours of work to do it correctly with threaded queries. Of course you can use unthreaded queries for a quick fix but if I were you I'd do it right the first time around.

real_escape_string is pretty much obsolete. Largely replaced with mysql_format (in place of regular format).
mysql_query is the same but has extra parameters, see wiki.
store_result and free_result are obsolete. For threaded queries these actions are performed automatically, for unthreaded queries the result must be deleted afterwards (cache_delete).
num_rows replaced with cache_get_row_count.

[Barnwell]

Link of the wiki?

[SickAttack]

The MySQL plugin is keep changing and changing how it works. It's just annoying when wanting to update your script. An entire pass through the gamemode is literally the only way.

https://github.com/pBlueG/SA-MP-MySQL/releases

[Barnwell]

pawn Code:

C:\Users\user\Desktop\FRP\gamemodes\FRP.pwn(4333) : error 035: argument type mismatch (argument 1)

pawn Code:

stock SaveTrunkSlot(playerid, slot)
{
    new sql[128];
    switch(slot)
    {
        case 0:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS1`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 1:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS2`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 2:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS3`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 3:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS4`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 4:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS5`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 5:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS6`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 6:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS7`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 7:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS8`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 8:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS9`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 9:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS10`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 10: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS1`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 11: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS2`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
        case 12: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS3`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }
    }
    return 1;
}

[DTV]

Quote:

Originally Posted by Barnwell pawn Code: C:\Users\user\Desktop\FRP\gamemodes\FRP.pwn(4333) : error 035: argument type mismatch (argument 1) pawn Code: stock SaveTrunkSlot(playerid, slot) {     new sql[128];     switch(slot)     {         case 0:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS1`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 1:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS2`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 2:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS3`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 3:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS4`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 4:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS5`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 5:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS6`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 6:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS7`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 7:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS8`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 8:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS9`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 9:  { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TS10`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 10: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS1`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 11: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS2`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }         case 12: { format(sql, sizeof(sql), "UPDATE `samp_trunks` SET `TDS3`=1 WHERE PlayerID='%d'", PlayerInfo[playerid][pDBID]); mysql_format(sql, THREAD_UPDATE, playerid); }     }     return 1; }

mysql_format requires the connection handle as the first argument.

Code:

mysql_format(connectionHandle,sql,sizeof(sql),"bla bla",...);

Also, why do you use format and then mysql_format when you can do it all in mysql_format?