function list_users($search = '') { global $CONFIG, $cpg_udb, $CPG_PHP_SELF, $LINEBREAK; //, $PHP_SELF; global $lang_usermgr_php, $lang_byte_units, $lang_date, $lang_common, $icon_array; global $lim_user, $number_of_columns, $template_tab_display; global $USER_DATA; $superCage = Inspekt::makeSuperCage(); list($timestamp, $form_token) = getFormToken(); $number_of_columns_minus_one = $number_of_columns - 1; $number_of_columns_minus_three = $number_of_columns - 3; $number_of_columns_minus_four = $number_of_columns - 4; $sort_codes = array('name_a' => 'user_name ASC', 'name_d' => 'user_name DESC', 'group_a' => 'group_name ASC', 'group_d' => 'group_name DESC', 'reg_a' => 'user_regdate ASC', 'reg_d' => 'user_regdate DESC', 'pic_a' => 'pic_count ASC', 'pic_d' => 'pic_count DESC', 'disku_a' => 'disk_usage ASC', 'disku_d' => 'disk_usage DESC', 'lv_a' => 'user_lastvisit ASC', 'lv_d' => 'user_lastvisit DESC'); $sort = 'reg_d'; if ($superCage->get->keyExists('sort') && ($matches = $superCage->get->getMatched('sort', '/^[a-z_]+$/'))) { if ($sort_codes[$matches[0]]) { $sort = $matches[0]; } } $makereadonly = $CONFIG['bridge_enable'] ? 'style="display:none;" disabled="disabled" ' : ''; $user_count = $cpg_udb->get_user_count(); if (!$user_count) { cpg_die(CRITICAL_ERROR, $lang_usermgr_php['err_no_users'], __FILE__, __LINE__); } $user_per_page = 25; $page = $superCage->get->testInt('page') ? $superCage->get->getInt('page') : 1; $lower_limit = ($page - 1) * $user_per_page; $lower_limit = ($page - 1) * $user_per_page; $username = ''; if ($search) { $username = '******' . $search; $users_search = $cpg_udb->get_users(array('users_per_page' => $user_count, 'lower_limit' => 0, 'search' => $search, 'sort' => $sort)); $user_count = count($users_search); } $tab_tmpl = $template_tab_display; $tab_tmpl['page_link'] = strtr($tab_tmpl['page_link'], array('{LINK}' => 'usermgr.php?sort=' . $sort . '&page=%d' . $username)); $tab_tmpl['left_text'] = strtr($tab_tmpl['left_text'], array('{LEFT_TEXT}' => $lang_usermgr_php['u_user_on_p_pages'])); $users = $cpg_udb->get_users(array('users_per_page' => $user_per_page, 'lower_limit' => $lower_limit, 'search' => $search, 'sort' => $sort)); $total_pages = ceil($user_count / $user_per_page); $tabs = create_tabs($user_count, $page, $total_pages, $tab_tmpl); $lb = '<span id="album_listbox_wrapper" style="display:none">'; $lb .= $lang_usermgr_php['sort_by'] . ': '; $lb .= "<select name=\"album_listbox\" id=\"album_listbox\" class=\"listbox\" onchange=\"if(this.options[this.selectedIndex].value) window.location.href='{$CPG_PHP_SELF}?page={$page}&sort='+this.options[this.selectedIndex].value;\">" . $LINEBREAK; foreach ($sort_codes as $key => $value) { $selected = $key == $sort ? 'selected="selected"' : ""; $lb .= ' <option value="' . $key . '" ' . $selected . '>' . $lang_usermgr_php[$key] . '</option>' . $LINEBREAK; } $lb .= '</select>' . $LINEBREAK; $lb .= '</span>' . $LINEBREAK; echo <<<EOT <script type="text/javascript" language="javascript"> <!-- function selectaction(d,box) { // check if an action has been selected var action = document.editForm.action.value; if (action == '') { return false; } // check if at least one user has been selected var checked_counter = 0; var checked_string = ''; var f = document.editForm; for (i = 0; i < f.length; i++) { if (f[i].type == "checkbox" && f[i].name.indexOf(box) >= 0) { if (f[i].checked) { checked_counter = checked_counter + 1; if (checked_string == '') { checked_string = f[i].name; } else { checked_string = checked_string + ',' + f[i].name; } } } } if (checked_counter == 0) { document.editForm.action.value = ''; alert('{$lang_usermgr_php['alert_no_selection']}'); return false; } document.editForm.id.value = checked_string; document.editForm.new_password.style.display = "none"; document.editForm.group.style.display = "none"; document.editForm.go.style.display = "none"; document.editForm.delete_files.style.display = "none"; document.editForm.delete_comments.style.display = "none"; switch(document.editForm.action.value) { case "delete": document.editForm.delete_files.style.display = "inline"; document.editForm.delete_comments.style.display = "inline"; document.editForm.go.style.display = "inline"; break; case "reset_password": document.editForm.new_password.style.display = "inline"; document.editForm.go.style.display = "inline"; break; case "change_group": document.editForm.new_password.value = ''; document.editForm.group.style.display = "inline"; if (document.editForm.group.value != '') { document.editForm.submit(); } break; case "add_group": document.editForm.new_password.value = ''; document.editForm.group.style.display = "inline"; if (document.editForm.group.value != '') { document.editForm.submit(); } break; default: document.editForm.new_password.value = ''; document.editForm.submit(); break; } } addonload("show_section('album_listbox_wrapper')"); addonload("show_section('checkAll')"); addonload("show_section('checkAll2')"); addonload("show_section('action')"); --> </script> EOT; echo '<form method="get" action="delete.php" name="editForm" id="cpgform">'; if ($superCage->post->keyExists('username')) { $search_filter = '<td align="center">' . $lang_usermgr_php['search_result'] . $superCage->post->getEscaped('username') . '</td>'; } else { $search_filter = ''; } $help = ' ' . cpg_display_help('f=users.htm&as=user_cp&ae=user_cp_end&top=1', '650', '500'); $usermgr_table_header = <<<EOT <input type="hidden" name="id" value="" /> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tr> <td> EOT; if (!$lim_user) { $usermgr_table_header .= cpg_fetch_icon('user_mgr', 2) . $lang_usermgr_php['user_manager'] . $help; } else { $usermgr_table_header .= cpg_fetch_icon('user_mgr', 2) . $lang_usermgr_php['memberlist']; } $usermgr_table_header .= <<<EOT </td> {$search_filter} <td class="sortorder_options" align="right"> {$lb} </td> </tr> </table> EOT; starttable('100%', $usermgr_table_header, $number_of_columns); // Accept header addons echo CPGPluginAPI::filter('usermgr_header', ''); if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_header = ''; } else { $pictures_quota_header = <<<EOT <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['pictures']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=pic_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['pic_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=pic_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['pic_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['disk_space_used']}/{$lang_usermgr_php['disk_space_quota']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=disku_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['disku_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=disku_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['disku_d']}" /></a> </td> EOT; } if (!$lim_user) { echo <<<EOT <tr> <td class="tableh1" align="center"> <input type="checkbox" {$makereadonly}name="checkAll" id="checkAll" onclick="selectAll('cpgform');" class="checkbox" title="{$lang_common['check_uncheck_all']}" style="display:none" /> </td> <td class="tableh1" colspan="2"> <span class="statlink">{$lang_usermgr_php['name']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['status']}</span> </td> <td class="tableh1"> <span class="statlink"><a href="groupmgr.php" class="statlink">{$lang_usermgr_php['group']}</a></span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['registered_on']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['last_visit']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['comments']}</span> </td> {$pictures_quota_header} </tr> EOT; } else { echo <<<EOT <tr> <td class="tableh1" colspan="2"> <span class="statlink">{$lang_usermgr_php['name']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=name_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['name_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['status']}</span> </td> <td class="tableh1"><span class="statlink">{$lang_usermgr_php['group']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=group_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['group_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['registered_on']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=reg_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['reg_d']}" /></a> </td> <td class="tableh1"> <span class="statlink">{$lang_usermgr_php['last_visit']}</span> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_a{$username}"><img src="images/ascending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_a']}" /></a> <a href="{$CPG_PHP_SELF}?page={$page}&sort=lv_d{$username}"><img src="images/descending.png" width="9" height="9" border="0" alt="" title="{$lang_usermgr_php['lv_d']}" /></a> </td> <td class="tableh1" align="center"> <span class="statlink">{$lang_usermgr_php['comments']}</span> </td> {$pictures_quota_header} </tr> EOT; } $loop_counter = 0; // query total number of files uploaded $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} LIMIT 1"); $tempPicCount = mysql_fetch_array($result); $totalPictureCount = $tempPicCount[0]; $totalPictureCount_fmt = cpg_float2decimal($totalPictureCount); mysql_free_result($result); unset($tempPicCount); // query total space used $result = cpg_db_query("SELECT SUM(total_filesize) FROM {$CONFIG['TABLE_PICTURES']} LIMIT 1"); $tempSpaceCount = mysql_fetch_array($result); $totalSpaceCount = $tempSpaceCount[0]; $totalSpaceCount_fmt = cpg_format_bytes($totalSpaceCount); mysql_free_result($result); unset($tempSpaceCount); // query total number of comments posted $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} LIMIT 1"); $tempCommentCount = mysql_fetch_array($result); $totalCommentCount = $tempCommentCount[0]; $totalCommentCount_fmt = cpg_float2decimal($totalCommentCount); mysql_free_result($result); unset($tempCommentCount); foreach ($users as $user) { if ($loop_counter == 0) { $row_style_class = 'tableb'; } else { $row_style_class = 'tableb tableb_alternate'; } $loop_counter++; if ($loop_counter > 1) { $loop_counter = 0; } if ($user['disk_usage'] == '') { $user['disk_usage'] = 0; } $group_quota_separator = '/'; // Determine actual quota if user belongs to more than one user group if ($user_groups = cpg_get_groups($user['user_id'])) { $quota = mysql_fetch_assoc(cpg_db_query("SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_quota >= 0 AND group_id IN (" . implode(", ", $user_groups) . ")")); $user['group_quota'] = $quota["disk_min"] ? $quota["disk_max"] : 0; } if ($user['group_quota']) { $disk_usage_output = theme_display_bar($user['disk_usage'], $user['group_quota'], 150, '', '', $group_quota_separator . $user['group_quota'] . ' ' . $lang_byte_units[1], 'red', 'green'); } else { $disk_usage_output = theme_display_bar($user['disk_usage'], $user['group_quota'], 150, '', '', ' ' . $lang_byte_units[1], 'green', 'green'); } if ($user['user_active'] == 'NO') { //$user['group_name'] = '<i>' . $lang_usermgr_php['inactive'] . '</i>'; $user['status'] = cpg_fetch_icon('offline', 0, $lang_usermgr_php['status_inactive']); $action = 'activate'; } else { $user['status'] = cpg_fetch_icon('online', 0, $lang_usermgr_php['status_active']); $action = 'deactivate'; } if (!$lim_user) { $user['status'] = '<a href="delete.php?id=u' . $user['user_id'] . '&album_listbox=' . $sort . '&action=' . $action . '&what=user&form_token=' . $form_token . '&timestamp=' . $timestamp . '" title="">' . $user['status'] . '</a>'; } $user['user_regdate'] = localised_date($user['user_regdate'], $lang_date['register']); if ($user['user_lastvisit']) { $user['user_lastvisit'] = localised_date($user['user_lastvisit'], $lang_date['register']); } else { $user['user_lastvisit'] = $lang_usermgr_php['never']; } $view_profile = '<a href="profile.php?uid=' . $user['user_id'] . '">' . cpg_fetch_icon('my_profile', 0, $lang_usermgr_php['view_profile']) . '</a>'; if ($user['pic_count']) { $last_uploads = '<a href="thumbnails.php?album=lastupby&uid=' . $user['user_id'] . '">' . cpg_fetch_icon('last_uploads', 0, $lang_usermgr_php['latest_upload']) . '</a>'; } else { if ($lim_user == 0) { $last_uploads = cpg_fetch_icon('last_uploads_disabled', 0, $lang_usermgr_php['no_latest_upload']); } else { $last_uploads = cpg_fetch_icon('blank', 0); } } // fetch number of comments and add link to comments if applicable if ($lim_user == 0) { $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE author_id = {$user['user_id']}"); // display all comments for the admin } else { $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE author_id = {$user['user_id']} AND approval = 'YES' "); // only display approved comments for non-admin } $commentCount = mysql_fetch_array($result); $user['comment_num'] = $commentCount[0]; mysql_free_result($result); if ($user['comment_num'] > 0) { $user_comment_link = '<a href="thumbnails.php?album=lastcomby&uid=' . $user['user_id'] . '">' . cpg_fetch_icon('comment', 0, $lang_usermgr_php['last_comments'] . '(' . $user['comment_num'] . ')') . '</a>'; } else { $user_comment_link = cpg_fetch_icon('blank', 0, $lang_usermgr_php['no_last_comments']); } // create comments bar $comment_quota_output = theme_display_bar($user['comment_num'], $totalCommentCount, 60, '', '', '', 'red', ''); // create files bar $file_quota_output = theme_display_bar($user['pic_count'], $totalPictureCount, 60, '', '', '', 'red', ''); // Look up banned table if (mysql_num_rows(cpg_db_query("SELECT user_name FROM {$CONFIG['TABLE_BANNED']} WHERE user_name = '" . addslashes($user['user_name']) . "' AND brute_force=0 LIMIT 1"))) { $ban_user_link = '<a href="banning.php">' . cpg_fetch_icon('ban_user_disabled', 0, $lang_usermgr_php['user_is_banned']) . '</a>'; $ban_memberlist = cpg_fetch_icon('ban_user_disabled', 0, $lang_usermgr_php['user_is_banned']); } else { $ban_user_link = '<a href="banning.php?ban_user='******'user_id'] . '">' . cpg_fetch_icon('ban_user', 0, $lang_usermgr_php['ban_user']) . '</a>'; $ban_memberlist = ''; } if (!$lim_user) { if ($user['user_id'] == $USER_DATA['user_id']) { $profile_link = 'profile.php?op=edit_profile'; $checkbox_html = ''; $ban_user_link = cpg_fetch_icon('blank', 0); } else { $profile_link = $CPG_PHP_SELF . '?op=edit&user_id=' . $user['user_id'] . '&form_token=' . $form_token . '&timestamp=' . $timestamp; $checkbox_html = '<input name="u' . $user['user_id'] . '" ' . $makereadonly . 'type="checkbox" value="" class="checkbox" />'; } $profile_link = '<a href="' . $profile_link . '">' . cpg_fetch_icon('edit', 0, $lang_usermgr_php['edit_profile']) . '</a>'; if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_data = ''; } else { $pictures_quota_data = <<<EOT <td class="{$row_style_class}" align="right">{$file_quota_output}</td> <td class="{$row_style_class}" align="center">{$disk_usage_output}</td> EOT; } echo <<<EOT <tr> <td class="{$row_style_class}" align="center">{$checkbox_html}</td> <td class="{$row_style_class}">{$user['user_name']}</td> <td class="{$row_style_class}" align="left"> {$view_profile} {$profile_link} {$last_uploads} {$ban_user_link} {$user_comment_link} </td> <td class="{$row_style_class}">{$user['status']}</td> <td class="{$row_style_class}">{$user['group_name']}</td> <td class="{$row_style_class}">{$user['user_regdate']}</td> <td class="{$row_style_class}">{$user['user_lastvisit']}</td> <td class="{$row_style_class}" align="right">{$comment_quota_output}</td> {$pictures_quota_data} </tr> EOT; } else { if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_data = ''; } else { $pictures_quota_data = <<<EOT <td class="{$row_style_class}" align="right">{$user['pic_count']}</td> <td class="{$row_style_class}" align="center">{$disk_usage_output}</td> EOT; } echo <<<EOT <tr> <td class="{$row_style_class}">{$user['user_name']}</td> <td class="{$row_style_class}">{$view_profile}{$last_uploads}{$user_comment_link}</td> <td class="{$row_style_class}">{$user['status']}{$ban_memberlist}</td> <td class="{$row_style_class}">{$user['group_name']}</td> <td class="{$row_style_class}">{$user['user_regdate']}</td> <td class="{$row_style_class}">{$user['user_lastvisit']}</td> <td class="{$row_style_class}" align="right">{$user['comment_num']}</td> {$pictures_quota_data} </tr> EOT; } } // while //mysql_free_result($result); if ($CONFIG['user_manager_hide_file_stats']) { $pictures_quota_footer = ''; } else { $pictures_quota_footer = <<<EOT <td align="right" class="tablef">{$totalPictureCount_fmt}</td> <td align="right" class="tablef">{$totalSpaceCount_fmt}</td> EOT; } if (!$lim_user) { if ($search) { $search_string_default = 'value="' . $search . '"'; } else { $search_string_default = 'value="' . $lang_usermgr_php['search'] . '" onfocus="this.value=\'\'"'; } $help = cpg_display_help('f=users.htm&as=user_cp_search&ae=user_cp_search_end&top=1', '400', '150'); echo <<<EOT <tr> <td class="tablef" align="center"><input type="checkbox" name="checkAll2" id="checkAll2" {$makereadonly}onclick="selectAll('cpgform');" class="checkbox" title="{$lang_common['check_uncheck_all']}" style="display:none" /></td> <td colspan="{$number_of_columns_minus_four}" class="tablef"> <table cellpadding="0" cellspacing="0" width="100%" border="0"> <tr> <td align="left"> <select name="action" id="action" size="1" class="listbox" {$makereadonly}onchange="return selectaction(this,'u');" style="display:none"> <option value="" selected="selected">{$lang_usermgr_php['with_selected']}</option> <option value="delete">{$lang_common['delete']}</option> <option value="activate">{$lang_usermgr_php['activate']}</option> <option value="deactivate">{$lang_usermgr_php['deactivate']}</option> <option value="reset_password">{$lang_usermgr_php['reset_password']}</option> <option value="change_group">{$lang_usermgr_php['change_primary_membergroup']}</option> <option value="add_group">{$lang_usermgr_php['add_secondary_membergroup']}</option> </select> <input type="hidden" name="what" value="user"/> <input type="text" name="new_password" value="{$lang_usermgr_php['password']}" size="8" maxlength="25" class="textinput" onfocus="this.value='';" style="display:none" /> <select name="group" size="1" class="listbox" style="display:none" onchange="return selectaction(this,'u');"> <option value="">{$lang_usermgr_php['select_group']}</option> EOT; $sql = "SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} ORDER BY group_name"; $result = cpg_db_query($sql); $group_list = cpg_db_fetch_rowset($result); mysql_free_result($result); if (isset($element[1])) { $sel_group = $user_data[$element[1]]; } else { $sel_group = ''; } foreach ($group_list as $group) { if ($group['group_id'] != 3) { print ' <option value="' . $group['group_id'] . '"' . ($group['group_id'] == $sel_group ? ' selected' : '') . '>' . $group['group_name'] . '</option>' . $LINEBREAK; } } $help_create = ' ' . cpg_display_help('f=users.htm&as=user_cp_new&ae=user_cp_new_end', '600', '250'); $create_new_user_icon = cpg_fetch_icon('add_user', 2); list($timestamp, $form_token) = getFormToken(); echo <<<EOT </select> <select name="delete_files" size="1" class="listbox" style="display:none"> <option value="no">{$lang_usermgr_php['delete_files_no']}</option> <option value="yes">{$lang_usermgr_php['delete_files_yes']}</option> </select> <select name="delete_comments" size="1" class="listbox" style="display:none"> <option value="no">{$lang_usermgr_php['delete_comments_no']}</option> <option value="yes">{$lang_usermgr_php['delete_comments_yes']}</option> </select> <button type="submit" class="button" name="go" value="{$lang_usermgr_php['submit']}" style="display:none">{$icon_array['ok']}{$lang_usermgr_php['submit']}</button> </td> </tr> </table> <input type="hidden" name="form_token" value="{$form_token}" /> <input type="hidden" name="timestamp" value="{$timestamp}" /> </td> <td align="right" class="tablef">{$totalCommentCount_fmt}</td> {$pictures_quota_footer} </tr> EOT; endtable(); echo '</form>'; starttable('100%'); echo <<<EOT <tr> <td colspan="{$number_of_columns}" class="tablef" align="center" valign="middle"> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tr> <td class="tablef" align="center" valign="middle"> <form method="post" action="{$CPG_PHP_SELF}" name="searchUser" id="cpgform2"> <input type="text" name="username" class="textinput" {$search_string_default} /> <button type="submit" class="button" name="user_search" value="{$lang_usermgr_php['search_submit']}">{$icon_array['search']}{$lang_usermgr_php['search_submit']}</button> {$help} </form> </td> <td class="tablef" align="center" valign="middle"> <a href="{$CPG_PHP_SELF}?op=new_user&form_token={$form_token}&timestamp={$timestamp}" {$makereadonly}class="admin_menu">{$create_new_user_icon}{$lang_usermgr_php['create_new_user']}</a> {$help_create} </td> </tr> </table> </td> </tr> EOT; } else { echo <<<EOT <tr> <td colspan="{$number_of_columns_minus_three}" class="tablef" align="left" valign="middle"> {$lang_usermgr_php['total']} </td> <td class="tablef" align="right" valign="middle"> {$totalCommentCount_fmt} </td> {$pictures_quota_footer} </tr> EOT; } // Accept footer addons for the user manager echo CPGPluginAPI::filter('usermgr_footer', ''); if ($tabs) { echo <<<EOT <tr> <td colspan="{$number_of_columns}" style="padding: 0px;"> <table width="100%" cellspacing="0" cellpadding="0"> <tr> {$tabs} </tr> </table> </td> </tr> EOT; } endtable(); }
/** * get_cat_list() * * List all categories * * @param string $breadcrumb * @param array $cat_data * @param string $statistics * @return void **/ function get_cat_list(&$breadcrumb, &$cat_data, &$statistics) { global $CONFIG, $BREADCRUMB_TEXT, $STATS_IN_ALB_LIST, $FORBIDDEN_SET; global $HIDE_USER_CAT, $cpg_show_private_album; global $cat; global $lang_list_categories; // Build the breadcrumb breadcrumb($cat, $breadcrumb, $BREADCRUMB_TEXT); // Build the category list $cat_data = array(); get_subcat_data($cat_data); $album_filter = ''; $pic_filter = ''; $cat = (int) $cat; if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) { $album_filter = ' ' . str_replace('p.', 'a.', $FORBIDDEN_SET); $pic_filter = $FORBIDDEN_SET; } // Gather gallery statistics - start if ($CONFIG['display_stats_on_index'] != 0) { if ($cat == 0) { $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_ALBUMS']} AS a WHERE 1 " . $album_filter); $nbEnr = $result->fetchRow(true); $album_count = $nbEnr[0]; $sql = "SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']}"; if ($pic_filter) { $sql .= " AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = p.aid WHERE approved = 'YES' {$pic_filter}"; } else { $sql .= " WHERE approved = 'YES'"; } $result = cpg_db_query($sql); $nbEnr = $result->fetchRow(true); $picture_count = $nbEnr[0]; $sql = "SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']}"; if ($pic_filter) { $sql .= " AS c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.pid = c.pid INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = p.aid WHERE 1 {$pic_filter}"; } if ($CONFIG['comment_approval']) { if ($pic_filter) { $sql .= " AND approval = 'YES'"; } else { $sql .= " WHERE approval = 'YES'"; } } $result = cpg_db_query($sql); $nbEnr = $result->fetchRow(true); $comment_count = $nbEnr[0]; $sql = "SELECT COUNT(*) FROM {$CONFIG['TABLE_CATEGORIES']}"; $result = cpg_db_query($sql); $nbEnr = $result->fetchRow(true); $cat_count = $nbEnr[0] - $HIDE_USER_CAT; $sql = "SELECT SUM(hits) FROM {$CONFIG['TABLE_PICTURES']}"; if ($pic_filter) { $sql .= " AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = p.aid WHERE approved = 'YES' {$pic_filter}"; } else { $sql .= " WHERE approved = 'YES'"; } $result = cpg_db_query($sql); $nbEnr = $result->fetchRow(true); $hit_count = (int) $nbEnr[0]; if (count($cat_data)) { $statistics = strtr($lang_list_categories['stat1'], array('[pictures]' => '<strong>' . cpg_float2decimal($picture_count) . '</strong>', '[albums]' => '<strong>' . cpg_float2decimal($album_count) . '</strong>', '[cat]' => '<strong>' . cpg_float2decimal($cat_count) . '</strong>', '[comments]' => '<strong>' . cpg_float2decimal($comment_count) . '</strong>', '[views]' => '<strong>' . cpg_float2decimal($hit_count) . '</strong>')); } else { $STATS_IN_ALB_LIST = true; $statistics = strtr($lang_list_categories['stat3'], array('[pictures]' => '<strong>' . cpg_float2decimal($picture_count) . '</strong>', '[albums]' => '<strong>' . cpg_float2decimal($album_count) . '</strong>', '[comments]' => '<strong>' . cpg_float2decimal($comment_count) . '</strong>', '[views]' => '<strong>' . cpg_float2decimal($hit_count) . '</strong>')); } } else { $statistics = ''; } } else { // Gather gallery statistics - end $statistics = ''; } }
<button type="submit" class="button" name="save_changes" id="save_changes" value="{$lang_reviewcom_php['save_changes']}">{$icon_array['ok']}{$lang_reviewcom_php['save_changes']}</button> </td> </tr> EOT; endtable(); list($timestamp, $form_token) = getFormToken(); echo "<input type=\"hidden\" name=\"form_token\" value=\"{$form_token}\" />\n <input type=\"hidden\" name=\"timestamp\" value=\"{$timestamp}\" /></form>"; if ($CONFIG['comment_akismet_api_key'] != '') { print '<br /><a name="akismet"></a>'; starttable('-2', $icon_array['info'] . $lang_reviewcom_php['akismet'], 2); print <<<EOT <tr> <td class="tableb" colspan="2"> EOT; print sprintf($lang_reviewcom_php['akismet_count'] . '.', '<strong>' . cpg_float2decimal($CONFIG['comment_akismet_counter']) . '</strong>'); print <<<EOT </td> </tr> EOT; $test_text = sprintf($lang_reviewcom_php['akismet_test_result'], '<strong>' . $CONFIG['comment_akismet_api_key'] . '</strong>'); $result = cpg_akismet_verify_key(); if (stripos($result[0], '404 Not Found') != FALSE) { $test_result = $icon_array['cancel'] . $lang_reviewcom_php['not_found']; $test_error = $result[0]; } elseif (stripos($result[1], 'Error') != FALSE) { $test_result = $icon_array['stop'] . $lang_reviewcom_php['unknown_error']; $test_error = $result[1]; } elseif ($result == TRUE) { $test_result = $icon_array['ok'] . $lang_common['ok']; $test_error = '';
function theme_display_cat_list($breadcrumb, &$cat_data, $statistics) { global $template_cat_list, $lang_cat_list; if (count($cat_data) > 0) { starttable('100%'); $template = template_extract_block($template_cat_list, 'header'); $params = array('{CATEGORY}' => $lang_cat_list['category'], '{ALBUMS}' => $lang_cat_list['albums'], '{PICTURES}' => $lang_cat_list['pictures']); echo template_eval($template, $params); } $template_noalb = template_extract_block($template_cat_list, 'catrow_noalb'); $template = template_extract_block($template_cat_list, 'catrow'); foreach ($cat_data as $category) { if (!isset($category['cat_thumb'])) { $category['cat_thumb'] = ''; } if (count($category) == 3) { $params = array('{CAT_TITLE}' => $category[0], '{CAT_THUMB}' => $category['cat_thumb'], '{CAT_DESC}' => $category[1]); echo template_eval($template_noalb, $params); } elseif (isset($category['cat_albums']) && $category['cat_albums'] != '') { $params = array('{CAT_TITLE}' => $category[0], '{CAT_THUMB}' => $category['cat_thumb'], '{CAT_DESC}' => $category[1], '{CAT_ALBUMS}' => $category['cat_albums'], '{ALB_COUNT}' => cpg_float2decimal($category[2]), '{PIC_COUNT}' => cpg_float2decimal($category[3])); echo template_eval($template, $params); } else { $params = array('{CAT_TITLE}' => $category[0], '{CAT_THUMB}' => $category['cat_thumb'], '{CAT_DESC}' => $category[1], '{CAT_ALBUMS}' => '', '{ALB_COUNT}' => cpg_float2decimal($category[2]), '{PIC_COUNT}' => cpg_float2decimal($category[3])); echo template_eval($template, $params); } } if ($statistics && count($cat_data) > 0) { $template = template_extract_block($template_cat_list, 'footer'); $params = array('{STATISTICS}' => $statistics); echo template_eval($template, $params); } if (count($cat_data) > 0) { endtable(); } echo template_extract_block($template_cat_list, 'spacer'); }
$option_output['plugin_enlargeit_buttonhist'] .= ''; } else { $option_output['plugin_enlargeit_buttonhist'] .= ' disabled="disabled"'; } if ($enlargeit_gd_version == '') { $enlargeit_gd_version = $lang_plugin_enlargeit['not_available']; } $gd_version_string = sprintf($lang_plugin_enlargeit['gd_version'], $enlargeit_gd_version); $result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE histogram_filesize>'0'"); list($cache_count) = mysql_fetch_row($result); mysql_free_result($result); $result = cpg_db_query("SELECT SUM(histogram_filesize) AS sum_histogram FROM {$CONFIG['TABLE_PICTURES']} WHERE histogram_filesize>'0'"); $row = mysql_fetch_assoc($result); $cache_sum = $row['sum_histogram']; mysql_free_result($result); $cached_files = sprintf($lang_plugin_enlargeit['file_cache_x_files_using_x_bytes'], cpg_float2decimal($cache_count), cpg_format_bytes($cache_sum)); if ($CONFIG['plugin_enlargeit_buttonnav'] == '1') { $option_output['plugin_enlargeit_buttonnav'] = 'checked="checked"'; } else { $option_output['plugin_enlargeit_buttonnav'] = ''; } if ($CONFIG['plugin_enlargeit_buttonclose'] == '1') { $option_output['plugin_enlargeit_buttonclose'] = 'checked="checked"'; } else { $option_output['plugin_enlargeit_buttonclose'] = ''; } if ($CONFIG['plugin_enlargeit_flvplayer'] == '0') { $option_output['plugin_enlargeit_flvplayer_0'] = 'checked="checked"'; $option_output['plugin_enlargeit_flvplayer_1'] = ''; } elseif ($CONFIG['plugin_enlargeit_flvplayer'] == '1') { //