It looks like you're new here. If you want to get involved, click one of these buttons!
Wohoo, awesomesauce: Database of active players on Undine server http://davidallanthompson.com/rs/chardb/search.php
(Editing out links to the m'tro site. Pretty sure RedSkies being linked to who I am now brings shame and dishonour to all you good people ;3)
I found it interesting just the number of pages per class that are currently ranked in the top 10,000 players who have been active in the last 40 days. 24 pages of Master Breeders, 5 pages of Mercenaries. This is over all servers.
It'll be split over a few posts.
(Sub, can the word count per post disregard HTML? I remember being unable to post a copy/paste grid for the Rappelz stats guide, even though the grid itself was quite small the additional HTML characters threw the limit way out...)
Scraped together* a database of Active** players on our server
*Opened each page of the Leaderboards and copy/pasted them into an Excel spreadsheet, deleted unnecessary columns, exported to CSV, imported the CSV to a database via PHP, and made a rudimentary front-end for searching through the players.
** "Active" = In the top 10k, logged on (or gained EXP?) in the last 40 days, level 150 or higher (got a few 149s just incidentally)
You can search by name, level, class and/or guild.
I'll add order-by eventually, for now results are ranked by Level (and presumably sub-ranked by EXP if the leaderboard were accurate at the time)
Clicking a name shows a brief history of changes made to a player's entry in my database. Shows the last time their name was uploaded (via CSV for batches) and the last time something about them was actually updated (doesn't update their entry if all of the details are still the same as before).
It's ugly, and I can't really differentiate between change types (if their level, guild or class)
because I was lazy and used a single 'history' field to contain a single string broken up by commas and semicolons.
Whaaaat, I hate joining tables. This was, I think, easier to set up. I told it to do a newline before a string segment
which is 19 characters long, which the timestamp is, to break up the updates list. If someone could have a
19-character guild or class then this wouldn't work very well at all xD
But I'm sure you can get the idea by looking at it. If it says "159" that was probably their level changing, not their guild. If it says 159, Beast Master, then it means they levelled up to 159 and changed their class. Deal wit' it!
It will only track changes made as of last night / this morning.
It's now available at the slightly-easier-to-remember snipnsave.info
A mate purchased it for me, paid for a year. 'Bout time I used it for something.
Cool to see you 'round these parts.
Just make sure you send them to snipnsave.info and not the other one - I was lazy with database privileges on the original one, I'm not convinced a clever fellow couldn't drop my tables as part of their search xD