2024-04-28

Count #

Items on page: 8

file_hash	item_title	author_id	cart
2024-04-28 #
`7fbe2869`	Public Key for Ilya Gulko	Ilya Gulko	+cart
`f112520c`	#rotate	Guest	+cart
`1f57f210`	#rotate	Guest	+cart
`1ceb9c72`	Software Updated to Version 6dd95ccc..	Guest	+cart
`406087fc`	#rotate	Guest	+cart
`d9929316`	Screenshot_2024-04-27_at_22-47-52_Instagram	Guest	+cart
`1df0c6e5`	438697363_10161852384384586_3215319638975837607_n	Guest	+cart
`7a3aa1ce`	1714283975_image	Guest	+cart

#changelog; #hashtag
Software Updated to Vers #
Software Updated to Version 6dd95ccc.. Installed software version has changed from a6399ea4.. to 6dd95ccc.. 6dd95ccc add cart column to threads view in default and flyerian theme 34eb8625 add tagset_threads column to threads view in flyerian theme 8fc18d73 add notable menuitem/section to flyerian theme 4f6b8eba improve donate page for flyerian theme 8ac65a91 add tagset_threads to field_advanced, threads.sql, and templates f27bef54 improve ilyag theme home/welcome page a1b796e7 improve ilyag theme home/welcome page e386dc19 improve ilyag theme home/welcome page 8e0d0df2 improve ilyag theme home/welcome page 33322971 improve ilyag theme home/welcome page 9ab8ada4 improve home page for ilyag theme c8f30a15 clean up welcome.pl for ilyag theme 45d54968 improve cory theme 414acfbf add some future code to cory theme's welcome.pl 32e81527 improve links toolbox 5bf2850a add searchable comment to item_page.pl 80981d31 add comment in welcome.pl dc0748ba clean up welcome.pl 3ff6ca88 move item page toolboxes to separate module, item_page_toolbox.pl 8b3710ac add js to donate page ; donate.pl 7ddf8235 improve appearance of cory theme b31b2bd1 add donate page to flyerian theme 1e8c53e1 add threads.sql query for flyerian theme 07a93390 add alternative implementations of TileDialogs() to scratch.js c60ee003 improve cory theme c3b9b228 improve test_thread.pl 1d97eb5d add TileDialogs() function in dragging.js 409e6c14 add cart button/column to raw view 2a3dea12 improve comments in item_html_link.pl dd570eb9 add searchable comment in sqlite.pl 13e830f2 improve additional.css for flyerian theme 03daef37 update default neighbor list facabbf4 add css and colors for flyerian theme e21b4b23 update todo c71bca43 add comment in test_thread.pl 67aec4ec add template for person_approved_keys.sql db224e3c improve indentation in item_template.pl 5bf26a35 add firebase-stored images display draft code to scratch.pl 6868d639 add checkmark string for dark theme 5b19550c add test for DBGetAllItemsInThread() ; test_thread.pl ad99df41 add image to flyerian menu 1145f238 fix bug in set.zip 06937ddc improve DBGetAllItemsInThread() ; all_items_in_thread.pl cee9ec00 add default for setting/zip/thread 5ed14c0c add to config.sh for bash theme 4769d247 improve thread/zip feature: only display thread zip if item has no parents; include file size in display ; item_page.pl 50d4e88c include author keys and self-id when returning DBGetAllItemsInThread() ; all_items_in_thread.pl 9240718d improve comments in all_items_in_thread.pl 032bee6a improve sanity, debug output, and fix bug in DBGetItemParents() ; sqlite.pl aaf3848c improve format of thread zip ; item_page.pl fec3fbe8 improve indenting in simple/.../home.template 678e055e improve comments and help output in set.pl e24ecaf4 improve set.pl 5564f52a add is_file() procedure ; file.pl 8593e24e improve set.pl b23164e5 add basic version of setting/zip/thread feature cfb30c89 add DBGetAllItemsInThreadAsArray() and improve DBGetAllItemsInThread() ; all_items_in_thread.pl b1ed0b06 add basic DBGetAllItemsInThread() all_items_in_thread.pl 93992261 improve comments in file.pl 9e82b53a add searchable comment in sqlite.pl 6551a2f2 add a searchable comment in item_page.pl de51d9a6 add all the toolboxes to enable_features.sh f10baa74 improve comments and debug logging in item_page.pl c460c34c add comments in make_zip.pl c3c9ac0d add perplexity to default search toolbox ; item_page.pl 8c098102 remove DBAddPageTouch('index') calls and update todo.txt 3e6c4ac1 add debug output in ResultSetAsDialog() ; resultset_as_dialog.pl e5e4b84f add debug output in utils.pl db6a003c add todo in inject_js.pl c428e06e fix indentation in settings.pl 719cff4f remove unused stub for SqliteGetPopulatedQuery() ; sqlite.pl 2a825c27 improve SqliteGetQueryTemplate() ; sqlite.pl 6a38e9f5 clean up old commented code in get_person_page.pl d65fbdd7 improve comments in get_person_page.pl 25409f23 add menu list for flyerian theme 97dc4c19 add default for setting item_image_double_click_to_like 19fa7b75 improve how server-added footer and parameters are recorded, so that there is no signature separator when the signature is empty ; post.php, store_new_comment.php 6e8d894f fix recent activity query on person page ; get_person_page.pl c9be55ea fix recent activity query on person page ; get_person_page.pl ad0a93e4 add author_key to recent activity query on person page ; get_person_page.pl 18f17b16 add searchable comments in get_person_page.pl ab7d6219 update todo.txt #changelog
Sun, 28 Apr 2024; 1ceb9c72; like ; +cart

#image
438697363_10161852384384 #

Sun, 28 Apr 2024; 1df0c6e5; like ; +cart

#client; #cookie; #hashtag; #parent; #received
#rotate #
>>IMG_20230310_ #rotate -- [Cookie] [Received] [Client]
no timestamp; Guest; 0eae8a8d; like ; +cart

#client; #cookie; #hashtag; #parent; #received
#rotate #
>>20230801_ #rotate -- [Cookie] [Received] [Client] [Cookie] [Received] [Client]
10/09; Guest; 406087fc; like ; +cart

#image
1714283975_image #

Sun, 28 Apr 2024; 7a3aa1ce; like ; +cart

#pubkey; #approve
Public Key for Ilya Gulk #
[This item is a public key.]
Sun, 28 Apr 2024; Ilya Gulko; 7fbe2869; like ; +cart

#image
Screenshot_2024-04-27_at #

Sun, 28 Apr 2024; d9929316; like ; +cart

#client; #cookie; #hashtag; #parent; #received
#rotate #
>>20230801_ #rotate -- [Cookie] [Received] [Client]
no timestamp; Guest; a6c2fbae; 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) = '2024-04-28'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-04-28'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-04-28'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-04-28'
					)
				);

Cart #

Paste

Clear
Add All

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