function Cat_Safe_Names() { // this was moved out of dbtree.php because it's only needed when changing // category information global $db; $cats = $db->get_col("Select category_name from " . table_categories . ";"); if ($cats) { foreach ($cats as $catname) { $db->query("UPDATE `" . table_categories . '` SET `category_name` = "' . safeAddSlashes($catname) . '"' . ", `category_safe_name` = '" . makeCategoryFriendly($catname) . "' WHERE `category_name` =" . '"' . safeAddSlashes($catname) . '";'); } } $cats = $db->get_col("Select category__auto_id from " . table_categories . ";"); if ($cats) { foreach ($cats as $catid) { $db->query("UPDATE `" . table_categories . "` SET `category_id` = " . $catid . " WHERE `category__auto_id` ='" . $catid . "';"); } } }
function Cat_Safe_Names() { global $db; $cats = $db->get_col("Select category_name from " . table_categories . ";"); if ($cats) { foreach ($cats as $catname) { $db->query("UPDATE `" . table_categories . '` SET `category_name` = "' . safeAddSlashes($catname) . '"' . ", `category_safe_name` = '" . makeCategoryFriendly($catname) . "' WHERE `category_name` =" . '"' . safeAddSlashes($catname) . '";'); } } $cats = $db->get_col("Select category__auto_id from " . table_categories . ";"); if ($cats) { foreach ($cats as $catid) { $db->query("UPDATE `" . table_categories . "` SET `category_id` = " . $catid . " WHERE `category__auto_id` ='" . $catid . "';"); } } }
// put the category tree into an array for use in the qeip dropdown $action = isset($_REQUEST['action']) && sanitize($_REQUEST['action'], 3) != '' ? sanitize($_REQUEST['action'], 3) : "view"; if ($action == "htaccess") { $htaccess = '../.htaccess'; if (file_exists($htaccess)) { echo "The file {$htaccess} already exists. To protect you from accidentally removing it, you must manually remove it from your server before moving on."; } else { rename("../htaccess.default", "../.htaccess"); echo "We have renamed htaccess.default to .htaccess for you. You still need to manually add the special category structure for it to fully work."; } } if ($action == "save") { $CSRF->check_expired('category_manager'); if ($CSRF->check_valid(sanitize($_POST['token'], 3), 'category_manager')) { if (!$_POST['safename']) { $_POST['safename'] = makeCategoryFriendly($_POST['name']); $row = $db->get_row("SELECT * FROM " . table_categories . " WHERE category_safe_name='" . mysql_real_escape_string(sanitize($_POST['safename'], 4)) . "' AND category__auto_id!='{$_POST['auto_id']}'"); $i = ''; while ($row->category_id > 0) { $i++; $row = $db->get_row("SELECT * FROM " . table_categories . " WHERE category_safe_name='" . mysql_real_escape_string(sanitize($_POST['safename'] . $i, 4)) . "' AND category__auto_id!='{$_POST['auto_id']}'"); } $_POST['safename'] .= $i; } if ($_POST['auto_id'] && is_numeric($_POST['auto_id'])) { $id = sanitize($_POST['auto_id'], 3); $parent = sanitize($_POST['parent'], 3); if (!is_numeric($id)) { die; } if (!is_numeric($parent)) {
$last_visit = txt_time_diff($pageview->last_visit(), $time); } $main_smarty->assign('last_visit', $last_visit); $pageview->insert(); // Set globals $globals['link_id'] = $link->id; $globals['category_id'] = $link->category; $globals['category_name'] = $link->category_name(); check_actions('story_top'); $main_smarty->assign('link_submitter', $link->username()); // setup breadcrumbs and title $main_smarty->assign('posttitle', " - " . $link->title); $navwhere['text1'] = $globals['category_name']; $navwhere['link1'] = getmyurl('maincategory', makeCategoryFriendly($globals['category_name'])); $navwhere['text2'] = $link->title; $navwhere['link2'] = getmyurl('storycattitle', makeCategoryFriendly($globals['category_name']), urlencode($link->title_url)); $main_smarty->assign('navbar_where', $navwhere); // for the comment form $randkey = rand(1000000, 100000000); $main_smarty->assign('randkey', $randkey); $main_smarty->assign('link_id', $link->id); $main_smarty->assign('user_id', $current_user->user_id); $main_smarty->assign('randmd5', md5($current_user->user_id . $randkey)); // for login to comment $main_smarty->assign('register_url', getmyurl("register", '')); $main_smarty->assign('login_url', getmyurl("login", $_SERVER['REQUEST_URI'])); // for show who voted $main_smarty->assign('user_url', getmyurl('userblank', "")); $main_smarty->assign('voter', who_voted($id, 'small')); // misc smarty $main_smarty->assign('Enable_Comment_Voting', Enable_Comment_Voting);
//---- Your database password. include_once '../libs/backup/mysql_backup/mysql_backup.class.php'; $output = "upgrade_config_table.sql"; // The data for the config table. $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only); $backup->restore(";"); } //--------------------------------------------------------- $fieldexists = checkforfield('category_safe_name', table_categories); if (!$fieldexists) { $sql = 'ALTER TABLE `' . table_categories . '` ADD `category_safe_name` varchar(64) default NULL ;'; $db->query($sql); $cats = $db->get_col("Select category_name from " . table_categories . ";"); if ($cats) { foreach ($cats as $catname) { $db->query("UPDATE `" . table_categories . "` SET `category_name` = '" . $catname . "', `category_safe_name` = '" . makeCategoryFriendly($catname) . "' WHERE `category_name` ='" . $catname . "';"); } } } // Added SpellChecker #2 $sql = "UPDATE `" . table_config . "` SET `var_defaultvalue` = '2', `var_optiontext` = '1 or 2 = on / 0 = off', `var_desc` = '1 = http://spellerpages.sourceforge.net/<br />2 = http://www.phpclasses.org/browse/package/2398.html (spell checker for people without aspell enabled in php.' WHERE `var_id` =57 LIMIT 1 ;"; $db->query($sql); $result = mysql_query("select * from `" . table_config . "` where `var_name` = 'StorySummary_ContentTruncate';"); if (mysql_num_rows($result) == 0) { $db->query("INSERT INTO `" . table_config . "` VALUES (58, 'Summary', 'StorySummary_ContentTruncate', '150', '150', 'number', 'Content Truncate', 'When showing the story in summary mode (like on the main page), truncate the content to this many characters', 'define', NULL);"); } $result = mysql_query("select * from `" . table_config . "` where `var_name` = 'SubmitSummary_Allow_Edit';"); if (mysql_num_rows($result) == 0) { $db->query("INSERT INTO `" . table_config . "` VALUES (59, 'Summary', 'SubmitSummary_Allow_Edit', '1', '1', 'number', 'Allow edit of Summary', 'Allow edit of Summary', 'define', NULL);"); } $result = mysql_query("select * from `" . table_config . "` where `var_name` = 'Enable_User_Upload_Avatar';");