Forums
Clan List Logger
Quick find code: 86-87-226-65189098
The algorithm I use is pretty simple, but very effective, it has yet to fail me. Of course, it can't work if someone was F2P, becomes member and changes his name at the same time/day.
List all members who left the clan, if there's none, nothing else to do.
List all members who joined the clan, if there's none, nothing else to do.
For each member who joined the clan:
- get his xp in every skill, including total, and scores in mini-games. Stored into an array 'xp' (if not displayed in hiscores, set to 0)
- For each member who left the clan:
- - set 'score' to 0
- - get his stored xp in every skills, etc. Stored into an array 'pre_xp'
- - For i = 0 to end of array 'xp'
- - - if xp[ i] < pre_xp[ i] (if he somehow lost xp... Except if a botter changes his name the day he gets reseted. Unlikely to happen)
- - - - score -= 99999
- - - else if xp[ i] == pre_xp[ i] && xp[ i] != 0
- - - - score += 200
- - - else if xp[ i] == pre_xp[ i] && xp[ i] == 0
- - - - score += 10
- - - else if xp[ i] < 1.1 * pre_xp[ i] (if his xp is in a 10% range of previous' xp)
- - - - score += 100
- - - else if xp[ i] > 1.4 * pre_xp[ i] (if his current xp is higher than 140% of previous' xp)
- - - - score -= 100
- - end for (parsing xp array)
- - if score > 1000 (depends on your clan, you might rise this value for a big clan with many name changes, generally score is always above 2000 for a succefully guessed name change)
- - - change_name()
- end for (parsing all members who left)
end for (parsing all members who joined)
As I said, it's a very effective and simple algorithm, as it's pretty unlikely that someone joins with a bit more XP in everything, than someone who just left.
I don't know if it's possible to do that on spreadsheets, I'm really not used to that.
List all members who left the clan, if there's none, nothing else to do.
List all members who joined the clan, if there's none, nothing else to do.
For each member who joined the clan:
- get his xp in every skill, including total, and scores in mini-games. Stored into an array 'xp' (if not displayed in hiscores, set to 0)
- For each member who left the clan:
- - set 'score' to 0
- - get his stored xp in every skills, etc. Stored into an array 'pre_xp'
- - For i = 0 to end of array 'xp'
- - - if xp[ i] < pre_xp[ i] (if he somehow lost xp... Except if a botter changes his name the day he gets reseted. Unlikely to happen)
- - - - score -= 99999
- - - else if xp[ i] == pre_xp[ i] && xp[ i] != 0
- - - - score += 200
- - - else if xp[ i] == pre_xp[ i] && xp[ i] == 0
- - - - score += 10
- - - else if xp[ i] < 1.1 * pre_xp[ i] (if his xp is in a 10% range of previous' xp)
- - - - score += 100
- - - else if xp[ i] > 1.4 * pre_xp[ i] (if his current xp is higher than 140% of previous' xp)
- - - - score -= 100
- - end for (parsing xp array)
- - if score > 1000 (depends on your clan, you might rise this value for a big clan with many name changes, generally score is always above 2000 for a succefully guessed name change)
- - - change_name()
- end for (parsing all members who left)
end for (parsing all members who joined)
As I said, it's a very effective and simple algorithm, as it's pretty unlikely that someone joins with a bit more XP in everything, than someone who just left.
I don't know if it's possible to do that on spreadsheets, I'm really not used to that.
24-Oct-2013 13:29:07 - Last edited on 25-Oct-2013 16:00:35 by 01astronaute
01astronaute
said
:
It somehow deleted all my "Enters" (no idea how to say in English)... If I quote this post, it shows the text with the "Enters", though. Click "quote"and read this in quick reply.
_____________
The algorithm I use is pretty simple, but very effective, it has yet to fail me. Of course, it can't work if someone was F2P, becomes member and changes his name at the same time/day.
List all members who left the clan, if there's none, nothing else to do.
List all members who joined the clan, if there's none, nothing else to do.
For each member who joined the clan:
- get his xp in every skill, including total, and scores in mini-games. Stored into an array 'xp' (if not displayed in hiscores, set to 0)
- For each member who left the clan:
- - set 'score' to 0
- - get his stored xp in every skills, etc. Stored into an array 'pre_xp'
- - For i = 0 to end of array 'xp'
- - - if xp[ i] < pre_xp[ i] (if he somehow lost xp... Except if a botter changes his name the day he gets reseted. Unlikely to happen)
- - - - score -= 99999
- - - else if xp[ i] == pre_xp[ i] && xp[ i] != 0
- - - - score += 200
- - - else if xp[ i] == pre_xp[ i] && xp[ i] == 0
- - - - score += 10
- - - else if xp[ i] < 1.1 * pre_xp[ i] (if his xp is in a 10% range of previous' xp)
- - - - score += 100
- - - else if xp[ i] > 1.4 * pre_xp[ i] (if his current xp is higher than 140% of previous' xp)
- - - - score -= 100
- - end for (parsing xp array)
- - if score > 1000 (depends on your clan, you might rise this value for a big clan with many name changes, generally score is always above 2000 for a succefully guessed name change)
- - - change_name()
- end for (parsing all members who left)
end for (parsing all members who joined)
As I said, it's a very effective and simple algorithm, as it's pret
It was the [ i]'s :p
It somehow deleted all my "Enters" (no idea how to say in English)... If I quote this post, it shows the text with the "Enters", though. Click "quote"and read this in quick reply.
_____________
The algorithm I use is pretty simple, but very effective, it has yet to fail me. Of course, it can't work if someone was F2P, becomes member and changes his name at the same time/day.
List all members who left the clan, if there's none, nothing else to do.
List all members who joined the clan, if there's none, nothing else to do.
For each member who joined the clan:
- get his xp in every skill, including total, and scores in mini-games. Stored into an array 'xp' (if not displayed in hiscores, set to 0)
- For each member who left the clan:
- - set 'score' to 0
- - get his stored xp in every skills, etc. Stored into an array 'pre_xp'
- - For i = 0 to end of array 'xp'
- - - if xp[ i] < pre_xp[ i] (if he somehow lost xp... Except if a botter changes his name the day he gets reseted. Unlikely to happen)
- - - - score -= 99999
- - - else if xp[ i] == pre_xp[ i] && xp[ i] != 0
- - - - score += 200
- - - else if xp[ i] == pre_xp[ i] && xp[ i] == 0
- - - - score += 10
- - - else if xp[ i] < 1.1 * pre_xp[ i] (if his xp is in a 10% range of previous' xp)
- - - - score += 100
- - - else if xp[ i] > 1.4 * pre_xp[ i] (if his current xp is higher than 140% of previous' xp)
- - - - score -= 100
- - end for (parsing xp array)
- - if score > 1000 (depends on your clan, you might rise this value for a big clan with many name changes, generally score is always above 2000 for a succefully guessed name change)
- - - change_name()
- end for (parsing all members who left)
end for (parsing all members who joined)
As I said, it's a very effective and simple algorithm, as it's pret
It was the [ i]'s :p
<
Blasty
the Blue
>
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
24-Oct-2013 14:46:19
That's really helpful thanks, I'll see what I can do
<
Blasty
the Blue
>
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
24-Oct-2013 14:47:13
vnice thanks for sharing it
PvMe Chuck
- Leader of
PvM Events
February 2012 - March 2017
24-Oct-2013 15:10:57
trying it out, can't wait for it to update!
Modest Skillers
-
Now on world 22!
24-Oct-2013 19:06:16
Thank you so much Blasty. Your instructions were clear and I was able to connect a view only copy to our offsite. Extremely useful!
I'll keep an eye out for the next revision. Positive I'll need good instructions on how to install it though.
Cheers,
Tam
I'll keep an eye out for the next revision. Positive I'll need good instructions on how to install it though.
Cheers,
Tam
Eldest Goat of the Old Goats
...
Baaaaaah!
Curiosity is a good thing
24-Oct-2013 22:53:40
Awesome job, nice one Blasty.
I may also import this to our offsite. Google sites 'n all
.
Cheers,
Radical. -
I may also import this to our offsite. Google sites 'n all
.
Cheers,
Radical. -
Proud Leader of Aberrant ~ 130/2300+ PvM
"Higher Standards are the Foundation for Greater Achievements"
24-Oct-2013 23:38:34
Whoa. Amazing!
This looks really really good. Will become incredibly useful for our clan with recent things we've implemented.
This looks really really good. Will become incredibly useful for our clan with recent things we've implemented.
25-Oct-2013 10:09:19
I'm glad people are finding it useful
As of this post I've updated the V1.1 spreadsheet in the OP to fix the rankup/down mix up, with the fix mentioned in this post .
Currently I have these features in progress:
- Column for membership
- Daily updating clan hiscores
- Improved menu options (manual update in particular)
- More convenient system for updating
- System to account for name changes
- System to allow custom notes on clan mates
- System that notifies of inactive players
- Graph generator for player XP over time
- Improved alternative interface
- Customization for appearance
- Improvements to settings
- Colour coding ranks and including images
- Improved instructions and notifications
It's a lot to do but I'm still looking out for further ideas
As of this post I've updated the V1.1 spreadsheet in the OP to fix the rankup/down mix up, with the fix mentioned in this post .
Currently I have these features in progress:
- Column for membership
- Daily updating clan hiscores
- Improved menu options (manual update in particular)
- More convenient system for updating
- System to account for name changes
- System to allow custom notes on clan mates
- System that notifies of inactive players
- Graph generator for player XP over time
- Improved alternative interface
- Customization for appearance
- Improvements to settings
- Colour coding ranks and including images
- Improved instructions and notifications
It's a lot to do but I'm still looking out for further ideas
<
Blasty
the Blue
>
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
25-Oct-2013 10:36:24
Quick find code: 86-87-226-65189098 Back to Top