# x ilyag

Alias: ilyag✓ Seen: 10/05 Keys: 1 Score: 13 Items: 2

# x people.sql

SELECT * FROM ( SELECT author_alias AS person_name, COUNT(author_key) AS author_key_count, MAX(author_seen) AS author_seen, SUM(author_score) AS author_score, SUM(item_count) AS item_count FROM author_flat WHERE author_key IN (SELECT author_key FROM person_author) GROUP BY author_alias ) WHERE person_name != '' AND author_key_count >= 1 AND author_score >= 0

# x Guests
file_hash	author_id	author_key	author_seen	tagset_guest	cart	item_count
99ddfe1d	Guest⏳	5EEBFB77711F8B0A	10/05	approve; vouch; flag	+cart	1
1e54337f	Guest⏳	1CF263AE5795AAF3	10/05	approve; vouch; flag	+cart	1
7c2b0c72	Guest⏳	D4EF2AC8870DF794	10/05	approve; vouch; flag	+cart	1
dcdfe3bd	Guest⏳	6D518C53F12F8091	10/05	approve; vouch; flag	+cart	1
0e275cdf	Guest⏳	717A0D28DCFE56D9	10/05	approve; vouch; flag	+cart	4
SELECT file_hash, author_key AS author_id, author_key, author_seen, '' AS tagset_guest, '' AS cart, item_count FROM author_flat WHERE author_alias = 'Guest' AND author_score >= 0 ORDER BY author_seen DESC

PrintedInfo #

Q: When was this page printed? Printed: October 17 2024 21:01:05. Q: How old was the page when downloaded? Age: 4897 seconds pollyanna: Q: How can I get a fresher copy? A: Ask the server to Reprint

RESET

# x JavaScript

# x Concept

concept People_Page purpose display a list of verified participants in the community, indicating individuals with confirmed identities through a cryptographic web of trust. state   people_entities: set Person     author_alias: String  // Represents the alias or name of the verified participant     author_key_count: Integer  // Count of unique author keys associated with the participant     author_seen: Timestamp  // Timestamp of the last activity seen from the participant     author_score: Integer  // Combined item score of the participant     item_count: Integer  // Total count of items associated with the participant actions   None explicitly specified for the People Page. operational principle   Retrieve and display a list of verified participants in the community.   Participants are identified based on their presence in the "person_author" table, indicating that their identities have been confirmed through a cryptographic web of trust. where   Include participants with a non-empty author_alias, at least one associated author key, and a non-negative author score. Additional Considerations: - The People Page lists individuals who have been verified through a cryptographic web of trust, providing a higher level of confidence in their identities. - The state includes key details such as the participant's alias, the count of associated author keys, last seen timestamp, author score, and item count. - Criteria for inclusion involve a non-empty author_alias, at least one associated author key, and a non-negative author score.

# x PageMap

Welcome ; Write ; Threads ; New ; Image(1) ; Links ; Upload ; Calendar ; #HumanTalk ; #ToiletTalk ; Search ; Settings ; Stats ; Session ; Authors(20) ; People(1) ; Scores ; Labels(15) ; Data ; Chain(36) ; Help

Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset

CookieInfo #

You are signed in as Guest Cookie: none Alias: Guest Score: 0 Avatar: