1
Discussion & Troubleshooting / editing {categories} in categories template
« on: March 05, 2013, 06:51:00 PM »
I need a short url, How can i change the urls of sub categories in URL.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
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'].") ";
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'].") (Hit: ".$cats['cat_hits'].") ";
if ($action == "") {
$action = "modifyusers";
}
function delete_users($user_ids, $delcomments = 1, $delimages = 1) {
global $site_db, $lang, $user_table_fields;
if (empty($user_ids)) {
echo $lang['no_search_results'];
return false;
}
$error_log = array();
echo "<br />";
$sql = "SELECT ".get_user_table_field("", "user_id").get_user_table_field(", ", "user_name")."
FROM ".USERS_TABLE."
WHERE ".get_user_table_field("", "user_id")." IN ($user_ids)";
$user_result = $site_db->query($sql);
$image_ids_sql = "";
while ($user_row = $site_db->fetch_array($user_result)) {
$user_id = $user_row[$user_table_fields['user_id']];
$user_name = $user_row[$user_table_fields['user_name']];
$sql = "DELETE FROM ".GROUP_MATCH_TABLE."
WHERE user_id = $user_id";
$site_db->query($sql);
$sql = "SELECT group_id
FROM ".GROUPS_TABLE."
WHERE group_name = '".addslashes($user_name)."' AND group_type = ".GROUPTYPE_SINGLE;
if ($groups_row = $site_db->query_firstrow($sql)) {
$sql = "DELETE FROM ".GROUPS_TABLE."
WHERE group_id = ".$groups_row['group_id']." AND group_type = ".GROUPTYPE_SINGLE;
$site_db->query($sql);
$sql = "DELETE FROM ".GROUP_ACCESS_TABLE."
WHERE group_id = ".$groups_row['group_id'];
$site_db->query($sql);
}
$sql = "DELETE FROM ".LIGHTBOXES_TABLE."
WHERE user_id = $user_id";
$site_db->query($sql);
if (!defined("USER_INTEGRATION") || (defined("USER_INTEGRATION") && USER_INTEGRATION == "NONE")) {
$sql = "DELETE FROM ".USERS_TABLE."
WHERE ".get_user_table_field("", "user_id")." = $user_id";
if ($site_db->query($sql)) {
echo "<b>".$lang['user_delete_success']."</b> ".format_text($user_name, 2)." (ID: $user_id)<br />\n";
}
else {
$error_log[] = "<b>".$lang['user_delete_error']."</b> ".format_text($user_name, 2)." (ID: $user_id)<br />\n";
}
}
else {
echo "<b>".$lang['user_integration_delete_msg']."</b> ".format_text($user_name, 2)." (ID: $user_id)<br />\n";
}