MySQL Help.
#1

Hello, i have a problem with my MySQL Loading system:

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;
        }
    }
It updates it, but sometimes when i restart the server - It makes duplicates, and it's really werid..

Can anyone see a problem?
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)