March 28, 2024, 10:40:53 pm

Author Topic: Vicewar7 Statistics  (Read 5242 times)

0 Members and 1 Guest are viewing this topic.

SilenTKilleR

  • Fanatic
  • ****
  • Posts: 280
  • Country: pk
  • 4everUF
    • View Profile
Re: Vicewar7 Statistics
« Reply #30 on: July 10, 2018, 08:01:30 pm »
Event was Great,My Ping was fucked up in vice war,got almost 15+ kicks lol
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


aXXo

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • *
  • *
  • *
  • *
  • Posts: 2722
  • Country: in
    • View Profile
Re: Vicewar7 Statistics
« Reply #31 on: July 10, 2018, 09:23:08 pm »
To be honest, since MadKiller is inactive, no-one is working on web stats anymore.
I do have the source code of VW6 webstats, which is coded in Python. If someone wants to develop the stats page PM me.

Till then, the best I can do is entertain absurd requests:  :-X

ADD TOP 10 VU SLAYERS   8)

Code: [Select]
SELECT u.nickname, COUNT(k.killer_uid) FROM users u
INNER JOIN kills k ON u.uid = k.killer_uid
WHERE k.killed_uid IN ( SELECT u1.uid FROM users u1 WHERE u1.nickname LIKE '%vu%' )
GROUP BY u.nickname
ORDER BY COUNT(k.killer_uid) DESC
Thank Tony for SQL queries


Wr*blix    364
=TRC=MarK.    361
[SS]krystianoo    244
[NAR]Gomiro    214
Floris    195
Kyle.    188
[EK]SiGNaL    182
Radon    143
[MD]Zkq    143
=EK=Maxpayne^    141
[SS]Freak    135
[MDr]ReX_The_GreaT    116
=TRC=sevrin    115
MKt.Fi77_H0LD3R    110
[TpS]DiegoZ    109
[EAF]Affanster    104
Weldone_905    103
=F2=KilleR_FrosT    101
[SS]Bhai    100
[SS]Lederhos    96
iNs.Force    96
=TRC=Zeeshan.    95
UFr.luchgox    94
[MD]Mechanic    92
[SS]Stealth    90
Funny Funny x 8 Winner Winner x 1 Friendly Friendly x 2 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


aXXo

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • *
  • *
  • *
  • *
  • Posts: 2722
  • Country: in
    • View Profile
Re: Vicewar7 Statistics
« Reply #32 on: July 10, 2018, 11:53:56 pm »


Agree Agree x 2 Useful Useful x 1 Artistic Artistic x 2 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


Charley

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • Posts: 4749
  • Country: 00
    • View Profile
Re: Vicewar7 Statistics
« Reply #33 on: July 11, 2018, 05:06:49 am »
Can we get total playtime by gang?
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

Writer of excessively long posts


Kelvin

  • Crazy Man
  • *****
  • Posts: 1029
  • Country: tr
    • View Profile
    • Miami Killers
Re: Vicewar7 Statistics
« Reply #34 on: July 11, 2018, 06:38:17 am »
  • Top 10 Stubby Killers


Wasnt even there in the last 10 hours but still finished on the top of this. So,i count this as an achievement.
Funny Funny x 1 Winner Winner x 3 Pwnt Pwnt x 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


morphine

  • Crazy Man
  • *****
  • Posts: 1908
  • Country: lt
    • View Profile
Re: Vicewar7 Statistics
« Reply #35 on: July 11, 2018, 06:55:51 am »
Can we get total playtime by gang?

don't even bother

Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


Luckshya

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • *
  • Posts: 377
  • Country: in
    • View Profile
Re: Vicewar7 Statistics
« Reply #36 on: July 11, 2018, 06:59:16 am »
Can we get total playtime by gang?

don't even bother


Your playtime was fixed as we had two ways to calculate playtime.
It is now 2521 seconds.
Funny Funny x 1 Pwnt Pwnt x 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


