كود PHP:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html dir=rtl>
<head>
<!-- no cache headers -->
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="no-cache">
<meta http-equiv="Expires" content="-1">
<meta http-equiv="Cache-Control" content="no-cache">
<!-- end no cache headers -->
<meta name="keywords" content="Nabdh Alm3ani">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<title>أخر عشرة مواضيع بالمنتدى</title>
<meta http-equiv="MSThemeCompatible" content="Yes">
<style>
<!--
A:link {text-decoration: none ; color : #0066CC ; font-weight: bold}
A:visited {text-decoration: none ; color : #0066CC; font-weight: bold}
A:active {text-decoration: none ; color : #0066CC; font-weight: bold}
A:hover {text-decoration: underline ; color : #99CCFF; font-weight: bold}
//-->
</style>
</head>
<body background="" id="all" rightmargin="2" leftmargin="0" topmargin="3" marginwidth="0" marginheight="0" scroll=no font-weight: bold>
<?
require("includes/config.php");
/////////////// CONFIG ///////////////
//
// لا تضع علامة ( / ) عند تحديد المسارات
$path = "includes"; // مسار ملف config.php في مجلد المنتدى
$url = "http://www.myweb.com/vb"; // مسار موقع المنتدى
$maxthreads = "10"; // العدد الذي تريد عرضه من المواضيع في آخر المشاركات
$ob = "lastpost"; // set to one of the following: replycount , views , lastposter , title , lastpost (lastpost is most popular. it's the thread most recently replied to, then the second-to-last most recent, etc.)
$obdir = "desc"; // المجلد الذي يتم فيه الترتيب which direction to sort? "desc" goes from bottom to top (9 to 1, z to a, etc.). "asc" goes top to bottom (1 to 9, a to z, etc.). if you use lastpost for $ob, leave this set to desc or it will not work correctly!
$lastposter = "1"; // عرض آخر كاتبshow last poster? 1 = yes; 0 = no
$replies = "0"; // عرض إحصاء الرد show reply count? 1 = yes; 0 = no
$lastpostdate = "0"; // عرض تاريخ ووقت آخر رد show last post date and time? 1 = yes; 0 = no
$len = 25 ; // أقصى عدد من الاحرف لعرضها في الموضوع maximum number of characters of the title to show. e.g. if the title is 60 characters and this is set to 25, only the first 25 characters of the title will be shown (followed by ...)
$excludeforums = ""; // if you want to exclude a forum, put it's ID here. more than one, seperate them with commas, NO SPACES! e.g. 1,2,3,4
$includeforums = ""; // إذا تريد تحديد منتدى معين ضع رقمه هنا if you only want to include certain forums, put their ids here. separate more than one with commas, NO SPACES! e.g. 1,2,3,4
$db = mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) or die("Could not connect");
mysql_select_db($config['Database']['dbname'], $db) or die("غير قادر على الاتصال بقاعدة البيانات");
$hfs = $fs+2;
$fs .= "pt";
$hfs .= "pt";
$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 <b>one</b> of these two to proceed.");
exit;
}
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]'";
}
}
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;
}
}
$query = "SELECT thread.lastpost,thread.title,thread.lastposter,thread.replycount,thread.views,user.userid,thread.threadid,thread.forumid,thread.iconid FROM thread,user $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads";
$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);
while ($threads = mysql_fetch_array($tr)) {
echo " <a href=\"$url/showthread.php?=$session[sessionhash]&threadid=$threads[threadid]&goto=newpost\" title=\"$threads[title]\" target=_blank><font color=\"#000000\">$threads[title]</font></a>";
echo "<br/>";
}
?>