2022-11-20

Count #

Items on page: 1

file_hash	item_title	author_id	cart
2022-11-20 #
`2526c764`	Software Updated to Version 42912dbe..	Guest	+cart

#changelog; #hashtag
Software Updated to Vers #
Software Updated to Version 42912dbe.. Installed software version has changed from 2ceae406.. to 42912dbe.. 42912db image page should sort reverse-chronological by default (default/template/query/image) 7efa2e3 add new directories to dirs that should exist: cpp, py, perl d79561c add mime type for perl files to lighttpd config template 781f6c7 add comments index_file.pl b09ff91 make clean.sh delete empty directories in html/ b349ab0 add update command to hike.sh 5b56119 add skeleton for improved version of dialog list 3041eb5 for reindex and flush buttons in admin panel, display a message when user presses button without checking confirmation checkbox route.php 341543a improve date pages to also include self-dated items get_read_page.pl 96b524f improve formatting utils.js 51782b2 add call to UpdateDialogList() when injecting new dialog into page dragging.js 8ef0d07 jstest1: add createTextNode() check to list of tests ; fix indentation in jstest1.template; jstest1.template jstest1.js 44f5fea improve set.pl -- check for matching setting exact match first 15aa995 improve removing extraneous characters when titling an image item IndexImageFile() index.pl 0c2dc26 re-add and improve default titling of images 3ab7da1 add sanity check for missing user input in set.pl bafdfdf fix easter egg fa8a0af add todo route.php 24aa551 add search keywords sqlite.pl 6d9594e improve TrimPath() utils.pl 596b2ef improve messaging when cookie required but not present d3d0782 improve messaging when cookie required but not present 0273f04 fix bug in window activation and improve code clarity dragging.js a01217c for 'new' and 'image' menu items, add item count e223e2c when computing author last seen time, ignore public key items posted by author DBGetAuthorLastSeen() sqlite.pl 1d8d3a0 improve smell in utils.php 1d7a1ff add todo in resultset_as_dialog.pl 01b6c07 improve smell in render_field.pl 20b0ce1 improve/change theme lookup process ... config/setting/theme can now be whitespace-separated instead of just return-separated 75ba88b fix indentation in help.pl 57478d1 fix indentation and fix missing file ending in run_item.pl d010401 clean up index_py_file.pl item_page.pl 9041c17 move RunItem() to run_item.pl ; add provisions for running and indexing perl files ; index.pl index_cpp_file.pl index_file.pl item_page.pl item_template.pl run_item.pl ba12a09 improve comment for DBGetItemAttribute() sqlite.pl 26e20f5 add DBGetItemType() sqlite.pl 86ccb54 add provisions for supporting perl files on the frontend and indexing index_pl_file.pl perl.template 53b1089 add toggle setting for module which runs perl files 78adf46 add PerlForWeb() format_message.pl 50b7a6b when signing out, also delete reply cart btnSignOut_Click() profile.js 39b3c4a improve GetThreadListing() thread_listing.pl e43af57 improve description of changelog tag 6da41ee add tags_list field to new items query 09a16dc add search keyword to in_array() utils.pl 8c30570 show item counts in menu for threads, tags, and authors menu.pl 93e4a71 put item attributes dialog back in the advanced layer item_page.pl f089c6f remove unused code in pages.pl 5149c66 improve debugging assistance in makepage.pl 61b9b7c add search keywords in item_page.pl d9bb847 if python module is off, communicate this on item page for python items; item_page.pl c92debe improve debug output for GetItemPage() item_page.pl #changelog
Thu, 22 Dec 2022; 2526c764; 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-11-20'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-11-20'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-11-20'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-11-20'
					)
				);

Cart #

Paste

Clear
Add All

Read ; Write ; Upload ; Image(258) ; Threads(139) ; Settings ; Profile ; Boxes ; Help
Banana Lounge Unofficial Fan Forum