chamilo / chamilo-lms

     * @param int $career_id

     * @return bool

     */

    public function get_status($career_id)

    {

        $TBL_CAREER             = Database::get_main_table(TABLE_CAREER);

        $career_id = intval($career_id);

        $sql 	= "SELECT status FROM $TBL_CAREER WHERE id = '$career_id'";

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

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

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

            return $data['status'];

        } else {

            return false;

        }

    }

    /**

     * @param array $params

/**

 * This function checks wether there are added resources or not

 */

function check_added_resources($type, $id) {

    $course_id = api_get_course_int_id();

    $TABLERESOURCE = Database::get_course_table(TABLE_LINKED_RESOURCES);

    $sql = "SELECT * FROM $TABLERESOURCE

            WHERE c_id = $course_id AND source_type='$type' and source_id='$id'";

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

    $number_added = Database::num_rows($result);

    if ($number_added != 0)

        return true;

    else

        return false;

}

/**

 * this function is to load the resources that were added to a specific item

/**

* this function checks wether there are added resources or not

*/

function check_added_resources($type, $id)

{

	global $_course, $origin;

	$TABLERESOURCE 		= Database::get_course_table(TABLE_LINKED_RESOURCES);

	$sql="SELECT * FROM $TABLERESOURCE WHERE source_type='$type' and source_id='$id'";

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

	$number_added=Database::num_rows($result);

	if ($number_added<>0)

		return true;

	else

		return false;

}

/**

     *

     * @return bool

     */

    public static function userIsAssignedToCategory($userId, $categoryId)

    {

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY_REL_USER);

        $userId = intval($userId);

        $categoryId = intval($categoryId);

        $sql = "SELECT * FROM $table WHERE category_id = $categoryId AND user_id = $userId";

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

        return Database::num_rows($result) > 0;

    }

    /**

     * @param int $categoryId

     * @param string session category ID

     * @return mixed false if the session category does not exist, array if the session category exists

     */

    public static function get_session_category($id)

    {

        $tbl_session_category = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY);

        $id = intval($id);

        $sql = "SELECT id, name, date_start, date_end

                FROM $tbl_session_category

                WHERE id= $id";

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

        $num = Database::num_rows($result);

        if ($num > 0) {

            return Database::fetch_array($result);

        } else {

            return false;

        }

    }

    /**

     * Get all session categories (filter by access_url_id)

     * @param array $list

     * @return array

     */

    public static function getCourseCategoryNotInList($list)

    {

        $table = Database::get_main_table(TABLE_MAIN_CATEGORY);

        if (empty($list)) {

            return array();

        }

        $list = array_map('intval', $list);

        $listToString = implode("','", $list);

        $sql = "SELECT * FROM $table

            WHERE id NOT IN ('$listToString') AND (parent_id IS NULL) ";

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

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * @param string $keyword