This is the best mod/hack/addon (or whatever we call it) i've seen on vBulletin. Everything depands on what you can imagine. And this mod makes everything much easier for who dont know lot about php or other coding language.

So thank you very much Logician for this great mod. You simply rock....

I also need an idea about something i would like to do.

Through "$WQ_last10threadfromforum2" i would like to list all the threads in a certain category. And i've changed the limit to 500. So it lists all the threads in ASC without a problem. But i would like to learn if it is possible to make this page with a letterbar (same as vbulletin memberlist.php) ? So users could find the threads much easier. Or even listing the threads like : threads starts with letter A or B.... would be great.

Is that possible ? Anyone can give me an idea about how to do that...
Thanks in advance...

It can be done. Here is a sample webtemplate/webquery for this

Logician, i dont know how to thank you for your very kind relation and very quick response... You are my hero....

I really wish that i could send more and i know that its nothing but i've send you a donation through paypal. That was the amount in my paypal account. :)

Is it possible to remove the first row of the alphabetical table (image2.png) so i can show just the letters seperate as same as on the memberlist.php ? (image4.png)

And is it also possible to add the numeric option which we can then list the threads start with the humbers. I've added "#" but i guess its not working.

Thanks again for this wonderful mod.

1- That part comes because wt uses default theme. If you don't use theme, you can customize it via HTML as you like.

2- Edit webquery like this:
SELECT threadid, title, postusername,postuserid,dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=3 $letterquery
ORDER BY dateline DESC
LIMIT 500

Query PHPInclude Code (Before) : like this:

$myletter1 = substr($myletter, 0, 1);
if ($myletter == '_')
{
$letterquery = "AND (title LIKE '0%' OR title LIKE '1%' OR title LIKE '2%' OR title LIKE '3%' OR title LIKE '4%' OR title LIKE '5%' OR title LIKE '6%' OR title LIKE '7%' OR title LIKE '8%' OR title LIKE '9%') ";
}
else
{
$letterquery = "AND title LIKE '$myletter1%'";
}

and then use
<a href='view.php?pg=alphabeticalthreads&myletter=_'> #</a>
for linking numbered threads.

Would "thank you" be enough for all your helps ?

Now i can use my imagination to create very useful and nice pages with your wonderful mod.

Thank you very very much again Logician...

No it's not. Click on the link in the first post to nominate WT for Mod of the Month ;)

I've already done that Ohiosweetheart :)

http://www.dwgallery.net/data/503/Image11.png

Hopefully it will win one of these days.

With "zero" knowledge of php, i did my best to solve the problems. And actually i did solve most of my problems through google them or search for the possible answers through vb.org

But i still have some problems which i can not solve.

Can not find the right variable for the forum title :
When i list the threads of forumid=2, i can sort them through the letterbar. In the current letterbar, there are "Title", "Author" and "Date" sections. I did add another section called "Forum" which will show the forum title of the thread which it belongs to.
I've also tried $forumid, $forum[title], forumid and maybe +20 different tries which i do not remember now. But none of them worked.


I would like to make a "movie list" for my forum. Due to i have lot of categories such as "Dvd Movie Reviews", "HD-Bluray Movie Reviews", "TV Series Reviews" etc.., i tried to make css navigation menu as shown on below image.

I used "Site Information Pages Template" for this movie list but it did not work due to a reason i do not even remember right now. I feel like my head will blow soon due to those complicated, puzzling, meaningless php codes.

http://www.dwgallery.net/data/503/Image13.png

***Above picture is just an example to give an idea about what i would like to do



Is it possible to pull threads from different forums at same time ?

I did below adding :
I've also tried below :
But none of them worked. So i guess i do something wrong or maybe its not possible to do what i want to do...