Data Tables lets administrators create stand-alone, fully customizable data tables within XenForo, no code required. Define your own columns, set up dropdown lookups, and manage structured data right from the AdminCP, with clean public-facing display pages wrapped in your forum's theme.

Perfect for product catalogs, game databases, team rosters, pricing tables, inventory lists, or any structured data that doesn't fit neatly into forum threads.

---

Key Features​

• Dynamic Table Definitions, Create unlimited tables, each with its own title, URL slug, description, and display order. Toggle tables active/inactive without deleting data.
• 7 Field Types, Build columns using: Text, Number, URL, Date, Lookup (dropdown), Text Area, and Yes/No (boolean). Each field supports sortable and filterable flags.
• Lookup Columns (Relational Dropdowns), Define dropdown options for any field. Options are stored relationally (not as flat strings), enabling clean data entry and consistent display.
• Admin Record Management, Full CRUD for records within the AdminCP. Dynamic forms automatically adapt to your field definitions, text fields become text inputs, lookups become dropdowns, numbers get spinners, booleans get checkboxes.
• Public Table Display, Clean, responsive public pages at /data-tables/ showing all active tables, with individual table views at /data-tables/{slug}/. Full theme integration.
• Column Sorting,Mark fields as "sortable" in the admin, and users can click column headers on the public table view to sort ascending/descending.
• Public Record Submission, Optionally allow members to submit new records from the public side (permission-controlled).
• Permission-Controlled Access, Two permissions out of the box:
  • View data tables (default: Allow for all)
  • Add records (default: No)
• Pagination, Both admin and public views paginate at 50 records per page.
• Clean Uninstall, All 4 database tables are dropped on uninstall. No leftover data.

---

How It Works​

1. Create a Definition, Go to AdminCP > Tools > Data Tables > Add Definition. Give it a title (e.g., "Product Catalog") and a URL slug (e.g., "products").
2. Add Fields, Click "Fields" to define your columns. For example:
   • Name (Text, Required, Sortable)
   • Category (Lookup, with options like "Electronics", "Clothing", "Home")
   • Price (Number, Sortable)
   • In Stock (Yes/No)
   • Website (URL)
3. Add Records, Click "Records" to start entering data. The form automatically generates the right input type for each field.
4. View Publicly, Visit /data-tables/products/ to see your table with sortable columns, resolved lookup values, and clean formatting.

---

Technical Details​

• Architecture:Hybrid JSON + normalized lookups across 4 database tables
  • xf_qubn_dt_definition, table definitions
  • xf_qubn_dt_field, column definitions per table
  • xf_qubn_dt_lookup_option, dropdown options for lookup fields
  • xf_qubn_dt_record, data rows (JSON blob per record)
• Performance: Lookup values resolved in a single batch query. Composite indexes on frequently-queried columns. Paginated to 50 records per page.
• Compatibility: XenForo 2.3.x. No class extensions, completely self-contained with zero conflicts.
• Code Quality: PHPStan level 3 clean. Follows XenForo conventions throughout. All user input filtered. CSRF protection on all forms.

---

Installation​

1. Download and extract the ZIP file
2. Upload the Qubn/DataTables/ folder to src/addons/
3. Go to AdminCP > Add-ons > Install from archive (or Install/upgrade)
4. Navigate to AdminCP > Tools > Data Tables to start creating tables

---

Addon ID: Qubn/DataTables
Vendor: Qubn
License: Free / Open Source

Télécharger V1.0.0 :

Data Tables v1.1.0 - Cross-Table Relational Lookups & Inline Record Creation​

v1.1.0 adds cross-table relational lookups and inline record creation via overlay.

---

New Features​

• Cross-table relational lookups - a new "Table Lookup" field type lets you reference records from another table. Select a linked table and choose which field to display as the label. Users pick from existing records via dropdown, and values render as clickable links to the referenced record's detail page.
• Inline "Create New" overlay - a "+" button appears next to every Table Lookup dropdown. Click it and a modal opens with the linked table's record form. Fill it out, save, and the new record is automatically selected in the parent dropdown - no page reload, no navigating away. Works in both AdminCP and public pages (permission-gated).
• Record detail pages - every record now has its own page at /data-tables/{slug}/view-record?record_id=N showing all fields in a clean layout. A "Referenced by" section at the bottom lists records from other tables that point to this one - giving you automatic reverse navigation between related data.
• Clickable cross-links - Table Lookup values display as clickable links in both admin and public table views. Click a manufacturer name in a products table and jump straight to that manufacturer's detail page.
• Clickable URL fields - URL-type field values now render as clickable links (safe protocols only - http/https).
• AJAX field configuration - when editing fields in the AdminCP, selecting "Table Lookup" as the field type dynamically loads linked table and display field dropdowns via AJAX - no page reload needed.
• Reference tracking - denormalized xf_qubn_dt_record_ref table for fast reverse lookups between tables.
• 17 new phrases for relational lookup and overlay UI.

Changed​

• Cell output restructured to support clickable cells in both admin and public views.
• Setup.php refactored to use getTables() helper (prevents install/uninstall drift).
• URL field values validated for safe protocols.

Fixed​

• Definition deletion now cleans up orphaned linked_definition_id references in other tables' fields

Upgrading​

Upload the ZIP via Admin CP > Add-ons > Install/upgrade from archive. Two upgrade steps run automatically to add the new xf_qubn_dt_record_ref table and linked_definition_id / display_field_key columns to the field table. All existing data is preserved. Database tables: 5 (was 4). No class extensions - zero conflict risk.

Télécharger V1.1.0 :