[FilterScript] Dynamic Vehicle & Dealership system [SQL]
#2

You don't seem to use EasyDB well. There are lot of areas where you still are performing DB::Query where it could be easily done with EasyDB functions.

Example
Your code:
pawn Code:
stock UpdatePlayerVehicle(playerid, vehicleid)
{
    new query[256], dbid = vInfo[vehicleid][dbID];
    format(query, sizeof query, "UPDATE `Vehicles` SET PosX = '%f', PosY = '%f',PosZ = '%f', Angle='%f' WHERE id='%d'",
    vInfo[vehicleid][vPos_X], vInfo[vehicleid][vPos_Y], vInfo[vehicleid][vPos_Z], vInfo[vehicleid][vAngle], dbid);
    DB::Query(query, false);
    printf("Vehicle ID %d has been saved. [%s vehicle]", vehicleid, GetName(playerid));
    return 1;
}
My code:
pawn Code:
stock UpdatePlayerVehicle(playerid, vehicleid)
{
    DB::MultiSet(vTable, vInfo[vehicleid][dbID], "ffff", "PosX", vInfo[vehicleid][vPos_X], "PosY", vInfo[vehicleid][vPos_Y], "PosZ", vInfo[vehicleid][vPos_Z], "Angle", vInfo[vehicleid][vAngle]);
   
    printf("Vehicle ID %d has been saved. [%s vehicle]", vehicleid, GetName(playerid));
    return 1;
}
Reply


Messages In This Thread
Dynamic Vehicle & Dealership system [SQL] - by Private200 - 04.04.2016, 21:36
Re: Dynamic Vehicle & Dealership system [SQL] - by Gammix - 04.04.2016, 22:00
Re: Dynamic Vehicle & Dealership system [SQL] - by oMa37 - 04.04.2016, 22:03
Re: Dynamic Vehicle & Dealership system [SQL] - by iKevin - 04.04.2016, 22:10
Re: Dynamic Vehicle & Dealership system [SQL] - by Stev - 04.04.2016, 22:50
Re: Dynamic Vehicle & Dealership system [SQL] - by Private200 - 05.04.2016, 09:07
Re: Dynamic Vehicle & Dealership system [SQL] - by Airblog - 05.04.2016, 13:19
Re: Dynamic Vehicle & Dealership system [SQL] - by OmegaKiller72 - 05.04.2016, 22:56
Re: Dynamic Vehicle & Dealership system [SQL] - by Private200 - 06.04.2016, 05:00
Re: Dynamic Vehicle & Dealership system [SQL] - by Sew_Sumi - 06.04.2016, 05:22
Re: Dynamic Vehicle & Dealership system [SQL] - by Private200 - 06.04.2016, 07:28
Re: Dynamic Vehicle & Dealership system [SQL] - by Sew_Sumi - 06.04.2016, 07:54
Re: Dynamic Vehicle & Dealership system [SQL] - by Private200 - 07.04.2016, 00:05
Re: Dynamic Vehicle & Dealership system [SQL] - by BlueBaron - 15.08.2016, 20:20
Re: Dynamic Vehicle & Dealership system [SQL] - by AndreiWow - 27.08.2016, 09:50
Re: Dynamic Vehicle & Dealership system [SQL] - by Tass007 - 28.08.2016, 11:18
Re: Dynamic Vehicle & Dealership system [SQL] - by axellech - 01.11.2016, 13:40
Re: Dynamic Vehicle & Dealership system [SQL] - by fonia5 - 01.11.2016, 14:50
Re: Dynamic Vehicle & Dealership system [SQL] - by DeLeTs - 05.12.2017, 20:39
Re: Dynamic Vehicle & Dealership system [SQL] - by JesusChrysler - 09.12.2017, 20:15

Forum Jump:


Users browsing this thread: 1 Guest(s)