UAN Statisitcs.

Discussion in 'Call of Duty 2' started by elmo, Feb 5, 2006.

  1. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    I'm sure many of you have found the link already for The new stats page. They are for all games starting Saturday night. These will be updated at least once per day by me or FabzZ or another [UAN] member.

    A few things to note:
    1) Score is not taken into consideration in the stats, only Kills. This means, that even though a flag return is worth 10 points, it wont add to your Kills. Add it to the things to see if it can be modded.

    2) Because of how COD2 runs, stats are not tracked by GUID or IP, only player name. If you switch names, case, color, symbols or even spacing; it will be recorded as a separate user. However, if you are a UAN member and provide me with the name you use, I will manually make the changes to the database, hopefully once per week.

    3) You can see that there is a "Skill" column listed with the stats. I would pay no attention to it for now, since the skill list has to be customized. It's an opinion based thing anyways. Basically, it figures out what weapon you killed your opponent with and determines the appropriate amount to add or even subtract from your "skill."

    4) I am still analyizing the stats from since COD2 was installed on the server, it's 78% done with over 3 MILLION entries to the database so far. Due to this large size and the humungus server load it would create for any of you to look at, it will not be available to you. I will instead make a post when It is finished of the "Top Tens" for each category: Kills, Deaths, Efficiency, Killing Streak, Death Streak, Kills per Death, kills per game, and Games played. Excluding Skill for now. UAN, let me know any names you've used other than the regular tags in the past months on the cod2 server so i can merge them. Otherwise, you could be left out of a "Top Ten" you should be in.

    5) We have yet to set a date for stats reset, but they will be reset at least once per month. Otherwise, this would create too much load on the game server and my server during the updates.
  2. Guttersnipe

    Guttersnipe M.I.A. Status CallMeMaybe?

    Messages:
    532
    Very Nice work guys!! Thanks, my next child will be named after you.
  3. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    Ladies and Gentlemen, the stats are now complete. 3.6 MILLION RECORDS.

    As promised, here is the "Top Ten" list for all games from the beggining of the COD2 server to a couple weeks ago:

    *NOTE: Again, UAN guys and a few of you 'Veterans' let me know if you played on different names a lot so i can merge the records for you.

    Stats will be updated over the next few days as names are merged.

    MOST GAMES PLAYED:
    1) Unknown Soldier - 1861
    2) WEAO - 967
    3) [UAN]elmo - 858
    4) Omni - 734
    5) .:pompeyo:. - 620
    6) <=NORMAN=> - 561
    7) [UAN]FaBzZ - 558
    8*) madcat - 540
    9) Fel!o - 528
    10) NicoM - 493


    MOST KILLS:
    1) WEAO - 31,848
    2) Unknown Soldier - 27,039
    3) [UAN]elmo - 20,536
    4) .:pompeyo:. - 18,685
    5) kink - 17,356
    6) Segmentation Fault - 13,878
    7) [UAN]FaBzZ - 13,820
    8*) FeL!o - 13,015
    9) omni - 12,733
    10) SS Hunk - 12,713

    Longest Killing Streak:
    1) Wollie - 41
    2) hopesfall - 36
    3) tatoyang - 34
    4) Street Crab - 33
    5) esa - 31
    6) 'MiTh' - 30
    7) 'MiTh' - 29
    8*) soma - 28
    9) embassador - 28
    10) xX00Xx - 28

    Longest Death Streak (without getting a kill):
    1) zippo - 54
    2) A33INC - 41
    3) Kamikaze_9n - 39
    4) Brandon - 37
    5) week end warrior - 35
    6) Docter Chris - 34
    7) Jerome the Kleptoman - 34
    8*) Nick - 31
    9) looser - 31
    10) arrowharris - 31
  4. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    My TODO list for the stats site. feel free to point out somethings that need to be done (within reason):

    I'll delete this post when it's done...

    -edit titles on pages to say 'UAN' inplace of 'VSP'
    -cannot mod ctf stats recording since COD2 doesn't even log it
    -add a 'Banned Players' page
    -remove the known cheaters from the stats list. Yes, we know who you are.
    -add 'Headshot' column?
    -mod in 'total hours played' per player?
    -redo skillset list to compensate for different weapons and kill locations

    -Other suggestions??
  5. Xp1der

    Xp1der M.I.A. Status CallMeMaybe?

    Messages:
    572
    the only way to track location shots, like headshots,
    is to enable hit logging (e.g. head, neck chest).
    I know the old command was g_loghits 1,
    and since the engine is almost identical,
    (except they renamed the formats)
    I'd wager the command is the same, or
    similar.

    X
  6. Guttersnipe

    Guttersnipe M.I.A. Status CallMeMaybe?

    Messages:
    532
    Do you think it would be a good idea to have member stats column? All I could think of. Looks gr8 already though.
  7. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    location is already recorded in the log. I was just looking to code in a headshot section. FabzZ handles the server side stuff and I mess with the stats stuff.

    here's an example of the log:

    Code:
    5:10 D;0;8;allies;TehZ;0;6;axis;Ass Issues;thompson_mp;35;MOD_PISTOL_BULLET;right_arm_lower
  8. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
  9. waffles

    waffles M.I.A. Status Staff Member Moderator

    Messages:
    2,589
    this stuff is amazing guys. more than any mod or map this has renewed my interest in cod2. hats off to you guys.

    if i think of any good ideas ill post them.
  10. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    Thanks waffles, glad you like.

    Ok, I'm going to spend a couple hours seeing what I can do, if anything. Then upload the changes.
  11. waffles

    waffles M.I.A. Status Staff Member Moderator

    Messages:
    2,589
    man im loving being the sole owner of "plane bomb" :D best score ive had in cod2. now im pullin for that 200 mark. as you can see it did a lot for the win...


    [​IMG]
  12. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    Nice waffles.

    I f anyone is on, could you check out my test stats site:

    http://www.watsonunited.com/~uan/vsp/pub/t...marck/index.php

    and tell me what you like better; Uan stats on the main page, or it's own separate page. Or if you don't like it, that's cool too.

    thanks,
    Elmo

    PS: those stats are NOT acccurate.
  13. waffles

    waffles M.I.A. Status Staff Member Moderator

    Messages:
    2,589
    ok the stats are supposed to clear after a given period correct? what about keeping the all time high score as a reference point. if it gets beat in that week (or whatever period) then it becomes the new record the following one.
  14. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    ok, that's an interesting thought. what determines 'High score' though? The 'Skill' column has some merit but I think it could be customized a little better.

    Or, take the top score in each area (most kills, kills per game, etc.) and list those each period? yea, i like that.

    Added it to the todo list, nice waffles.

    what about how the uan stats are shown? Keep it on main page or give it its own? PLus, I can remove that mini awards list too. "carnage" and "player" don't really mean anything to me as afar as the stats are concerned, and i have the script, haha.

    and to clarify: The period of time before the stats are reset is going to be based on how large the database gets and how fast. SOme servers reset once a month, some every 3 weeks, etc. What happens at the end of that time is the games_mp.log file will be deleted from the server and I will clear the database on my site, and boom, we start anew.
  15. waffles

    waffles M.I.A. Status Staff Member Moderator

    Messages:
    2,589
    its kinda nice to have the seperate page for us. makes it easier. i dont think its going to interest anyone besides those 14 people though/
  16. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    OK, main stats site has been updated with a link at the top, and a UAN members page. I've also removed that little mini awards box since it made no sense to me.
    Opinions?
    http://www.watsonunited.com/~uan/vsp2/pub/...marck/index.php

    In reference to Waffles idea about the 'Current Records' thing:
    I'm calling it a night since I'm pretty worn out, but I have some questions for you programmers;

    Here's the options I'm toying with in my head.
    1) Create a new table in the database that will either be updated via activating a script, or entering the player/record values into an admin page manually(look at the score, type it in a box along with player name).
    2) Create a function that reads the values of a file that is either edited directly or via script.
    3) Add script that will figure out who is closest to beating the record or who has beaten it. Kind of like haveing a "Current records" row and a "Current top scores" row, right next to each other. AKA "This [month/week]'s leaders"
    4) Just directly edit the main page and add html to display them. In which case, it would have to be edited eahc period before a DB flush.

    Basically, the way things are stored in the DB seem very unorganized to me, and creating script to try to read it seems like more unnecessary DB load. It's also important to keep in mind that the VSP tables will be flushed at the end of each period, so the 'records' have to be stored either in a different table or a file.

    I'm just really tired and I know the answer is right in front of me. well, maybe some one will have some ideas.

    Thanks Waffles, modding when there is a second opinion is Wayy better than doing it on your own. Your 'skill' rating from the previous 3 months stats was 2507 (second Place)
  17. Xp1der

    Xp1der M.I.A. Status CallMeMaybe?

    Messages:
    572
  18. darkhelmut

    darkhelmut M.I.A. Status CallMeMaybe?

    Messages:
    145
    It will interest more to join i think.And i agree with yuo waffles amazing work guys .
  19. waffles

    waffles M.I.A. Status Staff Member Moderator

    Messages:
    2,589
    sigs would be amazing if you could pull that somehow.
  20. elmo

    elmo M.I.A. Status CallMeMaybe?

    Messages:
    1,240
    Yes, that link was my main reference for things but I haven't seen anything like a 'records' mod. And cod2 doesn't record guid apparently, yet another thing that is supposed to be added with the patch. That's a cool looking sig tho Xpider, me likey. ANy particular reason why it coulldn't track via playername instead. The only thing I'd be worried about with having sigs; would there be a lot of server load with the database being searched everytime a UAN post is viewed?

    So, as far as the 'previous records' are concerned, that will have to be done manually I'm thinking, whether it's typing values into an admin page or running a script to check the DB right before it's cleared. The "current leaders" should be pretty strait forward.

    thanks