Count #
Items on page: 3
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version efd3ebb4..

Installed software version has changed from a0d6e046.. to efd3ebb4..

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

#changelog
no timestamp; 0854e143; like; flag; remove ; +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version 869283bc..

Installed software version has changed from 3aedd608.. to 869283bc..

869283bc improve handling of cached messages

#changelog
no timestamp; 16d1e524; like; flag; remove ; +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version 3aedd608..

Installed software version has changed from efd3ebb4.. to 3aedd608..

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

#changelog
no timestamp; 5631a225; like; flag; remove ; +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
			item_flat.file_hash IN (
				SELECT
					file_hash
				FROM
					item_label
				WHERE
					label = 'hashtag' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = 'hashtag'
				)
			)
			AND item_flat.item_score >= 0
			 ORDER BY item_flat.add_timestamp DESC LIMIT 100
Cart #
Paste
Clear
Add All

Image(149) ; Settings
Welcome
JavaScript #