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 #4385 is a reply to message #3253]

Thu, 25 July 2002 02:22

heidiott

Messages: 34
Registered: May 2002

Karma:

Member

Ah ha... I got it Very Happy

Thanks to your help.
Here is the new code for others who would like to use it with version 2.2.3...

<?php
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 fud_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
fud_msg.id,
fud_msg.subject
FROM
fud_thread
INNER JOIN fud_msg
ON fud_thread.root_msg_id=fud_msg.id
WHERE
fud_thread.forum_id IN (".$lm.") AND
fud_msg.approved='Y'
ORDER by
fud_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://www.yoursite.com/forum/styles/default/goto.gif vspace=3 align=middle> <a href=\"".$WWW_ROOT."msg.php?goto=".$obj->id."\& quot;>".$obj->subject."</a><br>\n";
}
mysql_free_result($r);
}
?>

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 06:21:46 GMT 2024

Total time taken to generate the page: 0.04126 seconds