| last posts help [message #30540] |
Thu, 02 March 2006 04:01  |
oswdcn
Messages: 5
Registered: March 2006
Karma:
|
Junior Member |
|
|
<?php
function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
include_once "./GLOBALS.php";
$cid = mysql_connect($DBHOST, $DBHOST_USER, $DBHOST_PASSWORD);
$tbl = $DBHOST_TBL_PREFIX;
$r = mysql_db_query($DBHOST_DBNAME, "SELECT resource_id
FROM ".$tbl."group_cache
WHERE user_id=0
AND group_cache_opt>>1&1=1", $cid);
$lm='';
while( list($id) = mysql_fetch_row($r) ) $lm .= $id.',';
$lm = substr($lm, 0, -1);
$r = mysql_db_query($DBHOST_DBNAME, "SELECT
".$tbl."msg.id,
".$tbl."msg.subject,
".$tbl."thread.last_post_date,
".$tbl."thread.last_post_id,
".$tbl."forum.id
FROM
".$tbl."thread
INNER JOIN ".$tbl."msg
ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
INNER JOIN ".$tbl."msg
ON ".$tbl."forum.id=".$tbl."msg.id
WHERE
".$tbl."thread.forum_id IN (".$lm.") OR
".$tbl."msg.apr=1 OR ".$tbl."forum.id=1
ORDER by
".$tbl."thread.last_post_id DESC
LIMIT ".$n_posts, $cid);
while( $obj = mysql_fetch_object($r) ) {
/* Here you do your actual code, below is a working example */
$tm = date("d/m/Y H:i", $obj->last_post_date);
echo "<SPAN CLASS=\"date\">".$tm."</SPAN> - <img src=http://fi7pyu.free.fr/bbs/theme/default/images/goto.gif vspace=3 align=middle>
<a href=\"".$WWW_ROOT."index.php?t=msg&goto=".$obj->id."\">".$obj->subject."</a>
<a href=\"".$WWW_ROOT."index.php?t=tree&goto=".$obj->last_post_id."\">»»</a><br>\n";
}
mysql_free_result($r);
}
?>
<?php
fetch_forum_posts(30);
?>
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /www/users/oswd.cn/fudforum/1.php on line 35
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/users/oswd.cn/fudforum/1.php on line 42
------------
Why???
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]