zSwayz

Managed to figure out what the issue was.. Bad mission file(s).. ;-; Does anyone know how i would go about changing the Y and shop menu's colours? Maybe to green or even blue? If so, how many files would i have to make edits to? :P Would certainly make police chases and running from cops much more interesting. If you manage to get this working, i'd love to get my hands on the how-to for this :D

I keep getting a popup when i join my server saying "Script life_server\functions.sqf not found" I know for a fact it's there and everything is 100% vanilla, so i'm not sure what i'm supposed to do here.. Also, when players use Sync Data in the menu, it's not saving licenses, but when i manually enter this into the database, it's all saved and loads correctly. I'm 100% positive my database schema is correct and everything else. I have a feeling this might have something to do with the script not being found. Has anyone else had this issue? I read through 60+ pages in this thread last night and didn't find an answer. Money and everything else saves correctly, but licenses do not. When i use "SYNC DATA" is shows all licenses as 0 value in my server logs. When i rejoin, all my licenses are gone. To give my licenses back, i need to either re-buy, or set each license to a value of 1 in my SQL Server Query. After i rejoin everything is there. If anyone would be willing to give me a hand, i would greatly appreciate it.. ;_;

Managed to fix sql errors, but licenses don't seem to save, even when synced to the server. Not sure what i'm doing wrong. Logs; Info: 04:11:25 - Logging started in directory: C:\Program Files (x86)\Steam\SteamApps\common\Arma 3\logs\ Info: 04:11:25 - Arma2NETMySQL Plugin Started. Info: 04:11:25 - Version number: 0.1.0.0 Info: 04:11:25 - Loading databases... Info: 04:11:25 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\SteamApps\common\Arma 3\Databases.txt Info: 04:11:25 - Type: mysql Database: arma3life IPAddress: localhost Port: 3306 Username: root Password: NotShownForSecurityReasons Info: 04:11:25 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:11:25 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:11:25 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:11:25 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:11:32 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198080376283' Info: 04:13:29 - Received - Database: arma3life SQL Query: SELECT * FROM vehicles WHERE pid='76561198080376283' AND alive='1' AND active='0' AND side='civ' AND type='Car' Info: 04:13:32 - Received - Database: arma3life SQL Query: SELECT * FROM vehicles WHERE id='11' AND pid='76561198080376283' Info: 04:13:32 - Received - Database: arma3life SQL Query: UPDATE vehicles SET active='1' WHERE pid='76561198080376283' AND id='11' Info: 04:18:29 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198080376283' Info: 04:18:29 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198080376283' Info: 04:18:29 - Received - Database: arma3life SQL Query: UPDATE players SET name='Sway', cash='13250', bankacc='3701397', civ_licenses='"[[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_coke`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0]]"', civ_gear='"[`U_C_Poloshirt_stripped`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[]]"', arrested='0' WHERE playerid='76561198080376283' Info: 04:18:29 - Received - Database: arma3life SQL Query: UPDATE players SET name='Sway', cash='13250', bankacc='3701397', civ_licenses='"[[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_coke`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0]]"', civ_gear='"[`U_C_Poloshirt_stripped`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[]]"', arrested='0' WHERE playerid='76561198080376283' Info: 04:19:34 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:19:34 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:19:34 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:19:34 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:19:41 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198080376283' Info: 04:44:50 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198080376283' Info: 04:44:50 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198080376283' Info: 04:44:50 - Received - Database: arma3life SQL Query: UPDATE players SET name='Sway', cash='12750', bankacc='3703147', civ_licenses='"[[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_coke`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0]]"', civ_gear='"[`U_C_Poloshirt_stripped`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[]]"', arrested='0' WHERE playerid='76561198080376283' Info: 04:44:50 - Received - Database: arma3life SQL Query: UPDATE players SET name='Sway', cash='12750', bankacc='3703147', civ_licenses='"[[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_coke`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0]]"', civ_gear='"[`U_C_Poloshirt_stripped`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[]]"', arrested='0' WHERE playerid='76561198080376283' Info: 04:47:28 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:47:28 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:47:28 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 04:47:28 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Info: 04:47:45 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198080376283' Anyone mind giving me a hand? :P Maybe this is it?

I've been working on an Altis Life server for me and a few friends for the past couple days and i've finally managed to get things running decently. However, i keep running into problems here and there, occasional MySQL stacktraces in server logs for whatever reason, but everything seems to work fine. civ_licenses and cop_licenses don't seem to save after restart. Is this the way it's supposed to be? Every time i restart the server, everyone loses their licences, but they still have their money. Am i doing something wrong? D: Latest server log; Also, i use MariaDB 5.5 Info: 01:42:32 - Logging started in directory: C:\Program Files (x86)\Steam\SteamApps\common\Arma 3\logs\ Info: 01:42:32 - Arma2NETMySQL Plugin Started. Info: 01:42:32 - Version number: 0.1.0.0 Info: 01:42:32 - Loading databases... Info: 01:42:32 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\SteamApps\common\Arma 3\Databases.txt Info: 01:42:32 - Type: mysql Database: arma3life IPAddress: localhost Port: 3306 Username: root Password: NotShownForSecurityReasons Info: 01:42:32 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 01:42:32 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Warning: 01:42:32 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma3life.deleteDeadVehicles does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize) Info: 01:42:32 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles(); Info: 01:42:32 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles(); Warning: 01:42:32 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma3life.deleteDeadVehicles does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize) Info: 01:42:39 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198080376283' Fixed that^^ Missing Procedure DELIMITER $$ -- -- Procedures -- CREATE DEFINER=`user`@`localhost` PROCEDURE `deleteDeadVehicles`() BEGIN DELETE FROM vehicles WHERE `alive`=0; END$$ DELIMITER ;