Your premium source for custom modification services for phpBB

HomeForumsBlogMOD ManagerFAQSearchRegisterLogin

Comments September 28, 2007

SQL Challenge #2: Top-ten Members Analysis

Filed under: SQL Challenge — Dave Rathbun @ 12:48 am Comments Off 

phpBB Doctor SQL Challenges

This is the second SQL Challenge from the phpBB Doctor. It is my hope that this series of posts will be interesting but educational as well. The concept is simple: I will post a challenge that must be solved with (unless stated otherwise) a single SQL statement. No php code, no “insert into…” temporary tables, just one simple (or more likely not-so-simple!) SQL statement. There is often more than one way to solve the same problem, so I personally will be interested to see some of the solutions that are presented. Eventually I will post my original answer and optionally the best answers (judged by me) submitted to the challenge as well. Some of the challenges will use phpBB tables and data, others may use special data that I will create and make available for you to download.

What do you win? You win the knowledge that you solved a challenge. Is that enough for you? :-)


Comments September 25, 2007

SQL Challenge #1 Solution

Filed under: SQL Challenge — Dave Rathbun @ 2:14 pm Comments Off 

In the first challenge in this series I presented some data that I had put together to analyze the posting history of users on my largest board. Rather than post the exact SQL used I thought it would be fun to leave it as an exercise for my blog readers. Today I’ll reveal my solution.


Comments August 28, 2007

SQL Challenge #1: Frequent Poster Analysis

Filed under: SQL Challenge — Dave Rathbun @ 5:05 am CommentsComments (3) 

I have no idea if this will be interesting or not, but I want to try it for a while and see what happens. I am going to start a series of SQL Challenge posts. The first one is based on a query that I wrote during one of my posts in my “Advertising on Forums” series. Since it was based on a table that is not part of phpBB I have provided a download link for a script that will create a simple version of the table for you to put into your database and play around with, if you are so inclined.


Powered by WordPress