summaryrefslogtreecommitdiffstatshomepage
path: root/src/SemanticScuttle/Service/Bookmark.php
Commit message (Collapse)AuthorAgeFilesLines
* Throw an error when changes can't be committed to the ↵sqlite-fixesGravatar Tom Willemse2024-06-111-2/+14
| | | | | | | | database I was testing and another process had the database open, so it couldn't commit changes. This wasn't apparent from the UI because it would just silently assume a commit went fine.
* Throw an error if a bookmark can't be committed to the ↵Gravatar Tom Willemse2024-06-111-1/+9
| | | | database
* Fix using SQLite as a database engineGravatar Tom Willemse2024-06-101-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - The ‘sqlite_*’ functions don't exist anymore in PHP 8. They have been replaced with several ‘SQLite3*’ classes. - There are some differences between MySQL and SQLite queries that showed up while doing this work. These differences have been pushed into a QueryBuilder class so that the other database engines don't have to be modified. This is done in an ad-hoc basis for now, just to get things working. - SQLite doesn't support the ‘!’ negation operator used as ‘!ISNULL(...)’, instead I use ‘IIF(...)’. - SQLite doesn't support a ‘LEFT(...)’ function, instead I use ‘SUBSTRING(..., 0, ...)’. - The SQLite3 module doesn't provide a connection identifier, instead you use an object that represents the connection. - SQLite doesn't support the ‘ALL’ keyword (or at least doesn't support it in the same way MySQL does). Instead of ‘<> ALL <subquery>’ I use ‘NOT IN <subquery>’. - The ‘SQLite3*’ classes don't provide any way to determine how many rows have been returned without iterating through all of them, so any place that tries to figure out the rows beforehand just doesn't anymore. - All the database engine classes require a ‘QueryBuilder’ instance. The sqlite one uses a specialized one. I can't test most of these database engines, so I'm focusing on SQLite and MySQL/MariaDB for now.
* Fix issue with urls ending in ‘/’ getting normalized ↵Gravatar Tom Willemse2024-02-291-1/+1
| | | | | | | wrong Normalizing them this way ruins the url by cutting off a character too many and making the url invalid.
* Fix issue about ‘bVotes’ and ‘bVoting’ not ↵fix-for-php-8Gravatar Tom Willemse2024-02-291-1/+3
| | | | having default values
* PHP 7.3 compat, bug fixesGravatar querwurzelt2019-01-211-3/+3
|
* add option to get last modified date instead of creation ↵Gravatar David Glenck2014-03-261-0/+7
| | | | date
* remove php4-style object reference passingGravatar Christian Weiske2013-03-171-3/+3
|
* Reverted changes of date() to gdate(), added tests to ↵Gravatar Mark Pemberton2011-06-041-1/+1
| | | | confirm existence of private RSS feed, and finalized changes to the user session usage with rss.php
* Altered tests to be more timezone friendlyGravatar Mark Pemberton2011-05-211-1/+1
|
* revert getBookmarks() back to originalGravatar Mark Pemberton2011-05-191-31/+19
|
* Updated PrivateKey to include Tag searchesGravatar Mark Pemberton2011-05-171-13/+24
|
* Updated 'Generate New Key' button to use ajax if ↵Gravatar Mark Pemberton2011-05-161-5/+6
| | | | javascript enabled.
* Fixed sql commands where resources were not freedGravatar Mark Pemberton2011-05-141-0/+1
|
* new privatekey2 branch with privatekey changesGravatar Mark Pemberton2011-05-131-1/+1
|
* do not add bookmarks with an invalid URLGravatar Christian Weiske2011-05-031-1/+9
|
* Implement request #3054906: Show user's full name ↵Gravatar Christian Weiske2011-03-151-1/+2
| | | | instead of nickname
* rename $range to $status as it is used in all other ↵Gravatar Christian Weiske2011-02-091-8/+8
| | | | methods; add privacy to the parameter description so we find it again next time
* rewrite api/posts/delete to be more secure and add unit ↵Gravatar cweiske2010-09-281-6/+12
| | | | | | tests for it git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@769 b3834d28-1941-0410-a4f8-b48e95affb8f
* Fix CS, fix docblocksGravatar cweiske2010-09-231-30/+81
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@748 b3834d28-1941-0410-a4f8-b48e95affb8f
* Move user IP resolution into own class methodGravatar cweiske2010-09-231-18/+3
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@747 b3834d28-1941-0410-a4f8-b48e95affb8f
* Fix bug #3073215: Updating bookmark time does not workGravatar cweiske2010-09-231-1/+1
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@745 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix bad bug that was introduced due to performance ↵Gravatar cweiske2010-03-181-1/+1
| | | | | | optimizations git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@693 b3834d28-1941-0410-a4f8-b48e95affb8f
* unify hashing code in a separate methodGravatar cweiske2010-03-181-24/+41
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@692 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix bug #2953732 and make corresponding test work.Gravatar cweiske2010-03-171-1/+2
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@688 b3834d28-1941-0410-a4f8-b48e95affb8f
* re-fix isAdmin() sql optimizationGravatar cweiske2010-02-201-1/+1
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@682 b3834d28-1941-0410-a4f8-b48e95affb8f
* add SemanticScuttle_Service_Bookmark::bookmarksExist() ↵Gravatar cweiske2010-02-201-1/+55
| | | | | | method to check for existance of multiple bookmarks at once for future sql optimization git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@680 b3834d28-1941-0410-a4f8-b48e95affb8f
* reformat queryGravatar cweiske2010-02-201-1/+3
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@679 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix tests after last commitGravatar cweiske2010-02-201-1/+4
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@678 b3834d28-1941-0410-a4f8-b48e95affb8f
* save another queryGravatar cweiske2010-02-201-2/+2
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@677 b3834d28-1941-0410-a4f8-b48e95affb8f
* sql optimization: fetch all tags at onceGravatar cweiske2010-02-201-4/+11
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@668 b3834d28-1941-0410-a4f8-b48e95affb8f
* make countOthers() accept an array of addressesGravatar cweiske2010-02-201-13/+44
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@659 b3834d28-1941-0410-a4f8-b48e95affb8f
* reformat countOthers()Gravatar cweiske2010-02-161-13/+33
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@658 b3834d28-1941-0410-a4f8-b48e95affb8f
* do not return numbers < 0Gravatar cweiske2010-02-161-1/+1
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@653 b3834d28-1941-0410-a4f8-b48e95affb8f
* do not return numbers < 0Gravatar cweiske2010-02-161-2/+3
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@652 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix countBookmarks() for mysqliGravatar cweiske2010-02-071-1/+1
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@640 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix bookmarkExists() for mysqliGravatar cweiske2010-02-071-4/+8
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@639 b3834d28-1941-0410-a4f8-b48e95affb8f
* Part of request #2928950: Add config option to allow ↵Gravatar cweiske2010-01-161-2/+2
| | | | | | sorting by bookmark creation date instead of modification date git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@594 b3834d28-1941-0410-a4f8-b48e95affb8f
* tell people about privacy settings and a TOODGravatar cweiske2010-01-161-0/+4
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@576 b3834d28-1941-0410-a4f8-b48e95affb8f
* add documentation for _getbookmark() and dependent methodsGravatar cweiske2009-11-261-11/+70
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@573 b3834d28-1941-0410-a4f8-b48e95affb8f
* part of request #2830224: prepare API for short url serviceGravatar cweiske2009-11-231-5/+29
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@570 b3834d28-1941-0410-a4f8-b48e95affb8f
* test deleteBookmarksForUserGravatar cweiske2009-11-201-0/+7
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@565 b3834d28-1941-0410-a4f8-b48e95affb8f
* remove superfluous returns after die messagesGravatar cweiske2009-11-201-14/+11
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@562 b3834d28-1941-0410-a4f8-b48e95affb8f
* test bookmarkExists() in all variationsGravatar cweiske2009-11-191-2/+13
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@561 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix notice when passing an invalid array to editAllowed()Gravatar cweiske2009-11-191-2/+5
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@558 b3834d28-1941-0410-a4f8-b48e95affb8f
* hide bookmarks below a configurable thresholdGravatar cweiske2009-11-021-1/+9
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@507 b3834d28-1941-0410-a4f8-b48e95affb8f
* fix unfreed sql resultGravatar cweiske2009-10-311-1/+3
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@486 b3834d28-1941-0410-a4f8-b48e95affb8f
* move user class into own fileGravatar cweiske2009-10-301-15/+27
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@473 b3834d28-1941-0410-a4f8-b48e95affb8f
* unification test was unstable, tooGravatar cweiske2009-10-281-18/+25
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@464 b3834d28-1941-0410-a4f8-b48e95affb8f
* explain deleteAll() in bookmarksGravatar cweiske2009-10-281-1/+7
| | | | git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@458 b3834d28-1941-0410-a4f8-b48e95affb8f
generated by cgit v1.2.3-54-g00ecf (git 2.39.0) at 2024-07-03 07:30:23 +0000