Mysql vehicle system - Printable Version

Mysql vehicle system - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql vehicle system (/showthread.php?tid=583613)

Mysql vehicle system - iulicxd - 29.07.2015

Код:

enum pInfo
{
     pCarID

};
new PlayerInfo[MAX_PLAYERS][pInfo];

enum cInfo
{
	ORM:ORM_ID,
	ID,
	Owner[MAX_PLAYER_NAME],
	Locked,
	Float:Vposx,
	Float:Vposy,
	Float:Vposz,
	Float:Vposa,
	Model,
	Color1,
	Color2,
	CarID
};

new CarInfo[MAX_VEHICLES][cInfo];
new TotalVeh;

public OnGameModeInit()
{
    mysql_tquery(g_SQL, "SELECT * FROM `vehicles`", "OnVehiclesLoad", "");
    return 1;
}

public OnPlayerConnect(playerid)
{
    PlayerInfo[playerid][pCarID] = -1;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    PlayerInfo[playerid][pCarID] = -1;
    return 1;
}

forward OnVehiclesLoad();
public OnVehiclesLoad()
{
    new time = GetTickCount();
    new c;
	for(c = 0; c < cache_num_rows(); c++) {
		new ORM:ormid = CarInfo[c][ORM_ID] = orm_create("vehicles");
		orm_addvar_int(ormid, CarInfo[c][ID], "ID");
		orm_setkey(ormid, "ID");
		orm_addvar_string(ormid, CarInfo[c][Owner], MAX_PLAYER_NAME, "Owner");
		orm_addvar_int(ormid, CarInfo[c][Locked], "Locked");
		orm_addvar_float(ormid, CarInfo[c][Vposx], "Vposx");
		orm_addvar_float(ormid, CarInfo[c][Vposy], "Vposy");
		orm_addvar_float(ormid, CarInfo[c][Vposz], "Vposz");
		orm_addvar_float(ormid, CarInfo[c][Vposa], "Vposa");
		orm_addvar_int(ormid, CarInfo[c][Model], "Model");
		orm_addvar_int(ormid, CarInfo[c][Color1], "Color1");
		orm_addvar_int(ormid, CarInfo[c][Color2], "Color2");
		orm_apply_cache(ormid, c);
		TotalVeh++;
		CarInfo[c][CarID] = CreateVehicle(CarInfo[c][Model], CarInfo[c][Vposx], CarInfo[c][Vposy], CarInfo[c][Vposz], CarInfo[c][Vposa], CarInfo[c][Color1], CarInfo[c][Color2], -1);
	}
	printf("%d personal cars loaded with %d ms",TotalVeh,GetTickCount() - time);
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    if(newstate == PLAYER_STATE_DRIVER)
    {	    
        for(new v = 1; v <= TotalVeh; v++)
	{
  	    PlayerInfo[playerid][pCarID] = CarInfo[v][ID];
	}
    }
    return 1;
}

CMD:carid(playerid, params[])
{
	SendMes(playerid, 0x131313, "{FFFFFF}%d",PlayerInfo[playerid][pCarID]);
	return 1;
}

|My problem|

When i enter in the car,and type command /carid
The server give incorrect car id from mysql!(Example: 1) but car have id 2!

In the database i have 2 cars:
1)With id 1
2)With id 2

Sorry for my bad english!

Re: Mysql vehicle system - Variable™ - 29.07.2015

Removed.

Re: Mysql vehicle system - Luis- - 29.07.2015

Quote:

Originally Posted by 1Deagle1

Код:

CMD:carid(playerid, params[])
{
	SendMes(playerid, 0x131313, "{FFFFFF}%s",PlayerInfo[playerid][pCarID]);
	return 1;
}

Try this.

The vehicle id isn't a string, it's an integer.

Re: Mysql vehicle system - iulicxd - 29.07.2015

Quote:

Originally Posted by 1Deagle1

Код:

CMD:carid(playerid, params[])
{
	SendMes(playerid, 0x131313, "{FFFFFF}%s",PlayerInfo[playerid][pCarID]);
	return 1;
}

Try this.

No,the command is working correctly,
but i think the problem is in the

Код:

public OnPlayerStateChange(playerid, newstate, oldstate)

Re: Mysql vehicle system - Variable™ - 29.07.2015

Removed

Re: Mysql vehicle system - iulicxd - 29.07.2015

Quote:

Originally Posted by 1Deagle1

No problem xD

The problem exists,
When i enter in the car with id 1,2
Command see the id 0

Re: Mysql vehicle system - Variable™ - 29.07.2015

Removed

Re: Mysql vehicle system - Luis- - 29.07.2015

You could try;

pawn Код:

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    if(newstate == PLAYER_STATE_DRIVER)
    {       
        for(new v = 1; v != TotalVeh; v++)
    {
        PlayerInfo[playerid][pCarID] = v;
    }
    }
    return 1;
}

Re: Mysql vehicle system - Variable™ - 29.07.2015

Removed

Re: Mysql vehicle system - Luis- - 29.07.2015

Quote:

Originally Posted by 1Deagle1

You're really annoying me now.