main/forum/forumfunction.inc.php ➔ move_up_down()

Complexity

Conditions	14
Paths	163

Size

Total Lines	89
Code Lines	61

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function move_up_down($content, $direction, $id)
{
    $table_categories = Database:: get_course_table(TABLE_FORUM_CATEGORY);
    $table_forums = Database:: get_course_table(TABLE_FORUM);
    $table_item_property = Database:: get_course_table(TABLE_ITEM_PROPERTY);
    $course_id = api_get_course_int_id();
    $id = intval($id);

    // Determine which field holds the sort order.
    if ($content == 'forumcategory') {
        $table = $table_categories;
        $sort_column = 'cat_order';
        $id_column = 'cat_id';
        $sort_column = 'cat_order';
    } elseif ($content == 'forum') {
        $table = $table_forums;
        $sort_column = 'forum_order';
        $id_column = 'forum_id';
        $sort_column = 'forum_order';
        // We also need the forum_category of this forum.
        $sql = "SELECT forum_category FROM $table_forums
                WHERE c_id = $course_id AND forum_id = " . intval($id);
        $result = Database::query($sql);
        $row = Database::fetch_array($result);
        $forum_category = $row['forum_category'];
    } else {
        return get_lang('Error');
    }

    // Determine the need for sorting ascending or descending order.
    if ($direction == 'down') {
        $sort_direction = 'ASC';
    } elseif ($direction == 'up') {
        $sort_direction = 'DESC';
    } else {
        return get_lang('Error');
    }

    // The SQL statement
    if ($content == 'forumcategory') {
        $sql = "SELECT *
                FROM $table_categories forum_categories, $table_item_property item_properties
                WHERE
                    forum_categories.c_id = $course_id AND
                    item_properties.c_id = $course_id AND
                    forum_categories.cat_id=item_properties.ref AND
                    item_properties.tool='" . TOOL_FORUM_CATEGORY . "'
                ORDER BY forum_categories.cat_order $sort_direction";
    }
    if ($content == 'forum') {
        $sql = "SELECT *
            FROM $table
            WHERE
                c_id = $course_id AND
                forum_category='" . Database::escape_string($forum_category) . "'
            ORDER BY forum_order $sort_direction";
    }
    // Finding the items that need to be switched.
    $result = Database::query($sql);
    $found = false;
    while ($row = Database::fetch_array($result)) {
        //echo $row[$id_column].'-';
        if ($found) {
            $next_id = $row[$id_column];
            $next_sort = $row[$sort_column];
            $found = false;
        }
        if ($id == $row[$id_column]) {
            $this_id = $id;
            $this_sort = $row[$sort_column];
            $found = true;
        }
    }

    // Committing the switch.
    // We do an extra check if we do not have illegal values. If your remove this if statment you will
    // be able to mess with the sorting by refreshing the page over and over again.
    if ($this_sort != '' && $next_sort != '' && $next_id != '' && $this_id != '') {
        $sql = "UPDATE $table SET $sort_column='" . Database::escape_string($this_sort) . "'
                WHERE c_id = $course_id AND $id_column='" . Database::escape_string($next_id) . "'";
        Database::query($sql);

        $sql = "UPDATE $table SET $sort_column='" . Database::escape_string($next_sort) . "'
                WHERE c_id = $course_id AND $id_column='" . Database::escape_string($this_id) . "'";
        Database::query($sql);
    }

    return get_lang(ucfirst($content) . 'Moved');
}