[Include] vehicles.inc - Automatic MySQL vehicle information loading and saving.

[Include] vehicles.inc - Automatic MySQL vehicle information loading and saving. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] vehicles.inc - Automatic MySQL vehicle information loading and saving. (/showthread.php?tid=577972)

vehicles-orm.inc - Automatic MySQL vehicle information loading and saving. - theYiin - 15.06.2015

Hey there,

this include helps to save and load information of vehicles without much effort.

Available functions:

Code:

// Get unique vehicle id (sql id)
stock GetVehicleUID(vehicleid);

// Create a vehicle. This function will create an entry in database for vehicle too.
stock AddVehicle(model, Float:x, Float:y, Float:z, Float:a, color1 = -1, color2 = -1);

// Load vehicle from database by vehicles UID (sqlid) or from active cache (use row parameter for that). Set applydata to false, if you dont want to apply loaded vehicle information (position, color, health)
stock LoadVehicle(sqlid = -1, row = 0, applydata = true);

// Save vehicle. Set update_pos to false if you don't want to save current vehicle position, and set remove to true, if you want to destroy vehicle from world.
stock SaveVehicle(vehicleid, update_pos = true, remove = false);

// Deletes vehicle entirely, both from game and from database. Cannot be undone.
stock DeleteVehicle(vehicleid);

Callbacks:

Code:

// Gets called when new vehicle is inserted into database
forward OnVehicleInsert(vehicleid);

// In this callback you can specify which information you want to be automatically loaded and saved
forward OnCreateVehicleORM(ORM:ormid, vehicleid);

Example:

PHP Code:



#include <a_samp>

#include <a_mysql>

#include <vehicles>


// you vehicle information enum

enum vehicle_e_DATA {

    owner[MAX_PLAYER_NAME], // name, because I wanted to make example using string variable

    Float:fuel,

    Float:run,

    price

};

new vehicleDB[MAX_VEHICLES][vehicle_e_DATA];


/* ... other code ... */


public OnVehicleInsert(vehicleid) {

    print("Vehicle (id: %i, sql id: %i) was successfully inserted into database!", 

        vehicleid, GetVehicleUID(vehicleid));

}


public OnCreateVehicleORM(ORM:ormid, vehicleid) {

    // information you want to be automatically saved and loaded

    // don't forget to create additional fields in `vehicles` table

    orm_addvar_string(ormid, vehicleDB[vehicleid][owner], "owner");

    orm_addvar_float(ormid, vehicleDB[vehicleid][fuel], "fuel");

    orm_addvar_float(ormid, vehicleDB[vehicleid][run], "run");

    orm_addvar_int(ormid, vehicleDB[vehicleid][price], "price");

}

For this include to work, you will need this MySQL plugin: https://sampforum.blast.hk/showthread.php?tid=56564
SQL file to create basic `vehicles` table structure: http://pastebin.com/3gtLVTMD
vehicles.inc: http://pastebin.com/hnw1GFL7

This include covers this information by default:

Model
Position (including angle)
Color
Health

Questions or suggesions?

grammar is bit fked up, feel free to correct me if needed!

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Gammix - 15.06.2015

Hardly useful until it saves all vehicle information, Specially:
- Components (moding shops)
- Paintjob
- Attached Objects
- Damage status (like poped tires and so)

pawn Code:

static
        database,
        ORM:vehicle_ORM[MAX_VEHICLES],
        vehicle_ID[MAX_VEHICLES],
        vehicle_Model[MAX_VEHICLES],
        vehicle_Color1[MAX_VEHICLES],
        vehicle_Color2[MAX_VEHICLES],
        Float:vehicle_Health[MAX_VEHICLES],
        Float:vehicle_PosX[MAX_VEHICLES],
        Float:vehicle_PosY[MAX_VEHICLES],
        Float:vehicle_PosZ[MAX_VEHICLES],
        Float:vehicle_PosA[MAX_VEHICLES]
