MySQL won't save player vehicles?
#8

I have updated my code, here it is:
PHP код:
public OnPlayerDisconnect(playeridreason){
    for(new 
0MAX_VEHICLESi++){
        
printf("I : %d | ID : %d | Model : %d"iCharacterVehicle[i][cvID], CharacterVehicle[i][cvModel]);
        if(
CharacterVehicle[i][cvModel] == 0) continue;
        if(
strcmp(GetPlayerNameEx(playerid), CharacterVehicle[i][cvOwnerName])) continue;
        
SQL_SaveCharacterVehicle(CharacterVehicle[i][cvID]);
        
DestroyVehicle(CharacterVehicle[i][cvID]);
        
ResetCharacterVehicle(CharacterVehicle[i][cvID]);
    }
    
SQL_SaveCharacterInfo(playerid);
    
SQL_SaveCharacterWeapons(playerid);
    
ResetCharacterInfo(playerid);
    
gCharacterLogged{playerid} = false;
    
Delete3DTextLabel(pLabel[playerid]);
    return 
1;
}
SQL_SaveCharacterVehicle(vid){
    new 
query[1024];
    if(
CharacterVehicle[vid][cvModel] == 0) return 1;
    
GetVehiclePos(vidCharacterVehicle[vid][cvPosX], CharacterVehicle[vid][cvPosY], CharacterVehicle[vid][cvPosZ]);
    
GetVehicleZAngle(vidCharacterVehicle[vid][cvPosA]);
    
CharacterVehicle[vid][cvVW] = GetVehicleVirtualWorld(vid);
    
mysql_format(MHandlequerysizeof(query), "UPDATE `vehicle` SET `ID` = %d, `Plate` = '%s', `Lock` = %d, `Colour1` = %d, `Colour2` = %d, `VW` = %d, `Int` = %d, `Health` = %0.2f, `Fuel` = %0.2f, `posX` = %0.2f, `posY` = %0.2f, `posZ` = %0.2f, `posA` = %0.2f WHERE `OwnerName` = '%e' AND `ID` = %d",
    
CharacterVehicle[vid][cvID], CharacterVehicle[vid][cvPlate], CharacterVehicle[vid][cvLock], CharacterVehicle[vid][cvColour1], CharacterVehicle[vid][cvColour2], CharacterVehicle[vid][cvVW], CharacterVehicle[vid][cvInt], CharacterVehicle[vid][cvHealth], CharacterVehicle[vid][cvFuel], CharacterVehicle[vid][cvPosX],
    
CharacterVehicle[vid][cvPosY], CharacterVehicle[vid][cvPosZ], CharacterVehicle[vid][cvPosA], CharacterVehicle[vid][cvOwnerName], CharacterVehicle[vid][cvID]);
    
mysql_query(MHandlequery);
    
printf(query);
    return 
1;
}
CreateCharacterVehicle(playeridmodelidFloat:vposXFloat:vposYFloat:vposZFloat:vposAcol1col2){
    new 
query[1024];
    for(new 
0MAX_VEHICLESi++){
        if(
CharacterVehicle[i][cvModel] != || GetVehicleModel(i) != 0) continue;
        
CharacterVehicle[i][cvID] = CreateVehicle(modelidvposXvposYvposZvposAcol1col2, -1);
        
format(CharacterVehicle[i][cvOwnerName], 24"%s"GetPlayerNameEx(playerid));
        
format(CharacterVehicle[i][cvPlate], 8"Non-R");
        
CharacterVehicle[i][cvPosX] = vposX;
        
CharacterVehicle[i][cvPosY] = vposY;
        
CharacterVehicle[i][cvPosZ] = vposZ;
        
CharacterVehicle[i][cvPosA] = vposA;
        
CharacterVehicle[i][cvModel] = modelid;
        
CharacterVehicle[i][cvColour1] = col1;
        
CharacterVehicle[i][cvColour2] = col2;
        
CharacterVehicle[i][cvHealth] = 1000.0;
        
CharacterVehicle[i][cvFuel] = 100.0;
        
CharacterVehicle[i][cvVW] = GetPlayerVirtualWorld(playerid);
        
CharacterVehicle[i][cvInt] = GetPlayerInterior(playerid);
        
SetVehicleVirtualWorld(iCharacterVehicle[i][cvVW]);
        
LinkVehicleToInterior(iCharacterVehicle[i][cvInt]);
        
mysql_format(MHandlequerysizeof(query), "INSERT INTO `vehicle` (`ID`, `OwnerName`, `Model`, `Plate`, `Colour1`, `Colour2`, `VW`, `Int`, `Health`, `Fuel`, `posX`, `posY`, `posZ`, `posA`)");
        
mysql_format(MHandlequerysizeof(query), "%s VALUES (%d, '%e', %d, '%s', %d, %d, %d, %d, %0.2f, %0.2f, %0.2f, %0.2f, %0.2f, %0.2f)",
        
queryCharacterVehicle[i][cvID], CharacterVehicle[i][cvOwnerName], CharacterVehicle[i][cvModel], CharacterVehicle[i][cvPlate], CharacterVehicle[i][cvColour1], CharacterVehicle[i][cvColour2], CharacterVehicle[i][cvVW], CharacterVehicle[i][cvInt],
        
CharacterVehicle[i][cvHealth], CharacterVehicle[i][cvFuel], CharacterVehicle[i][cvPosX], CharacterVehicle[i][cvPosY], CharacterVehicle[CharacterVehicle[i][cvID]][cvPosZ], CharacterVehicle[i][cvPosA]);
        
mysql_query(MHandlequery);
        
printf(query);
        return 
1;
    }
    return 
1;

Reply


Messages In This Thread
MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 09:17
Re: MySQL won't save player vehicles? - by Unte99 - 11.03.2017, 09:28
Re: MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 09:32
Re: MySQL won't save player vehicles? - by Unte99 - 11.03.2017, 09:51
Re: MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 10:09
Re: MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 10:11
Re: MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 13:02
Re: MySQL won't save player vehicles? - by DuyDang2412 - 11.03.2017, 13:09
Re: MySQL won't save player vehicles? - by DuyDang2412 - 12.03.2017, 01:42

Forum Jump:


Users browsing this thread: 2 Guest(s)