✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for PeepSo Friends

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

1

Read peepso_friends

Pick it as the base. SleekView joins users twice — on user_id and friend_id — so each row carries both sides' email and display name.
2

Compose the audit columns

Add 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.
3

Save the queues

Pending-request queue for moderators, block-list audit for trust-and-safety, per-user history for support. Each view ships with its own capability gate and column set.
4

Bulk-update inline

Accept, decline, or remove connections across many rows in one pass. Writes route through PeepSo's friend model so notification hooks fire and friend counts stay consistent.

Sample columns

A typical PeepSo Friends audit view

Reads peepso_friends joined to users on both user_id and friend_id.
Source: 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.status updates 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 users on both sides
  • Filter by status for pending, accepted, or blocked subsets
  • Group by user_id for 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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