Vehicles problem [mysql]
#1

Problem is, cars getting messy when deleting car inbetween cars.
Example:
Player buys car A, car A ID is 1
I do /veh to create a temporary car B, car B ID is 2
Player buys car C, car C ID is 3

When that temporary car dissapears, ID 3 car stats are not working anymore after the server restart.
Reply
#2

Also here's the load function.

PHP код:

stock LoadCars
()
{
    new 
query[600];
    for(new 
id 1id MAX_AUTODid++)
    {
        
format(querysizeof(query), "SELECT * FROM autod WHERE IID = %d"id);
        
mysql_query(query);
        
mysql_store_result();
        if(
mysql_num_rows())
        if(
mysql_fetch_row_format(query,"|"))
        {
            
sscanf(query"p<|>iiis[32]is[32]iiffffiiiis[32]i",
            
Autos[id][aAutoID],Autos[id][aAutoV6ti],Autos[id][iID],
            
Autos[id][aOmanik],Autos[id][aMudel],Autos[id][AutoNimi],
            
Autos[id][aHind],Autos[id][aKiirus], Autos[id][aPosx],
            
Autos[id][aPosy],Autos[id][aPosz],
            
Autos[id][aAngle],Autos[id][vAku],
            
Autos[id][vKytus],Autos[id][vVarv1],Autos[id][vVarv2],
            
Autos[id][aNumbriM2rk],Autos[id][aArvel]);
            
Total_Cars_Created++;
            
printf("Car: %d Owner: %s CarID: %d ss %d  %f x  %f y  %f z  %f a"Autos[id][aAutoID],Autos[id][aOmanik],Autos[id][iID], Autos[id][aAutoV6ti], Autos[id][aPosx], Autos[id][aPosy],Autos[id][aPosz], Autos[id][aAngle]);
            
SetVehicleNumberPlate(CreateVehicle(Autos[id][aMudel], Autos[id][aPosx], Autos[id][aPosy], Autos[id][aPosz], Autos[id][aAngle],Autos[id][vVarv1],Autos[id][vVarv2], -1), Autos[id][aNumbriM2rk]) ;
        }
    }
    
printf("> %d cars loaded."Total_Cars_Created);
    return 
1;

Reply
#3

Got it fixed, made an auto update ID.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)