Пример #1
0
function lxEditCategory()
{
    global $DB, $C;
    VerifyPrivileges(P_CATEGORY_MODIFY);
    // Count number of subcategories and links in this category
    $subcategories = $DB->Count('SELECT COUNT(*) FROM lx_categories WHERE parent_id=?', array($_REQUEST['category_id']));
    $links = $DB->Count('SELECT COUNT(*) FROM lx_link_cats WHERE category_id=?', array($_REQUEST['category_id']));
    $validator = new Validator();
    $validator->Register($_REQUEST['name'], V_EMPTY, 'The category name must be filled in');
    $validator->Register($_REQUEST['name'], V_REGEX, 'The category name cannot contain a / or _ character', '/^[^\\/_]*$/');
    $validator->Register($_REQUEST['name'], V_NOT_REGEX, 'The category name cannot contain a :: character sequence', '/::/');
    $validator->Register($_REQUEST['parent_id'], V_EMPTY, 'You must select a parent category');
    $validator->Register(is_numeric($_REQUEST['name']), V_FALSE, 'The category name cannot be all numeric');
    if ($_REQUEST['template']) {
        $validator->Register($_REQUEST['template'], V_REGEX, 'The template name can only contain letters, numbers, periods and underscores', '/^[a-z0-9\\.\\-_]+$/');
        $validator->Register($_REQUEST['template'], V_REGEX, 'The template must have a .tpl file extension', '/\\.tpl$/');
    }
    if ($_REQUEST['parent_id'] == $_REQUEST['category_id']) {
        $validator->SetError('A category cannot be it\'s own parent');
    }
    if ($_REQUEST['crosslink_id'] == $_REQUEST['category_id']) {
        $validator->SetError('A crosslink category cannot point to itself');
    }
    if (!empty($_REQUEST['crosslink_id']) && ($subcategories > 0 || $links > 0)) {
        $validator->SetError('This category cannot be set to be a crosslink category because it contains sub-categories and/or links');
    }
    if (!$validator->Validate()) {
        $GLOBALS['errstr'] = join('<br />', $validator->GetErrors());
        lxShEditCategory();
        return;
    }
    $parent = $_REQUEST['parent_id'] == 0 ? $GLOBALS['ROOT_CATEGORY'] : $DB->Row('SELECT * FROM lx_categories WHERE category_id=?', array($_REQUEST['parent_id']));
    $_REQUEST['name'] = trim($_REQUEST['name']);
    $_REQUEST['url_name'] = trim($_REQUEST['url_name']);
    if (empty($_REQUEST['crosslink_id'])) {
        $_REQUEST['crosslink_id'] = null;
    }
    $old_category = $DB->Row('SELECT * FROM lx_categories WHERE category_id=?', array($_REQUEST['category_id']));
    $DB->Update('UPDATE lx_categories SET ' . 'name=?, ' . 'url_name=?, ' . 'description=?, ' . 'meta_description=?, ' . 'meta_keywords=?, ' . 'parent_id=?, ' . 'path=?, ' . 'path_parts=?, ' . 'path_hash=?, ' . 'template=?, ' . 'crosslink_id=?, ' . 'related_ids=?, ' . 'status=?, ' . 'hidden=? ' . 'WHERE category_id=?', array($_REQUEST['name'], $_REQUEST['url_name'], $_REQUEST['description'], $_REQUEST['meta_description'], $_REQUEST['meta_keywords'], $_REQUEST['parent_id'], '', '', '', $_REQUEST['template'], $_REQUEST['crosslink_id'], $_REQUEST['related_ids'], $_REQUEST['status'], intval($_REQUEST['hidden']), $_REQUEST['category_id']));
    $category = $DB->Row('SELECT * FROM lx_categories WHERE category_id=?', array($_REQUEST['category_id']));
    $path = GeneratePathData($category, $parent);
    $DB->Update('UPDATE lx_categories SET ' . 'path=?, ' . 'path_parts=?, ' . 'path_hash=? ' . 'WHERE category_id=?', array($path['path'], $path['serialized'], $path['hash'], $_REQUEST['category_id']));
    UpdateSubcategoryCount($parent['category_id']);
    // Update path data for child categories if necessary
    if ($old_category['parent_id'] != $category['parent_id'] || $old_category['name'] != $category['name'] || $old_category['url_name'] != $category['url_name']) {
        $category['path'] = $path['path'];
        $category['path_parts'] = $path['serialized'];
        $category['hash'] = $path['hash'];
        UpdateChildPaths($category);
    }
    $GLOBALS['message'] = 'Category successfully updated';
    $GLOBALS['added'] = true;
    // Ask user to create custom template file if it does not exist
    if ($_REQUEST['template'] && !file_exists("{$GLOBALS['BASE_DIR']}/templates/{$_REQUEST['template']}")) {
        $GLOBALS['message'] .= "<br />Please create the template file {$_REQUEST['template']} in the templates directory and set it's permissions to 666";
    }
    // Clear cache for this category and it's parent
    ClearCategoryCache($category['category_id'], $path['path']);
    ClearCategoryCache($category['parent_id']);
    lxShEditCategory();
}
Пример #2
0
function DeleteCategory($category_id, $category = null)
{
    global $DB, $ROOT_CATEGORY;
    if ($category == null) {
        $category = $DB->Row('SELECT * FROM lx_categories WHERE category_id=?', array($category_id));
    }
    // Remove cache files
    ClearCategoryCache($category['category_id'], $category['path']);
    ClearCategoryCache($category['parent_id']);
    // Delete all sub-categories
    $result = $DB->Query('SELECT * FROM lx_categories WHERE parent_id=?', array($category_id));
    while ($subcategory = $DB->NextRow($result)) {
        DeleteCategory($subcategory['category_id'], $subcategory);
    }
    $DB->Free($result);
    // Delete all links in this category
    $result = $DB->Query('SELECT * FROM lx_links JOIN lx_link_cats USING (link_id) WHERE category_id=?', array($category_id));
    while ($link = $DB->NextRow($result)) {
        DeleteLink($link['link_id'], FALSE, $link);
    }
    $DB->Free($result);
    // Delete this category
    $DB->Update('DELETE FROM lx_categories WHERE category_id=?', array($category_id));
    // Update subcategory count for parent category
    if ($category['parent_id'] != $ROOT_CATEGORY['parent_id']) {
        UpdateSubcategoryCount($category['parent_id']);
    }
}
Пример #3
0
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
define('LINKX', TRUE);
require_once '../includes/common.php';
require_once "{$GLOBALS['BASE_DIR']}/includes/mysql.class.php";
require_once "{$GLOBALS['BASE_DIR']}/admin/includes/functions.php";
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
$DB->Connect();
echo "Re-counting sub-categories and links per category...";
flush();
$result = $DB->Query('SELECT * FROM lx_categories');
while ($category = $DB->NextRow($result)) {
    UpdateSubcategoryCount($category['category_id']);
    UpdateLinkCount($category['category_id']);
}
$DB->Free($result);
echo "done<br />";
flush();
echo "Re-counting comments...";
flush();
$result = $DB->Query('SELECT * FROM lx_links');
while ($link = $DB->NextRow($result)) {
    $comments = $DB->Count('SELECT COUNT(*) FROM lx_link_comments WHERE link_id=?', array($link['link_id']));
    $DB->Update('UPDATE lx_links SET comments=? WHERE link_id=?', array($comments, $link['link_id']));
}
$DB->Free($result);
echo "done<br />";
flush();