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

Threaded Mode
Script help
Ax3l123
Big Clucker
***
Posts: 71
Threads: 28
Joined: Jan 2013
Reputation: 0
#1

08.02.2016, 15:15
Hello , i found a gamemode on the internet and started changing some stuff .
I realised that every time someone spawns a personal vehicle it has 100% fuel .So i thought i could change that with mysql .I have created a new collumn named Gas and put in every line 99 .When i spawn the car it has 99% fuel as it is supposed to but if i use it and that despawn it the db doesen't update .
here's the code:
PHP код:
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
    new x_nr[50],getcarid = GetPlayerVehicleID(playerid),string[256];
    if(sscanf(params, "s[50]",x_nr)) return SCM(playerid,COLOR_WHITE,"{B8DBFF}Syntax: /vehspawn <Car-Moto-Heli-PCar>");
    if(getcarid != personalcar[playerid]) return SCM(playerid,COLOR_WHITE,"{FFB870}Tu nu esti in masina ta.");
    if(strcmp(x_nr,"car",true) == 0)
    {
        if(PlayerInfo[playerid][pPcarkey] == 0) return SCM(playerid,COLOR_WHITE,"{FFB870}You do not own a car.");
        if(OwnedVeh(getcarid) == PlayerInfo[playerid][pPcarkey]) return SCM(playerid,COLOR_WHITE,"{FFB870}You already have car spawned.");
        if(personalcar[playerid] != 0)
        {
            if(CarInfo[OwnedVeh(personalcar[playerid])][cNeon] != 0)
            {
                DestroyObject(Neon1[personalcar[playerid]]);
                DestroyObject(Neon2[personalcar[playerid]]);
                Neon1[personalcar[playerid]] = 0;
                Neon2[personalcar[playerid]] = 0;
            }
            vUpdate(OwnedVeh(personalcar[playerid]), cKMx);
            vUpdate(OwnedVeh(personalcar[playerid]), cGasx);
            DestroyVehicle(personalcar[playerid]);
            OwnedVeh(personalcar[playerid]) = 0;
            personalcar[playerid] = 0;
        }
        new carid = PlayerInfo[playerid][pPcarkey];
        new car = CreateVehicle(CarInfo[carid][cModel],CarInfo[carid][cLocationx],CarInfo[carid][cLocationy],CarInfo[carid][cLocationz],CarInfo[carid][cAngle],CarInfo[carid][cColorOne],CarInfo[carid][cColorTwo],500000);
        SetVehicleNumberPlate(car, CarInfo[carid][cLicense]);
        Gas[car] = (CarInfo[carid][cGas]);
        new engine,lights,alarm,doors,bonnet,boot,objective;
        if(CarInfo[carid][cLock] == 1)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,1,bonnet,boot,objective);
        }
        if(CarInfo[carid][cLock] == 0)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,0,bonnet,boot,objective);
        }
        OwnedVeh(car) = carid;
        personalcar[playerid] = car;
        format(string,sizeof(string),"{FFB870}You spawned your %s.",CarInfo[carid][cDescription]);
        SCM(playerid,COLOR_WHITE,string);
        
        SwitchKey[playerid] = 1;
        ModVehicle(car);
        if(CarInfo[carid][cNeon] != 0)
        {
            if(CarInfo[carid][cNeon] == 1)
            {
                Neon1[personalcar[playerid]] = CreateObject(18648,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18648,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 2)
            {
                Neon1[personalcar[playerid]] = CreateObject(18647,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18647,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 3)
            {
                Neon1[personalcar[playerid]] = CreateObject(18649,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18649,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 4)
            {
                Neon1[personalcar[playerid]] = CreateObject(18652,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18652,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 5)
            {
                Neon1[personalcar[playerid]] = CreateObject(18651,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18651,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 6)
            {
                Neon1[personalcar[playerid]] = CreateObject(18650,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18650,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
        }
        return 1;
    }
    if(strcmp(x_nr,"moto",true) == 0)
    {
        if(PlayerInfo[playerid][pmotokey] == 0) return SCM(playerid,COLOR_WHITE,"{FFB870}You do not own a Moto/Bike.");
        if(OwnedVeh(getcarid) == PlayerInfo[playerid][pmotokey]) return SCM(playerid,COLOR_WHITE,"{FFB870}You already have moto/bike spawned.");
        if(personalcar[playerid] != 0)
        {
            if(CarInfo[OwnedVeh(personalcar[playerid])][cNeon] != 0)
            {
                DestroyObject(Neon1[personalcar[playerid]]);
                DestroyObject(Neon2[personalcar[playerid]]);
                Neon1[personalcar[playerid]] = 0;
                Neon2[personalcar[playerid]] = 0;
            }
            vUpdate(OwnedVeh(personalcar[playerid]), cKMx);
            vUpdate(OwnedVeh(personalcar[playerid]), cGasx);
            DestroyVehicle(personalcar[playerid]);
            OwnedVeh(personalcar[playerid]) = 0;
            personalcar[playerid] = 0;
        }
        new carid = PlayerInfo[playerid][pmotokey];
        new car = CreateVehicle(CarInfo[carid][cModel],CarInfo[carid][cLocationx],CarInfo[carid][cLocationy],CarInfo[carid][cLocationz],CarInfo[carid][cAngle],CarInfo[carid][cColorOne],CarInfo[carid][cColorTwo],500000);
        SetVehicleNumberPlate(car, CarInfo[carid][cLicense]);
        Gas[car] = (CarInfo[carid][cGas]);
        new engine,lights,alarm,doors,bonnet,boot,objective;
        if(CarInfo[carid][cLock] == 1)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,1,bonnet,boot,objective);
        }
        if(CarInfo[carid][cLock] == 0)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,0,bonnet,boot,objective);
        }
        OwnedVeh(car) = PlayerInfo[playerid][pmotokey];
        personalcar[playerid] = car;
        format(string,sizeof(string),"{FFB870}You spawned your %s.",CarInfo[carid][cDescription]);
        SCM(playerid,COLOR_WHITE,string);
        SwitchKey[playerid] = 1;
        ModVehicle(car);
        return 1;
    }
    if(strcmp(x_nr,"heli",true) == 0)
    {
        if(PlayerInfo[playerid][phelikey] == 0) return SCM(playerid,COLOR_WHITE,"{FFB870}You do not own a Helicopter.");
        if(OwnedVeh(getcarid) == PlayerInfo[playerid][phelikey]) return SCM(playerid,COLOR_WHITE,"{FFB870}You already have helicopter spawned.");
        if(personalcar[playerid] != 0)
        {
            if(CarInfo[OwnedVeh(personalcar[playerid])][cNeon] != 0)
            {
                DestroyObject(Neon1[personalcar[playerid]]);
                DestroyObject(Neon2[personalcar[playerid]]);
                Neon1[personalcar[playerid]] = 0;
                Neon2[personalcar[playerid]] = 0;
            }
            vUpdate(OwnedVeh(personalcar[playerid]), cKMx);
            vUpdate(OwnedVeh(personalcar[playerid]), cGasx);
            DestroyVehicle(personalcar[playerid]);
            OwnedVeh(personalcar[playerid]) = 0;
            personalcar[playerid] = 0;
        }
        new carid = PlayerInfo[playerid][phelikey];
        new car = CreateVehicle(CarInfo[carid][cModel],CarInfo[carid][cLocationx],CarInfo[carid][cLocationy],CarInfo[carid][cLocationz],CarInfo[carid][cAngle],CarInfo[carid][cColorOne],CarInfo[carid][cColorTwo],500000);
        SetVehicleNumberPlate(car, CarInfo[carid][cLicense]);
        Gas[car] = (CarInfo[carid][cGas]);
        new engine,lights,alarm,doors,bonnet,boot,objective;
        if(CarInfo[carid][cLock] == 1)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,1,bonnet,boot,objective);
        }
        if(CarInfo[carid][cLock] == 0)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,0,bonnet,boot,objective);
        }
        OwnedVeh(car) = carid;
        personalcar[playerid] = car;
        format(string,sizeof(string),"{FFB870}You spawned your %s.",CarInfo[carid][cDescription]);
        SCM(playerid,COLOR_WHITE,string);
        SwitchKey[playerid] = 1;
        ModVehicle(car);
        return 1;
    }
    if(strcmp(x_nr,"pcar",true) == 0)
    {
        if(PlayerInfo[playerid][pprcarkey] == 0) return SCM(playerid,COLOR_WHITE,"{FFB870}You do not own a Premium Car.");
        if(OwnedVeh(getcarid) == PlayerInfo[playerid][pprcarkey]) return SCM(playerid,COLOR_WHITE,"{FFB870}You already have premium car spawned.");
        if(personalcar[playerid] != 0)
        {
            if(CarInfo[OwnedVeh(personalcar[playerid])][cNeon] != 0)
            {
                DestroyObject(Neon1[personalcar[playerid]]);
                DestroyObject(Neon2[personalcar[playerid]]);
                Neon1[personalcar[playerid]] = 0;
                Neon2[personalcar[playerid]] = 0;
            }
            vUpdate(OwnedVeh(personalcar[playerid]), cKMx);
            vUpdate(OwnedVeh(personalcar[playerid]), cGasx);
            DestroyVehicle(personalcar[playerid]);
            OwnedVeh(personalcar[playerid]) = 0;
            personalcar[playerid] = 0;
        }
        new carid = PlayerInfo[playerid][pprcarkey];
        new car = CreateVehicle(CarInfo[carid][cModel],CarInfo[carid][cLocationx],CarInfo[carid][cLocationy],CarInfo[carid][cLocationz],CarInfo[carid][cAngle],CarInfo[carid][cColorOne],CarInfo[carid][cColorTwo],500000);
        SetVehicleNumberPlate(car, CarInfo[carid][cLicense]);
        new engine,lights,alarm,doors,bonnet,boot,objective;
        if(CarInfo[carid][cLock] == 1)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,1,bonnet,boot,objective);
        }
        if(CarInfo[carid][cLock] == 0)
        {
            GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
            SetVehicleParamsEx(car,engine,lights,alarm,0,bonnet,boot,objective);
        }
        OwnedVeh(car) = carid;
        personalcar[playerid] = car;
        format(string,sizeof(string),"{FFB870}You spawned your %s.",CarInfo[carid][cDescription]);
        SCM(playerid,COLOR_WHITE,string);
        SwitchKey[playerid] = 1;
        ModVehicle(car);
        if(CarInfo[carid][cNeon] != 0)
        {
            if(CarInfo[carid][cNeon] == 1)
            {
                Neon1[personalcar[playerid]] = CreateObject(18648,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18648,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 2)
            {
                Neon1[personalcar[playerid]] = CreateObject(18647,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18647,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 3)
            {
                Neon1[personalcar[playerid]] = CreateObject(18649,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18649,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 4)
            {
                Neon1[personalcar[playerid]] = CreateObject(18652,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18652,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 5)
            {
                Neon1[personalcar[playerid]] = CreateObject(18651,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18651,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
            else if(CarInfo[carid][cNeon] == 6)
            {
                Neon1[personalcar[playerid]] = CreateObject(18650,0,0,0,0,0,0);
                Neon2[personalcar[playerid]] = CreateObject(18650,0,0,0,0,0,0);
                AttachObjectToVehicle(Neon1[personalcar[playerid]], car, -0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
                 AttachObjectToVehicle(Neon2[personalcar[playerid]], car, 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
            }
        }
        return 1;
    }
    return 1;
} 
PHP код:
public vUpdate(vehicleid, type)
{
    new gQuery[1024];
    switch(type)
    {
        case cLocationxx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Locationx`='%f' WHERE `ID`='%d'",CarInfo[vehicleid][cLocationx],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cLocationyx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Locationy`='%f' WHERE `ID`='%d'",CarInfo[vehicleid][cLocationy],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cLocationzx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Locationz`='%f' WHERE `ID`='%d'",CarInfo[vehicleid][cLocationz],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cAnglex:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Angle`='%f' WHERE `ID`='%d'",CarInfo[vehicleid][cAngle],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cModelx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Model`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cModel],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cColorOnex:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `ColorOne`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cColorOne],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cColorTwox:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `ColorTwo`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cColorTwo],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cOwnerx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Owner`='%s' WHERE `ID`='%d'",CarInfo[vehicleid][cOwner],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cValuex:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Value`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cValue],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cLicensex:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `License`='%s' WHERE `ID`='%d'",CarInfo[vehicleid][cLicense],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cDescriptionx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Description`='%s' WHERE `ID`='%d'",CarInfo[vehicleid][cDescription],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cLockx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Lockk`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cLock],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cTimedx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Timed`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cTimed],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cInscarpricex:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Inscarprice`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cInscarprice],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cInsurancecarx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Insurancecar`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cInsurancecar],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cKMx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `KM`='%.2f' WHERE `ID`='%d'",CarInfo[vehicleid][cKM],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cOwnedx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Owned`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cOwned],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cSellx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Sell`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cSell],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cModsx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `mod1`='%d',`mod2`='%d',`mod3`='%d',`mod4`='%d',`mod5`='%d',`mod6`='%d',`mod7`='%d',`mod8`='%d',`mod9`='%d',`mod10`='%d',`mod11`='%d',`mod12`='%d',`mod13`='%d',`mod14`='%d',`mod15`='%d',`mod16`='%d',`mod17`='%d' WHERE `ID`='%d'",
            CarInfo[vehicleid][mod1],
            CarInfo[vehicleid][mod2],
            CarInfo[vehicleid][mod3],
            CarInfo[vehicleid][mod4],
            CarInfo[vehicleid][mod5],
            CarInfo[vehicleid][mod6],
            CarInfo[vehicleid][mod7],
            CarInfo[vehicleid][mod8],
            CarInfo[vehicleid][mod9],
            CarInfo[vehicleid][mod10],
            CarInfo[vehicleid][mod11],
            CarInfo[vehicleid][mod12],
            CarInfo[vehicleid][mod13],
            CarInfo[vehicleid][mod14],
            CarInfo[vehicleid][mod15],
            CarInfo[vehicleid][mod16],
            CarInfo[vehicleid][mod17],
            vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cPaintJx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `PaintJ`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cPaintJ],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cNeonx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Neon`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cNeon],vehicleid);
            mysql_query(SQL, gQuery);
        }
        case cGasx:
        {
            format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `Gas`='%d' WHERE `ID`='%d'",CarInfo[vehicleid][cGas],vehicleid);
            mysql_query(SQL, gQuery);
        }
    }
    return 1;
} 
Find
Reply
Ax3l123
Big Clucker
***
Posts: 71
Threads: 28
Joined: Jan 2013
Reputation: 0
#2

08.02.2016, 18:44
bump
Find
Reply
ikey07
High-roller
*****
Posts: 1,167
Threads: 57
Joined: Jul 2010
Reputation: 0
#3

08.02.2016, 18:56
OnVehicleDeath and OnVehicleRespawn, get fuel and save it.

Also small tip, can you tell what is common in each case state in vUpdate?
Its mysql_query(SQL, gQuery);
You can save up to 23 script lines, by putting mysql_query(SQL, gQuery); at the very end of the cases before return 1; and delete it from each case individually.

pawn Код:
mysql_query(SQL, gQuery);
return 1;
}
Most likely you wont use it, but I can always suggest.
Find
Reply
Ax3l123
Big Clucker
***
Posts: 71
Threads: 28
Joined: Jan 2013
Reputation: 0
#4

08.02.2016, 19:19
and how should i get the gas ?
Find
Reply
amirm3hdi
Banned
Posts: 270
Threads: 7
Joined: Apr 2015
#5

08.02.2016, 19:21
WOW What a dumb code, instead of using those long ass cases, use a string parameter...

Example:
Код:
public vUpdate(vehicleid, type[]) 
{ 
    new gQuery[1024]; 
    format(gQuery,sizeof(gQuery),"UPDATE `cars` SET `%e`='%f' WHERE `ID`='%d'", type, CarInfo[vehicleid][cLocationx],vehicleid)
}
Done.
Find
Reply
ikey07
High-roller
*****
Posts: 1,167
Threads: 57
Joined: Jul 2010
Reputation: 0
#6

08.02.2016, 19:23
Gas[car] = (CarInfo[carid][cGas]);

This is your gas stat, when car gets destroyed or respawned, use it oposite CarInfo[carid][cGas] = Gas[car];
and then save it as you would save any other stat.
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