Dark Clan Forum

Unreal Tournament 3 => Dark Clan & Unreal Tournament 3 => Topic started by: WGH on Fri 22.05.2009 15:10:32



Title: UT3 Statistics at beyondunreal.com
Post by: WGH on Fri 22.05.2009 15:10:32
Sova suggested me to introduce my site here, so:

http://ut3stats.beyondunreal.com/ (http://ut3stats.beyondunreal.com/)

It looks very simple, but there are some cool features that others sites don't have like pie charts showing weapon usage, advanced SQL-like search, combining of Custom and Pure stats, etc.


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Fri 22.05.2009 15:39:23
Nice idea, but is it possible that there are some issues at the moment? It won't work for me to look up nicknames with FFox and Opera.

Edit: Ok, suddenly it works now - nice

Edit:
BIG LOL to the metatags: content="ut3, ut3stats, ut3 stats, unreal tournament 3,
statistics, beyondunreal, wgh, ut3pc,
gamespy, gayspy"

Edit:
And it goes on with the time taken to display the results:
"<!-- Gamespy gayness level is 5.2119619846344 seconds -->" haha, nice easteregg feature ^^


Title: Re: UT3 Statistics at beyondunreal.com
Post by: aka_sova on Fri 22.05.2009 15:42:53
Yea, you can do a lot of things there. Like this one  Crazysmile1

