Il semble que les cookies ne soient pas activés dans votre navigateur. Veuillez activer les cookies pour garantir une expérience du site optimale.
Page 6 sur 7 PremièrePremière ... 2 3 4 5 6 7 DernièreDernière
Affichage des résultats 126 à 150 sur 154

Discussion: Some Statistics

  1. #126
    Date d'inscription
    avril 2007
    Messages
    1 598

    Re: Some Statistics

    Citation Envoyé par kpfitzgerald Voir le message
    Erasmus354 are you using the api? or screen scrape? it is a good idea not to delete data unless you know the data is corrupt in some way, if you are loading the data into a DB you can add a Boolean field to say whether the row is visible or not.

    also the transfers isn't that difficult if you write some simple logic or do a join then compare then add a true to the booloean field through an insert into...
    The API wouldn't really work because you can't get a list of players from it. Unless I knew everyones name I couldn't use it. And while I do know most peoples names there are at least 20 new players each day. The only way right now is a screen scrape. The data is going into a mysql database (which currently has over 450,000 rows of data).


    As for transfers, it is more than some simple logic. You have to recognize that the player doesn't exist on the old server, then find them on one of the new servers. In addition to that they may have gained an unknown amount of renown/infamy and changed their names. Sure for higher ranked players it is easier to do, but for lower ranked players it isn't so easy. The daily updates already take ~an hour, and will take more soon when I fully automate it (manual uploading a saved file is faster than doing the queries through a script, and I don't have CL access to the SQL server). LOTS more logic coupled with many more database queries in order to do that isn't worth the time on the daily updates or the time writing the script.
    Dernière modification par Erasmus354 ; 30/04/2009 à 17h29.
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  2. #127
    Date d'inscription
    avril 2007
    Messages
    14

    Re: Some Statistics

    Nice to know.
    Dernière modification par Theobromine ; 01/05/2009 à 19h50.

  3. #128
    Date d'inscription
    mars 2008
    Localisation
    Columbus OH
    Messages
    278

    Re: Some Statistics

    Citation Envoyé par Erasmus354 Voir le message
    The API wouldn't really work because you can't get a list of players from it. Unless I knew everyones name I couldn't use it. And while I do know most peoples names there are at least 20 new players each day. The only way right now is a screen scrape. The data is going into a mysql database (which currently has over 450,000 rows of data).
    bummer about the API... the data feed form that woudl be best... i just asked for a key waiting for a response.

    Citation Envoyé par Erasmus354 Voir le message
    As for transfers, it is more than some simple logic. You have to recognize that the player doesn't exist on the old server, then find them on one of the new servers. In addition to that they may have gained an unknown amount of renown/infamy and changed their names. Sure for higher ranked players it is easier to do, but for lower ranked players it isn't so easy. The daily updates already take ~an hour, and will take more soon when I fully automate it (manual uploading a saved file is faster than doing the queries through a script, and I don't have CL access to the SQL server). LOTS more logic coupled with many more database queries in order to do that isn't worth the time on the daily updates or the time writing the script.
    actually it is simple logic in SQL, several ways to skin that cat. you could do a join on the server tables looking for distincts based on a timestamp of last daily infany/renown gain. or do a select against all table for players making a temp table for insert into and comparing results and removing the duplicates.
    450k rows may seem like a lot but it isnt in RDBMS standards. unless you are storing BLOB's or GLOB's....

    I am a DBA so if you need assistance let me know.

  4. #129
    Date d'inscription
    avril 2007
    Messages
    1 598

    Re: Some Statistics

    Well pretty major setback it looks like for me. I think my main OS drive on my main PC kicked the bucket. This is a day after I finally automated the entire stat ripping process. Also, I don't have any backups of the stat ripping script. So I need to try and see if the HDD really did go up in flames or if I just need to repair the windows install while at the same time trying to get my 6 year old laptop setup with php and rewrite the entire stat ripping script from scratch before tomorrow morning ..... I also lost some improvements and additions to the site that I was working on.

    Not a happy camper right now.
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  5. #130
    Date d'inscription
    septembre 2007
    Localisation
    Ur of the Chaldees
    Messages
    1 319

    Re: Some Statistics

    Citation Envoyé par Erasmus354 Voir le message
    Well pretty major setback it looks like for me. I think my main OS drive on my main PC kicked the bucket. This is a day after I finally automated the entire stat ripping process. Also, I don't have any backups of the stat ripping script. So I need to try and see if the HDD really did go up in flames or if I just need to repair the windows install while at the same time trying to get my 6 year old laptop setup with php and rewrite the entire stat ripping script from scratch before tomorrow morning ..... I also lost some improvements and additions to the site that I was working on.

    Not a happy camper right now.
    everyone give the man 20 bucks!

  6. #131
    Date d'inscription
    avril 2007
    Messages
    1 835

    Re: Some Statistics



    Everyone deserves one at some point!
    [CENTER][charsig=http://lotrosigs.level3.turbine.com/0a20b00000009cf9b/01004/signature.png]Keidynce[/charsig]
    Keidynce -- Bael -- Celebriath
    [B]Evil and Stuff Like That[/B]
    Gurthag -- Halwabu -- Druth -- Draghkar -- Snagnakh -- Sigh
    [B]The Black Blade[/B][/CENTER]

  7. #132
    Date d'inscription
    avril 2007
    Messages
    1 598

    Re: Some Statistics

    Hooray for back pat kitteh!


    The drive is dead, but it is still under warranty (WD Raptor 150). In the meantime I went down to Microcenter and picked up 2 WD640GB drives, one was bad, took that back, now I am trying to install Windows 7 onto a RAID array.
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  8. #133
    Date d'inscription
    janvier 2008
    Messages
    2 660

    Re: Some Statistics

    Is this not updating?

    It's Monday here and the gains from Saturday aren't up yet...

    I was looking forward to seeing my name at the top of the list for Saturday's gains (somewhere over 10,200)

  9. #134
    Date d'inscription
    avril 2007
    Localisation
    Peoria, IL
    Messages
    506

    Re: Some Statistics

    Likewise - spent a good bit of time on my minstrel in the Moors this weekend, and the leaderboard shows me at 10k less than I have. It does show accrual from the weekend, but the numbers are wrong.

    It also shows me as still be lvl 52, which is weird...

  10. #135
    Date d'inscription
    avril 2007
    Messages
    1 598

    Re: Some Statistics

    Citation Envoyé par andulinde Voir le message
    Likewise - spent a good bit of time on my minstrel in the Moors this weekend, and the leaderboard shows me at 10k less than I have. It does show accrual from the weekend, but the numbers are wrong.

    It also shows me as still be lvl 52, which is weird...
    The level 52 thing is an issue with the old script only updating renown and rating figures and nothing else. The new one will solve this (in theory).

    Also your gains from the blackout until when I get the new script done will be averaged across how many days it was. It is not a perfect solution but it's all I got.
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  11. #136
    Date d'inscription
    décembre 2007
    Messages
    772

    Re: Some Statistics

    Citation Envoyé par operaoneyes Voir le message
    everyone give the man 20 bucks!
    well I for one appreciate your unselfish commitment to all of our ego boosting stats (see Arks Post), send mail on your freep to me and Ill send you 1g for all your troubles

  12. #137
    Date d'inscription
    mai 2008
    Localisation
    Lugz Rez Cricle
    Messages
    457

    Re: Some Statistics

    I guess it's actually gone for good =( sorry to hear about the OS problems and i guess the HD was not recoverable considering the absence of info. Your work is missed =)

  13. #138
    Date d'inscription
    avril 2007
    Localisation
    Brooklyn,NY
    Messages
    3 321

    Re: Some Statistics

    Citation Envoyé par Dommin-Nim Voir le message
    I guess it's actually gone for good =( sorry to hear about the OS problems and i guess the HD was not recoverable considering the absence of info. Your work is missed =)
    Yeah rath only got in vent once recently and i didnt get around to asking him about leaderboards, so no update so far.

  14. #139
    Date d'inscription
    janvier 2008
    Localisation
    city begins w/ H, state w/ T
    Messages
    334

    Re: Some Statistics

    wow, reading the posts hurts my head, i didnt even get past pg 1 lol
    n/a ftw

  15. #140
    Date d'inscription
    août 2007
    Localisation
    Kansas!
    Messages
    4 702

    Re: Some Statistics

    The day the music died: 5/9/09. RIP

  16. #141
    Date d'inscription
    septembre 2007
    Messages
    2 460

    Re: Some Statistics

    Yea I totally agree.

  17. #142
    Date d'inscription
    décembre 2007
    Messages
    474

    Re: Some Statistics

    I really dont know how accurate this can be. how does it take into consideration kinship changes, inactive subscriptions and transfered characters? The leading kin doesnt have a single member on the first page of the mylotro leaderboards for total server wide renown gain, nor the second or even at a glance that i saw third page, and with so few members there is no way that they could have that gain.

    also, i know that honour and glory's total renown is more than 1.2mil or whatever that chart says, if that were the case over 1/4 of the kins renown would be mine, and honour and glory was an established pvp kin long before my coming along, and even with the transfer of faja, polar, who were some of our higher renown earners, the total is still higher than 1.2 mil. what i would like to see is a revised version of this to see which kin/tribe is earning the most renown/infamy on a day to day/week to week basis, rather than a total which is subject to so much change

  18. #143
    Date d'inscription
    octobre 2008
    Localisation
    Japan
    Messages
    202

    Re: Some Statistics

    So, is there any chance of this being resurrected? I loved the leaderboards and was sad to see them down a few months back.

  19. #144
    Date d'inscription
    avril 2008
    Localisation
    SWTOR
    Messages
    1 691

    Re: Some Statistics

    Citation Envoyé par masontamason Voir le message
    So, is there any chance of this being resurrected? I loved the leaderboards and was sad to see them down a few months back.
    I'd say no.. those people have long left LotRO.

  20. #145
    Date d'inscription
    avril 2007
    Localisation
    Brooklyn,NY
    Messages
    3 321

    Re: Some Statistics

    Citation Envoyé par OGsam Voir le message
    I'd say no.. those people have long left LotRO.
    Yeah, pretty sure Erath is playing WoW with some Legends people atm.

  21. #146
    Date d'inscription
    janvier 2011
    Messages
    18

    Re: Some Statistics

    Citation Envoyé par masontamason Voir le message
    So, is there any chance of this being resurrected? I loved the leaderboards and was sad to see them down a few months back.
    I really doubt it. With upcoming games i don't think many will stick around to care enough, sadly. Leaderboards were always fun, it was the last thing servers could "compete at".
    Dernière modification par VaporMadeMeDoIt ; 06/02/2011 à 23h32.

  22. #147
    Date d'inscription
    novembre 2007
    Localisation
    USA
    Messages
    8 294

    Re: Some Statistics

    Pretty funny how it took a player to create something using the leaderboards that people would actually find fun and care about, turbines own leaderboards are lacklustre, buggy and now update pretty infrequently. RIP.

  23. #148
    Date d'inscription
    mars 2008
    Messages
    1 532

    Re: Some Statistics

    Citation Envoyé par BLoNdiE Voir le message
    Yeah, pretty sure Erath is playing WoW with some Legends people atm.
    I saw his hunter in the moors recently, but I didnt see him more than once.

  24. #149
    Date d'inscription
    avril 2007
    Localisation
    Brooklyn,NY
    Messages
    3 321

    Re: Some Statistics

    Citation Envoyé par ellestone Voir le message
    I saw his hunter in the moors recently, but I didnt see him more than once.
    You're seeing things mr.star. Shrug, I haven't talked to him in weeks.

  25. #150
    Date d'inscription
    janvier 2008
    Localisation
    city begins w/ H, state w/ T
    Messages
    334

    Re: Some Statistics

    Citation Envoyé par Erasmus354 Voir le message
    Hey, this is pretty good...

    Except for this. I dont believe it one bit
    Dernière modification par myforumacc ; 20/07/2011 à 13h03.

 

 
Page 6 sur 7 PremièrePremière ... 2 3 4 5 6 7 DernièreDernière

Règles de messages

  • Vous ne pouvez pas créer de nouvelles discussions
  • Vous ne pouvez pas envoyer des réponses
  • Vous ne pouvez pas envoyer des pièces jointes
  • Vous ne pouvez pas modifier vos messages
  •  

La session de ce formulaire a expiré. Vous devez recharger la page.

Recharger