Need to call up custom field in "lastpostby" template from thread table

[omardealo]

Hello ,

i Need to call up custom field in "lastpostby" template from thread table
my Version 3.8.7

i try this code

hook : forumbit_display
in templat forumhome_lastpostby : $lastpostinfo[threadphoto]

PHP Code:

$hook_query_fields .= ', thread.threadphoto ';
$hook_query_joins .= ' LEFT JOIN ' . 'thread AS thread ON (thread.forumid = forum.forumid) '; 


i try this code too :

PHP Code:

$tachyjoin .= " LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.forumid = forum.forumid) ";
$counter_select .= ", thread.threadphoto"; 


[kh99]

Not long ago someone asked this same question (they even worded it the same way - weird). Anyway, it's here: www.vbulletin.org/forum/showthread.php?t=293100

[omardealo]

not weird , i see this thread already and i copy same title
i try same code , not worked ...
so , i write new thread ...
thanks kh99 , i waiting ur Suggestions regarding about my problem or what's wrong in my code

Note : my Version 3.8.7 not 4.×.×

[kh99]

Originally Posted by omardealo

not weird , i see this thread already and i copy same title
i try same code , not worked ...

lol, I see - I thought that was quite a coincidence. Also I see now that you're asking something a little different. OK, Try this: use hook location cache_ordered_forums and code like this:

$tachyjoin .= " LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = forum.lastthreadid) ";
$counter_select .= ", thread.threadphoto";

[omardealo]

ok , i try this code and the hook : cache_ordered_forums
Shows me this error

PHP Code:

Database error in vBulletin 3.8.7:

Invalid SQL:

                SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid, thread.threadphoto
                    
                FROM forum AS forum
                
                 LEFT JOIN thread AS thread ON (thread.threadid = forum.lastthreadid);

MySQL Error   : Column 'lastpost' in field list is ambiguous
Error Number  : 1052
Request Date  : Friday, February 8th 2013 @ 06:58:38 PM
Error Date    : Friday, February 8th 2013 @ 06:58:38 PM
Script        : http://localhost/386/index.php
Referrer      : http://localhost/386/showthread.php?p=71
IP Address    : 127.0.0.1
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.51b-community-nt-log 


Note : some forum on lastthreadid filed = 0

[kh99]

Hmm...OK, try this:

if (!($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)))
{
    $counter_select = str_replace(', ', ', forum.', $counter_select);
}
$tachyjoin .= " LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = forum.lastthreadid) ";
$counter_select .= ", thread.threadphoto";

[omardealo]

Originally Posted by kh99

Hmm...OK, try this:

if (!($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)))
{
    $counter_select = str_replace(', ', ', forum.', $counter_select);
}
$tachyjoin .= " LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = forum.lastthreadid) ";
$counter_select .= ", thread.threadphoto";

it worked good now . Thank you with all my heart
Now, The final question, if u allowed
I want to put a condition if {} in the case of content not available in the field threadphoto

[kh99]

Originally Posted by omardealo

it worked good now . Thank you with all my heart
Now, The final question, if u allowed
I want to put a condition if {} in the case of content not available in the field threadphoto

You could try something like this in the template:

<if condition="empty($lastpostinfo[threadphoto])">
No threadphoto
<else />
Threadphoto is $lastpostinfo[threadphoto]
</if>

As long as threadphoto can't be 0 (because that would make empty() true).

[omardealo]

ok that's good i use this template

PHP Code:

<if condition="empty($lastpostinfo[threadphoto])">
<img border="0" src="$vboptions[threadphoto_DefaultPic]" width="50" height="50">
<else />
<img border="0" src="$lastpostinfo[threadphoto]" width="50" height="50">
</if> 


look , i add this template in forumhome_lastpostby template
by this hook : forumbit_display

This code replaces all the template :

PHP Code:

eval('$forum[\'lastpostinfo\'] = "' . fetch_template('threadphoto_forumhome') . '";'); 


This code template placed in the end of the template forumhome_lastpostby:

PHP Code:

eval('$forum[\'lastpostinfo\'] .= "' . fetch_template('threadphoto_forumhome') . '";'); 


i want put my template At the beginning of the template forumhome_lastpostby












-------------------------------------------------------------------------------------------------------------------------

For any one want to call this field in forumdisplay Beside title threads
1 - plugin 1
hook : forumdisplay_query
code :

PHP Code:

$hook_query_fields .= ", thread.threadphoto AS threadphoto"; 


2 - add template - plugin 2
hook : global_start
code :

PHP Code:

require_once(DIR . '/includes/adminfunctions_template.php'); 
$threadphoto = compile_template('<td class="alt2"><if condition="$show[\'threadicon\']"><img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" /><else />&nbsp;</if></td>');
$threadphoto1 = compile_template('');
$vbulletin->templatecache['threadbit'] = str_replace($threadphoto ,$threadphoto1 .fetch_template('threadphoto_threadbit'),$vbulletin->templatecache['threadbit']);
$threadphoto_Photowidth  = $vbulletin->phrase[threadphoto_Photowidth];
$threadphoto_Photoheight  = $vbulletin->phrase[threadphoto_Photoheight]; 


3 - in template [threadphoto_threadbit] put this

PHP Code:

<if condition="$show[threadicons]">
<td class="alt2" align="center" valign="middle">
<if condition="$thread[threadphoto]">
<img src="$thread[threadphoto]" width="$vboptions[threadphoto_Photowidth]" height="$vboptions[threadphoto_Photoheight]" />
<else />
<if condition="$vboptions[threadphoto_DefaultPic]">
<img src="$vboptions[threadphoto_DefaultPic]" width="$vboptions[threadphoto_Photowidth]" height="$vboptions[threadphoto_Photoheight]" />
<else />
<if condition="$show[threadicon]">
<img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />
</if>
</if>
</td>
</if>
</if> 


[omardealo]

kh99 , Waiting u ...
thnx .