Petunia Forums

Petunia Server => SERVER NEWS => News & Updates => Topic started by: Mike on April 13, 2014, 01:59:22 PM

Title: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 13, 2014, 01:59:22 PM
So we have over 13'000 objects in our object_data SQL table alone...

Don't know what this means? Basically LOOOOONG reboot times, more lag on the server and issues that arise from the lag. PLUS with all the unused vehicles keeping us at the max vehicle count, NO NEW VEHICLES are spawning :(

We've previously tried to think about this issue (http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this (http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this)!/) but we've now launched something that WILL fix this...

Be afraid... Be VERY afriad!

New System For Bases:
-------------


* We have enabled building maintenance
* You MUST put a plot pole in the middle of your building (not required to build but IS required to maintain!)
* You MUST look at the plot pole, scroll select 'Maintain Area' and click on it
* This will update ALL your build objects (yes we added the custom buildings from the donor shop etc!)

How Often You Need to do This:
---------------------------------


* Ideally, once per week (to be sure you're safe!)
* This is because every day we check for ANY building NOT updated for the last 30 days - and DELETE IT.

So, you 'could' get away with updating it once a month.. ideally I'd say try to do it once a week, once every 2 weeks at the longest.

If you're going away for a while - holiday etc:
---------------------------------------------


The plot pole does NOT have to be yours - and anyone can look at your plot pole and maintain for you - so ask a friend or, as a LAST RESORT, PM an admin and ask if they can do your 'maintain area' task for the few weeks you're away.

When does this base wiping start?:
----------------------


Players have ONE WEEK to do their first maintain - meaning in ONE WEEK we will delete ANY base NOT updated by the maintain area task detailed above.

If you can't make it on, ask a friend to do this OR ask an admin to do this.

ENFORCING OLD SYSTEM FOR VEHICLES:
-------------


Vehicles were explained in detail here: http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this (http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this)!/ and this has not changed.

Basically...


* You MUST put something in your vehicles gear frequently.
* Every day, we run a check for vehicles not updated in over 30 days - and DELETE them.
* As with plot pole, you should do this once a week or at least once every 2 weeks

When is the vehicle wipe starting?:
-----------------------------------


IMMEDIATELY! later TODAY we will be DELETING any vehicle that has not been updated in 30 days (we've been warning about this for ages, see: http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this (http://www.petuniaserver.com/forums/news-updates/important-got-a-base-or-a-vehicle-read-this)!/)

AT THE CURRENT COUNT we will be deleting OVER 100 VEHICLES!

--------------------------------------------------------------------------------------------------
You were warned! -

Note, ALL you need to do is:

1) look at a plot pole in your base every couple of weeks and scroll to 'maintain area'
2) Put something in the gear of each of your vehicles every couple of weeks.

The result of this is that we will have a server that has LESS LAG, runs smoother, has SHORTER REBOOTS and also has MORE VEHICLE spawns :)

--------------------------------------------------------------------------------------------------
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: savedbygrace on April 13, 2014, 07:55:27 PM
This is great! I've been wondering why I have seen no vehicles spawning but see old vehicles that have been around since my join date. Tired of seeing the abandoned vehicles everywhere. Great effort Mike and team!
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 13, 2014, 11:34:06 PM
Thanks Saved by grace :D

Hopefully we've come up with a solution that keeps our players happy but also allows new vehicles to spawn for new folks :) Plus keeps the lag down :D

Thanks for your post, feedback really helps us to know when we've come up with a good idea, or just annoyed everyone, lol :D

This is great! I've been wondering why I have seen no vehicles spawning but see old vehicles that have been around since my join date. Tired of seeing the abandoned vehicles everywhere. Great effort Mike and team!
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Pip on April 14, 2014, 07:20:50 AM
This could suck badly for me... My play time varies and with wifey about to hatch out the little one, I could be gone for a bit longer than usual without notice.  I miss you guys, I've been really busy lately with life stuff like work, work, work, work, work, work, and getting ready for baby.
Hope to have some free time soon.

-Pip
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 14, 2014, 10:50:20 AM
Pip, I'm sure between me & the other admins, we could scroll wheel on your plot pole for you when you need it if you just ping us a PM or something?- only takes us 2 misn to TP there and scroll wheel ;)

Would that help?

This could suck badly for me... My play time varies and with wifey about to hatch out the little one, I could be gone for a bit longer than usual without notice.  I miss you guys, I've been really busy lately with life stuff like work, work, work, work, work, work, and getting ready for baby.
Hope to have some free time soon.

-Pip
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: savedbygrace on April 15, 2014, 05:15:08 AM
In a worse case scenario, you could place a plot pole on the exterior portion of your wall, and one of us other players could stop in to maintain the area for you as well. So long as we know where your base is.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: brendan on April 15, 2014, 08:23:27 PM
i might need admins to place the plot pole and maintain it for me b/c i am currently busy with irl things like baseball and homework and i really only post whilst im at school l ;D l so i wont be able to get on for a while :'(
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 15, 2014, 08:28:05 PM
Good idea :)

