SELECT p.*, m.uid, m.username,

SELECT p.*, mp.*, m.uid, m.username AS username,

LEFT JOIN {$tablepre}members m ON m.uid=p.authorid

                LEFT JOIN {$tablepre}mypetdata mp ON mp.username=p.author

$firstpid, $videoopen

, $petsettings, $petdir

$post['attachments'] = array();

if ($post[mypet]){
@include DISCUZ_ROOT.'./forumdata/cache/plugin_pet.php';
$petdir = $_DPLUGIN['pet']['vars']['imgdir'];
$petsettings = $_DPLUGIN['pet']['vars'];
$post['petusername'] =  rawurlencode($post['username']);
$t=time();
$today = gmdate ("Ymd",$t);
$post['petdiff'] = time() - $post['petregdate'];
$post['petregdate']=gmdate ("Ymd",$post['petregdate']);
$post['pett'] = $today-$post['petregdate'];
$post['petlevel'] = pow (log10 ($post['mypetexp']), 3);
$post['petshowlevel'] = floor ($post['petlevel'] + 1);
$post['levelpic']=intval($post['petshowlevel']/10);
$post['levelpic'] = $post['levelpic'] > '10' ? '11' : $post['levelpic'];
$post['level1']=intval($post['petshowlevel']/2);
$post['level2']=intval($post['petshowlevel']/2);
$post['petpic']=$post['mypetname'];
$post['pethp']=$post['mypethp'];
$post['petatk']=$post['mypetatk']+$post['item1']+$post['item2']+2+$post[level1];
$post['petdef']=$post['mypetdef']+$post['item3']+$post['item4']+$post['item5']+3+$post['level1'];
if($post['petshowlevel']<2){$post['petmaxhp']=$petsettings['basichp'];}
else{$post['petmaxhp']=$petsettings['basichp']+$post['petshowlevel']*5;}
$post['petsp']=$post['mypetsp']-$post['pett']*$petsettings['basicsp2'];
if($post['petsp']>$petsettings['basicsp']){$post['petsp']=$petsettings['basicsp'];}
$post['hpf']= floor (100 * ($post['pethp'] / $post['petmaxhp']));
$post['spf']= floor (100 * ($post['petsp'] / $petsettings['basicsp']));

$post['pethp'] = $post['pethp'] < '0' ? '0' : $post['pethp'];
$post['petsp'] = $post['petsp'] < '0' ? '0' : $post['petsp'];
$post['petdead'] = $post['pethp'] < '1' || $post['petsp'] < '1' ? '死亡' : '生存';
$post['petsex'] = $post['mypetsex'] < '2' ? '雄' : '雌';
$post['petpk'] = $post['openpk'] < '2' ?  '等待挑戰' : '拒絕挑戰';
$post['hpf'] = $post['hpf'] >= '100' ? '100' : $post['hpf'];
$post['spf'] = $post['spf'] >= '100' ? '100' : $post['spf'];
}

/*-----------userpetinfo-------------*/
.chart { border: 1px solid {BORDERCOLOR}; width:120px; height:9px; padding: 0em; background: #FFFFFF;}
.chart img { float:left;}       

<!--{if $post['authorid'] && $post['username'] && !$post['anonymous']}-->

<!--{if $post[mypet]}-->
<a href="plugin.php?identifier=pet&module=pet&index=viewpet&username=$post['petusername']" target="_blank" id="userpetinfo$post[pid]" class="dropmenu" onmouseover="showMenu(this.id,false,0,2,500,0,this.id,500)" style="text-align:right; float:right; font-weight:normal;">寵物資訊</a>
<!--{/if}-->

<!--{if $post['authorid'] && $post['username'] && !$post['anonymous']}-->

<!--{if $post[mypet]}-->
{template userpetinfo}
<!--{/if}-->

將 viewthread 模板下一段移到你喜歡位置就得