Konstantinos-Sk/tune-system

#Tune System

It is a simple yet effective filterscript designed for Freeroam servers which allows you to tune a vehicle outside of mod shops. It currently does not support Nitro or Stereo and probably never will.

There are only 4 commands available at the moment which are:

• /paintjob - Shows a list with the available paintjobs supported for a specific vehicle and an option to unset (remove) the paintjob.
• /tune - Shows a list with all the available categories of components.
• /vcolor - Allows you to change the colors of your vehicle!
• /vcolorlist - Shows a list with all the available vehicle colors (both the existing colors from San Andreas and extended colors were added in 0.3x).

How to install:

• MySQL:

---

1. Import the .sql file to your database.
2. Find the version (R33 to R39-6 or R40+) that matches the plugin version you've loaded into your server. Change the mysql configuration and save (compile) the filterscript as tune_system.pwn
3. Open server.cfg and add tune_system in the filterscripts line.

• SQLite:

---

1. Import the .sql file to your database or paste tune_system.db into scriptfiles folder.
2. Change the configuration (database name) if you import the .sql file to a different database name.
3. Save (compile) the filterscript as tune_system.pwn
4. Open server.cfg and add tune_system in the filterscripts line.

Important notes:

• It requires a vehicle spawner system at the very least.

• If the connection to the mysql server fails or the .db file (SQLite) couldn't be opened, it will try to unload the filterscript. Make sure the filterscript is named as tune_system.

• MySQL:

---

• Create a different database if you can. Using the same server and database will result in duplicate connections. You can allow them using:

mysql_option(DUPLICATE_CONNECTIONS, true);

for R33 to R39-6 versions or:

mysql_global_options(DUPLICATE_CONNECTIONS, true);

for R40+ versions of the mysql plugin. If you want to use only one connection for filterscripts and the gamemode (in R40+ versions), you'll need to disable DUPLICATE_CONNECTION_WARNING to avoid a warning:

mysql_global_options(DUPLICATE_CONNECTION_WARNING, false);

• You can either use Import tab in phpMyAdmin or even mysql console to import the .sql file.
• In case you get an error while trying to import the .sql file:

Error

SQL query:

/*!40101 SET NAMES utf8mb4 */;

MySQL said: Documentation
#1115 - Unknown character set: 'utf8mb4'

indicates that you use an older version of the mysql server. It is always recommended to update but if you cannot/don't want to, replace character set as 'utf8'.

Credits

• BlueG & maddinat0r (MySQL plugin)
• Y_Less, Emmet_ & maddinat0r (sscanf plugin)
• Zeex (zcmd)
• iJumbo (Color list idea - it was based on one of his post in Useful Snippets thread)
• oMa37 (testing)