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

Count #
Items on page: 1
2023-01-09 #
file_hash item_title author_id cart
ab714dac Software Updated to Version 229a5483.. Guest +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version 229a5483..

Installed software version has changed from 4556f89a.. to 229a5483..

229a548 add root_search_query_redirect basic
33ba6e9 improve debug output in pages.pl
97e4e36 improve debug output in pages.pl
dcf8d69 move force_profile* settings under php tree, since that's what makes them take effect; also, add a few things to config.sh and improve welcome page for yavista theme, because i don't know how to undo a commit
b69217c improve comments in get_page_header.pl and pages.pl
6b6db69 improve yavista theme welcome page
1178f43 add templates to yavista theme which hide statusbar and menubar from default (beginner) view
af7e016 add GetWelcomePage() and welcome.pl to yavista theme
450d272 fix bug in PutFile() report_files_written directive ; utils.pl
abc0ed9 easyreg theme add comments to welcome.pl
2440a47 allow dialogs with a blank title ; get_window_template.pl
85a6342 make $dialogTitle change dialog's title in GetWriteForm() dialog.pl
2f44125 GetWriteForm() add $dialogTitle parameter dialog.pl
691e70d easyreg theme add comments to welcome.pl
b42d403 improve Expand and Minimal buttons -- do not reload page if it is not necessary layer_controls.template
c231ae0 add to yavista theme config.sh
7718c48 allow for templating of progress indicator string GetScriptTemplate() inject_js.pl
5a4f3a7 add sanity check to EasyMember() easyreg.js
cfc12c9 add username prompt setting to yavista config.sh
a4bf784 add sanity check to IncrementTagLink() voting.js
b64f25a improve debug output of GetItemTagButtons() widget.pl
870aa17 status bar and tags list hiding -- comment out in settings.js because it doesn't work right
809c0dd add to yavista theme: config.sh and tagset/all
9684fbd improve formatting widget.pl
b394247 add css for yavista theme
aa3c5b5 create menu list template for yavista theme
8507464 update welcome template yavista.theme
ec10fbf for dialog and layer controls, move most controls to advanced layer to make dialog look cleaner
889fb92 improve dialog titles on welcome page in easyreg theme
6cb2340 allow templating puzzle prefix in easyreg.js
454e49d when showing solved puzzle in formatted message, do not display prefix puzzle.pl
6e295e7 for easyreg theme, prefill puzzle prefix inject_js.pl
88603e5 treat dialog headers and status bar as advanced layer in settings.js
f546016 update rules and privacy template for yavista theme
da56571 improve easyreg and yavista themes
334edb4 fix bug in GetDesktopPage() desktop.pl
f6c1f31 update todo.txt
9c57240 add a titlebar.template for yavista theme (without # symbol)
2064ea2 improve yavista and easyreg themes... tailor easyreg to work with yavsita for now
c313752 add support for origin parameter / remembering form origin ; cookie.php and route.php
23f89a6 change mourn mode to read colors from config instead of hard-coded
6ef1766 add searchable comment to tag_link.pl
fa76f99 change template_refresh.pl to wait less time before updating
088bda8 improve desktop page (tail for yavista theme for now, to be changed later) desktop.pl
bc10b6a add background and text default html colors (for monochrome mode)
15f10cf improve "check engine" widget when in monochrome mode ; stats_table.pl
626d407 improve template to allow js injection layer_controls.template
109867a improve Reprint link and make Expand and Minimal links work without javascript
7c253e8 make 'Reprint' button in menubar work without js ; route.php layer_controls.template
e7bc4a5 on author profile page, if they have not yet posted anything, do not display a zip archive get_read_page.pl
134cdb7 update todo.txt
a1b94b4 add form_add_timestamp_input setting and separate from force_profile_include_origin setting
d7f35a6 when "hide" voting link is clicked, hide the parent dialog voting.js
68bee2b improve comments and debug output in IncrementTagLink() voting.js
6042f62 add HideDialog dragging.js
cd49236 hike.sh improve output
d10eadc when changing theme with set.pl, automatically rebuild frontend set.pl
b4e1f8a improve debug output and sanity of GetFileHashPath() utils.pl
3a5ec59 improve cookie login handler in route.php
0e4a9c6 add search keywords in sqlite.pl
4a4cec1 remove unnecessary statement in CloseDialog() dragging.js
1c954be update todo
3fa5c65 use TrimUnicodeString() instead of substr() in IndexTextFile() index_text_file.pl
a600bb2 rename and improve TrimUnicodeString()
07659ee add comments to stringTrimUnicode() utils.pl
15d242d add stringTrimUnicode()
59c342b exclude /rss.xml from force_profile route.php
338ff00 update bug.txt
ccf9f10 use SetPrefs() and GetPrefs() instead of direct localStorage calls in dragging.js for storing open_dialogs setting
997657b improve indentation in utils.php
eb6453f improve readability of item_listing_page.pl
be80646 improve readability of index_text_file.pl
d0bf82e do not display menu on welcome page when registration is required
62933ee add basic save_dev_items.pl (collects development-related items into todo.txt)
cc8703c add checkbox for showing/hiding beginner hints layer in settings dialog settings.template settings.js
aa696a6 add stats to default menu for sm theme
4a39125 improve readability GetItemListingPage() item_listing_page.pl
9d5e6fd add a line break before the second pagination buttons dialog so that it appears at the bottom, below the listing GetItemListingPage() item_listing_page.pl
14f3166 improve formatting in readme
bbfa1ff improve empty calendar page GetCalendarPage() calendar.pl
6143489 approve MergeFiles() readability and debug output file.pl
5c1101a utils.pl add searchability
8d7ef49 update todo
c239577 add searchability to utils.js
f5e5dbf slightly improve scores page and add it to theme menu
e94b102 make CloseDialog() actually close dialog
221f5e8 hide debug message in dragging.js
61efc07 improve hike.sh: add pages action, improve alog action
9171dab add routes for scores page
e728e3d add scores page (authors sorted by score descending)
c8c78d9 improve author page: display score=0 items by default, and increase displayed items limit
446304a add authors and scores listings to help_views dialog
ae4dc99 update paste control after pasting is successful
5250e44 add CloseDialog() ; add skeleton of saving open dialogs state as they're opened and closed
f38cfbb update bug.txt
7dacc3c todo.txt
68bb277 update todo
9a7d35f after archiving is finished, call index.pl, so that the newly posted archive notice is indexed, then call hike frontend to rebuild the frontend
799d00c add basic stats command to hike.sh
f77447c improve tag info for pubkey and signed hashtags
150e2ff add ukrainian wikipedia link to search toolbox
4e7d833 limit more queries on desktop page to 10 items GetDesktopPage() desktop.pl
063ac4d add sanity check for file size in IndexTextFile() index_text_file.pl
15d72c4 make Annoy command auto-cascade dialogs on page to make it more obvious to the user what it does. dialog_controls.template
6b494ca add option route_welcome_desktop_logged_in, which replaces welcome page with desktop when user is logged in route.php
27531c3 add search keywords sqlite.pl
e2b9636 improve desktop page
f961235 update todo
4f6cffc improve formatting get_window_template.pl
595f3e1 fix bug and add comments with explanation CollapseWindow() dragging.js
308fcf9 clean up and update todo.txt
adb654e remove hard-coded js from titlebar_with_button template and inject from GetWindowTemplate() instead, only when js/enable is true get_window_template.pl
0c6bf51 add debug output WriteItemListingPages() item_listing_page.pl
ffc48f8 add basic 'no results' message when read page is empty GetReadPage() get_read_page.pl
622a010 disable broken debugging features revealed by GetConfig('debug') working correctly now inject_js.pl utils.pl
6445ef3 improve authors page intro
cf042be remove unnecessary warning in DBAddItemAttribute() sqlite.pl
2a88543 only inject server response message into page once; minor debug output improvement route.php
dfd8353 replace -e with file_exists in PutStatsPage() pages.pl
be6a02a fix special case for config/debug and improve debug output in FixConfigName() config.pl
fcf087d for mavo items, remove header-footer when displaying
7069611 on item listing page, format page intro with <br> tags
b49a567 improve page_intro strings for tags and threads pages
7ad5a20 add link to random page to help_views template
d86fac4 fix random page and move random query to separate template makepage.pl
2199f12 add zip/tag configuration option
103c5e3 update todo
aa40edd update todo
549ed77 improve rebuild.sh -- doesn't block rebuild if index.sqlite3 file is missing
dd3c53a update todo
86d241b update todo
dabdfcb add clarifying comment in enter.template
db90c2c comment out debugging message dragging.js
1818c44 improve smell get_read_page.pl
9af2d6e improve UpdateDialogList() and basic skeleton for SpotlightDialog() dragging.js
4c4bfff if importing a profile, takke user to that profile's page upload.php
3a62644 allow more fields to be displayed as timestamps RenderField() render_field.pl
2646324 improve upload form to more accurately reflect allowed file types
2540dac improve logging, debug output, and code smell IndexZipFile() index_zip_file.pl

#changelog

; ab714dac; 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) = '2023-01-09'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-01-09'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-01-09'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-01-09'
					)
				);
			

Cart #
Paste
Clear
Add All
^
JavaScript #