July 23, 2018, 03:13:13 pm

Author Topic: Vicewar7 Statistics  (Read 1550 times)

0 Members and 1 Guest are viewing this topic.

SilenTKilleR

  • VW7 - The Night Wolves
  • Fanatic
  • *
  • Posts: 189
  • Country: pk
  • S!LenT_K!LL3R Style!
    • View Profile
    • Awards
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


S!LenT_K!LL3R's Art

aXXo

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • *
  • *
  • Posts: 2415
  • Country: in
    • View Profile
    • Awards
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: 2415
  • Country: in
    • View Profile
    • Awards
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: 4162
  • Country: 00
    • View Profile
    • Awards
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

  • VW7 - The Wolf Pack
  • Crazy Man
  • *
  • Posts: 1004
  • Country: tr
  • Love Kickstarts Again
    • View Profile
    • Miami Killers
    • Awards
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


VoLK

  • Vice War Staff
  • Crazy Man
  • *
  • *
  • Posts: 1679
  • Country: lt
  • the most interesting man in VCMP v2
    • View Profile
    • Vice Legends
    • Awards
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 Rookie
  • Crazy Man
  • *
  • *
  • *
  • Posts: 306
  • Country: in
    • View Profile
    • Awards
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

VoLK

  • Vice War Staff
  • Crazy Man
  • *
  • *
  • Posts: 1679
  • Country: lt
  • the most interesting man in VCMP v2
    • View Profile
    • Vice Legends
    • Awards
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: 1486
  • Country: pk
  • Hi.
    • View Profile
    • MaDKiLLeR's Site
    • Awards
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

  • VW7 - The Night Wolves
  • Crazy Man
  • *
  • Posts: 994
  • Country: pk
  • #renaissance
    • View Profile
    • Awards
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


|| TRC Captain | EC Moderator | EAD Admin | VL S. Admin | VCPD Captain | SWAT Commander | EC Ladder Runner-up | EC Team Brawl Winner||


MaDKilleR

  • Vice Underdog
  • Crazy Man
  • *
  • *
  • Posts: 1486
  • Country: pk
  • Hi.
    • View Profile
    • MaDKiLLeR's Site
    • Awards
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

  • VW7 - The Wolf Pack
  • Fanatic
  • *
  • Posts: 291
  • Country: eg
  • Always Kaizen
    • View Profile
    • Awards
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


FulToN_619

  • VW7 - The Night Wolves
  • Crazy Man
  • *
  • Posts: 448
  • Country: pk
  • Silence is a source of great strength.
    • View Profile
    • Awards
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


Fercho

  • Moderatorz0r
  • Crazy Man
  • *
  • *
  • *
  • *
  • Posts: 1463
  • Country: pa
    • View Profile
    • Awards
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

  • Vice War Staff
  • Crazy Man
  • *
  • *
  • Posts: 411
  • Country: pl
    • View Profile
    • Awards
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 1 (list)
Agree Disagree Funny Winner Pwnt Informative Friendly Useful Optimistic Artistic Late Brain Donor