We have detected that cookies are not enabled on your browser. Please enable cookies to ensure the proper experience.
Page 6 of 7 FirstFirst ... 2 3 4 5 6 7 LastLast
Results 126 to 150 of 154

Thread: Some Statistics

  1. #126
    Join Date
    Apr 2007
    Posts
    1,598

    Re: Some Statistics

    Quote Originally Posted by kpfitzgerald View Post
    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.
    Last edited by Erasmus354; Apr 30 2009 at 05:29 PM.
    [charsig=http://lotrosigs.level3.turbine.com/0a20b0100000e869c/signature.png]Burnbabyburn[/charsig]
    Ninja

  2. #127
    Join Date
    Apr 2007
    Posts
    14

    Re: Some Statistics

    Nice to know.
    Last edited by Theobromine; May 01 2009 at 07:50 PM.
    [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
    Join Date
    Mar 2008
    Location
    Columbus OH
    Posts
    278

    Re: Some Statistics

    Quote Originally Posted by Erasmus354 View Post
    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.

    Quote Originally Posted by Erasmus354 View Post
    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
    Join Date
    Apr 2007
    Posts
    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
    Join Date
    Sep 2007
    Location
    Ur of the Chaldees
    Posts
    1,319

    Re: Some Statistics

    Quote Originally Posted by Erasmus354 View Post
    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
    [charsig=http://lotrosigs.level3.turbine.com/0a20b00000010a29e/signature.png]Gereshom[/charsig]

  6. #131

    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
    Join Date
    Apr 2007
    Posts
    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
    Join Date
    Jan 2008
    Posts
    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
    Join Date
    Apr 2007
    Location
    Peoria, IL
    Posts
    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
    Join Date
    Apr 2007
    Posts
    1,598

    Re: Some Statistics

    Quote Originally Posted by andulinde View Post
    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

    Re: Some Statistics

    Quote Originally Posted by operaoneyes View Post
    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
    Join Date
    May 2008
    Location
    Lugz Rez Cricle
    Posts
    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
    Join Date
    Apr 2007
    Location
    Brooklyn,NY
    Posts
    3,321

    Re: Some Statistics

    Quote Originally Posted by Dommin-Nim View Post
    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
    Join Date
    Jan 2008
    Location
    city begins w/ H, state w/ T
    Posts
    334

    Re: Some Statistics

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

  15. #140
    Join Date
    Aug 2007
    Location
    Kansas!
    Posts
    4,702

    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

    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

    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
    Join Date
    Oct 2008
    Location
    Japan
    Posts
    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://###################"]
    [/URL][URL="http://###################"][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
    Join Date
    Apr 2008
    Location
    SWTOR
    Posts
    1,691

    Re: Some Statistics

    Quote Originally Posted by masontamason View Post
    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
    Join Date
    Apr 2007
    Location
    Brooklyn,NY
    Posts
    3,321

    Re: Some Statistics

    Quote Originally Posted by OGsam View Post
    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
    Join Date
    Jan 2011
    Posts
    18

    Re: Some Statistics

    Quote Originally Posted by masontamason View Post
    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".
    Last edited by VaporMadeMeDoIt; Feb 06 2011 at 11:32 PM.

  22. #147
    Join Date
    Nov 2007
    Location
    USA
    Posts
    8,321

    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
    Join Date
    Mar 2008
    Posts
    1,532

    Re: Some Statistics

    Quote Originally Posted by BLoNdiE View Post
    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
    Join Date
    Apr 2007
    Location
    Brooklyn,NY
    Posts
    3,321

    Re: Some Statistics

    Quote Originally Posted by ellestone View Post
    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
    Join Date
    Jan 2008
    Location
    city begins w/ H, state w/ T
    Posts
    334

    Re: Some Statistics

    Quote Originally Posted by Erasmus354 View Post
    Hey, this is pretty good...

    Except for this. I dont believe it one bit
    Last edited by myforumacc; Jul 20 2011 at 01:03 PM.

 

 
Page 6 of 7 FirstFirst ... 2 3 4 5 6 7 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

This form's session has expired. You need to reload the page.

Reload