chamilo / chamilo-lms

 * @param string $tool_id tool id, from main.api.lib

 * @param int $ref_id intern id inside specific tool table

 */

function delete_all_specific_field_value($course_id, $id_specific_field, $tool_id, $ref_id) {

    $table_sf_values = Database::get_main_table(TABLE_MAIN_SPECIFIC_FIELD_VALUES);

    $sql = 'DELETE FROM %s WHERE course_code = \'%s\' AND tool_id = \'%s\' AND ref_id = %s AND field_id = %s';

    $sql = sprintf($sql, $table_sf_values, $course_id, $tool_id, $ref_id, $id_specific_field);

    Database::query($sql);

}

/**

 * Delete all values from a specific item (course_id, tool_id and ref_id).

 * @param   string  Tool ID

 * @param   int     Internal ID used in specific tool table

 */

function delete_all_values_for_item($course_id, $tool_id, $ref_id) {

  $table_sf_values = Database::get_main_table(TABLE_MAIN_SPECIFIC_FIELD_VALUES);

  $sql = 'DELETE FROM %s WHERE course_code = \'%s\' AND tool_id = \'%s\' AND ref_id = %s';

  $sql = sprintf($sql, $table_sf_values, $course_id, $tool_id, $ref_id);

  Database::query($sql);

}

/**

 * Generates a code (one-letter string) for a given field name

     * @param int $blog_id The internal ID of the blog

     * @return string Blog Title

     */

    public static function getBlogTitle($blog_id)

    {

        $course_id = api_get_course_int_id();

        if (is_numeric($blog_id)) {

            $tbl_blogs = Database::get_course_table(TABLE_BLOGS);

            $sql = "SELECT blog_name

                    FROM $tbl_blogs

                    WHERE c_id = $course_id AND blog_id = ".intval($blog_id);

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

            $blog = Database::fetch_array($result);

            return stripslashes($blog['blog_name']);

        }

    }

    /**

     * Get the description of a blog

     * @param int $id

     * @return array|mixed

     */

    public static function getCategory($id)

    {

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY);

        $id = intval($id);

        $sql = "SELECT id, name, description, total_tickets

                FROM $table WHERE id = $id";

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

        $category = Database::fetch_array($result);

        return $category;

    }

    /**

     * @return int

     * @param int $ticketId

     * @param int $userId

     */

    public static function send_alert($ticketId, $userId)

    {

        $table_support_tickets = Database::get_main_table(TABLE_TICKET_TICKET);

        $now = api_get_utc_datetime();

        $ticketId = intval($ticketId);

        $userId = intval($userId);

        $sql = "UPDATE $table_support_tickets SET

                  priority_id = '".self::PRIORITY_HIGH."',

                  sys_lastedit_user_id ='$userId',

                  sys_lastedit_datetime ='$now'

                WHERE id = '$ticketId'";

        Database::query($sql);

    }

    /**

     * @param int $ticketId

        return $html;

    }

    public function delete_topic($group_id, $topic_id)

    {

        $table_message = Database::get_main_table(TABLE_MESSAGE);

        $topic_id = intval($topic_id);

        $group_id = intval($group_id);

        $sql = "UPDATE $table_message SET

                msg_status = 3

                WHERE

                    group_id = $group_id AND

                    (id = '$topic_id' OR parent_id = $topic_id)

                ";

        Database::query($sql);

    }

    /**

     * @param string $user_id