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 #5630 is a reply to message #5544]

Tue, 10 September 2002 21:55

kewlguy

Messages: 9
Registered: August 2002
Location: Gainesville

Karma:

Junior Member

Ok, finally got it to work, it took this code:
<?php
// n_posts is the number of messages you wish to fetch
function fetch_forum_posts($n_posts)
{
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
print "�  <a class =\"menubar\" href=\"";
print $WWW_ROOT . "index.php?t=msg&goto=" . $obj->id . "\" target=\"_blank\">" . $obj->subject;
print "</a><br>\n";
}

mysql_free_result($r);

}
?>

Thanks everyone!

[Updated on: Tue, 10 September 2002 21:56]

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:36:36 GMT 2024

Total time taken to generate the page: 0.04853 seconds