chamilo / chamilo-lms

     *

     * @return int is id of test category

     */

    public static function get_category_id_for_title($title, $courseId = 0)

    {

        $out_res = 0;

        if (empty($courseId)) {

            $courseId = api_get_course_int_id();

        }

        $courseId = intval($courseId);

        $tbl_cat = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY);

        $sql = "SELECT id FROM $tbl_cat

                WHERE c_id = $courseId AND title = '".Database::escape_string($title)."'";

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

        if (Database::num_rows($res) > 0) {

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

            $out_res = $data['id'];

        }

        return $out_res;

    }

    /**

     * Add a relation between question and category in table c_quiz_question_rel_category

 * @author Jhon Hinojosa <[email protected]>,

 * @version octubre 2008, dokeos 1.8

 */

function count_number_of_post_in_thread($thread_id)

{

    $table_posts = Database::get_course_table(TABLE_FORUM_POST);

    $course_id = api_get_course_int_id();

    if (empty($course_id)) {

        return 0;

    }

    $sql = "SELECT count(*) count FROM $table_posts

            WHERE 

                c_id = $course_id AND 

                thread_id='".intval($thread_id)."' ";

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

    $count = 0;

    if (Database::num_rows($result) > 0) {

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

        $count = $row['count'];

    }

    return $count;

}

/**

 * This function counts the number of post inside a thread user

 *

 * @return  int the number of post inside a thread user

 */

function count_number_of_post_for_user_thread($thread_id, $user_id)

{

    $table_posts = Database::get_course_table(TABLE_FORUM_POST);

    $course_id = api_get_course_int_id();

    $sql = "SELECT count(iid) as count 

            FROM $table_posts

            WHERE c_id = $course_id AND

                  thread_id=".intval($thread_id)." AND

                  poster_id = ".intval($user_id)." AND visible = 1 ";

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

    $count = 0;

    if (Database::num_rows($result) > 0) {

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

        $count = $count['count'];

    }

    return $count;

}

/**

 * This function counts the number of user register in course