Altis Life RPG

pils · August 14, 2013

Played this a few hours lately and was quite fun. Just until I noticed vehicles blowing up at a regular basis from minor accidents and bumps. First I was blaming BI again (sorry guys) for those "bugs" but after doing some tests in the editor I figured out you changed the vehicle parameters, right?

Well. BI set them up really well and you messed them up completely. I would appreciate just having the standard BI parameters, because right now they absolutely suck.

Examples:

Boxer truck going 30 km/h against traffic sign: Instant boom.

Quad going 20 km/h against Boxer Truck: Boxer truck instant boom.

Ifrit slightly bumps into HEMTTs side: HEMTT instant boom.

etc. etc.

Why change pretty nice parameters to something completely unrealistic and annoying? Especially as vehicles are very valuable in this mod.

DeathmannX · February 21, 2014

Is there any other way to replace arma2mysql to run this Mod on Linux?

tonic-_- · February 4, 2011

Played this a few hours lately and was quite fun. Just until I noticed vehicles blowing up at a regular basis from minor accidents and bumps. First I was blaming BI again (sorry guys) for those "bugs" but after doing some tests in the editor I figured out you changed the vehicle parameters, right?
Well. BI set them up really well and you messed them up completely. I would appreciate just having the standard BI parameters, because right now they absolutely suck.

Examples:

Boxer truck going 30 km/h against traffic sign: Instant boom.

Quad going 20 km/h against Boxer Truck: Boxer truck instant boom.

Ifrit slightly bumps into HEMTTs side: HEMTT instant boom.

etc. etc.

Why change pretty nice parameters to something completely unrealistic and annoying? Especially as vehicles are very valuable in this mod.

You do realize that you can't change 'vehicle parameters' through a mission. That has nothing to do with me.

pils · August 14, 2013

You do realize that you can't change 'vehicle parameters' through a mission. That has nothing to do with me.

That's wierd, then it's probably the server I was playing on. Sorry for blaming you!

MiNoxus · January 3, 2014

We managed to fuck up the cop spawning on our server and we don't quite know what we did wrong. The spawn menu doesn't show up anymore when a cop respawns or dies and they get put on the island above athira. Any suggestions from anyone on how to fix this?

chrism37 · December 16, 2013

anyone know if its possible to tie a spawn point to a player ID?

kenzo47 · January 20, 2014

anyone know if its possible to tie a spawn point to a player ID?

I'd like to know the answer to this question as well.

YouKnowBlom · August 31, 2013

I did not find anything regarding this soo im posting here, When anyone on my server try to buy a car they get kicked for CreateVehicle restriction #1-12.

chrism37 · December 16, 2013

I'd like to know the answer to this question as well.

Im trying to find a solid answer because I was told no by someone, but I know for a fact at least 2 separate servers are somehow doing it

Paco79 · February 21, 2014

Hello,

We have the following problem.

We have 4 random cop slots. I found the file missions. But i can only change the description from Public Slot to WhiteListed.

Where can I set the WhiteListed slot ?

thx for your answer.

Insom · February 21, 2014

I am also looking for some help in making civilian weapons save upon disconnecting and reconnecting to server. I have found civfetchgear.sqf and civloadgear.sqf. I went through both files and changed everything, not really knowing exactly what to change. I have had no luck, is there anyone out there can point me in a better direction. I am just trying to get the guns and ammo to save for civilians. Thanks so much in advance.

I have seen numerous posts on this thread about this very same thing and I haven't come across an answer to any of them, so forgive me if I just missed it.

CdoubleZ · February 21, 2014

Hi , i was wondering if anyone knew how to fix this error me and a couple of people i know are getting , its really annoying and starting to piss alot of us off so could someone please help me?

the message i get when trying to connect to any altis life server is: cant setup your session with the server you have reached the maximum tries of 3.

I dont know why its saying this or how to fix it so can someone please help me?

BTNGaming · January 21, 2014

Sorry I haven't been around to help anyone, Starting here, VENOM, Did you figure out your CIV gear saving? If Not You can add me on Skype: KDawg08

I can help with most things as far as where to find things or how to fix issues like civ saving, rebel spawn issues, etc.

Rebel spawn issues: Just go to map editor with your mission.sqm in your custom made mission and add a spawn point for the vehicles and name it based on the rebel vehicles call function he calls for reb_v_1 or reb_v_2 i forget which one.

CdoubleZ: Make sure your database.txt is in the root folder of your arma 3, and have it calling for arma3life. Also make sure you have the database setup already and (Default is called arma3life) make sure you have packed your life_server and added the life_server.pbo into your servers ADDONS folder. Also make sure you have the @Arma2Net folder in your root directory and have setup MySQL on your server system.

I did not find anything regarding this soo im posting here, When anyone on my server try to buy a car they get kicked for CreateVehicle restriction #1-12.

Something you coded into your script files is causing that error, You need to figure out which file(s) are creating this error and fix it lol. Something tells me it's in the core/shops/ folder under one of the VehicleShops or VehicleBuy files.

I am also looking for some help in making civilian weapons save upon disconnecting and reconnecting to server. I have found civfetchgear.sqf and civloadgear.sqf. I went through both files and changed everything, not really knowing exactly what to change. I have had no luck, is there anyone out there can point me in a better direction. I am just trying to get the guns and ammo to save for civilians. Thanks so much in advance.
I have seen numerous posts on this thread about this very same thing and I haven't come across an answer to any of them, so forgive me if I just missed it.

It's a matter of REPLACING the civFetchGear and civLoadGear files.

Replace them with these:

https://drive.google.com/file/d/0B1PKSbYDsvcxaW45ZklVaDl0MzA/edit?usp=sharing

https://drive.google.com/file/d/0B1PKSbYDsvcxb2JzRXp4NkhuVW8/edit?usp=sharing

If I missed anyone elses questions, sorry. You'll have to repost them because I missed a lot lol. But I'll try to answer as much as possible.

Edited February 21, 2014 by BTNGaming

CdoubleZ · February 21, 2014

BTNGaming im not the server host

shifftie · April 22, 2009

