SA-MP Forums Archive
MySQL Help. - 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 Help. (/showthread.php?tid=299844)



MySQL Help. - GamingTurf - 27.11.2011

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?