Server database structure - 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)
+---- Forum: Discussion (https://sampforum.blast.hk/forumdisplay.php?fid=84)
+---- Thread: Server database structure (/showthread.php?tid=536824)
+- 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)
+---- Forum: Discussion (https://sampforum.blast.hk/forumdisplay.php?fid=84)
+---- Thread: Server database structure (/showthread.php?tid=536824)
Server database structure. Share your database structure! - dusk - 12.09.2014
I've been developing my server for quite some time now and in the process I had to create a lot of tables in my database.
I want to know, how is your database(assuming you use one) structured? How many tables? How do you group information for one table?
Re: Server database structure - Vince - 13.09.2014
That entirely depends on what data you want to store. There's two catches: a) avoid duplicate data where possible and b) don't put numbers behind field names (weapon1, weapon2, etc), use another table instead.
Re: Server database structure - RajatPawar - 13.09.2014
I divide tables according to the attributes of the entity in whose relation I'm creating the tables. For players, say for example, groups, vehicles, financial status, etc. Make sure you don't duplicate details NOR create any fields that can be derived. (if I store the birth-date, why store the age?)
Re: Server database structure - iFarbod - 13.09.2014
This can be based on your server's game type. if it's a normal freeroam, i think 2 tables is enough.
One for holding player data, and one for saving player's attached objects (I Don't know) or one for player's saved vehicles.
If it's a Roleplay server, you can, for example, create one table For player's basic information, like name, password, email, ..., One table for properties, businesses, houses, etc.
Re: Server database structure - dusk - 13.09.2014
Interesting. I believe I might have overdone it.... 27 tables for a roleplay server and I consider making one more for player licenses and their warnings.
Re: Server database structure - IceCube! - 13.09.2014
Quote:
|
Originally Posted by dusk
 Interesting. I believe I might have overdone it.... 27 tables for a roleplay server and I consider making one more for player licenses and their warnings.
