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

Count #
Items on page: 3
2025-02-20 #
file_hash item_title author_id cart
3b72a005 Software Updated to Version d9355901.. Guest +cart
665868a0 Software Updated to Version 0baeac2b.. Guest +cart
fdef981e [Public key for ilyag, 0DE17A1AB5ED3335] ilyag +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version d9355901..

Installed software version has changed from 0baeac2b.. to d9355901..

d9355901 suppress error output in _dev_clean_html.sh when touching files

#changelog

; 3b72a005; like ; +cart
Software Updated to Vers #
#changelog; #hashtag; #https

Software Updated to Version 0baeac2b..

Installed software version has changed from 9e1f2d62.. to 0baeac2b..

0baeac2b refactor redirect logic in cookie.php to use RedirectWithResponse()
c2fdc6d2 add caller information to debug output in setcookie2() ; utils.php
7339b514 moved api.md to doc/
68bbd297 add todo in cookie.php
36e160b7 add todo in route.php
1efaf3b3 fix bug to do with cookie.php and some GET requests not having the first URL argument correctly parsed out ; route.php
18730c67 fix bug with modern theme detection in dialog.php
13419bc0 add debug output in cookie.php
ee23d204 move api.md from docs/ to doc/
9f57a5e5 add api.md
006bd564 add to scratch.pl
3fcaaa46 update todo.txt
127342b3 fix indentation in file.pl
56cd439e add clarifying comments in utils.pl
94b1e6c5 add comment in route.php
08c45c2c Initial commit of sqlite.pl from sqlite-dbi theme
c10d35c2 add draft of settings.md
478bdf07 change search redirect feature to default to kagi instead of google for compatibility reasons (nojs) ; route.php
fbd8a091 add setting route_mosaic_compat
aac9abe0 add todo/comment in item_template.pl
9645df17 Add architecture documentation for Pollyanna framework
c3837084 remove redundant DBAddItemAttribute(.. title ..) in gpgpg.pl
61e7497c improve debug output in DBAddItemAttribute() ; database.pl
41424dab improve get_person_page.pl, add DISTINCT to PendingKeys query
1958a4f2 add comments and todos in cache-sqlite/.../cache.pl
05882fc4 fix inconsistencies with GetMessageCacheName() that fixes empty messages on item templates
da303090 improve debug output in utils.pl
14c46777 improve debug output in item_template.pl
2e35beed add mod_auth to modules list in lighttpd.conf.template to get rid of warning when starting server
3f3c3daa add searchable keywords in server_local_lighttpd.pl
134b76c3 add scratch.js
0db3eccf add todo in sqlite.pl
029be356 prepare route.php for making interface mode button outline/border themeable
00a4ca87 fix verify_instructions_signed.template
e266f103 add qdb theme with menu list
8d37a124 revert `hike page ` to working version in hike.sh
77228c8b improve handling of `hike page` in hike.sh
869283bc improve handling of cached messages
3aedd608 add calls to MigrateCache() in gpgpg.pl
2c90b9d7 improve debug output in gpgpg.pl
52c13d03 add debug output to GetCache() in sqlite-based cache.pl and fix indentation
dc946de5 add file description to sqlite-based cache.pl
c9abc874 improve debug output in utils.php
3c0fcd23 improve debug output and formatting in route.php
a7389a50 remove duplicate function name in sqlite.pl
3de3a331 improve formatting in fresh.js (remove empty line with tab)
0525af35 improve appearance / visibility of server response messages on modern theme
4804d4a0 add debug output in cache.php
efd3ebb4 update todo.txt
d0225772 remove stray characters in route.php
def3fbc7 improve debug output in gpgpg.pl
887d5428 add MigrateCache()
f77bc855 add MigrateCache()
ce32337a use proper logging in cache-sqlite/.../cache.php
ed6674b7 add cache-sqlite theme, which substitutes sqlite-based cache for file-based cache
203f5f3f fix logic around alias lookup for session status dialog in route.php
927815bf Merge remote-tracking branch 'origin/master'
12d5dc05 improve code style in route.php
f6983f8a remove old commented code in route.php
dd7fbb13 Update todo.txt
6aa411ad update todo.txt
f6cf06cb remove comments from sane_defaults.sql ; remove part of sane_defaults.sql from schema.sql
bd4736a1 fix the way query templates are concatenated in SqliteMakeTables() ; sqlite.pl
e700b6e2 update people.sql to be compatible with mysql
7657a7a1 add sane_defaults.sql for sqlite
6006e97f update query to work with mysql ; mysql.pl
ddada427 add debug output in mysql.pl
74fe47e0 change INSERT OR REPLACE to REPLACE in order to improve cross-compatibility with mysql ; database.pl
25f2b8ec improve labels.sql
3e4005e3 for mysql driver, use DBI instead of shell ; mysql.pl
1d27a4ee change '.tables' sqlite command to 'SHOW TABLES' mysql command in mysql.pl
5f6a3dc2 improve code style and debug output in mysql.pl
29b3a294 add debug output to MysqlConnect() ; mysql.pl
9341729d update todo.txt
f3fda8fe improve debug output and comments ;
62bdd6f8 replace includes of sqlite.pl with database.pl and reduce conflicts ;
92eadf8a improve mysql.pl
ef1f8226 improve database.pl: include driver file depending on setting
4866c237 change SqliteGetCount() to DBGetCount()
432711f5 add label_weight.sql for mysql
e741b821 add DBGetCount() database.pl
95862e8f add database_type setting
1b179d81 make database.pl include database layer (sqlite or mysql)
f8ac49b9 improve debug output in page_map.pl
666f0252 update todo.txt
4b88fedc finish mysql.pl
71478eec remove time keyword in hike.sh so that there's no stray output when piping ; hike.sh
44fa4626 improve query formatting in welcome.pl
a0d6e046 fix link to qdb screenshots on ilyag home page
e1bbe955 fix link to qdb screenshots on ilyag home page
3bc16a44 update todo.txt
0019dc65 update todo.txt
d2643ec5 add mysql.pl
64ab1ab5 fix comment indentation in sqlite.pl
032949dd improve formatting in sqlite.pl
89f920dc improve comments in sqlite.pl
71ff1653 Merge branch 'master' of [https]
005ef765 add schema for mysql ; default/template/mysql/schema.sql
3015e13e improve IsSaneFilename() ; utils.pl
de7fd1a7 make database.pl and move logic from sqlite.pl into database.pl
42b1cb61 Update README.txt
3d5171f5 Update README.txt
a675942d Update README.md

#changelog

; 665868a0; like ; +cart
[Public key for ilyag, 0 #
#pubkey

[This item is a public key.]

no timestamp; ilyag; 38352782; 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) = '2025-02-20'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2025-02-20'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2025-02-20'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2025-02-20'
					)
				);
			

Cart #
Paste
Clear
Add All
^
JavaScript #