[REQ] Thread Catagory intergration?

[Misuzu]

http://www.vbulletin.org/forum/showthread.php?t=61494
with the above hack installed, is it possible to do this?

example: for the news module, instead of displaying the poster's avatar, can i have it display a different picture depending on the catagory? like say, if the catagory was games, have it display games.gif instead of avatar, and catagory was sports, display sports.gif etc.

[Misuzu]

ok, is it possible to just show the prefix in front of the thread title? cuz right now the prefix doesn't show up. :(

[Brian]

It looks like that hack is adding another column to the thread table, so you'd have to figure out what column is added, edit the file to add that to the query, then edit the template to add that column there as well.

[Misuzu]

the column seems to be thread.category i tried adding that to the news.php

$getnews = $DB_site->query("
SELECT " . iif($vba_options['portal_news_showrating'], 'IF(votenum >= ' . $vboptions['showvotes'] . ', votenum, 0) AS votenum, IF(votenum >= ' . $vboptions['showvotes'] . ' AND votenum != 0, votetotal / votenum, 0) AS voteavg,') . "
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, thread.category, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie

then added $thread[category] to the news template and it didn't work :(

[Brian]

Try $news[category] in the template instead.

[Misuzu]

that worked! :) thanks