$result = $site_db->query($sql);
$config = array();
while ($row = $site_db->fetch_array($result)) {
$config[$row['setting_name']] = $row['setting_value'];
}
show_form_header("settings.php", "updatesettings");
show_table_header($lang['nav_general_settings'], 2);
echo "<tr class=\"tablerow\"><td colspan=\"2\">";
echo "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\"><tr valign=\"top\">\n";
$numgroups = sizeof($setting_group);
$percolumn = ceil($numgroups / 2);
$settingcounter = 0;
foreach ($setting_group as $key => $val) {
$settingcounter++;
echo "<td>";
show_text_link($val, "#setting_group_" . $key);
echo "<br /></td>\n";
if ($settingcounter == 4) {
echo "</tr><tr>";
$settingcounter = 0;
}
}
echo "</tr></table>\n";
echo "</td></tr>";
show_table_separator($setting_group[1], 2, "setting_group_1");
show_setting_row("site_name", "", 1);
show_setting_row("site_email");
show_setting_row("use_smtp", "radio");
show_setting_row("smtp_host");
show_setting_row("smtp_username");
show_setting_row("smtp_password");
$where_t = where($error[4]);
echo "<tr align=\"center\" class=\"" . get_row_bg() . "\"><td>{$i}</td>";
echo "<td><input type=\"checkbox\" name=\"selectimages[]\" value=\"" . $image_row['image_id'] . "\" /></td>";
echo "<td align=\"left\">";
$thumb = "<img src=\"" . (empty($image_row['image_thumb_file']) ? ICON_PATH . "/" . get_file_extension($image_row['image_media_file']) . ".gif" : (is_remote($image_row['image_thumb_file']) ? remote_file_exists($image_row['image_thumb_file'], 1) ? $image_row['image_thumb_file'] : ICON_PATH . "/404.gif" : (file_exists(ROOT_PATH . THUMB_DIR . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file']) ? ROOT_PATH . THUMB_DIR . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file'] : ICON_PATH . "/404.gif"))) . "\" width=\"40\" height=\"40\" border=\"1\" alt=\"\" /><b> " . $image_row['image_name'] . "</b>";
echo "<a href=\"../images.php?action=editimage&image_id=" . $image_row['image_id'] . "\" target=\"4images_editimage\">" . $thumb . "</a>";
echo "</td><td>" . $image_row['image_id'] . "</td>";
echo "<td><a href=\"" . $site_sess->url(ROOT_PATH . "categories.php?" . URL_CAT_ID . "=" . $image_row['cat_id']) . "\" target=\"_blank\">" . htmlspecialchars($cat_cache[$image_row['cat_id']]['cat_name']) . " [ID: <b>" . $image_row['cat_id'] . "</b>]</a></td>\n";
$show_user_name = htmlspecialchars($image_row[$user_table_fields['user_name']]);
if ($image_row['user_id'] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $image_row['user_id']) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td>" . $show_user_name . "</a></td>\n";
echo "<td>" . format_date($config['date_format'], $image_row['image_date']) . "</td>\n";
echo "<td><font color={$where}>{$ok_show}</font></td><td>" . substr(strrchr($image_row['image_media_file'], "."), 1) . "</td>" . ($thumbs ? "<td><font color={$where_t}>{$ok_t_show}</font></td><td>" . substr(strrchr($image_row['image_thumb_file'], "."), 1) . "</td>" : "") . "<td> ";
show_text_link("View", "../../details.php?" . URL_IMAGE_ID . "=" . $image_row['image_id'], 1);
show_text_link($lang['edit'], "../images.php?action=editimage&image_id=" . $image_row['image_id'], 1);
show_text_link($lang['delete'], "files_check.php?action=removeimage&image_id=" . $image_row['image_id']);
echo "</td></tr>\n";
$i++;
}
echo "<tr class=\"tablefooter\">\n<td colspan=\"12\" align=\"left\" class=\"tableseparator\">\n ";
echo "<input type=\"submit\" value=\" " . $lang['delete'] . " \" class=\"button\">\n ";
echo "</tr></table></td></tr></table><br>";
show_text_link("Back", "files_check.php");
} else {
echo "<p><b>Files Check Complete!<br /><br /> No more errors found.</b><p>\n";
show_text_link("Back", "files_check.php");
}
}
show_admin_footer();
if (strlen($comment_row['comment_text']) > 75) {
$comment_row['comment_text'] = substr($comment_row['comment_text'], 0, 75) . "...";
}
$show_comment .= format_text($comment_row['comment_text']);
echo "<td>" . $show_comment . "</td>\n";
$show_user_name = format_text($comment_row['user_name'], 2);
if ($comment_row['user_id'] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $comment_row['user_id']) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td>" . $show_user_name . "</td>\n";
$show_image = "<a href=\"" . $site_sess->url(ROOT_PATH . "details.php?" . URL_IMAGE_ID . "=" . $comment_row['image_id']) . "\" target=\"_blank\">" . format_text($comment_row['image_name'], 2) . "</a> (ID: " . $comment_row['image_id'] . ")";
echo "<td>" . $show_image . "</td>\n";
echo "<td>" . format_date($config['date_format'] . " " . $config['time_format'], $comment_row['comment_date']) . "</td>\n";
echo "<td><p>";
show_text_link($lang['edit'], "comments.php?action=editcomment&comment_id=" . $comment_row['comment_id']);
show_text_link($lang['delete'], "comments.php?action=removecomment&comment_id=" . $comment_row['comment_id']);
echo "</p></td>\n";
echo "</tr>\n";
}
echo "<tr class=\"tablefooter\">\n<td colspan=\"6\" align=\"left\">\n ";
echo "<input type=\"submit\" value=\" " . $lang['delete'] . " \" class=\"button\">\n";
echo " \n</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>\n</form>\n";
} else {
show_description_row($lang['no_search_results'], 6);
show_form_footer("", "");
}
echo "<div align=\"right\">";
echo "<form action=\"" . $site_sess->url("comments.php") . "\" name=\"form2\" method=\"post\">\n";
if ($limitnumber != 5000 && $limitfinish < $countcomments['comments']) {
show_hidden_input("action", "findcomments");
show_hidden_input("image_id", $image_id);
show_form_footer($lang['do_backup'], $lang['reset']);
show_table_header($lang['list_backups'], 4);
$handle = opendir(ROOT_PATH . DATABASE_DIR);
$filelist = array();
while ($file = @readdir($handle)) {
if (is_file(ROOT_PATH . DATABASE_DIR . "/" . $file) && $file != "." && $file != ".." && preg_match("/\\.sql/i", $file)) {
$filelist[] = $file;
}
}
closedir($handle);
if (!empty($filelist)) {
rsort($filelist);
foreach ($filelist as $key => $file) {
echo "<tr class=\"" . get_row_bg() . "\" width=\"30%\">\n<td><p class=\"rowtitle\">{$file}</p></td>\n";
$file_time = format_date($config['date_format'] . " " . $config['time_format'], filemtime(ROOT_PATH . DATABASE_DIR . "/" . $file));
echo "<td>" . $file_time . "</td>";
$file_size = format_file_size(@filesize(ROOT_PATH . DATABASE_DIR . "/" . $file));
echo "<td>" . $file_size . "</td>";
echo "<td>";
echo "<a href=\"javascript:RestoreBackup('" . $file . "')\">[" . $lang['restore_backup'] . "]</a> ";
echo "<a href=\"javascript:DeleteBackup('" . $file . "')\">[" . $lang['delete_backup'] . "]</a> ";
show_text_link($lang['download_backup'], "backup.php?action=downloadbackup&file={$file}");
show_text_link($lang['show_backup'], "backup.php?action=showbackup&file={$file}");
echo "</td></tr>";
}
} else {
show_description_row($lang['no_backups'], 4);
}
show_table_footer();
}
show_admin_footer();
echo "<td><input type=\"checkbox\" name=\"deleteimages[]\" value=\"" . $image_row['image_id'] . "\" /></td>";
echo "<td><b><a href=\"" . $site_sess->url(ROOT_PATH . "details.php?" . URL_IMAGE_ID . "=" . $image_row['image_id']) . "\" target=_blank>" . format_text($image_row['image_name'], 2) . "</a></b> (" . $image_row['image_media_file'];
if (!get_file_path($image_row['image_media_file'], "media", $image_row['cat_id'], 1, 0)) {
echo " <b class=\"marktext\">!</b>";
}
echo ")</td>\n";
echo "<td><a href=\"" . $site_sess->url(ROOT_PATH . "categories.php?" . URL_CAT_ID . "=" . $image_row['cat_id']) . "\" target=\"_blank\">" . format_text($cat_cache[$image_row['cat_id']]['cat_name'], 2) . "</a></td>\n";
$show_user_name = format_text($image_row[$user_table_fields['user_name']], 2);
if ($image_row['user_id'] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $image_row['user_id']) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td>" . $show_user_name . "</a></td>\n";
echo "<td>" . format_date($config['date_format'], $image_row['image_date']) . "</td>\n";
echo "<td><p>";
show_text_link($lang['edit'], "images.php?action=editimage&image_id=" . $image_row['image_id']);
show_text_link($lang['delete'], "images.php?action=removeimage&image_id=" . $image_row['image_id']);
echo "</p></td>\n";
echo "</tr>\n";
}
echo "<tr class=\"tablefooter\">\n<td colspan=\"6\" align=\"left\">\n ";
echo "<input type=\"submit\" value=\" " . $lang['delete'] . " \" class=\"button\">\n";
echo " \n</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>\n</form>\n";
} else {
show_description_row($lang['no_search_results'], 6);
show_form_footer("", "");
}
echo "<div align=\"right\">";
echo "<form action=\"" . $site_sess->url("images.php") . "\" name=\"form2\" method=\"post\">\n";
//if ($limitnumber != 5000 && $limitfinish < $countimages['images']) {
show_hidden_input("action", "findimages");
show_hidden_input("image_id", $image_id);
if (!isset($HTTP_POST_VARS['emails']) || empty($HTTP_POST_VARS['emails'])) {
$error['emails'] = 1;
}
if (empty($error)) {
@set_time_limit(1200);
include ROOT_PATH . 'includes/email.php';
$site_email = new Email();
$site_email->set_to($config['site_email']);
$site_email->set_subject($subject);
$site_email->register_vars(array("message" => $message, "site_email" => $config['site_email'], "site_name" => $config['site_name']));
$site_email->set_body("admin_email", $config['language_dir']);
$emails = $HTTP_POST_VARS['emails'];
$site_email->set_bcc($emails);
echo $site_email->send_email() ? $lang['send_emails_success'] : $lang['send_emails_error'];
echo "<p>";
show_text_link($lang['back'], "javascript:history.back(1)");
} else {
$msg = sprintf("<span class=\"marktext\">%s</span>", $lang['lostfield_error']);
$action = "emailusers";
}
}
if ($action == "emailusers") {
if ($msg != "") {
printf("<b>%s</b>\n", $msg);
}
show_form_header("email.php", "sendemails");
show_table_header($lang['send_emails'], 2);
show_input_row($lang['send_emails_subject'], "subject", "", 45);
show_textarea_row($lang['send_emails_message'], "message", "", 60, 20);
$select = "<select name=\"emails[]\" size=\"15\" multiple=\"multiple\">\n";
$sql = "SELECT " . get_user_table_field("", "user_id") . get_user_table_field(", ", "user_level") . get_user_table_field(", ", "user_name") . get_user_table_field(", ", "user_email") . "\n FROM " . USERS_TABLE . "\n WHERE " . get_user_table_field("", "user_id") . " <> " . GUEST . " AND " . get_user_table_field("", "user_allowemails") . " = 1\n ORDER BY " . get_user_table_field("", "user_level") . " DESC";
$show_user_name = format_text($user_row[$user_table_fields['user_name']], 2);
if ($user_row[$user_table_fields['user_id']] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $user_row[$user_table_fields['user_id']]) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td><b>" . $show_user_name . "</b></td>\n";
echo "<td>" . $user_row[$user_table_fields['user_email']] . "</td>\n";
echo "<td>" . format_date($config['date_format'] . " " . $config['time_format'], $user_row[$user_table_fields['user_joindate']]) . "</td>\n";
echo "<td>" . format_date($config['date_format'] . " " . $config['time_format'], $user_row[$user_table_fields['user_lastaction']]) . "</td>\n";
echo "<td><p>";
if (!defined('USER_INTEGRATION') || defined('USER_INTEGRATION') && USER_INTEGRATION == "none") {
show_text_link($lang['edit'], "users.php?action=edituser&user_id=" . $user_row[$user_table_fields['user_id']]);
}
show_text_link($lang['delete'], "users.php?action=removeuser&user_id=" . $user_row[$user_table_fields['user_id']]);
echo " ";
show_text_link($lang['permissions'], "usergroups.php?action=editpermissions&user_id=" . $user_row[$user_table_fields['user_id']]);
show_text_link($lang['nav_usergroups'], "usergroups.php?action=edituser&user_id=" . $user_row[$user_table_fields['user_id']]);
echo "</p></td>\n";
echo "</tr>\n";
}
echo "<tr class=\"tablefooter\">\n<td colspan=\"6\" align=\"left\">\n ";
echo "<input type=\"submit\" value=\" " . $lang['delete'] . " \" class=\"button\">\n";
echo " \n</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>\n</form>\n";
} else {
show_description_row($lang['no_search_results'], 6);
show_form_footer("", "");
}
echo "<div align=\"right\">";
echo "<form action=\"" . $site_sess->url("users.php") . "\" name=\"form2\" method=\"post\">\n";
//if ($limitnumber != 5000 && $limitfinish < $countusers['users']) {
show_hidden_input("action", "findusers");
show_hidden_input("user_level", $user_level);
echo "<tr class=\"" . get_row_bg() . "\">";
$image_path = is_remote($image_row['image_media_file']) ? $image_row['image_media_file'] : MEDIA_TEMP_PATH . "/" . $image_row['image_media_file'];
$file_src = get_file_path($image_row['image_media_file'], "media", 0, 1);
echo "<td><input type=\"radio\" name=\"image_list[" . $image_row['image_id'] . "]\" value=\"1\"></td>";
echo "<td><input type=\"radio\" name=\"image_list[" . $image_row['image_id'] . "]\" value=\"0\"></td>";
echo "<td><a href=\"" . $image_path . "\" target=\"_blank\"><img src=\"" . $file_src . "\" border=\"1\" height=\"50\"></a></td>";
echo "<td><b><a href=\"" . $image_path . "\" target=\"_blank\">" . format_text($image_row['image_name'], 2) . "</a></b> (" . $image_row['image_media_file'];
if (!get_file_path($image_row['image_media_file'], "media", 0, 0, 0)) {
echo " <b class=\"marktext\">!</b>";
}
echo ")</td>\n";
echo "<td><a href=\"" . $site_sess->url(ROOT_PATH . "categories.php?" . URL_CAT_ID . "=" . $image_row['cat_id']) . "\" target=\"_blank\">" . format_text($cat_cache[$image_row['cat_id']]['cat_name'], 2) . "</a></td>\n";
$show_user_name = format_text($image_row[$user_table_fields['user_name']], 2);
if ($image_row['user_id'] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $image_row['user_id']) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td>" . $show_user_name . "</td>\n";
echo "<td>" . format_date($config['date_format'] . " " . $config['time_format'], $image_row['image_date']) . "</td>\n";
echo "<td><p>";
show_text_link($lang['edit'], "validateimages.php?action=editimage&image_id=" . $image_row['image_id']);
echo "</p></td>\n";
echo "</tr>\n";
}
show_form_footer($lang['submit'], $lang['reset'], 8);
} else {
$bgcounter = 0;
show_description_row($lang['no_search_results'], 8);
show_table_footer();
}
}
show_admin_footer();
function show_category_rows($cid = 0, $depth = 1)
{
global $site_db, $site_sess, $lang, $category_cache, $cat_parent_cache;
if (!isset($category_cache[$cid])) {
return false;
}
foreach ($category_cache[$cid] as $key => $cats) {
$class = "tablerow2";
if ($cats['cat_parent_id'] == 0) {
$class = "tablerow";
}
echo "<tr class=\"{$class}\">\n";
if (!$GLOBALS['show_all_subcats']) {
if (!empty($cat_parent_cache[$cats['cat_id']])) {
$href = $site_sess->url("categories.php?action=modifycats");
if (isset($GLOBALS['map'][$cats['cat_id']]) || $GLOBALS['open_all']) {
$char = $GLOBALS['close_cat_link'];
$href .= "&closecat=" . $cats['cat_id'];
} else {
$char = $GLOBALS['open_cat_link'];
$href .= "&opencat=" . $cats['cat_id'];
}
$char = '<a href="' . $href . '">' . $char . '</a>';
} else {
$char = ' ';
}
echo "<td align=\"center\">" . $char . "</td>";
}
echo "<td>\n";
if ($depth > 1) {
echo str_repeat(" ", $depth - 1) . "<img src=\"images/folder_path.gif\" alt=\"\">\n";
}
echo "<img src=\"" . ROOT_PATH . "admin/images/folder.gif\" alt=\"\"><b><a href=\"" . $site_sess->url(ROOT_PATH . "categories.php?cat_id=" . $cats['cat_id']) . "\" target=\"_blank\">" . format_text($cats['cat_name'], 2) . "</a>\n</b> (ID: " . $cats['cat_id'] . ") ";
show_text_link($lang['edit'], "categories.php?action=editcat&cat_id=" . $cats['cat_id']);
show_text_link($lang['delete'], "categories.php?action=removecat&cat_id=" . $cats['cat_id']);
show_text_link($lang['add_subcategory'], "categories.php?action=addcat&cat_parent_id=" . $cats['cat_id']);
echo "\n</td>\n<td align=\"center\">";
echo "<a href=\"" . $site_sess->url("categories.php?action=ordercat&move=up&cat_id=" . $cats['cat_id']) . "\"><img src=\"images/arrow_up.gif\" border=\"0\"></a>\n";
echo "<a href=\"" . $site_sess->url("categories.php?action=ordercat&move=down&cat_id=" . $cats['cat_id']) . "\"><img src=\"images/arrow_down.gif\" border=\"0\"></a>\n";
echo "</td>\n</tr>\n";
show_category_rows($cats['cat_id'], $depth + 1);
}
unset($category_cache[$cid]);
}
if ($cat_id) {
$batchend = $row['image_id'];
}
printf($lang_rebuild_image, $row['image_name'], $row['image_id']);
flush();
@set_time_limit(90);
$search_words = array();
foreach ($search_match_fields as $image_column => $match_column) {
if (isset($row[$image_column])) {
$search_words[$image_column] = $row[$image_column];
}
}
remove_searchwords($row['image_id']);
add_searchwords($row['image_id'], $search_words);
echo " <b>OK</b><br />\n";
flush();
}
if ($num_rows) {
$sql = "SELECT cat_id\n FROM " . IMAGES_TABLE . "\n WHERE {$cat_filter} AND image_id >= " . ($batchend + 1) . $order;
$num_rows = $site_db->query_firstrow($sql);
}
if ($num_rows) {
next_step($batchend + 1, $batchsize, $autoredirect);
show_text_link($lang_rebuild_back, "rebuild_searchindex.php");
} else {
echo "<p><b>" . $lang_rebuild_success . "</b><p>\n";
show_text_link($lang_rebuild_back, "rebuild_searchindex.php");
$site_sess->set_session_var("rsibatchstart", 0);
}
}
show_admin_footer();
show_form_header("usergroups.php", "updategroup");
show_hidden_input("group_id", $group_id);
show_table_header($lang['nav_usergroups'], 2);
show_input_row($lang['field_usergroup_name'], "group_name", $result['group_name'], $textinput_size);
show_form_footer($lang['save_changes'], $lang['reset'], 2, $lang['back']);
}
if ($action == "modifygroups") {
if ($msg != "") {
printf("<b>%s</b>\n", $msg);
}
show_form_header("usergroups.php", "addgroup", "form");
show_table_header($lang['nav_usergroups'], 2);
$sql = "SELECT group_id, group_name\n FROM " . GROUPS_TABLE . "\n WHERE group_type = " . GROUPTYPE_GROUP . "\n ORDER BY group_name ASC";
$result = $site_db->query($sql);
$found = 0;
while ($row = $site_db->fetch_array($result)) {
echo "<tr class=\"" . get_row_bg() . "\"><td><p><b>" . $row['group_name'] . "</b></p></td><td><p>";
show_text_link($lang['edit'], "usergroups.php?action=editgroup&group_id=" . $row['group_id']);
show_text_link($lang['delete'], "usergroups.php?action=removegroup&group_id=" . $row['group_id']);
show_text_link("<b>" . $lang['permissions'] . "</b>", "usergroups.php?action=editpermissions&group_id=" . $row['group_id']);
echo "</p></td></tr>";
$found = 1;
}
if (!$found) {
echo "<tr class=\"" . get_row_bg() . "\">\n<td colspan=\"2\">" . $lang['no_search_results'] . "</td></tr>";
}
show_table_separator($lang['add_usergroup'], 2);
show_custom_row("<input type=\"text\" name=\"group_name\" value=\"\" size=\"" . $textinput_size . "\">", "<input type=\"submit\" value=\"" . $lang['add_usergroup'] . "\" class=\"button\">");
show_table_footer();
}
show_admin_footer();
