هذا هاك اااااخر 10 مواضيع المطور نسبياً انا اشوف انه افضل من هذا الي راكب بالمنتدى تقل يمشي على ديزل
كود PHP:
<head>
<style type="text/css">
<!--
.main { text-decoration: none; color: #000000;
font-family: MS Sans Serif; font-size: 12pt;}
-->
</style>
<style>
<!--
A:link, A:visited, A:active {
COLOR: #7E1236;
TEXT-DECORATION: none;
}
A:hover {
COLOR: #C02C5D;
TEXT-DECORATION: none;
}
//-->
</style>
</head>
<body bgcolor="#EFF7E0" background="zayed/bg2.jpg" text="#7E1236" BGPROPERTIES=fixed rightmargin="0" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" ondragstart="return false">
<?
//...........Last X Posts v1.0.5...........\\
//......by Kevin (kevin@tubescan.com)......\\
// For vBulletin version 2 (betas 3, 4, 5, RC1, RC2, RC3)
// (c) 2001 Jelsoft Enterprises, Ltd.
// vBulletin.com thread: http://www.vbulletin.com/forum/showthread.php?threadid=12324
// let's get connected
require("last10config.php");
require("includes/config.php");
echo "<FONT><marquee scrollAmount=2 onMouseover=\"this.scrollAmount=1\" onMouseout=\"this.scrollAmount=2\" direction=\"right\">";
$db=mysql_connect($servername,$dbusername,$dbpassw ord) or die("Can't open connection to MySQL");
mysql_select_db($dbname) or die("Can't select database");
$hfs = $fs+2;
$fs .= "pt";
$hfs .= "pt";
// 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 <b>one</b> 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;
}
}
// ooh a query!
$query = "SELECT thread.lastpost,thread.title,thread.lastposter,thr ead.postusername,thread.replycount,thread.views,us er.userid,thread.threadid,thread.forumid,thread.ic onid FROM thread,user $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);
// let's display the info
while ($threads = mysql_fetch_array($tr)) {
echo "<FONT dir=\"rtl\" SIZE=\"1\" FACE=\"MS Sans Serif\"><a href=\"$url/showthread.php?t=$threads[threadid]&goto=newpost\" title=\"عدد الردود : $threads[replycount] عدد القراءات: $threads[views]\" target=_blank>$threads[title]</a> ( الكاتب:   $threads[postusername] آخر رد : $threads[lastposter] )</font> ";
}
// close it all up
// bye!?></marquee>
