Quote:
Originally Posted by ishare
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.