Share experience on building a forum site

Anton, about your question:

That might explain that one then, but I do remember plain as day the number being at 66. I think when I started back in August the high was in the high teen’s. And I remembered watching it do a steady increase (up to 66) since I’ve been here. Maybe when you release your modded version I’ll use it start start segue.xxx :smiling_imp: :wink:[/quote]

Back in August, after Segue was launched, I registered for Google’s spiders to visit the new website. I expected Google to take about 3 weeks before they came over and started indexing the site.

Almost to the day (or so it seemed to me), the website started seeing significant jumps in anonymous guest visits – a high of 28 or 29 became a high of 40+ the next day. Then 50+, then over 60.

Remember, this is after I first launched Segue (August) – so only half of the Google mod was in place then. Thinking about this, and the 3 to 4 week delay, I checked the Admin CP (Control Panel) and noticed that 1 or 2 DOZEN of the guest visitors had the SAME IP.
“They” were doing all kinds of things – “posting messages”, doing searches, reading this and that.

Two dozen from the same IP? 3 or 4 weeks from the launch the site?? And seeing that the daily highs had overwhelming majorities of guest postings?

In short – don’t worry – Google’s spiders will come… probably around Chinese New Year. And they will keep coming – it’s pretty cool.

Here’s my first Pre-modded phpBB Installation.

It includes the following mods:

Tell-a-friend
Google Indexing
Hypercells
Quick Reply w/ quotes
View Recent Posts (Drop Down version)
Traditional Chinese language set and images


Curtis Sanderson's Tellafriend mod

############################################################## 
## MOD Title: enhance-google-indexing 
## MOD Author: Showscout & R. U. Serious 
## MOD Description: If the User_agent includes the string 'Googlebot', then no session_ids are appended to links, which will (hopefully) allow google to index more than just your index- site. 
## MOD Version: 0.9.1 

################################################################# 
## MOD Title: GoogleSingleSession (Add-On to enhance-google-indexing ) 
## MOD Author: - R. U. Serious 
## MOD Description: This MOD will give all 'guests' where the useragent 
##      contains 'Googlebot' one session (static session_id) 
##      Hence it will only appear as a single guest. 
## 
## MOD Version: 0.9 

######################################################## 
## 
## Title: Hypercells
## Version: 1.0.0 - final release 
## Author: Brewjah 
## Description: allows users to click anywhere in the cell to access the forum or a topic 
## and displays a hand cursor on mouse over even to SHOW that its clickable.. 
## 

##############################################################
## MOD Title: Quick Reply with Quote
## MOD Author: Smartor < smartor_xp@hotmail.com > (Hoang Ngoc Tu) http://smartor.is-root.com
## MOD Description: This will add a quick-reply form below every topics
##			It will only display when user has the Reply access
##			User have a option to quote the last message
## MOD Version: 1.1.2

##############################################################
## Mod Name:			view_recent_posts_v1_0_3.txt
## Mod Date:			2002-06-07
## Mod Title:			View Recent Posts
## Mod Version:			1.0.3
## for phpBB Version:	2.0.1
## Author:				Matthias C. Hormann <matthias@hormann-online.net>
## Description:			This mod allows viewing recent posts directly from
##						the index page. It introduces a new 'View Posts
##						from previous <selection>' on the main page,
##						directly below the 'View unanswered posts' link.
##						The selection box has the standard search selections
##						(1 day/1 week/2 weeks/1 month/3months/6 month/1 year)
##						and defaults to '1 day'.

PLS NOTE: I WILL NOT PROVIDE ANY TECH SUPPORT FOR THIS INSTALLATION. If you need help, please refer to www.phpbbhacks.com – all of these mods are available there

I’ve installed this successfully on MySQL in a Linux environment

Here’s the download:
adapon.ph/gus/segue/segue1.zip (628k)

