G4

RecentActivity #
file_hash	item_title	add_timestamp	author_id	author_key	cart
`86b4f3d2`	[Public key for G4, 384063E79CA1B214]	2 months ago	G4	`384063E79CA1B214`	+cart

ApprovedKeys #
file_hash	item_title	add_timestamp	tagset_pubkey
`86b4f3d2`	[Public key for G4, 384063E79CA1B214]	2 months ago	person; approve(1); vouch

ApprovedKeys.sql #



			SELECT
				file_hash,
				item_title,
				add_timestamp,
				'' AS tagset_pubkey
			FROM item_flat
			WHERE
				(labels_list LIKE '%,pubkey,%' OR labels_list LIKE '%,my_name_is,%') AND
				labels_list LIKE '%,approve,%' AND
				file_hash IN (
					SELECT file_hash
					FROM item_flat
					WHERE author_key IN(
						SELECT author_key
						FROM author_flat
						WHERE author_alias = 'G4'
					)
				)

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