-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:42 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 `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `varname` varchar(25) NOT NULL DEFAULT '',
  `description` varchar(150) NOT NULL DEFAULT '',
  `setting` varchar(250) NOT NULL DEFAULT '',
  `optionorder` int(3) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=185 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `varname`, `description`, `setting`, `optionorder`, `section`) VALUES
(1, 'Title for your PhotoPost Application', 'galleryname', '', 'My Photo Gallery', 1, 1),
(2, 'Web site name', 'webname', '', 'BlackMustangClub.com', 2, 1),
(3, 'Your Website URL (include http://)', 'domain', '', 'http://blackmustangclub.com', 3, 1),
(4, 'Administrator Email Address', 'adminemail', '', 'admin@domain.com', 4, 1),
(5, 'Data directory virtual path', 'datadir', 'This is the web / virtual path to the data directory.', 'http://blackmustangclub.com/photopost/data', 5, 1),
(6, 'Full path to PhotoPost data directory', 'datafull', 'Full path to the image files directory.', '/home/blackmus/public_html/photopost/data', 6, 1),
(7, 'URL to your forums main directory (optional)', 'vbulletin', 'This is the virtual path to your forum installation.', 'http://blackmustangclub.com/forum', 7, 1),
(8, 'Full path to Header Include file', 'header', 'To include an HTML file as the header, enter the full path.', '/path/to/php/header.htm', 8, 1),
(9, 'Full path to the Footer include file', 'footer', 'To include an HTML file as the footer, enter the full path.', '/path/to/php/footer.htm', 9, 1),
(10, 'Full path to HTML file containing head tags', 'headtags', '', '/path/to/php/headtags.htm', 10, 1),
(11, 'URL to PhotoPost PHP directory', 'maindir', '', 'http://blackmustangclub.com/photopost', 11, 1),
(13, 'Default number of comments per page', 'defaultposts', '', '15', 1, 5),
(14, 'Show Most Recent Additions on Index page?', 'mostrecent', '', 'yes', 4, 9),
(15, 'Number of columns for thumbnail pages', 'thumbcols', '', '4', 1, 4),
(18, 'Thumbnail image max width and height in pixels', 'previewwidth', '', '100', 1, 6),
(19, 'Max allowable image width in pixels', 'maxwidth', '', '2500', 2, 6),
(20, 'Max allowable image height in pixels', 'maxheight', '', '2500', 3, 6),
(21, 'Trigger medium graphic height and width', 'biggraphic', 'An uploaded larger than this will create a medium image of this size.', '600', 4, 6),
(37, 'cright', 'cright', '', '<font size="1" face="verdana">Powered by: <a target="_blank" href="http://www.photopost.com">PhotoPost</a> --replaceme--<br />Copyright &copy 2004 All Enthusiast, Inc.</font>', 300, 0),
(38, 'Use email to notify users?', 'useemail', 'Users can be notified of photo approvals and deletions.', 'yes', 1, 2),
(41, 'User Registration System', 'vbversion', '', 'vb3', 12, 1),
(42, 'Comments increment user post count?', 'cpostcount', '', 'yes', 1, 7),
(43, 'Photo uploads increment user post count?', 'ppostcount', '', 'yes', 5, 6),
(44, 'Save and display medium and large images?', 'bigsave', '', 'yes', 6, 6),
(45, 'Number of columns for most recent additions section?', 'recentcols', '', '4', 1, 9),
(46, 'Number of photos to display in the most recent additions section?', 'recentnum', '', '12', 2, 9),
(47, 'Allow users to send e-Cards?', 'enablecard', '', 'no', 2, 5),
(48, 'Require users to be registered to send an e-Card?', 'cardreg', '', 'yes', 3, 5),
(49, 'URL to PhotoPost images directory', 'idir', '', 'http://blackmustangclub.com/photopost/images', 13, 1),
(50, 'Depth (number of levels) of categories to display.', 'catdepth', '', '1', 2, 3),
(51, 'Allow users to be notified of new posts via email?', 'usenotify', '', 'yes', 2, 2),
(58, 'Show post count and photo details for cats without thumbs?', 'catdetails', '', 'no', 3, 3),
(61, 'Use COPPA for registration?', 'coppa', '', 'yes', 3, 8),
(62, 'Full Path to Registration Rules, or leave blank for default', 'rules', '', '', 4, 8),
(63, 'Require verification of email address upon registration?', 'emailverify', '', 'yes', 5, 8),
(64, 'Your mailing address to receive COPPA permission forms?', 'address', '', '', 6, 8),
(65, 'Full path to COPPA rules file, or leave blank for default?', 'copparules', '', '', 7, 8),
(66, 'Allow new user registrations?', 'allowregs', '', 'yes', 8, 8),
(67, 'Allow users to upload photos?', 'allowup', '', 'yes', 3, 2),
(68, 'Allow users to post comments?', 'allowpost', '', 'yes', 4, 2),
(69, 'Show recent photos in default location (bottom)? (if no, will display at top)', 'recentdefault', '', 'yes', 3, 9),
(70, 'Your <a target="_blank" href="http://www.techimo.com/photopost/affiliate.html">Commission Junction</a> click-through URL', 'cjurl', '', '', 6, 2),
(71, 'Notify Admin of New Uploads?', 'uploadnotify', '', 'yes', 10, 2),
(72, 'Show last photo thumbnail in member galleries listing?', 'membthumb', '', 'yes', 4, 5),
(75, 'PhotoPost main table width, percent or pixels.', 'tablewidth', '', '100%', 5, 9),
(76, 'Require unique email addresses for user registration?', 'emailunique', '', 'no', 1, 8),
(78, 'Show Random images on Index page?', 'disrandom', '', 'no', 4, 3),
(79, 'Show Most Popular images on Index page?', 'dispopular', '', 'no', 5, 3),
(80, 'Do you want to allow ZIP uploads?', 'allowzip', '', 'no', 5, 2),
(81, 'PATH to UPLOADS directory?', 'zipuploaddir', '', '/home/blackmus/public_html/photopost/uploads', 16, 1),
(82, 'URL to UPLOADS directory?', 'zipuploadurl', '', 'http://blackmustangclub.com/photopost/uploads', 17, 1),
(83, 'Forum database table prefix', 'dprefix', '', '', 14, 1),
(84, 'PhotoPost Version', 'pversion', '', '4.5', 53, 0),
(86, 'Enable watermarking of photos with overlay image?', 'annotate', '', 'no', 1, 10),
(87, 'If enabled, position of overlay watermark on images.', 'gravity', '', 'SouthEast', 2, 10),
(88, 'Quality setting for resizing/thumbnails?', 'imgquality', '', '70', 7, 6),
(89, 'If photo upload width or height exceeds maximums, resize upload down to max dimensions?', 'resizeorig', '', 'yes', 8, 6),
(90, 'Full server path to watermark overlay image.', 'watermark', '', '', 3, 10),
(91, 'Allow users to move/delete their own images?', 'userdel', '', 'no', 12, 2),
(92, 'Display Members Gallery on the main index page?', 'showmem', '', 'yes', 6, 3),
(93, 'Require users to be registered to view images?', 'reqregister', '', 'no', 9, 8),
(94, 'Do you want Members Gallery to show all of a users photos?', 'memformat', '', 'yes', 57, 2),
(95, 'Display headers during SlideShows?', 'slidehead', '', 'yes', 24, 5),
(97, 'Maximum multimedia upload size in Kb', 'mmuploadsize', '', '2000', 10, 6),
(98, 'Allow users to create Personal Albums?', 'allowpa', '', 'yes', 7, 2),
(99, 'Allow multimedia uploads?', 'allowmedia', '', 'no', 8, 2),
(100, 'Allow members to rate photos?', 'allowrate', '', 'yes', 20, 5),
(101, 'Display new comments/photos indicator on index?', 'displaynew', '', 'no', 7, 3),
(102, 'Display and extract EXIF information from images?', 'showexif', '', 'no', 9, 6),
(103, 'Do you want to show the Members Gallery in List format?', 'memblist', '', 'no', 3, 4),
(104, 'Do you want to prompt for optional info during registration?', 'getoptional', '', 'yes', 2, 8),
(105, 'Do you want to be notified of all new comments?', 'notifyadmin', '', 'no', 9, 2),
(114, 'Display filesize?', 'dispfs', '', 'yes', 11, 5),
(115, 'Display views?', 'dispviews', '', 'yes', 12, 5),
(116, 'Display date?', 'dispdate', '', 'yes', 13, 5),
(117, 'Display dimensions?', 'dispdims', '', 'yes', 14, 5),
(118, 'Display keywords?', 'dispkeys', '', 'yes', 15, 5),
(119, 'Display description?', 'dispdesc', '', 'yes', 16, 5),
(120, 'Display ratings that have no comments attached?', 'dispempty', '', 'yes', 17, 5),
(121, 'Display title under photo?', 'disptitle', '', 'yes', 18, 5),
(122, 'Display quickratings under photos?', 'dispquick', '', 'yes', 19, 5),
(123, 'Do you want to allow people to download their favorites?', 'allowfavzip', '', 'yes', 11, 2),
(124, 'Display # of comments indicator under thumbnails?', 'dispcoms', '', 'yes', 2, 4),
(125, 'Display unapproved comments?', 'moderatecoms', '', 'yes', 21, 5),
(126, 'How many file upload prompts do you want?', 'maxfiles', '', '1', 13, 6),
(128, 'Pixel size of borders for images/thumbnails', 'cellpadding', 'Thickness - set to 0 for no border', '1', 8, 9),
(129, 'Color for image borders', 'framecolor', 'Color of the frame around images/thumbs', '#000000', 7, 9),
(130, 'Select a theme for your website', 'theme', 'Choose from the available themes for your site layout', 'default', 6, 9),
(131, 'Show UBBCode on Photo page?', 'showubb', '', 'no', 25, 6),
(133, 'Use Spider-friendly URLs?', 'spider', '', 'no', 15, 1),
(134, 'Use Anti-leeching code?', 'right-click', 'Use Right-Click Disable Script', 'no', 23, 5),
(135, 'Display number of viewers on categories?', 'displayonline', 'Adds a query to main index, but shows numbers of viewers per category', 'yes', 8, 3),
(136, 'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 14, 6),
(137, 'Enable slideshows?', 'slideshow', '', 'yes', 22, 5),
(138, 'Enable next and previous photo previews?', 'nextbox', '', 'yes', 26, 5),
(139, 'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 14, 2),
(140, 'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 13, 2),
(141, 'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 11, 6),
(142, 'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png', 12, 6),
(143, 'Select a border for your thumbnails', 'thumbborder', 'Choose from the available borders for your thumbnails', 'thumbnail', 9, 9),
(144, 'Sidebar Placement.?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'left', 1, 11),
(145, 'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11),
(146, 'UnderCategory PAL', 'undercat', ' Display Recent Comments and Who''s Online Pals', 'no', 5, 11),
(147, 'Statistics PAL', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11),
(148, 'Top Posters PAL', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11),
(149, 'Random Image PAL', 'randompal', ' Display Random Image?', 'yes', 8, 11),
(150, 'Highest Ratings PAL', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11),
(151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'yes', 2, 11),
(152, 'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'yes', 3, 11),
(153, 'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 18, 1),
(154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5),
(155, 'Show Avatars', 'showavatar', 'When available, show avatars?', 'yes', 28, 5),
(156, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3),
(157, 'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 10, 11),
(158, 'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 11, 11),
(159, 'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 12, 11),
(160, 'Number of Top Posters to display', 'numtoppal', '', '5', 13, 11),
(161, 'Number of Last Comments to display', 'numcompal', '', '5', 14, 11),
(162, 'Number of Highest Rated Photos to display', 'mostpoppal', '', '5', 15, 11),
(163, 'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 19, 1),
(164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11),
(165, 'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12),
(166, 'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1),
(167, 'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', '0', 23, 1),
(168, 'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1),
(169, 'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter t', '0', 25, 1),
(170, 'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '0', 26, 1),
(171, 'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12),
(172, 'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12),
(173, 'PhotoPost Cookie Domain', 'cookie_domain', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 12),
(174, 'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '0', 27, 1),
(175, 'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', '0', 29, 5),
(176, 'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '1', 28, 1),
(177, 'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1),
(178, 'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/bin/mysqldump', 30, 1),
(179, 'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/bin/jpegtran', 18, 1),
(180, 'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/bin/jhead', 19, 1),
(181, 'Gallery Open?', 'ppboards', '', 'open', 20, 1),
(182, 'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1),
(183, 'Show Personal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3),
(184, 'Allow users to move their own images?', 'usermove', '', 'no', 16, 2);