OK, I've gotten it all worked out, with much help from Menno! This time, with the part that Menno added, if there is a URL that is so long that it would stretch the table, you don't have to worry. The part by Menno looks in the message text that would be displayed, and looks for the URL tags, and if it sees it, replaces the text of the hyperlink with the text (hyperlink). For an example, please look at my working test file,
http://www.jjr512.com/newer.html
Code:
<?
$num_active = 6;
$num_chars = 75;
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$querylatest="SELECT * FROM thread WHERE forumid='1' OR forumid='2' OR forumid='3' OR forumid='4' OR forumid='5' OR forumid='6' OR forumid='8' OR forumid='11' OR forumid='12' OR forumid='13' ORDER BY lastpost DESC LIMIT $num_active";
$resultlatest = mysql_query($querylatest,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
// Get Forum Infomation
$query_forum = "select * from forum where forumid='$latest_array[forumid]'";
$result_forum = mysql_query($query_forum,$db);
$forum_info_array = mysql_fetch_array($result_forum);
// split the date up a bit
$datestr1 = substr($latest_array["dateline"],0,10);
$datetime = substr($latest_array["dateline"],11,8);
$querythread="SELECT * FROM post WHERE threadid='$latest_array[threadid]' ORDER BY dateline ASC LIMIT 1";
$result_thread_text= mysql_query($querythread,$db);
$result_thread_array = mysql_fetch_array($result_thread_text);
$newstitle = $latest_array["title"];
$newsposter = $latest_array["postusername"];
$newsposterid = $result_thread_array["userid"];
$newsdate = date("D j M Y", $latest_array["dateline"]);
$newstext = substr(strip_tags($result_thread_array["pagetext"]),0,$num_chars);
$newsthreadid = $latest_array["threadid"];
$newscomments = $latest_array["replycount"];
$threadforumid = $latest_array["forumid"];
$threadforum = $forum_info_array["title"];
$threadiconid = $latest_array["iconid"];
// split apart long URL strings
$newstext=eregi_replace("\\[url\\]www.([^\\[]*)\\[/url\\]","<a href=\"http://www.\\1\" target=_blank>\\1</a>",$newstext);
$newstext=eregi_replace("\\[url\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>(hyperlink)</a>",$text);
$newstext=eregi_replace("\\[url=\"([^\"]*)\"\\]([^\\[]*)\\[\\/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$newstext);
$newstext=eregi_replace("\\[url=([^\"]*)\\]([^\\[]*)\\[\\/url\\]","<a href=\"\\1\" target=_blank>(hyperlink)</a>",$newstext);
//special thank-you to Menno at vBulletin Community Forum for coming up with the above part!
if ($threadiconid==0) {
$threadicon = "";
}
else {
$threadicon = "<img src=\"/bbs/images/icons/icon$threadiconid.gif\" alt=\"Thread icon\"> ";
}
if ($newscomments==1) {
$commenttext = "reply ?";
}
else {
$commenttext = "replies ?";
}
print("
<table width=\"155\" cellpadding=\"2\">
<tr>
<td width=\"150\" bgcolor=\"#0066CC\" class=\"sidebar1\">
<b>$threadicon$newstitle</b><br>
</td>
</tr>
<tr>
<td width=\"150\" class=\"sidebar1\">
Posted in <a href=\"http://www.jjr512.com/bbs/forumdisplay.php?forumid=$threadforumid\" class=\"sidebar1\">$threadforum</a> by <a href=\"http://www.jjr512.com/bbs/member.php?action=mailform&userid=$newsposterid\" class=\"sidebar1\">$newsposter</a> on $newsdate:<br>
\"$newstext...\"<br><a href=\"http://www.jjr512.com/bbs/showthread.php?threadid=$newsthreadid\" class=\"sidebar1\">$newscomments $commenttext</a><br><p>
</td>
</tr>
</table>
");
}
?>
Here is a link to a text file containing the above, in case some part gets messed up:
http://www.jjr512.com/bbs/activetopics.txt
Please note that because I could never get the global.php file to properly include, I just ended up replacing the four variables at the top for server, username, PW, and db name with the actual values. (Of course, I replaced them back before posting it here for you!
)
More Information