Persistent Database and Resupply

[ConArts 1]

Is it correct that this mod wont save spawned in vehcles (With Zeus) to the DB ?

[Guest]

Thanks for informing us about the update :)

New version frontpaged on the Armaholic homepage.

SRU - Persistent Database and Resupply v2.1.0

extDB2

Community Base addons A3

[tebbbs 33]

Is it correct that this mod wont save spawned in vehcles (With Zeus) to the DB ?

 

Hi,

 

no thats not right. Every vehicle will be stored in the database. You can however delete them with Zeus again and then run a PHP cronjob that deletes everything that has not been updated in the last 10 minutes. Here is an example how our cronjob looks like. It runs every hour on our windows server. We will maybe include it into the mod sooner or later.

while(true){
	$sql = "SELECT id FROM mission ORDER BY missionLoaded DESC LIMIT 1";
	$qGet = $dbc->prepare($sql);
	$qGet->execute();
	$aGet = $qGet->fetch(PDO::FETCH_ASSOC);
	$iMissionFk = $aGet["id"];
	
	
	/** vehicles */
	
	$sql = "SELECT id FROM vehicles WHERE mission_FK = ?";
	$aAttributes = [$iMissionFk];
	$qGet = $dbc->prepare($sql);
	$qGet->execute($aAttributes);
	$aGet = $qGet->fetchAll(PDO::FETCH_ASSOC);
	$iCount = count($aGet);

	$sql = "SELECT id FROM vehicles WHERE rec_date < NOW() - INTERVAL 60 MINUTE AND mission_FK = ?";
	$aAttributes = [$iMissionFk];
	$qGet = $dbc->prepare($sql);
	$qGet->execute($aAttributes);
	$aGet = $qGet->fetchAll(PDO::FETCH_ASSOC);
	
	if(count($aGet) != $iCount){
		foreach($aGet as $aVehicleToDelete){
			$sql = "DELETE FROM vehicles WHERE id = ?";
			$aAttributes = [$aVehicleToDelete["id"]];
			$qGet = $dbc->prepare($sql);
			$qGet->execute($aAttributes);
		}
	}
	
	
	/** objects */
	
	$sql = "SELECT id FROM objects WHERE mission_FK = ?";
	$aAttributes = [$iMissionFk];
	$qGet = $dbc->prepare($sql);
	$qGet->execute($aAttributes);
	$aGet = $qGet->fetchAll(PDO::FETCH_ASSOC);
	$iCount = count($aGet);

	$sql = "SELECT id FROM objects WHERE rec_date < NOW() - INTERVAL 60 MINUTE AND mission_FK = ?";
	$aAttributes = [$iMissionFk];
	$qGet = $dbc->prepare($sql);
	$qGet->execute($aAttributes);
	$aGet = $qGet->fetchAll(PDO::FETCH_ASSOC);
	
	if(count($aGet) != $iCount){
		foreach($aGet as $aObjectToDelete){
			$sql = "DELETE FROM objects WHERE id = ?";
			$aAttributes = [$aObjectToDelete["id"]];
			$qGet = $dbc->prepare($sql);
			$qGet->execute($aAttributes);
		}
	}

	sleep(3600);
}

[ConArts 1]

Hi again :)

 

Would i be possible to make it so when you die you respawn without your previous loadout ? im thinking that this would req the db to make a new entry on respawn if previous Caracter is dead.

 

And make it save ACE adv. medical state.

[tebbbs 33]

thats not something our mod should do. You usually set this option in ACE3 or somewhere else if player should respawn with last gear or not. Our mod just saves the inventory. It has nothing to do with setting the gear after you die.

[ConArts 1]

Hi again..

 

After 1.60 it would seem that your mod dosent load gear in uniform,vest and backpacks, do you have a fix incomming ?? :)

[tebbbs 33]

Hi, i dont think there will be a fix from our side. I asked the guys from ACE3 to maybe implement this mod in the future, but i stopped developing (hunting behind BI's code changes). I removed Arma 3 from my computer and i am not sure.. maybe Spackenbremse wants to find a quick fix for this but i dont have fun with this anymore :P Sorry

[seraphimwolf101 11]

Hi There, 

 

My group is looking to move over to this from ALiVE as we utilize a lot more zeus for story involvement etc, however while looking at the requirements we noticed that it is extDB2 however when looking for this we see extDB3. So in line with this my query is will this system still function with extDB3? I may have missed the post somewhere with in here and if so I apologise I just want to be sure.

 

Regards 

[tebbbs 33]

sorry no idea, i stopped developing

[dixon13 15]

I hope you don't mind tebbbs but I have started hosting 2.1.0 on my GitHub, which you may find here. If that is an issue, please notify me, and I will take it down. I will work on it occasionally when I have free time. If you guys want a web application of some sort, myself and a friend could possibly come up with something for Django, the python web framework. As for PHP, I'd have to dust off that part of my brain and work on something. Also, if any of you want to contribute a web application for this, go right along and make a PR on my GitHub.

[Berntsen 19]

I hope you don't mind tebbbs but I have started hosting 2.1.0 on my GitHub, which you may find here. If that is an issue, please notify me, and I will take it down. I will work on it occasionally when I have free time. If you guys want a web application of some sort, myself and a friend could possibly come up with something for Django, the python web framework. As for PHP, I'd have to dust off that part of my brain and work on something. Also, if any of you want to contribute a web application for this, go right along and make a PR on my GitHub.

I'd love a web framework, if possible :)

 

Hi There, 

 

My group is looking to move over to this from ALiVE as we utilize a lot more zeus for story involvement etc, however while looking at the requirements we noticed that it is extDB2 however when looking for this we see extDB3. So in line with this my query is will this system still function with extDB3? I may have missed the post somewhere with in here and if so I apologise I just want to be sure.

 

Regards 

This is gonna sound weird, but I really like your avatar.

[dixon13 15]

Ok well when I have some free time I could conjure up some kind of framework? What web frameworks are you familiar with?

[Mr.jizz 9]

Ok well when I have some free time I could conjure up some kind of framework? What web frameworks are you familiar with?

Hey dixon13, you may be my savour after this mod stopped being developed, i dont have a clue on setting up a database, so this would be my perfect solution, currently im saveing game with publicnanespace, but that doesnt work after restart......one thing i may add if entirely possible (considering the time youve probably already spent on this), i have 2 variables i would like to save (ie cash = 100, kills = 2), would you be able to add this or to help me out thanks?, its if not i know youve probably more important things.

I wish some could release a video tutorial on how to this, i just cant get my head around it from what ov read

[tebbbs 33]

We are back in business with this mod but i am not sure if this is still required if dixon13 is already working on it. If yes, we could supply you with the alpha of our webinterface.

[Spackenbremse 4]

btw, we already got a version running with extDB3 ;)

[Greatman 10]

I hope you don't mind tebbbs but I have started hosting 2.1.0 on my GitHub, which you may find here. If that is an issue, please notify me, and I will take it down. I will work on it occasionally when I have free time. If you guys want a web application of some sort, myself and a friend could possibly come up with something for Django, the python web framework. As for PHP, I'd have to dust off that part of my brain and work on something. Also, if any of you want to contribute a web application for this, go right along and make a PR on my GitHub.

 

can this be used for any mod? can it be used with ravage to make vehicle and inventory persistent ? 

[tebbbs 33]

what is ravage

[tebbbs 33]

Thread can be closed. We are currently working on a new version with a different title

[dixon13 15]

If you are working on a new version with a different title, then I will close down my repo on GitHub as I have not done much with it but just to host it. I thought I was going to use it and work with it more but never did. Good to hear it will be even more awesome.

[ConArts 1]

Hi, Any chance of getting a the version that works with extdb3 so we can use the 64bit dedi server.exe ?? :)

[tebbbs 33]

here you go ;) http://tebinulrich.de/pdb.pbo

 

Did the older version work good on your server? We never received any feedback of a running installation other than our own.

[torndeco 128]

Note you can replace the call compiles with the extensions with parseSimpleArray

[tebbbs 33]

I am currently in airline training so cant continue development until at least July.

[ConArts 1]

On 25/3/2017 at 9:13 AM, tebbbs said:

here you go ;) http://tebinulrich.de/pdb.pbo

 

Did the older version work good on your server? We never received any feedback of a running installation other than our own.

I actually fix'ed it myself :)

We have used it for for about 8 or 9 month now.. and only did a few fixes, as we run big presistent missions every Thursday.. but somtimes it would stop saving if it encountered an error. but made a work around.. :)  Looking forward to the new version you guys are working on :)

[tebbbs 33]

On 27/03/2017 at 10:36 PM, ConArts said:

I actually fix'ed it myself :)

We have used it for for about 8 or 9 month now.. and only did a few fixes, as we run big presistent missions every Thursday.. but somtimes it would stop saving if it encountered an error. but made a work around.. :)  Looking forward to the new version you guys are working on :)

 

if it stops saving, its usually because objects have a special char in them (as far as i remember, i might be wrong). If you could tell me how you "work around" this problem, i can see if your solution makes sense and if i implemented