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

Home » FUDforum » FUDforum Suggestions » Unread messages
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Unread messages [message #164895 is a reply to message #164891] Wed, 30 March 2011 13:33 Go to previous messageGo to previous message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma:
Senior Member
I have fixed it on my old codebase Razz

It doesn't sort properly since a column that we need isn't indexed (Guess that can be fixed Razz) but at least it's fast and it works for my users.

Yes yes, I know, it's not synced with the latest version, sharing it anyway.

I even threw in a few comments in it because I was PLANNING to release it to you guys also! - I just never got to finish it properly Razz

I am sure there are some template changes needed also, not sure. It is near impossible for me to tell hehe.

Since there isn't an index on the column we would want to sort on, I used group by instead of sort by. Result isn't perfect, but fast.
  • Attachment: selmsg.php.t
    (Size: 11.65KB, Downloaded 1178 times)


[Updated on: Wed, 30 March 2011 13:36]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Implement postgresql ts_query
Next Topic: maillist.php support for simple machines forum?
Goto Forum:
  

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

Current Time: Sat Sep 28 00:22:45 GMT 2024

Total time taken to generate the page: 0.06098 seconds