Ha! This is true! I do only have one post in this forum...I guess my question should be, how do I list threads from ALL forums? Would I have to add every forum here

WHERE t.forumid = '1','2','3', etc.? Thanks!

I tried removing this WHERE t.forumid = (because I want from ALL forums) and replaced it with WHERE t.open = '1' AND t.visible = '1', but then the titles don't get limited and it posts the entire title.

OMG, I'm having a hard time with this...I noticed that when I run your code, it cuts the title to the limit you specify, but when I copy/paste your code into my webtemplate, it diplays the number of posts correctly, but doesn't cut off the title...any ideas why yours works and mine doesn't?

Your WHERE close is right if you want to pull from all forums.

If you want to restrict title, you need to apply the left() to the title section too:

SELECT t.threadid, LEFT(t.title, 10) as title, t.firstpostid, t.lastpost, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, LEFT(p.pagetext, 10) as pagetext
FROM " . TABLE_PREFIX . "thread t
LEFT JOIN " . TABLE_PREFIX . "post p ON p.postid = t.firstpostid
WHERE t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 5

YEY! This works PERFECTLY! Thank you very much Logician, you're the best!!! (Doing the running man and dancing around the house now...)

For a look at my site, here is what it looks like now (my site is still under construction): http://www.naturalbeautycafe.net/

THANKS!

Glad it worked. Added your site to the demo webtemplates in the first post. I must also tell it to my wife who might be interested being a member ;)

Great! No problem! I couldn't find a place online for those interested in all natural products, so I decided to create a community online :) :banana:

Thanks I've been looking for this. Just upgraded from vb 3.0.11. Lost the webtemplets. ** installs **
H :D

Export script should export your old webtemplates for you? You can run it even now if you didnt manually deleted old wt tables.

Its most strange, its only swapping IMG bb tags for URL= tags on my test install. I cannot replicate it live either. I decided to go for it anyway as this by all accounts is a long standing mod, so if its not happening to anyone else it must be some wierd setting somewhere making it happen. :)

I thought perhaps it was a style issue as I havent updated all the styles on my dev box but I've pretty much ruled that out aswell, it does do it in vb's default style which is untouched.

One comment the page title seems to not be editable in the front end only in CP. Might be nice to have some inline stuff on this mod for bits like that.

thanks for this hack

Hmm.. I'd like to allow certain usergroups to edit pages, which already works great with a few flaws. On my board with about 500 users I have only one admin beside me.. there are several sections with a own leader group but no access to control panel.

1. the editors should be able to toggle the draft flag and should be able to see the page in draft

2. the editors should be able to change the view permission.

Ideally I only create the page, set the allowed webquerys and let the editors do the rest. Even better if I could allow them to create pages themself, but without any possibility to add php code or include files or stuff like that :)