IP : 18.118.26.97Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
./
var/
softaculous/
ampache/
../
myadmin49/
./
../
lime3/
../
ocportal/
ocportal.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `[[dbprefix]]addons` --
CREATE TABLE `[[dbprefix]]addons` ( `addon_name` varchar(255) NOT NULL, `addon_author` varchar(255) NOT NULL, `addon_organisation` varchar(255) NOT NULL, `addon_version` varchar(255) NOT NULL, `addon_category` varchar(255) NOT NULL, `addon_copyright_attribution` varchar(255) NOT NULL, `addon_licence` varchar(255) NOT NULL, `addon_description` longtext NOT NULL, `addon_install_time` int(10) unsigned NOT NULL, PRIMARY KEY (`addon_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -- Dumping data for table `[[dbprefix]]addons` --
INSERT INTO `[[dbprefix]]addons` VALUES ('actionlog', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Audit-trail functionality.', [[timestamp]]), ('aggregate_types', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Define complex aggregate types in XML, and spawn them.', [[timestamp]]), ('apache_config_files', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Sample .htaccess files to help achieve optimal configuration on the Apache web server.', [[timestamp]]), ('authors', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Certain kinds of content can have authors instead of submitters (e.g. ''ocProducts''). The authors may be independently described and searched under.', [[timestamp]]), ('awards', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Pick out content for featuring.', [[timestamp]]), ('backup', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Perform incremental or full backups of files and the database. Supports scheduling.', [[timestamp]]), ('banners', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'An advanced banner system, with support for multiple banner rotations, commercial banner campaigns, and webring-style systems. Support for graphical, text, and flash banners. Hotword activation support.', [[timestamp]]), ('bookmarks', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Allow members to bookmark screens of the website. As the bookmarks are tied to their member profile they can access them from any computer they can log in on.', [[timestamp]]), ('breadcrumbs', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Advanced breadcrumb editing.', [[timestamp]]), ('calendar', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'An advanced community calendar.', [[timestamp]]), ('captcha', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Stop spam-bots from performing actions on the website.', [[timestamp]]), ('catalogues', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Describe your own custom data record types (by choosing and configuring fields) and populate with records. Supports tree structures, and most standard Composr features (e.g. ratings).', [[timestamp]]), ('chat', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Chatrooms and instant messaging.', [[timestamp]]), ('cns_avatars', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A selection of avatars for Conversr', [[timestamp]]), ('cns_cartoon_avatars', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A selection of avatars for Conversr (sketched characters)', [[timestamp]]), ('cns_clubs', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Clubs for members, each of which comes with a forum.', [[timestamp]]), ('cns_contact_member', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Off-site e-mailing of members (more private, and may be used by guests).', [[timestamp]]), ('cns_cpfs', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Custom profile fields, so members may save additional details. If this is uninstalled any existing custom profile fields will remain in the system.', [[timestamp]]), ('cns_forum', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The Conversr forum- a modern advanced forum for members to interact on.', [[timestamp]]), ('cns_member_avatars', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Member avatars.', [[timestamp]]), ('cns_member_photos', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Member photos.', [[timestamp]]), ('cns_member_titles', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Member titles.', [[timestamp]]), ('cns_multi_moderations', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Multi-moderations for the Conversr forum.', [[timestamp]]), ('cns_post_templates', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Post templates for the Conversr forum.', [[timestamp]]), ('cns_reported_posts', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Post reporting with the Conversr forum.', [[timestamp]]), ('cns_signatures', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Member signatures.', [[timestamp]]), ('cns_thematic_avatars', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A selection of avatars for Conversr', [[timestamp]]), ('cns_warnings', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Member warnings and punishment.', [[timestamp]]), ('code_editor', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'For programmers- A simple editor for editing Composr code files, with support for override support and saving via FTP.', [[timestamp]]), ('collaboration_zone', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Collaboration Zone.', [[timestamp]]), ('commandr', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A command-line environment for managing your website, designed for Linux/Unix lovers.', [[timestamp]]), ('content_privacy', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Allows users to specify privacy level for their content.', [[timestamp]]), ('content_reviews', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Regularly review content for accuracy.', [[timestamp]]), ('core', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', '(Core Composr code)', [[timestamp]]), ('core_abstract_components', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality.', [[timestamp]]), ('core_abstract_interfaces', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality.', [[timestamp]]), ('core_addon_management', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Install or uninstall addons.', [[timestamp]]), ('core_adminzone_dashboard', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The dashboard tools shown in the Admin Zone.', [[timestamp]]), ('core_cleanup_tools', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Behind-the-scenes maintenance tasks.', [[timestamp]]), ('core_cns', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The Composr member/usergroup system.', [[timestamp]]), ('core_comcode_pages', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Manage new pages on the website, known as Comcode pages.', [[timestamp]]), ('core_configuration', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Set configuration options.', [[timestamp]]), ('core_database_drivers', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The code layer that binds the software to one of various different kinds of database software.', [[timestamp]]), ('core_feedback_features', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Features for user interaction with content.', [[timestamp]]), ('core_fields', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', '(Core fields API)', [[timestamp]]), ('core_form_interfaces', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality for forms.', [[timestamp]]), ('core_forum_drivers', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The code layer that binds the software to one of various different forum/member systems.', [[timestamp]]), ('core_graphic_text', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality for imagery.', [[timestamp]]), ('core_html_abstractions', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality.', [[timestamp]]), ('core_language_editing', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Translate the software, or just change what it says for stylistic reasons.', [[timestamp]]), ('core_menus', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Edit menus.', [[timestamp]]), ('core_notifications', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Sends out action-triggered notifications to members listening to them.', [[timestamp]]), ('core_permission_management', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Manage permissions.', [[timestamp]]), ('core_primary_layout', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Core rendering functionality.', [[timestamp]]), ('core_rich_media', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Comcode and attachments.', [[timestamp]]), ('core_themeing', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Themeing the website, via CSS, HTML, and images.', [[timestamp]]), ('core_upgrader', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The upgrader code.', [[timestamp]]), ('core_webstandards', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Web Standards checking tools.', [[timestamp]]), ('core_zone_editor', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Manage zones (sub-sites).', [[timestamp]]), ('counting_blocks', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Blocks for hit counters, and count-downs.', [[timestamp]]), ('custom_comcode', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Create new Comcode tags.', [[timestamp]]), ('debrand', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Allow easy debranding of the website software.', [[timestamp]]), ('downloads', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Host a downloads directory.', [[timestamp]]), ('ecommerce', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'eCommerce infrastructure, with support for digital purchase and usergroup subscriptions. Accounting functionality.', [[timestamp]]), ('errorlog', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Log of errors that have happened on the website.', [[timestamp]]), ('failover', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Advanced system to detect if the site goes down, and provide an automatic fallback.', [[timestamp]]), ('filedump', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'File/media library, for use in attachments or for general ad-hoc sharing.', [[timestamp]]), ('forum_blocks', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Blocks to draw forum posts and topics into the main website.', [[timestamp]]), ('galleries', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Galleries, including support for video galleries, and member personal galleries.', [[timestamp]]), ('google_appengine', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Support for deploying to Google App Engine (for developers).', [[timestamp]]), ('help_page', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A simple website help page. Note that removing this will not remove the menu link automatically.', [[timestamp]]), ('hphp_buildkit', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Scripts for supporting Facebook''s HHVM.', [[timestamp]]), ('import', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Switch to Composr from other software. This addon provides the architecture for importing, and a number of prewritten importers.', [[timestamp]]), ('installer', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The installer files (can be removed immediately after installing; in fact Composr makes you remove install.php manually).', [[timestamp]]), ('language_block', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A block to allow visitors to choose their language.', [[timestamp]]), ('ldap', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Support for integrating Conversr with an LDAP server, so usergroup and members can be the same as those already on the network', [[timestamp]]), ('linux_helper_scripts', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Bash shell scripts to help configure permissions on Linux/Unix servers.', [[timestamp]]), ('match_key_permissions', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Match-key-permissions allow advanced setting of permissions on a screen-by-screen basis.', [[timestamp]]), ('msn', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Features to support multi-site-networks (networks of linked sites that usually share a common member system).', [[timestamp]]), ('news', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'News and blogging.', [[timestamp]]), ('news_shared', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', '(Common files needed for RSS and News addons)', [[timestamp]]), ('newsletter', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Support for users to join newsletters, and for the staff to send out newsletters to subscribers, and to specific usergroups.', [[timestamp]]), ('page_management', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Manage pages on the website.', [[timestamp]]), ('phpinfo', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Access PHP configurational information from inside Composr.', [[timestamp]]), ('points', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Allow members to accumulate points via a number of configurable activities, as well as exchange points with each other. Points act as a ranking system as well as a virtual currency.', [[timestamp]]), ('pointstore', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Provide a number of virtual products to your members in exchange for the points they have accumulated by their activity', [[timestamp]]), ('polls', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A poll (voting) system.', [[timestamp]]), ('printer_friendly_block', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A block to provide a link for the current screen to be turned into it''s printer-friendly equivalent.', [[timestamp]]), ('quizzes', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Construct competitions, surveys, and tests, for members to perform. Highly configurable, and comes with administrative tools to handle the results.', [[timestamp]]), ('random_quotes', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A block to display random quotes on your website, and an administrative tool to choose them.', [[timestamp]]), ('realtime_rain', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Real-time/historic display of website activity.', [[timestamp]]), ('recommend', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Allow members to easily recommend the website to others.', [[timestamp]]), ('redirects_editor', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Manage redirects between pages.', [[timestamp]]), ('rootkit_detector', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A tool to help power-user webmasters identify if a "rootkit" has been placed on the server.', [[timestamp]]), ('search', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Multi-content search engine.', [[timestamp]]), ('securitylogging', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Log/display security alerts.', [[timestamp]]), ('setupwizard', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Quick-start setup wizard.', [[timestamp]]), ('shopping', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Online store functionality.', [[timestamp]]), ('sms', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Provides an option for the software to send SMS messages, via the commercial Clickatell web service. By default this is only used by the notifications system.', [[timestamp]]), ('ssl', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Choose which pages of your website run over HTTPS (SSL). Requires an SSL certificate to be installed on the webserver, and a dedicated IP address.', [[timestamp]]), ('staff', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Choose and display a selection of staff from the super-administator/super-moderator usergroups. This is useful for multi-site networks, where members with privileges may not be considered staff on all websites on the network.', [[timestamp]]), ('staff_messaging', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Blocks to allow visitors to contact the staff, either via e-mail, or via a special administrative interface which the staff may use to comment on the messages and assign task ownership.', [[timestamp]]), ('stats', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Show advanced graphs (analytics) and dumps of raw data relating to your website activity.', [[timestamp]]), ('stats_block', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A block to show a selection of your website statistics to your visitors.', [[timestamp]]), ('supermember_directory', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Show a list of all members in the configured "Super member" usergroup. Useful for communities that need to provide a list of VIPs.', [[timestamp]]), ('syndication', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Syndicate RSS/Atom feeds of your content.', [[timestamp]]), ('syndication_blocks', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Show RSS and Atom feeds from other websites.', [[timestamp]]), ('textbased_persistent_caching', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A persistent data cache, using disk files for data storage.', [[timestamp]]), ('themewizard', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Automatically generate your own colour schemes using the default theme as a base. Uses the sophisticated chromagraphic equations built into Composr.', [[timestamp]]), ('tickets', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A support ticket system.', [[timestamp]]), ('uninstaller', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'The uninstaller.', [[timestamp]]), ('unvalidated', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Subject member''s to validation (approval) of their content submissions, and enable/disable content.', [[timestamp]]), ('users_online_block', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A block to show which users who are currently visiting the website, and birthdays.', [[timestamp]]), ('welcome_emails', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Welcome e-mails for new members.', [[timestamp]]), ('wiki', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Collaborative/encyclopaedic database interface. A wiki-like community database with rich media capabilities.', [[timestamp]]), ('windows_helper_scripts', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'A .bat script to help configure permissions on Windows servers.', [[timestamp]]), ('wordfilter', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Block rude/offensive/inappropriate words.', [[timestamp]]), ('xml_fields', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Advanced form field filtering.', [[timestamp]]), ('zone_logos', 'Core Team', 'ocProducts', '10', 'Uncategorised/Alpha', '', '(Unstated)', 'Support for having different logos for individual zones.', [[timestamp]]);
-- -- Table structure for table `[[dbprefix]]award_types` --
CREATE TABLE `[[dbprefix]]award_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `a_title` longtext NOT NULL, `a_description` longtext NOT NULL, `a_points` int(11) NOT NULL, `a_content_type` varchar(80) NOT NULL, `a_hide_awardee` tinyint(1) NOT NULL, `a_update_time_hours` int(11) NOT NULL, `a_description__text_parsed` longtext NOT NULL, `a_description__source_user` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), FULLTEXT KEY `a_title` (`a_title`), FULLTEXT KEY `a_description` (`a_description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]award_types` --
INSERT INTO `[[dbprefix]]award_types` VALUES (1, 'Download of the week', 'The best downloads in the download system, chosen every week.', 0, 'download', 1, 168, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:39:\\"string_attach_66c43f541e1c92.70889105_1\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:39:\\"string_attach_66c43f541e1c92.70889105_1\\";s:129:\\"\\$tpl_funcs[''string_attach_66c43f541e1c92.70889105_1'']=\\"echo \\\\\\"The best downloads in the download system, chosen every week.\\\\\\";\\";\\n\\";}}");\n', 1);
-- -- Table structure for table `[[dbprefix]]banners` --
CREATE TABLE `[[dbprefix]]banners` ( `name` varchar(80) NOT NULL, `expiry_date` int(10) unsigned DEFAULT NULL, `submitter` int(11) NOT NULL, `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `the_type` tinyint(4) NOT NULL, `b_title_text` varchar(255) NOT NULL, `caption` longtext NOT NULL, `b_direct_code` longtext NOT NULL, `campaign_remaining` int(11) NOT NULL, `site_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `hits_from` int(11) NOT NULL, `views_from` int(11) NOT NULL, `hits_to` int(11) NOT NULL, `views_to` int(11) NOT NULL, `importance_modulus` int(11) NOT NULL, `notes` longtext NOT NULL, `validated` tinyint(1) NOT NULL, `add_date` int(10) unsigned NOT NULL, `edit_date` int(10) unsigned DEFAULT NULL, `b_type` varchar(80) NOT NULL, `caption__text_parsed` longtext NOT NULL, `caption__source_user` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`name`), KEY `banner_child_find` (`b_type`), KEY `the_type` (`the_type`), KEY `expiry_date` (`expiry_date`), KEY `badd_date` (`add_date`), KEY `topsites` (`hits_from`,`hits_to`), KEY `campaign_remaining` (`campaign_remaining`), KEY `bvalidated` (`validated`), FULLTEXT KEY `caption` (`caption`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- -- Dumping data for table `[[dbprefix]]banners` --
INSERT INTO `[[dbprefix]]banners` VALUES ('advertise_here', NULL, 1, 'data/images/advertise_here.png', 2, '', 'Advertise here!', '', 0, '[[softurl]]/index.php?page=advertise', 0, 0, 0, 0, 10, 'Provided as a default. This is a fallback banner (it shows when others are not available).', 1, [[timestamp]], NULL, '', 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:39:\\"string_attach_66c43f5b9d7c66.54529300_1\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:39:\\"string_attach_66c43f5b9d7c66.54529300_1\\";s:83:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_1'']=\\"echo \\\\\\"Advertise here!\\\\\\";\\";\\n\\";}}");\n', 1), ('donate', NULL, 1, 'data/images/donate.png', 0, '', 'Please donate to keep this site alive', '', 0, '[[softurl]]/index.php?page=donate', 0, 0, 0, 0, 30, 'Provided as a default.', 1, [[timestamp]], NULL, '', 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:39:\\"string_attach_66c43f5b9d7c66.54529300_2\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:39:\\"string_attach_66c43f5b9d7c66.54529300_2\\";s:105:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_2'']=\\"echo \\\\\\"Please donate to keep this site alive\\\\\\";\\";\\n\\";}}");\n', 1);
-- -- Table structure for table `[[dbprefix]]catalogue_categories` --
CREATE TABLE `[[dbprefix]]catalogue_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `c_name` varchar(80) NOT NULL, `cc_title` longtext NOT NULL, `cc_description` longtext NOT NULL, `rep_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `cc_notes` longtext NOT NULL, `cc_add_date` int(10) unsigned NOT NULL, `cc_parent_id` int(11) DEFAULT NULL, `cc_move_target` int(11) DEFAULT NULL, `cc_move_days_lower` int(11) NOT NULL, `cc_move_days_higher` int(11) NOT NULL, `cc_order` int(11) NOT NULL, `cc_description__text_parsed` longtext NOT NULL, `cc_description__source_user` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `catstoclean` (`cc_move_target`), KEY `cataloguefind` (`c_name`), KEY `cc_parent_id` (`cc_parent_id`), KEY `ftjoin_cctitle` (`cc_title`(250)), KEY `ftjoin_ccdescrip` (`cc_description`(250)), KEY `cc_order` (`cc_order`), FULLTEXT KEY `cc_title` (`cc_title`), FULLTEXT KEY `cc_description` (`cc_description`), FULLTEXT KEY `cat_cat_search__combined` (`cc_title`,`cc_description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=6 ;
-- -- Dumping data for table `[[dbprefix]]catalogue_categories` --
INSERT INTO `[[dbprefix]]catalogue_categories` VALUES (1, 'projects', 'Super-member projects', 'These are projects listed by super-members, designed to: advertise project existence, detail current progress, and solicit help.', '', '', [[timestamp]], NULL, NULL, 30, 60, 0, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:40:\\"string_attach_66c43f5b9d7c66.54529300_12\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:40:\\"string_attach_66c43f5b9d7c66.54529300_12\\";s:197:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_12'']=\\"echo \\\\\\"These are projects listed by super-members, designed to: advertise project existence, detail current progress, and solicit help.\\\\\\";\\";\\n\\";}}");\n', 1), (2, 'links', 'Links home', '', '', '', [[timestamp]], NULL, NULL, 30, 60, 0, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:40:\\"string_attach_66c43f5b9d7c66.54529300_14\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:40:\\"string_attach_66c43f5b9d7c66.54529300_14\\";s:69:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_14'']=\\"echo \\\\\\"\\\\\\";\\";\\n\\";}}");\n', 1), (3, 'faqs', 'Frequently Asked Questions', 'If you have questions that are not covered in our FAQ, please post them in an appropriate forum.', '', '', [[timestamp]], NULL, NULL, 30, 60, 0, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:40:\\"string_attach_66c43f5b9d7c66.54529300_16\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:40:\\"string_attach_66c43f5b9d7c66.54529300_16\\";s:165:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_16'']=\\"echo \\\\\\"If you have questions that are not covered in our FAQ, please post them in an appropriate forum.\\\\\\";\\";\\n\\";}}");\n', 1), (4, 'contacts', 'Contacts', '', '', '', [[timestamp]], NULL, NULL, 30, 60, 0, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:40:\\"string_attach_66c43f5b9d7c66.54529300_18\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:40:\\"string_attach_66c43f5b9d7c66.54529300_18\\";s:69:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_18'']=\\"echo \\\\\\"\\\\\\";\\";\\n\\";}}");\n', 1), (5, 'products', 'Products home', '', '', '', [[timestamp]], NULL, NULL, 30, 60, 0, 'return unserialize("a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:40:\\"string_attach_66c43f5b9d7c66.54529300_20\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:40:\\"string_attach_66c43f5b9d7c66.54529300_20\\";s:69:\\"\\$tpl_funcs[''string_attach_66c43f5b9d7c66.54529300_20'']=\\"echo \\\\\\"\\\\\\";\\";\\n\\";}}");\n', 1);
-- -- Dumping data for table `[[dbprefix]]f_posts` --
INSERT INTO `[[dbprefix]]f_posts` VALUES (1, 'Welcome to the forums', 'This is the inbuilt forum system (known as Conversr).\n\nA forum system is a tool for communication between members; it consists of posts, organised into topics: each topic is a line of conversation.\n\nComposr provides support for a number of different forum systems, and each forum handles authentication of members: Conversr is the built-in forum, which provides seamless integration between the main website, the forums, and the inbuilt member accounts system.', '127.0.0.1', [[timestamp]], 1, NULL, 'System', 1, 1, 6, NULL, NULL, 0, 0, NULL, 'return unserialize("a:5:{i:0;a:1:{i:0;a:7:{i:0;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_1\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:1;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_2\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:2;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_3\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:3;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_4\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:4;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_5\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:5;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_6\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}i:6;a:5:{i:0;s:39:\\"string_attach_66c43f4c85f9d3.63177312_7\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:7:\\"(mixed)\\";i:3;N;i:4;a:7:{s:39:\\"string_attach_66c43f4c85f9d3.63177312_1\\";s:121:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_1'']=\\"echo \\\\\\"This is the inbuilt forum system (known as Conversr).\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_2\\";s:74:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_2'']=\\"echo \\\\\\"<br />\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_3\\";s:74:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_3'']=\\"echo \\\\\\"<br />\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_4\\";s:210:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_4'']=\\"echo \\\\\\"A forum system is a tool for communication between members; it consists of posts, organised into topics: each topic is a line of conversation.\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_5\\";s:74:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_5'']=\\"echo \\\\\\"<br />\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_6\\";s:74:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_6'']=\\"echo \\\\\\"<br />\\\\\\";\\";\\n\\";s:39:\\"string_attach_66c43f4c85f9d3.63177312_7\\";s:329:\\"\\$tpl_funcs[''string_attach_66c43f4c85f9d3.63177312_7'']=\\"echo \\\\\\"Composr provides support for a number of different forum systems, and each forum handles authentication of members: Conversr is the built-in forum, which provides seamless integration between the main website, the forums, and the inbuilt member accounts system.\\\\\\";\\";\\n\\";}}");\n', 1);
-- -- Table structure for table `[[dbprefix]]transactions` --
CREATE TABLE `[[dbprefix]]transactions` ( `id` varchar(80) NOT NULL, `t_type_code` varchar(80) NOT NULL, `t_purchase_id` varchar(80) NOT NULL, `t_status` varchar(255) NOT NULL, `t_reason` varchar(255) NOT NULL, `t_amount` varchar(255) NOT NULL, `t_currency` varchar(80) NOT NULL, `t_parent_txn_id` varchar(80) NOT NULL, `t_time` int(10) unsigned NOT NULL, `t_pending_reason` varchar(255) NOT NULL, `t_memo` longtext NOT NULL, `t_via` varchar(80) NOT NULL, PRIMARY KEY (`id`,`t_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- -- Table structure for table `[[dbprefix]]url_title_cache` --
CREATE TABLE `[[dbprefix]]url_title_cache` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `t_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `t_title` varchar(255) NOT NULL, `t_meta_title` longtext NOT NULL, `t_keywords` longtext NOT NULL, `t_description` longtext NOT NULL, `t_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `t_mime_type` varchar(80) NOT NULL, `t_json_discovery` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `t_xml_discovery` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY KEY (`id`), KEY `t_url` (`t_url`(250)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;