[FilterScript] Vehicle Ownership System [MySQL]

[oMa37]

took me time thinking to release this system or not ...

Commands:

Player Commands:

• /buyvehicle <VehicleID> - Buy the offered vehicle in the dealership.
• /vehicles - Shows the current player owned vehicles, Click on the vehicle to spawn/change plate/empty/etc.
• /changeplate <Number/Text> - Change the number plate of the vehicle.
• /lock <VehicleID> - Lock a vehicle (If you are inside the vehicle, No need for the 'VehicleID' parameter).
• /unlock <VehicleID> - Unlock a vehicle (If you are inside the vehicle, No need for the 'VehicleID' parameter).

Administrator Commands:

• /buyvehicle <VehicleID> - Buy the offered vehicle in the dealership.
• /createvehicle <ModelID/Vehicle Name> <Color1> <Color2> <Price> - Create a vehicle for the dealership.
• /gotovehicle <VehicleID> - Teleport to a vehicle.
• /setvehicleprice <Price> - Change dealership vehicle price.
• /deletevehicle <VehicleID> - Delete a vehicle.

Requirements:

Streamer - Incognito
MySQL - BlueG/maddinat0r
Foreach - Kar/Y_Less
SSCANF2 - Y_Less/maddinat0r/Emmet_
Command Processor - SickAttack

Bugs:

Nothing found yet, If you found please post here.

Download:

ClickHere! - GitHub

Special Thanks:

AndySedeyn; Improvements and some fixes.
Konstantinos; Improvements and some fixes.

Enjoy, Hope you like it.

[SyS]

Nice one

[Logic_]

'oly fu' dude - can't rep :3

[DarkChildren]

Great!

[RyderX]

i like it thanks

[Eoussama]

noice

So you've listened to my suggestion... good job tho!

[Konstantinos]

I know it might be easier to re-upload the .pwn file again but pushing commits will be better for reviewing the changes.

The filterscript is nice and I know you will eventually change few other things to improve it so I always appreciate you take into consideration most of my suggestions!

PS: Another version for R40+ would be good as well.

[Thanks]

How to Do it? i mean how to instill it to mySQL I Already have mysql datebase

[ISmokezU]

Hey, isn't this a bad thing to do According to: (http://forum.sa-mp.com/showthread.php?t=420363)

     new query[500];
    mysql_format(mysql, query, sizeof(query), "UPDATE `Vehicles` SET `vehName` = '%e', `vehOwner` = '%e', `vehLock` = %i, `vehModel` = %i,\
    `vehPlate` = '%e', `vehMod_1` = %i, `vehMod_2` = %i, `vehMod_3` = %i, `vehMod_4` = %i, `vehMod_5` = %i, `vehMod_6` = %i, `vehMod_7` = %i,\
    `vehMod_8` = %i, `vehMod_9` = %i, `vehMod_10` = %i, `vehMod_11` = %i, `vehMod_12` = %i, `vehMod_13` = %i, `vehMod_14` = %i, `vehColorOne` = %i,\
    `vehColorTwo` = %i, `vehX` = %f, `vehY` = %f, `vehZ` = %f, `vehA` = %f WHERE `vehID` = %d", vInfo[vehicleid][vehName], vInfo[vehicleid][vehOwner],
    vInfo[vehicleid][vehLock], vInfo[vehicleid][vehModel], vInfo[vehicleid][vehPlate], vInfo[vehicleid][vehMod][0], vInfo[vehicleid][vehMod][1], vInfo[vehicleid][vehMod][2], 
    vInfo[vehicleid][vehMod][3], vInfo[vehicleid][vehMod][4], vInfo[vehicleid][vehMod][5], vInfo[vehicleid][vehMod][6], vInfo[vehicleid][vehMod][7], vInfo[vehicleid][vehMod][8], 
    vInfo[vehicleid][vehMod][9], vInfo[vehicleid][vehMod][10], vInfo[vehicleid][vehMod][11], vInfo[vehicleid][vehMod][12], vInfo[vehicleid][vehMod][13], vInfo[vehicleid][vehColorOne],
    vInfo[vehicleid][vehColorTwo], vInfo[vehicleid][vehX], vInfo[vehicleid][vehY], vInfo[vehicleid][vehZ], vInfo[vehicleid][vehA], vInfo[vehicleid][vehID]);
    mysql_tquery(mysql, query);
    return 1;
}

Saving all the mods even though some may not be used?

Edit: The limit for numberplates are 32 chars. why'd you save it as 16 chars,would that be enough?