Calling threadicon in a plugin

[Mazinger]

PHP Code:

SELECT thread.threadid, thread.title, thread.iconid, icon.iconid, icon.iconpath
FROM " . TABLE_PREFIX . "thread
LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (icon.iconid = thread.iconid)
ORDER BY threadid ASC


{

$thread.="<a href='$thread[threadid].html'>$thread[iconpath]</a>";

} 


Let's assume I've the above query & code.

How do I modify it so it can correctly call $thread[iconpath] which is the path of the thread icon?

[kh99]

The iconpath is being retrieved by the query, but I don't know what to tell you about using it because the code you posted is using $thread as a string and an array. What does the "while" line look like?

[Mazinger]

This is a correct code for a plugin, but it still can't call for iconpath.

PHP Code:

$topthreads = $db->query_read("
     SELECT thread.threadid, thread.title, thread.iconid, icon.iconid, icon.iconpath
     FROM " . TABLE_PREFIX . "thread
     LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (icon.iconid = thread.iconid)
     ORDER BY threadid ASC LIMIT 5
     ");

while ($topthread = $db->fetch_array($topthreads))
{
$favo.="<a href='t$topthread[threadid].html'><img src='$topthread[iconpath]'>$topthread[title]</a>";
} 


[kh99]

Do you have a table prefix defined? If so, you need to add an AS to the FROM line, like:

$topthreads = $db->query_read("
     SELECT thread.threadid, thread.title, thread.iconid, icon.iconid, icon.iconpath
     FROM " . TABLE_PREFIX . "thread AS thread
     LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (icon.iconid = thread.iconid)
     ORDER BY threadid ASC LIMIT 5
     ");

But I guess you don't have a prefix, otherwise the query wouldn't work at all.

In any case, I tried that query in PHPMyAdmin and it works, but note that if a thread doesn't have an icon assigned (and it seems that most do not), the iconpath will be NULL.

[Mazinger]

Thanks alot!

I managed to get it work. This is a correct code:

PHP Code:

global $db, $vbulletin;

$favthreads = $db->query_read("
     SELECT thread.threadid, thread.title, thread.postusername, thread.postuserid, thread.votenum, thread.views, thread.replycount, thread.iconid, icon.iconpath
     FROM " . TABLE_PREFIX . "thread AS thread
     LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (icon.iconid = thread.iconid)
     ");

while ($favthread = $db->fetch_array($favthreads))
{
$favo.="<a href='t$favthread[threadid].html'>$favthread[title] $favthread[iconid] $favthread[iconpath]</a><br /><br />";
}