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); }