|
If you have specialised tables you only need to load in those tables when they are needed, for example the players vehicles are stored in their garages. They however aren't using their cars, and cruising with other players. You may as well unload this information if not load it at all until they enter the garage expecting to see their cars?
I however think if you have a table for licenses, it would simply be because of neatness and readability. This is not problem, it's not going to affect loading times of your database too much. As for warnings that could be anything, driving warnings? Admin Warnings?
Just keep in mind, the more tables you have; the better arranged your data. The easier it is to load and unload data when necessary and be able to manage the server in better more memory and network conserving ways.
Re: Server database structure - Pottus - 13.09.2014
You can never have too many tables but you can have too many fields in a table!
Re: Server database structure - PowerPC603 - 24.02.2015
I'm saving alot of info about vehicles in one table.
It all works fine, except the last column which holds all possible mods on a vehicle has multiple values stored in one column like this:
pawn Code:
+----+-------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| ID | Name | Class | Model | Price | MaxFuel | Consumption | RefuelTime | RefuelLitersPerStep | MaxPassengers | MaxCargo | AccessLevels | Disabled | ValidComponents |
+----+-------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| 0 | Landstalker | 7 | 400 | 50000 | 72 | 0.08 | 25 | 0.72 | 3 | 0 | 0 | 0 | 1008-1009-1010-1013-1018-1019-1020-1021-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 1 | Bravura | 11 | 401 | 50000 | 51 | 0.0566667 | 20 | 0.6375 | 1 | 0 | 0 | 0 | 1001-1003-1004-1005-1006-1007-1008-1009-1010-1013-1019-1020-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 2 | Buffalo | 12 | 402 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 3 | Linerunner | 5 | 403 | 50000 | 757 | 0.841111 | 25 | 7.57 | 1 | 0 | 0 | 0 | 1008-1009-1010 |
| 4 | Perenniel | 13 | 404 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1000-1002-1007-1008-1009-1010-1013-1016-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 5 | Sentinel | 11 | 405 | 50000 | 90 | 0.1 | 20 | 1.125 | 3 | 0 | 0 | 0 | 1000-1001-1008-1009-1010-1014-1018-1019-1020-1021-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 6 | Dumper | 15 | 406 | 50000 | 480 | 0.533333 | 25 | 4.8 | 1 | 0 | 0 | 0 | 0 |
| 7 | Firetruck | 9 | 407 | 50000 | 1893 | 2.10333 | 30 | 15.775 | 0 | 0 | 0 | 0 | 1008-1009-1010 |
| 8 | Trashmaster | 5 | 408 | 50000 | 189 | 0.21 | 25 | 1.89 | 1 | 0 | 0 | 0 | 1008-1009-1010 |
| 9 | Stretch | 15 | 409 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 0 | 0 | 0 | 0 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098
pawn Code:
+-------+-----------+
| Model | Component |
+-------+-----------+
| 400 | 1008 |
| 400 | 1009 |
| 400 | 1010 |
| 400 | 1013 |
| 400 | 1018 |
| 400 | 1019 |
| 400 | 1020 |
| 400 | 1021 |
| 400 | 1024 |
| 400 | 1025 |
| 400 | 1074 |
| 400 | 1076 |
| 400 | 1078 |
| 400 | 1081 |
| 400 | 1082 |
| 400 | 1085 |
| 400 | 1086 |
| 400 | 1087 |
| 400 | 1096 |
| 400 | 1097 |
| 400 | 1098 |
| 401 | 1001 |
| 401 | 1003 |
| 401 | 1004 |
| 401 | 1005 |
| 401 | 1006 |
| 401 | 1007 |
| 401 | 1008 |
| 401 | 1009 |
| 401 | 1010 |
| 401 | 1013 |
| 401 | 1019 |
| 401 | 1020 |
| 401 | 1025 |
| 401 | 1074 |
| 401 | 1076 |
| 401 | 1078 |
| 401 | 1081 |
| 401 | 1082 |
| 401 | 1085 |
| 401 | 1086 |
| 401 | 1087 |
| 401 | 1096 |
| 401 | 1097 |
| 401 | 1098 |
| 401 | 1143 |
| 401 | 1145 |
| 402 | 1008 |
| 402 | 1009 |
| 402 | 1010 |
| 402 | 1025 |
| 402 | 1074 |
| 402 | 1076 |
| 402 | 1078 |
| 402 | 1081 |
| 402 | 1082 |
| 402 | 1085 |
| 402 | 1087 |
| 402 | 1096 |
| 402 | 1097 |
| 402 | 1098 |
| 403 | 1008 |
| 403 | 1009 |
| 403 | 1010 |
| 404 | 1000 |
| 404 | 1002 |
| 404 | 1007 |
| 404 | 1008 |
| 404 | 1009 |
| 404 | 1010 |
| 404 | 1013 |
| 404 | 1016 |
| 404 | 1019 |
| 404 | 1020 |
| 404 | 1021 |
| 404 | 1025 |
| 404 | 1074 |
| 404 | 1076 |
| 404 | 1078 |
| 404 | 1081 |
| 404 | 1082 |
| 404 | 1085 |
| 404 | 1086 |
| 404 | 1087 |
| 404 | 1096 |
| 404 | 1097 |
| 404 | 1098 |
| 405 | 1000 |
| 405 | 1001 |
| 405 | 1008 |
| 405 | 1009 |
| 405 | 1010 |
| 405 | 1014 |
| 405 | 1018 |
| 405 | 1019 |
| 405 | 1020 |
| 405 | 1021 |
| 405 | 1023 |
| 405 | 1025 |
| 405 | 1074 |
| 405 | 1076 |
| 405 | 1078 |
| 405 | 1081 |
| 405 | 1082 |
| 405 | 1085 |
| 405 | 1086 |
| 405 | 1087 |
| 405 | 1096 |
| 405 | 1097 |
| 405 | 1098 |
| 407 | 1008 |
| 407 | 1009 |
| 407 | 1010 |
| 408 | 1008 |
| 408 | 1009 |
| 408 | 1010 |
| 409 | 1008 |
| 409 | 1009 |
| 409 | 1010 |
| 409 | 1025 |
| 409 | 1074 |
| 409 | 1076 |
| 409 | 1078 |
| 409 | 1081 |
| 409 | 1082 |
| 409 | 1085 |
| 409 | 1086 |
| 409 | 1087 |
| 409 | 1096 |
| 409 | 1097 |
| 409 | 1098 |
| 410 | 1001 |
| 410 | 1003 |
| 410 | 1007 |
| 410 | 1008 |
| 410 | 1009 |
| 410 | 1010 |
| 410 | 1013 |
| 410 | 1019 |
| 410 | 1020 |
| 410 | 1021 |
| 410 | 1023 |
| 410 | 1024 |
| 410 | 1025 |
| 410 | 1074 |
| 410 | 1076 |
| 410 | 1078 |
| 410 | 1081 |
| 410 | 1082 |
| 410 | 1085 |
+-------+-----------+
I was loading it all into this enum structure:
pawn Code:
// This enum holds all info about a vehicle-model
enum TVehicleInfo
{
VehicleName[50], // Holds the name of the vehicle-model
VehicleClass, // Holds the ID of the vehicleclass to which this vehicle-model is related
VehicleModel, // Holds the vehicle-model ID
VehiclePrice, // Holds the price for the vehicle-model to buy this vehiclemodel as house/company vehicle
Float:VehicleMaxFuel, // Holds the maximum fuel for this vehicle-model
Float:FuelConsumption, // This holds the fuel consumption for this vehicle-model
RefuelTime, // This holds the duration in seconds for a complete refuel
Float:RefuelLitersPerStep, // This holds the amount of liters refuelled each step (every 250ms)
MaxPassengers, // Holds the maximum amount of passengers for this vehiclemodel
MaxCargo, // Holds the maximum cargo for this vehiclemodel
AccessLevels[MAX_CLASSES], // Holds the level required for each player-class to enter this vehiclemodel
bool:VehicleDisabled, // Holds "true" if this vehicle is disabled for buying as house-vehicle and spawning with /v command
ValidComponents[30] // Holds all component-ID's that are valid for this vehiclemodel
}
new AVehicleInfo[212][TVehicleInfo];
pawn Code:
// This function is called to load the vehicle-info from MySQL during OnGameModeInit
VehicleInfo_Load()
{
// Setup local variables
new Query[128], Cache:result, Rows, CountSuccess, CountFailed;
new ID, name[50], Class, Model, Price, Float:MaxFuel, Float:Consump, RefuelT, Float:refuellitersperstep, maxpass, maxcargo, accesslevels[50], Disabled, ValidComps[160], sscanf_text[16];
// Send a query to load all vehicle-info from MySQL
format(Query, sizeof(Query), "SELECT * FROM vehicleinfo");
result = mysql_query(SQL_db, Query, true);
// Print some debug info to the server console
printf("*** Loading vehicle-info from MySQL using \"%s\"", Query);
// Get the amount of rows (vehicle-info)
Rows = cache_get_row_count(SQL_db);
// If there are any rows (vehicle-info) loaded, load data and overwrite default script-values
if (Rows >= 1)
{
// Loop through all rows
for (new Row; Row < Rows; Row++)
{
// Load the data
ID = cache_get_field_content_int(Row, "ID", SQL_db);
cache_get_field_content(Row, "Name", name, SQL_db, 50);
Class = cache_get_field_content_int(Row, "Class", SQL_db);
Model = cache_get_field_content_int(Row, "Model", SQL_db);
Price = cache_get_field_content_int(Row, "Price", SQL_db);
MaxFuel = cache_get_field_content_float(Row, "MaxFuel", SQL_db);
Consump = cache_get_field_content_float(Row, "Consumption", SQL_db);
RefuelT = cache_get_field_content_int(Row, "RefuelTime", SQL_db);
refuellitersperstep = cache_get_field_content_float(Row, "RefuelLitersPerStep", SQL_db);
maxpass = cache_get_field_content_int(Row, "MaxPassengers", SQL_db);
maxcargo = cache_get_field_content_int(Row, "MaxCargo", SQL_db);
cache_get_field_content(Row, "AccessLevels", accesslevels, SQL_db, 160);
Disabled = cache_get_field_content_int(Row, "Disabled", SQL_db);
cache_get_field_content(Row, "ValidComponents", ValidComps, SQL_db, 160);
// Check if the ID is invalid (out of range)
if ((ID < 0) || (ID >= sizeof(AVehicleInfo)))
{
// Count the amount of failed vehicle-info entries (invalid ID's)
CountFailed++;
// Add a message to the server-console to inform the admin about the wrong ID
printf("*** ERROR: Invalid ID found in table \"vehicleinfo\": %i", ID);
// Continue with the next vehicle-info entry from the MySQL query
continue;
}
// Store all the data
format(AVehicleInfo[ID][VehicleName], 50, name);
AVehicleInfo[ID][VehicleClass] = Class;
AVehicleInfo[ID][VehicleModel] = Model;
AVehicleInfo[ID][VehiclePrice] = Price;
AVehicleInfo[ID][VehicleMaxFuel] = MaxFuel;
AVehicleInfo[ID][FuelConsumption] = Consump;
AVehicleInfo[ID][RefuelTime] = RefuelT;
AVehicleInfo[ID][RefuelLitersPerStep] = refuellitersperstep;
AVehicleInfo[ID][MaxPassengers] = maxpass;
AVehicleInfo[ID][MaxCargo] = maxcargo;
if (Disabled == 1)
AVehicleInfo[ID][VehicleDisabled] = true;
else
AVehicleInfo[ID][VehicleDisabled] = false;
// Use sscanf to extract all valid components from the big string to insert them into the AVehicleInfo array (use delimiter "-" to split the values and convert every value to an integer)
sscanf(ValidComps, "p<->a<i>[30]", AVehicleInfo[ID][ValidComponents]);
// Do the same for the accesslevels
format(sscanf_text, sizeof(sscanf_text), "p<->a<i>[%i]", MAX_CLASSES);
sscanf(accesslevels, sscanf_text, AVehicleInfo[ID][AccessLevels]);
// Count the succesfully loaded vehicle-info entries
CountSuccess++;
}
}
// Print the amount of vehicle-info entries loaded for debugging
printf("*** Vehicle-info loaded: %i (successful: %i, failed: %i)", Rows, CountSuccess, CountFailed);
printf("");
// Clear the cache to prevent memory-leaks
cache_delete(result, SQL_db);
return 1;
}
If I would need to load the second table separately, it takes alot more code to read the same data, as I need to loop through all rows, check the vehicle-model, load the component and store it in a free index in the same enum under "ValidComponents".
Alot more work to get the same result and seems like a waste.
Also, the second table has 1750 rows to hold the same data as the ValidComponents column in the first table.
The access-levels will have the same "problem" as it was meant to put multiple values in that column as well.
And later on, for my job-system, it would also have such columns where multiple values are stored into one single column.
Splitting it all up into separate columns, separate loading functions, and whatever else, only makes it more complicated.
The data is meant to be stored together and I tried to keep all related values into one single table, but I didn't want to add 30 separate columns either to store 30 possible components on each vehiclemodel.
Re: Server database structure - Vince - 24.02.2015
I am assuming that the first table you posted only contains unique models. So in that case you should probably remove the "ID" column and use "model" as the primary key. Then you can link the components table using a foreign key. Use natural keys when they're available.
One particularly nice feature I recently discovered in phpMyAdmin is this:
So when you have relations set up correctly it will show like this:
Putting multiple values in one column, however, is simply not done. You could probably create a view to denormalize the tables to recreate the structure you currently use. http://stackoverflow.com/questions/2...into-one-field
Re: Server database structure - PowerPC603 - 24.02.2015
Yes, I was thinking about the ID column as well.
As you may have noticed, the vehicleinfo table lists all gta vehiclemodels and sets certain data for each one.
The ID is currently used to identify the index in my array, but I could simply use the model and substract 400 from it to get my index.
I'm getting rid of that as well.
But you gave me a proper solution by using group_concat.
I could group all my components into one single string, which can be extracted by sscanf.
But I'm not sure if it works for all models at once.
Right now, only one query is sent to get all vehicle-info, and everything is nicely split per vehiclemodel, as each model is stored on 1 row.
Using group_concat and my second table, I would need to send 211 queries, one query for each vehiclemodel and group all the components for that model into one string.
Maybe there is a solution where I could send one query and have 211 strings in the result, where each string holds all concat-ed components for each model.
I'll look into this a little further.
I'm also not using foreign keys or whatever to link tables together.
My knowledge about MySQL doesn't go that far yet.
Re: Server database structure - Extremo - 24.02.2015
I don't know if it has been mentioned in here yet, but since one of your latest questions is wether you should split multiple data, here is a good read that pretty much automatically teaches you how to group your data.
https://sampforum.blast.hk/showthread.php?tid=564378
I replied multiple times in that thread and each of my links, especially 1stNF, 2nd NF, 3rd NF are worth a read on this subject. From the sounds of it you are already using mysql correctly for the most part
That should answer a lot of your questions and I don't have to make the same reply over and over.
Re: Server database structure - PowerPC603 - 25.02.2015
I found something nice:
Код:
SELECT model, GROUP_CONCAT(component SEPARATOR '-') AS components FROM vehicleinfocomponents GROUP BY model;
pawn Код:
+-------+-----------+
| Model | Component |
+-------+-----------+
| 400 | 1008 |
| 400 | 1009 |
| 400 | 1010 |
| 400 | 1013 |
| 400 | 1018 |
| 400 | 1019 |
| 400 | 1020 |
| 400 | 1021 |
| 400 | 1024 |
| 400 | 1025 |
| 400 | 1074 |
| 400 | 1076 |
| 400 | 1078 |
| 400 | 1081 |
| 400 | 1082 |
| 400 | 1085 |
| 400 | 1086 |
| 400 | 1087 |
| 400 | 1096 |
| 400 | 1097 |
| 400 | 1098 |
| 401 | 1001 |
| 401 | 1003 |
| 401 | 1004 |
| 401 | 1005 |
| 401 | 1006 |
| 401 | 1007 |
| 401 | 1008 |
| 401 | 1009 |
| 401 | 1010 |
| 401 | 1013 |
| 401 | 1019 |
| 401 | 1020 |
| 401 | 1025 |
| 401 | 1074 |
| 401 | 1076 |
| 401 | 1078 |
| 401 | 1081 |
| 401 | 1082 |
| 401 | 1085 |
| 401 | 1086 |
| 401 | 1087 |
| 401 | 1096 |
| 401 | 1097 |
| 401 | 1098 |
| 401 | 1143 |
| 401 | 1145 |
| 402 | 1008 |
| 402 | 1009 |
| 402 | 1010 |
| 402 | 1025 |
| 402 | 1074 |
| 402 | 1076 |
| 402 | 1078 |
| 402 | 1081 |
| 402 | 1082 |
| 402 | 1085 |
| 402 | 1087 |
| 402 | 1096 |
| 402 | 1097 |
| 402 | 1098 |
| 403 | 1008 |
| 403 | 1009 |
| 403 | 1010 |
| 404 | 1000 |
| 404 | 1002 |
| 404 | 1007 |
| 404 | 1008 |
| 404 | 1009 |
| 404 | 1010 |
| 404 | 1013 |
| 404 | 1016 |
| 404 | 1019 |
| 404 | 1020 |
| 404 | 1021 |
| 404 | 1025 |
| 404 | 1074 |
| 404 | 1076 |
| 404 | 1078 |
| 404 | 1081 |
| 404 | 1082 |
| 404 | 1085 |
| 404 | 1086 |
| 404 | 1087 |
| 404 | 1096 |
| 404 | 1097 |
| 404 | 1098 |
| 405 | 1000 |
| 405 | 1001 |
| 405 | 1008 |
| 405 | 1009 |
| 405 | 1010 |
| 405 | 1014 |
| 405 | 1018 |
| 405 | 1019 |
| 405 | 1020 |
| 405 | 1021 |
| 405 | 1023 |
| 405 | 1025 |
| 405 | 1074 |
| 405 | 1076 |
| 405 | 1078 |
| 405 | 1081 |
| 405 | 1082 |
| 405 | 1085 |
| 405 | 1086 |
| 405 | 1087 |
| 405 | 1096 |
| 405 | 1097 |
| 405 | 1098 |
| 407 | 1008 |
| 407 | 1009 |
| 407 | 1010 |
| 408 | 1008 |
| 408 | 1009 |
| 408 | 1010 |
| 409 | 1008 |
| 409 | 1009 |
| 409 | 1010 |
| 409 | 1025 |
| 409 | 1074 |
| 409 | 1076 |
| 409 | 1078 |
| 409 | 1081 |
| 409 | 1082 |
| 409 | 1085 |
| 409 | 1086 |
| 409 | 1087 |
| 409 | 1096 |
| 409 | 1097 |
| 409 | 1098 |
| 410 | 1001 |
| 410 | 1003 |
| 410 | 1007 |
| 410 | 1008 |
| 410 | 1009 |
| 410 | 1010 |
| 410 | 1013 |
| 410 | 1019 |
| 410 | 1020 |
| 410 | 1021 |
| 410 | 1023 |
| 410 | 1024 |
| 410 | 1025 |
| 410 | 1074 |
| 410 | 1076 |
| 410 | 1078 |
| 410 | 1081 |
| 410 | 1082 |
| 410 | 1085 |
+-------+-----------+
pawn Код:
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
| model | components |
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
| 400 | 1008-1009-1010-1013-1018-1019-1020-1021-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 401 | 1001-1003-1004-1005-1006-1007-1008-1009-1010-1013-1019-1020-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 402 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 403 | 1008-1009-1010 |
| 404 | 1000-1002-1007-1008-1009-1010-1013-1016-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 405 | 1000-1001-1008-1009-1010-1014-1018-1019-1020-1021-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 407 | 1008-1009-1010 |
| 408 | 1008-1009-1010 |
| 409 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 410 | 1001-1003-1007-1008-1009-1010-1013-1019-1020-1021-1023-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 411 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 412 | 1008-1009-1010-1076-1078-1086-1087-1097-1098 |
| 413 | 1008-1009-1010 |
| 414 | 1008-1009-1010 |
| 415 | 1001-1003-1007-1008-1009-1010-1018-1019-1023-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 416 | 1008-1009-1010 |
| 418 | 1002-1006-1008-1009-1010-1016-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 419 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 420 | 1001-1003-1004-1005-1008-1009-1010-1019-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 421 | 1000-1008-1009-1010-1014-1016-1018-1019-1020-1021-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 422 | 1007-1008-1009-1010-1013-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 423 | 1008-1009-1010 |
| 424 | 1008-1009-1010 |
| 426 | 1001-1003-1004-1005-1006-1008-1009-1010-1019-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 427 | 1008-1009-1010 |
| 428 | 1008-1009-1010 |
| 429 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 431 | 1008-1009-1010 |
| 433 | 1008-1009-1010 |
| 434 | 1008-1009-1010 |
| 436 | 1001-1003-1006-1007-1008-1009-1010-1013-1019-1020-1021-1022-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 437 | 1008-1009-1010 |
| 438 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 439 | 1001-1003-1007-1008-1009-1010-1013-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 440 | 1008-1009-1010 |
| 442 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 443 | 1008-1009-1010 |
| 445 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 451 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 455 | 1008-1009-1010 |
| 456 | 1008-1009-1010 |
| 457 | 1008-1009-1010 |
| 458 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 459 | 1008-1009-1010 |
| 466 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 467 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 470 | 1008-1009-1010 |
| 474 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 475 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 477 | 1006-1007-1008-1009-1010-1018-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 478 | 1004-1005-1008-1009-1010-1012-1013-1020-1021-1022-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 479 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 480 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 482 | 1008-1009-1010 |
| 483 | 1008-1009-1010 |
| 485 | 1008-1009-1010 |
| 486 | 1008-1009-1010 |
| 489 | 1000-1002-1004-1005-1006-1008-1009-1010-1013-1016-1018-1019-1020-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 490 | 1008-1009-1010 |
| 491 | 1003-1007-1008-1009-1010-1014-1018-1019-1020-1021-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 492 | 1000-1004-1005-1006-1008-1009-1010-1016-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 494 | 1008-1009-1010 |
| 495 | 1008-1009-1010 |
| 496 | 1001-1002-1003-1006-1007-1008-1009-1010-1011-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143 |
| 498 | 1008-1009-1010 |
| 499 | 1008-1009-1010 |
| 500 | 1008-1009-1010-1013-1019-1020-1021-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 502 | 1008-1009-1010 |
| 503 | 1008-1009-1010 |
| 504 | 1008-1009-1010 |
| 505 | 1008-1009-1010 |
| 506 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 507 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 508 | 1008-1009-1010 |
| 514 | 1008-1009-1010 |
| 515 | 1008-1009-1010 |
| 516 | 1000-1002-1004-1007-1008-1009-1010-1015-1016-1018-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 517 | 1002-1003-1007-1008-1009-1010-1016-1018-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 518 | 1001-1003-1005-1006-1007-1008-1009-1010-1013-1018-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 524 | 1008-1009-1010 |
| 525 | 1008-1009-1010 |
| 526 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 527 | 1001-1007-1008-1009-1010-1014-1015-1018-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 528 | 1008-1009-1010 |
| 529 | 1001-1003-1006-1007-1008-1009-1010-1011-1012-1018-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 530 | 1008-1009-1010 |
| 531 | 1008-1009-1010 |
| 532 | 1008-1009-1010 |
| 533 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 534 | 1008-1009-1010-1075-1076-1077-1078-1079-1083-1084-1086-1087-1097-1098-1100-1106-1122-1123-1125-1126-1127-1178-1179-1180-1185 |
| 535 | 1008-1009-1010-1075-1076-1077-1078-1079-1083-1084-1086-1087-1097-1098-1109-1110-1113-1114-1115-1116-1117-1118-1119 |
| 536 | 1008-1009-1010-1075-1076-1077-1078-1079-1083-1084-1086-1097-1098-1103-1104-1105-1108-1128-1181-1182-1183-1184 |
| 540 | 1001-1004-1006-1007-1008-1009-1010-1018-1019-1020-1023-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 541 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 542 | 1008-1009-1010-1014-1015-1018-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1145 |
| 543 | 1008-1009-1010 |
| 544 | 1008-1009-1010 |
| 545 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 546 | 1001-1002-1004-1006-1007-1008-1009-1010-1018-1019-1023-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 547 | 1000-1003-1008-1009-1010-1016-1018-1019-1020-1021-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143 |
| 549 | 1001-1003-1007-1008-1009-1010-1011-1012-1018-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 550 | 1001-1003-1004-1005-1006-1008-1009-1010-1018-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 551 | 1002-1003-1005-1006-1008-1009-1010-1016-1018-1019-1020-1021-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 552 | 1008-1009-1010 |
| 554 | 1008-1009-1010 |
| 555 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 558 | 1008-1009-1010-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1086-1087-1088-1089-1090-1091-1092-1093-1163-1164-1165-1166-1167-1168 |
| 559 | 1008-1009-1010-1065-1066-1067-1068-1069-1070-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1087-1158-1159-1160-1161-1162-1173 |
| 560 | 1008-1009-1010-1026-1028-1029-1031-1032-1033-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1086-1087-1138-1139-1140-1141-1169-1170 |
| 561 | 1008-1009-1010-1055-1056-1057-1058-1059-1060-1061-1064-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1086-1087-1154-1155-1156-1157 |
| 562 | 1008-1009-1010-1034-1035-1036-1037-1038-1039-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1086-1087-1146-1147-1148-1149-1171-1172 |
| 565 | 1008-1009-1010-1045-1046-1047-1048-1049-1050-1053-1054-1073-1074-1075-1077-1079-1080-1081-1082-1083-1085-1086-1087-1150-1151-1152-1153 |
| 566 | 1008-1009-1010-1076-1078-1086-1087-1097-1098 |
| 567 | 1008-1009-1010-1075-1076-1077-1078-1079-1083-1084-1086-1087-1097-1098-1129-1130-1131-1133-1186-1187-1188-1189 |
| 568 | 1008-1009-1010 |
| 571 | 1008-1009-1010 |
| 572 | 1008-1009-1010 |
| 574 | 1008-1009-1010 |
| 575 | 1008-1009-1010-1042-1043-1044-1075-1076-1077-1078-1079-1083-1084-1086-1087-1097-1098-1174-1175-1176-1177 |
| 576 | 1008-1009-1010-1075-1076-1077-1078-1079-1083-1084-1086-1087-1097-1098-1134-1135-1136-1190-1191-1192-1193 |
| 578 | 1008-1009-1010 |
| 579 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 580 | 1001-1006-1007-1008-1009-1010-1018-1020-1023-1025-1074-1076-1078-1081-1082-1085-1087-1096-1097-1098 |
| 582 | 1008-1009-1010 |
| 583 | 1008-1009-1010 |
| 585 | 1001-1003-1006-1007-1008-1009-1010-1013-1018-1019-1020-1023-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 587 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 588 | 1008-1009-1010 |
| 589 | 1000-1004-1005-1006-1007-1008-1009-1010-1013-1016-1018-1020-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1145 |
| 596 | 1008-1009-1010 |
| 597 | 1008-1009-1010 |
| 598 | 1008-1009-1010 |
| 599 | 1008-1009-1010 |
| 600 | 1004-1005-1006-1007-1008-1009-1010-1013-1018-1020-1022-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 601 | 1008-1009-1010 |
| 602 | 1008-1009-1010-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098 |
| 603 | 1001-1006-1007-1008-1009-1010-1018-1019-1020-1023-1024-1025-1074-1076-1078-1081-1082-1085-1086-1087-1096-1097-1098-1143-1145 |
| 604 | 1008-1009-1010 |
| 605 | 1008-1009-1010 |
| 609 | 1008-1009-1010 |
+-------+----------------------------------------------------------------------------------------------------------------------------------------+
Then I can still loop through all rows, use the "model" as the index for my array and use sscanf to split up the results again to put them in my enum structure just like before.
Then my table vehicleinfo can dump the ValidComponents column, which had up to 30 values in one column, and the table should be normalized.
Still, I need 2 queries now, and 2 loading functions to load the same data as before.
I'm still looking for a way to merge both queries together, to have the same result returned as before, so I can keep my loading function exactly the same, just another query that loads one table entirely, and uses group_concat on the second, where it merged each grouped entry to the correct row from the first table.
Re: Server database structure - Luis- - 25.02.2015
I really need to learn more MySQL. There's so many possibilities that I don't even know of.
Respuesta: Re: Server database structure - kirk - 25.02.2015
Quote:
|
Originally Posted by Vince
That entirely depends on what data you want to store. There's two catches: a) avoid duplicate data where possible and b) don't put numbers behind field names (weapon1, weapon2, etc), use another table instead.
|
Its good to normalizate your database, and its also good to denormalizate it a bit and also allow some controlled redundancy if need.
Re: Server database structure - PowerPC603 - 25.02.2015
I found my required query after lots of trial and error using the mysql command console:
pawn Код:
select a.*, (select group_concat(b.component) from vehicleinfocomponents b where b.model = a.model) as components from vehicleinfo a;
This was the hardest part, as previous queries always listed the proper data, but skipped all results which didn't have components, so I was missing a few rows in my result.
Код:
+-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+ | ID | Name | Class | Model | Price | MaxFuel | Consumption | RefuelTime | RefuelLitersPerStep | MaxPassengers | MaxCargo | AccessLevels | Disabled | components | +-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+ | 0 | Landstalker | 7 | 400 | 50000 | 72 | 0.08 | 25 | 0.72 | 3 | 0 | 0 | 0 | 1008,1009,1010,1013,1018,1019,1020,1021,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 1 | Bravura | 11 | 401 | 50000 | 51 | 0.0566667 | 20 | 0.6375 | 1 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1007,1008,1009,1010,1013,1019,1020,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 2 | Buffalo | 12 | 402 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 3 | Linerunner | 5 | 403 | 50000 | 757 | 0.841111 | 25 | 7.57 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 4 | Perenniel | 13 | 404 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1000,1002,1007,1008,1009,1010,1013,1016,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 5 | Sentinel | 11 | 405 | 50000 | 90 | 0.1 | 20 | 1.125 | 3 | 0 | 0 | 0 | 1000,1001,1008,1009,1010,1014,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 6 | Dumper | 15 | 406 | 50000 | 480 | 0.533333 | 25 | 4.8 | 1 | 0 | 0 | 0 | NULL | | 7 | Firetruck | 9 | 407 | 50000 | 1893 | 2.10333 | 30 | 15.775 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 8 | Trashmaster | 5 | 408 | 50000 | 189 | 0.21 | 25 | 1.89 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 9 | Stretch | 15 | 409 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 10 | Manana | 11 | 410 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1013,1019,1020,1021,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 11 | Infernus | 12 | 411 | 50000 | 70 | 0.077778 | 20 | 0.875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 12 | Voodoo | 6 | 412 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1076,1078,1086,1087,1097,1098 | | 13 | Pony | 5 | 413 | 50000 | 125 | 0.138889 | 25 | 1.25 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 14 | Mule | 5 | 414 | 50000 | 132 | 0.146667 | 25 | 1.32 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 15 | Cheetah | 12 | 415 | 50000 | 110 | 0.122222 | 20 | 1.375 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1018,1019,1023,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 16 | Ambulance | 9 | 416 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 17 | Leviathan | 4 | 417 | 50000 | 1074 | 1.19333 | 30 | 8.95 | 0 | 0 | 0 | 0 | NULL | | 18 | Moonbeam | 13 | 418 | 50000 | 102 | 0.113333 | 20 | 1.275 | 3 | 0 | 0 | 0 | 1002,1006,1008,1009,1010,1016,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 19 | Esperanto | 11 | 419 | 50000 | 102 | 0.113333 | 20 | 1.275 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 20 | Taxi | 9 | 420 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1008,1009,1010,1019,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 21 | Washington | 11 | 421 | 50000 | 80 | 0.0888889 | 20 | 1 | 3 | 0 | 0 | 0 | 1000,1008,1009,1010,1014,1016,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 22 | Bobcat | 5 | 422 | 50000 | 65 | 0.0722222 | 25 | 0.65 | 1 | 0 | 0 | 0 | 1007,1008,1009,1010,1013,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 23 | Mr Whoopee | 15 | 423 | 50000 | 102 | 0.113333 | 25 | 1.02 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 24 | BF Injection | 7 | 424 | 50000 | 56 | 0.0622222 | 25 | 0.56 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 25 | Hunter | 4 | 425 | 50000 | 1421 | 1.57889 | 30 | 11.8417 | 0 | 0 | 0 | 0 | NULL | | 26 | Premier | 11 | 426 | 50000 | 87 | 0.0966667 | 20 | 1.0875 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1008,1009,1010,1019,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 27 | Enforcer | 9 | 427 | 50000 | 98 | 0.108889 | 25 | 0.98 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 28 | Securicar | 15 | 428 | 50000 | 98 | 0.108889 | 25 | 0.98 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 29 | Banshee | 12 | 429 | 50000 | 83 | 0.0922222 | 20 | 1.0375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 30 | Predator | 2 | 430 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 31 | Bus | 9 | 431 | 50000 | 545 | 0.605556 | 30 | 4.54167 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 32 | Rhino | 9 | 432 | 50000 | 1893 | 2.10333 | 30 | 15.775 | 0 | 0 | 0 | 0 | NULL | | 33 | Barracks | 9 | 433 | 50000 | 306 | 0.34 | 30 | 2.55 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 34 | Hotknife | 15 | 434 | 50000 | 41 | 0.0455556 | 25 | 0.41 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 35 | Cargo Trailer | 14 | 435 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 36 | Previon | 11 | 436 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1013,1019,1020,1021,1022,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 37 | Coach | 9 | 437 | 50000 | 560 | 0.311111 | 30 | 4.66667 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 38 | Cabbie | 9 | 438 | 50000 | 67 | 0.0744444 | 25 | 0.67 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 39 | Stallion | 3 | 439 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1013,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 40 | Rumpo | 5 | 440 | 50000 | 100 | 0.11 | 25 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 41 | RC Bandit | 10 | 441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 42 | Romero | 15 | 442 | 50000 | 102 | 0.113333 | 25 | 1.02 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 43 | Packer | 5 | 443 | 50000 | 378 | 0.42 | 25 | 3.78 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 44 | Monster | 7 | 444 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 45 | Admiral | 11 | 445 | 50000 | 65 | 0.0722222 | 20 | 0.8125 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 46 | Squallo | 2 | 446 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 47 | Seasparrow | 4 | 447 | 50000 | 230 | 0.255556 | 30 | 1.91667 | 1 | 0 | 0 | 0 | NULL | | 48 | Pizzaboy | 1 | 448 | 10000 | 9 | 0.01 | 10 | 0.225 | 0 | 0 | 0 | 0 | NULL | | 49 | Tram | 16 | 449 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 50 | Ore Trailer | 14 | 450 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 51 | Turismo | 12 | 451 | 50000 | 120 | 0.133333 | 20 | 1.5 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 52 | Speeder | 2 | 452 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 53 | Reefer | 2 | 453 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 54 | Tropic | 2 | 454 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 55 | Flatbed | 5 | 455 | 50000 | 306 | 0.34 | 25 | 3.06 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 56 | Yankee | 5 | 456 | 50000 | 189 | 0.21 | 25 | 1.89 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 57 | Caddy | 15 | 457 | 50000 | 22 | 0.0244444 | 15 | 0.366667 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 58 | Solair | 13 | 458 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 59 | Berkley's RC Van | 5 | 459 | 50000 | 100 | 0.11 | 25 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 60 | Skimmer | 8 | 460 | 50000 | 151 | 0.167778 | 30 | 1.25833 | 1 | 0 | 0 | 0 | NULL | | 61 | PCJ-600 | 1 | 461 | 50000 | 20 | 0.0222222 | 10 | 0.5 | 1 | 0 | 0 | 0 | NULL | | 62 | Faggio | 1 | 462 | 10000 | 9 | 0.01 | 10 | 0.225 | 0 | 0 | 0 | 0 | NULL | | 63 | Freeway | 1 | 463 | 50000 | 23 | 0.0255556 | 10 | 0.575 | 0 | 0 | 0 | 0 | NULL | | 64 | RC Baron | 10 | 464 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 65 | RC Raider | 10 | 465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 66 | Glendale | 11 | 466 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 67 | Oceanic | 11 | 467 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 68 | Sanchez | 1 | 468 | 50000 | 6 | 0.0075 | 10 | 0.15 | 0 | 0 | 0 | 0 | NULL | | 69 | Sparrow | 4 | 469 | 50000 | 230 | 0.255556 | 30 | 1.91667 | 1 | 0 | 0 | 0 | NULL | | 70 | Patriot | 7 | 470 | 50000 | 95 | 0.105556 | 25 | 0.95 | 3 | 0 | 0 | 0 | 1008,1009,1010 | | 71 | Quad | 1 | 471 | 50000 | 10 | 0.0111111 | 10 | 0.25 | 0 | 0 | 0 | 0 | NULL | | 72 | Coastguard | 2 | 472 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 73 | Dinghy | 2 | 473 | 50000 | 181 | 0.201111 | 15 | 3.01667 | 0 | 0 | 0 | 0 | NULL | | 74 | Hermes | 11 | 474 | 50000 | 61 | 0.0677778 | 20 | 0.7625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 75 | Sabre | 12 | 475 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 76 | Rustler | 8 | 476 | 50000 | 507 | 0.563333 | 30 | 4.225 | 0 | 0 | 0 | 0 | NULL | | 77 | ZR-350 | 12 | 477 | 50000 | 77 | 0.0855556 | 20 | 0.9625 | 1 | 0 | 0 | 0 | 1006,1007,1008,1009,1010,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 78 | Walton | 5 | 478 | 50000 | 60 | 0.0666667 | 25 | 0.6 | 1 | 0 | 0 | 0 | 1004,1005,1008,1009,1010,1012,1013,1020,1021,1022,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 79 | Regina | 13 | 479 | 50000 | 95 | 0.105556 | 20 | 1.1875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 80 | Comet | 3 | 480 | 50000 | 80 | 0.0888889 | 20 | 1 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 81 | BMX | 1 | 481 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 82 | Burrito | 5 | 482 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 83 | Camper | 15 | 483 | 50000 | 69 | 0.0766667 | 25 | 0.69 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 84 | Marquis | 2 | 484 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 85 | Baggage | 15 | 485 | 50000 | 50 | 0.0555556 | 25 | 0.5 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 86 | Dozer | 15 | 486 | 50000 | 793 | 0.881111 | 25 | 7.93 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 87 | Maverick | 4 | 487 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 88 | SAN News Maverick | 4 | 488 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 89 | Rancher 1 | 7 | 489 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1000,1002,1004,1005,1006,1008,1009,1010,1013,1016,1018,1019,1020,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 90 | FBI Rancher | 9 | 490 | 50000 | 117 | 0.13 | 25 | 1.17 | 3 | 0 | 0 | 0 | 1008,1009,1010 | | 91 | Virgo | 11 | 491 | 50000 | 95 | 0.105556 | 20 | 1.1875 | 1 | 0 | 0 | 0 | 1003,1007,1008,1009,1010,1014,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 92 | Greenwood | 11 | 492 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 3 | 0 | 0 | 0 | 1000,1004,1005,1006,1008,1009,1010,1016,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 93 | Jetmax | 2 | 493 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 94 | Hotring Racer 1 | 12 | 494 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 95 | Sandking | 7 | 495 | 50000 | 118 | 0.131111 | 25 | 1.18 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 96 | Blista Compact | 12 | 496 | 50000 | 45 | 0.05 | 20 | 0.5625 | 1 | 0 | 0 | 0 | 1001,1002,1003,1006,1007,1008,1009,1010,1011,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143 | | 97 | Police Maverick | 4 | 497 | 50000 | 345 | 0.383333 | 30 | 2.875 | 3 | 0 | 0 | 0 | NULL | | 98 | Boxville 1 | 5 | 498 | 50000 | 102 | 0.113333 | 25 | 1.02 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 99 | Benson | 5 | 499 | 50000 | 68 | 0.0755556 | 25 | 0.68 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 100 | Mesa | 7 | 500 | 50000 | 72 | 0.08 | 25 | 0.72 | 1 | 0 | 0 | 0 | 1008,1009,1010,1013,1019,1020,1021,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 101 | RC Goblin | 10 | 501 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 102 | Hotring Racer 2 | 12 | 502 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 103 | Hotring Racer 3 | 12 | 503 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 104 | Bloodring Banger | 11 | 504 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 105 | Rancher 2 | 7 | 505 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 106 | Super GT | 12 | 506 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 107 | Elegant | 11 | 507 | 50000 | 87 | 0.0966667 | 20 | 1.0875 | 3 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 108 | Journey | 15 | 508 | 50000 | 117 | 0.13 | 25 | 1.17 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 109 | Bike | 1 | 509 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 110 | Mountain Bike | 1 | 510 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 111 | Beagle | 8 | 511 | 50000 | 480 | 0.533333 | 30 | 4 | 0 | 0 | 0 | 0 | NULL | | 112 | Cropduster | 8 | 512 | 50000 | 330 | 0.366667 | 30 | 2.75 | 0 | 0 | 0 | 0 | NULL | | 113 | Stuntplane | 8 | 513 | 50000 | 72 | 0.08 | 30 | 0.6 | 0 | 0 | 0 | 0 | NULL | | 114 | Tanker | 5 | 514 | 50000 | 250 | 0.277778 | 25 | 2.5 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 115 | Roadtrain | 5 | 515 | 50000 | 250 | 0.277778 | 25 | 2.5 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 116 | Nebula | 11 | 516 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 3 | 0 | 0 | 0 | 1000,1002,1004,1007,1008,1009,1010,1015,1016,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 117 | Majestic | 11 | 517 | 50000 | 56 | 0.0622222 | 20 | 0.7 | 1 | 0 | 0 | 0 | 1002,1003,1007,1008,1009,1010,1016,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 118 | Buccaneer | 11 | 518 | 50000 | 72 | 0.08 | 20 | 0.9 | 1 | 0 | 0 | 0 | 1001,1003,1005,1006,1007,1008,1009,1010,1013,1018,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 119 | Shamal | 8 | 519 | 50000 | 2755 | 1.53056 | 45 | 15.3056 | 0 | 0 | 0 | 0 | NULL | | 120 | Hydra | 8 | 520 | 50000 | 4319 | 4.79889 | 45 | 23.9944 | 0 | 0 | 0 | 0 | NULL | | 121 | FCR-900 | 1 | 521 | 50000 | 18 | 0.02 | 10 | 0.45 | 0 | 0 | 0 | 0 | NULL | | 122 | NRG-500 | 1 | 522 | 50000 | 13 | 0.0144444 | 10 | 0.325 | 1 | 0 | 0 | 0 | NULL | | 123 | HPV1000 | 1 | 523 | 50000 | 17 | 0.0188889 | 10 | 0.425 | 0 | 0 | 0 | 0 | NULL | | 124 | Cement Truck | 5 | 524 | 50000 | 227 | 0.252222 | 25 | 2.27 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 125 | Towtruck | 15 | 525 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 126 | Fortune | 11 | 526 | 50000 | 72 | 0.08 | 20 | 0.9 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 127 | Cadrona | 11 | 527 | 50000 | 51 | 0.0566667 | 20 | 0.6375 | 1 | 0 | 0 | 0 | 1001,1007,1008,1009,1010,1014,1015,1018,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 128 | FBI Truck | 9 | 528 | 50000 | 121 | 0.134444 | 25 | 1.21 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 129 | Willard | 11 | 529 | 50000 | 61 | 0.0677778 | 20 | 0.7625 | 3 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1011,1012,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 130 | Forklift | 15 | 530 | 50000 | 53 | 0.0588889 | 25 | 0.53 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 131 | Tractor | 5 | 531 | 50000 | 75 | 0.0833333 | 25 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 132 | Combine Harvester | 15 | 532 | 50000 | 1000 | 1.11111 | 25 | 10 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 133 | Feltzer | 3 | 533 | 50000 | 90 | 0.1 | 20 | 1.125 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 134 | Remington | 6 | 534 | 50000 | 91 | 0.101111 | 20 | 1.1375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1100,1106,1122,1123,1125,1126,1127,1178,1179,1180,1185 | | 135 | Slamvan | 6 | 535 | 50000 | 151 | 0.167778 | 20 | 1.8875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1109,1110,1113,1114,1115,1116,1117,1118,1119 | | 136 | Blade | 6 | 536 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 1 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1097,1098,1103,1104,1105,1108,1128,1181,1182,1183,1184 | | 137 | Freight train | 16 | 537 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 138 | Brownstreak | 16 | 538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 139 | Vortex | 15 | 539 | 50000 | 100 | 0.111111 | 25 | 1 | 0 | 0 | 0 | 0 | NULL | | 140 | Vincent | 11 | 540 | 50000 | 80 | 0.0888889 | 20 | 1 | 3 | 0 | 0 | 0 | 1001,1004,1006,1007,1008,1009,1010,1018,1019,1020,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 141 | Bullet | 12 | 541 | 50000 | 85 | 0.0944444 | 20 | 1.0625 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 142 | Clover | 11 | 542 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 1 | 0 | 0 | 0 | 1008,1009,1010,1014,1015,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1145 | | 143 | Sadler | 5 | 543 | 50000 | 72 | 0.08 | 25 | 0.72 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 144 | Firetruck LA | 9 | 544 | 50000 | 1893 | 2.10333 | 25 | 18.93 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 145 | Hustler | 15 | 545 | 50000 | 53 | 0.0588889 | 25 | 0.53 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 146 | Intruder | 11 | 546 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1001,1002,1004,1006,1007,1008,1009,1010,1018,1019,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 147 | Primo | 11 | 547 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 3 | 0 | 0 | 0 | 1000,1003,1008,1009,1010,1016,1018,1019,1020,1021,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143 | | 148 | Cargobob | 4 | 548 | 50000 | 1400 | 1.55556 | 30 | 11.6667 | 0 | 0 | 0 | 0 | NULL | | 149 | Tampa | 11 | 549 | 50000 | 53 | 0.0588889 | 20 | 0.6625 | 1 | 0 | 0 | 0 | 1001,1003,1007,1008,1009,1010,1011,1012,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 150 | Sunrise | 11 | 550 | 50000 | 64 | 0.0711111 | 20 | 0.8 | 3 | 0 | 0 | 0 | 1001,1003,1004,1005,1006,1008,1009,1010,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 151 | Merit | 11 | 551 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 3 | 0 | 0 | 0 | 1002,1003,1005,1006,1008,1009,1010,1016,1018,1019,1020,1021,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 152 | Utility Van | 5 | 552 | 50000 | 94 | 0.104444 | 25 | 0.94 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 153 | Nevada | 8 | 553 | 50000 | 3112 | 1.72889 | 45 | 17.2889 | 0 | 0 | 0 | 0 | NULL | | 154 | Yosemite | 5 | 554 | 50000 | 151 | 0.167778 | 25 | 1.51 | 1 | 0 | 0 | 0 | 1008,1009,1010 | | 155 | Windsor | 3 | 555 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 1 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 156 | Monster A | 7 | 556 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 157 | Monster B | 7 | 557 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 1 | 0 | 0 | 0 | NULL | | 158 | Uranus | 12 | 558 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1088,1089,1090,1091,1092,1093,1163,1164,1165,1166,1167,1168 | | 159 | Jester | 12 | 559 | 50000 | 70 | 0.0777778 | 20 | 0.875 | 1 | 0 | 0 | 0 | 1008,1009,1010,1065,1066,1067,1068,1069,1070,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1087,1158,1159,1160,1161,1162,1173 | | 160 | Sultan | 11 | 560 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 0 | 0 | 0 | 0 | 1008,1009,1010,1026,1028,1029,1031,1032,1033,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1138,1139,1140,1141,1169,1170 | | 161 | Stratum | 13 | 561 | 50000 | 64 | 0.0711111 | 20 | 0.8 | 0 | 0 | 0 | 0 | 1008,1009,1010,1055,1056,1057,1058,1059,1060,1061,1064,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1154,1155,1156,1157 | | 162 | Elegy | 11 | 562 | 50000 | 60 | 0.0666667 | 20 | 0.75 | 1 | 0 | 0 | 0 | 1008,1009,1010,1034,1035,1036,1037,1038,1039,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1146,1147,1148,1149,1171,1172 | | 163 | Raindance | 4 | 563 | 50000 | 1360 | 1.51111 | 30 | 11.3333 | 0 | 0 | 0 | 0 | NULL | | 164 | RC Tiger | 10 | 564 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 165 | Flash | 12 | 565 | 50000 | 50 | 0.0555556 | 20 | 0.625 | 0 | 0 | 0 | 0 | 1008,1009,1010,1045,1046,1047,1048,1049,1050,1053,1054,1073,1074,1075,1077,1079,1080,1081,1082,1083,1085,1086,1087,1150,1151,1152,1153 | | 166 | Tahoma | 6 | 566 | 50000 | 68 | 0.0755556 | 20 | 0.85 | 0 | 0 | 0 | 0 | 1008,1009,1010,1076,1078,1086,1087,1097,1098 | | 167 | Savanna | 6 | 567 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1129,1130,1131,1133,1186,1187,1188,1189 | | 168 | Bandito | 7 | 568 | 50000 | 80 | 0.0888889 | 25 | 0.8 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 169 | Freight flat trailer | 16 | 569 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 170 | Streak trailer | 16 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 171 | Kart | 15 | 571 | 50000 | 4 | 0.00444444 | 10 | 0.1 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 172 | Mower | 15 | 572 | 50000 | 5 | 0.00555556 | 10 | 0.125 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 173 | Dune | 7 | 573 | 50000 | 897 | 0.996667 | 25 | 8.97 | 0 | 0 | 0 | 0 | NULL | | 174 | Sweeper | 15 | 574 | 50000 | 189 | 0.21 | 25 | 1.89 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 175 | Broadway | 6 | 575 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1042,1043,1044,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1174,1175,1176,1177 | | 176 | Tornado | 6 | 576 | 50000 | 76 | 0.0844444 | 20 | 0.95 | 0 | 0 | 0 | 0 | 1008,1009,1010,1075,1076,1077,1078,1079,1083,1084,1086,1087,1097,1098,1134,1135,1136,1190,1191,1192,1193 | | 177 | AT400 | 8 | 577 | 50000 | 20104 | 7.44593 | 60 | 83.7667 | 0 | 0 | 0 | 0 | NULL | | 178 | DFT-30 | 5 | 578 | 50000 | 125 | 0.138889 | 25 | 1.25 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 179 | Huntley | 7 | 579 | 50000 | 82 | 0.0911111 | 25 | 0.82 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 180 | Stafford | 11 | 580 | 50000 | 109 | 0.121111 | 20 | 1.3625 | 0 | 0 | 0 | 0 | 1001,1006,1007,1008,1009,1010,1018,1020,1023,1025,1074,1076,1078,1081,1082,1085,1087,1096,1097,1098 | | 181 | BF-400 | 1 | 581 | 50000 | 15 | 0.0166667 | 10 | 0.375 | 0 | 0 | 0 | 0 | NULL | | 182 | Newsvan | 5 | 582 | 50000 | 91 | 0.101111 | 25 | 0.91 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 183 | Tug | 15 | 583 | 50000 | 151 | 0.167778 | 25 | 1.51 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 184 | Fluids Trailer | 14 | 584 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 185 | Emperor | 11 | 585 | 50000 | 85 | 0.0944444 | 20 | 1.0625 | 0 | 0 | 0 | 0 | 1001,1003,1006,1007,1008,1009,1010,1013,1018,1019,1020,1023,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 186 | Wayfarer | 1 | 586 | 50000 | 25 | 0.0277778 | 10 | 0.625 | 0 | 0 | 0 | 0 | NULL | | 187 | Euros | 12 | 587 | 50000 | 72 | 0.08 | 20 | 0.9 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 188 | Hotdog | 15 | 588 | 50000 | 79 | 0.0877778 | 25 | 0.79 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 189 | Club | 12 | 589 | 50000 | 55 | 0.0611111 | 20 | 0.6875 | 0 | 0 | 0 | 0 | 1000,1004,1005,1006,1007,1008,1009,1010,1013,1016,1018,1020,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1145 | | 190 | Freight box trailer | 16 | 590 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 191 | Article Trailer | 14 | 591 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 192 | Andromada | 8 | 592 | 50000 | 90849 | 33.6478 | 60 | 378.538 | 0 | 0 | 0 | 0 | NULL | | 193 | Dodo | 8 | 593 | 50000 | 85 | 0.0944444 | 30 | 0.708333 | 0 | 0 | 0 | 0 | NULL | | 194 | RC Cam | 10 | 594 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | | 195 | Launch | 2 | 595 | 50000 | 100 | 0.111111 | 15 | 1.66667 | 0 | 0 | 0 | 0 | NULL | | 196 | Police Car (LSPD) | 9 | 596 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 197 | Police Car (SFPD) | 9 | 597 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 198 | Police Car (LVPD) | 9 | 598 | 50000 | 87 | 0.0966667 | 25 | 0.87 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 199 | Police Ranger | 9 | 599 | 50000 | 117 | 0.13 | 25 | 1.17 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 200 | Picador | 5 | 600 | 50000 | 83 | 0.0922222 | 25 | 0.83 | 0 | 0 | 0 | 0 | 1004,1005,1006,1007,1008,1009,1010,1013,1018,1020,1022,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 201 | S.W.A.T. | 9 | 601 | 50000 | 378 | 0.42 | 30 | 3.15 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 202 | Alpha | 12 | 602 | 50000 | 75 | 0.0833333 | 20 | 0.9375 | 0 | 0 | 0 | 0 | 1008,1009,1010,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098 | | 203 | Phoenix | 12 | 603 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1001,1006,1007,1008,1009,1010,1018,1019,1020,1023,1024,1025,1074,1076,1078,1081,1082,1085,1086,1087,1096,1097,1098,1143,1145 | | 204 | Glendale Shit | 11 | 604 | 50000 | 79 | 0.0877778 | 20 | 0.9875 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 205 | Sadler Shit | 5 | 605 | 50000 | 72 | 0.08 | 25 | 0.72 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 206 | Baggage Trailer A | 14 | 606 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 207 | Baggage Trailer B | 14 | 607 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 208 | Tug Stairs Trailer | 14 | 608 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 209 | Boxville 2 | 5 | 609 | 50000 | 102 | 0.113333 | 25 | 1.02 | 0 | 0 | 0 | 0 | 1008,1009,1010 | | 210 | Farm Trailer | 14 | 610 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | | 211 | Utility Trailer | 14 | 611 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | +-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+