MyBB Hacks

Pages: 1 2

place it somewhere else. Like the bottom of the page.

nice mod will tr this out thanks Zing ....

done,...same on the first side the other sites are a little better now,...but the same,...heres my tempelate,...i tried to change it but,...

Code:

			<html>
<head>
<title>{$mybb->settings['bbname']}</title>
{$headerinclude}
</head>
<body>
{$header}
<center><a href="http://msig.msgshit.com/mypage/w2m/snAke_LeAder/" target="_blank"><img src="http://msig.msgshit.com/userbar/w2m/snAke_LeAder.png" alt="My Messenger Status"></a></center>
<sf_shoutbox>
<table width="100%" cellspacing="0" cellpadding="{$theme['tablespace']}" border="0" align="center">
<tr><td valign="top" width="200">
<tr><td valign="top">
{$announcements}
</td>
<td valign="top" width="100">
{$welcome}
{$pms}
<!-- SCP_1_0 -->{$search}
{$stats}<!-- ASOIP_2_0_P -->
{$whosonline}
{$latestthreads}
</td>
</tr>
</table>
{$multipage}
{$footer}
</body>
</html>

^ Try placing it under {$announcements}

ZiNgA BuRgA Wrote:To do this, open up portal.php
Find:

PHP Code:

			$query = $db->query("
	SELECT p.pid, p.message, p.tid
	FROM ".TABLE_PREFIX."posts p
	LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
	WHERE t.fid IN (".$mybb->settings['portal_announcementsfid'].") AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid
	ORDER BY t.dateline DESC 
	LIMIT 0, ".$mybb->settings['portal_numannouncements']
);

Replace with:

PHP Code:

			$page = intval($mybb->input['page']);
if($page < 1) $page = 1;
$numann = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'COUNT(*) AS numann', "fid IN (".$mybb->settings['portal_announcementsfid'].") AND visible='1' AND closed NOT LIKE 'moved|%'"), 'numann');
$perpage = intval($mybb->settings['portal_numannouncements']);
$multipage = multipage($numann, $perpage, $page, $_SERVER['PHP_SELF'].'?paged=1');
$query = $db->query("
	SELECT p.pid, p.message, p.tid
	FROM ".TABLE_PREFIX."posts p
	LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
	WHERE t.fid IN (".$mybb->settings['portal_announcementsfid'].") AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid
	ORDER BY t.dateline DESC 
	LIMIT ".(($page-1)*$perpage).", ".$perpage
);

But if we use PreParser Cache (beta) I think this must to be replaced with:

PHP Code:

			$page = intval($mybb->input['page']);
if($page < 1) $page = 1;
$numann = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'COUNT(*) AS numann', "fid IN (".$mybb->settings['portal_announcementsfid'].") AND visible='1' AND closed NOT LIKE 'moved|%'"), 'numann');
$perpage = intval($mybb->settings['portal_numannouncements']);
$multipage = multipage($numann, $perpage, $page, $_SERVER['PHP_SELF'].'?paged=1');
$query = $db->query("
	SELECT p.pid, p.message, p.tid, pp.parsedmessage
	FROM ".TABLE_PREFIX."posts p
	LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
	LEFT JOIN ".TABLE_PREFIX."parsed_posts pp ON (p.pid=pp.pid)
	WHERE t.fid IN (".$mybb->settings['portal_announcementsfid'].") AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid
	ORDER BY t.dateline DESC 
	LIMIT ".(($page-1)*$perpage).", ".$perpage
);

Right !?

It's about this 2 lines:

PHP Code:

				SELECT p.pid, p.message, p.tid, pp.parsedmessage

and

PHP Code:

				LEFT JOIN ".TABLE_PREFIX."parsed_posts pp ON (p.pid=pp.pid)

Whistle

Something like that.
Does it work? I haven't tried it.

If it works, then you're fine Tongue

Pages: 1 2

incadude

Animal

snAke

ZiNgA BuRgA

goindex

ZiNgA BuRgA