chamilo / chamilo-lms

 * @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

     * @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