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

Count #
Items on page: 1
2022-11-20 #
file_hash item_title author_id cart
2526c764 Software Updated to Version 42912dbe.. Guest +cart
Software Updated to Vers #
#changelog; #hashtag

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
; 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
^
JavaScript #