SleekView for PeepSo Friends: connections & requests as tables
Read directly from peepso_friends for a flat connection table across the whole community. Filter by status, sort by request date, and audit who is connecting to whom in one workspace.
♾️ Lifetime License available
Friendship audit, not a profile-by-profile search
PeepSo Friends adds a friend-graph layer to the PeepSo community plugin, storing each connection as a row in peepso_friends with user_id, friend_id, status (pending, accepted, blocked), and a created timestamp. Friend requests, accepted connections, and blocks all live in the same table with the status flag deciding which is which. The default PeepSo admin shows connections per profile but doesn't expose a cross-community queue for pending requests or a flat audit of who is blocking whom.
SleekView reads peepso_friends directly, joins users on both user_id and friend_id to surface both members' emails, and pivots the result into a flat connection table. Filter by status, sort by request date to clear stale pending requests, or group by user to spot accounts with unusually high outbound friend requests as a spam signal.
Inline edits route through PeepSo's friend model where exposed, so accepting or declining a request fires the standard notification hooks and updates cached friend counts. Direct table writes with conflict detection handle migrations, with the dual join making sure both sides of the connection stay in sync.
Workflow
Build the PeepSo Friends audit workspace
Read peepso_friends
users twice — on user_id and friend_id — so each row carries both sides' email and display name.
Compose the audit columns
status, created_at, accepted_at, and mutual-friend counts as columns. Status renders as a dropdown filter so pending, accepted, and blocked subsets reload instantly.
Save the queues
Bulk-update inline
Sample columns
A typical PeepSo Friends audit view
peepso_friends joined to users on both user_id and friend_id.
wp_peepso_friends + wp_users
| Requester | Recipient | Status | Requested | Accepted | Mutual |
|---|---|---|---|---|---|
| alex@studio.co | ria@design.io | Accepted | Mar 12 | Mar 12 | 12 |
| tom@hello.dev | mia@brew.coop | Pending | Apr 24 | — | 3 |
| anonymous | alex@studio.co | Blocked | Apr 22 | — | 0 |
| ria@design.io | tom@hello.dev | Accepted | Feb 03 | Feb 03 | 8 |
Comparison
Default PeepSo Friends admin vs SleekView
Default PeepSo Friends admin
- Friendships shown per profile only — no cross-community queue
-
peepso_friends.statusupdates happen per row, per user - Pending-request volume per account isn't a built-in report
- Spam-pattern detection across unusually high request counts needs SQL
- Block lists aren't audit-friendly in the default admin
SleekView
-
Cross-community friendship table joined to
userson both sides -
Filter by
statusfor pending, accepted, or blocked subsets -
Group by
user_idfor per-account outbound request leaderboards - Bulk-accept, decline, or remove connections inline
- Save views per role (moderator, trust-and-safety)
Features
What SleekView gives you for PeepSo Friends
Dual user join
peepso_friends joins to users twice — once on user_id for the requester and once on friend_id for the recipient. Each row shows both sides with email and display name.
Status-based saved views
Filter by status for pending-request queues, accepted-connection audits, or block lists. Save each as a named view per role and reload with the right columns every time.
Spam-pattern leaderboards
Group rows by user_id to count outbound requests per account. Accounts with unusually high request volume surface immediately for moderator review.
Audience
Who uses SleekView for PeepSo Friends
Moderators
Pending-request queue across the whole community sorted by recency, with mutual-friend count visible inline. Bulk-clear backlogs and decline obvious spam in one pass.
Trust-and-safety
Block-list audit and outbound-request leaderboards for spam-pattern detection. Filter to accounts with high outbound request volume and low acceptance rate.
Support
Per-user friendship history during complaint triage. Filter by either user_id or friend_id to see every connection a member has, including blocks and pending requests.
The bigger picture
Why friend-graph moderation needs flat audits
Social networks live and die on the quality of their friend graph. PeepSo Friends keeps the data simple because peepso_friends is a single edge table with status flags covering pending, accepted, and blocked connections. That makes everything queryable in principle.
The default admin only exposes it per profile, which is the wrong shape for cross-community moderation. A moderator wants the pending-request queue across every account so backlogs can be cleared in one pass. A trust-and-safety analyst wants the outbound-request leaderboard so high-volume requesters can be reviewed for spam-pattern signals.
A support agent triaging a complaint wants every connection a member has in one screen, including the blocks. SleekView's job is to compose those views directly against the same table PeepSo maintains, with writes routing through the friend model so notification hooks fire when they should. Same data, fewer screens, dramatically less profile-by-profile clicking for the people who run safety operations on live communities.
Questions
Common questions about SleekView for PeepSo Friends
peepso_friends has two foreign keys (user_id, friend_id) that both reference users. SleekView joins to users twice with different aliases so each row carries both sides' email and display name. Filters work against either side independently.
Yes. Filter to status = pending, select all matching rows, and set the status in one pass. Writes route through PeepSo's friend model where exposed so notification hooks fire on each change.
Group rows by user_id to count outbound requests per account. Combine with low acceptance rate or recent created_at to surface accounts pushing high volume of requests, which is a useful spam signal.
Yes. Filter by either user_id or friend_id for that member to see every connection, request, and block they're involved in. The same view reloads with each support ticket.
peepso_friends indexes on both user_id and friend_id so per-account lookups stay fast even on networks with millions of edges. SleekView pages results server-side and avoids loading the full table client-side.
Yes, indirectly. Both tables key off user_id so cross-feature views can show a member's friends and their group memberships in adjacent panes. Common during trust-and-safety triage on a flagged account.
When writes route through PeepSo's friend model the plugin's notification logic fires for accept and decline actions. Direct DB writes are an explicit opt-in and skip notifications by design, useful for silent back-fills.
 PeepSo participates in the WordPress personal-data exporter and SleekView doesn't change that. Use a per-user view to preview what the export will contain, then run the standard WP exporter to ship the data.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Yith Woocommerce Ajax Product Filter
- Charitable
- Woocommerce Conditional Discounts
- Mollie Payments
- Product Vendors Marketplace
- Woocommerce Wholesale Lead Capture
- Linnworks Wp
- Surecart Affiliates
- Restropress
- Woocommerce Zoho Books
- Woocommerce Cart Abandonment Recovery
- Woocommerce Dokan Pro
- Woocommerce Pricing Deals
- Woocommerce Xero Pro
- Woocommerce Side Cart