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

Count #
Items on page: 2
2025-03-21 #
file_hash item_title author_id cart
2397cb79 Software Updated to Version 51f679cc.. Guest +cart
dd3717f5 #BananaDelivery #BananaDe applied to 8 items Guest +cart
Software Updated to Vers #
#changelog; #hashtag; #https

Software Updated to Version 51f679cc..

Installed software version has changed from 762699e8.. to 51f679cc..

51f679cc fix indentation and extra empty lines in get_read_page.pl
7ab876eb improve debug output in utils.pl
b3c8cf0a improve debug output and sanity checks in get_read_page.pl
6a904da0 improve debug output in sqlite.pl and mysql.pl
8cb808bc fix indentation in page_map.pl
1dd9cd48 make GetPageMapDialog() function without requiring js ; page_map.pl
1e62b1d6 when Arrange or Cascade is clicked, make settings changes be visible immediately if settings dialog is open ; dialog_controls.template
b4fd400e add searchable comment in settings.js
f877a9bf add to todo.txt
0f99b4aa Merge remote-tracking branch 'origin/master'
bfb207f5 fix utf-8 decoding/encoding bug in theme/cache-sqlite/template/perl/cache.pl
2d71af5d add debug output in utils.pl
582be232 improve indentation in sqlite.pl
bf49d392 Merge branch 'master' of [https]
902cdfa9 Merge branch 'master' of [https]
0c5ba388 Merge resolved: Fix conflict in utils.pl regarding SHA1 sum command configuration
2366b58d improve debug output in RenameFile() ; utils.pl
71fbe820 fix broken sanity check in GetFileHash() ; utils.pl

#changelog
; 2397cb79; like ; +cart
#BananaDelivery #BananaD #
#hashtag; #parent

>>8ae9a895..
>>1096210d..
>>740980f0..
>>92796dc7..
>>ae1e51a5..
>>2db9bfb8..
>>9e6afa5f..
>>5bd2b222..

#BananaDelivery
no timestamp; Guest; 7c194483; 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-03-21'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2025-03-21'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2025-03-21'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2025-03-21'
					)
				);
Cart #
Paste
Clear
Add All
^
JavaScript #