chamilo / chamilo-lms

     * @param array $courseInfo

     * @return array with the post info

     */

    public function getAttachment($eventId, $courseInfo)

    {

        $tableAttachment = Database::get_course_table(TABLE_AGENDA_ATTACHMENT);

        $courseId = intval($courseInfo['real_id']);

        $eventId = intval($eventId);

        $row = array();

        $sql = "SELECT id, path, filename, comment

                FROM $tableAttachment

                WHERE

                    c_id = $courseId AND

                    agenda_id = $eventId";

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

        if (Database::num_rows($result) != 0) {

            $row = Database::fetch_array($result, 'ASSOC');

        }

        return $row;

    }

    /**

     * Add an attachment file into agenda

     * @param int field_id

     * @return int 0 if fails otherwise the tag id

     */

    public static function get_tag_id_from_id($tag_id, $field_id)

    {

        $table_user_tag = Database::get_main_table(TABLE_MAIN_TAG);

        $tag_id = intval($tag_id);

        $field_id = intval($field_id);

        $sql = "SELECT id FROM $table_user_tag

                WHERE id = '$tag_id' AND field_id = $field_id";

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

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

            $row = Database::fetch_array($result, 'ASSOC');

            return $row['id'];

        } else {

            return false;

        }

    }

    /**

     * Adds a user-tag value

 * @param array $courseInfo

 * @return int

 */

function getWorkCommentCount($id, $courseInfo = array())

{

    if (empty($courseInfo)) {

        $courseInfo = api_get_course_info();

    }

    $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT);

    $id = intval($id);

    $sql = "SELECT count(*) as count

            FROM $commentTable

            WHERE work_id = $id AND c_id = ".$courseInfo['real_id'];

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

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

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

        return $comment['count'];

    }

    return 0;

}

/**

 * Get comment count for a specific parent