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

Count #
Items on page: 1
2022-10-19 #
file_hash item_title author_id cart
19e4c177 Software Updated to Version 9225ec3f.. Guest +cart
Software Updated to Vers #
#changelog; #hashtag; #https

Software Updated to Version 9225ec3f..

Installed software version has changed from 2e18f723.. to 9225ec3f..

9225ec3 improve hash mismatch message to user cookie.php
a610e8a utils.pl fix missing space in WriteLog() output
f94402b improve formatting in sqlite.pl
8ec88ce add code to diagnose malformed sqlite queries sqlite.pl
5bfb181 add search keyword in dragging.js
d75a20f add search keywords in makepage.pl
c86324d update todo
34a71bf add to scunthorpe list
b360853 carlos theme, add comment in welcome.pl
56a78b4 improve queries where tags_list field is used
3dd1224 add sanity check to GetFileHash() utils.php
039fe53 improve index_text_file.pl
83771ca impove threads query
1c96c07 fix typo index_text_file.pl
c00da4b remove references to install.pl until it's fixed build.sh
a9931f6 change threshold for blocking rebuild rebuild.sh
527ecf4 improve error handling when rename fails utils.php
740d6d6 add search keywords utils.pl
361efa9 improve GetFileMessageHash() utils.pl
a9942c5 improve printing of debug snow (first line should contain timestamp prefix) utils.pl
70a4ea4 change method of looking up script directory ; allow script directory to contain period character. utils.pl
696dc4e remove setting: allow_admin_permissions_tag_lookup_via_tagset IndexTextFile() index_text_file.pl
4c496d7 fix permissioned tag lookups for author key IndexTextFile() index_text_file.pl
dea05be improve page printed template printed_notice.template
8de3d36 add search keywords in file.pl
6971332 move expire_pages.pl out of script directory
627e6a5 improve template_refresh.pl
0ee4e8e add draft welcome page to yavista theme
13481ab add sarch keywords to utils.js
bfe48c3 improve upload page by splitting paste functionality into separate dialog
f514544 improve sanity and smell of calendar.pl
277d5dd improve text in printed notice (when page is printed just now) route.php
d2f2ae6 improve calendar.html page GetCalendarPage() calendar.pl
95bce11 improve date listing page get_read_page.pl
92245a1 add calendar basic links to listings and by-date pages calendar.pl get_read_page.pl
a7a35a5 improve calendar.pl
7287784 add search keyword in html.pl
68003c0 add comments in item_listing_page.pl
219a4aa update todo
c9285c3 improve printed notice
ff7e6d7 add search keyword to MakeMenuPages() pages.pl
0b0e29f improve border in lisonok theme
defbedc improve border in lisonok theme
f427c91 improve script smell chain.pl
c5da569 do not write previous item attribute if it doesn't exist chain.pl
784571b improve printed notice template about page contents printed_notice.template
99c438c make script more informative about not being finished template_refresh.pl
d72a81e add .cpp and .py mime types to lighttpd.conf.template
e94916b improve reset button appearance reset_button.template
403af56 make DBAddItemAttribute() exit if sanity check fails sqlite.pl
c55053d update/improve todo.txt
ab4f618 add comments on how to add rewrites for write.php and upload.php to lighttpd_php_rewrite_all.conf.template
f715390 add skip_footer_when_pubkey setting to fix common problem with duplicate pubkey items ; StoreNewComment() store_new_comment.php
2039f3a refactor StoreNewComment() to improve smell ; store_new_comment.php
7398047 update todo
9a9a208 add css template to restrict width of txt elements
f40acad improve comments and formatting of lighttpd config templates
6b06db0 update todo
f018d8c improve sqlite.pl
be03937 fix bug in item_page.pl
2d30da7 improve GetReadPage(): add a way to display query which generated the page get_read_page.pl
6c20d5d improve template_refresh.pl
edde4af add call to template_refresh.pl when calling "hike frontend"
5f39587 improve Minimal button: add access key, and feature check in javascript layer_controls.template
eb1492f improve informational message on public key item pages
4b93bf4 add basic template_refresh.pl
248a6a1 add missing checks to Expand button in layer_controls.template
c5c5b94 add debug output to MakePage() makepage.pl
f88f922 add missing utils.js to search page
510a62f change caption of thermostat dialog
9d5a042 update todo
a274eb3 adjust wording in printed_notice.template
42a50b1 add link and vlink colors to panera theme
9d7dc12 add some colors to panera theme
d1d1617 add menu and welcome dialog for sm theme
1efb5ca pages.pl add debug output
06b0750 add MakeMenuPages()
06f9ac6 improve comments file.pl
235b600 update todo
e40790c add GetThreadListingDialog() and clean up thread_listing.pl and item_page.pl
19e54c0 move stats table below settings dialog on settings page
405dc5c improve printed_notice
7d0276d improve timestamp.js ; should not display "0 seconds from now" anymore
725d44f remove advanced layer from admin checkbox so that it can be used independently of the advanced checkbox
224543d update doc
1e47e7d add comments item_template.pl
a6c60ee add support for py files index.pl index_file.pl
caae987 improve comments html.pl
632d5d1 add PyForWeb() formatter
81e0b27 add comments in utils.php
757bf01 reset setting of admin layer too when pressing 'reset' layer_controls.template
3d77c23 improve debug output in cache.pl
2c7ae6e improve todo
25d485d add support for python files
cbfc47f update todo
68ab315 add item_type to list of advanced fields
c123eaf fix lighttpd config template to work with friendly urls
2551f73 improve url_ailas_friendly option in route.php
3c8eb36 add some comments ; add GetItemUrl()
202670a add comment chat.js
a9c2857 item status bars: reply link not advanced layer status_bar.template
a33a699 update todo
84ffe1b improve lighttpd_basic_auth.conf.template
f783290 improve debug output in IndexFile()
4cccf69 add comments index_file.pl
a8d0516 add hint comments for where OrganizeFile() is called from ; index_file.pl index_text_file.pl utils.pl
4401616 improve set.pl: list contents of ".list" file when it's available
9a2fe4e improve contrast of colors in banana theme
54abc4b add todo in dragging.js
aa66007 limit length of dialog title in dialogs list dialog ; dragging.js
00acb29 reset button should not be displayed unless js and php are enabled
bbfe793 add threads item to default menu
0095175 update todo
a42ec5b improve debug output in InjectJs() inject_js.pl
221618d update todo
12b980c update todo
839f0fc add seconds to timestamp widget titles
eeb9a80 add/improve sanity check in DBAddItemAttribute()
47f7a1f improve related query
878abe1 item page: move attributes to admin layer, hashes and timestamps to advanced layer
824403b update todo
3a1dc3c improve message when #remove token is declined
e8af0c1 fix bug in puzzle.js (original puzzle solve start time should be reported)
0fda6b8 fix bug in utils.pl
11d96ec optimize GetItemPage() and move Related dialog to advanced layer
efe9d75 add sanity check in CheckForInstalledVersionChange()
090f250 improve comments in index_file.pl
147bdeb after writing changelog, index the changelog file
cf067f4 fix missing id bug in query dialogs
659c500 improve related query and dialog
dca9492 do not block related listing in mourn mode
3cec105 add toolbox_hashes and toolbox_timestamps options
cc0e35f improve GetResultSetAsDialog()
dd6b8f5 improve item_page, add more toolboxes
5495690 add no_heading and no_status options to GetWindowTemplate2()
db6e641 update todo.txt
c800f05 improve RemoveHtmlFile()
823da82 improve related query
d3656e0 Merge remote-tracking branch 'origin/master'
399fdfc improve comments in index_file.pl and cache.pl
706c4cc improve description of sha1 item attribute
40c40ca add sanity check in GetReadPage() get_read_page.pl
cf13c7e add script for fixing text file filenames (remove spaces)
ef99960 add a sanity check around sha1sum in sqlite.pl
129e61b update todo
f7a0a6c improve message to operator on how to enable upload feature
b2e99dd improve todo
eba4228 improve set.pl (hike set)
58152c1 next/previous toolbox on item page basic
323c663 clarify printed time dialog route.php
aae7bb8 improve smell and add run time and compile time logging in index_cpp_file.pl
3b08deb add chain_next attribute
16d01e7 remove capitalization from system tags
dd31743 add provisions for tags dialog
f23d751 put run_log into default ui layer item_page.pl
dab8d06 uncomment RunItem() call index_text_file.pl
98bf202 improve smell index_text_file.pl
f597ac4 add tags and authors to dialog id special case
7bcc4a0 add to default menu
4ada24a update todo
f0a8409 item page: display run log before compile log for cpp items
b3c03f7 fix/improve cpp file support
63542d7 improve smell upload.php
6f6ca0c improve smell in html.pl
09167ed add comment in expire_pages.pl
24d139b fix indentation and misformatted comment in gpgpg.py
3ed3cc9 update scratch.pl
dbaed44 rebuild.sh get rid of unnecessary pages --system call
3ba7072 minor improvements
f5a79d6 update todo.txt
1de73a7 add basic support for cpp files
ab6f0e8 fix dragging.js having a gt character
ba54698 remove extra whitespace index_text_file.pl
6d1877c add message_hash attribute
b978b3b fix indents in some files
bb10033 add string for message_hash string
7023d8b add GetFileMessageHash() and fix indents in utils.pl
9bc5a3d improve smell in item_page.pl and change item attributes sort
ccbc6d0 move nojs indicator to better spot
bdf3cb0 improve smell/style pages.pl and utils.php
8da119b sanitize dialog id in GetWindowTemplate() get_window_template.pl
7c3432f add to scratch.pl
de3af09 improve FetchDialog()
6e84eb6 add to todo and some comments related to duplicating hashtag dialogs
5fa437b improve smell dragging.js
b82c3ac update todo
f811dc5 fix typo in utils.js
18b9a80 Merge branch 'master' of [https]
cbc0c98 Merge branch 'master' of [https]
c3ff018 when refusing to rebuild, provide information about file counts rebuild.sh
dba202d capitalize some system hashtags to make them easier to read
6f61b81 remove no longer necessary special case for http and https tokens in IndexTextFile() index_text_file.pl
f039f2b add special case for upload dialog in GetWindowTemplate() get_window_template.pl
9bd4556 make dialog name friendlier in author page get_read_page.pl
af0d44c change case of hastext tag in commented out code thread_listing.pl
3ceca6c add dialog list basic, toggled by config/setting/html/dialog_list_dialog
ef057e2 add comments in EventLoop() utils.js
c96a657 improve smell scrape_hn_comments.js
0161fe0 reset query text in
f858329 add capitalized tags to system tagset
d87b522 add comments to get_window_template.pl
5896f27 add a little sanity to stats_table.pl
50ff123 update todo.txt and brainstorm.txt
a7090fd make perl-based sha1 attribute caption more clear
d815b93 make chain_hash caption more clear
75edb3a improve readability item_page.pl
2f8c3fb add todo pages.pl
9fe4e6f highlight approves and declines in parse log GetItemIndexLog() item_page.pl
e3fbef4 improve smell item_page.pl
ca099ed add missing line to enable openpgp module to enable_features.sh
71b40d6 fix warning related to boxes count feature in post.php
1846c8e improve indexing of new item's chain attributes
f70f158 don't need warning for missing strings in GetThemeAttribute()
1873040 improve GetFileMessage()
5c6cd5c add save button to content filter dialog
ed86d1c add accesskey to layer controls / reprint button ; exclude O and R from accesskey selection in GetAccessKey() because they're used by Expand and Reprint
45dd13d clean up old commented out code in perl files
3e8cb80 fix typo in get_window_template.pl
8a0179c improve fallback of window anchor selection in GetWindowTemplate2() get_window_template.pl
607f80a GetConfig() add exception to no-default warning for debug setting
8d927a7 improve documentation for config system
dcbbc6b in banana theme make item dialogs wider
a0582e7 allow page information notice even in mourn mode

#changelog

; 19e4c177; 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-10-19'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-10-19'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-10-19'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-10-19'
					)
				);
			

Cart #
Paste
Clear
Add All
^
JavaScript #