Add-ons [vbresults.com] Searchable Custom Pages 1.1.8

Summary

This add-on allows you to make custom pages searchable by using a custom database table that is shared by XenForo and your in-house system. Built to work alongside Custom PHP Pages, but can work without it.

MySQL database administration knowledge is required.

Custom table:



Search term:


Custom table schema (Note: you can set any schema you want using the settings):
CREATE TABLE `pages` (
`page_id` smallint(4) NOT NULL,
`page_type` varchar(25) NOT NULL,
`target` varchar(200) NOT NULL,
`title` varchar(200) DEFAULT NULL,
`description` varchar(300) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`created` timestamp NOT NULL DEFAULT current_timestamp(),
`updated` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `page_type`, `target`, `title`, `description`, `active`, `created`, `updated`) VALUES
(1, 'products', '/products/1', 'Product 1', 'Text for Product 1 search result.', 1, '2025-06-05 00:00:00', '2025-06-05 07:19:21');



Source table columns:
[category]
key=page_type
[page]
page_id=page_id
title=title
description=description
pathname=target
active=active
page_date=created
last_update=updated

Inflection map (if you have more than one page type, you can define them here):
[plural]

products=Products

[singular]

products=Product



Search result: