// Bulletin Board Configuration ############
$bb_host = "localhost";
$bb_dbname = "phpbb";
$bb_dbuser = "root";
$bb_dbpasswd = "password";
$bb_url = "forums/";
$bb_panel = $bb_url."profile.php";
$bb_whatsnew = $bb_url."profile.php";
$bb_pms = $bb_url."profile.php";
$bb_cookie = "";
$bb_private = ""; // private forums. For example: 4,11 will exclude forum 4 & 11
// #################################
if ($bb_private) {
if (preg_match("/,/i",$bb_private)) {
$asql = "WHERE ";
$forums = explode(",",$bb_private);
for($i=0;$i<count($forums);$i++) {
$asql .= "NOT(forum_id = '$forums[$i]')";
if ($i<count($forums)-1) $asql .= " AND ";
}
} else {
$asql = "WHERE NOT(forum_id = '$forums')";
}
}
function BBConnect() {
global $bb_host, $bb_dbname, $bb_dbuser, $bb_dbpasswd;
mysql_connect($bb_host,$bb_dbuser,$bb_dbpasswd);
mysql_select_db("$bb_dbname");
}
function BBGetTopics() {
global $bb_url,$asql;
BBConnect();
$bb_data = array();
$result = mysql_query("SELECT topic_id, topic_title FROM
phpbb_topics $asql ORDER BY topic_id DESC LIMIT 10");
if (!$result) {
echo mysql_errno().mysql_error();
exit;
}
while(list($threadid, $title) = mysql_fetch_row($result)) {
array_push($bb_data, $bb_url."viewtopic.php?t=$threadid||~||$title");
}
return $bb_data;
}
function BBGetUser($username, $password) {
BBConnect();
$result = mysql_query("SELECT *
FROM phpbb_users WHERE user_active = '1' AND username = '$username'");
$userdata = mysql_fetch_array($result);
($userdata[user_password] == $password) ? $pwok = 1 : $pwok = 0;
return $pwok;
}
function BBCheckUser($username, $email) {
BBConnect();
$result = mysql_query("SELECT * FROM phpbb_users WHERE
username = '$username' OR username = '$username' OR
user_email = '$email'");
(mysql_num_rows($result)) ? $pwok = 1 : $pwok = 0;
return $pwok;
}
function BBUserInsert($username, $password, $birthday, $email, $ipaddress) {
BBConnect();
$result = mysql_query("SELECT user_id FROM
phpbb_users ORDER BY user_id DESC LIMIT 1");
list ($userid) = mysql_fetch_row($result);
$userid++;
$regdate = time();
mysql_query("INSERT INTO phpbb_users (user_id,
username, user_password, user_email, user_style, user_lang,
user_viewemail, user_attachsig, user_regdate, user_avatar,
user_website, user_from, user_sig, user_sig_bbcode_uid
, user_icq, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey)
VALUES ('$userid','$username','$password',
'$email','1','english','0','0','$regdate','','','','','','','','','','','','')");
dbconnect();
}
function BBUserCount($username) {
BBConnect();
mysql_query("UPDATE phpbb_users SET
user_posts=user_posts+1 WHERE username = '$username'");
dbconnect();
}
function BBGrabSig($username) {
BBConnect();
$query = mysql_query("SELECT user_sig
FROM phpbb_users WHERE username = '$username'");
list($signature) = mysql_fetch_row($query);
return $signature;
}
function BBGetXML() {
global $bb_url,$configs,$asql;
BBConnect();
$bb_data = array();
$result = mysql_query("SELECT topic_id,
topic_title, topic_replies FROM phpbb_topics $asql
ORDER BY topic_id DESC LIMIT 20");
while(list($threadid, $title, $replies) = mysql_fetch_row($result)) {
array_push($bb_data, $configs[6]."/".$bb_url."viewtopic.php?t
=$threadid||~||$title||~||Replies: $replies");
}
return $bb_data;
}
function BBGetEmail($username) {
BBConnect();
$query = mysql_query("SELECT user_email
FROM phpbb_users WHERE username = '$username'");
list($email) = mysql_fetch_row($query);
return $email;
}
function BBLastTopics($date) {
BBConnect();
$query = mysql_query("SELECT *
FROM phpbb_topics WHERE topictime > ('$date')");
$bb_new = mysql_num_rows($query);
return $bb_new;
}
function BBPMs($user) {
return 0;
}
function BBCookieInit($username, $password) {
global $bb_cookie;
BBConnect();
$result = mysql_query("SELECT *
FROM phpbb_users WHERE username = '$username'");
$userdata = mysql_fetch_array($result);
$thiscookie[userid] = $userinfo[userid];
$thiscookie[autologinid] = $password;
setcookie($bb_cookie."_data",urlencode(serialize($thiscookie)));
}
function BBCookieFlush() {
global $bb_cookie;
setcookie($bb_cookie."_data",0);
}
?>