(http://i43.tinypic.com/2m3g408.jpg)


Title: Re: UT3 Statistics at beyondunreal.com
Post by: WGH on Fri 22.05.2009 15:43:40
Yes, it was my mistake. I'm doing some code cleaning and refactiong these days, also adding new minor features.


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Fri 22.05.2009 15:51:46
I really like the charts, they even sort the kills/deaths ascending. You can see anyones fav weapons.  ;D

Small question regarding the hosting of this stats:
You need the stats application to log in on gamespy with your UT3 account, right? Can you play at the same time without getting a double login, if you use the same account to play?

Do you need a net/mono server to run the stats query? That would make it impossible to offer such live-stats also on the _Dark_ clan homepage.  :'(

Greets, VegasKill


Title: Re: UT3 Statistics at beyondunreal.com
Post by: WGH on Fri 22.05.2009 16:07:18
Actually, you need to login only once, and use received ticket for indefinite time unless you logout explicitly. Funny thing is you can get as many tickets as you want using the same login/password pair.
You can use UT3 account to get that ticket, you can use general gamespyid account, and probably an account from any other game namespace. To get that ticket I used general account, but I believe you won't get any duplicate logins once you get the ticket using UT3 account.
You don't need to use that Apophis' thing, you can rewrite it easily. It's just SOAP (http://en.wikipedia.org/wiki/SOAP) over HTTP, I'm using PHP compiled with cURL for it.
to get ticket you need to connect directly using TCP, but as stated above it's one time thing

http://sake.gamespy.com/SakeStorageServer/StorageServer.asmx?op=SearchForRecords (http://sake.gamespy.com/SakeStorageServer/StorageServer.asmx?op=SearchForRecords)
try to sniff UT3 packets with something like wireshark to get the idea
also you could look at Apophis' sources, but they pretty strange sometimes :)
alternatively I could provide you with code snippets too


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Fri 22.05.2009 16:20:30
Nice, I doubt that _Dark_ really needs public stats on the homepage tough.
It would be nice to get live stats for just the clanmembers, with such nice charts for the weapon kills and vehicles. ^^
I guess its too much work for me to realize this. Its better to look up the stats on your site instead.
Its going to get a great service you offer there!  smiley_clap.gif
Greets


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Fri 22.05.2009 16:58:19
You don't need to use that Apophis' thing, you can rewrite it easily. It's just SOAP (http://en.wikipedia.org/wiki/SOAP) over HTTP, I'm using PHP compiled with cURL for it.
to get ticket you need to connect directly using TCP, but as stated above it's one time thing

Wow it sounds so cool when you talk to aliens  xxxlaugh.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Fri 22.05.2009 18:01:10
I can get the stats on my desktop with a ticket and log the results. The commands are to weird... and its all far, far away from an online working solution. I think I'll leave the developing to profis.  ^-^


Title: Re: UT3 Statistics at beyondunreal.com
Post by: WGH on Fri 22.05.2009 21:02:02
The only command you will ever need is SearchForRecords. And maybe GetRecordCount. Other commands are either unavailable (of course you can't insert your own data in the table) or pointless (GetRecordLimit, GetRandomRecords)


Title: Re: UT3 Statistics at beyondunreal.com
Post by: sikeferenc on Mon 25.05.2009 13:06:26
Nice work! Bad to see my combined stats... im an UT3 addict: http://ut3stats.beyondunreal.com/player114119178/?combined (http://ut3stats.beyondunreal.com/player114119178/?combined) msn001.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: m4rt1ni on Mon 25.05.2009 14:08:09
Nice work! Bad to see my combined stats... im an UT3 addict: http://ut3stats.beyondunreal.com/player114119178/?combined (http://ut3stats.beyondunreal.com/player114119178/?combined) msn001.gif
Holy crap sike!  xxxw00t.gif that's a LOT of kills. Strange that we almost never meet in-game lately. What are you playing these days, TDM & BTA mostly?


Title: Re: UT3 Statistics at beyondunreal.com
Post by: aka_sova on Mon 25.05.2009 14:53:05
Nice work! Bad to see my combined stats... im an UT3 addict: http://ut3stats.beyondunreal.com/player114119178/?combined (http://ut3stats.beyondunreal.com/player114119178/?combined) msn001.gif
Games played - 6159  xxxw00t.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Mon 25.05.2009 15:14:37
http://ut3stats.beyondunreal.com/player128808153/?combined (http://ut3stats.beyondunreal.com/player128808153/?combined)

Errm yeah^^



Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Mon 25.05.2009 16:33:27
most used weapon: sniper
 Sniper smiley.gif fsniper.gif
http://ut3stats.beyondunreal.com/player181957373/weapons (http://ut3stats.beyondunreal.com/player181957373/weapons)


Title: Re: UT3 Statistics at beyondunreal.com
Post by: darkredfox on Mon 25.05.2009 17:39:13
BUT: U didn't make a suicide only one time with ur favorite weapon! flopped?  ;D


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Mon 25.05.2009 17:41:22
BUT: U didn't make a suicide only one time with ur favorite weapon! flopped?  ;D

whats my favourite weapon?


Title: Re: UT3 Statistics at beyondunreal.com
Post by: sikeferenc on Tue 26.05.2009 07:56:44
Quote
Holy crap sike!  xxxw00t.gif that's a LOT of kills. Strange that we almost never meet in-game lately. What are you playing these days, TDM & BTA mostly?

I hate BTA ... well im playing TDM mostly and sometimes VCTF for fun. ATM im learning custom maps like Gritt, Flustered, TempestX etc.. we'd like to join into the TDM ladder after some months.


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Tue 26.05.2009 09:34:42
WGH published his awesome UT3 stats script and sent me a link. I'm gonna give it a look when I've got time spare, thanks WGH!  wink2.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: darkredfox on Mon 08.06.2009 11:30:42
BUT: U didn't make a suicide only one time with ur favorite weapon! flopped?  ;D

whats my favourite weapon?

Sniper? :D


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Mon 08.06.2009 12:29:24
i didnt make a suicide with it  msn002.gif
BUT: U didn't make a suicide only one time with ur favorite weapon! flopped?  ;D


Title: Re: UT3 Statistics at beyondunreal.com
Post by: darkredfox on Mon 08.06.2009 15:48:11
Bad, bad aiming, friend!  ;D


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Mon 08.06.2009 15:54:35
Bad, bad aiming, friend!  ;D

lol wtf foxxie xD


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Chrisaw2008 on Tue 09.06.2009 08:30:54
its a real shame dark_slash left ut3... he was the best sniper in my opinion

even you guys were impressed with him at our R3gul4rs vs _Dark_ match :P


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Tue 09.06.2009 09:22:01
dunno him. for the only real vctf sniper i know is vcrabo


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Chrisaw2008 on Tue 09.06.2009 09:49:35
lol vcrabo isnt even good in my opinion...

bloody.bender knows dark_slash i think... rarely missed your head anyways... he got bored of ut3 tough :(


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Tue 09.06.2009 11:19:39
Yeah this guy was insane  msn008.gif

You always had to fear to get shot in suspense  msn012.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: darkredfox on Tue 09.06.2009 12:47:34
vcrabo is the human aimbot! You jerk by hearing a sniper shot even if you are in cover. And if this pic was a rl-pic he has a thug-mug. ;D Won't play suckspense with him on a tower...


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Tue 09.06.2009 13:32:56
Atomrolf is the one and only sniper I know deserving the title "crazy sniper".  Sniper smiley.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: PainSavour on Tue 09.06.2009 13:56:11
I haven't seen dark_slash or Atomrolf sniping so I don't know how good they are, but if vcrabo isn't a good sniper then 99% of UT3 players utterly suck at sniping. I played a couple susp matches last week where I tried to snipe vcrabo, and my kd ratio against him was maybe 0.1.  xxxras.gif Then again sniper rifle is my worst weapon, I actually have a <1 kd ratio with it.  Crazysmile1



Title: Re: UT3 Statistics at beyondunreal.com
Post by: Thigor on Tue 09.06.2009 14:11:57
I haven't seen dark_slash or Atomrolf sniping so I don't know how good they are, but if vcrabo isn't a good sniper then 99% of UT3 players utterly suck at sniping. I played a couple susp matches last week where I tried to snipe vcrabo, and my kd ratio against him was maybe 0.1.  xxxras.gif Then again sniper rifle is my worst weapon, I actually have a <1 kd ratio with it.  Crazysmile1



Yea you were sniping with me on suspense in a match a few days ago

I got head hunter in 23 points that game  msn002.gif

I never really noticed slash as a great sniper (as I never really played much suspense only, even then I tried to avoid sniper line of fire) but going by his stats he must have been great

(http://i227.photobucket.com/albums/dd271/Solar_Silv/darkslashstats.jpg)

Something like 300+ head hunters or so


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Tue 09.06.2009 14:58:07
I dont have this Diagram on the right side  neutral1


Title: Re: UT3 Statistics at beyondunreal.com
Post by: aka_sova on Tue 09.06.2009 15:32:26
I dont have this Diagram on the right side  neutral1
press on "Kills".


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Chrisaw2008 on Wed 10.06.2009 08:40:14
lol how did you guys not notice him :O... if you ever play with vcrabo alot then you will see he should be better than he is.. he will only get u when your hoverboarding and to do so will stand still like a noob... iv headshot him quite a few times ecause hes stood still :S... plus he misses to much lol

dark_slash's stats speak for themselves... nearly 8kpd, shit loads of headshots and many kills with sniper... awesome :D... he also sniped in necro

good in DM too.. not just a sniper... in the TDM r3gul3rs vs Dark he was 1 of the top scorers... again shame he left :(


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Wed 10.06.2009 10:09:29
lol how did you guys not notice him :O...

ffs
we dont play the whole time suckpenis-only servers.

never.

and if we do it... maybe 2 times a week then it dont has to be that slash is also there.

and no i didnt notice him . not in the clanwar and not on publics. how should i? we didnt even move our ass in the suspense clanwar vs regulars and you were camping too so we didnt need to.


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Wed 10.06.2009 10:11:47
Its really a pitty that he stopped playing UT. 73% of his kills were Sniper kills =O. He made 56000 Kills and died only 8000 times  msn008.gif

Edit: He was 45h in the SPMA? OMG!!!!!


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Chrisaw2008 on Wed 10.06.2009 10:56:22
splitter why do u have to be like that.. im just saying hes a good sniper :S... suspense only or not he was the best sniper in UT3 :D

he sniped on necro too... and when we played r3gul4rs vs _dark_... you werent even in darks clan splitter so ur obviously not going to see him in the clan match.. LOL

and ye bender he had most camera crushes.. was really annoying when he crushed u when u had flag lol..


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Splitter on Wed 10.06.2009 11:05:01
no but my clan i was in before played against regulars and he played too.

and bullshit. maybe you think he was the best sniper in vctf but i know 3-5 guys who have the best ut3 aim and these guys u ve never seen cause they play only pickup games on password servers and no publics or not many. esp never vctf.


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Chrisaw2008 on Wed 10.06.2009 11:39:50
ok sorry i meant best sniper in vCTF :D


Title: Re: UT3 Statistics at beyondunreal.com
Post by: VegasKill on Wed 10.06.2009 18:47:38
With some lessions in PHP the stats by WGH may be attractive for our member site on our homepage.

Code:
<?php   $ownerids = array(
  131427252#sova
  117551835#Atomrolf
  128808153#Bloody.Bender
  116815284#DarklyBishop
  168253810#Darkredfoxxx
  120954274#Mordsspass
  123647314#Motz
  117117832#Radarfox
  181957373#Splitter
  131061970#VegasKill
  114124500#Wojci
   
);
?>

...results in:

array(11) {
  [0]=>
  array(3) {
    [0]=>
    string(13) "Bloody.Bender"
    [1]=>
    string(5) "44365"
    [2]=>
    string(3) "498"
  }
  [3]=>
  array(3) {
    [0]=>
    string(5) "Wojci"
    [1]=>
    string(5) "75034"
    [2]=>
    string(3) "657"
  }
  ...and so on, where the result for the 1st line is the name, 2nd the public server kills, 3rd the public ELO rating.

Thx WHG, you're a genious in programming!  wink2.gif


Title: Re: UT3 Statistics at beyondunreal.com
Post by: Bloody.Bender on Wed 10.06.2009 19:09:13
WGH you are 16 or something like that right? Annihilator said that 1 time. Thats so fuckin amazing man...


But I still dont get how that looks when its finished^^


Title: Re: UT3 Statistics at beyondunreal.com
Post by: aka_sova on Wed 10.06.2009 21:28:15
WGH will barely answer you, cuz he's in his summer cottage now till August. (no good internet in there).


Title: Re: UT3 Statistics at beyondunreal.com
Post by: WGH on Fri 04.09.2009 12:50:21
WGH you are 16 or something like that right? Annihilator said that 1 time. Thats so fuckin amazing man...


But I still dont get how that looks when its finished^^
I'm back. Yes, I'm really 16, I just take a great interest in all that stuff, that's all.