I overrode the default distance covered to be 250mtrs, so that would work :)

In a worse case scenario, you could place a plot pole on the exterior portion of your wall, and one of us other players could stop in to maintain the area for you as well. So long as we know where your base is.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: savedbygrace on April 17, 2014, 05:23:49 AM
Does it count when one player places a plot pole for another players placed items to simply maintain it?
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 17, 2014, 07:52:14 PM
Yup :) The only potential issue with this would be if another player had a plot pole nearby as it may then stop the 2nd player placing a plot pole.

But basically, any player can scroll wheel on any plot pole and will with update all buildables within 250 mtrs of that pole :)

Does it count when one player places a plot pole for another players placed items to simply maintain it?
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Fleck on April 23, 2014, 12:32:14 AM
Oh man. I done f'ed it up. It has been a few months since I'v been on and none of my Friends have either. So I didn't even see this was going to happen. What I'm trying to say is I prefer to not have a empty space where my base was. Not sure if I could get any help on that.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 23, 2014, 11:27:40 PM
Ouch!

The way EPOCH stores stuff (tied to characterIDs that change of death not playeruid that doesn't), we can't restore it - sorry Fleck :(

We did send multiple emails our warning before hand...

What I can do, if it helps at all, is give you a box of building supplies? With the snap building on these days, it's much quicker to build.

Sorry I can't help more than that :(

Oh man. I done f'ed it up. It has been a few months since I'v been on and none of my Friends have either. So I didn't even see this was going to happen. What I'm trying to say is I prefer to not have a empty space where my base was. Not sure if I could get any help on that.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Fleck on April 25, 2014, 12:28:32 AM
That would be awesome! The base itself wasn't very large in size. Just the gear I had in there is what I miss. If it wouldn't be a major pain in the ass for you guys it would be awesome to just rebuild it quickly.

-TY
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Fleck on April 25, 2014, 12:44:00 AM
So after a little more thought and talking with my friends who also play the server, and we decided that we don't really care all the much that the gear. EXCEPT our clothes XD. Again, if it wouldn't be a pain in the ass it'd be awesome if we could setup again.

With so much gear after a long period time you get a little bored, so honestly this is fresh start and a new incentive to hop back on. Thanks again.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: brendan on April 25, 2014, 05:17:30 AM
goodbye all of my things i was busy with irl things for the past three weeks and i have not been able to play so all of my things are gone :(
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: 2yys on April 25, 2014, 03:45:44 PM
Only takes 5 min of time to make sure your stuf is safe once or every 2 weeks
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 25, 2014, 06:54:30 PM
Noooo :( Didn't you get the emails where we said email me & 2yys and we'll do the maintain if people let us know?

Are you sure it's all gone?

goodbye all of my things i was busy with irl things for the past three weeks and i have not been able to play so all of my things are gone :(
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: brendan on April 26, 2014, 12:41:26 AM
im not sure but i have not been on in 2 weeks
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: savedbygrace on April 26, 2014, 12:57:28 AM
What would be wrong with doing the maintenance every four weeks? Before, it was monthly. Now that it's even easier to report ownership, you've increased the wipe event? Not complaining, but things do happen in real life that keep you away from the hobbies longer than you care to be. Two weeks soars by far quicker than you'd want to believe but four weeks seemed like a good settle point before. Does the server truly clutter that quickly or did you shorten the time span to keep the process fresh in your mind(trudging through the code can be slow when you've been away from it for too long)?

Just curious.

If Brendan will PM me his coordinates and perhaps a code to his entrance door and where the plot pole is, I'll scroll on it and lock it back without peeking into any inventories. You can always change the lock when you return next.
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: 2yys on April 26, 2014, 02:03:32 AM
Guys here is the info again! Its now an automated system it really only needs to be done once every 29 days, but to make sure its safe we say once  a week!

How Often You Need to do This:
---------------------------------

* Ideally, once per week (to be sure you're safe!)
* This is because every day we check for ANY building NOT updated for the last 30 days - and DELETE IT.

So, you 'could' get away with updating it once a month.. ideally I'd say try to do it once a week, once every 2 weeks at the longest.

If you're going away for a while - holiday etc:
---------------------------------------------

The plot pole does NOT have to be yours - and anyone can look at your plot pole and maintain for you - so ask a friend or, as a LAST RESORT, PM an admin and ask if they can do your 'maintain area' task for the few weeks you're away.

When does this base wiping start?:
----------------------
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 26, 2014, 10:48:49 AM
Thanks 2yys :)

Yep saved by grace - it's still every 4weeks/month... I think Brendan is just saying he hasn't been on for 2 weeks and is worried (for the first maintenance wipe we gave everyone 7 days to do the plot pole maintain).

Anyone can maintain the base by looking at ANY plot pole placed there though.

The database gets full REALLY quickly to be honest, so this step is needed to keep it all running smoothly. It only requires a player to jump on once and scroll on a plot pole, takes about 5 seconds and keeps the database nice and clear :D

The reason I suggest trying to do it once per week is just that it's easy to forget something you do once a month, that's all.

For the more tech savyy out there, this is what happens:

* Scrolling on the plotpole and selecting 'maintain area' updates a field in the database called 'LastUpdated' for each buildable onbject within 200mtrs

* Every day a MySQL event is called automatically that deletes from the object_data table, all objects where 'LastUpdated' is greater than 30 days.

* This includes vehicles - hence the putting something in the vehicle and taking it out again.

So as you can see, it's an automated process.

I'd honestly say just scroll on your plot pole when you can, at a MINIMUM of once a month, to avoid like going 1 hour over a month and being wiped. As 2yys points out, if you are sure to do this every 29 days, you'r fine.

We've even said if someone can't make it, let another player or an admin know and we can sort it for them as it only takes 5 seconds or so.

Since starting this, out objects_data table (the biggest table in the database, pretty much bigger than ALL other database tables COMBINED) has been cut down to around half, which really helps the server stay smooth.

Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: brendan on April 27, 2014, 10:56:48 PM
thank you arma logic my cars and base were there thank you whoever or whatever did that my base is saved
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 27, 2014, 11:01:37 PM
Cool :D

Just be sure to do the plot pole scroll and put something in/out of your vehicles gear to make sure it stays :D

thank you arma logic my cars and base were there thank you whoever or whatever did that my base is saved
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Pip on April 28, 2014, 06:06:58 AM
Is there ANY way to have the plot pole do something to the vehicles to make it so they're "Maintained" when you do the pole thing??  Like add some code like (if key=yes, pole maintains vehicles=yes)  I'm not a programmer by any means, but I kind of understand how code works.  There probably is a way, ust might be more work than it's worth to you. 

I know it seems kind of lazy, but some people, myself included, have sporadic free time and trying to maintain X amount of vehicles might be outside of that time frame.  And don't give me that "Well then don't have that many vehicles!" bs.  I have them for a reason :)

Thoughts??
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: Mike on April 28, 2014, 11:47:36 AM
Hey Pip :)

I could - I did consider writing a code for this...

The only issue is that there are so few unlocked vehicles on the server that new players are having a hard time finding them. Added to that, some bases have LOOOTS of vehicles (which is making us hit the max vehicle cap).

We've already:

* Increased the max vehicles from the default 150 to around 380
* Increased the max buildings from the default 150 to around 420

But still we have players wanting more building allowed on their plot and new players unable to find cars :( It seems the more we up the limits, the more players have... Which is natural, but the MySQL database size can only grow so much :D

So for that reason, we've taken the view that we're not sure if a player has so many vehicles that they go a month without touching them, is it fair on new players and everyone else.

I'm sorry you feel the issue of players having too many vehicles is a BS point, but it really isn't BS when it means it effects players and the server. What it boils down to is that if every player has lots and lots of vehicles in their base, either there will be no new players able to find many vehicles, or we continually up the number of vehicles and the server - but then the established players find a high % of them and put them in their bases, so without a limit on this, we have to keep increasing and increasing it - then the server will load slower and slower due to the objects loading on a reboot.

I'm trying to find a way to both allow players to have the vehicles they want and also allow new players to find vehicles, but unfortunately the way the Arma/DayZ/EPOCH engine works, there's no way to remove the vehicles in peoples bases from the max-vehicle count, which would have solved half of the issue.

I fully appreciate people have stuff to do IRL, but the only alternative to this set-up really is if admins manually check every vehicle on the server and remove the unused ones - Something I don't feel is fair to ask of the admins as to do that for every vehicle would take a long time... So I felt the good in-between thing would be to ask players to each take responsibility for their own vehicles, interacting with them at least once every 29 days.

Loot can be kept in safes of course - which are updated by the plot pole scroll, so it really is just vehicles that are at risk.

I do take your points on board though Pip and I will try to find a middle ground if I can :D Just we are limited by the way EPOCH stores stuff in the SQL database, but we're trying!



Is there ANY way to have the plot pole do something to the vehicles to make it so they're "Maintained" when you do the pole thing??  Like add some code like (if key=yes, pole maintains vehicles=yes)  I'm not a programmer by any means, but I kind of understand how code works.  There probably is a way, ust might be more work than it's worth to you. 

I know it seems kind of lazy, but some people, myself included, have sporadic free time and trying to maintain X amount of vehicles might be outside of that time frame.  And don't give me that "Well then don't have that many vehicles!" bs.  I have them for a reason :)

Thoughts??
Title: Re: URGENT - DELETING YOUR Bases and Vehicles SOON - Please Read!!!
Post by: trots on April 30, 2014, 08:06:11 PM
i would actually be more interested in a poleplot script that stopped spawns of all kinds within the radius of that placement.