Credits to Pumak47

morphine

  • Crazy Man
  • *****
  • Posts: 1908
  • Country: lt
    • View Profile
Re: Vicewar7 Statistics
« Reply #37 on: July 11, 2018, 07:05:09 am »
ok you don't have to fucking kill the joke like that wtf

Agree Agree x 3 Funny Funny x 10 Pwnt Pwnt x 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


MaDKilleR

  • Vice Underdog
  • Crazy Man
  • *
  • Posts: 1517
  • Country: ca
  • Hi.
    • View Profile
    • MaDKiLLeR's Site
Re: Vicewar7 Statistics
« Reply #38 on: July 11, 2018, 07:50:13 am »
To be honest, since MadKiller is inactive, no-one is working on web stats anymore.

Hi sweetie  :-*
Winner Winner x 6 Friendly Friendly x 7 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

- [VU]MaDKiLLeR

Sevrin

  • Crazy Man
  • *****
  • Posts: 1315
  • Country: pk
  • Peace please
    • View Profile
Re: Vicewar7 Statistics
« Reply #39 on: July 11, 2018, 11:31:06 am »
To be honest, since MadKiller is inactive, no-one is working on web stats anymore.

Hi sweetie  :-*
yo biach, when rocket in game?
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor



Question to Stormeus: Where is TRC forums? We didn't even had a proper farewell because of you. :( :( :(

MaDKilleR

  • Vice Underdog
  • Crazy Man
  • *
  • Posts: 1517
  • Country: ca
  • Hi.
    • View Profile
    • MaDKiLLeR's Site
Re: Vicewar7 Statistics
« Reply #40 on: July 11, 2018, 02:08:32 pm »
To be honest, since MadKiller is inactive, no-one is working on web stats anymore.

Hi sweetie  :-*
yo biach, when rocket in game?

Any time of your choice ;)
Funny Funny x 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

- [VU]MaDKiLLeR

OmaRosh

  • Vice Underdog
  • Crazy Man
  • *
  • Posts: 553
  • Country: eg
  • Always Kaizen
    • View Profile
Re: Vicewar7 Statistics
« Reply #41 on: July 11, 2018, 07:19:48 pm »
Welcome back boiiiiiiiiiiiii :D
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

"Never fight close to omarosh..."

FulToN_619

  • Crazy Man
  • *****
  • Posts: 719
  • Country: pk
  • Give Respect Get Respect
    • View Profile
Re: Vicewar7 Statistics
« Reply #42 on: July 11, 2018, 07:30:35 pm »
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

fulton (the hardest lagger on vcmp, I can't touch him)

Fercho

  • Moderatorz0r
  • Crazy Man
  • *
  • *
  • *
  • Posts: 1717
  • Country: pa
    • View Profile
Re: Vicewar7 Statistics
« Reply #43 on: July 12, 2018, 05:44:30 am »
Wasnt even there in the last 10 hours but still finished on the top of this. So,i count this as an achievement.

I do admire you.
You still believe in stubby even when there's a pump epidemy around vcmp nowadays. I'm like, well, there's only one way to fight these glitchers; and it's to become one of them lol
Agree Agree x 1 Optimistic Optimistic x 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor


Piterus

  • Crazy Man
  • *****
  • Posts: 607
  • Country: pl
    • View Profile
Re: Vicewar7 Statistics
« Reply #44 on: July 12, 2018, 08:00:13 am »

Wasnt even there in the last 10 hours but still finished on the top of this. So,i count this as an achievement.

I do admire you.
You still believe in stubby even when there's a pump epidemy around vcmp nowadays. I'm like, well, there's only one way to fight these glitchers; and it's to become one of them lol

Stubby > Pump Shotgun

And yea, I'm also happy because top stubby - 2nd place in Wolf Pack, and close to best 3 generally :p
Agree Agree x 2 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor

VC:MP since 2012, LU-DM Team Owner, some other things also in the past.