MyBB Hacks

(05-01-2011 08:09 AM)leefish Wrote: [ -> ]Maybe this thread can help you:

http://mybbhacks.zingaburga.com/showthre...http://mybbhacks.zingaburga.com/showthread.php?tid=713&pid=66

Quote:SQL Error:
    1054 - Unknown column 't.lastpostbumperuid' in 'on clause'
Query:
    SELECT t.*, tfd.`desc` AS `xthreads_desc`, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username, u.avatar, lp.avatar AS lpavatar FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='1') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) LEFT JOIN `mybb_threadfields_data` tfd ON t.tid=tfd.tid LEFT JOIN mybb_users lp ON (lp.uid=t.lastpostbumperuid) WHERE t.fid='7' AND (t.visible='1' OR t.visible='0') GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpostbump desc LIMIT 0, 20

t.lastposteruid

replace with

t.`lastposteruid`

(05-01-2011 11:03 AM)ZiNgA BuRgA Wrote: [ -> ]Are you using my really old (and not so good) Bump Thread plugin?
I guess a workaround could be to open up the above mnxt_fn_av.php, find:

Code:

t.lastposteruid

---

replace with

Code:

t.`lastposteruid`

---

<tr>
	<td align="center" class="{$bgcolor}{$thread_type_class}" width="2%"><img src="{$theme['imgdir']}/{$folder}.gif" alt="{$folder_label}" title="{$folder_label}" /></td>
	<td align="center" class="{$bgcolor}{$thread_type_class}" width="2%">{$icon}</td>
	<td class="{$bgcolor}{$thread_type_class}">
		{$attachment_count}
		<div>
			<span><img src="{$thread['avatar']}{$thread['lpavatar']}" alt="" title="" />{$prefix} {$gotounread}{$thread['threadprefix']}<a href="{$thread['tlink']}" class="{$inline_edit_class} {$new_class}" id="tid_{$inline_edit_tid}">{$thread['subject']}</a>{$thread['multipage']}</span>
			{$threadfields['desc']}<div class="author smalltext">{$thread['profilelink']}</div>
		</div>
	</td>
	<td align="center" class="{$bgcolor}{$thread_type_class}"><a href="javascript:MyBB.whoPosted({$thread['tid']});">{$thread['replies']}</a>{$unapproved_posts}</td>
	<td align="center" class="{$bgcolor}{$thread_type_class}">{$thread['views']}</td>
	{$rating}
	<td class="{$bgcolor}{$thread_type_class}" style="white-space: nowrap; text-align: right;">
		<span class="lastpost smalltext">{$lastpostdate} {$lastposttime}<br />
		<a href="{$thread['lastpostlink']}">{$lang->lastpost}</a>: {$lastposterlink}</span>
	</td>
{$modbit}
</tr>

(05-01-2011 01:06 PM)ZiNgA BuRgA Wrote: [ -> ]You're not meant to put the two URLs together.  They have to be in separate <img> tags.
I suggest you read up on HTML if you're really intent on customising.  It doesn't take too long, and will be infinitely useful.