 |
|
| \n");
if ($showicon == "1") {
echo("| | ");
}
// the last poster column,
if ($lastposter == "1") {
echo("Last Poster | \n");
}
// the last post date & time column,
if ($lastpostdate == "1") {
echo("Last Post | \n");
}
// the views column,
if ($views == "1") {
echo("Views | \n");
}
// and/or the replies column
if ($replies == "1") {
echo("Replies | \n");
}
echo(" \n");
// the base WHERE statement
$wheresql = "WHERE thread.lastposter=user.username AND thread.open!='10'";
// we can't have both the last 24 hours *and* the last 7 days, so error out if needed
if ($last24 == "1" && $last7 == "1") {
print("Error: \$last24 and \$last7 are both set to 1. Please change one of them to 0.");
exit;
}
// otherwise we're gonna find out which one it is
// last 24
if ($last24 == "1") {
$time = time()-86400;
$wheresql .= " AND thread.lastpost>'$time'";
}
// last 7
if ($last7 == "1") {
$time = time()-604800;
$wheresql .= " AND thread.lastpost>'$time'";
}
// are we trying to exclude *and* include forums? if so, error out
if ($excludeforums != "" && $includeforums != "") {
print("Error: \$includeforums and \$excludeforums are both set with numbers. Please remove the numbers from one of these two to proceed.");
exit;
}
// otherwise figure out which one we're using
// include forums
if ($includeforums == "" or $includeforums <= "0") {
$quarter = "no";
} else {
$incfid = explode(",",$includeforums); $i = 0; $a = count($incfid);
if ($a > 1) {
$wheresql .= " AND (thread.forumid='$incfid[0]'";
++$i;
while ($i < $a) {
$wheresql .= " OR thread.forumid='$incfid[$i]'"; ++$i;
}
$wheresql .= ")";
} else {
$wheresql .= " AND thread.forumid='$incfid[$i]'";
}
}
// or exclude forums
if ($excludeforums == "" or $excludeforums <= "0") {
$quarter = "no";
} else {
$excfid = explode(",",$excludeforums); $i = 0; $a = count($excfid);
while ($i < $a) {
$wheresql .= " AND thread.forumid!='$excfid[$i]'"; ++$i;
}
}
if ($showforumtitle == "1") {
$ftitle = ",forum";
$fsel = ",forum.title AS ftitle";
$wheresql .= " AND thread.forumid=forum.forumid";
}
// ooh a query!
$query = "SELECT thread.lastpost,thread.title,thread.lastposter,thread.replycount,thread.views,user.userid,thread.threadid,thread.forumid$fsel,thread.iconid FROM thread,user$ftitle $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads";
// let's get the info
$tr = mysql_query($query) or die("MySQL reported this error while trying to retreive the info: ".mysql_error());
$dtf = mysql_query("SELECT value FROM setting WHERE varname='dateformat' OR varname='timeformat' OR varname='timeoffset' ORDER BY varname");
$df = mysql_result($dtf,0,0);
$tf = mysql_result($dtf,1,0);
$tof = mysql_result($dtf,2,0);
if ($showdate == "1") {
$fdt = "$df $tf";
} else {
$fdt = "$tf";
}
$cols = 1;
// let's display the info
while ($threads = mysql_fetch_array($tr)) {
// are we going to show the message too?
if ($showmessages == "1") {
$query0 = "SELECT pagetext,postid,dateline,iconid FROM post WHERE threadid='$threads[threadid]' ORDER BY dateline DESC LIMIT 1";
$lastpost = mysql_query($query0) or die("MySQL reported this error while trying to retrieve the last post info: ".mysql_error());
while ($lastpost1 = mysql_fetch_array($lastpost)) {
$lastpostshort = $lastpost1[pagetext];
$postii = $lastpost1[iconid];
}
if (strlen($lastpostshort) > $lplen) {
$lastpostshort = substr($lastpostshort,0,$lplen);
$lastpostshort .= "...";
}
$smilies = mysql_query("SELECT smilietext,smiliepath FROM smilie");
while ($smiles = mysql_fetch_array($smilies)) {
$lastpostshort = str_replace($smiles[smilietext],"![](\"".$url."/".$smiles[smiliepath]."\") ",$lastpostshort);
}
if ($nb == "1") {
$lastpostshort = nl2br($lastpostshort);
}
$lastpostshort = str_replace("[i]","",$lastpostshort);
$lastpostshort = str_replace("[/i]","",$lastpostshort);
$lastpostshort = str_replace("[u]","",$lastpostshort);
$lastpostshort = str_replace("[/u]","",$lastpostshort);
$lastpostshort = str_replace("[b]","",$lastpostshort);
$lastpostshort = str_replace("[/b]","",$lastpostshort);
$lastpostshort = str_replace("[quote]","
quote:
",$lastpostshort);
$lastpostshort = str_replace("[/quote]","
\n",$lastpostshort);
$lastpostshort = str_replace("[I]","",$lastpostshort);
$lastpostshort = str_replace("[/I]","",$lastpostshort);
$lastpostshort = str_replace("[U]","",$lastpostshort);
$lastpostshort = str_replace("[/U]","",$lastpostshort);
$lastpostshort = str_replace("[B]","",$lastpostshort);
$lastpostshort = str_replace("[/B]","",$lastpostshort);
$lastpostshort = str_replace("[QUOTE]","
quote:
",$lastpostshort);
$lastpostshort = str_replace("[/QUOTE]","
\n",$lastpostshort);
$lastpostshort = str_replace("[CODE]","
code:
",$lastpostshort);
$lastpostshort = str_replace("[/CODE]","
\n",$lastpostshort);
$lastpostshort = str_replace("[code]","
code:
",$lastpostshort);
$lastpostshort = str_replace("[/code]","
\n",$lastpostshort);
$lastpostshort = str_replace("[img]","",$lastpostshort);
$lastpostshort = str_replace("[/img]","",$lastpostshort);
$lastpostshort = str_replace("[IMG]","",$lastpostshort);
$lastpostshort = str_replace("[/IMG]","",$lastpostshort);
$lastpostshort = str_replace("[url]","",$lastpostshort);
$lastpostshort = str_replace("[/url]","",$lastpostshort);
$lastpostshort = str_replace("[URL]","",$lastpostshort);
$lastpostshort = str_replace("[/URL]","",$lastpostshort);
}
// thanks to kier for this idea to do the alternating row colors
if (($counter++ % 2) != 0) {
$bc=$bc1;
} else {
$bc=$bc2;
}
// if the title is more than $len characters, we need to cut it off and add ... to the end
if (strlen($threads[title]) > $len) {
$title = substr($threads[title],0,$len);
$title .= "...";
} else {
$title = $threads[title];
}
// convert the date to a format readable by non-unix geeks :)
$fd = date($fdt,$threads[lastpost]);
// display everything in a nice table. in the future we're gonna try to do this so others can format the data, but this is sufficient for now
echo("");
if ($showicon == "1") {
echo("");
if ($postii != "0" && $postii != "") {
echo("![](\"$urlimg/icons/icon$postii.gif\") ");
}
if (($postii == "0" || $postii == "") && $threads[iconid] != "0" && $threads[iconid] != "") {
echo("![](\"$urlimg/icons/icon$threads[iconid].gif\") ");
}
if (($postii == "0" || $postii == "") && ($threads[iconid] == "0" || $threads[iconid] == "")) {
echo(" ");
}
echo(" | ");
++$cols;
}
echo("");
if ($showforumtitle == "1") {
echo("$threads[ftitle]: ");
}
echo("![](\"/img/blt.gif\") $title | \n");
// last poster column?
if ($lastposter == "1") {
echo("$threads[lastposter] | \n");
++$cols;
}
// the last post date & time column,
if ($lastpostdate == "1") {
echo("$fd | \n");
++$cols;
}
// views column?
if ($views == "1") {
echo("$threads[views] | \n");
++$cols;
}
// replies column?
if ($replies == "1") {
echo("$threads[replycount] | \n");
++$cols;
}
echo(" ");
// are we showing the last post?
if ($showmessages == "1") {
echo("\n");
echo("\n");
echo("| Last Post: | \n");
echo("$lastpostshort | \n");
echo(" | \n");
}
$fd = "";
}
// close it all up
echo(" ");
// bye!
?>
|
|
