FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Plugins and Code Hacks » 2.6.x Recent posts list with date and time
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
2.6.x Recent posts list with date and time [message #20639] Fri, 22 October 2004 10:51 Go to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
I make a topic apart since it was buried into a large theme
There was a code to pull a desired number of posts onto any page written for version 2.5.x
The code is here: http://fudforum.org/forum/index.php?t=tree&th=591&mid=12061&&am p;rev=&reveal=

But due to the changes in DB structure in 2.6.x versions it doesn't work any more. I made a quick modification so that it does works, but I have certain questions for the developers of FUD to make sure the posts list is pulled right taking into consideration all restictions, please:

1)
Old query:
SELECT resource_id FROM ".$tbl."group_cache 
                         WHERE user_id=0 AND p_READ='Y'

New query:
SELECT resource_id FROM ".$tbl."group_cache 
                         WHERE group_id=0

Question:
Where the check for read permission did go so that it could be considered in the query?

2)
Old query segment causing troubles:
WHERE
".$tbl."thread.forum_id IN (".$lm.") AND                                        
".$tbl."msg.approved='Y'

New Query:
WHERE
".$tbl."thread.forum_id IN (".$lm.") AND 
".$tbl."msg.apr=1

Question:
I am not sure that apr field takes track if the message was approved... What does?

If those questions answered, I will post the new code working for 2.6.x database structure. For now this quick hack is working here: http://avalon.net.ua/forum.php (russian language) with FUDforum 2.6.7

Another helpful improvement would be to know how the links to the thread or message are generated, so that the hardcoded link would change e.g. for path_info style template automatically depending on forum preferences (if possible at all? or easier to change the url bu hand when the change is made? not too often anyway). OR is it better I remember for security reasons to give link just to rview and is uid=0 needed for security set as 0 in this link?


