Página 1 de 1
Top five mostrar top Multi-Race Rank Themes
Publicado: 05 Nov 2011, 23:31
por Makoto
Top five
http://www.phpbb.com/customise/db/mod/top_five/
Multi-Race Rank Themes
http://www.phpbb.com/customise/db/mod/m ... nk_themes/
bueno el desarrollador del mod
Multi-Race Rank Themes me dio
este codigo pero no se como adecuarlo
Código: Seleccionar todo
SELECT rtheme_title, COUNT( user_rank_theme ) AS theme_count
FROM `phpbb3_users`
INNER JOIN `phpbb3_rank_themes` ON user_rank_theme = rtheme_id GROUP BY rtheme_id
quisiera que se muestre los rank themes con mas usuarios
Re: Top five mostrar top Multi-Race Rank Themes
Publicado: 07 Feb 2012, 01:34
por Makoto
eh tratado de adaptar el php pero no me resulta u_u donde podria estar el error
Código: Seleccionar todo
// top five rank themes
if (($user_ranks = $cache->get('_top_five_ranks')) === false)
{
$user_ranks = array();
// grab users with most posts
$sql = 'SELECT rtheme_title, COUNT( user_rank_theme ) AS theme_count, user_id
FROM ' . USERS_TABLE . '
INNER JOIN ' . RANK_THEMES_TABLE . ' ON user_rank_theme = rtheme_id
GROUP BY rtheme_id
ORDER BY theme_count DESC';
$result = $db->sql_query_limit($sql, 5);
while ($row = $db->sql_fetchrow($result))
{
$user_ranks[$row['user_id']] = array(
'user_id' => $row['user_id'],
'user_rank_theme' => $row['user_rank_theme'],
);
}
$db->sql_freeresult($result);
// cache this data for five minutes, this improves performance
$cache->put('_top_five_ranks', $user_ranks, 300);
}
foreach ($user_ranks as $row)
{
$template->assign_block_vars('top_five_ranks',array(
'TRANKS' => $row['theme_count'],
'TRANKS_TITLE' => $row['rtheme_title'])
);
}
???
