-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2010 at 01:51 PM -- Server version: 5.1.40 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 */; -- -- Database: `bmcforu_transfer` -- -- -------------------------------------------------------- -- -- Table structure for table `local_linksadmin` -- CREATE TABLE IF NOT EXISTS `local_linksadmin` ( `adminid` smallint(5) NOT NULL AUTO_INCREMENT, `settingname` varchar(255) NOT NULL DEFAULT '', `setting` text NOT NULL, `description` text NOT NULL, `sequence` smallint(5) NOT NULL DEFAULT '0', PRIMARY KEY (`adminid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ; -- -- Dumping data for table `local_linksadmin` -- INSERT INTO `local_linksadmin` (`adminid`, `settingname`, `setting`, `description`, `sequence`) VALUES (1, 'this_version', '2.1.0', 'Do not change unless you know what you are doing!!!', 201), (2, 'can_add_link', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', 'Usergroups that can add new links.', 111), (3, 'can_edit_link', '5,6,7,16,17,18,19,26,22,38,40', 'Usergroups that can edit existing links. (Users can always edit their own links.)', 112), (4, 'can_delete_link', '5,6,38,40', 'Usergroups that can delete links.', 113), (5, 'can_add_category', '6', 'Usergroups that can add new categories.', 121), (6, 'can_edit_category', '6', 'Usergroups that can edit existing categories.', 122), (7, 'can_delete_category', '6', 'Usergroups that can delete categories.', 123), (8, 'can_view_hits', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', 'Usergroups that can view numbers of "hits" and names of who submitted entry.', 131), (9, 'can_set_permissions', '6', 'Usergroups that can set these permissions, i.e. administer.', 133), (10, 'can_rate_link', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', 'Usergroups that can rate links.', 114), (11, 'can_moderate_links', '6', 'Usergroups that can moderate links and add new links without moderation.', 134), (12, 'can_set_display_order', '6', 'Usergroups that can override the display order of links.', 124), (13, 'can_see_protected_links_on_portal', '6', 'Usergroups that can see links regardless of whether they can then access them', 135), (14, 'can_bypass_hit_recording', '-1', 'Downloads from selected usergroups are not recorded (useful if bots are tracking your site)', 136), (15, 'can_mark_link', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', 'Usergroups that can mark links as "My Favourites"', 115), (16, 'allow_html', '0', 'Html in links/category entries. 0: ignore, 1: allow', 301), (17, 'allow_images', '1', 'Images in links/category entries. 0: ignore, 1: allow', 302), (18, 'allow_smilies', '1', 'Smilies in links/category entries. 0: ignore, 1: allow', 303), (19, 'allow_bbcode', '1', 'Bbcode in links/category entries. 0: ignore, 1: allow', 304), (20, 'allow_null_links', '0', 'Links field can be left empty: 0: no, 1: yes', 305), (21, 'cat_depth_display', '1', 'Depth of subcategories shown in category listing; 1: show categories at this level only.', 307), (22, 'cat_sub_display', '0', 'Depth of categories below cat_depth_display to show as links within the catbit.', 308), (23, 'categories_seen_on_portal', '', 'Comma-separated list: Categories of hottest links to show on portal; blank=all categories', 309), (24, 'default_forumid', '-999', '-999: turn off the forum permissions system.
forumid:\n default category/link viewing permissions based on that forum.
Usergroups with\n can_set_permissions can always assign a permissions forum to a link/category.', 313), (25, 'count_depth', '1', '0: Show total links/categories in subcategory.
1: Show totals in complete subtree.', 310), (26, 'days_seen_on_portal', '10', 'Number of days'' new links to show on portal and with What''s New', 312), (27, 'default_sort_order', 'N', 'N/n: sort links in ascending/descending order by name, H/h: sort by hits, D/d: sort by submission date.', 314), (28, 'default_link_dseq', '1', 'Default display group sequence number for new links.', 315), (29, 'default_cat_dseq', '1', 'Default display group sequence number for new categories.', 316), (30, 'file_icons_dir', '', 'Optional, directory containing gif icons (e.g. pdf.gif) for linklistbit.\n NB: This setting is relative to the forums directory.', 317), (31, 'force_redirect', '0', '0: read/rewrite entries with known mimetypes (i.e. files hidden, headers controlled), browser redirect otherwise;
\n 1: use browser redirect regardless of filetype (quicker/less bandwidth but file location visible and no header control);
\n 2: standard html hyperlink (file location visible, no checking, no hit counting).', 318), (32, 'links_per_page', '0', 'Links shown per page, over-rides user setting.', 320), (33, 'links_seen_on_portal', '10', 'Number of links to show on portal, and with Show What''s Hot! and Anything!', 321), (34, 'local_file_root', '0', 'Controls interpretation of local filenames entered as links/downloads and\n using monitor_dir setting. 0: relative to site url, i.e. http://this_site/dir/file.
\n 1: interpreted relative to host filesystem; symbolic links and redirections ./ and ../ allowed.
NB, local_file_root=1\n creates security problems if file system not protected.', 322), (35, 'moderate_links', '0', '0: No moderation.
1: New submissions require moderation.', 325), (36, 'monitor_catid', '', 'Category id in which to place entries found during directory scans.', 326), (37, 'monitor_dir', '', 'Comma-separated list of directories to scan for new links (check setting of local_file_root).', 327), (38, 'robots_meta_tag', 'index, nofollow', 'Tells robots what to do: (no)index, (no)follow links/files.', 332), (39, 'can_access_link', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', '', 101), (40, 'can_report_link', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', '', 116), (41, 'can_play_musicbox', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', '', 117), (42, 'can_send_tofriend', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,23,39,25,27,35,38,40,41,42', '', 118), (43, 'can_view_names', '2,5,6,7,9,10,11,12,14,16,17,18,19,26,20,22,23,39,25,27,35,38,40,41,42', '', 132), (44, 'can_upload_files', '5,6,41', '', 141), (45, 'version_installed', '1', '', 202), (46, 'allow_remote_downloads', '1', '', 306), (47, 'database_name', '', '', 311), (48, 'link_imagesize', '0', '', 319), (49, 'local_file_root_prefix', '', '', 323), (50, 'match_using_like', '0', '', 324), (51, 'mod_rewrite', '', '', 325), (52, 'monitor_template', 'links_scantext', '', 328), (53, 'musicbox_filetypes', 'mpg, mpeg, wmv, mp3, swf, asf, wma, avi, wav', '', 329), (54, 'musicbox_filetypes_realplayer', 'rm, ra, ram, rt, rp, rv, rmvb, rpm, mov', '', 330), (55, 'protected_link', '0', '', 331), (56, 'seo_friendly', '0', '', 333), (57, 'show_hit_parade', '1', '', 334), (58, 'timeout_hit_recording', '60', '', 335), (59, 'timeout_hit_allow', '0', '', 336), (60, 'template_category_selection', 'links_addnewlink_catselect', '', 337), (61, 'template_linkbit', 'links_linkbit', '', 338), (62, 'upload_dir', '', '', 339), (63, 'upload_enabled', '0', '', 340), (64, 'upload_filetypes', '', '', 341), (65, 'upload_maxspace', '0', '', 342);