PhpBB Forums

From NzGpsWiki

The forums are run using open-source software called phpBB. Further information about the product is available on their website.

Contents 1 Database Maintenance 1.1 Delete unused accounts 2 Upgrades 2.1 Install phpBB Mods 2.1.1 Smilie Pak 2.1.2 RSS Content Syndicator 2.1.3 Topics Anywhere 2.2 Template Modifications 2.2.1 Delete inline CSS 2.2.2 Install GPS Society logo 2.2.3 Make Registration Link Red 2.2.4 Remove Moderators 2.2.5 Add Index To Menu 2.2.6 Copy CellPic Images 2.2.7 Save Bandwidth 2.3 Time Changes 2.3.1 To Standard Time 2.3.2 To Daylight Time 2.4 Spammer Protection 2.5 Banlists

Database Maintenance

Delete unused accounts

• We should identify some queries to remove certain unused accounts from the database. These accounts should cover only those users that haven't:
  • Made a post (post_count = 0)
  • Haven't logged into the site for x days
  • Have not activated their account

Upgrades

The best way to upgrade the Society installation of phpbb is to use the 'code changes' that require a manual cut and paste of the updates. This will usually avoid the issue of having to make many of the following changes we have made.

Install phpBB Mods

After performing a new install/upgrade of phpBB, the following items need to be installed.

Smilie Pak

Download, unzip and upload files (*.pak, *.gif) to forums/images/smiles

• Source - Smilie Pak

RSS Content Syndicator

Download, unzip and upload the files. Provides a simple RSS feed of new posts.

• Source - RSS Content Syndicator
• Upload rss.php to forums/
• Upload rss_body.tpl to forums/templates/subSilver/rss_body.tpl

Topics Anywhere

This appears to have been removed. We may have to investigate and find a new Mod to provide this service (customised feeds).

• Topics Anywhere

Template Modifications

Delete inline CSS

Huge space waster

• Delete <style></style> in /forums/templates/subsilver/overall_header.tpl

Install GPS Society logo

1. Copy logo_gpsorgnz.gif to /forums/templates/subSilver/images. Should probably move to a global directory.
2. Edit forums/templates/subSilver/overall_header.tpl

<a href="http://gps.org.nz"><img src="/images/logo_gpsorgnz.gif"
 border="0" alt="GPS.org.nz" vspace="1" />

Make Registration Link Red

• Edit forums/templates/subSilver/overall_header.tpl

<font color="red">{L_REGISTER}</font>

Remove Moderators

Remove the display of moderators in the list of different forums

• Edit forums/templates/subSilver/index_body.tpl
• Remove

<br /></span><span class="gensmall">{catrow.forumrow.L_MODERATOR}
{catrow.forumrow.MODERATORS}</span>

Add Index To Menu

• Edit forums/templates/subSilver/overall_header.tpl

<span class="mainmenu"> <a href="{U_INDEX}" class="mainmenu">
<img src="templates/subSilver/images/icon_mini_members.gif" width="12"
 height="13" border="0" alt="{L_INDEX}" hspace="3" />Index</a>   

Copy CellPic Images

???

Save Bandwidth

• Remove css embedded in default template
  • Open forums/templates/subSilver/overall_header.tpl
  • Delate everything between <style type="text/css"> </style>
• Add css link - should probably move the css out of the forums directory - perhaps global

<link rel="stylesheet" href="/subUL-GPS.css" type="text/css">

Time Changes

These updates need to be made directly through the phpmyadmin interface to the database. Browse to the database and run the SQL queries.

To Standard Time

• To change NZ users

UPDATE `phpbb3_users` SET `user_timezone`='12.00' WHERE `user_timezone`='13.00';

• Change board time

UPDATE `phpbb3_config` SET `config_value`='12.00' WHERE `config_name`='board_timezone';

To Daylight Time

UPDATE `phpbb3_users` SET `user_timezone`='13.00' WHERE `user_timezone`='12.00';
UPDATE `phpbb3_config` SET `config_value`='13.00' WHERE `config_name`='board_timezone';

Spammer Protection

A couple of techniques are necessary to protect the forums from spammers. This change will the membership so that only verified users will be shown, and only those members that have posted at least one message to the forums.

• Edit forums/memberlist.php

$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, 
user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, 
user_allowavatar FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS . "
AND user_active = 1 AND user_posts >= 1 ORDER BY $order_by";

• Edit forums/templates/subSilver/index_body.tpl and remove the following

<br />{NEWEST_USER}

Banlists

The following domains have been permanently banned from subscribing to the forums for past spamming attempts. They are provided as SQL INSERTS that can be imported directly into the phpbb banlist table. The query to extract them is. Address and domains in this list have been caught spamming in either the http://gps.org.nz/forums or http://response.net.nz/forums

SELECT `ban_userid` , `ban_ip` , `ban_email`
FROM `phpbb_banlist`
WHERE `ban_email` IS NOT NULL

INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@non-olet.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'gonzales56ghl@hotmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@blobby.viagta.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@centmp3.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@execposters.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@webjumps.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@redwhitearmy.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'jorgesolhk@yahoo.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@lpemail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@tierramedia.org');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@interproject.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@hotpop.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'jacob_milne@hotmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'laurel.c@xtra.co.nz');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@yandex.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@aladdinus.be');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@net-search.org');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@mail.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@inbox.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@jobqueen.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'john1955@inbox.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'bloggreen@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@list.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@inbox.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@bk.ru');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@londonon.org');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@temet-nosce.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@gaweb.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@manus-manum-lavat.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'Tolstiyovm@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@doh75.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@figaro.in');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'valr234@yahoo.co.uk');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@justopt.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'qzMrdVAD@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'UYihcAFV@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '0JhLAnAj@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'eer2006@yahoo.co.uk');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@moo321.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'liko@nerdshack.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', 'gotrainn@gmail.com');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@tipro.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@tempori-parce.info');
INSERT INTO `phpbb_banlist` (`ban_userid`, `ban_ip`, `ban_email`) VALUES (0, '', '*@jogox.org');