FUDforum: Plugins and Code Hacks » Looking for hack...

Home » FUDforum Development » Plugins and Code Hacks » Looking for hack...

Show: Today's Messages :: Polls :: Message Navigator

Re: Looking for hack... [message #5544 is a reply to message #5538]

Sun, 08 September 2002 02:35

ezdb

Messages: 158
Registered: May 2002
Location: china

Karma:

Senior Member

it's very good Laughing

function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
include_once "/path_to/GLOBALS.php";

$cid = mysql_connect($DBHOST, $DBHOST_USER, $DBHOST_PASSWORD);

$r = mysql_db_query($DBHOST_DBNAME, "SELECT resource_id FROM ".$DBHOST_TBL_PREFIX."group_cache WHERE user_id=0 AND p_READ='Y'", $cid);

$lm='';
while( list($id) = mysql_fetch_row($r) ) $lm .= $id.',';
$lm = substr($lm, 0, -1);
$r = mysql_db_query($DBHOST_DBNAME, "SELECT
".$DBHOST_TBL_PREFIX."msg.id,
".$DBHOST_TBL_PREFIX."msg.subject
FROM
".$DBHOST_TBL_PREFIX."thread
INNER JOIN ".$DBHOST_TBL_PREFIX."msg
ON ".$DBHOST_TBL_PREFIX."thread.root_msg_id=".$DBHOST_TBL_PREFI X."msg.id
WHERE
".$DBHOST_TBL_PREFIX."thread.forum_id IN (".$lm.") AND
".$DBHOST_TBL_PREFIX."msg.approved='Y'
ORDER by
".$DBHOST_TBL_PREFIX."thread.id DESC
LIMIT ".$n_posts, $cid);
while( $obj = mysql_fetch_object($r) ) {
/* Here you do your actual code, below is a working example */
echo "<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."\"& quot; target=\"_blank\">".$obj->subject."</a>< br>\n";
}
mysql_free_result($r);
}

http://fi7pyu.free.fr/bbs/lastpost.php

[Updated on: Sun, 08 September 2002 02:43]

Report message to a moderator

[Message index]

		Looking for hack... By: heidiott on Fri, 14 June 2002 23:41
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 01:42
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 03:32
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 04:06
		Re: Looking for hack... By: cire on Wed, 13 July 2005 02:23
		Re: Looking for hack... By: Ilia on Wed, 13 July 2005 02:31
		Re: Looking for hack... By: cire on Wed, 13 July 2005 02:37
		Re: Looking for hack... By: Ilia on Wed, 13 July 2005 15:01
		Re: Looking for hack... By: cire on Wed, 13 July 2005 21:04
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 04:42
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 07:09
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 17:50
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 18:16
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 19:24
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 19:26
		Re: Looking for hack... By: cire on Wed, 13 July 2005 22:52
		Re: Looking for hack... By: Ilia on Thu, 14 July 2005 13:07
		Re: Looking for hack... By: cire on Thu, 14 July 2005 23:31
		Re: Looking for hack... By: Wild_Cat on Sat, 03 December 2005 23:17
		Re: Looking for hack... By: Ilia on Sun, 04 December 2005 16:33
		Re: Looking for hack... By: Wild_Cat on Tue, 06 December 2005 19:21
		Re: Looking for hack... By: Ilia on Tue, 06 December 2005 21:21
		Re: Looking for hack... By: Wild_Cat on Wed, 07 December 2005 20:08
		Re: Looking for hack... By: Ilia on Thu, 08 December 2005 14:25
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 19:28
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 19:32
		Re: Looking for hack... By: heidiott on Sat, 15 June 2002 19:33
		Re: Looking for hack... By: UserTom on Sat, 15 June 2002 23:29
		Re: Looking for hack... By: Ilia on Sat, 15 June 2002 23:51
		Re: Looking for hack... By: heidiott on Wed, 24 July 2002 19:00
		Re: Looking for hack... By: Ilia on Wed, 24 July 2002 20:36
		Re: Looking for hack... By: heidiott on Thu, 25 July 2002 02:22
		Re: Looking for hack... By: UserTom on Thu, 25 July 2002 10:22
		Re: Looking for hack... By: Ilia on Thu, 25 July 2002 13:33
		Re: Looking for hack... By: kewlguy on Sat, 07 September 2002 07:38
		Re: Looking for hack... By: Ilia on Sat, 07 September 2002 13:34
		Re: Looking for hack... By: kewlguy on Sat, 07 September 2002 16:51
		Re: Looking for hack... By: Ilia on Sat, 07 September 2002 20:07
		Re: Looking for hack... By: ezdb on Sun, 08 September 2002 02:35
		Re: Looking for hack... By: kewlguy on Tue, 10 September 2002 21:55
		Re: Looking for hack... By: kewlguy on Wed, 11 September 2002 03:30
		Re: Looking for hack... By: Ilia on Wed, 11 September 2002 14:54
		Re: Looking for hack... By: Sergey on Mon, 10 February 2003 16:34
		Re: Looking for hack... By: Ilia on Mon, 10 February 2003 16:39
		Re: Looking for hack... By: Sergey on Tue, 11 February 2003 00:18
		Re: Looking for hack... By: Ilia on Tue, 11 February 2003 01:57
		Re: Looking for hack... By: Sergey on Tue, 11 February 2003 23:04
		Re: Looking for hack... By: heidiott on Thu, 25 July 2002 14:08
		Re: Looking for hack... By: jonrocks on Wed, 02 April 2003 23:02
		Newest Posts with date and name ? Re: Looking for hack... By: Zoog on Tue, 08 July 2003 11:13
		Re: Newest Posts with date and name ? Re: Looking for hack... By: Wild_Cat on Sun, 27 July 2003 13:37
		Re: Newest Posts with date and name ? Re: Looking for hack... By: pinion on Thu, 13 November 2003 13:39
		Re: Newest Posts with date and name ? Re: Looking for hack... By: Wild_Cat on Fri, 02 January 2004 04:00
		Re: Looking for hack... By: Zylle on Wed, 16 June 2004 04:07
		Re: Looking for hack... By: Wild_Cat on Fri, 22 October 2004 14:54
		Re: Looking for hack... By: lilly on Sun, 04 July 2004 01:41
		Re: Looking for hack... By: zushiba on Sun, 25 July 2004 07:28
		Re: Looking for hack... By: lilly on Sun, 25 July 2004 21:17
		Re: Looking for hack... By: zushiba on Sun, 25 July 2004 23:00
		Re: Looking for hack... By: Iadnah on Sat, 03 September 2005 09:33

Previous Topic:	New threads on the front page of the site
Next Topic:	General Hacking Recommendation please

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 07:04:07 GMT 2024

Total time taken to generate the page: 0.04748 seconds