function contr_panel_members_onl($w = "")
{
global $site;
global $prof;
// members statistics
$total_c = strlen($_POST['total_c']) ? $_POST['total_c'] : getParam("default_country");
$total_c_members_onl = get_users_online_number('c', $total_c);
$total_arr_chatting = get_users_online_number('t');
$members_online = get_users_online_number();
$c_arr = $prof['countries'];
$ret = '';
$ret .= '<div class="membes_statistic_block">';
$ret .= '<div class="clear_both"></div>';
$ret .= '<div style="position:relative; float:left;"><img src="' . $site['icons'] . 'group.gif" alt="" /></div>';
$ret .= '<div style="position:relative; float:left; white-space:nowrap; left:5px; font-weight:bold; color:#000;"><a href="search_result.php?online_only=show" target="_blank">' . _t("_Currently Online") . '</a></div>';
$ret .= '<div class="clear_both"></div>';
$ret .= '<div style="position:relative; margin:0px 0px;"></div>';
$ret .= '<div class="member_stat_block">';
$ret .= '<div><img src="' . $site['icons'] . 'us.gif" alt="" /><span style="margin-left:5px;">' . _t("_Total") . ' - ' . $members_online . '</span></div>';
$ret .= '<div><img src="' . $site['icons'] . 'us.gif" alt="" /><span style="margin-left:5px;">' . _t("_Chatting") . ' - ' . $total_arr_chatting . '</span></div>';
$ret .= '<div><img src="' . $site['icons'] . 'us.gif" alt="" /><span style="margin-left:5px;">' . $total_c_members_onl . ' ' . _t("_members") . ' ' . _t("_from") . '</span></div>';
$ret .= '<div class="mem_stat_country">';
$ret .= '<form action="' . $_SERVER['PHP_SELF'] . '" method="post" name="cForm">';
$ret .= '<input type="hidden" name="total_c" value="' . $total_c . '" />';
$ret .= '<select class="mem_stat_country_select" name="total_c" onChange="javascript:this.form.submit();">';
foreach ($c_arr as $key => $value) {
$ret .= '<option value="' . $key . '"';
if ($key == $total_c) {
$ret .= ' selected="selected"';
}
$ret .= '>' . _t('__' . $value) . '</option>';
}
$ret .= '</select>';
$ret .= '</form>';
$ret .= '</div>';
$ret .= '</div>';
$ret .= '</div>';
return $ret;
}
/**
* members statistic block
*/
function PageCompMemberStatN($w, $h)
{
global $site;
global $prof;
global $tmpl;
$free_mode = getParam("free_mode") == "on" ? 1 : 0;
// members statistics
$total_c = strlen($_POST['total_c']) ? $_POST['total_c'] : getParam("default_country");
$total_c2 = strlen($_POST['total_c2']) ? $_POST['total_c2'] : getParam("default_country");
$total_arr = db_arr("SELECT COUNT(ID) FROM `Profiles` WHERE Status = 'Active'");
$total_arr_week = db_arr("SELECT COUNT(ID) FROM `Profiles` WHERE Status = 'Active' AND (TO_DAYS(NOW()) - TO_DAYS(LastReg)) <= 7");
$total_arr_gold = db_arr("SELECT\tCOUNT(DISTINCT IDMember)\r\n\t\t\t\t\t\t\t\t\tFROM\tProfileMemLevels\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Profiles ON Profiles.ID = ProfileMemLevels.IDMember\r\n\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t(DateExpires IS NULL OR DateExpires > NOW()) AND\r\n\t\t\t\t\t\t\t\t\t\t(DateStarts IS NULL OR DateStarts <= NOW()) AND\r\n\t\t\t\t\t\t\t\t\t\t(Profiles.Status = 'Active')");
$total_c_arr = db_arr("SELECT COUNT(ID) FROM `Profiles` WHERE Status = 'Active' AND `Country` = '" . process_db_input($total_c) . "'");
$total_members = $total_arr[0];
$total_c_members = $total_c_arr[0];
$total_c_members_onl = get_users_online_number('c', $total_c2);
$total_arr_chatting = get_users_online_number('t');
$members_online = get_users_online_number();
$c_arr = $prof[countries];
$out = "";
$out .= '<table cellpadding="0" cellspacing="0" border="0" align="center" width="150"><tr><td>';
$out .= "<table cellpadding=1 cellspacing=1 class=text border=0 align=center>";
$out .= "<tr><td width=17><img src={$site['images']}group1.gif></td><td width=100%><b> " . _t("_Currently Online") . "</b></td></tr>\n";
$out .= "<tr><td height=5 class=memb_stat colspan=2><img src={$site['images']}spacer.gif width=6 height=1></td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src='{$site['images']}us2.gif'></td><td width=100% align=\"left\"> " . _t("_Total") . " - {$members_online}</td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src='{$site['images']}us3.gif'></td><td width=100% align=\"left\"> " . _t("_Chatting") . " - {$total_arr_chatting} </td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src='{$site['images']}us4.gif'></td><td width=100% align=\"left\"> {$total_c_members_onl} " . _t("_members") . " " . _t("_from") . ":</td></tr>\n";
$out .= '<form action="' . $_SERVER[PHP_SELF] . '" method="post" name="cForm2"><tr><td align=right colspan=2>';
$out .= "<input type=hidden name=total_c value={$total_c}>";
$out .= '<select class=index name=total_c2 onChange="javascript: document.forms[\'cForm2\'].submit();">';
foreach ($c_arr as $key => $value) {
$out .= "<option value={$key}";
if ($key == $total_c2) {
$out .= " selected";
}
$out .= '>' . _t('__' . $value) . '</option>';
}
$out .= '</select>';
$out .= '</td></form></tr>';
$out .= "<tr><td height=1 colspan=2><img src={$site['images']}spacer.gif width=1 height=1></td></tr>\n";
$out .= "</table>\n";
$out .= "<br />";
$out .= "<table cellpadding=1 cellspacing=1 class=text>";
$out .= "<tr><td height=2><img src={$site['images']}spacer.gif height=2></td></tr>\n";
$out .= "<tr><td width=17><img src={$site['images']}group2.gif></td><td width=100%><b> " . _t("_Total Registered") . "</b></td></tr>\n";
$out .= "<tr><td height=1 class=memb_stat colspan=2><img src={$site['images']}spacer.gif width=1 height=1></td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src={$site['images']}us6.gif></td><td width=100% align=\"left\"> " . _t("_Total") . " - {$total_arr['0']}</td></tr>\n";
if (!$free_mode) {
$out .= "<tr><td width=17 align='right'><img src={$site['images']}us4.gif></td><td width=100% align=\"left\"> " . _t("_Gold Members") . " - {$total_arr_gold['0']} </td></tr>\n";
}
$out .= "<tr><td width=17 align='right'><img src={$site['images']}us7.gif></td><td width=100% align=\"left\"> " . _t("_New this week") . " - {$total_arr_week['0']} </td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src={$site['images']}us1.gif></td><td width=100% align=\"left\"> {$total_c_members} " . _t("_members") . " " . _t("_from") . ":</td></tr>\n";
if ($tmpl == 'g4') {
$out .= "<tr><td><img src=\"" . $site[images] . "spacer.gif\" height=\"5\"></td></tr>";
}
$out .= '<form action="' . $_SERVER[PHP_SELF] . '" method="post" name="cForm"><tr><td align=right colspan=2>';
$out .= "<input type=hidden name=total_c2 value={$total_c2}>";
$out .= '<select class=index name=total_c onChange="javascript: document.forms[\'cForm\'].submit();">';
foreach ($c_arr as $key => $value) {
$out .= "<option value={$key}";
if ($key == $total_c) {
$out .= " selected";
}
$out .= '>' . _t('__' . $value) . '</option>';
}
$out .= '</select>';
$out .= '</td></form></tr>';
$out .= "<tr><td height=1 colspan=2><img src={$site['images']}spacer.gif width=1 height=1></td></tr>\n";
$out .= '</table>';
$out .= '</td></tr></table>';
return DesignBoxContent(_t("_members"), $w, $out, $h);
}
