[jamesb93]

Hey,

Currently on my mysql TDM server. Players are losing their cars and their stats on a restart. Could I make like a SavePlayers(); and SaveVehicles(); under OnGameModeExit. Currently I have this:

pawn Code:

public SavePlayer(playerid)
{
    CheckSQL();
    new query[512];
    format(query,sizeof(query),"UPDATE `players` SET rank=%d,reborn=%d,exp=%d,van=%d,kills=%d,tkills=%d,gkill=%d,mp5kill=%d,kkill=%d,mgoal=%d,hgoal=%d,agoal=%d,mapgoal=%d,deaths=%d,admin=%d,gm=%d,premium=%d,money=%d WHERE playerid=%d",
      PlayerInfo[playerid][pRank],PlayerInfo[playerid][pReborn],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pVan],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pTKills],PlayerInfo[playerid][pGrenadekill],PlayerInfo[playerid][pMp5kill],
      PlayerInfo[playerid][pKnucklekill],PlayerInfo[playerid][pMenugoal],PlayerInfo[playerid][pHeligoal],PlayerInfo[playerid]         [pArmourgoal],PlayerInfo[playerid][pMapgoal],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pAdmin],
      PlayerInfo[playerid][pGM],PlayerInfo[playerid][pPremium],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pSQLId]);
    mysql_query(query);
    return 1;
}

and

pawn Code:

public SaveVehicle(vehid)
{
    new query[256];
    format(query,sizeof(query),"UPDATE `vehicles` SET model=%d,x=%f,y=%f,z=%f,a=%f,col1=%d,col2=%d,type=%d,price=%d,ownerid=%d WHERE vehid=%d",
        vInfo[vehid][vModelId],vInfo[vehid][vPos_X],vInfo[vehid][vPos_Y],vInfo[vehid][vPos_Z],vInfo[vehid][vPos_A],vInfo[vehid][vColor1],
        vInfo[vehid][vColor2],vInfo[vehid][vBuyAble],vInfo[vehid][vPrice],vInfo[vehid][vOwnerId],vInfo[vehid][vSQLId]);
    mysql_query(query);
    return 1;
}

Can anyone help me make a fucntion to save all players stats and vehicles on a restart?