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