Messages

Use this function and then restart your server

Code Select Expand

function ResetIDs()
    {
    local q = QuerySQL(db,"SELECT ID FROM Vehicles"), i = 1;
    while( GetSQLColumnData( q, 0 ) != null )
      {
      QuerySQL(db"UPDATE Vehicles SET ID='"+i+"' WHERE ID='"+GetSQLColumnData(q,0)+"'");
      i++;
      GetSQLNextRow( q );
      }
    FreeQuery( q );
    print("Vehicles Loaded - "+i);
    }

 :edit:
P.S: After using above function don't use this

Code Select Expand

UPDATE Vehicles SET ID = rowid
Cause it will change the ids to the one used upon INSERT

myproblem: when i create a vehicle in the server it spawns with 243 id when i restart the server it changes into 68 id
so the id 68 is not in the database so i got errors

this function doesn't work and doesn't change the ids in the database

console : "[SCRIPT] Vehicles Count (69)
           [SCRIPT] Vehicles Loaded - 1"

the reject cmd gives errors i think it must be as this:

Code Select Expand

else if ( cmd == "reject")
{
 if( stats[player.ID].Partner == "" ) return MessagePlayer("You haven't recieved any team-up request yet.",player);
 local plr = FindPlayer(stats[player.ID].Partner);

            MessagePlayer(""+rpmsg+"-> You rejected [#" + format("%02X%02X%02X", plr.Color.r, plr.Color.g, plr.Color.b) + "]"+plr.Name+""+rpmsg+"'s team-up request.",player);
            MessagePlayer(""+rpmsg+"-> [#" + format("%02X%02X%02X", plr.Color.r, plr.Color.g, plr.Color.b) + "]"+player.Name+" "+rpmsg+"rejected your team-up request. ",plr);
  stats[player.ID].Partner = "";
  stats[player.ID].Requested = false;
}