2022-02-07

Count #

Items on page: 3

file_hash	item_title	author_id	cart
2022-02-07 #
`d47b4fe6`	I miss banana	Guest	+cart
`e56fab86`	Software Updated to Version c36485d0..	Guest	+cart
`ec9f5f34`	#like	Guest	+cart

#cookie
I miss banana #
I miss banana -- [Cookie]
09/22; Guest; d47b4fe6; like ; +cart

#changelog; #hashtag
Software Updated to Vers #
Software Updated to Version c36485d0.. Installed software version has changed from 3290ba5a.. to c36485d0.. c36485d add placeholder for hike.pl fab7894 pages.pl: improve code smell 8088f48 improve dragging.js 86be324 update todo d37b05e remove GT character from utils.js 8660a85 hide debug message when it is not enabled (dragging.js) 74bfa46 improve debug output for in_array() a721950 when item has no tags, display "none" 8db4ce2 add code for convert (ImageMagick) on/off setting e7fe43d fix indent characters in menu.pl ; add exclusion list to menus depending on turned off features b065634 fix indent characters in menu.pl ; add exclusion list to menus depending on turned off features 137f6d7 improve what is displayed on upload page when upload feature is off 5cdffa4 move javascript in titlebar button template to separate template 48aa80f add Reset button to dialog controls 422e9a9 add header/footer to profile_no template 8349032 add upload_no template 21db77c add default setting for convert acd1f8a add reporting of debug modes to start.sh 4844921 add controls_header default 610ca06 add Profile link to identity dialog template 4197c2b add "arrange" button to controls dialog e454cd8 controls dialog should be at the top by default (add option to have it at the bottom too) ; controls dialog should not require php ; improve code smell in pages.pl a97846d change annoyances dialog to be on operator (admin) layer 5626ce4 fix reference to post page template 956720f add DraggingMakeFit() function in dragging.js 0c8ae76 dragging.js: fix magic number for controls dialog af23685 annoyances dialog: improve clarity 6d998e4 add to todo 367738b add to cheatsheet doc f466f07 add search keyword in item_listing_page.pl f18ca69 update todo c9e55fe add debug output to MergeFiles() in file.pl fa23872 add expire_html_when_indexing setting and skeleton for implementing it 523d1fb IndexTextFile() when token limit is reached stop accepting new tokens, instead of aborting index process e4a5088 improve code smell in index_text_file.pl c62fd8a expire avatar cache when user's admin state is changed feea79f improve code smell in cache.pl 4b94b29 fix support for openpgp feature flag 51e3f11 fix support for openpgp feature flag in profile.js 4ff92e8 update todo 63f00ff fix bug StoreNewComment() when REMOTE_HOST not available (fall back on REMOTE_ADDR) 938c01f fix openpgp feature flag not working in off position 50b4928 post.php & utils.php improve code smell 3530ad0 fix 'when config/setting/admin/js/openpgp is turned off, sign checkboxes should not be there' a39c6b9 fix 'when config/setting/admin/js/openpgp is turned off, profile page still includes keygen checkbox' 1c3b19f update todo #changelog
09/23; e56fab86; like ; +cart

#hashtag; #parent
#like #
>>a15373d8.. #like --
09/22; ec9f5f34; 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) = '2022-02-07'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-02-07'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-02-07'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-02-07'
					)
				);

Cart #

Paste

Clear
Add All

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