forums.rs

Forums

Old School RuneScape Anyone?

Quick find code: 294-295-158-64458191

of 1746
Xyzdrache

Xyzdrache

Posts: 245 Silver Posts by user Forum Profile RuneMetrics Profile
Mod Mmg:
"To clear up any confusion on this matter I want to confirm that our Unique Active Player stats for the proceeding 14 Days from Monday the 11th Feb was actually 8,229,459!"

How is it possible that more than 8Million members were online within 2weeks ?
There are only 1,66Million members in the highscores and 75%+ of them are bots...

Jagex logic 1. German Trimmed Comp Cape Pre EOC
1. German Maxed OSRS Account

20-Feb-2013 14:14:55

AgTiger

AgTiger

Posts: 620 Steel Posts by user Forum Profile RuneMetrics Profile
Xyzdrache asks:

"How is it possible that more than 8Million members were online within 2weeks ?
There are only 1,66Million members in the highscores and 75%+ of them are bots..."

'Unique Active Player stats' probably doesn't imply "Paid account", it probably includes free-to-play accounts as well. At least, that's what I'm guessing based on the vagueness in MMG's statement.

Further, I don't know what MMG means (exactly) by "active player". You could infer that it means a player signing into the game, but you could just as easily infer that it includes players who sign into the forums but who don't sign into the game anymore. (Posting is 'being active', right?)

For example, ginning up some SQL here against a theoretical transaction table in a database that tracks activity, including logins, logouts, and other things, as well as whether a player is logging into the game, and whether they're a member:

There should be be a big difference between a count of unique logins between Jan 29, and Feb 11 inclusive:

SELECT COUNT(DISTINCT PLAYER_ID) FROM PLAYER_ACTIVITY WHERE (ACTIVITY_TYPE = 'LOGIN') AND (LOGIN_DATE) >= 20130129) AND (LOGIN_DATE <= 20130211)

and a count of unique logins, that are members, that are logging into the game, between Jan 29, and Feb 11 inclusive:

SELECT COUNT(DISTINCT PLAYER_ID) FROM PLAYER_ACTIVITY WHERE (ACTIVITY_TYPE = 'LOGIN') AND (MEMBER='Y') AND (LOGIN_TO_GAME='Y') AND (LOGIN_DATE >= 20130129) AND (LOGIN_DATE <= 20130211)

Ugh. I've been supporting database products at work too long. I'm starting to think in SQL. :-)

20-Feb-2013 14:51:48 - Last edited on 20-Feb-2013 14:53:03 by AgTiger

Avioxus

Avioxus

Posts: 1,350 Mithril Posts by user Forum Profile RuneMetrics Profile
replace the EoC with 2007scape pl0x


I need a mods help immediatly I found a really large bug when i logged into runescape today..my dragon claws were in two peices and they didn't have a special attack..in fact i couldn't find my spec bar anywhere.They also had this big bar in the way of part of my screen, it had all kinds of differnet attacks on it i then, immediatly closed the client to make sure i hadn't loaded w.o.w by a mistake i logged back in and realised my ags didn't have a spec either can someone help me report this to jagex its a really big problem.

20-Feb-2013 14:54:12 - Last edited on 20-Feb-2013 14:54:47 by Avioxus

white arabe
Mar Member 2020

white arabe

Posts: 188 Iron Posts by user Forum Profile RuneMetrics Profile
Bro it aint a bug, thats the new combat evolution bull **** it sucks @xoF lamirP :| [link url= ][/link][spoiler][qfc id=][/qfc][/spoiler] I am being followed by bots and there willing to take me account.
peballicous I dunnu

20-Feb-2013 16:23:13 - Last edited on 20-Feb-2013 16:23:39 by white arabe

Farmchore
Feb Member 2023

Farmchore

Posts: 340 Silver Posts by user Forum Profile RuneMetrics Profile
My FriendsChat is Open for anyone who has any questions about 2007, I played a long way back and have a lot of knowledge of what it was like, so if you're newer than 2007 and want to learn about the old days, just hop in also add me if you like.

If you did play back then, be sure to join and share your stories with us!

- Stinkhorn

20-Feb-2013 16:24:00

Quick find code: 294-295-158-64458191 Back to Top