Hi all, I know I have asked before but I'm pretty stumped now. I have managed to add a few extra things to our server but could really do with some help adding vehicles to stores and I'm trying to get hold of more skins. If anyone could help me I would be so thankfull. My steam addy is scottboy600 (don't laugh to hard I was a young lad back on counter strike lol) sorry I have tried adding vehicles myself but have to keep reverting back because the stores don't work. And I can't for the life of me do skins and add skins

Edited February 22, 2014 by shifftie

YouKnowBlom · August 31, 2013

Something you coded into your script files is causing that error, You need to figure out which file(s) are creating this error and fix it lol. Something tells me it's in the core/shops/ folder under one of the VehicleShops or VehicleBuy files.

Thanks for the reply but im afraid that this did not help since I have a very low sqf understanding.

BTNGaming · January 21, 2014

Hi all, I know I have asked before but I'm pretty stumped now. I have managed to add a few extra things to our server but could really do with some help adding vehicles to stores and I'm trying to get hold of more skins. If anyone could help me I would be so thankfull. My steam addy is scottboy600 (don't laugh to hard I was a young lad back on counter strike lol) sorry I have tried adding vehicles myself but have to keep reverting back because the stores don't work. And I can't for the life of me do skins and add skins

You have to edit multiple files for this. From vehicle shops, player garages and such, Just take some time to read the code a bit and understand where all the vehicle calls are in the script. I can't really explain how to do it but yeah. Lol, Sorry I can't be of more help in this situation.

Thanks for the reply but im afraid that this did not help since I have a very low sqf understanding.

Basically, Change your vehicle shops and vehicle buy files to the DEFAULT ONES and see if it works fine, if so, the error is in one of those sqf files.

YouKnowBlom · August 31, 2013

I have the default ones

dburke87 · January 30, 2014

I've been noticing that our life_db_queue or whatever it's called has been filling up in the thousands. I took a look in the query log file, and it seems I'm getting an UPDATE players and SELECT FROM players spam from a single player nearly once a second. It appears to be the queries sent out by the STS_fnc_update script, which adds sync requests to the earlier mentioned queue. Again, it's a new query request coming every second or so from the same player. I know it's not malicious, because it will shift to different players including one of my fellow server owners at one point. Anyone know what could cause this? Obviously it's beginning to really hurt server performance.

Here's a snippet from my .log file:

Info: 23:00:03 - Received - Database: arma3life_master SQL Query: SELECT playerid, name, adminlevel, donatorlvl, cash, bankacc, reb_licenses, reb_gear, reb_pos_x, reb_pos_y, reblevel, arrested FROM players WHERE playerid='76561198081517434'
Info: 23:00:07 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='85932', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:08 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:08 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='82026', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:09 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:10 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='89838', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:11 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:11 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='93744', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:12 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:13 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='101556', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:14 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:14 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='97650', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:15 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:16 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='105462', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:17 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:17 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='109368', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:18 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:19 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='113274', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:20 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:20 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='117180', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:21 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:21 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='121086', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:23 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:23 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='124992', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:24 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:24 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='128898', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:26 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:26 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='132804', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:27 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:27 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='140616', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:28 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:29 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='136710', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:30 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:30 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='148428', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:31 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:32 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='152334', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:33 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:33 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='156240', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:34 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:34 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='144522', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:36 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:36 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='160146', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:37 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:37 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='167958', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:39 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:39 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='171864', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:40 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:40 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='164052', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:42 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:44 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='183582', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:50 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:01:05 - Received - Database: arma3life_master SQL Query: UPDATE vehicles SET active='0' WHERE pid='76561198101958454' AND plate='79128'
Info: 23:01:07 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='187488', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:01:53 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:02:43 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='175770', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'

zSwayz · February 22, 2014

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 ;

Edited February 22, 2014 by zSwayz

suprsurfr · February 22, 2014

So I'm just now really digging into all the scripting for this mod, and I'm trying to get a good grasp of where everything is. What I've noticed so far is I'm having trouble finding several functions. For example, in following the flow from init.sqf, the first occurrence of a "missing" function is in life_server/init.sqf on line 59, then on lines 65:
[] spawn DB_fnc_queueManagement;

//Server-side functions that need to be sent out.
publicVariable "STS_fnc_addVehicle2Chain";
publicVariable "life_fnc_fedSuccess";

[] spawn STS_fnc_federalUpdate;
I cannot for the life of me find these functions. Other examples are all of the life_fnc_xxx, such as life_fnc_gatherCocaine from fn_setupActions.sqf. I've found fn_gatherCocaine.sqf, but not life_fnc_gatherCocaine. Any help in locating and editing these files/functions would be greatly appreciated.

I read the entire thread and did not see any answer to the location of the life_fn_ files or where they are defined. was this answered and I missed it?

BTNGaming · January 21, 2014

I read the entire thread and did not see any answer to the location of the life_fn_ files or where they are defined. was this answered and I missed it?

Go into functions.h and search for the file name like... "setupActions" to find the Functions, and SAME THING for life_server folder, Go into config.cpp to find the files you need there.

shifftie · April 22, 2009

You have to edit multiple files for this. From vehicle shops, player garages and such, Just take some time to read the code a bit and understand where all the vehicle calls are in the script. I can't really explain how to do it but yeah. Lol, Sorry I can't be of more help in this situation.
Basically, Change your vehicle shops and vehicle buy files to the DEFAULT ONES and see if it works fine, if so, the error is in one of those sqf files.

Thanks =) going to do that.

I have one last question how do i add another faction? i have been searhing for the cop ranks location to mayble add a variable for them and things but im stuck. Sorry im new to editing life stuff normally not this bad at it so im failing

dburke87 · January 30, 2014

I read the entire thread and did not see any answer to the location of the life_fn_ files or where they are defined. was this answered and I missed it?

Not sure about answered, but I've since learned a great deal more about Arma scripting. They're all defined in either Functions.hpp or config.cpp.

---------- Post added at 09:51 ---------- Previous post was at 09:47 ----------

I've been noticing that our life_db_queue or whatever it's called has been filling up in the thousands. I took a look in the query log file, and it seems I'm getting an UPDATE players and SELECT FROM players spam from a single player nearly once a second. It appears to be the queries sent out by the STS_fnc_update script, which adds sync requests to the earlier mentioned queue. Again, it's a new query request coming every second or so from the same player. I know it's not malicious, because it will shift to different players including one of my fellow server owners at one point. Anyone know what could cause this? Obviously it's beginning to really hurt server performance.

Here's a snippet from my .log file:

Info: 23:00:03 - Received - Database: arma3life_master SQL Query: SELECT playerid, name, adminlevel, donatorlvl, cash, bankacc, reb_licenses, reb_gear, reb_pos_x, reb_pos_y, reblevel, arrested FROM players WHERE playerid='76561198081517434'
Info: 23:00:07 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='85932', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:08 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:08 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='82026', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:09 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:10 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='89838', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:11 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:11 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='93744', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:12 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:13 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='101556', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:14 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:14 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='97650', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:15 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:16 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='105462', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:17 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:17 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='109368', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:18 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:19 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='113274', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:20 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:20 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='117180', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:21 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:21 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='121086', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:23 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:23 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='124992', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:24 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:24 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='128898', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:26 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:26 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='132804', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:27 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:27 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='140616', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:28 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:29 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='136710', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:30 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:30 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='148428', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:31 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:32 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='152334', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:33 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:33 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='156240', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:34 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:34 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='144522', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:36 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:36 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='160146', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:37 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:37 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='167958', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:39 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:39 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='171864', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:40 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:40 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='164052', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:42 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:00:44 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='183582', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:00:50 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:01:05 - Received - Database: arma3life_master SQL Query: UPDATE vehicles SET active='0' WHERE pid='76561198101958454' AND plate='79128'
Info: 23:01:07 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='187488', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'
Info: 23:01:53 - Received - Database: arma3life_master SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198069882932'
Info: 23:02:43 - Received - Database: arma3life_master SQL Query: UPDATE players SET name='Hikurac', cash='175770', bankacc='208024', reb_licenses='"[[`license_reb_air`,1],[`license_reb_driver`,1],[`license_reb_boat`,1],[`license_reb_weapons`,0],[`license_reb_explosives`,0],[`license_reb_leader`,0],[`license_reb_heroin`,0],[`license_reb_marijuana`,0],[`license_reb_coke`,0]]"', reb_gear='"[``,``,[],`U_O_SpecopsUniform_ocamo`,``,``,[],[],[],[],[`hgun_Pistol_heavy_02_F`],[],[],``,``,[]]"', arrested='0', reb_pos_x='20072', reb_pos_y='6746' WHERE playerid='76561198069882932'

I've actually found the source of this, and it's a blatant exploit. I imagine most who use this exploit aren't aware of what damage it causes to server performance (I run a 12-core, top-of-the-line NFO VDS, and I saw cycles per second drop from ~40-50 to below 1 from one person doing this). I obviously won't detail the exploit for fear of widespread use, but I've since fixed the scripts that allowed it as well as create a new script that globally broadcasts the name of the exploiter to the entire server. Tonic, I'll post some details of the exploit in a PM so that you can possibly address this in a later update. Any server admins are more than welcome to PM if they're experiencing this same issue, and I'd be glad to help.

zSwayz · February 22, 2014

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?

Edited February 22, 2014 by zSwayz

Altis Life RPG

Recommended Posts

pils 49

Share this post

Link to post

Share on other sites

DeathmannX 10

Share this post

Link to post

Share on other sites

tonic-_- 53

Share this post

Link to post

Share on other sites

pils 49

Share this post

Link to post

Share on other sites

MiNoxus 10

Share this post

Link to post

Share on other sites

chrism37 10

Share this post

Link to post

Share on other sites

kenzo47 10

Share this post

Link to post

Share on other sites

YouKnowBlom 10

Share this post

Link to post

Share on other sites

chrism37 10

Share this post

Link to post

Share on other sites

Paco79 10

Share this post

Link to post

Share on other sites

Insom 10

Share this post

Link to post

Share on other sites

CdoubleZ 10

Share this post

Link to post

Share on other sites

BTNGaming 10

Share this post

Link to post

Share on other sites

CdoubleZ 10

Share this post

Link to post

Share on other sites

shifftie 10

Share this post

Link to post

Share on other sites

YouKnowBlom 10

Share this post

Link to post

Share on other sites

BTNGaming 10

Share this post

Link to post

Share on other sites

YouKnowBlom 10

Share this post

Link to post

Share on other sites

dburke87 10

Share this post

Link to post

Share on other sites

zSwayz 10

Share this post