Vehicle System

[KrlozZ...]

Hey, i have make a other vehicle system to Create vehicles, and owner things, i have get it from Luis_Baraca script just have make it SQL and put some modifcations.

Have tested it all, and it works fine, if you found some bug, tell me.
It uses sql. so be sure to get the plugin.

Credits:
Credits for Blank Script to sseebbyy.
Credits for Vehicle System to Luis_Labarca.
Credits for make it SQL to KrlozZ...
Credits for cmds "Removecar, Setowner, Carsforsale, Car, Driver" to KrlozZ...
Credits for Sharecar for 2 players to KrlozZ...

Cmds for Admins: addcar, changecol, changepos, removecar, setowner, carsforsale.
Cmds for players: buycar, sellcar, sharecar, delsharecar, mycars, mysharedcars, car, driver.

Here is it:

[luchgox]

Nice working

[!]

It uses mysql. so be sure to get the plugin.

Credits for make it SQL to KrlozZ...

?

[KrlozZ...]

It uses mysql. so be sure to get the plugin.

Credits for make it SQL to KrlozZ...

?

It was ini :p and i make it to use databases. ._. Thats.

[!]

It uses mysql. so be sure to get the plugin.

?

It was ini :p and i make it to use databases. ._. Thats.

Vehicles <- ConnectSQL( "Databases/Vehicles.db" );

Its SQL not MySQL.

[KrlozZ...]

It uses mysql. so be sure to get the plugin.

?

It was ini :p and i make it to use databases. ._. Thats.

Vehicles <- ConnectSQL( "Databases/Vehicles.db" );

Its SQL not MySQL.

Hmm ._. Kk my mistake, i edited it n.n

[Zone_Killer]

Nice

[kennedyarz]

Use this method, so there will be no need to restart the server so that the vehicle appears where I put it

Code Select Expand

    else if (cmd=="park")
    {
    if ( !player.IsSpawned ) MessagePlayer("You need be spawned to use this command.", player );
    else if ( player.Vehicle ) MessagePlayer("You must be outside of the vehicle.", player );
    else if( !text ) MessagePlayer("Use /"+cmd+" <Veh/ID>", player);
    else if (!IsNum(text)) MessagePlayer("Use /"+cmd+" <Veh/ID>", player);
    else if (!FindVehicle(text.tointeger())) MessagePlayer("Vehicle ID does not exist.",player);
    else {
    local v=FindVehicle(text.tointeger());
    QuerySQL( db,"UPDATE Vehicles SET PX='"+player.Pos.x+"' WHERE ID='"+v.ID+"'");
    QuerySQL( db,"UPDATE Vehicles SET PY='"+player.Pos.y+"' WHERE ID='"+v.ID+"'");
    QuerySQL( db,"UPDATE Vehicles SET PZ='"+player.Pos.z+"' WHERE ID='"+v.ID+"'");
    QuerySQL( db,"UPDATE Vehicles SET Angle='"+player.Angle+"' WHERE ID='"+v.ID+"'");
v.SpawnPos = Vector( v.Pos.x, v.Pos.y, v.Pos.z );
    v.SpawnAngle = v.Angle;
    MessagePlayer( "Parked Vehicle!", player );
    MessagePlayer("You have changed car ID "+v.ID+" Position." , player );
        }
    }

[KrlozZ...]

Oh thank you i was finding a function for that, but that one was deleted :/.

thanks!

[Xmair]

Use this method, so there will be no need to restart the server so that the vehicle appears where I put it

Code Select Expand

QuerySQL( db,"UPDATE Vehicles SET PX='"+player.Pos.x+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PY='"+player.Pos.y+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PZ='"+player.Pos.z+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET Angle='"+player.Angle+"' WHERE ID='"+v.ID+"'");


Code Select Expand

QuerySQL( db, "UPDATE Vehicles SET PX = '" + player.Pos.x + "', PY = '" + player.Pos.y + "', PZ = '" + player.Pos.z + "', Angle = '" + player.Angle + "' WHERE ID = " + v.ID );

[kennedyarz]

Use this method, so there will be no need to restart the server so that the vehicle appears where I put it

Code Select Expand

QuerySQL( db,"UPDATE Vehicles SET PX='"+player.Pos.x+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PY='"+player.Pos.y+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PZ='"+player.Pos.z+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET Angle='"+player.Angle+"' WHERE ID='"+v.ID+"'");


Code Select Expand

QuerySQL( db, "UPDATE Vehicles SET PX = '" + player.Pos.x + "', PY = '" + player.Pos.y + "', PZ = '" + player.Pos.z + "', Angle = '" + player.Angle + "' WHERE ID = " + v.ID );

Not recommended as it confuses the newbie, it is better to do it separate and will see more if he has an error.

[KAKAN]

Not recommended as it confuses the newbie, it is better to do it separate and will see more if he has an error.

Code Select Expand

local pPos = player.Pos;
local query = format("UPDATE Vehicles( PX, PY, PZ, Angle ) VALUES( %f, %f, %f, %f ) WHERE ID=%i",
 pPos.x,
 pPos.y,
 pPos.z,
 player.Angle,
 v.ID
);
QuerySQL( db, query );Okay now?

[Thijn]

Not recommended as it confuses the newbie, it is better to do it separate and will see more if he has an error.

Code Select Expand

local pPos = player.Pos;
local query = format("UPDATE Vehicles( PX, PY, PZ, Angle ) VALUES( %f, %f, %f, %f ) WHERE ID=%i",
 pPos.x,
 pPos.y,
 pPos.z,
 player.Angle,
 v.ID
);
QuerySQL( db, query );Okay now?

That is not a valid query.

Use this method, so there will be no need to restart the server so that the vehicle appears where I put it

Code Select Expand

QuerySQL( db,"UPDATE Vehicles SET PX='"+player.Pos.x+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PY='"+player.Pos.y+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET PZ='"+player.Pos.z+"' WHERE ID='"+v.ID+"'");
QuerySQL( db,"UPDATE Vehicles SET Angle='"+player.Angle+"' WHERE ID='"+v.ID+"'");


Code Select Expand

QuerySQL( db, "UPDATE Vehicles SET PX = '" + player.Pos.x + "', PY = '" + player.Pos.y + "', PZ = '" + player.Pos.z + "', Angle = '" + player.Angle + "' WHERE ID = " + v.ID );

Not recommended as it confuses the newbie, it is better to do it separate and will see more if he has an error.

And then they are confused because their server lags. Nah. It's better to teach them correctly, and just explain what's happening instead of learning them the wrong way.

[kennedyarz]

ok

[Mohamed Boubekri]

I have test this and it Work
Keep up my friend.