Quote:
Originally posted by WizyWyg
I was wondering if it would be possible to change the query for the last 10 and instead of pulling the last 10 threads he/she has posted to the forum, pull only "all" threads he/she has posted to a private forum?
|
Sure you can! This is what this hack is for: You can have
ANY SQL queries in your database and you can make it listed in any Webtemplate you created.
So all you have to do is to add a new "WebQuery" that does the SQL query you need, then attach this webquery to any webtemplates to automatically list it in your page.
One downside: At the moment this hack does not list sql select results in pages in which you click and get the page 2, 3, etc..So you have 2 options: You can query ALL threads and if the query returns say 700 results, all will be listed in one page! Or you can limit your query with SQL command LIMIT then whatever numbers your user has, only your limited number of results will return.
Anyway if you have problems in designing your Webquery, ask me
here and I can help you with the query.