Forums

Clan List Logger

Quick find code: 86-87-226-65189098

Grey Inc
Jan Member 2012

Grey Inc

Posts: 716 Steel Posts by user Forum Profile RuneMetrics Profile
Blasty said :
For anyone interested in adding features to the sheet, I've updated the template so that it uses the new version of Google Sheets.

If you don't plan on adding any features, nothing else has been changed in the update so it likely isn't worth trying to move data from one sheet to the other.

­­­­ .:
Blasty
the Blue
:.­­­


Thanks! :)

Shoot for the moon and if you miss just grab a star!

21-Jan-2015 17:38:09

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
PantsuOnHead said :
Hey Blasty. I doubt the excessive throttling would allow for something like that anyway, unless you're manually managing the servers instead of going by Jagex's load balancer. It'd be a slow and painful mess with more headaches than it's worth.


Oh I just realized in response to this, using seasonal hiscores with a good pair of data points can let you be highly certain of a name change between any two points in time with a very simple comparison algorithm.

That is one reason it's better than hiscores, which likely have to be looked up regularly for every clan mate for it to work.

With seasonals it should be sufficient to only look up the data when each person joins or changes their name, not daily like hiscores. The data of the joiner/name-changer can then be compared with the data of people who have left.

Some people don't have enough seasonal hiscores entries for this to work fully for them though. Still, you can say empty at date ___.

Edit:

Just as an example, have a quick look at my seasonal hiscores entry:

http://services.runescape.com/m=temp-hiscores/getRankings.json?player=Blasty&status=archived

If, at any point in the future, you look someone up whose seasonal hiscores entry begins identically to mine (if rank can change then ignore it), you can be almost certain that it is me, no matter when and no matter what my RSN is. No one else got a score of 111 for Penance King kills for the seasonal hiscore with the ID 1409047204321.

If you use an algorithm to convert the information in that array into a hash, then it should be a compact way to reliably store and compare two seasonal hiscores to check name changes.

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ .:
Blasty
the Blue
:.­­­­­­­­­­­­­­­­­­­­­­­­­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

28-Jan-2015 02:49:55 - Last edited on 28-Jan-2015 03:47:33 by Blasty

Body btw

Body btw

Posts: 19,488 Opal Posts by user Forum Profile RuneMetrics Profile
Blasty, does this have a way to tell what date someone joins?

Edit: I mean like, I want to go to Member XYZ, and see what date he joined (sometime last year for example)

As long as I was using this since last year, it should right? Also can I manually input the data for what date a member joined for the member's that joined before I started using this?

Sorry I'm noob with this computer stuff :P
"Why are you posting threads, asking questions and making discussion???"


All I do anymore is fish - 2017

02-Feb-2015 10:35:20 - Last edited on 02-Feb-2015 10:38:47 by Body btw

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
It does, but it's not very user friendly. Admin menu -> open UI -> find name in list. It's more of a test of features than designed for actual use.

Besides that you can do a ctrl+F and see which cells light up.
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

02-Feb-2015 10:39:29

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
The sheet works as a tool for referencing what information it gets rather than storing additional information although it's up to you how you want to customise it as long as you know what you're doing.
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

02-Feb-2015 10:41:56

SofaKing

SofaKing

Posts: 1,854 Mithril Posts by user Forum Profile RuneMetrics Profile
Whenever i want to find someone, the date they were promoted, joined left, demoted, i just go to the clan log tab and hold down CTRL + F then type their name :D

edit;
Blasty said :
Besides that you can do a ctrl+F and see which cells light up.

i declare my comment null

02-Feb-2015 10:57:17 - Last edited on 02-Feb-2015 11:15:04 by SofaKing

King Patrick
Jul Member 2012

King Patrick

Posts: 1,389 Mithril Posts by user Forum Profile RuneMetrics Profile
This is awesome. I'm already experimenting with it. I'm not very tech savy, though :P

Edit: This is an extremely powerful tool, and it's really going to help us clan leaders out. Thanks a lot, Blasty!
I Am Patrick, Founder And Leader Of The Mighty
Defenders Of Gielinor!
Follow me on Twitter @The_Paddyman

People often ask if I'm Irish. I'm descended from them, but... not really, no. I hope I will be one day!

19-Mar-2015 02:04:42 - Last edited on 19-Mar-2015 02:16:22 by King Patrick

Freud

Freud

Posts: 6,469 Rune Posts by user Forum Profile RuneMetrics Profile
Blasty said :
Hey Feud, the steps for checking the library version are on the first page of the thread, I think version 29 should fix the bug you mentioned but I may have to have a closer look.

I hope people have been finding the logger useful :)

­­­­ .:
Blasty
the Blue
:.­­­


Oops :P on version 27 :P
.......:::::::;;;;;;;;
¸.·°´¯`°·.¸
;;;;;;;:::::..
Freud
;;;;;;;:::::::....
¸.·°´¯`°·.¸
.......::::::;;;;;;
`°·.¸
Clueless Adventurers
¸.·°

19-Mar-2015 13:10:05

Quick find code: 86-87-226-65189098 Back to Top