illestiraqi Posted December 30, 2014 Share Posted December 30, 2014 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
Mizudori Posted December 30, 2014 Share Posted December 30, 2014 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
Castillo Posted December 30, 2014 Share Posted December 30, 2014 We don't give support with leaked scripts. Link to comment
Recommended Posts