Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 473 posts ]  Go to page Previous  1 ... 6, 7, 8, 9, 10
Author Message
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:32 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12240
I want Grim... to implement some kind of API so I can scrape the database and do graphs of people who were most active each month, or who talked about PCs the most over time, or who had the longest gaps between consecutive posts, things like that. It would be the awesome.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:34 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
Be more specific, and I'll see what I can do.

Things about post contents (ie. "talking about PCs") are unlikely to happen though, because of the large amount of data involved.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:38 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55715
Location: California
Grim... wrote:
Be more specific, and I'll see what I can do.

Things about post contents (ie. "talking about PCs") are unlikely to happen though, because of the large amount of data involved.

That's loser talk. Up your game.

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:40 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
The most important part of requirements gathering is the ability to reject bad requirements.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:42 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55715
Location: California
Cras wrote:
The most important part of requirements gathering is the ability to reject bad requirements.

You're a bad requirement

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:42 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12240
I'm a typical user. I don't know what I want until you give me the wrong thing.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:47 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
Well, let's start with this:

Code:
http://www.beexcellenttoeachother.com/forum/api.php?f=

`f` can be one of `uid`, `userdeets` and `idandname`.

That's enough for you to use Beex as a login authenticator for other websites. I mean, I wouldn't recommend it, but that's how the calendar, MeatUp and Peex websites work.

So I guess the question is - what other data do you need to get your graphs?

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:47 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
I want inline code styling :(

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:57 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12240
Grim... wrote:
Well, let's start with this:

Code:
http://www.beexcellenttoeachother.com/forum/api.php?f=

`f` can be one of `uid`, `userdeets` and `idandname`.

That's enough for you to use Beex as a login authenticator for other websites. I mean, I wouldn't recommend it, but that's how the calendar, MeatUp and Peex websites work.

So I guess the question is - what other data do you need to get your graphs?

Heh, nice one.

I suppose for getting graphs it's more like running queries against the database, such as
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where LastVisitedDate > @Date ORDER BY PostCount DESC
or
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where PostDate BETWEEN @DateStart AND @DateEnd ORDER BY PostCount DESC
or
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where PostContent LIKE '%' + @Keyword + '%' ORDER BY PostCount DESC
that kind of thing, and then I'd come up with queries depending on what whims I had, like posts as a percentage of totals or compared to other posters and things like that.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:03 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:03 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55715
Location: California
No inner joins there, very disappointing.

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:04 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)


Who needs an API? Just have a text box on a page with ENTER YOUR SQL HERE AND I'LL RUN IT FOR YOU:

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:07 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
Why stop there? I could just exec some PHP, that way you can open up the server with `shell_exec()`.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:08 
User avatar
Comfortably Dumb

Joined: 30th Mar, 2008
Posts: 12034
Location: Sunny Stoke
Joans wrote:
I need to up my game.

And post more.


I wasn't expecting to be where I was in the chart after not posting for three years. I guess it shows how little work I've done in the past. :)

_________________
Consolemad | Under Logic
Curse, the day is long
Realise you don't belong


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:22 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12240
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

Well that depends on how well written the API is:

Surely you'd just expose a service and let me pass in a parameter to that service, and then return JSON or XML though, not let me pass in my own SQL.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:24 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69502
Location: Your Mum
Mr Russell wrote:
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

Well that depends on how well written the API is

I think you'd have to consider the quality of the API to be quite high on a scale of "zero" to "oh my holy fuck what were you doing" to allow entire queries to be run.

Mr Russell wrote:
Surely you'd just expose a service and let me pass in a parameter to that service, and then return JSON or XML though, not let me pass in my own SQL.

Well, yes.

:boots:

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:46 
SupaMod
User avatar
"Praisebot"

Joined: 30th Mar, 2008
Posts: 17013
Location: Parts unknown
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:49 
User avatar
Sleepyhead

Joined: 30th Mar, 2008
Posts: 27343
Location: Kidbrooke
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.

_________________
We are young despite the years
We are concern
We are hope, despite the times


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:55 
User avatar
Hibernating Druid

Joined: 27th Mar, 2008
Posts: 49106
Location: Standing on your mother's Porsche
There used to be loads more pictures of DocG.

_________________
SD&DG Illustrated! Behance Bleep Bloop

'Not without talent but dragged down by bass turgidity'


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 15:36 
User avatar
Unpossible!

Joined: 27th Jun, 2008
Posts: 38439
devilman wrote:
Joans wrote:
I need to up my game.

And post more.


I wasn't expecting to be where I was in the chart after not posting for three years. I guess it shows how little work I've done in the past. :)

3 years? Blimey.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 16:53 
User avatar
EvilTrousers

Joined: 30th Mar, 2008
Posts: 3073
Curiosity wrote:
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.


I shall makes great strides to be better.

_________________
Everyone but Zardoz is better than me at videogames.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 23:24 
User avatar
Can you dig it?

Joined: 5th Apr, 2008
Posts: 4662
DOOMED

_________________
rumours about the high quality of the butter reached Yerevan


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Thu Sep 22, 2016 12:28 
User avatar
Ticket to Ride World Champion

Joined: 18th Apr, 2008
Posts: 11843
Trousers wrote:
Curiosity wrote:
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.


I shall makes great strides to be better.

ISWYDT.

_________________
No, it was a giant robot castle!


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 473 posts ]  Go to page Previous  1 ... 6, 7, 8, 9, 10

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search within this thread:
You are using the 'Ted' forum. Bill doesn't really exist any more. Bogus!
Want to help out with the hosting / advertising costs? That's very nice of you.
Are you on a mobile phone? Try http://beex.co.uk/m/
RIP, Owen. RIP, MrC.

Powered by a very Grim... version of phpBB © 2000, 2002, 2005, 2007 phpBB Group.