Lady of Avalon
Re: 2.6.x Recent posts list with date and time [message #20641 is a reply to message #20639] Fri, 22 October 2004 12:42 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Permissions in 2.6+ are stored as a bitmask.

You can find out what each bit controlls by looking inside sql/fud_group_cache.tbl

For the message table this information can be found inside
sql/fud_msg.tbl


FUDforum Core Developer
Re: 2.6.x Recent posts list with date and time [message #20642 is a reply to message #20641] Fri, 22 October 2004 17:52 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Oh, thanks. I see that I guessed right as to msg.apr, OK

But bit operations are above my understanding as of yet Sad
For more, to make selection basing on group_cache_opt I guess it should be an index for performace reasons too?
I don't quite understand anyway what all this table does and those options neither (not to mention I don't get how explanations are converted to that data I see in the table), honestly. Remember, initially I took your code (old queries) example and my work was only smoothing it.

What if I make initial selection in fud_group_cache basing on
group_id=0 and user_id=0
does it make the trick of selecting only resources with overall (anonymous) permission to read?

Although... For now it seems it does the trick the way I wrote it anyways, just a little optimization for initial selection number of rows?...


Lady of Avalon

[Updated on: Fri, 22 October 2004 17:54]

Report message to a moderator

Re: 2.6.x Recent posts list with date and time [message #20643 is a reply to message #20642] Fri, 22 October 2004 18:37 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
γΙΤΑΤΑ:

What if I make initial selection in fud_group_cache basing on
group_id=0 and user_id=0
does it make the trick of selecting only resources with overall (anonymous) permission to read?


Nope, it doesn't. I modified the query and made a restricted forum to see how this will work... I guess I've got the whole thing wrong.
SO I do have to deal with those bits? It's beyond my understanding and time for study now.
Could anybody be so kind to just tell the query part selecting only p_READ from fud_group_cache.group_cahe_opt?....


Lady of Avalon
Re: 2.6.x Recent posts list with date and time [message #20646 is a reply to message #20643] Fri, 22 October 2004 18:48 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
you need to use the bit field to get permissions, without it you are just fetching random data.

FUDforum Core Developer
Re: 2.6.x Recent posts list with date and time [message #20650 is a reply to message #20643] Fri, 22 October 2004 19:08 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Okay, may be this is ugly but it does work to show only posts where anonymous have permission to read. The query is then
SELECT resource_id FROM ".$tbl."group_cache 
                         WHERE user_id=0 AND
                         group_cache_opt>>1&1=1


Lady of Avalon
icon4.gif  THE CODE! for Recent posts list with date and time [message #20652 is a reply to message #20639] Fri, 22 October 2004 19:20 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
OK, here goes the working code with right permissions:

<?php
function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
        include_once "YOUR_PATH_TO/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
                                        FROM
                                                ".$tbl."thread
                                        INNER JOIN ".$tbl."msg
                                                ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
                                        WHERE
                                                ".$tbl."thread.forum_id IN (".$lm.") AND
                                                ".$tbl."msg.apr=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 "<p><SPAN CLASS=\"date\">".$tm."</SPAN> - 
                <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."\">&raquo;&raquo;</a></p>\n";
        }
        mysql_free_result($r);
}
?>

Put this in your file apart or in the place you need.
Then make a call for it:
<?php
fetch_forum_posts(10);
?>

Done
*Phew*


Lady of Avalon

[Updated on: Fri, 22 October 2004 19:23]

Report message to a moderator

Re: 2.6.x Recent posts list with date and time [message #20655 is a reply to message #20639] Fri, 22 October 2004 20:18 Go to previous messageGo to next message
Abraxa is currently offline  Abraxa   Germany
Messages: 72
Registered: August 2004
Location: Germany
Karma: 0
Member
add to buddy list
ignore all messages by this user
group_cache_opt>>1&1=1 <~ group_cache_opt&2=2 probably is causing less confusion on someone who isn't familiar with bit operations and wants to understand the code. It works nevertheless, though.

-Abraxa
Re: 2.6.x Recent posts list with date and time [message #20659 is a reply to message #20655] Sat, 23 October 2004 07:44 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Abraxa, this is me who is not familiar with bit operations (if you read my previous panic questions about it)! Very Happy At least hasn't been until yesterday.

What you say was about what I was thinking at first, but counting that it is possible (even if not commonly logical) to make permissions visible=0 and readable=1 means you will get in this case 3 with your code!

I mean, if you have
10
&
10
--
11

or did I get the operation meaning wrong?

I thought it's just safer to be independent from visible if I move one bit right and only take into account readable permission.


Lady of Avalon

[Updated on: Sat, 23 October 2004 08:00]

Report message to a moderator

Re: THE CODE! for Recent posts list with date and time [message #21200 is a reply to message #20652] Fri, 19 November 2004 12:11 Go to previous messageGo to next message
viktor is currently offline  viktor   United States
Messages: 12
Registered: November 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
How to add the user name or alias?
I mean the recent posts view like this:
http://www.visaforyou.org/forum/recent.php
Re: THE CODE! for Recent posts list with date and time [message #21204 is a reply to message #21200] Fri, 19 November 2004 18:27 Go to previous messageGo to next message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Then you'll have to make a call to one more table for user alias...
May be the easiest way - to ask the forum owner for the code all done the way you want? He does have FUD, so he did this hack, only didn't care to share? Hopefully not for greediness, although it's easy to add, I just can't get hands on my db right now (connection problems) to look for needed columns to call.


Lady of Avalon
Re: THE CODE! for Recent posts list with date and time [message #21207 is a reply to message #21204] Sat, 20 November 2004 09:36 Go to previous messageGo to next message
viktor is currently offline  viktor   United States
Messages: 12
Registered: November 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
OK, i want to have the

users.alias

instead

msg.poster_id

Please, advise!



<?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."thread.views,
                                                ".$tbl."thread.replies,
                                                ".$tbl."msg.poster_id
                                        FROM
                                                ".$tbl."thread
                                        INNER JOIN ".$tbl."msg
                                                ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
                                        WHERE
                                                ".$tbl."thread.forum_id IN (".$lm.") AND
                                                ".$tbl."msg.apr=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);
                print "<tr>";
                print "<td class=\"RowStyleA\">#</td>";
                print "<td  class=\"RowStyleB\">";
                print "<a title=\"Перейти к теме\" mclass =\"menubar\" href=\"";
                print $WWW_ROOT . "index.php?t=msg&goto=" . $obj->id . "\"><b> " . $obj->subject;
                print "</b></a></td>";
                print "<td  class=\"RowStyleA\">";
                print strftime("%d %b %H:%M", $obj->last_post_date);
                print "</td>";
                print "<td class=\"RowStyleB\" align=\"center\">". $obj->replies ." / ". $obj->views . "</td>";
                print "<td class=\"RowStyleA\" align=\"center\"><a class=\"GenLink\" href=\"";
                print $WWW_ROOT ."index.php?t=usrinfo&id=". $obj->poster_id. "\">". $obj->poster_id ."</td></tr>";
        }
        mysql_free_result($r);
}
?>
<?php
fetch_forum_posts(34);
?>

[Updated on: Sat, 20 November 2004 21:54]

Report message to a moderator

Re: THE CODE! for Recent posts list with date and time [message #22380 is a reply to message #21207] Mon, 31 January 2005 04:17 Go to previous message
cellarius is currently offline  cellarius   Germany
Messages: 6
Registered: January 2005
Location: Augsburg/Germany
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi,

try this - works fine for me:

<?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."thread.views,
                                                ".$tbl."thread.replies,
                                                ".$tbl."msg.poster_id,
                                                ".$tbl."users.alias
                                        FROM
                                                ".$tbl."thread
                                        INNER JOIN ".$tbl."msg
                                                ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
					INNER JOIN ".$tbl."users
						ON ".$tbl."msg.poster_id=".$tbl."users.id	
                                        WHERE
                                                ".$tbl."thread.forum_id IN (".$lm.") AND
                                                ".$tbl."msg.apr=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);
			    print "<tr>";
                print "<td class=\"RowStyleA\">#</td>";
                print "<td  class=\"RowStyleB\">";
                print "<a title=\"??????? ? ????\" mclass =\"menubar\" href=\"";
                print $WWW_ROOT . "index.php?t=msg&goto=" . $obj->id . "\"><b> " . $obj->subject;
                print "</b></a></td>";
                print "<td  class=\"RowStyleA\">";
                print strftime("%d %b %H:%M", $obj->last_post_date);
                print "</td>";
                print "<td class=\"RowStyleB\" align=\"center\">". $obj->replies ." / ". $obj->views . "</td>";
                print "<td class=\"RowStyleA\" align=\"center\"><a class=\"GenLink\" href=\"";
                print $WWW_ROOT ."index.php?t=usrinfo&id=". $obj->poster_id. "\">". $obj->alias ."<br></td></tr>";
        }
        mysql_free_result($r);
}
?>
<?php
fetch_forum_posts(34);
?>


HTH,

Sven
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Extra User Info
Next Topic: Email Participation patch
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 21 21:13:08 EDT 2017

Total time taken to generate the page: 0.00863 seconds