;

Use arrays; because its much better to handle them and saves memory.

You have hooked ChangeVehicleColor but what if the player resprays his/her vehicle. This won't save the color.

pawn Code:

static query[500];

I would recommend a local array for queries or any purpose related to formatting strings.

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Calgon - 15.06.2015

SQLite would have made a lot more sense for a portable include.

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - theYiin - 15.06.2015

Quote:

Originally Posted by Gammix

Hardly useful until it saves all vehicle information, Specially:
- Components (moding shops)
- Paintjob
- Attached Objects
- Damage status (like poped tires and so)

You can add any additional information by yourself, the point of this include is to have a base for easy vehicle information loading and saving.

Quote:

Originally Posted by Gammix

pawn Code:

static
        database,
        ORM:vehicle_ORM[MAX_VEHICLES],
        vehicle_ID[MAX_VEHICLES],
        vehicle_Model[MAX_VEHICLES],
        vehicle_Color1[MAX_VEHICLES],
        vehicle_Color2[MAX_VEHICLES],
        Float:vehicle_Health[MAX_VEHICLES],
        Float:vehicle_PosX[MAX_VEHICLES],
        Float:vehicle_PosY[MAX_VEHICLES],
        Float:vehicle_PosZ[MAX_VEHICLES],
        Float:vehicle_PosA[MAX_VEHICLES]
;

Use arrays; because its much better to handle them and saves memory.

I'm pretty sure these ARE indeed arrays lol.

Quote:

Originally Posted by Gammix

You have hooked ChangeVehicleColor but what if the player resprays his/her vehicle. This won't save the color.

Good point, thanks! Fixed.

Quote:

Originally Posted by Gammix

pawn Code:

static query[500];

I would recommend a local array for queries or any purpose related to formatting strings.

Ugh, not sure why? Just moment ago you were talking about saving memory lol

Quote:

Originally Posted by Calgon

SQLite would have made a lot more sense for a portable include.

SQLite doen't support orm.

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Yashas - 15.06.2015

For those who are already using MySQL, this will be an easy integration (just has to include and with few modifications the vehicles from now on will get saved)!!!!

You just also add features to save components and paintjobs.I don't think anyone would need to store damage status.I find spawning damaged cars funny

You should also try to keep the include versatile by providing options for storage system(MySQL,SQLite,INI).

Good Work!

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - dusk - 15.06.2015

Quote:

Originally Posted by Yashas

For those who are already using MySQL, this will be an easy integration (just has to include and vehicles from now on will get saved)!!!!

Well not quite. You still have to use the functions provided for them to be saved.

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Yashas - 15.06.2015

My bad, I always screw things because I don't put what is on my mind on paper properly.

Here is what I meant by it, just include and with 2 loops and everything gets saved.

Anyway thanks for pointing that out, edited.

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Pottus - 15.06.2015

When you replied with the follow.

"You can add any additional information by yourself, the point of this include is to have a base for easy vehicle information loading and saving."

I must disagree with your response and agree with Gammix the reason is I feel that there is realistically only so much a user is going to need to actually save. If a user really does indeed need to use more than standard saved data then to me that is an appropriate time in which adding their own load/unload data would be useful. I would like to expand on how it should be done.

My suggestion is to create a standard load/unload include that contains all information for a vehicle including support for attached objects this would greatly improve the use.

Another thing is you named this so damn generic in the topic "vehicles.inc" it means nothing really

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - theYiin - 15.06.2015

Quote:

Originally Posted by Pottus

Another thing is you named this so damn generic in the topic "vehicles.inc" it means nothing really.

yup, that's true. vehicles-orm.inc should do the job.

And yeah, support for vehicle components, paintjob and attached objects is in progress. Thanks for feedback!

Re: vehicles.inc - Automatic MySQL vehicle information loading and saving. - Pottus - 15.06.2015

I also should mention to make sure it also can save objects that have text/materials/colors as well this is important.