getAllVisibleAuthors query optimization (works faster to get public publications if there are huge amounts of non-public publications; meaning that only public publications are ordered by the sql server instead of all and including non-public publications)
added getVisibleKeywordsForPublication functionality
(using code and logic as found elsewhere in Aigaion)
Bugfix: RIS fields for N2 (note) and AB (abstract) where mixed up
(importing put abstract string in note field and vice versa)
added getVisibleCountForTopic
optimized getForTopic and added getVisibleForTopic
query optimized for huge limit counts (as with paginated pages), e.g limit 10000, 25 actually retrieves 10025 rows, then dumps the first 10000
the logic behind the optimization is to eliminate the amount of data of the rows to be dumped anyways.
trim value before checking if empty string
added function getVisiblePubStructForTopic
TODO: getPubStructForTopic could be optimized the same way; this hasn't been done to preserve upstream compatibility
added getVisiblePublicationCountForTopic, although it doubles the functionality given in libraries/publication_db.php->getVisibleCountForTopic()
sql query optimization for pagination
implemented getVisibleForTopic