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

Count #
Items on page: 1
2022-12-21 #
file_hash item_title author_id cart
6c5e2465 Software Updated to Version 4556f89a.. Guest +cart
Software Updated to Vers #
#changelog; #hashtag; #https

Software Updated to Version 4556f89a..

Installed software version has changed from 42912dbe.. to 4556f89a..

4556f89 add page intro for threads page
3899a78 add some writing found from friends_camp
426bce9 remove extra spaces handle_not_found.php
6cdca0d add page_intro to listing pages GetItemListingPage() item_listing_page.pl
8d7d6b3 IndexFile() disable seemingly inactive code section
3c47cb1 temp-fix OrganizeFile() bug in IndexTextFile() index_text_file.pl
9269705 improve zip file presentation basic
d595543 add skeleton draft of better_than.txt
7e91b57 improve avatar cache path to include all effective themes GetAvatar() avatar.pl
ae176f1 add search keyword for GetItemTemplateBody() item_template.pl
850df46 add some searchable comments in utils.php (document how to escape url parameters)
f53d7a8 check for item deletion sooner in IndexCppFile() index_cpp_file.pl
4fd03f4 improve debug output in GetItemTemplate() item_template.pl
2d8dee1 add force_profile_include_origin option
53677e9 remove defunct domain from publish toolbox
73220c5 add zip file support and add additional checks for file types being enabled before indexing them
67aa162 add setting/admin/zip/enable and make html/enable false by default
ba6735f improve easyreg welcome page
0f983b8 add force_profile_redirect_path setting to allow a different registration entry page than profile.html
7e64026 add comment in profile.js
123d7fe improve easyreg theme
ca71c6d improve easyreg welcome page
1dc9660 add documentation comment to make it easier to remember how to escape a url component utils.js
74bf6a2 fix typo in profile.js
1dbf3d2 change method used by sharePubKey() function in profile.js
b631893 fix indentation in profile.js
531a7be add optional messageField and callback parameters to signMessageBasic() crypto2.js
759c403 add option of callback to MakeKey() crypto2.js
d8df9d1 add easyreg theme basic
d2ffe15 improve smell profile.pl
38ec53c add signMessageBasic() basic crypto2.js
7fde867 WriteOnLoad() improve debug output write.js
8411f2d add basic getSolvedPuzzle() factored out from doSolvePuzzle() puzzle.js
e856f33 clean up MakeListingPages() -- remove redundant call to MakeProfilePage() -- it is called a few lines lower ; pages.pl
79626db improve sanity and debug output in GetFileMessage() file.pl
8d7b2df improve image and new queries
65d7a7d Merge branch 'master' of [https]
f1519fb fix image query
6cd0fd9 improve debug output DBAddItem() sqlite.pl
058685a fix warning caused by DBAddItem2() calling DBAddItem() with empty parameter
cfdbed9 improve debug output IndexTextFile() index_text_file.pl
a083fb1 improve debug output GetFileMessage() file.pl
a8b526f remove unhelpful warning GetMessageCacheName() cache.pl
f30256a improve sanity and debug output in MakeIndex() index.pl
3c05cd8 improve image query
0e33ae7 image_container.pl add sanity check in GetImageContainer()
d120d22 eliminate gt (>) character from dragging.js
50ab6e8 improve image query
19e03ce add max-width stylesheet when adding inline-block stylesheet (temporary hack) pages.pl
f3948af add easy_register.js for easyreg theme
2f87bd3 make skeleton for profile.template in easyreg theme
0e6b6d0 improve output hike.sh
a61357c improve output clean.sh
0d5a0a4 improve readability and debug output of MakeListingPages() pages.pl
b11a89f fix bug and improve debug output in MakeIndex() index.pl
06724b0 fix bug and improve debug output in MakeIndex() index.pl
cb15bd3 pages.pl: include profile.pl before calling GetProfilePage()
330a33a improve comments and change PingUrl() method used in crypto2.js
8d31285 improve profile.js ; add more comments and improve public key sharing code
39b6078 update todo
6e54bc4 improve smell profile.pl
7624df8 add some debugging output to puzzle.js
0c11322 improve template_refresh.pl -- only rebuild if perl templates were updated
7b7ab77 add comments utils.php
817dcbb add new dialog types handle_not_found.php
9dc3e55 improve dialog making logic and add more dialog types pages.pl
4517170 data.pl: factor out GetDataDialog() and MakeDataZips() out of GetDataPage()
49713f1 add option to focus dialogs when spawned into page
301f174 move PingUrl() from voting.js to utils.js
fa8d78a add link to image page to help_views.template
c5c381e add comments to doSolvePuzzle()
7163cae easyreg theme skeleton
feb3e0c add to scratch.html
bfe34aa new page query: only display items from past 3 days
10b3bdd new page query: add cart button
8ea60bc add special column field type for just having a +cart button to RenderField()
1f34526 update readme
c8746d4 move GetProfileDialog() from dialog.pl into profile.pl
8771de1 improve examples.template
61287b7 improve profile.pl readability
625c00f improve thankyou theme
f9c2eef fix formatting in about.template
b6975e5 help.pl add search keyword
89f4c04 add some comments get_page_header.pl
6386d82 in GetPageHeader(), look up page title in strings if available get_page_header.pl
41f8da1 improve default pages for thankyou theme (add utils.js if js is enabled)
93e1020 banana theme: remove rounded corners on titlebar class, because it caused a visual issue in menubar's titlebar additional.css
e2163a7 fix bug in noscript indicator pages.pl
ebbe03f improve GetNextPreviousDialog() by adding sanity check and improving readability
aabad64 improve thanks page
77e9ebe correct user-facing message in template_refresh.pl script template
c08c793 improve thankyou theme skeleton
b615ae8 add to todo.txt
a014c91 fix bug in GetThemeAttribute() utils.php
14a4e5d improve MakeMenuPages() and add it to MakeSystemPages()
1d76110 improve thankyou theme skeleton
68f440d fix typo in handle_not_found.php
7bef36c add skeleton for thankyou theme
d0a8036 update todo.txt
e359737 add GetActiveThemes() and improve GetThemeAttribute() utils.php
9f85a86 improve readability route.php
89cbe2a add thanks page to HandleNotFound() handle_not_found.php
c68ebd1 add thanks page to MakePage() makepage.pl
1254932 add GetActiveThemes() and improve GetThemeAttribute() config.pl
c0298ce slightly improve output of template_refresh.pl
9e46c56 improve template_refresh.pl
d86498a improve notice posted by by _dev_archive.pl after forum is archived
e29ad67 add todo in get_window_template.pl
59984d2 update some docs
081ab12 update clip_selection_long.js
8e553f5 add toggle for history dialog
214786d add menu template list to dev theme
d870c35 improve template structure
91400e1 add missing line in utils.pl
a4ba760 fix typo utils.pl
e874ac2 add todo in _dev_clean_html.sh
311138a add limit to related query default template
e16ad99 add todo item_page.pl
6aab65a add skeleton for history dialog get_page_header.pl history.pl history.js history.template
15eb9b8 improve debug output in GetWriteForm() and add support for PHP without rewriting dialog.pl
83b3426 improve debug output of str_ireplace() utils.pl
118b3cb improve debug output of str_replace() utils.pl
afdfafc improve searchability config.pl
fc5929f improve template_refresh.pl
121c4ab improve smell dragging.js
99df11e fix indentation and add better wording post.template
42f476f update todo
d37a027 improve searchability pages.pl
55d6fa5 add tasks query and page
cd3df1b fix bug 60302827 in set.pl, directories should not be considered possible setting keys set.pl
d2b58e2 add noscript notice to dialog list dialog_list.template
0bb579a fix tags link on help page help_views.template
1fe114a add search keywords in render_field.pl
a40e248 add "ukrainian/cyrillic" wherever it says russian in the UI
c19c0c4 remove insults list (not sure where this is pasted from)
72a5049 move PAPER.TXT to doc/draft
30039ea slightly improve paste.template
3d333a6 add indexing of perl files in html/perl/ from IndexFile()
8e67722 add debug output to PutStatsPages()
6118e27 improve smell utils.pl
be42792 improve smell of PutHtmlFile() utils.pl

#changelog

; 6c5e2465; 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-12-21'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-12-21'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-12-21'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-12-21'
					)
				);
			

Cart #
Paste
Clear
Add All
^
JavaScript #