CLEAN UP the ALLIANCE Database CLOSET!

[Carrigana]

I'm sure this topic is buried in here somewhere, but COME ON GUYS!, Y'all SERIOUSLY need to CLEAN OUT/UP Your Alliance Database!!

Not only are there a MILLION unused Alliance accounts with a total of ONE SINGLE PLAYER, that single playet has not even been logged onto Dominations for MONTHS!! I have seen 200-300+ DAYS!! which is rather ridiculous!

The Dead, Abandoned, Unused, Stale Alliances just eat up space & make it so much harder to FIND ACTIVE Allainces (& Active Alliances to find interested members!

NOT THAT HARD OF A "FIX"!!
How hard can it be to write a quick script to run against 2 dtabase Fields?

1) If the field "Login" is GREATER THAN > than X number days (30 would an improvement, although personally I would set it for 10 days) = REMOVE PLAYER

2) NEXT, If after running the above script #1, the total Players in the Alliance equals ZERO, then = REMOVE ALLIANCE!
***BAMMM!!**
Done & Alliance Database is FINALLY CLEANED UP!!

PLEASE, Please Pretty Please, Could You maybe work on this one?


Thanks!! -- From Someone so tired of scrolling through Dead/Stale & Abandoned Alliances looking for a new ACTIVE one, I gave up & Started My Own! => USA GulfCoast

 

[sponge]

Not the best solution, because you never know when someone actually stopped playing or real life happened. What if you got sick and ended up in a hospital for a few weeks? Would you be happy to see your account removed from the game after you got back?
Much better solution is to show those dead alliances on the bottom of search results, and perhaps tag them as dead or inactive after certain conditions are met.

 

[Eddie F1]

Pretty sure OP meant just remove player from alliance only, not delete their account.

10 days might be a bit short - some of us go on holiday for a couple of weeks and part of a holiday is not playing this.

 

[Viridila]

Probably more than 365 days would be the best time to remove it.

 

[Vixen]

Probably more than two weeks should be time to remove it!! If they come back they can rejoin.

 

[Carrigana]

Thanks for the translation, you were very correct. I simply meant "Remove/Delete" from the Alliance (Not the Player from the Game). I also meant Removal/Deletion of the Alliance/Name if no active players were left in it, in order to make room for NEW Alliances that are Active.

*lol* The number of days was just an example...although in my last Alliance the Rule was if gone for 5+ days w/o having let anyone know in advance, yes, a player was removed. The logic was, that active players were needed to participate & provide support to each other for WWars (we had issues with either no shows or not using both attacks for Opt-IN's of WW's)

I thought it was a no brainer to say, hey, gonna be gone for a bit but will be back or hey having phone issues just in case I go MIA..etc. and, always easy to return & rejoin...*shrugs* ..but, the rule was in place when I joined..it seemed to work well & we still maintained a steady 46-50 active players (none over 5+ days offline.)

 

[Carrigana]

Not the best solution, because you never know when someone actually stopped playing or real life happened. What if you got sick and ended up in a hospital for a few weeks? Would you be happy to see your account removed from the game after you got back?
Much better solution is to show those dead alliances on the bottom of search results, and perhaps tag them as dead or inactive after certain conditions are met.

=================

I did not mean to delete the Player's game account, just simply to remove the Player from the Alliance Member list (as mentioned he/she could re-join again when once more actively playing), in order to determine if that Alliance was an Active Alliance or one which had fallen into abandon by most or all listed members. By removing INACTIVE Players from the Member Roster, it would also allow new active players to join the Alliance, who then could offer current support to the Alliance Members, which is a plus for the Alliance (keeping it revelevant) and its members (Alliances are created/joined to make players stronger by teaming up. Plus, it is difficult to not only go to World War, but to Win World Wars, when most of the Alliance Opt'd IN Players are inactive and therefore not making their attacks. Hence, ACTIVE Players are better for all Players across DomiNations.

The reason being, I have seen Alliance Member Rosters with the Leaders & Council Members listed as Offline/Last Logged In anywhere from weeks to several hundered days, and yet, there were New Members listed. If a Member Player is only at an "Ally" level then He/She is unable to 'demote' or 'kick' an Inactive Player from the Member Roster and make room for New Active Players (potentially keeping the Alliance Active & Thriving versus being stuck in a stalled Alliance with the only active members unable to affect any changes, because their Alliance Leaders/Co-Leaders/Council Members, were all M.I.A. (and if a Player is gone from the game for months, particularly any level of Alliance Leader, then He/She should have no expectation that the Alliance will remain at a complete stand still until their return.)

Anyhow, these were my thoughts on this topic, and simply my own opinions for the reasons I stated. Any movement to clean up the Alliance Database would be a welcome one.

With Regard to just 'shuffling' old Alliances to the bottom of the list, all that will do in an electronic system is build up, eating up more and more space (becoming ever longer of a list = and honestly, ppl tend to get sick of scrolling through all the names, plus, with 10 "Gumball Bandits" or whatever exact same names -- eventually enough is enough & you just have to take action), until it eventually it becomes a burden that will demand to be addressed (causing lag/crashes/glitches/bugs/etc) as database storage space is always limited...Eventually, you run out of space, hence why information is prioritized & you keep the important, and delete the irrelevant once key indicators are triggered.

Again, just my views...

 

[sponge]

=================

With Regard to just 'shuffling' old Alliances to the bottom of the list, all that will do in an electronic system is build up, eating up more and more space (becoming ever longer of a list = and honestly, ppl tend to get sick of scrolling through all the names, plus, with 10 "Gumball Bandits" or whatever exact same names -- eventually enough is enough & you just have to take action), until it eventually it becomes a burden that will demand to be addressed (causing lag/crashes/glitches/bugs/etc) as database storage space is always limited...Eventually, you run out of space, hence why information is prioritized & you keep the important, and delete the irrelevant once key indicators are triggered.

Again, just my views...

The game database is very likely NoSQL, my bet is on Amazon DynamoDB, so all those extra alliances, even when we talk about millions of them, have marginal impact on performance. The same with storage space, there is no such thing as limited storage, you can always add more. And most NoSQL databases have no hardcoded limits or limits are so high the we cannot reach them in the nearest future.

The amount of data is not the issue, the way that data is presented to users is.