[color=red]PLS NOTE: If you already have phpBB installed, (1) back up your files before you make any major changes to them and (2) save your original config.php someplace – if you lose this, you are really screwed. The config.php file that comes with these pre-mod is an empty file[/color]

Enjoy!

Gus,

My guestion is still: where to put the index or meta_ID that let google search by keyword, as in an HTML you put a meta name on the header, for example; forum, anton, language, etc, etc so that when I type language or anton on google search box, my site will pop up on the search result?

regards,
Ax

That’s a good question. I have two suggestions for you:

  1. In the index.php file, find the following:

$template->assign_vars(array( "META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '">') );

Carefully insert your Keyword Meta tags within the single quotes. Example:

$template->assign_vars(array( "META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '"> <meta .... blah blah blah>') );

[color=red]I have NEVER actually done this, so I do NOT know if this will work[/color] (see Suggestion #2 below)

  1. Go to www.phpbbhacks.com and LOOK FOR THE ANSWER. When you find it, please come back here and let us know the proper way :slight_smile:

I’ve added a few more mods in addition to the mods listed above to my next Segue Pre-Mod.

(See message below for the download link)

These modifications require you to add or alter some MySQL tables. I’ve made all the code changes, but you will have to make the table changes on your own. There are two ways you can do this:

  1. Manually change the tables using phpMYadmin or whatever MySQL administration software you are using (do a search on Google or www.phpbb.com to get your own copy of phpMYadmin). The table ‘dimensions’ for each mod are listed below

  2. Download each of the following mods – some of them have .php scripts that painlessly make the table adjustments for you.

Mods in this Pre-mod:

Referral Mod
Sponsored Categories (not a banner mod)
Forum Views
Ignore Users
Bookmarks

################################################################################### 
## 
## MOD Title:   referral mod
## MOD Version: 1.0.0 ALPHA
## Author:      Antifanatic < webmaster@antifanatic.co.uk > (Rob Wiggins)
## Description: Add a bit to the users profile to say who reffed them to the site
##
## 
################################################################################### 
## This MOD is released under the GPL License. 
## Intellectual Property is retained by the MOD Author(s) listed above 
############################################################## 

SQL QUERY: 
alter database (change the phpbb_ if this isnt your mysql prefix)

ALTER TABLE phpbb_users ADD user_referral VARCHAR(255);





################################################################# 
## Mod Title:    Sponsered Categories Mod 
## Mod Version:  1.0.0 
## Author:       Samuel Cochran < sam@wyvern.com.au > 
##               http://www.wyvern.com.au/~sam/mods
## Description:  This mod allows you to display an image next to 
##               each of your categories. This is useful for 
##               corporate websites where companies may pay to 
##               display their logo next to a catagory as the 
##               'sponser'.
## 
################################################################# 
# 
#-----[ RUN SQL ]------------------------------------------------ 
# 
# You may have to change your database prefix 
# MYSQL: 
ALTER TABLE phpbb_categories ADD cat_sponser_img VARCHAR(255) NOT NULL, ADD cat_sponser_url VARCHAR(255) NOT NULL;
# 






######################################################################################
## Hack Title:   Forum views
## Hack Version: 1.0
## Author:       Acid < acid_junky@web.de >
##               (saerdnaer gives me a little hint)
##
## Description:  Similar to topicviews (viewforum) this hack shows you how often a
##         forum was visited.
##
#######################################################################################
## First always make a back-up from the files (and database) that you're going to edit. 
## 
## This hack adds a new field to your 'forums' table. 
#######################################################################################

# 
#-----[ EXECUTE SQL ]-----------------------------------------------------
# 
# change prefix_ !

ALTER TABLE test_forums ADD forum_views MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL AFTER forum_topics






############################################################## 
## Mod Title: Ignore Users Mod 
## Mod Version: 1.1.1 RELEASE
## Author: GunnerX < gunnerx@gunnerx.net > Romar Armas - www.gunnerx.net 
## Description: This Mod enables users to set up an ignore list.
##  The posts of the users in this list will be ignored and unseen.
##  Demo url at: http://www.gunnerx.net/phpBB21/
## 
## Installation Level: (advanced) 
## Installation Time: 30 Minutes 
############################################################## 
############################################################## 
## Author Note:  
##  v1.1.1 Minor bug fix in viewtopic.php
##  v1.1.0 New updated version with more functions
##      v1.0.0 Release: I have added functionality in the viewtopic to add a poster
##  to the ignore list.  Also fixed a bug which allowed users to be listed
##  multiple times.
##      BETA: I did not add instructions as to where you would like to put the link
##  to the ignore.php function.  You can add the link anywhere you would like.
##  Examples are: Top menu links, inside the profile.php or inside each post.
##  It really is up to you.  I placed it on the top menu.
## 
############################################################## 

# 
#-----[ CREATE TABLE ]------------------------------------------ 
# 
CREATE TABLE phpbb_ignore (
  user_id mediumint(8) NOT NULL default '0',
  user_ignore mediumint(8) NOT NULL default '0'
) TYPE=MyISAM;






############################################################## 
## MOD Title: Bookmarks
## MOD Version: 1.0.1
## MOD Author: PhilippK < Kordowich <at> gmx.net > (Philipp Kordowich)
## MOD Description: Keeps an internal list of bookmarks set by the user 
## 
############################################################## 

# 
#-----[ EXECUTE SQL ]----------------------------------------- 
# 

# If you use a MySQL-Database, you can use the included script-file 'update_db_for_bookmarks.php'
# to update your database. This script will use the right prefix for your tabel, so you don't have
# to care about these things. To exececute it, just copy it to the root directory of your forum
# (the directory where you can find the config.php) an execute it by calling it with your
# Browser. It's recomended to remove the file afterwards from the server for security reasons.
#
# If you do not use a MySQL-Database, you have to execute these two SQL-Commands. Please keep in
# mind that you need to change the tabel-prefixes if you didn't use 'phpBB2'. It may be necessary
# to change the SQL-commands depending on the database you use

CREATE TABLE phpbb2_bookmarks (
    topic_id mediumint(8) unsigned NOT NULL default '0',
    user_id mediumint(8) NOT NULL default '0',
    KEY topic_id (topic_id),
    KEY user_id (user_id));
ALTER TABLE phpbb2_users
    ADD user_setbm tinyint(1) NOT NULL default 0 AFTER user_attachsig";

Once again, do NOT ask me to support these modifications and pre-mods. You can find the answers for yourself at www.phpbbhacks.com

IMPORTANT: Do NOT hold me responsible for ANY problems you encounter with these phpBB installations. These are the codes that I am using, but in trying to install them yourself, you agree to absolve me of any responsibility.

If you have a beef with any of the modifications, you can also contact the Mod Authors in the headers I list here.

Cheerio

If you already have a phpBB installation on your website, but would like to try out these pre-mods, here’s what you can do.

  1. Create a new subdirectory (Ex. /test)

  2. Upload everything in the ZIP fule (maintain the directory structure!!) into said /test directory

  3. Replace the config.php file with the one you are currently using from your original install

Like magic, your new forum should be working (and Yes, you will have TWO installations pointing to the same underlying data)

The same disclaimer from above holds here – if you try this and your website, forum, and/or MySQL database F’s up, do not hold me responsible.

But as far as i can tell – it works (whic is real cool, too :slight_smile:)

Additional mods:

Two (2) sets of mini-icons from forumimages.com
Last_Topic_Title_Index
Today At/Yesterday At
Remove Coppa
Welcome & Avatar On Index (who is online section)
Notify Email Shows Poster Name
Printable Page
Mouse Hover Topic Preview

######################################################## 
## Mod Title:  last_topic_title_index   
## Mod Version: 1.0.0 
## Author:       Adam Ismay <admin@boardz.tk>
## Description:  Gives the topic title in the last post
##               box on index.
######################################################## 


################################################################# 
## Mod Title:    Today At/Yesterday At
## Mod Version:  1.2.1
## Author:       blulegend 
## Description:  Will show Today At if the post was posted today 
##               Will show Yesterday At if the post was posted 
##               yesterday
##
##               Modifies in index, viewforum, viewtopic, and 
##               search!
##
##               Includes code compatible with Daylight Savings 
##               Time Mod
################################################################# 


################################################################# 
## Mod Title: Remove Coppa
## Mod Version: 1.0.0 
## Author: Duncan Jones <duncan____jones@hotmail.com>
##         Username On PHPBB Boards - Hardout
## Description: This MOD will remove Coppa from the registration 
##         agreement and replace it with "I Agree to these terms" 
##         and "I do not agree to these terms"
## 
################################################################# 
## 
## Author Note: 
##  
##  Removing Coppa MAY be illegal in some countries, please check 
##  for your own country before using/making this Modification.
## 
################################################################# 


################################################################# 
## Mod Title: Welcome & Avatar On Index (who is online section)
## Mod Version: 2.0.1 
## Author: John B. Abela  <abela@phpbb.com> - www.JohnAbela.Com
## Description: 
##   This MOD will place a 'welcome your_name' and your avatar
##   (if you have one) within the 'who is online' section of the 
##   index page. If you do not have an avatar, it will display 
##   the default 'whosonline.gif'
## 
################################################################# 
## 
## Authors Note: 
##   
##   This MOD -should- allow for all three types of Avatars.
##   This MOD is Copyright ?John B. Abela, 2002
##   (Any changes to this MOD must retain my Copyright Notice.)
## 
################################################################# 


################################################################# 
## Mod Title: Notify Email Shows Poster Name 
## Mod Version: 1.0.0 
## Author: Matthijs < matthijs@beryllium.net > 
## Description: This will show the name of the person reacting to
##              the topic you're watching in the notification
##              email.
################################################################# 


######################################################## 
## Mod Title:  printable page   
## Mod Version: 1.0.0 
## Author:       Adam Ismay (admin@boardz.tk)
## Description:  Gives the option of a printable version
##          which has no non-message graphics and has
##          a more compact display format. All messages
##          in a thread are displayed.
## 
########################################################


################################################################# 
## MOD Title:       Mouse hover topic preview
## MOD Author:      Shannado <sven@shannado.nl> (Sven) 
##                  http://www.shannado.nl/forumorg
## MOD Description: With this MOD an user can see preview, when 
##                  he/she holds the mouse over the topic in 
##                  viewforum
## 
##                  It showes the first 200 characters of the 
##                  LAST post.In the HOWTO is also described how 
##                  to preview the FIRST post instead of the LAST 
##                  Post.
## 
##                  Also in the search result screen you can 
##                  preview the post (only when viewing topics)
## 
## MOD Version:     1.0.6 
##      
############################################################## 


################################################################# 
## 
## Plus two sets of mini icons from Forumimages.com
## 
################################################################# 

Gus.

can you understand this better than me?
zytrax.com/tech/php/php_ssi.htm

does it mean I can change the index.php to look like an html file and it still work the same?

regardx
ax

Almost.

I think it actually means that you can use PHP to ‘imitate’ the effect of SSI, and they give you a ‘footer time stamp’ example to illustrate this point. So to re-phrase your statement, you could say it means that you can change the index.php to look like an shtml file (or an SSI server enabled ‘html’ file)

Note, one problem I encountered with this forums is a “Header missing” error. This occurs when you use do not start a PHP file with PHP code.

I re-uploaded segue2.zip Pre-mod – it now includes the above mods plus the ones listed in this post

adapon.ph/gus/segue/segue2.zip (749k)

[color=red]PLS NOTE: If you already have phpBB installed, (1) back up your files before you make any major changes to them and (2) save your original config.php someplace – if you lose this, you are really screwed. The config.php file that comes with these pre-mod is an empty file[/color]

Global Announcements
Links
Merge Threads
Topic Ratings

################################################################# 
## Mod Title:   Global Announcment mod 
## Mod Version: 1.0.6
## Author:       Niels Chr. R&#40419; Denmark < ncr@db9.dk > 
##               mods.db9.dk
## 
## This mod is for phpBB2!! ver 2.0.0
##
## This mod, makes it posible to post global announcements 
## vieweble in all forums, it suppport auth level, which 
## means you can define in forum permissions, who have 
## right to post global announcements, note though that 
## if you have given this righ in one forum, then it gives 
## no meaning to restrict it to the same user in another 
## forum - the post is global 
##
## There is a know isue this this mod, a global announcement 
## will still "belong" to the forum where it original was posted,
## this means that if a user reply to sutch a post, then they 
## will be redirected to that forum, nothing to do about that, 
## also when using seach, it will be displayed in the original 
## forum
##
################################################################# 
## 
## Installation Notes: 
## 
## if you are using a prefix to you DB tabels then you have to 
## add this to the SQL commands, e.g. "phpbb_users" instead of 
## just "users" - ONLY in the initial SQL commands, not in the 
## php code ! 
## 
## The most important thing to keep in mind is, take your time, 
## make sure you are finding the correct lines to modify, then 
## take care to paste the new code. 
## 
## Please also keep in mind, if you are using more than one 
## language file or theme at your site, you will need to edit the 
## corresponding files for each occurrence.  Good Luck! 
## 
################################################################# 
## Before Adding This MOD To Your Forum, You Should Back Up All 
## Files Related To This MOD and the Database
################################################################# 

# 
#-----[ ADD SQL ]------------------------------------------ 
# 
ALTER TABLE forums ADD auth_globalannounce TINYINT (2) DEFAULT '3' NOT NULL AFTER auth_announce

# 
#-----[ ADD SQL ]------------------------------------------ 
# 
ALTER TABLE auth_access ADD auth_globalannounce TINYINT (1) AFTER auth_announce 




################################################################# 
## Mod Title: Links 
## Mod Version: 1.0.3 
## Author: R. U. Serious <r.u.serious@handykoelsch.de> - 
##                       www.handykoelsch.de
##
## Description: This MOD adds a link list to your site. 
##      Admins can add categories. Everybody can add links and
##      assign them to one (or more) categories. Also every User
##      can manage their own private favorites.
## 
##                  install_links_db.php
##                  links_schema.sql,
##                  update_from090.sql
## 
############################################################## 
## 
## Author Note: 
## This mod is good to use on smaller or medium sized boards. 
## It has only been tested with mysql so far.
## Make the appropiate changes to your database 
## (run install_links_db.php from your main phpBB-directory).
## If you don't have any category, you will receive error
## messages. The last 3 lines add an example category/link to 
## my site. I'd be happy if you'd let the link to my site in 
## there :-)
## 
## Put links.php in your main phpBB-directory.
## Put *.tpl in templates/subSilver/
##
## This basically uses the colors of your style, except for 
## the navigation bar on the left. Edit the color values in 
## links_body.tpl to suite your needs.
##
## There are a few "switches" which are explained. Look in 
## links.php
## 
## They are for anonymous adding links, BBcode enable, 
## default-category etc.
## 
## AT LEAST CHECK THE DEFAULT CATEGORY; YOU WILL GET ERROR 
## MSG IF IT DOES NOT EXIST!
##
################################################################# 
## 
## Make sure the following files are in your root directory:
##                  install_links_db.php
##                  links_schema.sql,
##                  update_from090.sql
## 
## Run install_links_db.php and then delete it
## 
################################################################# 

################################################################# 
## Mod Title:   Users Can Rate Topics
## Mod Version: 1.2.3
## Author:       Nivisec < nivisec@hotmail.com > - http://www.nivisec.com/
##               Note:  E-mail me as a last resort, please try the forums
##                      below first.
##  Get Tech
## Support At:   http://www.phpbbhacks.com/forums/
## Description:  Allows users to rate a topic based
##               on an Admin defined scale.
##
## Features:     Extensive Admin control panel.
##               Anon IP checking (if wanted).
##               Does authorization checking per user basis
##                   to not display un-viewable links/forums.
##               Each forum can be set to a seperate authorization
##                    method for rating.
##               Define your own rating scale of 1 to MAX.
##
## Latest Version At:   http://www.nivisec.com/mods/
################################################################# 
## 
## Author Note: 
## Be sure to run rate_topics_table to install, or
## uninstall if you want, the data needed in your
## database.
## 
##-----[ UPLOAD AND RUN ]------------------------------------------ 
## 
## rate_topics_table.php
##
## Make a link to rate.php if you wish to have a
## very detailed listing of all the rating information.
##
################################################################# 

################################################################# 
## MOD Title:       Merge Topic MOD
## MOD Author:      Shannado <sven@shannado.nl> (Sven) http://www.shannado.nl/forumorg
## MOD Description:     Moderator will be able to move a topic to an already running topic. And a moderator is able to move
##          individual posts to a runnning topic.
## MOD Version:     1.0.3
##      
############################################################## 

[quote]

Taiwan-oriented online community :: Segue Taiwan [/quote]

Gus,

I check segue homepage www.segue.com and found the following souce code. I’m sure you already know how to put the META NAME and keywords. Please share with me on which php file to edit on which part and is there a specific php format I have to follow?
I only know echo command:)

thanks in advance,

ax

Sorry, man, I don’t recall how I put the keywords in.

Read this: forums.segue.com.tw/viewtopic.php?p=47597#47597 (especially suggestion #2)

gus, was I suppose to do something more to make your pre-modded phpbb work? I tried it out [HERE], it seems like something is up. The file it’s looking for isn’t there. :?

[quote=“gus”]If you already have a phpBB installation on your website, but would like to try out these pre-mods, here’s what you can do.

  1. Create a new subdirectory (Ex. /test)

  2. Upload everything in the ZIP fule (maintain the directory structure!!) into said /test directory

  3. Replace the config.php file with the one you are currently using from your original install

Like magic, your new forum should be working (and Yes, you will have TWO installations pointing to the same underlying data)

The same disclaimer from above holds here – if you try this and your website, forum, and/or MySQL database F’s up, do not hold me responsible.

But as far as i can tell – it works (whic is real cool, too :slight_smile:)[/quote]

I’m gonna start trying some things now. So when adding these new modifications the way to do it is:

  1. Edit all the correct files and things in an unmodded copy of phpbb.
  2. Upload it to a test directory, swap the config, and it should (note should) work?

Does that sound about right? I still have more reading to do on everything, but I wanted to see if I have a small understanding yet.

Ok, I’ve done the statistics mod and the samspade mod. I think I got it figured out.

[quote]phpBB : Critical Error

Error creating new session [/quote]

Is this bad?

That’s what I’m getting at my forum. :astonished:

Did you do anything new? You might want to search www.phpbb.com’s forums (I’ll take a quick look).

phpbb.com’s search isn’t working right now, but I found this via google.

[CLICK HERE]

Not sure if it’ll help you at all or not.

Nope, nothing new and in fact, was planning to install the latest release. Thanks for that link, I’ll check it out.

Recently updated to 2.0.17 with no problems, except now I’m getting this:

[quote]
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table ‘phpbb_sessions’ is full

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES (‘37eed890f7b616410a25304b67a8ca22’, -1, 1127830226, 1127830226, ‘daa17ad1’, 0, 0, 0)

Line : 172
File : sessions.php [/quote]

What a PITA!!

PHPBB gurus, :help:

EDIT: Okay, figured it out. Had to “empty or truncate my session table.”