require_once 'lib/lunar.php';
$lunar = new Lunar();
for ($i = 0; $i < 5; $i++) {
$ct = getftime(time() + 86400 * $i);
$bdb[] = '(bir_m=' . date('n', $ct) . ' and bir_d=' . date('j', $ct) . ' and isnl=0)';
$nl = $lunar->S2L($ct);
$bdb[] = '(bir_m=' . $nl[0] . ' and bir_d=' . $nl[1] . ' and isnl=1)';
}
$nl_t = $lunar->S2L(getftime());
$s_dbu = sprintf('select id, name, isnl, bir_m, bir_d from %s where %s', $dbprefix . 'member', join(' or ', $bdb));
$q_dbu = mysql_query($s_dbu) or die('');
$r_dbu = mysql_fetch_assoc($q_dbu);
if (mysql_num_rows($q_dbu) > 0) {
$content .= '<li>生日榜<ol>';
do {
$sr_c = $r_dbu['isnl'] > 0 ? $lunar->LMonName($r_dbu['bir_m']) . '月' . $lunar->LDayName($r_dbu['bir_d']) . '日' : '' . $r_dbu['bir_m'] . '月' . $r_dbu['bir_d'] . '日';
$content .= '<li>' . ($r_dbu['isnl'] == 1 && $r_dbu['bir_m'] == $nl_t[0] && $r_dbu['bir_d'] == $nl_t[1] || $r_dbu['isnl'] == 0 && $r_dbu['bir_m'] == date('n', getftime()) && $r_dbu['bir_d'] == date('j', getftime()) ? '<img src="images/cake.gif" alt="" title="生日快乐！" /> ' : '') . '<a href="?m=user&id=' . $r_dbu['id'] . '">' . $r_dbu['name'] . '</a> (<span title="生日：' . ($r_dbu['isnl'] > 0 ? '农历' : '') . $sr_c . '">' . $sr_c . '</span>)</li>';
} while ($r_dbu = mysql_fetch_assoc($q_dbu));
$content .= '</ol></li>';
}
mysql_free_result($q_dbu);
$s_dbc = sprintf('select id, title from %s where closed=0 and disp=0 order by datetime desc limit 3', $dbprefix . 'camp');
$q_dbc = mysql_query($s_dbc) or die('');
$r_dbc = mysql_fetch_assoc($q_dbc);
if (mysql_num_rows($q_dbc) > 0) {
$content .= '<li>最新活动<ol>';
do {
$content .= '<li><a href="?m=camp&id=' . $r_dbc['id'] . '" title="' . $r_dbc['title'] . '">' . substrs($r_dbc['title']) . '</a></li>';
} while ($r_dbc = mysql_fetch_assoc($q_dbc));
$content .= '<li><a href="?m=camp">更多……</a></li></ol></li>';
}
