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 :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: 2.6.x Recent posts list with date and time [message #20642 is a reply to message #20641] Fri, 22 October 2004 21:52 Go to previous messageGo to previous message
Wild_Cat is currently offline  Wild_Cat   Ukraine
Messages: 144
Registered: November 2002
Location: Odessa, Ukraine
Karma:
Senior Member
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 21:54]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon4.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Extra User Info
Next Topic: Email Participation patch
Goto Forum:
  

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

Current Time: Wed Nov 27 10:38:08 GMT 2024

Total time taken to generate the page: 0.04443 seconds