pero nada u_U
probe con el codigo de board_portal_2
SPOILER_SHOW
Código: Seleccionar todo
// Generate birthday list if required ... / borrowed from index.php 3.0.6
$birthday_list_idol = $birthday_ahead_list_idol = '';
if ($config['load_birthdays'] && $config['allow_birthdays'])
{
$now = getdate(time() + $user->timezone + $user->dst - date('Z'));
$cache_days = 7;
$sql_days = '';
while ($cache_days > 0)
{
$day = getdate(time() + 86400 * $cache_days + $user->timezone + $user->dst - date('Z'));
$sql_days .= " OR u.idol_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $day['mday'], $day['mon'])) . "%'";
$cache_days--;
}
switch ($db->sql_layer)
{
case 'mssql':
case 'mssql_odbc':
$order_by = 'u.idol_birthday ASC';
break;
default:
$order_by = 'SUBSTRING(u.idol_birthday FROM 4 FOR 2) ASC, SUBSTRING(u.idol_birthday FROM 1 FOR 2) ASC';
break;
}
$now = getdate(time() + $user->timezone + $user->dst - date('Z'));
$sql = 'SELECT u.idol_id, u.idolname, u.idol_birthday
FROM ' . IDOLS_TABLE . ' u
LEFT JOIN ' . BANLIST_TABLE . " b ON (u.idol_id = b.ban_userid)
WHERE (b.ban_id IS NULL
OR b.ban_exclude = 1)
AND (u.idol_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%' {$sql_days})
AND u.idol_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')
ORDER BY ' . $order_by;
$result = $db->sql_query($sql);
$today = sprintf('%2d-%2d-', $now['mday'], $now['mon']);
while ($row = $db->sql_fetchrow($result))
{
if (substr($row['idol_birthday'], 0, 6) == $today)
{
$birthday_list_idol .= '<span style="float:left;"><img src="' . $phpbb_root_path . 'styles/' . $user->theme['theme_path'] . '/theme/images/portal/portal_user.png" width="16" height="16" alt="" /></span><span style="float:left; padding-left:5px; padding-top:2px;">' . get_username_string('full', $row['idol_id'], $row['idolname'], $row['idol_colour']) . '</span><span style="float: right;">';
if ($age = (int) substr($row['idol_birthday'], -4))
{
$birthday_list_idol .= ' (' . ($now['year'] - $age) . ')';
}
$birthday_list_idol .= '</span><br style="clear: both" />';
}
elseif ( 7 > 0)
{
$birthday_ahead_list_idol .= '<span style="float:left;"><img src="' . $phpbb_root_path . 'styles/' . $user->theme['theme_path'] . '/theme/images/portal/portal_user.png" width="16" height="16" alt="" /></span><span style="float:left; padding-left:5px; padding-top:2px;"><span title="' . format_birthday($row['idol_birthday'], 'd M') . '">' . get_username_string('full', $row['idol_id'], $row['idolname'], $row['idol_colour']) . '</span></span><span style="float: right;">';
if ($age = (int) substr($row['idol_birthday'], -4))
{
$birthday_ahead_list_idol .= ' (' . ($now['year'] - $age) . ')';
}
$birthday_ahead_list_idol .= '</span><br style="clear: both" />';
}
}
$db->sql_freeresult($result);
}SPOILER_SHOW
Código: Seleccionar todo
'BIRTHDAY_LIST_IDOL' => $birthday_list_idol,
'BIRTHDAYS_AHEAD_LIST_IDOL' => ( 7 ) ? $birthday_ahead_list_idol: '',
'S_DISPLAY_BIRTHDAY_LIST_IDOL' => ($config['load_birthdays']) ? true : false,
'S_DISPLAY_BIRTHDAY_AHEAD_LIST_IDOL' => ( 7 > 0) ? true : false,SPOILER_SHOW
Código: Seleccionar todo
CREATE TABLE `phpbb_idols` (
`idol_id` mediumint(8) unsigned NOT NULL auto_increment,
`idol_type` tinyint(2) NOT NULL default '0',
`idolname` varchar(255) collate utf8_bin NOT NULL default '',
`idolname_nick` varchar(255) collate utf8_bin NOT NULL,
`idolname_kanji` varchar(20) character set ujis collate ujis_bin NOT NULL,
`idol_birthday` varchar(10) collate utf8_bin NOT NULL default '',
`idol_profile` varchar(200) collate utf8_bin NOT NULL,
`idol_agency` varchar(200) collate utf8_bin NOT NULL default '',
`idol_agency_group` varchar(200) collate utf8_bin NOT NULL default '',
`idol_type_blood` varchar(10) collate utf8_bin NOT NULL,
`idol_stature` smallint(4) unsigned NOT NULL,
`idol_native_city` varchar(200) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`idol_id`),
UNIQUE KEY `idolname` (`idolname`),
KEY `idol_birthday` (`idol_birthday`),
KEY `idol_type` (`idol_type`)
) ENGINE=MyISAM AUTO_INCREMENT=156 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;y en el index_body.html coloco esto
SPOILER_SHOW
Código: Seleccionar todo
<!-- IF BIRTHDAY_LIST_IDOL -->
<strong>{L_CONGRATULATIONS}:</strong><br /> {BIRTHDAY_LIST_IDOL}
<!-- ELSE -->
{L_NO_BIRTHDAYS}
<!-- ENDIF -->
<!-- IF S_DISPLAY_BIRTHDAY_AHEAD_LIST_IDOL -->
<hr class="dashed" />
<strong>{L_BIRTHDAYS_AHEAD_IDOL}</strong>
<br />
<!-- IF BIRTHDAYS_AHEAD_LIST_IDOL -->
{BIRTHDAYS_AHEAD_LIST_IDOL}
<!-- ELSE -->
{L_NO_BIRTHDAYS_AHEAD}
<!-- ENDIF -->
<!-- ENDIF -->
