chamilo / chamilo-lms

                        c_id = ".$courseId;

            $res = Database::query($sql);

            $row = Database::fetch_array($res);

            if ($row['nb'] > 0) {

                $sql = "UPDATE $table

                        SET category_id = $categoryId

                        WHERE

                            question_id = $question_id AND

                            c_id = ".$courseId;

                Database::query($sql);

            } else {

                $sql = "INSERT INTO $table (c_id, question_id, category_id)

                        VALUES (".$courseId.", $question_id, $categoryId)";

                Database::query($sql);

            }

            return true;

        }

        }

        if ($num > 1) { // If there's only one element, no need to sort.

            $order = $lps[$lp_id]['display_order'];

            if ($order > 1) { // If it's the first element, no need to move up.

                $sql = "UPDATE $lp_table SET display_order = $order

                        WHERE c_id = $courseId AND id = ".$lp_order[$order - 1];

                Database::query($sql);

                $sql = "UPDATE $lp_table SET display_order = ".($order - 1)."

                        WHERE c_id = $courseId AND id = ".$lp_id;

                Database::query($sql);

            }

        }

        return true;