hmm.. nevermind. The link pops up in a different window somehow..

How search engine friendly is this? Let's say you write articles or tutorials using this template system. Would this get spidered? I know lots of text the regular threads in vb will get picked up, but I am not sure if a full blown article in webtemplates will get spidered. Just wondering how SEO friendly this is.

Thanks very much.

Have you checked FAQ?

Logician are you considering improving this hack? It is definetely my favorite out of all hacks released here. If you were, I have some ideas maybe to help you (just suggestions)..

a.) If there is a way, to parse pages as text and html? For example, on one of my pages I wanted to create a table, but also use the WYSIWYG editor below the table. This would be cool if possible.

b.) Polls in pages would also be sick

c.) Pages able to be searched from forum search

I know that coding is a hard job, because I am trying to learn PHP right now, and I'm stuck on like page 4 lol, so if you've got other priorities, I know the community and I would understand. Thanks for an awesome hack

I appreciate your suggestions.

I agree that this hack has a lot of potential to be improved and I'd like to improve it. However my time that I can spend for my vb.org hacks are very limited and unfortunately I don't see a chance to improve this hack in the near future. As a matter of fact it even took me a year to port it to VB3 and I have other pending hacks to port before concentrating into webtemplates. Sorry about it.

if you change this line in view.php:

as
this should do what you wanted.

Outstanding work. No question.
In testing, there is no conflict of any kind with regard to using other portal software such as VBA. If you get creative with this add-on, there's a lot you can do with it. Example- you could use this for articles and such; with a more customizable format. You can index them by creating a new "forum" called "Articles" and then make the webtemplates into links. One suggestion I would add is if you have a board with multiple stylesets, you might also want to install ZeroTolerance's "Copy Templates from one style to another" hack. Then you can copy the webtemplates required when this is first installed to all your styles very quickly.

Anyway, this is great work you have done here Logician.

How do I use a webquery to query two different tables?

I want to include the forum's name in the last post header.

I tried:

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

SELECT forumid, title, description, displayorder
FROM " . TABLE_PREFIX . "forum
WHERE forumid In(108,109)
ORDER BY title ASC
LIMIT 100

But it did not work.

And even if I do get both query's to work when I output them in the Query Results Row both Query's assign a value to the $WQfield[title] variable.

Any ideas how to get both query's to work and assign them the "title" variable to different names?

Thanks in advance, this is a great hack!

Make a LEFT JOIN in first query:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumidpostid
WHERE t.forumid
IN ( 108, 109 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

Thanks for the fast response!

So to pull the info can I just use $WQfield[t.title] and $WQfield[f.title] ?

ok let's change the query like this:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumidpostid
WHERE t.forumid
IN ( 108, 109 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

now $WQfield[title] gives you thread title and $WQfield[forumtitle] gives you forum title. ;)