Loop for Cars

[Trevit]

Hi,

I want to load the carinformation from the mysql-table, but there is something wrong with "createVehicle". I hope you can help me.

  
function carspawn ( ) 
    handler = mysql_connect("localhost", "table", "pass", "user") 
    cars = mysql_query(handler, "SELECT * FROM vehicles" ) 
    pCars = mysql_fetch_row( cars ) 
     
    for i, cars in pairs (pCars) do 
        createVehicle( cars[i].model, cars[i].posx, cars[i].posy, cars[i].posz ) 
    end 
     
    if (not cars) then 
         outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) 
    else 
        mysql_free_result(cars) 
    end 
end 
  
addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()), carspawn ) 
  

[12p]

Try this:

  
function carspawn ( ) 
    handler = mysql_connect("localhost", "table", "pass", "user") 
    cars = mysql_query(handler, "SELECT * FROM vehicles" ) 
    pCars = mysql_fetch_row( cars ) 
     
    for i, cars in pairs (pCars) do 
        createVehicle( cars.i[model], cars.i[posx], cars.i[posy], cars.i[posz] ) 
    end 
     
    if (not cars) then 
         outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) 
    else 
        mysql_free_result(cars) 
    end 
end 
  
carspawn() 
  

[Trevit]

Error:

attempt to index field 'i' (a nil value)

[FFS-Racing]

  
addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()), 
 function ( ) 
    handler = mysql_connect("localhost", "table", "pass", "user") 
    cars = mysql_query(handler, "SELECT * FROM vehicles" ) 
   
    if cars then 
        pCars = mysql_fetch_row( cars ) 
            while pCars do 
                createVehicle( pCars.model, pCars.posx, pCars.posy, pCars.posz ) 
            end 
        mysql_free_result(cars) 
    else 
         outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) 
  
    end 
end 
) 

[Trevit]

Now it just says bad argument and infinite running script.

[SDK]

Where did that bad argument error happen? Try this, not sure if it'll work:

addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()), 
function() 
    handler = mysql_connect("localhost", "table", "pass", "user") 
    cars = mysql_query(handler, "SELECT * FROM vehicles" ) 
   
    if cars then 
        pCars = mysql_fetch_row( cars ) 
        while pCars do 
            createVehicle( pCars.model, pCars.posx, pCars.posy, pCars.posz ) 
            pCars = mysql_fetch_row( cars ) 
        end 
        mysql_free_result(cars) 
    else 
         outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) 
    end 
end 
)