1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Discussion

Threaded Mode
Server database structure
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#1

12.09.2014, 12:37
( Last edited by dusk; 12/09/2014 at 06:06 PM. )
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?
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#2

13.09.2014, 10:19
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.
Find
Reply
RajatPawar
High-roller
*****
Posts: 2,187
Threads: 81
Joined: Aug 2011
Reputation: 0
#3

13.09.2014, 10:31
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?)
Find
Reply
iFarbod
Gangsta
****
Posts: 610
Threads: 18
Joined: Jan 2014
Reputation: 0
#4

13.09.2014, 11:45
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.
Find
Reply
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#5

13.09.2014, 13:39
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.
Find
Reply
IceCube!
High-roller
*****
Posts: 1,765
Threads: 1
Joined: Aug 2011
Reputation: 0
#6

13.09.2014, 14:50
Quote:
Originally Posted by dusk
View Post
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.
In all honesty that's nothing... there are lots of massive MySQL databases out there with dozens, and dozens of tables. As Y_Less said they are likely specialized tables which is a good thing.

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.
Find
Reply
Pottus
High-roller
*****
Posts: 4,885
Threads: 57
Joined: Jun 2012
Reputation: 0
#7

13.09.2014, 14:51
You can never have too many tables but you can have too many fields in a table!
Find
Reply
PowerPC603
High-roller
*****
Posts: 1,733
Threads: 20
Joined: Nov 2010
Reputation: 0
#8

24.02.2015, 10:40
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
Should I remove that last column and create a separate table for it, like this:
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 |
+-------+-----------+
And load this table separately?

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];
Using this function:
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;
}
It was only one line (see the sscanf-line) to load all values from that single column, separate them using sscanf and put them all at once in the proper enum-field in the array.

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.
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#9

24.02.2015, 14:14
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
Find
Reply
PowerPC603
High-roller
*****
Posts: 1,733
Threads: 20
Joined: Nov 2010
Reputation: 0
#10

24.02.2015, 14:32
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.
Find
Reply
Extremo
Gangsta
****
Posts: 717
Threads: 11
Joined: Jul 2008
Reputation: 0
#11

24.02.2015, 15:13
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.
Find
Reply
PowerPC603
High-roller
*****
Posts: 1,733
Threads: 20
Joined: Nov 2010
Reputation: 0
#12

25.02.2015, 09:32
( Последний раз редактировалось PowerPC603; 25.02.2015 в 15:11. )
I found something nice:

Код:
SELECT model, GROUP_CONCAT(component SEPARATOR '-') AS components FROM vehicleinfocomponents GROUP BY model;
On this table (it's much longer than this, it's actually 1750 rows, but you get the idea):
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 |
+-------+-----------+
Gives me this result:
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 only need to use 1 query to read the entire table.
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.
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#13

25.02.2015, 15:02
I really need to learn more MySQL. There's so many possibilities that I don't even know of.
Find
Reply
kirk
Huge Clucker
***
Posts: 221
Threads: 0
Joined: Oct 2010
Reputation: 0
#14

25.02.2015, 16:41
Quote:
Originally Posted by Vince
View Post
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.
You don't always have to normalizate your database to the full, that means, for example if you are going to have just 3 weapons max per player, you don't need a new table. Joins are not that cheap.

Its good to normalizate your database, and its also good to denormalizate it a bit and also allow some controlled redundancy if need.
Find
Reply
PowerPC603
High-roller
*****
Posts: 1,733
Threads: 20
Joined: Nov 2010
Reputation: 0
#15

25.02.2015, 21:48
( Последний раз редактировалось PowerPC603; 26.02.2015 в 07:55. )
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 query lists all my columns from the first table (vehicleinfo) and adds to each row the group_concat-ed components from the second table (vehicleinfocomponents), and inserts "NULL" where a vehiclemodel doesn't have any components.

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                                                                                                                                   |
+-----+----------------------+-------+-------+-------+---------+-------------+------------+---------------------+---------------+----------+--------------+----------+----------------------------------------------------------------------------------------------------------------------------------------+
This is actually the exact same result as using "select * from vehicleinfo" from my table before the column with multiple components was moved out of there to create a new table with all components on a separate row.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Discussion