Wir haben festgestellt, dass Euer Browser keine Cookies akzeptiert. Bitte erlaubt die Verwendung von Cookies in den Optionen Eures Browsers, um eine optimale Funktion dieser Webseite zu gewährleisten.
Seite 6 von 7 ErsteErste ... 2 3 4 5 6 7 LetzteLetzte
Ergebnis 126 bis 150 von 154
  1. #126
    Registriert seit
    14.04.2007
    Beiträge
    1.598

    Re: Some Statistics

    Zitat Zitat von kpfitzgerald Beitrag anzeigen
    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.
    Geändert von Erasmus354 (30.04.2009 um 17:29 Uhr)
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  2. #127
    Registriert seit
    17.04.2007
    Beiträge
    14

    Re: Some Statistics

    Nice to know.
    Geändert von Theobromine (01.05.2009 um 19:50 Uhr)
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0000000145f0/01008/signature.png]Theobromine[/charsig]
    Carrowen Lvl 65 Min - SM Jewler, GM Cook, GM Prosepctor
    Sinclaire lvl 42 LM - SM Shcolar, GM Farmer
    Svartalfahein, Theothelion, Valrauko, - Creep Gothmogdum

  3. #128
    Registriert seit
    28.03.2008
    Ort
    Columbus OH
    Beiträge
    278

    Re: Some Statistics

    Zitat Zitat von Erasmus354 Beitrag anzeigen
    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.

    Zitat Zitat von Erasmus354 Beitrag anzeigen
    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.
    [CENTER][charsig=http://lotrosigs.level3.turbine.com/0a20b00000009deab/01008/signature.png]Daddywig[/charsig][/CENTER]

  4. #129
    Registriert seit
    14.04.2007
    Beiträge
    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
    Registriert seit
    08.09.2007
    Ort
    Ur of the Chaldees
    Beiträge
    1.319

    Re: Some Statistics

    Zitat Zitat von Erasmus354 Beitrag anzeigen
    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!
    argh i'm a killerrrr
    you are lolTS'dGREYbarDEAD'ded
    .

  6. #131
    Registriert seit
    24.04.2007
    Beiträge
    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
    Registriert seit
    14.04.2007
    Beiträge
    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
    Registriert seit
    19.01.2008
    Beiträge
    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
    Registriert seit
    07.04.2007
    Ort
    Peoria, IL
    Beiträge
    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...
    Lindoryn 100r11 mns, Lindorien 85r7 lrm, Lindbergh 75r7 brg, Drakur 56r1 grd
    Cuspid, r6 warg

  10. #135
    Registriert seit
    14.04.2007
    Beiträge
    1.598

    Re: Some Statistics

    Zitat Zitat von andulinde Beitrag anzeigen
    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
    Registriert seit
    24.12.2007
    Beiträge
    772

    Re: Some Statistics

    Zitat Zitat von operaoneyes Beitrag anzeigen
    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
    [charsig=http://lotrosigs.level3.turbine.com/0a20b000000080db4/signature.png]Gealachlan[/charsig]

  12. #137
    Registriert seit
    17.05.2008
    Ort
    Lugz Rez Cricle
    Beiträge
    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 =)
    [color=gold]~ Amamadan <retired>, Level 65 Champion of Legends <retired>, Rank 4 on Nim[/color]
    [color=lightblue] ~~ Elthros <retired>, Level 60 Minstrel of Legends <retired>, Rank 4[/color]
    [color=grey] ~~ Methodis <retired>, Level 60 Runekeeper[/color]
    [color=red]~ Accuracy <retired>, Blackarrow of Black Blade <still pwning>, Rank 9 on Nim[/color]

  13. #138
    Registriert seit
    13.04.2007
    Ort
    Brooklyn,NY
    Beiträge
    3.321

    Re: Some Statistics

    Zitat Zitat von Dommin-Nim Beitrag anzeigen
    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.
    [FONT=Comic Sans MS][B][U]Dirtyblonde[/U] 65[/B] Burg (Nimrodel) | [U][B]Notblondie[/B][/U] (Nimrodel) | [U][B]Scratchs[/B][/U][/FONT] (Elendilmir)
    [OOC] ****** : 'except blondie, hes already GM smartass'
    [URL="http://www.youtube.com/watch?v=n7VAhzPcZ-s"]Blame the players.
    [/URL][url="http://www.battlefieldheroes.com/en/ref/2283770762"] Battlefield Heroes is really fun![/url]

  14. #139
    Registriert seit
    18.01.2008
    Ort
    city begins w/ H, state w/ T
    Beiträge
    334

    Re: Some Statistics

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

  15. #140
    Registriert seit
    08.08.2007
    Ort
    Kansas!
    Beiträge
    4.703

    Re: Some Statistics

    The day the music died: 5/9/09. RIP
    [charsig=http://lotrosigs.level3.turbine.com/0320201000027b3ee/signature.png]Mummy[/charsig]
    Ancient spider of the moors

  16. #141
    Registriert seit
    07.09.2007
    Beiträge
    2.460

    Re: Some Statistics

    Yea I totally agree.
    [COLOR="Lime"][B]Tsion[/B][/COLOR] - [B]R10[/B] [B]Captain, [COLOR="Magenta"]Candyman[/COLOR][/B] [B]of[/B] [B][COLOR="DeepSkyBlue"]Nimrodel[/COLOR][/B]
    [B]Leader/Founder of[/B] [B][COLOR="Red"]The Dancing Tsions™[/COLOR][/B]
    [CENTER][COLOR="Lime"][B]Throwing Axe KB Count:[/B][/COLOR] [B][SIZE="3"][COLOR="Red"]5[/COLOR][/SIZE][/B][/CENTER]
    [CENTER][B][COLOR="Yellow"]Collector of Juice™[/COLOR][/B][/CENTER]

  17. #142
    Registriert seit
    09.12.2007
    Beiträge
    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
    Manbeorpig 100 Beorning, Brandywine.

  18. #143
    Registriert seit
    16.10.2008
    Ort
    Japan
    Beiträge
    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.
    [CENTER][URL="http://lotrocommunity.com"]
    [/URL][URL="http://lotrocommunity.com"][B][COLOR=#ED2669]A vote for lotrocommunity is a vote for progress! Vote today![/COLOR][/B][/URL]

    [COLOR=#ff0000]Nimrodel's #1 Inandout reaver[/COLOR].
    [/CENTER]

  19. #144
    Registriert seit
    28.04.2008
    Ort
    SWTOR
    Beiträge
    1.691

    Re: Some Statistics

    Zitat Zitat von masontamason Beitrag anzeigen
    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
    Registriert seit
    13.04.2007
    Ort
    Brooklyn,NY
    Beiträge
    3.321

    Re: Some Statistics

    Zitat Zitat von OGsam Beitrag anzeigen
    I'd say no.. those people have long left LotRO.
    Yeah, pretty sure Erath is playing WoW with some Legends people atm.
    [FONT=Comic Sans MS][B][U]Dirtyblonde[/U] 65[/B] Burg (Nimrodel) | [U][B]Notblondie[/B][/U] (Nimrodel) | [U][B]Scratchs[/B][/U][/FONT] (Elendilmir)
    [OOC] ****** : 'except blondie, hes already GM smartass'
    [URL="http://www.youtube.com/watch?v=n7VAhzPcZ-s"]Blame the players.
    [/URL][url="http://www.battlefieldheroes.com/en/ref/2283770762"] Battlefield Heroes is really fun![/url]

  21. #146
    Registriert seit
    15.01.2011
    Beiträge
    18

    Re: Some Statistics

    Zitat Zitat von masontamason Beitrag anzeigen
    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".
    Geändert von VaporMadeMeDoIt (06.02.2011 um 23:32 Uhr)

  22. #147
    Registriert seit
    07.11.2007
    Ort
    USA
    Beiträge
    8.330

    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.
    There may come a time for valor without renown, for those without swords may surely still die upon them.


  23. #148
    Registriert seit
    18.03.2008
    Beiträge
    1.532

    Re: Some Statistics

    Zitat Zitat von BLoNdiE Beitrag anzeigen
    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.
    [center][charsig=http://lotrosigs.level3.turbine.com/0a20b0100000c71ae/signature.png]Starkiller[/charsig][/center]

  24. #149
    Registriert seit
    13.04.2007
    Ort
    Brooklyn,NY
    Beiträge
    3.321

    Re: Some Statistics

    Zitat Zitat von ellestone Beitrag anzeigen
    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.
    [FONT=Comic Sans MS][B][U]Dirtyblonde[/U] 65[/B] Burg (Nimrodel) | [U][B]Notblondie[/B][/U] (Nimrodel) | [U][B]Scratchs[/B][/U][/FONT] (Elendilmir)
    [OOC] ****** : 'except blondie, hes already GM smartass'
    [URL="http://www.youtube.com/watch?v=n7VAhzPcZ-s"]Blame the players.
    [/URL][url="http://www.battlefieldheroes.com/en/ref/2283770762"] Battlefield Heroes is really fun![/url]

  25. #150
    Registriert seit
    18.01.2008
    Ort
    city begins w/ H, state w/ T
    Beiträge
    334

    Re: Some Statistics

    Zitat Zitat von Erasmus354 Beitrag anzeigen
    Hey, this is pretty good...

    Except for this. I dont believe it one bit
    Geändert von myforumacc (20.07.2011 um 13:03 Uhr)

 

 
Seite 6 von 7 ErsteErste ... 2 3 4 5 6 7 LetzteLetzte

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •  

Diese Formular-Sitzung ist abgelaufen. Du musst die Seite neu laden.

Neu laden