2022-05-20

Count #

Items on page: 7

file_hash	item_title	author_id	cart
2022-05-20 #
`3877466d`	#flag	Guest	+cart
`633f0a57`	accidentally testing on production	Guest	+cart
`b5885bd5`	Software Updated to Version bfaa783c..	Guest	+cart
`ba7d1b41`	Reindex log metadata	Ilya G	+cart
`d375a89a`	#like	Ilya G	+cart
`e12f143f`	#flag	Guest	+cart
`f1278b65`	1 instance of literal crying over no bananas today (human visit	Ilya G	+cart

#cookie; #hashtag; #parent
#flag #
>>7c5401c5.. #flag -- [Cookie]
09/22; Guest; 3877466d; like ; +cart

#hashtag; #parent
accidentally testing on #
>>dd4ed76a.. >>370d8d6e.. #remove accidentally testing on production D229E182A0835A1B 1653076118 0.8453050394492394
Fri, 20 May 2022; Guest; 633f0a57; like ; +cart

#changelog; #hashtag
Software Updated to Vers #
Software Updated to Version bfaa783c.. Installed software version has changed from 7504c674.. to bfaa783c.. bfaa783 add rebuild button to operator controls c4e7e5c change "insert" to "paste" on reply cart dialog 224ec5e add active element to tos checkbox 03e694a add reply cart to tagset fields when it's enabled globally 6b669f1 add reply cart to query pages edc3d3f add "add all" button to reply cart dialog" 2993b93 add skeleton for publishing logout event 3de9ce9 improve reply_cart.js f9670f3 improve display of chain hash field 8fcd35e improve string 2c27e10 Merge remote-tracking branch 'origin/master' a5d5b82 return 'Untitled' in related query if no title c614e92 return 'Untitled' in related query if no title dfc253b improve default tos 96c1fb1 improve tos display f268250 add notarized hash to item attributes so that it can be matched with item's other hashes 2100102 add_to_reply_cart.pl improve smell 204ecab reply_cart.pl improve smell 061a720 reply_cart.js improve smell fd6af2a update todo bcc04fc improve default tos 33ac200 improve js injection on read pages 9667dea fix and improve reply cart buttons 3b35301 sqlite.pl improve comments 9841b91 fix bug in looking_for text selection (if list is missing) 8433a2b improve collapse button 8fd2e98 add cloud page (tag pairs) 6dfecba improve smell dialog.pl 80e671f make a simpler default looking_for list 7d5eb5d add ExpandAll() and CollapseMost() d614645 todo 6d2695a set default puzzle prefix to 1337 262f11d improve default tos message to include checkboxes and agree button 499001d improve reply cart 19cc623 fix parsing of permissioned tags 56fa44f add setting/html/resultset_dialog_print_query 77e4df8 welcome.pl fix indents (rs theme) 53fbffd chain.pl: fix indents 31508ae update todo bb4d784 move things related to the chain log to index.pl c8ae30d update todo a53ebb1 Merge remote-tracking branch 'origin/master' c5fb3f2 remove extra closing tag in write.template fae3b01 remove extra closing tag in write.template 1206ce3 improve welcome template for rs theme #changelog
09/22; b5885bd5; like ; +cart

#cookie; #hashtag; #parent; #title
Reindex log metadata #
Reindex log metadata -- >>Reindex log fini -- #textart title: Reindex log finished at 1652985400 [Cookie]
09/22; Ilya G; ba7d1b41; like ; +cart

#cookie; #hashtag; #parent
#like #
>>a7ba0173.. #like -- [Cookie]
09/22; Ilya G; d375a89a; like ; +cart

#cookie; #hashtag; #parent
#flag #
>>dd4ed76a.. #flag -- [Cookie]
09/22; Guest; e12f143f; like ; +cart

1 instance of literal cr #

1 instance of literal crying over no bananas today (human visitor less than 5 years old)

Fri, 20 May 2022; Ilya G; f1278b65; 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-05-20'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-05-20'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-05-20'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-05-20'
					)
				);

Cart #

Paste

Clear
Add All

Read ; Write ; Upload ; Image(296) ; People(18) ; Threads(40) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum