I need an example to convert MySQL R6 to MySQL R7.

I need an example to convert MySQL R6 to MySQL R7. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: I need an example to convert MySQL R6 to MySQL R7. (/showthread.php?tid=404546)

I need an example to convert MySQL R6 to MySQL R7. - Guyl - 03.01.2013

Hi everybody,

I'd like your help to convert just one line of MySQL R6 to MySQL R7 cause i dunno how to use it.

MySQL R6 :

PHP Code:



                    format(query, sizeof(query), "SELECT `id` FROM `vehicles` WHERE `owner` = '%s' AND `plate` = '15640'", pname);

                    mysql_query(query);

                    mysql_store_result();

                    while(mysql_retrieve_row())

                    {

                        mysql_fetch_field_row(savingstring, "id"); UserInfo[playerid][uVehKey1] = strval(savingstring);

                        SaveStats(playerid);

                    }

                    mysql_free_result();

                    new rand = random(sizeof(VehicleSpawns));

                    format(query, sizeof(query), "UPDATE `vehicles` SET `park_x` = '%f', `park_y` = '%f', `park_z` = '%f' WHERE `id` = '%d'", VehicleSpawns[rand][0], VehicleSpawns[rand][1], VehicleSpawns[rand][2], UserInfo[playerid][uVehKey1]);

                    mysql_query(query);

                    format(query, sizeof(query), "UPDATE `vehicles` SET `plate` = '*' WHERE `id` = '%d'", UserInfo[playerid][uVehKey1]);

                    mysql_query(query);

If you can show me how convert this to MySQL R7.

Thanks a lot!

Re: I need an example to convert MySQL R6 to MySQL R7. - ReneG - 03.01.2013

pawn Code:

loadVehicle(playerid) {
    format(query, sizeof query, "SELECT `id` FROM `vehicles` WHERE `owner` = '%s' AND `plate` = '15640'", pname); 
    mysql_function_query(yourConnectionHandleHere, query, true, "OnVehicleLoad", "d", playerid);
}

forward OnVehicleLoad(playerid);
public OnVehicleLoad(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);

    if(!rows) return 0;

    new content[11];

    cache_get_row(0, 0, content, yourConnectionHandleHere);
    UserInfo[playerid][uVehKey1] = strval(content);
    SaveStats(playerid);

    new rand = random(sizeof(VehicleSpawns)), query[500];
    format(query, sizeof(query), "UPDATE `vehicles` SET `park_x` = '%f', `park_y` = '%f', `park_z` = '%f' WHERE `id` = '%d'", VehicleSpawns[rand][0], VehicleSpawns[rand][1], VehicleSpawns[rand][2], UserInfo[playerid][uVehKey1]); 
    mysql_function_query(yourConnectionHandleHere, query, false, "", "");

    format(query, sizeof(query), "UPDATE `vehicles` SET `plate` = '*' WHERE `id` = '%d'", UserInfo[playerid][uVehKey1]); 
    mysql_function_query(yourConnectionHandleHere, query, false, "", ""); 
    return 1;
}

Re: I need an example to convert MySQL R6 to MySQL R7. - Guyl - 03.01.2013

Thanks for you help but i forgot one thing,
how to convert that :

PHP Code:



format(query, sizeof(query), "INSERT INTO `vehicles` (model, owner, colour1, colour2, price) VALUES('%d', '%s', '%d', '%d', '%d')", vehicle, pname, color1, color2, vehicleprice);

                mysql_query(query);

My code with your help :

PHP Code:



SafeGivePlayerMoney(playerid, -vehicleprice);

                GetPlayerName(playerid, pname, 24);

                format(query, sizeof(query), "INSERT INTO `vehicles` (model, owner, colour1, colour2, price) VALUES('%d', '%s', '%d', '%d', '%d')", vehicle, pname, color1, color2, vehicleprice);

                mysql_query(query);

                if(key1 == 9999) {

                    format(query, sizeof query, "SELECT `id` FROM `vehicles` WHERE `owner` = '%s' AND `plate` = '15640'", pname);

                    mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleLoad", "d", playerid);

                }

Re: I need an example to convert MySQL R6 to MySQL R7. - ReneG - 03.01.2013

pawn Code:

format(query, sizeof(query), "INSERT INTO `vehicles` (model, owner, colour1, colour2, price) VALUES('%d', '%s', '%d', '%d', '%d')", vehicle, pname, color1, color2, vehicleprice); 
mysql_function_query(MUMU_MYSQL_HANDLE, query, false, "", "");

the 'false' parameter is whether or not to enable the cache. You only want to enable the cache when you're fetching data i.e SELECT queries.