seblucas / cops

        return parent::getCountGeneric ("authors", self::ALL_AUTHORS_ID, parent::PAGE_ALL_AUTHORS);

    }

    public static function getAllAuthorsByFirstLetter() {

        list (, $result) = parent::executeQuery ("select {0}

from authors

group by substr (upper (sort), 1, 1)

order by substr (upper (sort), 1, 1)", "substr (upper (sort), 1, 1) as title, count(*) as count", "", array (), -1);

        $entryArray = array();

        while ($post = $result->fetchObject ())

        {

            array_push ($entryArray, new Entry ($post->title, Author::getEntryIdByLetter ($post->title),

                str_format (localize("authorword", $post->count), $post->count), "text",

                array ( new LinkNavigation ("?page=".parent::PAGE_AUTHORS_FIRST_LETTER."&id=". rawurlencode ($post->title))), "", $post->count));

        }

        return $entryArray;

    }

    public static function getAuthorsByStartingLetter($letter) {

        return self::getEntryArray (self::SQL_AUTHORS_BY_FIRST_LETTER, array ($letter . "%"));

        return array($entryArray, $totalNumber);

    }

    public static function getAllBooks() {

        /* @var $result PDOStatement */

        list (, $result) = parent::executeQuery('select {0}

from books

group by substr (upper (sort), 1, 1)

order by substr (upper (sort), 1, 1)', 'substr (upper (sort), 1, 1) as title, count(*) as count', self::getFilterString(), array(), -1);

        $entryArray = array();

        while ($post = $result->fetchObject())

        {

            array_push($entryArray, new Entry($post->title, Book::getEntryIdByLetter($post->title),

                str_format(localize('bookword', $post->count), $post->count), 'text',

                array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS_LETTER.'&id='. rawurlencode($post->title))), '', $post->count));

        }

        return $entryArray;

    }

    public static function getBooksByStartingLetter($letter, $n, $database = NULL, $numberPerPage = NULL) {

        return self::getEntryArray(self::SQL_BOOKS_BY_FIRST_LETTER, array($letter . '%'), $n, $database, $numberPerPage);