SleekView for Asgaros Forum: forums, threads & posts as tables
Read directly from asgarosforum_forums, asgarosforum_threads, and asgarosforum_posts. Pivot the lean Asgaros schema into a cross-forum moderation table with status, view count, and author visible inline.
♾️ Lifetime License available
A real table for a lean forum schema
Asgaros Forum ships a deliberately compact schema. Forums live in asgarosforum_forums, threads in asgarosforum_threads, and posts in asgarosforum_posts, with status flags for closed, sticky, and approved on threads, and an approved column on posts for moderation workflows. The default Asgaros admin is intentionally minimal, which is part of the plugin's appeal, but on busy boards moderators end up wanting more columns than the lean default screens provide.
SleekView reads asgarosforum_threads directly, joins asgarosforum_forums for the board name and users for the author email, and pivots the result into a flat thread table. Filter by status, sort by view count, group by author for leaderboards, and bulk-flip closed, sticky, or approved across many rows.
Inline edits route through Asgaros' own update methods where exposed so the cascade logic keeps parent forum last-activity accurate. Direct table writes with conflict detection handle bulk back-fills, with the lean Asgaros schema making column mapping straightforward and unambiguous.
Workflow
Pivot the Asgaros schema into a real moderation table
Read asgarosforum_threads
asgarosforum_forums for the board name and users for the author email so each row reads as a real moderation record.
Compose the moderation columns
closed, sticky, approved, views, and last_post_date as columns. Status flags render as filters with dropdown inputs.
Save per-forum views
Bulk-update inline
closed, sticky, or approved across many rows in one pass. Writes go through Asgaros' update methods so the cascade keeps last-activity timestamps accurate.
Sample columns
A typical Asgaros Forum threads view
asgarosforum_threads joined to asgarosforum_forums and users.
wp_asgarosforum_forums + wp_asgarosforum_threads + wp_asgarosforum_posts + wp_users
| Thread | Forum | Author | Views | Status | Last post |
|---|---|---|---|---|---|
| Welcome to the community | Announcements | alex@studio.co | 2,104 | Sticky | Apr 24 |
| Spam: free trial | General | anonymous | 11 | Unapproved | Apr 24 |
| Plugin compatibility | Support | ria@design.io | 318 | Open | Apr 23 |
| Archived: old roadmap | Discussion | tom@hello.dev | 742 | Closed | Mar 12 |
Comparison
Default Asgaros Forum admin vs SleekView
Default Asgaros Forum admin
- Default moderation screens are deliberately minimal — limited columns
-
asgarosforum_threads.closedandstickyflips happen per row -
asgarosforum_posts.approvedqueue isn't a cross-forum flat view -
Per-author leaderboards need custom SQL against
asgarosforum_posts - Cross-forum thread audits require code
SleekView
-
Cross-forum thread table joined across
asgarosforum_threads,asgarosforum_forums,users -
Filter by
closed,sticky,approved, and last-post date together -
Bulk-flip
closed,sticky, andapprovedinline -
Group
asgarosforum_postsbyauthor_idfor per-author counts - Save views per role (sub-forum moderator, super-moderator)
Features
What SleekView gives you for Asgaros Forum Pro
Flat thread workspace
Threads from every forum pivot into one table with parent forum, author, view count, and status inline. The lean default admin gets the columns busy boards actually use.
Bulk approval queue
Filter asgarosforum_posts.approved to the unapproved value for a cross-forum approval queue. Bulk-approve, mark as spam, or delete in one pass with Asgaros' hooks firing through the model path.
Per-author leaderboards
Group asgarosforum_posts by author_id for post-count and reply-count leaderboards. Recognise top contributors or surface accounts to investigate for spam patterns.
Audience
Who uses SleekView for Asgaros Forum Pro
Super-moderators
Cross-forum thread queue with status, view count, and author visible. Bulk-handle stickies, closures, and approval queues with a saved view per shift.
Sub-forum moderators
Capability-gated views scoped to specific forums via parent_id filter. Each sub-moderator reloads the same view template with their own forum scope applied.
Audit reviewers
Per-author timelines and post-count audits across asgarosforum_posts. Useful for trust-and-safety reviews and contributor recognition cycles.
The bigger picture
Why lean forum schemas still need a workspace
Asgaros' compact schema is part of its appeal because the plugin stays fast and easy to administer at small to medium scale. The same compactness becomes a constraint once a community grows past the size the default screens were designed for. Super-moderators want a cross-forum thread queue with all the status flags visible.
Sub-forum moderators want the same view template scoped to their boards. Approval reviewers want a flat list of every unapproved post across every forum. Each of those is one query against the existing tables, but the lean default admin doesn't compose them and adding bespoke admin screens to a deliberately minimal plugin defeats the purpose.
SleekView's job is to be the workspace layer Asgaros leaves to specialised tools, pivoting the schema into the views moderation teams actually need with writes routing through the plugin's own methods so its cascade logic keeps the data consistent. Same database, fewer screens, dramatically more throughput for busy boards.
Questions
Common questions about SleekView for Asgaros Forum Pro
Yes — Asgaros uses dedicated tables (asgarosforum_forums, asgarosforum_threads, asgarosforum_posts) rather than the WP post-type pattern. SleekView reads them directly and pivots the schema into proper named columns for moderation workflows.
Yes. Status flags like closed, sticky, and approved flip inline through Asgaros' own update methods where exposed, so cascade logic stays consistent. Direct DB writes are available with conflict detection for back-fills.
Yes. Filter asgarosforum_posts.approved for the unapproved subset across every forum. Bulk-approve, reject, or delete in one pass with Asgaros' hooks firing through the model path.
Yes. Filter asgarosforum_threads.parent_id to a single forum or a set of forums a moderator owns, and save it as a named view. Capability gating attaches per saved view for role-based scoping.
Yes. Group asgarosforum_posts by author_id with count aggregation. Filter by date range for activity audits or contributor recognition.
Asgaros' tables index on parent_id, author_id, and date columns so the common moderation paths stay fast. SleekView pages results server-side and avoids loading the full table client-side.
Add-ons that extend the same tables work automatically because SleekView reads the live schema. Add-ons that ship their own custom tables can be mapped explicitly and joined into the workspace.
 
Yes. Both asgarosforum_threads.author_id and asgarosforum_posts.author_id reference users so each row shows the user's email and display name without extra setup.
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
- Woocommerce Pdf Product Vouchers
- Mvx Marketplace
- Woocommerce Truste Checkout
- Woocommerce Zip Pay
- Woocommerce Mailchimp Discount
- Sprout Invoices
- Woocommerce Gift Registry
- Woocommerce Prices By User Role
- Woocommerce Multistore
- Woocommerce Eu Vat Assistant
- Edd Reviews
- Woocommerce Colissimo
- Woocommerce Quickbooks Sync
- Woocommerce Product Comparison
- Woocommerce Print Invoices
- Theme My Login
- Ultimatemember Private Content
- Indeed Ultimate Member
- Profile Builder
- Wp Affiliate Platform
- Memberium For Activecampaign
- Wishlist Member X
- Ultimatemember Real Time Notifications
- Memberpress Developer
- Ultimatemember Social
- Easy Affiliate
- Paid Memberships Pro Addons
- User Meta Pro
- S2member
- Membership By Supsystic