Jump to content

Vehicle Library System with MYSQL issues


illestiraqi

Recommended Posts

okay so this vehicle library system my friend gave me, it gives me a Mysql error

[2014-12-30 03:43:52] INFO: MYSQL ERROR 1054: Unknown column 'gtaid' in 'field list' 
[2014-12-30 03:43:59] ERROR: vehicle-manager\vehicle-library\s_vehicle_library.lua:40: exports: Call to non-running server resource (integration) 
[2014-12-30 03:43:59] ERROR: vehicle-manager\vehicle-library\s_vehicle_library.lua:40: exports: Call to non-running server resource (integration) 

Now heres the MySQL

CODE REMOVED

Link to comment

Hi I know this might be and offtopic but why you don't use the mta wiki function to connect to mysql and insert data

cn  = dbConnect (info_about_mysql) <-- u can share it for all lua files 
function AddVehicle() 
 local value = some short of unique key for your vehicle 
local value1 and value 2 are the info about car which you want to insert 
 query = dbQuery(cn,"SELECT * FROM vehicle WHERE column_name =?",value) 
result = dbPoll ( query, -1 ) 
if(result)then 
  dbExec(cn, "UPDATE statment here") <-- if vehicle is in db already 
 else 
dbExec(cn, "INSERT INTO vehicle (column1,column2) VALUES (?,?)",value1,value2) <-- if not, insert 
end 
  
end 
  

I think it's simple than your code

Link to comment
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...