Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Undine Character Database
  • Vote Up0Vote Down TuxedomaskTuxedomask

    :edit:

    Wohoo, awesomesauce: Database of active players on Undine server  http://davidallanthompson.com/rs/chardb/search.php

    or

    snipnsave.info


    (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...)

    TuxedoMask
    image
    Post edited by Tuxedomask at 2017-01-17 02:58:21
  • 15 Comments sorted by
  • Vote Up0Vote Down TuxedomaskTuxedomask
    Corruptor
    |1|2|3|4|5|6|7|8|9|10|11
    Void-Mage
    |1|2|3|4|5|6|7|8|9|10|11|12
    Overlord
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23
    Deadeye
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17
    Slayer
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18 
    TuxedoMask
    image
    Post edited by Tuxedomask at 2013-04-01 23:41:16
  • Vote Up0Vote Down TuxedomaskTuxedomask
    Magus
    |1|2|3|4|5|6|7|8
    War-Kahuna
    |1|2|3|4|5|6
    Beast-Master
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20
    Marksman
    |1|2|3|4|5|6|7|8|9|10|11
    Berserker
    |1|2|3|4|5|6
    TuxedoMask
    image
    Post edited by Tuxedomask at 2013-04-01 23:40:59
  • Vote Up0Vote Down TuxedomaskTuxedomask
    Oracle
    |1|2|3|4|5|6|7|8|9|10|11
    Cardinal
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21
    Master-Breeder
    |1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24
    Mercenary
    |1|2|3|4|5
    Templar
    |1|2|3|4|5|6|7|8
    TuxedoMask
    image
    Post edited by Tuxedomask at 2013-04-01 23:41:47
  • Vote Up1Vote Down SubJunkSubJunk
    I raised the maximum comment length, hopefully that's enough
    SubJunk
    image
  • Vote Up1Vote Down TuxedomaskTuxedomask

    Scraped together* a database of Active** players on our server


    http://davidallanthompson.com/rs/chardb/search.php

    *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)

    TuxedoMask
    image
    Post edited by Tuxedomask at 2013-04-07 21:52:05
  • Vote Up0Vote Down AndateAndate
    Lol, it still searched me.  Apparently I'm 152
    Andate
  • Vote Up0Vote Down TuxedomaskTuxedomask
    Added some stats about how many of each class were included in your search. You can look at any guild and see how many Marksmen or Master Breeders they have, or how many Asura classes they have compared to Gaian classes.

    Lots of fun. I am not good with ze DIVs.
    TuxedoMask
    image
  • Vote Up0Vote Down TuxedomaskTuxedomask

    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.

    TuxedoMask
    image
    Post edited by Tuxedomask at 2013-04-12 20:07:13
  • Vote Up0Vote Down SubJunkSubJunk
    Looks great man!
    SubJunk
    image
  • Vote Up0Vote Down TuxedomaskTuxedomask

    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.

    TuxedoMask
    image
  • Vote Up0Vote Down MaxPowersMaxPowers
    yea, good job dude.
  • Vote Up1Vote Down TuxedomaskTuxedomask

    Maaaax :D

    Cool to see you 'round these parts.

    TuxedoMask
    image
  • Vote Up0Vote Down GavriiGavrii
    This is so useful! I shared it with some Nitor people~
    Gavriil
    image
  • Vote Up0Vote Down TuxedomaskTuxedomask

    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

    TuxedoMask
    image
    Post edited by Tuxedomask at 2017-01-17 02:51:46
  • Vote Up0Vote Down TuxedomaskTuxedomask
    ^ Bad spammer, naughty. Go harass some other forum, like the Rappelz Forum >:D
    TuxedoMask
    image
Add a Comment