Similar site for a different industry?

[Harry_Perkins]

I'm thinking of going ahead and setting up a similar site to Royal Mail Chat for the industry that I used to work in (Gaming industry, ie betting shop workers, casino workers etc). I see one facebook group already has a lively forum for people working in just one company in the business and it would be good to unite all these disparate groups in one location. Obviously, there are issues with facebook in that the vast majority use their real names and pictures and this can lead to potential issues with the employer and people not speaking more freely than they otherwise would. The issue is compounded by some of the biggest pro-management people hiding behind fake names, despite this being against facebook rules. So I'm looking to setup an independent forum for the industry.

Obviously I realise this forum itself is a php bulletin board and I have some experience in setting these up. But how about the script for front page, which I think is very neat and simple with the latest forum posts and latest industry news etc? Ideally I'd be looking for a host that could set it all up as I don't really have the time. Any help or tips on this would be greatly appreciated!

[POSTMAN]

Hi,i've just logged on after a few days away,so i've lots to catch up on,gis a couple of days to sort myself out and i'll show you some stuff.

[SpacePhoenix]

I'd like to know the name of that mod for phpbb as well

[POSTMAN]

It's not an official MOD as such,i found it on phpp.com and played around with it and got others to help....

Code: Select all

<?php
// How Many Topics you want to display?
$topicnumber = 10;


// Change this to your phpBB path
    $urlPath = "/community";


// Database Configuration (Where your phpBB config.php file is located)
    include 'community/config.php';

$table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND 
	t.forum_id != 2 AND
t.forum_id != 18 AND
t.forum_id != 5 AND
t.forum_id != 7 AND
t.forum_id != 13 AND
t.forum_id != 16 AND
t.forum_id != 17 AND
t.forum_id != 38 AND
t.forum_id != 40 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_first_post_id AND
    p.poster_id = u.user_id
        ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die("Query failed");	

print  " ";

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
	 {

            echo  "<a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]\" TARGET=\"_self\">" .$row["topic_title"] ."</a>";
            }

print "";
mysql_free_result($result);
mysql_close($link);
?>

Change the forum number with the forum where you want thread titles NOT to be shown.

Code: Select all

 t.forum_id != 4 AND 
t.forum_id != 2 AND
t.forum_id != 18 AND
t.forum_id != 5 AND
t.forum_id != 7 AND
t.forum_id != 13 AND
t.forum_id != 16 AND
t.forum_id != 17 AND
t.forum_id != 38 AND
t.forum_id != 40 AND

It can be played around to do lots of other things,like last topic answered,text from that post,and much more.
The above does the latest topic in specific forums.'FORUM LATEST' on the front page.

[POSTMAN]

Ideally I'd be looking for a host that could set it all up as I don't really have the time

No such thing as far as i'm aware,you can get a 'free' phpbb bulletin board,you can get many others as well,but they do not give you access to the server where you can add web pages ect.

You could possibly get a board with a 'portal' which does a lot of things on the front page.

http://www.phpbb3portal.com/" onclick="window.open(this.href);return false;

There are also other portals on phpbb.com

[Harry_Perkins]

Okay, thanks for that info, Postman.