w usercp_viewprofile.php po:
Kod:
$search = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '</a>';
dodaj:
Kod:
function query_forum_list($condition, $sqlname, $sqlprefix='')
{
global $userdata, $db;
$lp_sql = '';
$forum_data = array();
if ( !($userdata['user_level'] == ADMIN && $userdata['session_logged_in']) )
{
$auth_forums_list = array();
$sql = "SELECT forum_id, $sqlname FROM " . FORUMS_TABLE;
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forum list', '', __LINE__, __FILE__, $sql);
}
while( $f_row = $db->sql_fetchrow($result) )
{
$forum_data[] = $f_row;
}
$db->sql_freeresult($result);
$auth_read_all = array();
$auth_read_all=auth($condition, AUTH_LIST_ALL, $userdata, $forum_data);
for ($i=0; $i<count($forum_data); $i++)
{
if ($auth_read_all[$forum_data[$i]['forum_id']][$sqlname])
{
$auth_forums_list[] = $forum_data[$i]['forum_id'];
}
}
$lp_sql = $sqlprefix.'forum_id IN (' . implode(',', $auth_forums_list) . ')';
}
return $lp_sql;
}
$limit2 = (isset($_GET['nolimit']) && $_GET['nolimit'])?'':' LIMIT 10';
$limit = query_forum_list(AUTH_VIEW, 'auth_view', 'p.');
if ($limit) $limit = " AND $limit";
$sql='SELECT p.forum_id, p.poster_id, f.forum_name, COUNT(p.post_id) AS countall FROM ('.POSTS_TABLE.' p LEFT JOIN '.FORUMS_TABLE.' f ON
p.forum_id=f.forum_id) WHERE p.poster_id = '.$uid.$limit.' GROUP BY p.poster_id, p.forum_id ORDER BY countall DESC'.$limit2;
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forum stats.', '', __LINE__, __FILE__, $sql);
}
$statcount=0;
$statdata = array();
while ($row = $db->sql_fetchrow($result))
{
$statdata[] = $row;
$statcount+=$row['countall'];
}
//stat
$i=0;
foreach ($statdata as $stat)
{
$i++;
$percent = round(100*$stat['countall'] / $statcount);
$link = append_sid('viewforum.'.$phpEx.'?f='.$stat['forum_id']);
$template->assign_block_vars('forumstat',array(
'NUM' => $i,
'PERCENT' => $percent,
'LINK' => $link,
'COUNT' => $stat['countall'],
'TITLE' => $stat['forum_name']));
}
No i w pliku tpl:
Kod:
<tr>
<td colspan="2"class="catLeft" align="center" height="28"><b><span class="gen">{L_FORUMSTATS}</span></b></td>
</tr>
<tr>
<td colspan="2" class="row1" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="3">
<!-- BEGIN forumstat -->
<tr>
<td><span class="gen"><B>{forumstat.NUM}. <a href="{forumstat.LINK}">{forumstat.TITLE}</a></B> (postow: <B>{forumstat.COUNT}</B> (<B>{forumstat.PERCENT}%</B>))</span></td>
</tr>
<tr>
<td>
<div style="width:100%;border:1px solid #BC0000;background:white;"><div style="background:url('link/do/jakiegos/gradientu.gif');height:15px;width:{forumstat.PERCENT}%;"></div></div>
</td>
</tr>
<!-- END forumstat -->
<tr>
<td style="text-align:center;"><span class="gen"> <br/><a href="{U_NOLIMIT}">{L_NOLIMIT}</a></span></td>
</tr>
</table>
</td>
</tr>
Kod o ile się nie mylę dabroza
Nie zapomnij dodać langów dla {L_ZMIENNYCH} w tpl.
linkme.pl ~ Darmowe pozycjonowanie w google Twojego forum
Wymiana plusami oraz Lubię to