Okay, the "recent forum posts" block is finished. Wanna know how fun it was?:)
// let's get down to bitness
if(!$ibr_db_connection) // if another one of my excellent mods hasn't already made a connection :)
{
$ibr_db_connection = mysql_connect($ibr_sql_host, $ibr_sql_user, $ibr_sql_password);
if(!$ibr_db_connection)
{
echo "<div style=\"font-color:#ff0000; font-weight:bold;\">Error: Could not connect to database server</div>";
}
else
{
$ibr_db = mysql_select_db($ibr_sql_dbname, $ibr_db_connection);
if(!ibr_db)
{
echo "<div style=\"color:#ff0000; font-weight:bold;\">Error: Could not select database</div>";
}
}
}
if ($HTTP_COOKIE_VARS["member_id"] == 0) // if we don't have a member ID
{
// Yer a guest
$ibr_group_id = "2";
}
else
{
// Validate the user
if ($ibr_global_user == "yes")
{
// if we have the global user function then the user is already validated.
if ($guest == 1)
{
// if the Global User function decided that the user is a guest, then they're a guest
$ibr_group_id = "2";
}
else
{
// we can use the $r array to find out the group number.
$ibr_group_id = $r['g_id'];
}
}
else
{
$ibr_query = mysql_query("SELECT mgroup FROM ".$ibr_table_prefix."members WHERE id=".$HTTP_COOKIE_VARS['member_id']." AND password='".$HTTP_COOKIE_VARS['pass_hash']."'", $ibr_db_connection);
if(!$ibr_query)
{
echo "<div style=\"color:#ff0000; font-weight:bold;\">Error: Could not Verify Member Group: ".mysql_error()."</div>";
}
else
{
if (mysql_numrows($ibr_query) == 0)
{
$ibr_group_id = "2";
}
else
{
$ibr_result = mysql_fetch_row($ibr_query);
$ibr_group_id = $ibr_result[0];
}
}
}
}
// Finally, let us now grab the top ten topics!
$ibr_query = mysql_query("SELECT DISTINCT t.tid, t.title, t.last_poster_name, t.last_poster_id, t.forum_id, t.last post, f.read_perms FROM ".$ibr_table_prefix."topics t INNER JOIN ".$ibr_table_prefix."forums f ON t.forum_id = f.id ORDER BY t.last_post DESC LIMIT ".$ibr_limit, $ibr_db_connection);
if (!$ibr_query)
{
$show .= "<div style=\"color:#ff0000; font-weight:bold;\">Error: Could not execute topic lookup query</div>";
}
else
{
while($ibr_result = mysql_fetch_array($ibr_query))
{
$ibr_allow = "no";
if ($ibr_result['read_perms'] == "" OR $ibr_result['read_perms']==" " OR $ibr_result['read_perms'] == "*")
{
// permissions are set to "all"
$ibr_allow = "yes";
}
else
{
$ibr_read_perms = explode(",", $ibr_result['read_perms']);
for($i = 0; $i < sizeof($ibr_read_perms); $i++)
{
if($ibr_group_id == $ibr_read_perms[$i])
{
$ibr_allow = "yes";
}
}
}
if($ibr_allow=="yes")
{
$content .= "<b>»<a href=\"/".$ibr_ibf_path."?act=ST&f=".$ibr_result[4]."&t=".$ibr_result[0]."&view=getnewpost\">".$ibr_result[1]."</a></b> <i>by ";
if($ibr_result[3] != 0)
{
$content .= "<a class=\"quicklinks\" href=\"".$ibr_ibf_path."?act=Profile&CODE=03&MID=".$ibf_result[3]."\">".$ibr_result[2]."</a></i><br/><br/>\n";
}
else
{
$content .= $ibr_result[2]."</i><br/><br/>\n";
}
}
}
mysql_free_result($ibr_query);
}
// the end.
?>
Of course, I didn't author the code, just modified it to work with our website.
<!--EDIT|achtungbaby|Aug 7 2002, 12:09 PM-->