The post will show you how in Drupal 6 to display a block for the administrator showing how many comments by anonymous users are waiting approval and also provide a link to the approval list.

Pre-setup

This post assumes you have your permissions set so anonymous users can post comments (with approval), and you also have the core module PHP filter installed.

Here is a function I have recently had to use you pass a time / date string in strtotime format and the function will return a string with a date relative to today.

Examples of what the function can return

Today

Yesterday

Tomorrow

In 2 days

In 6 days

5 days ago

Thursday 17 January

Tuesday 4 January 2005

Intro

This document will cover how to integrate with phpBB 3's BBCode system, this can useful if you are building a CMS and you are using phpBB 3 as your back end.

This tutorial will not cover setting up phpBB 3 or the basics of PHP, also please note there may well be better ways of doing this but it worked for me

The database

To start I have created a table in the phpBB database called "cms_test" with the following fields.