Members of the Forum!

A place to discuss anything not related to the game.
User avatar
Antison
VIP
Posts: 2902
Joined: Mon Mar 28, 2011 11:33 pm
android_version: 7.0
Location: It's a beagle's world. We're just living in it.

Re: Members of the Forum!

Post by Antison » Wed Oct 10, 2012 11:31 pm

I am just curious, Scott could you write a query to find the court of all members active within the 30 days?
It's a pretty simple SQL query.

Code: Select all

Lv  AP   HP  AC  AD    BC DR CHS CM ECC
134 3/12 215 285 65-75 201 9
58  4/14 131 241 30-43 186 3
52  3/12 150 261 33-42 81  4 59  3.0 29
52  4/12 163 334 30-47 77  3
49  3/12 99  347 40-46 171 1
49  6/12 131 263 35-80 107 3
48  2/12 121 267 34-43 103 5

sdevaney
Site Admin
Posts: 1051
Joined: Fri Jan 28, 2011 10:17 pm
android_version: 4.4
Contact:

Re: Members of the Forum!

Post by sdevaney » Thu Oct 11, 2012 12:22 am

tek wrote:I am just curious, Scott could you write a query to find the court of all members active within the 30 days?
It's a pretty simple SQL query.
Indeed.
168 users active within the last 30 days.
411 users active within the last 60 days.
679 users active within the last 90 days.

User avatar
Antison
VIP
Posts: 2902
Joined: Mon Mar 28, 2011 11:33 pm
android_version: 7.0
Location: It's a beagle's world. We're just living in it.

Re: Members of the Forum!

Post by Antison » Thu Oct 11, 2012 12:27 am

sdevaney wrote:
tek wrote:I am just curious, Scott could you write a query to find the court of all members active within the 30 days?
It's a pretty simple SQL query.
Indeed.
168 users active within the last 30 days.
411 users active within the last 60 days.
679 users active within the last 90 days.
Thanks.

Those numbers are a lot lower than I was anticipating. I would have guessed closer to 300 within the last 30 days.

Code: Select all

Lv  AP   HP  AC  AD    BC DR CHS CM ECC
134 3/12 215 285 65-75 201 9
58  4/14 131 241 30-43 186 3
52  3/12 150 261 33-42 81  4 59  3.0 29
52  4/12 163 334 30-47 77  3
49  3/12 99  347 40-46 171 1
49  6/12 131 263 35-80 107 3
48  2/12 121 267 34-43 103 5

sdevaney
Site Admin
Posts: 1051
Joined: Fri Jan 28, 2011 10:17 pm
android_version: 4.4
Contact:

Re: Members of the Forum!

Post by sdevaney » Thu Oct 11, 2012 2:07 am

tek wrote:
sdevaney wrote:
tek wrote:I am just curious, Scott could you write a query to find the court of all members active within the 30 days?
It's a pretty simple SQL query.
Indeed.
168 users active within the last 30 days.
411 users active within the last 60 days.
679 users active within the last 90 days.
Thanks.

Those numbers are a lot lower than I was anticipating. I would have guessed closer to 300 within the last 30 days.
I was pleasantly surprised in all honesty. Considering 99% of content on the forums is available without registering. We also have about 5k unique (ip) users a month total.

User avatar
nyktos
Posts: 3384
Joined: Wed Sep 14, 2011 5:38 pm
android_version: 7.1
Location: Nor City
Contact:

Re: Members of the Forum!

Post by nyktos » Thu Oct 11, 2012 2:19 am

yeah, i was happy to see that too...
i mean, they keep coming back & there isn't a constant flow of updates or anything for them to be asking about.

and the part about 5K different IP's hitting us up?
over used word, but that's kinda "epic"

:lol:
"Embrace the Shadow"

Image

[Lv: 60] [HP: 175] [AC: 361] [AD: 25-39] [BC: 75]
[Dual Wielding Swords] [Unarmored Fighting]

User avatar
Pyrizzle
Posts: 6436
Joined: Sat Jun 25, 2011 1:00 am
android_version: 6.0
Location: Fire Nation HQ

Re: Members of the Forum!

Post by Pyrizzle » Fri Oct 12, 2012 8:01 am

sdevaney wrote:
tek wrote:I am just curious, Scott could you write a query to find the court of all members active within the 30 days?
It's a pretty simple SQL query.
Indeed.
168 users active within the last 30 days.
411 users active within the last 60 days.
679 users active within the last 90 days.
Interesting stats!!

Thanks for posting this Scott!
---------------------------------------------------------------------------------------

Player Name:Pyro
Lvl:24XP:244KAP:2/10HP:80AC: 189%AD:13-21CHS:-6CM: 0BC: 20%DR:2
IF:2Reg:2FSDW:1

May Elythara bless you and light your path!

---------------------------------------------------------------------------------------

User avatar
ace
Posts: 482
Joined: Sat Jun 21, 2014 4:00 am
android_version: 5.1
Location: lodar's hideout

Re: Members of the Forum!

Post by ace » Fri Jul 11, 2014 3:32 pm

now the forum got 2546 members. that is quite big.
the secrets of shadow and light#ace.
https://facebook.com/andorstrail
be happy :lol:

User avatar
ace
Posts: 482
Joined: Sat Jun 21, 2014 4:00 am
android_version: 5.1
Location: lodar's hideout

Re: Members of the Forum!

Post by ace » Sat Aug 29, 2015 6:47 pm

so guys we now have a group of 3000 members. yay its a big achievement for Andor's Trail and the peoples who loves it.
the secrets of shadow and light#ace.
https://facebook.com/andorstrail
be happy :lol:

User avatar
Lady Drager
Posts: 516
Joined: Thu Dec 01, 2016 11:13 pm
android_version: 6.0
Location: Watch out Batsy! I'm commin' for ya!

Re: Members of the Forum!

Post by Lady Drager » Sun Apr 09, 2017 8:19 pm

Since this thread hasn't been updated in a while:
We are currently at 3760 members. Can we get another query?
Name: Lady Drager
ATT: Aims below the belt often
DEF: "Thanks Puddin' :D "
SPD: Don't do the stuff, weed's another story...
INT: Often underestimated... to my advantage!
Boobs: used only as a distraction... ;)
CHA: * See 'Boobs' *

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest