Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#49 2006-11-15 20:10:17
- ttr
- Member
- Registered: 2006-10-26
- Posts: 34
Re: [archived] rei_recent_comments: Recent Comments Unordend List
Hi Molly.
Just change this statement $q = "select ".PFX."txp_discuss.*,".PFX."textpattern.* from ".PFX."txp_discuss left join ".PFX."textpattern on ".PFX."textpattern.ID = ".PFX."txp_discuss.parentid order by ".PFX."txp_discuss.posted desc limit 0,$limit"; in $q = "select ".PFX."txp_discuss.*,".PFX."textpattern.* from .PFX."txp_discuss left join ".PFX."textpattern on ".PFX."textpattern.ID = ".PFX."txp_discuss.parentid where ".PFX."txp_discuss.visible = '1' order by ".PFX."txp_discuss.posted desc limit 0,$limit"; <br>
It works fine for me.
Last edited by ttr (2006-11-15 20:11:38)
Offline
Re: [archived] rei_recent_comments: Recent Comments Unordend List
ttr wrote:
Hi Molly.
Just change this statement$q = "select ".PFX."txp_discuss.*,".PFX."textpattern.* from ".PFX."txp_discuss left join ".PFX."textpattern on ".PFX."textpattern.ID = ".PFX."txp_discuss.parentid order by ".PFX."txp_discuss.posted desc limit 0,$limit";in$q = "select ".PFX."txp_discuss.*,".PFX."textpattern.* from .PFX."txp_discuss left join ".PFX."textpattern on ".PFX."textpattern.ID = ".PFX."txp_discuss.parentid where ".PFX."txp_discuss.visible = '1' order by ".PFX."txp_discuss.posted desc limit 0,$limit";<br>
It works fine for me.
I have the same problem as Molly but ttr solution does not work… does anyone know why?
Happily served with Txp: Strampelli.net, Brain Essence, NicolaTranfaglia.com…
Offline
#51 2008-01-14 19:27:43
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [archived] rei_recent_comments: Recent Comments Unordend List
Hmm… old thread ;) We have wet_recent_comments now :)
Offline
Re: [archived] rei_recent_comments: Recent Comments Unordend List
Els wrote:
Hmm… old thread ;) We have wet_recent_comments now :)
Yes, I tried Wet’s plugin, but if i’m not wrong it is context sensitive, while rei’s is not…
Happily served with Txp: Strampelli.net, Brain Essence, NicolaTranfaglia.com…
Offline
#53 2008-01-14 20:17:54
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [archived] rei_recent_comments: Recent Comments Unordend List
wet’s plugin is only context sensitive when placed in an article form. It is not when placed on a page.
Offline
Re: [archived] rei_recent_comments: Recent Comments Unordend List
Els wrote:
wet’s plugin is only context sensitive when placed in an article form. It is not when placed on a page.
That’s the point indeed. In my site, the recent_comments plugin loads on every page. And I don’t like it context sensitive, as I have comments only on a few pages…
Els (or anybody els ;), do you know if there’s a way to disable this thing on wet’s plugin?
Happily served with Txp: Strampelli.net, Brain Essence, NicolaTranfaglia.com…
Offline
#55 2008-01-15 00:07:57
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [archived] rei_recent_comments: Recent Comments Unordend List
You could always ask wet :) At the time he also helped me to modify the code to suit my needs. But there doesn’t seem to be a thread for that plugin…
Offline
Re: [archived] rei_recent_comments: Recent Comments Unordend List
Els wrote:
You could always ask wet :) At the time he also helped me to modify the code to suit my needs. But there doesn’t seem to be a thread for that plugin…
Correct. I’ll try to bother wet. Let’s see if he can help me ;)
Happily served with Txp: Strampelli.net, Brain Essence, NicolaTranfaglia.com…
Offline