\n"); if ($showicon == "1") { echo(" "); } echo("Themenbereich : Thema\n"); // the last poster column, if ($lastposter == "1") { echo("letzter Beitrag von\n"); } // the last post date & time column, if ($lastpostdate == "1") { echo("letzter Beitrag\n"); } // the views column, if ($views == "1") { echo("Hits\n"); } // and/or the replies column if ($replies == "1") { echo("Antworten\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],"",$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(""); } if (($postii == "0" || $postii == "") && $threads[iconid] != "0" && $threads[iconid] != "") { echo(""); } if (($postii == "0" || $postii == "") && ($threads[iconid] == "0" || $threads[iconid] == "")) { echo(" "); } echo(""); ++$cols; } echo(""); if ($showforumtitle == "1") { echo("$threads[ftitle]: "); } echo("$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("\n"); echo("\n"); echo("
Last Post:$lastpostshort
\n"); } $fd = ""; } // close it all up echo(""); // bye! ?>