1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
mysql, carro 1 nгo carrega
willttoonn
Gangsta
*****
Posts: 941
Threads: 54
Joined: Nov 2011
Reputation: 0
#1

05.10.2013, 22:44
o veiculo com ID 1 na database nгo carrega.

pawn Код:
function:LoadVehicles()
{
    //CreateVehicle(422, 2109.1763, 1503.0453, 32.2887, 82.2873, 0, 1, 60);
    mysql_function_query(MYSQLConnection, "SELECT * FROM vehicleinfo LIMIT 2000", true, "r@LoadVehicles", "d", 11);
    return 1;
}

function:r@LoadVehicles()
{
    new values[32], rows, fields;
    cache_get_data(rows, fields);  
    new i = 1;  
    for( ; i < rows; i++)    
    {               
        cache_get_field_content(i, "ID", values, MYSQLConnection);
        vehicleinfo[i][vSQLID] = strval(values);                                     
        cache_get_field_content(i, "Model", values, MYSQLConnection);
        vehicleinfo[i][vModel] = strval(values);                      
        cache_get_field_content(i, "Color1", values, MYSQLConnection);
        vehicleinfo[i][vColors1] = strval(values);         
        cache_get_field_content(i, "Color2", values, MYSQLConnection);
        vehicleinfo[i][vColors2] = strval(values);                
        cache_get_field_content(i, "Mod1", values, MYSQLConnection);
        vehicleinfo[i][vMod][0] = strval(values);                           
        cache_get_field_content(i, "Mod2", values, MYSQLConnection);
        vehicleinfo[i][vMod][1] = strval(values);         
        cache_get_field_content(i, "Mod3", values, MYSQLConnection);
        vehicleinfo[i][vMod][2] = strval(values);                           
        cache_get_field_content(i, "Mod4", values, MYSQLConnection);
        vehicleinfo[i][vMod][3] = strval(values);        
        cache_get_field_content(i, "Mod5", values, MYSQLConnection);
        vehicleinfo[i][vMod][4] = strval(values);        
        cache_get_field_content(i, "Mod6", values, MYSQLConnection);
        vehicleinfo[i][vMod][5] = strval(values);        
        cache_get_field_content(i, "Mod7", values, MYSQLConnection);
        vehicleinfo[i][vMod][6] = strval(values);            
        cache_get_field_content(i, "Mod8", values, MYSQLConnection);
        vehicleinfo[i][vMod][7] = strval(values);           
        cache_get_field_content(i, "Mod9", values, MYSQLConnection);
        vehicleinfo[i][vMod][8] = strval(values);            
        cache_get_field_content(i, "Mod10", values, MYSQLConnection);
        vehicleinfo[i][vMod][9] = strval(values);                  
        cache_get_field_content(i, "Mod11", values, MYSQLConnection);
        vehicleinfo[i][vMod][10] = strval(values);        
        cache_get_field_content(i, "Mod12", values, MYSQLConnection);
        vehicleinfo[i][vMod][11] = strval(values);        
        cache_get_field_content(i, "Mod13", values, MYSQLConnection);
        vehicleinfo[i][vMod][12] = strval(values);         
        cache_get_field_content(i, "Health", values, MYSQLConnection);
        vehicleinfo[i][vHealth] = floatstr(values);          
        cache_get_field_content(i, "Owner", vehicleinfo[i][vOwner], MYSQLConnection);       
        cache_get_field_content(i, "Type", values, MYSQLConnection);
        vehicleinfo[i][vType] = strval(values);                             
        cache_get_field_content(i, "RentPrice", values, MYSQLConnection);
        vehicleinfo[i][vRentPrice] = strval(values);       
        cache_get_field_content(i, "Price", values, MYSQLConnection);
        vehicleinfo[i][vPrice] = strval(values);      
        cache_get_field_content(i, "Fuel", values, MYSQLConnection);
        vehicleinfo[i][vFuel] = strval(values);                  
        cache_get_field_content(i, "Job", values, MYSQLConnection);
        vehicleinfo[i][vJob] = strval(values);        
        cache_get_field_content(i, "Buyable", values, MYSQLConnection);
        vehicleinfo[i][vBuyable] = strval(values);
        cache_get_field_content(i, "Locked", values, MYSQLConnection);
        vehicleinfo[i][vLocked] = strval(values);
        cache_get_field_content(i, "Rentable", values, MYSQLConnection);
        vehicleinfo[i][vRentable] = strval(values);   
        cache_get_field_content(i, "ParkX", values, MYSQLConnection);
        vehicleinfo[i][vParkPos1] = floatstr(values);      
        cache_get_field_content(i, "ParkY", values, MYSQLConnection);
        vehicleinfo[i][vParkPos2] = floatstr(values);      
        cache_get_field_content(i, "ParkZ", values, MYSQLConnection);
        vehicleinfo[i][vParkPos3] = floatstr(values);                        
        cache_get_field_content(i, "ParkAngle", values, MYSQLConnection);
        vehicleinfo[i][vParkPos4] = floatstr(values);         
        cache_get_field_content(i, "fCarID", values, MYSQLConnection);
        vehicleinfo[i][vFCarID] = strval(values);                             
        cache_get_field_content(i, "Alarm", values, MYSQLConnection);
        vehicleinfo[i][vAlarm] = strval(values);        
        cache_get_field_content(i, "Locks", values, MYSQLConnection);
        vehicleinfo[i][vLock] = strval(values);                                    
        cache_get_field_content(i, "Immobiliser", values, MYSQLConnection);
        vehicleinfo[i][vImmobiliser] = strval(values);       
        cache_get_field_content(i, "Bought", values, MYSQLConnection);
        vehicleinfo[i][vBought] = strval(values);                
        cache_get_field_content(i, "World", values, MYSQLConnection);
        vehicleinfo[i][vWorld] = strval(values);     
        cache_get_field_content(i, "Weapon1", values, MYSQLConnection);
        vehicleinfo[i][vWeapons1] = strval(values);           
        cache_get_field_content(i, "Weapon2", values, MYSQLConnection);
        vehicleinfo[i][vWeapons2] = strval(values);            
        cache_get_field_content(i, "Weapon3", values, MYSQLConnection);
        vehicleinfo[i][vWeapons3] = strval(values);           
        cache_get_field_content(i, "Ammo1", values, MYSQLConnection);
        vehicleinfo[i][vAmmo1] = strval(values);      
        cache_get_field_content(i, "Ammo2", values, MYSQLConnection);
        vehicleinfo[i][vAmmo2] = strval(values);         
        cache_get_field_content(i, "Ammo3", values, MYSQLConnection);
        vehicleinfo[i][vAmmo3] = strval(values);             
        cache_get_field_content(i, "XMRadio", values, MYSQLConnection);
        vehicleinfo[i][vXMRadio] = strval(values);            
        cache_get_field_content(i, "Insurance", values, MYSQLConnection);         
        vehicleinfo[i][vInsurance] = strval(values);          
        new vehicleadd = AddStaticVehicleEx(vehicleinfo[i][vModel], vehicleinfo[i][vParkPos1],vehicleinfo[i][vParkPos2],vehicleinfo[i][vParkPos3],vehicleinfo[i][vParkPos4],vehicleinfo[i][vColors1],vehicleinfo[i][vColors2], -1);  
        SetVehicleZAngle(vehicleadd, vehicleinfo[i][vParkPos4]);        
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][0]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][1]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][2]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][3]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][4]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][5]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][6]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][7]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][8]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][9]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][10]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][11]);
        AddVehicleComponent(vehicleadd, vehicleinfo[i][vMod][12]);        
        SetVehicleHealth(vehicleadd, vehicleinfo[i][vHealth]);            

        for(new b = 0; b < MAX_PLAYERS; b ++)
        {
            if(vehicleinfo[i][vLocked] == 1) SetVehicleParamsForPlayer(vehicleadd,b,0,1);
            if(vehicleinfo[i][vFCarID] != -1 && playerinfo[b][pFaction] != vehicleinfo[i][vFCarID]) SetVehicleParamsForPlayer(vehicleadd,b,0,1);
            if(vehicleinfo[i][vJob] != -1 && playerinfo[b][pJob] != vehicleinfo[i][vJob]) SetVehicleParamsForPlayer(vehicleadd,b,0,1);             
        }         
        SetVehicleToRespawn(vehicleadd);             
        if(!strcmp(vehicleinfo[i][vOwner], "Faction", true))
        {
            SetVehicleVirtualWorld(vehicleadd, 0);               
        }
        else
        {
            SetVehicleVirtualWorld(vehicleadd, i+1);             
        }
    }    
    printf("Loaded %d Vehicles.", rows);
    return 1;
}
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#2

05.10.2013, 23:33
pawn Код:
new i;
Find
Reply
willttoonn
Gangsta
*****
Posts: 941
Threads: 54
Joined: Nov 2011
Reputation: 0
#3

05.10.2013, 23:34
Quote:
Originally Posted by zPain
Посмотреть сообщение
pawn Код:
new i;
Consegui resolver
if(vehicleinfo[i][vSQLID] > 0) <- Sу carrega veiculos com ID acima de 0.

^.^ Valeu ai por responder
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#4

05.10.2013, 23:36
Lembre-se: a contagem de rows comeзa do zero.
Find
Reply
willttoonn
Gangsta
*****
Posts: 941
Threads: 54
Joined: Nov 2011
Reputation: 0
#5

05.10.2013, 23:55
Quote:
Originally Posted by zPain
Посмотреть сообщение
Lembre-se: a contagem de rows comeзa do zero.
Sim, mas o veiculo 0 nгo spawna rsrs ai criei 1 que ocupasse a row 0 e por sua vez nгo spawnaria e assim nгo bugando os demais veiculos, ficando todos com o mesmo ID no banco de dados e tambйm no jogo.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese