Go Back   English Forum Switzerland > Support > Support > Forum support  
Reply
 
Thread Tools Display Modes
  #1  
Old 27.02.2011, 15:10
Upthehatters2008's Avatar
Forum Legend
 
Join Date: May 2010
Location: In the kitchen at parties.
Posts: 4,540
Groaned at 204 Times in 120 Posts
Thanked 6,078 Times in 2,378 Posts
Upthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond repute
The huge Forum DB

Not not the Breakfast one, the database.

Do you think members with SQL skills could get restricted access ? (Read Only, To thread contents and not member details etc)

I would love to generate some interesting/useless stats pages...

E.G. Posts by Location, Lists of members detailing posts per day, average thanks per post, average groans per post, per member, per City, Demographic member counts, member lifetimes, Keyword totals (Brown Sugar, Speeding etc) and millions of other possibilities...

Maybe the Mods have some regular queries they would like to run ?
Reply With Quote
The following 4 users would like to thank Upthehatters2008 for this useful post:
  #2  
Old 28.02.2011, 08:46
Guest
 
Posts: n/a
Re: The huge Forum DB

Direct access to the database is not possible.

But anyone is welcome write a script using PHP and MySQL and send it in.

Mail it to: team@englishforum.ch

We'll give it a look over, and if it's safe and suitable then we'll upload it.

Files you need:
- Simple PHP template
- EF database schema

That is not the full schema, but it should be enough to cover all the types of statistics you mention.
Reply With Quote
The following 6 users would like to thank for this useful post:
  #3  
Old 01.03.2011, 11:54
economisto
 
Posts: n/a
Re: The huge Forum DB

I for one would be very interested in an opportunity to complex-query the database.

+1
Reply With Quote
  #4  
Old 01.03.2011, 12:01
olygirl's Avatar
Forum Legend
 
Join Date: Oct 2007
Location: d' Innerschwiiz
Posts: 7,618
Groaned at 416 Times in 279 Posts
Thanked 17,911 Times in 5,536 Posts
olygirl has a reputation beyond reputeolygirl has a reputation beyond reputeolygirl has a reputation beyond reputeolygirl has a reputation beyond reputeolygirl has a reputation beyond reputeolygirl has a reputation beyond repute
Re: The huge Forum DB

I'm more interested in the huge Forum DB - the breakfast one.
Reply With Quote
  #5  
Old 01.03.2011, 12:13
Glendyn's Avatar
Forum Veteran
 
Join Date: Nov 2008
Location: ZH. Horgen area
Posts: 774
Groaned at 10 Times in 4 Posts
Thanked 933 Times in 385 Posts
Glendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond repute
Re: The huge Forum DB

One useless stats page I think would be interesting is:
"Most ignored users" based on presumably
TABLE `usertextfield``ignorelist` mediumtext NOT NULL,
(without any names as to who is doing the ignoring)

UserName IgnoredCount


I bet you there would be a few well known names there with big rep's.

Last edited by Glendyn; 01.03.2011 at 14:43.
Reply With Quote
The following 3 users would like to thank Glendyn for this useful post:
  #6  
Old 01.03.2011, 12:22
miss_bean's Avatar
Forum Veteran
 
Join Date: Sep 2008
Location: Zurich
Posts: 525
Groaned at 3 Times in 3 Posts
Thanked 464 Times in 224 Posts
miss_bean has an excellent reputationmiss_bean has an excellent reputationmiss_bean has an excellent reputationmiss_bean has an excellent reputation
Re: The huge Forum DB

Quote:
View Post
One useless stats page I think would be interesting is:
"Most ignored users" based on presumably
TABLE `usertextfield``ignorelist` mediumtext NOT NULL,
(without any names as to who is ignoring who)

I bet you there would be a few well known names there with big rep's.

I hope not, hate the popularity contest.

But over all statistics of views, most read threads under different category/sections would be helpful especially for the new members looking for the relevant information.
Reply With Quote
  #7  
Old 01.03.2011, 12:32
Glendyn's Avatar
Forum Veteran
 
Join Date: Nov 2008
Location: ZH. Horgen area
Posts: 774
Groaned at 10 Times in 4 Posts
Thanked 933 Times in 385 Posts
Glendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond reputeGlendyn has a reputation beyond repute
Re: The huge Forum DB

Quote:
View Post
I hope not, hate the popularity contest.

But over all statistics of views, most read threads under different category/sections would be helpful especially for the new members looking for the relevant information.
So do I, and that's why I think that would be a useful report because it shows the real truth, not the popularity contest rep business. The ignored user is also unaware so there is no risk of retaliation as there is with rep.

My hope is that some of those who feature high on the ignore list, especially those with lots of points / rep might reconsider a little what they post.

Last edited by Glendyn; 01.03.2011 at 12:44. Reason: spelling mistook.
Reply With Quote
The following 2 users would like to thank Glendyn for this useful post:
  #8  
Old 21.04.2011, 15:24
MrVertigo's Avatar
Forum Legend
 
Join Date: Feb 2010
Location: CH
Posts: 3,200
Groaned at 86 Times in 70 Posts
Thanked 5,788 Times in 2,254 Posts
MrVertigo has a reputation beyond reputeMrVertigo has a reputation beyond reputeMrVertigo has a reputation beyond reputeMrVertigo has a reputation beyond reputeMrVertigo has a reputation beyond reputeMrVertigo has a reputation beyond repute
Re: The huge Forum DB

Quote:
View Post

(...)
I would love to generate some interesting/useless stats pages...

E.G. Posts by Location, Lists of members detailing posts per day, average thanks per post, average groans per post, per member, per City, Demographic member counts, member lifetimes, Keyword totals (Brown Sugar, Speeding etc) and millions of other possibilities...

(...)
I was watching this TED presentation and thought immediately about EF. Would be funny to find criteria for the ultimate EF topic & post that will generate:
- max # posts, red/green reps, thanks, etc...

Can we make something out of the stats you have access to?
Reply With Quote
  #9  
Old 21.04.2011, 15:39
Upthehatters2008's Avatar
Forum Legend
 
Join Date: May 2010
Location: In the kitchen at parties.
Posts: 4,540
Groaned at 204 Times in 120 Posts
Thanked 6,078 Times in 2,378 Posts
Upthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond reputeUpthehatters2008 has a reputation beyond repute
Re: The huge Forum DB

Quote:
View Post
I was watching this TED presentation and thought immediately about EF. Would be funny to find criteria for the ultimate EF topic & post that will generate:
- max # posts, red/green reps, thanks, etc...

Can we make something out of the stats you have access to?
I am eager to get started on this, I have the DB up , with PHP/Apache etc. But the schema is poorly documented, and I have no test/dummy/anonymised data. Writing reports is next to impossible. If Editor Bob could find some time to get some to me, I would be off like a shot mining the data for all sorts of reports.
Reply With Quote
Reply




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Probably going to UK soon with huge empty trailer. 70sKitch Transportation/driving 5 08.10.2010 22:00
A HUGE Decision Mossy Employment 30 13.12.2007 04:58


All times are GMT +2. The time now is 13:58.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0