Read ; Write ; Upload ; Image(296) ; People(18) ; Threads(40) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum

Count #
Items on page: 5
2025-04-25 #
file_hash item_title author_id cart
1d09d28a [Puzzle Solved] ilyag +cart
6a3c6774 [Public key for ilyag, 132A0FA03BDDFFF3] ilyag +cart
8a226e43 [declined: #admin] ilyag +cart
be3340ac [Public key for ilyag, 46258F03A90D35E9] ilyag +cart
ef32ee49 Software Updated to Version 0d1ad5fe.. Guest +cart
[Puzzle Solved] #
#puzzle



[Puzzle Solved]
no timestamp; ilyag; eabe7f85; like ; +cart
[Public key for ilyag, 1 #
#pubkey

[This item is a public key.]
; ilyag; 6a3c6774; like ; +cart
[declined: #admin] #
#hashtag; #parent

>>[Public key for

#admin #approve
no timestamp; ilyag; 246aa8f0; like ; +cart
[Public key for ilyag, 4 #
#approve; #pubkey

[This item is a public key.]
no timestamp; ilyag; 16b0f95a; like ; +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version 0d1ad5fe..

Installed software version has changed from 51f679cc.. to 0d1ad5fe..

0d1ad5fe Fix cache path inconsistencies in SqliteQueryCachedShell() ; sqlite.pl
2d2ee408 Enhance SqliteVerifyTables() to improve logging and validation of required tables and views. Added debug mode checks for 'table_test_fail' and 'view_test_fail'. Updated return logic to ensure accurate status reporting. ; sqlite.pl
6d1f1ec9 Enhance SqliteMakeTables() by adding functionality to remove SQL comments, including single-line and multi-line comments, for cleaner schema queries.
d9fc473d .../sqlite-new/.../sqlite.pl: Refactor SqliteMakeTables() to use DBI for table existence checks and add SqliteVerifyTables() for schema validation. Enhance query execution with improved error handling and logging. Split schema queries for individual execution and verify table creation success.
7747a236 in sqlite-new/.../sqlite.pl update SqliteQuery() to use DBI instead of sqlite3
c723b87c add searchable comments
a49d5469 add comments in sqlite.pl
d711256b replace GetAvatar() with much simpler version in avatar.pl (move old version to scratch.pl)
49660a26 add new sqlite.pl module, sqlite-new theme, to rewrite a better version of it
079bd0dd improve debug output in sqlite.pl
80ae049a remove unused debug code in utils.pl
34db1a24 improve formatting and comments in utils.pl
01016dd0 improve appearance of write_options and upload dialogs in modern theme
b5e437f7 remove unused debug code in sqlite.pl and sqlite-dbi/.../sqlite.pl
788799a1 add searchable comment to sqlite.pl
af53a73c improve GetItemIndexLog() ; item_page_toolbox.pl
60cacc47 add debug output in IsSaneFilename() ; utils.pl
decb69ac add sanity check/de-taint in GetFileHash() ; utils.pl
7ebe5b79 allow slash character in usernames provided by gpg public key ; gpgpg.pl

#changelog
; ef32ee49; like ; +cart
query.sql #
 


		SELECT
			item_flat.file_path file_path,
			item_flat.item_name item_name,
			item_flat.file_hash file_hash,
			item_flat.author_key author_key,
			item_flat.child_count child_count,
			item_flat.parent_count parent_count,
			item_flat.add_timestamp add_timestamp,
			item_flat.item_title item_title,
			item_flat.item_score item_score,
			item_flat.labels_list labels_list,
			item_flat.item_type item_type,
			item_flat.item_order item_order,
			item_flat.item_sequence item_sequence
		FROM
			item_flat
	 
		WHERE
			file_hash IN (
				SELECT file_hash
				FROM item_flat
				WHERE
					item_score >= 0 AND
					(
						SUBSTR(DATETIME(add_timestamp, 'unixepoch', 'localtime'), 0, 11) = '2025-04-25'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2025-04-25'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2025-04-25'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2025-04-25'
					)
				);
Cart #
Paste
Clear
Add All
^
JavaScript #