27.11.2011, 15:14
Hello, i have a problem with my MySQL Loading system:
It updates it, but sometimes when i restart the server - It makes duplicates, and it's really werid..
Can anyone see a problem?
pawn Код:
if(strcmp(cmd, "/updatevehicle", true) == 0)
{
if(IsPlayerInAnyVehicle(playerid))
{
new VC1 = -1;
new VC2 = -1;
if(PInfo[playerid][AdminLevel] < 2) { SendClientMessage(playerid, COLOR_ERROR, "You are not an administrator !"); return 1;}
new Float: VX, Float: VY, Float: VZ, Float: VA, dModel, Msg[64];
GetPlayerPos(playerid, VX, VY, VZ);
GetVehicleZAngle(GetPlayerVehicleID(playerid), VA);
dModel = GetVehicleModel(GetPlayerVehicleID(playerid));
new id2 = GetPlayerVehicleID(playerid);
mysql_reconnect();
new Query[500];
format(Query, sizeof(Query), "UPDATE vehicles SET VehicleX='%f',VehicleY='%f',VehicleZ='%f',VehicleAngle='%f',VehicleColor1='%d',VehicleColor2='%d' WHERE VehicleID = '%d'",
VX, VY, VZ, VA, VC1, VC2, VInfo[id2][ID]);
mysql_query(Query);
mysql_free_result();
format(Msg, sizeof(Msg), "Vehicle position updated - Model: %d | CarID: %d",dModel,VInfo[id2][ID]);
SendClientMessage(playerid, COLOR_YELLOW, Msg);
return 1;
}
else
{
SendClientMessage(playerid, COLOR_ERROR, "You are not in a vehicle !");
return 1;
}
}
Can anyone see a problem?