-- MySQL dump 10.9
--
-- Host: localhost Database: dealersc_site
-- ------------------------------------------------------
-- Server version 4.1.22-standard
/*!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 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `sd_categories`
--
DROP TABLE IF EXISTS `sd_categories`;
CREATE TABLE `sd_categories` (
`categoryid` int(10) unsigned NOT NULL auto_increment,
`parentid` int(10) unsigned NOT NULL default '0',
`designid` int(10) unsigned NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`urlname` varchar(64) NOT NULL default '',
`sslurl` tinyint(1) default '0',
`displayorder` int(10) unsigned NOT NULL default '0',
`link` varchar(128) NOT NULL default '',
`target` varchar(10) NOT NULL default '',
`image` varchar(128) NOT NULL default '',
`hoverimage` varchar(128) NOT NULL default '',
`menuwidth` smallint(5) unsigned NOT NULL default '0',
`metadescription` text NOT NULL,
`metakeywords` text NOT NULL,
`appendkeywords` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`categoryid`),
KEY `displayorder` (`displayorder`),
KEY `parentid` (`parentid`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_categories`
--
LOCK TABLES `sd_categories` WRITE;
/*!40000 ALTER TABLE `sd_categories` DISABLE KEYS */;
INSERT INTO `sd_categories` (`categoryid`, `parentid`, `designid`, `name`, `urlname`, `sslurl`, `displayorder`, `link`, `target`, `image`, `hoverimage`, `menuwidth`, `metadescription`, `metakeywords`, `appendkeywords`) VALUES (1,0,7,'Home','home',0,1,'','','','',65,'','',0),(8,0,7,'Support','Support',0,2,'http://www.dealerscript.com/forum/index.php','','','',0,'','',0),(9,0,7,'Documents','Documents',0,3,'','','','',0,'','',0),(10,0,7,'Products','Products',0,4,'','','','',0,'','',0);
/*!40000 ALTER TABLE `sd_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_comments`
--
DROP TABLE IF EXISTS `sd_comments`;
CREATE TABLE `sd_comments` (
`commentid` int(10) unsigned NOT NULL auto_increment,
`pluginid` int(10) unsigned NOT NULL default '0',
`objectid` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`username` varchar(64) NOT NULL default '',
`comment` text NOT NULL,
PRIMARY KEY (`commentid`),
KEY `pluginid` (`pluginid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_comments`
--
LOCK TABLES `sd_comments` WRITE;
/*!40000 ALTER TABLE `sd_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_customplugins`
--
DROP TABLE IF EXISTS `sd_customplugins`;
CREATE TABLE `sd_customplugins` (
`custompluginid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`displayname` varchar(64) NOT NULL default '',
`plugin` mediumtext NOT NULL,
`includefile` varchar(128) NOT NULL default '',
`settings` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`custompluginid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_customplugins`
--
LOCK TABLES `sd_customplugins` WRITE;
/*!40000 ALTER TABLE `sd_customplugins` DISABLE KEYS */;
INSERT INTO `sd_customplugins` (`custompluginid`, `name`, `displayname`, `plugin`, `includefile`, `settings`) VALUES (1,'Contact text','Contact us!','Need to contact us?
Click Here!','',17),(2,'Homepage','DealerScript :: Top Rated PHP Car Dealer Script','
DealerScript is a world class php vehicle listings script designed for novice and expert computer users alike. In just a few minutes time you can have a fully functional multi-page vehicle listings web site. With years of development time and customer feedback taken into consideration, DealerScript is your sure fire way to get noticed on the internet quickly and efficiently.
DealerScript will take your internet listing needs to the next level with features such as: Unlimited custom watermarked photos per listing, Credit pre-qualification form, unlimited listings, unlimited Dealership Locations, multiple languages, template driven environment, contact pages, text editors and printable vehicle sales pages for your customers.
We accept Credit Cards and USD converted free via PayPal! \r\n\r\n \r\n\r\n\r\n \r\n\r\n
Your payment will be sent to \"Extreme Values\"
Parent Company of DealerScript !\r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n \r\n\r\n\r\n
DealerScript - \"Do It Your Self\" per domain license - $139.99
Buyer Does Installation
1 Year Support & Downloadable Updates
Full Installation Instructions Included
\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
DealerScript per domain license - $189.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript Copyright Free per domain license - $289.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript copyrights and links removed
DealerScript Source per domain - $499.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript copyrights and links removed
Full Source Code Revealed
DealerScript Platinum - $1,999.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript copyrights and links removed
Full Source Code Revealed
Professional Web Design & Custom Logo with Flash®
DealerScript Reseller License - $3,499.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript copyrights and links replaced with your own
DealerScript Source Reseller - $7,499.99
Free Installation
1 Year Support & Downloadable Updates
DealerScript copyrights and links replaced with your own
Full Source Code Revealed
Flash is a registered trademark or trademark of Adobe Systems, Incorporated and is not affiliated with DealerScript in any way.
','',17),(4,'PayPal Verified','PayPal Verified','
','',17),(5,'eBay Feedback','eBay Feedback','
','',17),(6,'FireFox','Spreading Love','
','',17);
/*!40000 ALTER TABLE `sd_customplugins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_designs`
--
DROP TABLE IF EXISTS `sd_designs`;
CREATE TABLE `sd_designs` (
`designid` int(10) unsigned NOT NULL auto_increment,
`skinid` int(10) unsigned NOT NULL default '0',
`maxplugins` int(10) unsigned NOT NULL default '0',
`designpath` varchar(64) NOT NULL default '',
`imagepath` varchar(64) NOT NULL default '',
PRIMARY KEY (`designid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_designs`
--
LOCK TABLES `sd_designs` WRITE;
/*!40000 ALTER TABLE `sd_designs` DISABLE KEYS */;
INSERT INTO `sd_designs` (`designid`, `skinid`, `maxplugins`, `designpath`, `imagepath`) VALUES (1,1,30,'advanced_2/advanced_1.php','advanced_2/images/adv_design_1.jpg'),(2,1,20,'advanced_2/advanced_2.php','advanced_2/images/adv_design_2.jpg'),(3,1,20,'advanced_2/advanced_3.php','advanced_2/images/adv_design_3.jpg'),(4,1,10,'advanced_2/advanced_4.php','advanced_2/images/adv_design_4.jpg'),(5,2,20,'immeasurably/immeasurably_1.php','immeasurably/images/im_design_1.jpg'),(6,2,10,'immeasurably/immeasurably_2.php','immeasurably/images/im_design_2.jpg'),(7,3,25,'phpCS/3cols.php','phpCS/images/3cols.jpg');
/*!40000 ALTER TABLE `sd_designs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_mainsettings`
--
DROP TABLE IF EXISTS `sd_mainsettings`;
CREATE TABLE `sd_mainsettings` (
`settingid` int(10) unsigned NOT NULL auto_increment,
`varname` varchar(64) NOT NULL default '',
`groupname` varchar(64) NOT NULL default '',
`input` mediumtext NOT NULL,
`title` varchar(100) NOT NULL default '',
`description` mediumtext NOT NULL,
`value` mediumtext NOT NULL,
PRIMARY KEY (`settingid`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_mainsettings`
--
LOCK TABLES `sd_mainsettings` WRITE;
/*!40000 ALTER TABLE `sd_mainsettings` DISABLE KEYS */;
INSERT INTO `sd_mainsettings` (`settingid`, `varname`, `groupname`, `input`, `title`, `description`, `value`) VALUES (1,'sdurl','Subdreamer Settings','text','Website URL','Please enter the full URL to your Subdreamer website:
This setting is very important and is required for Subdreamer to function correctly.
Example: http://www.subdreamer.com/','http://www.dealerscript.com/site/'),(2,'enablewysiwyg','Subdreamer Settings','yesno','WYSIWYG Editor','Enable the WYSIWYG editor in the admin panel?
Subdreamer comes installed with a powerful editor that is used in several areas including the news plugin and logo creator. The editor will allow you to view changes you make on your content such as altering a font\'s size and color. While the editor is great for simple changes, you might want to disable it if you\'re dealing with more complex code such as JavaScript.','1'),(3,'checkforupdates','Subdreamer Settings','yesno','Check For Updates','Allow Subdreamer to automatically check for updates to the CMS and plugins?
See: http://us2.php.net/manual/en/function.date.php','F j, Y'),(17,'timezoneoffset','Date and Time Options','','Default Time Zone Offset','Time zone offset for guests and new users. Do not take DST into consideration, rather use the next option to enable/disable DST.','0'),(18,'daylightsavings','Date and Time Options','yesno','Enable Daylight Savings','If Daylight Savings Time is currently in effect for the above time zone, enable this option so that guests will see the correct times','0'),(19,'smiliesystem','Smilies','','Smilie System','','Subdreamer'),(20,'language','NA','','Language','','English.php|1.0|iso-8859-1'),(21,'bfo','NA','','bfo','','1'),(22,'sdversion','','','version','Subdreamer Version','2.4.3.1'),(23,'sdversiontype','','','Version Type','The version type is either Basic or Pro. Do not change this value manually, it will cause problems.','Pro'),(24,'currentlogo','','','Current Logo','','
DealerScript
'),(25,'commentvvc','Comment Options','yesno','Visual Verify Code','Require users to enter a Visual Verify Code to post comments?','0'),(26,'commentavatar','Comment Options','yesno','Show User Avatar','Show user\'s avatar next to their comment?','0'),(27,'emailformat','Site Settings','','Default Email Format','Default format for sending Emails.','Text'),(28,'sslurl','Subdreamer Settings','text','Secure Website URL','Please enter the full URL to your Secure Subdreamer website:
Example: https://www.subdreamer.com/',''),(29,'forcessl','Subdreamer Settings','yesno','Force SSL','If marked yes, an error page will be displayed if a URL not using HTTPS is used.','0'),(30,'globalscomp','Subdreamer Settings','yesno','Globals Compatibility','Globals compatibility will make your server more secure, but may not be compatible with all plugins.','1');
/*!40000 ALTER TABLE `sd_mainsettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p16_links`
--
DROP TABLE IF EXISTS `sd_p16_links`;
CREATE TABLE `sd_p16_links` (
`linkid` int(10) unsigned NOT NULL auto_increment,
`sectionid` int(10) unsigned NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
`allowsmilies` tinyint(1) NOT NULL default '0',
`showauthor` tinyint(1) NOT NULL default '0',
`author` varchar(64) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`url` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`linkid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p16_links`
--
LOCK TABLES `sd_p16_links` WRITE;
/*!40000 ALTER TABLE `sd_p16_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_p16_links` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p16_sections`
--
DROP TABLE IF EXISTS `sd_p16_sections`;
CREATE TABLE `sd_p16_sections` (
`sectionid` int(10) unsigned NOT NULL auto_increment,
`parentid` int(10) unsigned NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`sorting` varchar(32) NOT NULL default '',
PRIMARY KEY (`sectionid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p16_sections`
--
LOCK TABLES `sd_p16_sections` WRITE;
/*!40000 ALTER TABLE `sd_p16_sections` DISABLE KEYS */;
INSERT INTO `sd_p16_sections` (`sectionid`, `parentid`, `activated`, `name`, `description`, `sorting`) VALUES (1,0,1,'Links','','Newest First');
/*!40000 ALTER TABLE `sd_p16_sections` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p17_images`
--
DROP TABLE IF EXISTS `sd_p17_images`;
CREATE TABLE `sd_p17_images` (
`imageid` int(10) unsigned NOT NULL auto_increment,
`sectionid` int(10) unsigned NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`allowsmilies` tinyint(1) NOT NULL default '0',
`allowcomments` tinyint(1) NOT NULL default '0',
`showauthor` tinyint(1) NOT NULL default '0',
`author` varchar(64) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`description` text,
`viewcount` int(10) unsigned NOT NULL default '0',
`datecreated` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`imageid`),
KEY `sectionid` (`sectionid`),
KEY `activated` (`activated`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p17_images`
--
LOCK TABLES `sd_p17_images` WRITE;
/*!40000 ALTER TABLE `sd_p17_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_p17_images` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p17_sections`
--
DROP TABLE IF EXISTS `sd_p17_sections`;
CREATE TABLE `sd_p17_sections` (
`sectionid` int(10) unsigned NOT NULL auto_increment,
`parentid` int(10) unsigned NOT NULL default '0',
`activated` tinyint(1) NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`sorting` varchar(32) NOT NULL default '',
`imageid` int(10) unsigned default NULL,
`datecreated` int(10) unsigned NOT NULL default '0',
`imagecount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`sectionid`),
KEY `parentid` (`parentid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p17_sections`
--
LOCK TABLES `sd_p17_sections` WRITE;
/*!40000 ALTER TABLE `sd_p17_sections` DISABLE KEYS */;
INSERT INTO `sd_p17_sections` (`sectionid`, `parentid`, `activated`, `name`, `description`, `sorting`, `imageid`, `datecreated`, `imagecount`) VALUES (1,0,1,'Images','','Newest First',NULL,1184468174,0);
/*!40000 ALTER TABLE `sd_p17_sections` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p2_news`
--
DROP TABLE IF EXISTS `sd_p2_news`;
CREATE TABLE `sd_p2_news` (
`articleid` int(10) unsigned NOT NULL auto_increment,
`categoryid` int(10) unsigned NOT NULL default '0',
`settings` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`displayorder` int(10) unsigned NOT NULL default '0',
`datecreated` int(10) unsigned NOT NULL default '0',
`dateupdated` int(10) unsigned NOT NULL default '0',
`datestart` int(10) unsigned NOT NULL default '0',
`dateend` int(10) unsigned NOT NULL default '0',
`author` varchar(64) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`metadescription` text NOT NULL,
`metakeywords` text NOT NULL,
`description` text NOT NULL,
`article` mediumtext NOT NULL,
PRIMARY KEY (`articleid`),
KEY `categoryid` (`categoryid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p2_news`
--
LOCK TABLES `sd_p2_news` WRITE;
/*!40000 ALTER TABLE `sd_p2_news` DISABLE KEYS */;
INSERT INTO `sd_p2_news` (`articleid`, `categoryid`, `settings`, `views`, `displayorder`, `datecreated`, `dateupdated`, `datestart`, `dateend`, `author`, `title`, `metadescription`, `metakeywords`, `description`, `article`) VALUES (2,9,4134,74,1,1196923298,0,1196923099,0,'phpcs','DealerScript Manual','','','DealerScript user manual','Please visit the proceeding link to view the PDF of the DealerScript user's manual.');
/*!40000 ALTER TABLE `sd_p2_news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p2_settings`
--
DROP TABLE IF EXISTS `sd_p2_settings`;
CREATE TABLE `sd_p2_settings` (
`categoryid` int(10) unsigned NOT NULL default '0',
`maxarticles` int(10) unsigned NOT NULL default '10',
`sorting` varchar(64) NOT NULL default 'Newest First',
`multiplepages` tinyint(1) NOT NULL default '0',
KEY `categoryid` (`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p2_settings`
--
LOCK TABLES `sd_p2_settings` WRITE;
/*!40000 ALTER TABLE `sd_p2_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_p2_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p4_guestbook`
--
DROP TABLE IF EXISTS `sd_p4_guestbook`;
CREATE TABLE `sd_p4_guestbook` (
`messageid` int(10) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`websitename` varchar(128) NOT NULL default '',
`website` varchar(128) NOT NULL default '',
`message` text NOT NULL,
`datecreated` int(10) NOT NULL default '0',
PRIMARY KEY (`messageid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p4_guestbook`
--
LOCK TABLES `sd_p4_guestbook` WRITE;
/*!40000 ALTER TABLE `sd_p4_guestbook` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_p4_guestbook` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_p7_chatterbox`
--
DROP TABLE IF EXISTS `sd_p7_chatterbox`;
CREATE TABLE `sd_p7_chatterbox` (
`commentid` int(10) unsigned NOT NULL auto_increment,
`categoryid` int(10) unsigned NOT NULL default '0',
`username` varchar(64) NOT NULL default '',
`comment` text NOT NULL,
`datecreated` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`commentid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_p7_chatterbox`
--
LOCK TABLES `sd_p7_chatterbox` WRITE;
/*!40000 ALTER TABLE `sd_p7_chatterbox` DISABLE KEYS */;
/*!40000 ALTER TABLE `sd_p7_chatterbox` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_pagesort`
--
DROP TABLE IF EXISTS `sd_pagesort`;
CREATE TABLE `sd_pagesort` (
`categoryid` int(10) unsigned NOT NULL default '0',
`pluginid` varchar(5) NOT NULL default '1',
`displayorder` int(10) unsigned NOT NULL default '0',
KEY `categoryid` (`categoryid`),
KEY `pluginid` (`pluginid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_pagesort`
--
LOCK TABLES `sd_pagesort` WRITE;
/*!40000 ALTER TABLE `sd_pagesort` DISABLE KEYS */;
INSERT INTO `sd_pagesort` (`categoryid`, `pluginid`, `displayorder`) VALUES (1,'1',25),(1,'1',24),(1,'1',23),(1,'1',22),(1,'1',21),(1,'1',20),(1,'1',19),(1,'c6',18),(1,'c5',17),(1,'c4',16),(1,'1',15),(1,'1',14),(1,'1',13),(1,'1',12),(1,'1',11),(1,'1',10),(1,'1',9),(1,'3',8),(1,'8',7),(1,'10',6),(1,'1',5),(1,'1',4),(1,'1',3),(1,'1',2),(1,'c2',1),(8,'1',25),(8,'1',24),(8,'1',23),(8,'1',22),(8,'1',21),(8,'1',20),(8,'1',19),(8,'1',18),(8,'1',17),(8,'1',16),(8,'1',15),(8,'1',14),(8,'1',13),(8,'1',12),(8,'1',11),(8,'1',10),(8,'1',9),(8,'1',8),(8,'1',7),(8,'1',6),(8,'1',5),(8,'1',4),(8,'1',3),(8,'1',2),(8,'1',1),(9,'1',25),(9,'1',24),(9,'1',23),(9,'1',22),(9,'1',21),(9,'1',20),(9,'1',19),(9,'1',18),(9,'1',17),(9,'8',16),(9,'1',15),(9,'1',14),(9,'1',13),(9,'1',12),(9,'1',11),(9,'1',10),(9,'1',9),(9,'1',8),(9,'1',7),(9,'10',6),(9,'1',5),(9,'1',4),(9,'1',3),(9,'1',2),(9,'2',1),(10,'1',25),(10,'1',24),(10,'1',23),(10,'1',22),(10,'1',21),(10,'1',20),(10,'1',19),(10,'1',18),(10,'1',17),(10,'8',16),(10,'1',15),(10,'1',14),(10,'1',13),(10,'1',12),(10,'1',11),(10,'1',10),(10,'1',9),(10,'1',8),(10,'1',7),(10,'10',6),(10,'1',5),(10,'1',4),(10,'1',3),(10,'1',2),(10,'c3',1);
/*!40000 ALTER TABLE `sd_pagesort` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_phrases`
--
DROP TABLE IF EXISTS `sd_phrases`;
CREATE TABLE `sd_phrases` (
`phraseid` int(10) NOT NULL auto_increment,
`pluginid` int(10) NOT NULL default '0',
`varname` varchar(64) NOT NULL default '',
`defaultphrase` text NOT NULL,
`customphrase` text NOT NULL,
`font` varchar(32) NOT NULL default '',
`color` varchar(32) NOT NULL default '',
`size` varchar(32) NOT NULL default '',
`bold` tinyint(1) NOT NULL default '0',
`italic` tinyint(1) NOT NULL default '0',
`underline` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`phraseid`),
KEY `pluginid` (`pluginid`)
) ENGINE=MyISAM AUTO_INCREMENT=275 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_phrases`
--
LOCK TABLES `sd_phrases` WRITE;
/*!40000 ALTER TABLE `sd_phrases` DISABLE KEYS */;
INSERT INTO `sd_phrases` (`phraseid`, `pluginid`, `varname`, `defaultphrase`, `customphrase`, `font`, `color`, `size`, `bold`, `italic`, `underline`) VALUES (1,1,'Sunday','Sunday','','','','',0,0,0),(2,1,'Monday','Monday','','','','',0,0,0),(3,1,'Tuesday','Tuesday','','','','',0,0,0),(4,1,'Wednesday','Wednesday','','','','',0,0,0),(5,1,'Thursday','Thursday','','','','',0,0,0),(6,1,'Friday','Friday','','','','',0,0,0),(7,1,'Saturday','Saturday','','','','',0,0,0),(8,1,'Sun','Sun','','','','',0,0,0),(9,1,'Mon','Mon','','','','',0,0,0),(10,1,'Tue','Tue','','','','',0,0,0),(11,1,'Wed','Wed','','','','',0,0,0),(12,1,'Thu','Thu','','','','',0,0,0),(13,1,'Fri','Fri','','','','',0,0,0),(14,1,'Sat','Sat','','','','',0,0,0),(15,1,'January','January','','','','',0,0,0),(16,1,'February','February','','','','',0,0,0),(17,1,'March','March','','','','',0,0,0),(18,1,'April','April','','','','',0,0,0),(19,1,'May','May','','','','',0,0,0),(20,1,'June','June','','','','',0,0,0),(21,1,'July','July','','','','',0,0,0),(22,1,'August','August','','','','',0,0,0),(23,1,'September','September','','','','',0,0,0),(24,1,'October','October','','','','',0,0,0),(25,1,'November','November','','','','',0,0,0),(26,1,'December','December','','','','',0,0,0),(27,1,'Jan','Jan','','','','',0,0,0),(28,1,'Feb','Feb','','','','',0,0,0),(29,1,'Mar','Mar','','','','',0,0,0),(30,1,'Apr','Apr','','','','',0,0,0),(31,1,'May','May','','','','',0,0,0),(32,1,'Jun','Jun','','','','',0,0,0),(33,1,'Jul','Jul','','','','',0,0,0),(34,1,'Aug','Aug','','','','',0,0,0),(35,1,'Sep','Sep','','','','',0,0,0),(36,1,'Oct','Oct','','','','',0,0,0),(37,1,'Nov','Nov','','','','',0,0,0),(38,1,'Dec','Dec','','','','',0,0,0),(39,1,'enter_comment_name','Please fill out the name field.','','','','',1,0,0),(40,1,'enter_comment','Please fill out the comment field.','','','','',1,0,0),(41,1,'repeat_comment','Repeat comment not posted.','','','','',1,0,0),(42,1,'users_name','User\'s Name:','','','','',0,0,0),(43,1,'your_name','Your Name:','','','','',0,0,0),(44,1,'comment','Comment:','','','','',0,0,0),(45,1,'update_comment','Update Comment','','','','',0,0,0),(46,1,'post_comment','Post Comment','','','','',0,0,0),(47,1,'comments','Comments:','','','','',0,0,0),(48,1,'edit','Edit','','','','',0,0,0),(49,1,'delete','Delete','','','','',0,0,0),(50,1,'login_post_comments','You must be logged in to post comments.','','','','',1,0,0),(51,1,'view_comments','View Comments','','','','',0,0,0),(52,1,'hide_comments','Hide Comments','','','','',0,0,0),(53,1,'login_view_page','Sorry, you must be logged in to view this page!','','','','',0,0,0),(54,1,'wrong_password','Wrong Password','','','','',1,0,0),(55,1,'wrong_username','Wrong Username','','','','',1,0,0),(56,1,'please_enter_username','Please enter a username.','','','','',1,0,0),(57,1,'session_error','Couldn\'t start session','','','','',1,0,0),(58,1,'you_are_banned','You have been banned','','','','',1,0,0),(59,1,'ip_banned','Your IP address has been banned','','','','',1,0,0),(60,1,'no_view_access','Sorry, your account does not have access to this section.','','','','',0,0,0),(61,1,'no_post_access','Sorry, your account does not have access to submit information.','','','','',0,0,0),(62,1,'no_download_access','Sorry, your account does not have access to downloads.','','','','',0,0,0),(63,1,'no_comment_access','Sorry, your account does not have access to post comments.','','','','',0,0,0),(64,1,'url_not_found','URL Not Found!','','','','',0,0,0),(65,1,'page_not_found','Page Not Found!','','','','',0,0,0),(66,1,'redirect_to_homepage','Click here to redirect to the homepage.','','','','',0,0,0),(67,1,'not_yet_activated','Your haven\'t yet activated your account. Check your email for the activation instructions','','','','',1,0,0),(68,1,'incorrect_vvc_code','Incorrect confirmation code','','','','',1,0,0),(69,1,'enter_verify_code','Enter the code you see in the image above (case sensitive)','','','','',1,0,0),(70,2,'previous_page','« Previous Page','','','','',0,0,0),(71,2,'next_page','Next Page »','','','','',0,0,0),(72,2,'page','Page','','','','',0,0,0),(73,2,'of','of','','','','',0,0,0),(74,2,'published','Published: ','','','','',0,0,0),(75,2,'updated','Updated: ','','','','',0,0,0),(76,2,'discuss_article_in_forum','Discuss this article in the Forum!','','','','',0,0,0),(77,2,'by','By','','','','',0,0,0),(78,2,'read_more','Read More...','','','','',0,0,0),(79,2,'previous','« Previous','','','','',0,0,0),(80,2,'next','Next »','','','','',0,0,0),(81,2,'article_offline','This article is currently offline.','','','','',0,0,0),(82,2,'author','Author:','','','','',1,0,0),(83,2,'title','Title:','','','','',1,0,0),(84,2,'description','Description:','','','','',1,0,0),(85,2,'article','Article:','','','','',1,0,0),(86,2,'submit_article','Submit Article','','','','',0,0,0),(87,2,'enter_name','Please enter your name.','','','','',0,0,0),(88,2,'enter_title','Please enter the title.','','','','',0,0,0),(89,2,'enter_description','Please enter the description.','','','','',0,0,0),(90,2,'enter_article','Please enter an article.','','','','',0,0,0),(91,2,'article_submitted','Thanks! Your article has been submitted.','','','','',0,0,0),(92,2,'print','Print','','','','',0,0,0),(93,2,'email','Email','','','','',0,0,0),(94,2,'enter_recipient_email','Send this article to:','','','','',1,0,0),(95,2,'separate_with_commas','Separate multiple addresses with commas.','','','','',0,0,0),(96,2,'enter_your_email','Enter your email address:','','','','',1,0,0),(97,2,'enter_comment','Enter an optional comment:','','','','',1,0,0),(98,2,'send_email','Send Email','','','','',0,0,0),(99,2,'invalid_email','Please enter a valid email address.','','','','',1,0,0),(100,2,'email_sent','The following article has been sent:','','','','',1,0,0),(101,2,'go_back','Click here to go back to the article.','','','','',0,0,0),(102,2,'email_not_sent','A system error occured. Your message was not sent.','','','','',1,0,0),(103,2,'notify_email_from','Article Plugin','','','','',0,0,0),(104,2,'notify_email_subject','New article submitted to your website!','','','','',0,0,0),(105,2,'notify_email_message','A new article has been submitted to your website.','','','','',0,0,0),(106,2,'notify_email_author','Author','','','','',0,0,0),(107,2,'notify_email_title','Title','','','','',0,0,0),(108,2,'views','Views','','','','',0,0,0),(109,3,'by','By','','','','',0,0,0),(110,3,'read_more','Read More...','','','','',0,0,0),(111,3,'print','Print','','','','',0,0,0),(112,3,'email','Email','','','','',0,0,0),(113,3,'published','Published: ','','','','',0,0,0),(114,3,'updated','Updated: ','','','','',0,0,0),(115,4,'website_url','Website URL:','','','','',1,0,0),(116,4,'name','Name:','','','','',1,0,0),(117,4,'date','Posted:','','','','',1,0,0),(118,4,'website_name','Website Name:','','','','',1,0,0),(119,4,'message','Message:','','','','',1,0,0),(120,4,'submit_message','Submit Message','','','','',0,0,0),(121,4,'reset','Reset','','','','',0,0,0),(122,4,'no_username','Please fill out the username field.','','','','',0,0,0),(123,4,'no_message','Please fill out the message field.','','','','',0,0,0),(124,4,'message_too_long','Message length must be less than','','','','',0,0,0),(125,4,'url_invalid','Website URL is invalid.','','','','',0,0,0),(126,4,'no_site_name','Please enter the site name of the url specified.','','','','',0,0,0),(127,4,'repeat_comment','Repeat comment not posted.','','','','',0,0,0),(128,4,'website','Website:','','','','',1,0,0),(129,4,'previous','« Previous','','','','',0,0,0),(130,4,'next','Next »','','','','',0,0,0),(131,4,'sign_guestbook','Click here to sign the guestbook!','','','','',0,0,0),(132,4,'characters','characters','','','','',0,0,0),(133,6,'full_name','Full Name:','','','','',1,0,0),(134,6,'your_email','Your Email:','','','','',1,0,0),(135,6,'subject','Subject:','','','','',1,0,0),(136,6,'message','Message:','','','','',1,0,0),(137,6,'send_message','Send Message','','','','',0,0,0),(138,6,'reset','Reset','','','','',0,0,0),(139,6,'invalid_email','Invalid Email entered!','','','#FF0000','',1,0,0),(140,6,'email_sent','Thanks! Your email has been sent!','','','','',0,0,0),(141,6,'email_not_sent','A system error occured. Your message was not sent.','','','','',1,0,0),(142,6,'attachment','Attachment:','','','','',1,0,0),(143,6,'empty_fields','Error: One of the required field(s) is empty.','','','#FF0000','',1,0,0),(144,7,'name','Name:','','','','',0,0,0),(145,7,'comment','Comment:','','','','',0,0,0),(146,7,'say','Say','','','','',0,0,0),(147,7,'no_username','No username supplied!','','','','',0,0,0),(148,7,'no_comment','No comment supplied!','','','','',0,0,0),(149,7,'repeat_comment','Repeat comment not posted.','','','','',0,0,0),(150,7,'view_history','View Message History','','','','',0,0,0),(151,8,'posted_by','Posted by','','','','',0,0,0),(152,9,'user','User:','','','','',0,0,0),(153,9,'posts','Posts:','','','','',0,0,0),(154,10,'my_account','My Account','','','','',0,0,0),(155,10,'welcome_back','Welcome back','','','','',0,0,0),(156,10,'logout','Log Out','','','','',0,0,0),(157,10,'username','Username:','','','','',0,0,0),(158,10,'password','Password:','','','','',0,0,0),(159,10,'remember_me','Remember Me','','','','',0,0,0),(160,10,'login','Login','','','','',0,0,0),(161,10,'not_registered','Not registered?','','','','',0,0,0),(162,10,'register_now','Register now!','','','','',0,0,0),(163,10,'private_messages','Private Messages:','','','','',0,0,0),(164,10,'unread_total',' Unread, Total ','','','','',0,0,0),(165,10,'new_priv_msg','You have a new private message.','','','','',0,0,0),(166,10,'title','Title:','','','','',0,0,0),(167,10,'sender','Sender:','','','','',0,0,0),(168,10,'click_ok','Click OK to view it, or cancel to hide this prompt.','','','','',0,0,0),(169,10,'open_msg','Open Message in New Window?','','','','',0,0,0),(170,10,'new_priv_msg_title','New Private Message','','','','',0,0,0),(171,10,'forgot_password','Forgot your password?','','','','',0,0,0),(172,10,'admin_panel','Admin Panel','','','','',0,0,0),(173,11,'no_changes_entered','No Changes Entered!','','','','',0,0,0),(174,11,'enter_valid_password','Please enter a new password that consists only of letters and numbers.','','','','',0,0,0),(175,11,'password_unmatched','The new password you entered did not match the new confirmed password.','','','','',0,0,0),(176,11,'enter_valid_email','Please enter a valid email address.','','','','',0,0,0),(177,11,'email_already_exists','email already exists, please try another.','','','','',0,0,0),(178,11,'profile_updated','User Profile Updated!','','','','',0,0,0),(179,11,'new_password','New Password:','','','','',0,0,0),(180,11,'confirm_password','Confirm New Password:','','','','',0,0,0),(181,11,'new_email','New Email:','','','','',0,0,0),(182,11,'update_profile','Update Profile','','','','',0,0,0),(183,11,'visit_cp','Click here to visit your control panel.','','','','',0,0,0),(184,12,'user_name','User Name:','','','','',0,0,0),(185,12,'password','Password:','','','','',0,0,0),(186,12,'password_again','Enter Password Again:','','','','',0,0,0),(187,12,'email','Email:','','','','',0,0,0),(188,12,'email_again','Enter Email Again:','','','','',0,0,0),(189,12,'register','Register','','','','',0,0,0),(190,12,'reset_form','Reset Form','','','','',0,0,0),(191,12,'enter_alnum_username','Please enter a username that consists only of letters and numbers.','','','','',1,0,0),(192,12,'enter_alnum_password','Please enter a password that consists only of letters and numbers.','','','','',1,0,0),(193,12,'password_unmatched','Your confirmed password does not match the entered password.','','','','',1,0,0),(194,12,'unvalid_email','Please enter a valid email address.','','','','',1,0,0),(195,12,'email_unmatched','The email you entered did not match the confirmed email.','','','','',1,0,0),(196,12,'username_exists','Username already exists, please try another.','','','','',1,0,0),(197,12,'email_exists','Email already exists, please try another.','','','','',1,0,0),(198,12,'register_success','Thank you for registering!','','','','',0,0,0),(199,12,'already_logged_in','You are already logged in as:','','','','',0,0,0),(200,12,'logout','Click here if you wish to log out.','','','','',0,0,0),(201,12,'register_now','Click here to Register!','','','','',0,0,0),(202,12,'email_banned','Your Email address has been banned','','','','',1,0,0),(203,12,'pwd_reset','Reset My Password','','','','',0,0,0),(204,12,'email_not_found','No account could be found that matched the entered email address:','','','','',0,0,0),(205,12,'email_subject','Your new Password','','','','',0,0,0),(206,12,'email_message','Here is your new password: ','','','','',0,0,0),(207,12,'password_reset_success','Your password was reset successfully. An email will arrive shortly with your new login details.','','','','',0,0,0),(208,12,'activation_required','Thank you for registering. An email has been sent to your email address with instructions on how to activate your new account','','','','',0,0,0),(209,12,'email_subject_activation','Thanks for registering','','','','',0,0,0),(210,12,'email_message_activation','Thanks for registering with us. Please click the following link to activate your account.','','','','',0,0,0),(211,12,'validation_key_not_found','Your account was not found. Please ensure you copied the link correctly.','','','','',0,0,0),(212,12,'already_validated','Your account has already been activated. You may login using your username and password','','','','',0,0,0),(213,12,'validation_success','Thank you for activating your account. You may now login using your username and password','','','','',0,0,0),(214,16,'sections','Sections:','','','','',1,0,0),(215,16,'submitting_link','Submitting Link','','','','',0,0,0),(216,16,'your_name','Your Name:','','','','',1,0,0),(217,16,'website_name','Website Name:','','','','',1,0,0),(218,16,'website_url','Website URL:','','','','',1,0,0),(219,16,'description','Description:','','','','',1,0,0),(220,16,'submit_link','Submit Link','','','','',0,0,0),(221,16,'submit_a_link','Click here to submit a link to this section!','','','','',0,0,0),(222,16,'submitted_by','Submitted by:','','','','',0,0,0),(223,16,'previous_links','« Previous Links','','','','',0,0,0),(224,16,'more_links','More Links »','','','','',0,0,0),(225,16,'enter_name','Please enter your name.','','','','',0,0,0),(226,16,'enter_site_name','Please enter the name of the site.','','','','',0,0,0),(227,16,'enter_site_url','Please enter the url of the site.','','','','',0,0,0),(228,16,'url_invalid','Website URL is invalid.','','','','',0,0,0),(229,16,'enter_description','Please enter the description.','','','','',0,0,0),(230,16,'link_submitted','Thanks! Your link has been submitted.','','','','',1,0,0),(231,16,'notify_email_from','Link Directory Plugin','','','','',0,0,0),(232,16,'notify_email_subject','New link submitted to your website!','','','','',0,0,0),(233,16,'notify_email_message','A new link has been submitted to your link directory.','','','','',0,0,0),(234,16,'notify_email_author','Author','','','','',0,0,0),(235,16,'notify_email_website','Website Name','','','','',0,0,0),(236,16,'notify_email_url','Website URL','','','','',0,0,0),(237,16,'notify_email_description','Description','','','','',0,0,0),(238,17,'sections','Sections:','','','','',1,0,0),(239,17,'no_gif_support','Images with the .gif extension are not supported.','','','','',0,0,0),(240,17,'previous_images','« Previous Images','','','','',0,0,0),(241,17,'more_images','More Images »','','','','',0,0,0),(242,17,'submitted_by','Submitted by:','','','','',0,0,0),(243,17,'submit_an_image','Submit an image to this section.','','','','',0,0,0),(244,17,'submitting_image','Submitting Image','','','','',0,0,0),(245,17,'your_name','Your Name:','','','','',1,0,0),(246,17,'description','Description:','','','','',1,0,0),(247,17,'thumbnail','Thumbnail:','','','','',1,0,0),(248,17,'image','Image:','','','','',1,0,0),(249,17,'submit_image','Submit Image','','','','',0,0,0),(250,17,'image_title','Title:','','','','',1,0,0),(251,17,'enter_title','Please enter a title.','','','','',1,0,0),(252,17,'enter_author','Please enter the author\'s name.','','','','',0,0,0),(253,17,'select_image','Please select an image.','','','','',0,0,0),(254,17,'select_thumbnail','Please select a thumbnail.','','','','',0,0,0),(255,17,'enter_description','Please enter a description.','','','','',0,0,0),(256,17,'image_submitted','Thanks! Your image has been submitted. ','','','','',1,0,0),(257,17,'previous_image','« Previous Image','','','','',0,0,0),(258,17,'next_image','Next Image »','','','','',0,0,0),(259,17,'invalid_image_type','Invalid image type.','','','','',0,0,0),(260,17,'views','Views','','','','',0,0,0),(261,17,'jump_to','Jump To...','','','','',0,0,0),(262,17,'comments','Comments','','','','',0,0,0),(263,17,'comment','Comment','','','','',0,0,0),(264,17,'image2','Image','','','','',0,0,0),(265,17,'images','Images','','','','',0,0,0),(266,17,'images2','Images:','','','','',1,0,0),(267,17,'notify_email_from','Image Gallery Plugin','','','','',0,0,0),(268,17,'notify_email_subject','New image submitted to your website!','','','','',0,0,0),(269,17,'notify_email_message','A new image has been submitted to your image gallery.','','','','',0,0,0),(270,17,'notify_email_author','Author','','','','',0,0,0),(271,17,'notify_email_title','Title','','','','',0,0,0),(272,17,'notify_email_description','Description','','','','',0,0,0),(273,1,'refresh','Refresh','','','','',0,0,0),(274,6,'message_first_line','Contact Form sent by:','','','','',1,0,0);
/*!40000 ALTER TABLE `sd_phrases` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_plugins`
--
DROP TABLE IF EXISTS `sd_plugins`;
CREATE TABLE `sd_plugins` (
`pluginid` int(10) unsigned NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`displayname` varchar(64) NOT NULL default '',
`version` varchar(10) NOT NULL default '',
`pluginpath` varchar(64) NOT NULL default '',
`settingspath` varchar(64) NOT NULL default '',
`authorname` varchar(32) NOT NULL default '',
`authorlink` int(10) unsigned NOT NULL default '0',
`settings` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pluginid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_plugins`
--
LOCK TABLES `sd_plugins` WRITE;
/*!40000 ALTER TABLE `sd_plugins` DISABLE KEYS */;
INSERT INTO `sd_plugins` (`pluginid`, `name`, `displayname`, `version`, `pluginpath`, `settingspath`, `authorname`, `authorlink`, `settings`) VALUES (1,'--empty--','','','p1_empty/empty.php','','subdreamer',1,19),(2,'Articles','Articles','2.0','p2_news/news.php','p2_news/p2_settings.php','subdreamer',1,27),(3,'Latest Articles','Latest Articles','2.0','p3_latestnews/latestnews.php','p3_latestnews/p3_settings.php','subdreamer',1,17),(4,'Guestbook','Guestbook','2.0','p4_guestbook/guestbook.php','p4_guestbook/p4_settings.php','subdreamer',1,19),(6,'Contact Form','Contact us!','2.1.0','p6_contact_form/contactform.php','p6_contact_form/p6_settings.php','subdreamer',1,19),(7,'Chatterbox','Chatterbox','2.0','p7_chatterbox/chatterbox.php','p7_chatterbox/p7_settings.php','subdreamer',1,19),(8,'Latest Posts','Latest Posts','2.0','p8_latest_posts/latestposts.php','p8_latest_posts/p8_settings.php','subdreamer',1,17),(9,'Top Posters','Top Posters','2.0','p9_top_posters/topposters.php','p9_top_posters/p9_settings.php','subdreamer',1,17),(10,'MI - Login Panel','Login Panel','2.0','p10_mi_loginpanel/loginpanel.php','p10_mi_loginpanel/p10_settings.php','subdreamer',1,17),(11,'MI - User CP','User CP','2.0','p11_mi_usercp/usercp.php','p11_mi_usercp/p11_settings.php','subdreamer',1,17),(12,'MI - Registration','Registration','2.0','p12_mi_registration/register.php','p12_mi_registration/p12_settings.php','subdreamer',1,17),(16,'Link Directory','Link Directory','2.0','p16_link_directory/link_directory.php','p16_link_directory/p16_settings.php','subdreamer',1,19),(17,'Image Gallery','Image Gallery','2.0','p17_image_gallery/imagegallery.php','p17_image_gallery/p17_settings.php','subdreamer',1,27),(31,'Subcategory Menu','Subcategory Menu','1.0','p31_subcategory_menu/p31_subcategory_menu.php','p31_subcategory_menu/p31_settings.php','subdreamer',1,17);
/*!40000 ALTER TABLE `sd_plugins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sd_pluginsettings`
--
DROP TABLE IF EXISTS `sd_pluginsettings`;
CREATE TABLE `sd_pluginsettings` (
`settingid` int(10) unsigned NOT NULL auto_increment,
`pluginid` int(10) unsigned NOT NULL default '0',
`groupname` varchar(100) NOT NULL default 'Options',
`title` varchar(100) NOT NULL default '',
`description` mediumtext NOT NULL,
`input` mediumtext NOT NULL,
`value` mediumtext NOT NULL,
`displayorder` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`settingid`),
KEY `pluginid` (`pluginid`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sd_pluginsettings`
--
LOCK TABLES `sd_pluginsettings` WRITE;
/*!40000 ALTER TABLE `sd_pluginsettings` DISABLE KEYS */;
INSERT INTO `sd_pluginsettings` (`settingid`, `pluginid`, `groupname`, `title`, `description`, `input`, `value`, `displayorder`) VALUES (1,2,'Article Display Settings','','Display Title','yesno','1',1),(2,2,'Article Display Settings','','Display Author','yesno','1',2),(3,2,'Article Display Settings','','Display Creation Date','yesno','1',3),(4,2,'Article Display Settings','','Display Updated Date','yesno','1',4),(5,2,'Article Display Settings','','Display Print Article Link','yesno','1',5),(6,2,'Article Display Settings','','Display Email Article Link','yesno','1',6),(7,2,'Article Display Settings','','Display Description Inside Article','yesno','0',7),(8,2,'Article Display Settings','','Display Smilie Images','yesno','1',8),(9,2,'Article Display Settings','','Display User Comments','yesno','1',9),(10,2,'Article Display Settings','','Display Views Count','yesno','0',10),(11,2,'Article Display Settings','','Display on main page listing','yesno','1',11),(12,2,'Article Display Settings','','Display as Sticky','yesno','0',12),(13,2,'Options','Article Notification','This email address will receive an email message when a new article is submitted from a user/guest: Leave this blank if you prefer not to receive an email. \r\nSeparate multiple addresses with commas.','text','',1),(14,2,'Options','Auto Approve News','Automatically approve user submitted news items?','yesno','0',2),(15,2,'Options','Enable Email Articles','Allow users to email articles to a friend?','yesno','1',3),(16,2,'Options','Require VVC Code','Require users to enter a Visual Verify Code to email to a friend?','yesno','1',4),(17,3,'Options','Limit','The Latest News plugin will display links to the most recent news on your site. Enter the number of links to be shown:','text','10',1),(18,3,'Options','Category Targeting','Only display the latest news of the category which the latest news plugin resides in. Include Categories or Matching Categories will not work if targeting is on.','yesno','0',2),(19,3,'Options','Include Categories','Enter the ID\'s of the categories you want to select latest news from, separate values with comma. Leave empty to select news from all categories. It can also be used together with the Matching Categories option.','text','',3),(20,3,'Options','Matching Categories','This option makes it possible to to select latest news from the category of your choice, separate values with comma. This will only work together with the Include Categories option. If the Include Categories has the value \'1, 3\' and this field has the value \'2, 6\' it means: If this plugin is placed in category 1, display latest news from category 2. If the plugin is placed in category 3, display latest news from category 6. Leave this field empty if you don\'t want to use this option.','text','',4),(21,3,'Options','Sorting','How would you like your articles to be sorted (the latest news plugin always selects the latest news, but this option makes it possible to sort within those articles and within groups if you are using the Grouping option below)?','','newest',5),(22,3,'Options','Display Category Name','Display category name to the right of each news title?','yesno','0',6),(23,3,'Options','Display Description','Display description under each news title?','yesno','0',7),(24,3,'Options','Read More','Display \'Read more...\' link for each news article (it will use the language settings for the news plugin)?','yesno','0',8),(25,3,'Options','Display Author','Display author name under each news article?','yesno','0',9),(26,3,'Options','Display Creation Date','Display creation date under each news article?','yesno','0',10),(27,3,'Options','Display Updated Date','Display updated date under each news article?','yesno','0',11),(28,3,'Options','Display Print Article Option','Display the print article option for your readers?','yesno','0',12),(29,3,'Options','Display Email Article Option','Display the email article option for your readers?','yesno','0',13),(30,3,'Options','Bold Title','Do you want the title of each news article to be bold?','yesno','0',14),(31,3,'Options','Title Link','Do you want to convert the title of each news article into a link?','yesno','1',15),(32,3,'Options','Grouping','How would you like your articles to be grouped?','','nothing',16),(33,3,'Options','Category Link','Do you want to use the category name as a link to the category? This will only work if you group articles by category name or if you choose do display category names to the right of each article.','yesno','0',17),(34,3,'Options','Group Separator','Add or remove tags if you want change the space between groups of articles.','text',' ',18),(35,3,'Options','Group/Article Separator','Add or remove tags if you want to change the space between group header and articles.','text',' ',19),(36,3,'Options','News Article Separator','Add or remove tags if you want to change the space between news articles (only works when grouping is off).','text',' ',20),(37,4,'Options','Enable Smilies','If you enable smilies, then certain combinations of characters will change into images.','yesno','1',2),(38,4,'Options','Messages Per Page','Enter the number of messages you would you like to see in the guesbook:','text','5',3),(39,4,'Options','Message Length','Please enter the maximum length a message can be: (in characters)','text','100',4),(40,4,'Options','Word Wrap','Wraps a string to the given number of characters: (0 = disabled)','text','0',5),(41,4,'Options','Show Post Date','Show the date the message was posted?: ','yesno','1',6),(42,4,'Options','Require VVC Code','Require users to enter a Visual Verify Code to post a message?','yesno','1',7),(43,6,'Options','Email','Enter the email address where the submitted contact forms should be sent to: \r\nSeparate multiple addresses with commas.','text','phpcs@dealerscript.com',1),(44,6,'Options','Allow Attachments','Allow users to send you attachments?','yesno','0',2),(45,6,'Options','Require VVC Code','Require users to enter a Visual Verify Code to submit form?','yesno','1',3),(46,7,'Options','Enable Smilies','If smilies are enabled, then certain combinations of characters will be change into images.','yesno','1',2),(47,7,'Options','Number of comments to display','Select the number of comments you would like to be displayed in your chatterbox:','text','5',3),(48,7,'Options','Word Wrap','Wraps a string to the given number of characters:','text','30',4),(49,7,'Options','Maximum Username Length','Enter the maximum length in characters for the username:','text','15',5),(50,7,'Options','Maximum Comment Length','Enter the maximum length in characters for the Comment:','text','35',6),(51,7,'Options','Category Targeting','Only display messages which were posted in the category where the Chatterbox resides.','yesno','1',7),(52,7,'Options','Chatterbox History','Display a link to a popup window that displays the message history of your chatterbox.','yesno','1',8),(53,7,'Options','Maximum History Length','Enter the maxium number of days of messages to display in the message history of your chatterbox. (Enter 0 for unlimited)','text','0',9),(54,7,'Options','Display Date','Display the date and time the message was posted?','yesno','1',10),(55,7,'Options','Time Format','Format in which the time is presented:
Please consult your server administrator for more information.','a0647bfe8fb2eec5eb42243bd401402c'),(2,1196990178,1,'64.136.215.254','?action=post2;start=0;board=7','The upload folder is full. Please try a smaller file and/or contact an administrator.','a0647bfe8fb2eec5eb42243bd401402c'),(3,1197473932,0,'87.196.123.118','?action=login2','Password incorrect - <span class="remove">jsilva</span>','9d8fdf23b790744dc2b02a45b88b470f'),(4,1198122570,14,'24.31.181.231','?action=search2','8: Undefined index: brd File: /home/dealersc/public_html/forum/Sources/Search.php Line: 407','c32787490551062ec3a7aa81624bc7fd'),(5,1198962614,0,'64.136.215.254','?action=login2','Password incorrect - <span class="remove">phpcs</span>','76301ab7ef1a7af1aec9ca6addda0747');
/*!40000 ALTER TABLE `smf_log_errors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_floodcontrol`
--
DROP TABLE IF EXISTS `smf_log_floodcontrol`;
CREATE TABLE `smf_log_floodcontrol` (
`ip` char(16) NOT NULL default '',
`logTime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_floodcontrol`
--
LOCK TABLES `smf_log_floodcontrol` WRITE;
/*!40000 ALTER TABLE `smf_log_floodcontrol` DISABLE KEYS */;
INSERT INTO `smf_log_floodcontrol` (`ip`, `logTime`) VALUES ('12.218.206.206',1199140209);
/*!40000 ALTER TABLE `smf_log_floodcontrol` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_karma`
--
DROP TABLE IF EXISTS `smf_log_karma`;
CREATE TABLE `smf_log_karma` (
`ID_TARGET` mediumint(8) unsigned NOT NULL default '0',
`ID_EXECUTOR` mediumint(8) unsigned NOT NULL default '0',
`logTime` int(10) unsigned NOT NULL default '0',
`action` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID_TARGET`,`ID_EXECUTOR`),
KEY `logTime` (`logTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_karma`
--
LOCK TABLES `smf_log_karma` WRITE;
/*!40000 ALTER TABLE `smf_log_karma` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_karma` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_mark_read`
--
DROP TABLE IF EXISTS `smf_log_mark_read`;
CREATE TABLE `smf_log_mark_read` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`ID_MSG` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_MEMBER`,`ID_BOARD`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_mark_read`
--
LOCK TABLES `smf_log_mark_read` WRITE;
/*!40000 ALTER TABLE `smf_log_mark_read` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_mark_read` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_notify`
--
DROP TABLE IF EXISTS `smf_log_notify`;
CREATE TABLE `smf_log_notify` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`sent` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_MEMBER`,`ID_TOPIC`,`ID_BOARD`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_notify`
--
LOCK TABLES `smf_log_notify` WRITE;
/*!40000 ALTER TABLE `smf_log_notify` DISABLE KEYS */;
INSERT INTO `smf_log_notify` (`ID_MEMBER`, `ID_TOPIC`, `ID_BOARD`, `sent`) VALUES (6,7,0,0);
/*!40000 ALTER TABLE `smf_log_notify` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_online`
--
DROP TABLE IF EXISTS `smf_log_online`;
CREATE TABLE `smf_log_online` (
`session` varchar(32) NOT NULL default '',
`logTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`url` text NOT NULL,
PRIMARY KEY (`session`),
KEY `logTime` (`logTime`),
KEY `ID_MEMBER` (`ID_MEMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_online`
--
LOCK TABLES `smf_log_online` WRITE;
/*!40000 ALTER TABLE `smf_log_online` DISABLE KEYS */;
INSERT INTO `smf_log_online` (`session`, `logTime`, `ID_MEMBER`, `ip`, `url`) VALUES ('d49bb2c8929c5df4eeed73aaf5482e6e','2007-12-31 16:31:03',1,215666382,'a:2:{s:5:\"board\";i:7;s:10:\"USER_AGENT\";s:118:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)\";}');
/*!40000 ALTER TABLE `smf_log_online` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_polls`
--
DROP TABLE IF EXISTS `smf_log_polls`;
CREATE TABLE `smf_log_polls` (
`ID_POLL` mediumint(8) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ID_CHOICE` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_POLL`,`ID_MEMBER`,`ID_CHOICE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_polls`
--
LOCK TABLES `smf_log_polls` WRITE;
/*!40000 ALTER TABLE `smf_log_polls` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_polls` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_search_messages`
--
DROP TABLE IF EXISTS `smf_log_search_messages`;
CREATE TABLE `smf_log_search_messages` (
`ID_SEARCH` tinyint(3) unsigned NOT NULL default '0',
`ID_MSG` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_SEARCH`,`ID_MSG`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_search_messages`
--
LOCK TABLES `smf_log_search_messages` WRITE;
/*!40000 ALTER TABLE `smf_log_search_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_search_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_search_results`
--
DROP TABLE IF EXISTS `smf_log_search_results`;
CREATE TABLE `smf_log_search_results` (
`ID_SEARCH` tinyint(3) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`ID_MSG` int(10) unsigned NOT NULL default '0',
`relevance` smallint(5) unsigned NOT NULL default '0',
`num_matches` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_SEARCH`,`ID_TOPIC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_search_results`
--
LOCK TABLES `smf_log_search_results` WRITE;
/*!40000 ALTER TABLE `smf_log_search_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_search_results` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_search_subjects`
--
DROP TABLE IF EXISTS `smf_log_search_subjects`;
CREATE TABLE `smf_log_search_subjects` (
`word` varchar(20) NOT NULL default '',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`word`,`ID_TOPIC`),
KEY `ID_TOPIC` (`ID_TOPIC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_search_subjects`
--
LOCK TABLES `smf_log_search_subjects` WRITE;
/*!40000 ALTER TABLE `smf_log_search_subjects` DISABLE KEYS */;
INSERT INTO `smf_log_search_subjects` (`word`, `ID_TOPIC`) VALUES ('a',7),('as',7),('check',11),('com',10),('could',7),('data',7),('dealerscript',10),('for',11),('here',11),('i',7),('it',7),('patches',11),('plugins',11),('site',7),('to',10),('use',7),('welcome',10);
/*!40000 ALTER TABLE `smf_log_search_subjects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_search_topics`
--
DROP TABLE IF EXISTS `smf_log_search_topics`;
CREATE TABLE `smf_log_search_topics` (
`ID_SEARCH` tinyint(3) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ID_SEARCH`,`ID_TOPIC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_search_topics`
--
LOCK TABLES `smf_log_search_topics` WRITE;
/*!40000 ALTER TABLE `smf_log_search_topics` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_log_search_topics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_log_topics`
--
DROP TABLE IF EXISTS `smf_log_topics`;
CREATE TABLE `smf_log_topics` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`ID_MSG` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_MEMBER`,`ID_TOPIC`),
KEY `ID_TOPIC` (`ID_TOPIC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_log_topics`
--
LOCK TABLES `smf_log_topics` WRITE;
/*!40000 ALTER TABLE `smf_log_topics` DISABLE KEYS */;
INSERT INTO `smf_log_topics` (`ID_MEMBER`, `ID_TOPIC`, `ID_MSG`) VALUES (6,7,12),(1,7,13),(5,7,13),(10,7,13),(12,7,12),(3,7,13),(15,7,13),(1,11,16),(16,7,13),(2,7,13),(1,10,16);
/*!40000 ALTER TABLE `smf_log_topics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_membergroups`
--
DROP TABLE IF EXISTS `smf_membergroups`;
CREATE TABLE `smf_membergroups` (
`ID_GROUP` smallint(5) unsigned NOT NULL auto_increment,
`groupName` varchar(80) NOT NULL default '',
`onlineColor` varchar(20) NOT NULL default '',
`minPosts` mediumint(9) NOT NULL default '-1',
`maxMessages` smallint(5) unsigned NOT NULL default '0',
`stars` tinytext NOT NULL,
PRIMARY KEY (`ID_GROUP`),
KEY `minPosts` (`minPosts`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_membergroups`
--
LOCK TABLES `smf_membergroups` WRITE;
/*!40000 ALTER TABLE `smf_membergroups` DISABLE KEYS */;
INSERT INTO `smf_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES (1,'Administrator','#FF0000',-1,0,'5#staradmin.gif'),(2,'Global Moderator','#0000FF',-1,0,'5#stargmod.gif'),(3,'Moderator','',-1,0,'5#starmod.gif'),(4,'Newbie','',0,0,'1#star.gif'),(5,'Jr. Member','',50,0,'2#star.gif'),(6,'Full Member','',100,0,'3#star.gif'),(7,'Sr. Member','',250,0,'4#star.gif'),(8,'Hero Member','',500,0,'5#star.gif'),(9,'Licensee','',-1,0,'1#star.gif'),(10,'Reseller','',-1,0,'1#star.gif');
/*!40000 ALTER TABLE `smf_membergroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_members`
--
DROP TABLE IF EXISTS `smf_members`;
CREATE TABLE `smf_members` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment,
`memberName` varchar(80) NOT NULL default '',
`dateRegistered` int(10) unsigned NOT NULL default '0',
`posts` mediumint(8) unsigned NOT NULL default '0',
`ID_GROUP` smallint(5) unsigned NOT NULL default '0',
`lngfile` tinytext NOT NULL,
`lastLogin` int(10) unsigned NOT NULL default '0',
`realName` tinytext NOT NULL,
`instantMessages` smallint(5) NOT NULL default '0',
`unreadMessages` smallint(5) NOT NULL default '0',
`buddy_list` text NOT NULL,
`pm_ignore_list` tinytext NOT NULL,
`messageLabels` text NOT NULL,
`passwd` varchar(64) NOT NULL default '',
`emailAddress` tinytext NOT NULL,
`personalText` tinytext NOT NULL,
`gender` tinyint(4) unsigned NOT NULL default '0',
`birthdate` date NOT NULL default '0001-01-01',
`websiteTitle` tinytext NOT NULL,
`websiteUrl` tinytext NOT NULL,
`location` tinytext NOT NULL,
`ICQ` tinytext NOT NULL,
`AIM` varchar(16) NOT NULL default '',
`YIM` varchar(32) NOT NULL default '',
`MSN` tinytext NOT NULL,
`hideEmail` tinyint(4) NOT NULL default '0',
`showOnline` tinyint(4) NOT NULL default '1',
`timeFormat` varchar(80) NOT NULL default '',
`signature` text NOT NULL,
`timeOffset` float NOT NULL default '0',
`avatar` tinytext NOT NULL,
`pm_email_notify` tinyint(4) NOT NULL default '0',
`karmaBad` smallint(5) unsigned NOT NULL default '0',
`karmaGood` smallint(5) unsigned NOT NULL default '0',
`usertitle` tinytext NOT NULL,
`notifyAnnouncements` tinyint(4) NOT NULL default '1',
`notifyOnce` tinyint(4) NOT NULL default '1',
`notifySendBody` tinyint(4) NOT NULL default '0',
`notifyTypes` tinyint(4) NOT NULL default '2',
`memberIP` tinytext NOT NULL,
`memberIP2` tinytext NOT NULL,
`secretQuestion` tinytext NOT NULL,
`secretAnswer` varchar(64) NOT NULL default '',
`ID_THEME` tinyint(4) unsigned NOT NULL default '0',
`is_activated` tinyint(3) unsigned NOT NULL default '1',
`validation_code` varchar(10) NOT NULL default '',
`ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0',
`additionalGroups` tinytext NOT NULL,
`smileySet` varchar(48) NOT NULL default '',
`ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0',
`totalTimeLoggedIn` int(10) unsigned NOT NULL default '0',
`passwordSalt` varchar(5) NOT NULL default '',
PRIMARY KEY (`ID_MEMBER`),
KEY `memberName` (`memberName`(30)),
KEY `dateRegistered` (`dateRegistered`),
KEY `ID_GROUP` (`ID_GROUP`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`lastLogin`),
KEY `lngfile` (`lngfile`(30)),
KEY `ID_POST_GROUP` (`ID_POST_GROUP`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_members`
--
LOCK TABLES `smf_members` WRITE;
/*!40000 ALTER TABLE `smf_members` DISABLE KEYS */;
INSERT INTO `smf_members` (`ID_MEMBER`, `memberName`, `dateRegistered`, `posts`, `ID_GROUP`, `lngfile`, `lastLogin`, `realName`, `instantMessages`, `unreadMessages`, `buddy_list`, `pm_ignore_list`, `messageLabels`, `passwd`, `emailAddress`, `personalText`, `gender`, `birthdate`, `websiteTitle`, `websiteUrl`, `location`, `ICQ`, `AIM`, `YIM`, `MSN`, `hideEmail`, `showOnline`, `timeFormat`, `signature`, `timeOffset`, `avatar`, `pm_email_notify`, `karmaBad`, `karmaGood`, `usertitle`, `notifyAnnouncements`, `notifyOnce`, `notifySendBody`, `notifyTypes`, `memberIP`, `memberIP2`, `secretQuestion`, `secretAnswer`, `ID_THEME`, `is_activated`, `validation_code`, `ID_MSG_LAST_VISIT`, `additionalGroups`, `smileySet`, `ID_POST_GROUP`, `totalTimeLoggedIn`, `passwordSalt`) VALUES (1,'phpcs',1196838657,5,1,'',1199140209,'phpcs',3,0,'','','','fa5c1d4ecca2a6250696b9eee5c7158eafc78a17','dealerscript@mchsi.com','',0,'0001-01-01','','','','','','','',1,1,'%B %d, %Y, %I:%M:%S %p','',0,'',0,0,0,'',1,1,0,2,'12.218.206.206','12.218.206.206','who','d1457b72c3fb323a2671125aef3eab5d',0,1,'',16,'','',4,12398,'df82'),(2,'Bill_K',1196984829,0,9,'',1198473932,'Bill_K',0,0,'','','','98e033bdfb50425229dcc279d6869dd41993d7c9','billk68@hotmail.com','',0,'0001-01-01','','','','','','','',1,1,'','',0,'',1,0,0,'',1,1,0,2,'68.187.70.60','68.187.70.60','','',0,1,'',13,'','',4,72,'4450'),(3,'comtec',1196994782,0,10,'',1198377708,'comtec',2,0,'','','','8664c2bf08a8dc15764b8526e0e7c1682c85aa37','info@comtecservices.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'70.152.115.250','70.152.115.250','','',0,1,'',13,'','',4,692,'77b7'),(4,'jsilva',1197021313,0,0,'',1197474032,'jsilva',0,0,'','','','aacd9b52dc8c4f2121acd11682f635e5c94ea4d8','jptsantossilva@gmail.com','',1,'0001-01-01','','','Portugal','','','','',1,1,'','',0,'',1,0,0,'',1,1,0,2,'87.196.123.118','87.196.123.118','','',0,1,'',12,'','',4,1006,'35ec'),(5,'Primeisp',1197136557,0,9,'',1198513743,'Primeisp',1,0,'','','','42befa1fd5534addd264f7baeec2a9da1813e0e3','support@primeisp.net','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'76.6.46.96','76.6.46.96','','',0,1,'',13,'','',4,2046,'266d'),(6,'Gpro',1197157130,3,0,'',1197173304,'Gpro',0,0,'','','','d6b2843f93846f4fa18c8f38c835f6141fe26ce8','360ferrari@gmail.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'89.242.82.97','89.242.82.97','','',0,1,'',6,'','',4,792,'9905'),(7,'dvst8',1197394404,0,0,'',1197394405,'dvst8',0,0,'','','','8ad66edfa2c36d25ddc8046111790b138f6d803e','j_nghiem@hotmail.com','',0,'0001-01-01','','','','','','','',1,1,'','',0,'',1,0,0,'',1,1,0,2,'24.84.14.73','24.84.14.73','','',0,1,'',12,'','',4,0,'9ae3'),(8,'FFrancis',1197590031,0,10,'',1197894527,'FFrancis',0,0,'','','','5fd354122f5cc1382982deb5ca48d8850abac930','me@fadi5.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'192.84.68.140','192.84.68.140','','',0,1,'',12,'','',4,0,'9791'),(9,'jennymirr',1197594977,0,0,'',1197594977,'jennymirr',0,0,'','','','f1cf617c0ad56051bd5c61121d5b591812f37fcd','jennymirr@gmail.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'71.136.33.47','71.136.33.47','','',0,1,'',12,'','',4,0,'f9fc'),(10,'bestauto',1197599279,0,0,'',1198040378,'Max',0,0,'','','','7d95965043a1f83e7931686b66e197c82c6ba2c4','Maxasefi@gmail.com','',0,'0001-01-01','','','','','','','',1,1,'','',0,'',1,0,0,'',1,1,0,2,'68.100.108.35','68.100.108.35','','',0,1,'',13,'','',4,2570,'eba1'),(11,'ionelionel',1197635790,0,10,'',1197635897,'ionelionel',0,0,'','','','cb807c39408fcc0ef8c4333a5035d4581303f01f','p23gigi@yahoo.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'85.180.42.26','85.180.42.26','','',0,1,'',12,'','',4,154,'52ea'),(12,'leelee',1197721212,0,0,'',1197721212,'leelee',0,0,'','','','1f3c74ee18dbffbfc0488eb5634cd1738703a2c8','leemarshdesign@zoom.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'172.200.149.8','172.200.149.8','','',0,1,'',12,'','',4,0,'1919'),(13,'lubbockwebguy',1197954885,0,10,'',1198045619,'lubbockwebguy',0,0,'','','','c3143f2c1c42165b76efb5a15266667e38f0ef38','info@redosites.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'65.182.85.147','65.182.85.147','','',0,1,'',13,'','',4,377,'3faf'),(14,'Rogert',1197991560,0,9,'',1198186730,'Rogert',0,0,'','','','6fb1feac21152cd5ff30d0742ddb008298ecc0f0','Rogerweb2@columbus.rr.com','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'24.31.181.231','24.31.181.231','','',0,1,'',13,'','',4,906,'bcec'),(15,'rustysbiz',1198104230,0,9,'',1198104523,'rustysbiz',0,0,'','','','c33165dd8e133cfd3649af1e113b50dcbb6add6b','sales@rustys.biz','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'74.93.185.13','74.93.185.13','','',0,1,'',13,'','',4,854,'42dd'),(16,'Kristopher424',1198119250,0,9,'',1198389930,'Kristopher424',0,0,'','','','0bd08a997d4b156e682472477135e68c630a05ab','kristopher.minnich@gmail.com','',1,'0001-01-01','','','Kingman, Arizona, USA','','','','',1,1,'','-Kristopher',0,'',1,0,0,'',1,1,0,2,'24.121.136.71','24.121.136.71','','',0,1,'',13,'','',4,2034,'5890'),(17,'DealerGuy',1198987525,0,0,'',0,'DealerGuy',0,0,'','','','60fddd6783af927a928a94245b29c1f406b89ace','website_sales@mchsi.com','',0,'0001-01-01','','','','','','','',1,1,'','',0,'',1,0,0,'',1,1,0,2,'12.218.206.206','12.218.206.206','','',0,1,'',0,'','',4,0,'a180');
/*!40000 ALTER TABLE `smf_members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_message_icons`
--
DROP TABLE IF EXISTS `smf_message_icons`;
CREATE TABLE `smf_message_icons` (
`ID_ICON` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(80) NOT NULL default '',
`filename` varchar(80) NOT NULL default '',
`ID_BOARD` mediumint(8) unsigned NOT NULL default '0',
`iconOrder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_ICON`),
KEY `ID_BOARD` (`ID_BOARD`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_message_icons`
--
LOCK TABLES `smf_message_icons` WRITE;
/*!40000 ALTER TABLE `smf_message_icons` DISABLE KEYS */;
INSERT INTO `smf_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES (1,'Standard','xx',0,0),(2,'Thumb Up','thumbup',0,1),(3,'Thumb Down','thumbdown',0,2),(4,'Exclamation point','exclamation',0,3),(5,'Question mark','question',0,4),(6,'Lamp','lamp',0,5),(7,'Smiley','smiley',0,6),(8,'Angry','angry',0,7),(9,'Cheesy','cheesy',0,8),(10,'Grin','grin',0,9),(11,'Sad','sad',0,10),(12,'Wink','wink',0,11);
/*!40000 ALTER TABLE `smf_message_icons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_messages`
--
DROP TABLE IF EXISTS `smf_messages`;
CREATE TABLE `smf_messages` (
`ID_MSG` int(10) unsigned NOT NULL auto_increment,
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`posterTime` int(10) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`ID_MSG_MODIFIED` int(10) unsigned NOT NULL default '0',
`subject` tinytext NOT NULL,
`posterName` tinytext NOT NULL,
`posterEmail` tinytext NOT NULL,
`posterIP` tinytext NOT NULL,
`smileysEnabled` tinyint(4) NOT NULL default '1',
`modifiedTime` int(10) unsigned NOT NULL default '0',
`modifiedName` tinytext NOT NULL,
`body` text NOT NULL,
`icon` varchar(16) NOT NULL default 'xx',
PRIMARY KEY (`ID_MSG`),
UNIQUE KEY `topic` (`ID_TOPIC`,`ID_MSG`),
UNIQUE KEY `ID_BOARD` (`ID_BOARD`,`ID_MSG`),
UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_MSG`),
KEY `ipIndex` (`posterIP`(15),`ID_TOPIC`),
KEY `participation` (`ID_MEMBER`,`ID_TOPIC`),
KEY `showPosts` (`ID_MEMBER`,`ID_BOARD`),
KEY `ID_TOPIC` (`ID_TOPIC`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_messages`
--
LOCK TABLES `smf_messages` WRITE;
/*!40000 ALTER TABLE `smf_messages` DISABLE KEYS */;
INSERT INTO `smf_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, `posterTime`, `ID_MEMBER`, `ID_MSG_MODIFIED`, `subject`, `posterName`, `posterEmail`, `posterIP`, `smileysEnabled`, `modifiedTime`, `modifiedName`, `body`, `icon`) VALUES (16,11,7,1199126730,1,16,'Check Here For Patches & Plugins','phpcs','dealerscript@mchsi.com','12.218.206.206',1,0,'','Check Here For Patches, Plugins & MORE !','xx'),(7,7,2,1197157563,6,7,'could i use it as a data site','Gpro','360ferrari@gmail.com','89.242.82.97',1,0,'','Could i use this script as a data site like fast-autos.net/ What i mean is. could it be possible in the admin panel to remove price, contact details and if its used or new.
','xx'),(8,7,2,1197166441,1,8,'Re: could i use it as a data site','phpcs','support@dealerscript.com','64.136.215.254',1,0,'','With minor modifications, such as those you mentioned, it would be possible.','xx'),(9,7,2,1197170774,6,9,'Re: could i use it as a data site','Gpro','360ferrari@gmail.com','89.242.82.97',1,0,'','if i wanted addons/modifications like members register login etc could you do that with an extra cost? or do u not modify the script','xx'),(10,7,2,1197171198,1,10,'Re: could i use it as a data site','phpcs','support@dealerscript.com','64.136.215.254',1,0,'','Yes, we can modify the script to fit your specific needs.','xx'),(11,7,2,1197171374,6,11,'Re: could i use it as a data site','Gpro','360ferrari@gmail.com','89.242.82.97',1,0,'','ok i will get in contact with you within the next few weeks when i have some more money. i will definatly be doing business with you','xx'),(12,7,2,1197172058,1,12,'Re: could i use it as a data site','phpcs','support@dealerscript.com','64.136.215.254',1,0,'','Thanks for your consideration and we look forward to working with you.','xx'),(15,10,6,1199125968,1,16,'Welcome to DealerScript.com !','phpcs','dealerscript@mchsi.com','12.218.206.206',1,1199140252,'phpcs','Welcome to DealerScript !','xx');
/*!40000 ALTER TABLE `smf_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_moderators`
--
DROP TABLE IF EXISTS `smf_moderators`;
CREATE TABLE `smf_moderators` (
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_BOARD`,`ID_MEMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_moderators`
--
LOCK TABLES `smf_moderators` WRITE;
/*!40000 ALTER TABLE `smf_moderators` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_moderators` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_package_servers`
--
DROP TABLE IF EXISTS `smf_package_servers`;
CREATE TABLE `smf_package_servers` (
`ID_SERVER` smallint(5) unsigned NOT NULL auto_increment,
`name` tinytext NOT NULL,
`url` tinytext NOT NULL,
PRIMARY KEY (`ID_SERVER`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_package_servers`
--
LOCK TABLES `smf_package_servers` WRITE;
/*!40000 ALTER TABLE `smf_package_servers` DISABLE KEYS */;
INSERT INTO `smf_package_servers` (`ID_SERVER`, `name`, `url`) VALUES (1,'Simple Machines Third-party Mod Site','http://mods.simplemachines.org');
/*!40000 ALTER TABLE `smf_package_servers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_permissions`
--
DROP TABLE IF EXISTS `smf_permissions`;
CREATE TABLE `smf_permissions` (
`ID_GROUP` smallint(5) NOT NULL default '0',
`permission` varchar(30) NOT NULL default '',
`addDeny` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`ID_GROUP`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_permissions`
--
LOCK TABLES `smf_permissions` WRITE;
/*!40000 ALTER TABLE `smf_permissions` DISABLE KEYS */;
INSERT INTO `smf_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES (-1,'search_posts',1),(-1,'calendar_view',1),(-1,'view_stats',1),(-1,'profile_view_any',1),(0,'view_mlist',1),(0,'search_posts',1),(0,'profile_view_own',1),(0,'profile_view_any',1),(0,'pm_read',1),(0,'pm_send',1),(0,'calendar_view',1),(0,'view_stats',1),(0,'who_view',1),(0,'profile_identity_own',1),(0,'profile_extra_own',1),(0,'profile_remove_own',1),(0,'profile_server_avatar',1),(0,'profile_upload_avatar',1),(0,'profile_remote_avatar',1),(0,'karma_edit',1),(2,'view_mlist',1),(2,'search_posts',1),(2,'profile_view_own',1),(2,'profile_view_any',1),(2,'pm_read',1),(2,'pm_send',1),(2,'calendar_view',1),(2,'view_stats',1),(2,'who_view',1),(2,'profile_identity_own',1),(2,'profile_extra_own',1),(2,'profile_remove_own',1),(2,'profile_server_avatar',1),(2,'profile_upload_avatar',1),(2,'profile_remote_avatar',1),(2,'profile_title_own',1),(2,'calendar_post',1),(2,'calendar_edit_any',1),(2,'karma_edit',1),(9,'calendar_view',1),(9,'karma_edit',1),(9,'pm_read',1),(9,'pm_send',1),(9,'profile_extra_own',1),(9,'profile_identity_own',1),(9,'profile_remote_avatar',1),(9,'profile_remove_own',1),(9,'profile_server_avatar',1),(9,'profile_upload_avatar',1),(9,'profile_view_any',1),(9,'profile_view_own',1),(9,'search_posts',1),(9,'view_mlist',1),(9,'view_stats',1),(9,'who_view',1),(10,'calendar_view',1),(10,'karma_edit',1),(10,'pm_read',1),(10,'pm_send',1),(10,'profile_extra_own',1),(10,'profile_identity_own',1),(10,'profile_remote_avatar',1),(10,'profile_remove_own',1),(10,'profile_server_avatar',1),(10,'profile_upload_avatar',1),(10,'profile_view_any',1),(10,'profile_view_own',1),(10,'search_posts',1),(10,'view_mlist',1),(10,'view_stats',1),(10,'who_view',1);
/*!40000 ALTER TABLE `smf_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_personal_messages`
--
DROP TABLE IF EXISTS `smf_personal_messages`;
CREATE TABLE `smf_personal_messages` (
`ID_PM` int(10) unsigned NOT NULL auto_increment,
`ID_MEMBER_FROM` mediumint(8) unsigned NOT NULL default '0',
`deletedBySender` tinyint(3) unsigned NOT NULL default '0',
`fromName` tinytext NOT NULL,
`msgtime` int(10) unsigned NOT NULL default '0',
`subject` tinytext NOT NULL,
`body` text NOT NULL,
PRIMARY KEY (`ID_PM`),
KEY `ID_MEMBER` (`ID_MEMBER_FROM`,`deletedBySender`),
KEY `msgtime` (`msgtime`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_personal_messages`
--
LOCK TABLES `smf_personal_messages` WRITE;
/*!40000 ALTER TABLE `smf_personal_messages` DISABLE KEYS */;
INSERT INTO `smf_personal_messages` (`ID_PM`, `ID_MEMBER_FROM`, `deletedBySender`, `fromName`, `msgtime`, `subject`, `body`) VALUES (1,3,0,'comtec',1197045529,'new dealer script','Are you going to have a new version coming out soon?
If so what features will be included in the new version?
Also how long before the new version will be available?
Angelia'),(2,1,1,'phpcs',1197118161,'Re: new dealer script','A version with a CSV import/export tool and modified statistical reporting is planned in the near future. Do you have any suggestions as to what should be included in the next release?
Happy Holidays.'),(3,5,0,'Primeisp',1197137371,'Purched sDealer','Purchased sDealer at support@primeisp.net using Paypal Website: http://www.sussexmotors.com'),(4,3,0,'comtec',1197155146,'Re: new dealer script','I would like to see a couple of new templates or if there is a way to make the templates easier to modify.
The last company talked about ebay integration. I do not know if that could be ready for the next release.
Do you think the new version will be available before the new year?'),(5,1,1,'phpcs',1197187819,'Re: new dealer script','It should be.');
/*!40000 ALTER TABLE `smf_personal_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_pm_recipients`
--
DROP TABLE IF EXISTS `smf_pm_recipients`;
CREATE TABLE `smf_pm_recipients` (
`ID_PM` int(10) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`labels` varchar(60) NOT NULL default '-1',
`bcc` tinyint(3) unsigned NOT NULL default '0',
`is_read` tinyint(3) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_PM`,`ID_MEMBER`),
UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`deleted`,`ID_PM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_pm_recipients`
--
LOCK TABLES `smf_pm_recipients` WRITE;
/*!40000 ALTER TABLE `smf_pm_recipients` DISABLE KEYS */;
INSERT INTO `smf_pm_recipients` (`ID_PM`, `ID_MEMBER`, `labels`, `bcc`, `is_read`, `deleted`) VALUES (1,1,'-1',0,3,0),(2,3,'-1',0,3,0),(3,1,'-1',0,1,0),(3,5,'-1',1,1,0),(4,1,'-1',0,3,0),(5,3,'-1',0,1,0);
/*!40000 ALTER TABLE `smf_pm_recipients` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_poll_choices`
--
DROP TABLE IF EXISTS `smf_poll_choices`;
CREATE TABLE `smf_poll_choices` (
`ID_POLL` mediumint(8) unsigned NOT NULL default '0',
`ID_CHOICE` tinyint(3) unsigned NOT NULL default '0',
`label` tinytext NOT NULL,
`votes` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_POLL`,`ID_CHOICE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_poll_choices`
--
LOCK TABLES `smf_poll_choices` WRITE;
/*!40000 ALTER TABLE `smf_poll_choices` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_poll_choices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_polls`
--
DROP TABLE IF EXISTS `smf_polls`;
CREATE TABLE `smf_polls` (
`ID_POLL` mediumint(8) unsigned NOT NULL auto_increment,
`question` tinytext NOT NULL,
`votingLocked` tinyint(1) NOT NULL default '0',
`maxVotes` tinyint(3) unsigned NOT NULL default '1',
`expireTime` int(10) unsigned NOT NULL default '0',
`hideResults` tinyint(3) unsigned NOT NULL default '0',
`changeVote` tinyint(3) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
`posterName` tinytext NOT NULL,
PRIMARY KEY (`ID_POLL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_polls`
--
LOCK TABLES `smf_polls` WRITE;
/*!40000 ALTER TABLE `smf_polls` DISABLE KEYS */;
/*!40000 ALTER TABLE `smf_polls` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_sessions`
--
DROP TABLE IF EXISTS `smf_sessions`;
CREATE TABLE `smf_sessions` (
`session_id` varchar(32) NOT NULL default '',
`last_update` int(10) unsigned NOT NULL default '0',
`data` text NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_sessions`
--
LOCK TABLES `smf_sessions` WRITE;
/*!40000 ALTER TABLE `smf_sessions` DISABLE KEYS */;
INSERT INTO `smf_sessions` (`session_id`, `last_update`, `data`) VALUES ('11f28bd2cb71730970a82c03eca0cf6d',1199128014,'rand_code|s:32:\"df37677efa3464244770bc6f362b7859\";ban|a:5:{s:12:\"last_checked\";i:1199126693;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:14:\"12.218.206.206\";s:3:\"ip2\";s:14:\"12.218.206.206\";s:5:\"email\";s:0:\"\";}log_time|i:1199128010;timeOnlineUpdated|i:1199128010;old_url|s:53:\"http://www.dealerscript.com/forum/index.php?board=7.0\";USER_AGENT|s:118:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)\";login_SMFCookie662|s:95:\"a:4:{i:0;s:1:\"1\";i:1;s:40:\"c895ff0ad0f690a8c437561213d488a772113edf\";i:2;i:1199130293;i:3;i:0;}\";admin_time|i:1199126693;ID_MSG_LAST_VISIT|s:2:\"13\";unread_messages|i:0;pm_selected|a:0:{}temp_attachments|a:0:{}forms|a:3:{i:0;i:6647989;i:1;i:12830068;i:2;i:13871076;}last_read_topic|i:11;'),('6a49bd71915d8889f77c0e3a8dbdb0ae',1199133046,'rand_code|s:32:\"fe2bdbfdfee5374484773b7005b894a1\";ID_MSG_LAST_VISIT|s:2:\"14\";log_time|i:1199133046;timeOnlineUpdated|i:1199133046;unread_messages|i:0;old_url|s:43:\"http://www.DealerScript.com/forum/index.php\";USER_AGENT|s:118:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)\";'),('d49bb2c8929c5df4eeed73aaf5482e6e',1199140263,'rand_code|s:32:\"604f36c89d8f948458f49e4fb60a7860\";ban|a:5:{s:12:\"last_checked\";i:1199140208;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:14:\"12.218.206.206\";s:3:\"ip2\";s:14:\"12.218.206.206\";s:5:\"email\";s:0:\"\";}log_time|i:1199140263;timeOnlineUpdated|i:1199140188;old_url|s:53:\"http://www.DealerScript.com/forum/index.php?board=7.0\";USER_AGENT|s:118:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)\";last_read_topic|i:10;login_SMFCookie662|s:95:\"a:4:{i:0;s:1:\"1\";i:1;s:40:\"c895ff0ad0f690a8c437561213d488a772113edf\";i:2;i:1199143809;i:3;i:0;}\";admin_time|i:1199140209;ID_MSG_LAST_VISIT|s:2:\"16\";unread_messages|i:0;temp_attachments|a:0:{}forms|a:1:{i:0;i:9204574;}');
/*!40000 ALTER TABLE `smf_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_settings`
--
DROP TABLE IF EXISTS `smf_settings`;
CREATE TABLE `smf_settings` (
`variable` tinytext NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`variable`(30))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_settings`
--
LOCK TABLES `smf_settings` WRITE;
/*!40000 ALTER TABLE `smf_settings` DISABLE KEYS */;
INSERT INTO `smf_settings` (`variable`, `value`) VALUES ('smfVersion','1.1.4'),('news','DealerScript Released'),('compactTopicPagesContiguous','5'),('compactTopicPagesEnable','1'),('enableStickyTopics','1'),('todayMod','1'),('karmaMode','0'),('karmaTimeRestrictAdmins','1'),('enablePreviousNext','1'),('pollMode','1'),('enableVBStyleLogin','1'),('enableCompressedOutput','1'),('karmaWaitTime','1'),('karmaMinPosts','0'),('karmaLabel','Karma:'),('karmaSmiteLabel','[smite]'),('karmaApplaudLabel','[applaud]'),('attachmentSizeLimit','5048'),('attachmentPostLimit','5048'),('attachmentNumPerPostLimit','4'),('attachmentDirSizeLimit','10240000'),('attachmentUploadDir','/home/dealersc/public_html/forum/attachments'),('attachmentExtensions','doc,gif,jpg,mpg,pdf,png,txt,zip'),('attachmentCheckExtensions','0'),('attachmentShowImages','1'),('attachmentEnable','1'),('attachmentEncryptFilenames','1'),('attachmentThumbnails','1'),('attachmentThumbWidth','150'),('attachmentThumbHeight','150'),('censorIgnoreCase','1'),('mostOnline','4'),('mostOnlineToday','1'),('mostDate','1197688241'),('allow_disableAnnounce','1'),('trackStats','1'),('userLanguage','1'),('titlesEnable','1'),('topicSummaryPosts','15'),('enableErrorLogging','1'),('max_image_width','0'),('max_image_height','0'),('onlineEnable','0'),('cal_holidaycolor','000080'),('cal_bdaycolor','920AC4'),('cal_eventcolor','078907'),('cal_enabled','0'),('cal_maxyear','2010'),('cal_minyear','2004'),('cal_daysaslink','0'),('cal_defaultboard',''),('cal_showeventsonindex','0'),('cal_showbdaysonindex','0'),('cal_showholidaysonindex','0'),('cal_showeventsoncalendar','1'),('cal_showbdaysoncalendar','1'),('cal_showholidaysoncalendar','1'),('cal_showweeknum','0'),('cal_maxspan','7'),('smtp_host',''),('smtp_port','25'),('smtp_username',''),('smtp_password',''),('mail_type','0'),('timeLoadPageEnable','0'),('totalTopics','3'),('totalMessages','8'),('simpleSearch','0'),('censor_vulgar',''),('censor_proper',''),('enablePostHTML','0'),('theme_allow','1'),('theme_default','1'),('theme_guests','1'),('enableEmbeddedFlash','0'),('xmlnews_enable','1'),('xmlnews_maxlen','255'),('hotTopicPosts','15'),('hotTopicVeryPosts','25'),('registration_method','0'),('send_validation_onChange','0'),('send_welcomeEmail','1'),('allow_editDisplayName','1'),('allow_hideOnline','1'),('allow_hideEmail','1'),('guest_hideContacts','0'),('spamWaitTime','5'),('pm_spam_settings','10,5,20'),('reserveWord','0'),('reserveCase','1'),('reserveUser','1'),('reserveName','1'),('reserveNames','Admin\nWebmaster\nGuest\nroot'),('autoLinkUrls','1'),('banLastUpdated','0'),('smileys_dir','/home/dealersc/public_html/forum/Smileys'),('smileys_url','http://www.dealerscript.com/forum/Smileys'),('avatar_directory','/home/dealersc/public_html/forum/avatars'),('avatar_url','http://www.dealerscript.com/forum/avatars'),('avatar_max_height_external','65'),('avatar_max_width_external','65'),('avatar_action_too_large','option_html_resize'),('avatar_max_height_upload','65'),('avatar_max_width_upload','65'),('avatar_resize_upload','1'),('avatar_download_png','1'),('failed_login_threshold','3'),('oldTopicDays','120'),('edit_wait_time','90'),('edit_disable_time','0'),('autoFixDatabase','1'),('allow_guestAccess','1'),('time_format','%B %d, %Y, %I:%M:%S %p'),('number_format','1234.00'),('enableBBC','1'),('max_messageLength','20000'),('max_signatureLength','300'),('autoOptDatabase','7'),('autoOptMaxOnline','0'),('autoOptLastOpt','1198813777'),('defaultMaxMessages','15'),('defaultMaxTopics','20'),('defaultMaxMembers','30'),('enableParticipation','1'),('recycle_enable','0'),('recycle_board','0'),('maxMsgID','16'),('enableAllMessages','0'),('fixLongWords','0'),('knownThemes','1,2,3'),('who_enabled','1'),('time_offset','0'),('cookieTime','60'),('lastActive','15'),('smiley_sets_known','default,classic'),('smiley_sets_names','Default\nClassic'),('smiley_sets_default','default'),('cal_days_for_index','7'),('requireAgreement','1'),('unapprovedMembers','0'),('default_personalText',''),('package_make_backups','1'),('databaseSession_enable','1'),('databaseSession_loose','1'),('databaseSession_lifetime','2880'),('search_cache_size','50'),('search_results_per_page','30'),('search_weight_frequency','30'),('search_weight_age','25'),('search_weight_length','20'),('search_weight_subject','15'),('search_weight_first_message','10'),('search_max_results','1200'),('permission_enable_deny','0'),('permission_enable_postgroups','0'),('permission_enable_by_board','0'),('default_timezone','Etc/GMT+5'),('memberlist_updated','1198987525'),('latestMember','17'),('totalMembers','17'),('latestRealName','DealerGuy'),('mostOnlineUpdated','2007-12-31'),('cal_today_updated','20071231'),('cal_today_holiday','a:1:{s:10:\"2008-01-01\";a:1:{i:0;s:10:\"New Year\'s\";}}'),('cal_today_birthday','a:0:{}'),('cal_today_event','a:0:{}'),('search_pointer','3');
/*!40000 ALTER TABLE `smf_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_smileys`
--
DROP TABLE IF EXISTS `smf_smileys`;
CREATE TABLE `smf_smileys` (
`ID_SMILEY` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(30) NOT NULL default '',
`filename` varchar(48) NOT NULL default '',
`description` varchar(80) NOT NULL default '',
`smileyRow` tinyint(4) unsigned NOT NULL default '0',
`smileyOrder` smallint(5) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_SMILEY`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_smileys`
--
LOCK TABLES `smf_smileys` WRITE;
/*!40000 ALTER TABLE `smf_smileys` DISABLE KEYS */;
INSERT INTO `smf_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES (1,':)','smiley.gif','Smiley',0,0,0),(2,';)','wink.gif','Wink',0,1,0),(3,':D','cheesy.gif','Cheesy',0,2,0),(4,';D','grin.gif','Grin',0,3,0),(5,'>:(','angry.gif','Angry',0,4,0),(6,':(','sad.gif','Sad',0,5,0),(7,':o','shocked.gif','Shocked',0,6,0),(8,'8)','cool.gif','Cool',0,7,0),(9,'???','huh.gif','Huh?',0,8,0),(10,'::)','rolleyes.gif','Roll Eyes',0,9,0),(11,':P','tongue.gif','Tongue',0,10,0),(12,':-[','embarrassed.gif','Embarrassed',0,11,0),(13,':-X','lipsrsealed.gif','Lips Sealed',0,12,0),(14,':-\\','undecided.gif','Undecided',0,13,0),(15,':-*','kiss.gif','Kiss',0,14,0),(16,':\'(','cry.gif','Cry',0,15,0),(17,'>:D','evil.gif','Evil',0,16,1),(18,'^-^','azn.gif','Azn',0,17,1),(19,'O0','afro.gif','Afro',0,18,1);
/*!40000 ALTER TABLE `smf_smileys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_themes`
--
DROP TABLE IF EXISTS `smf_themes`;
CREATE TABLE `smf_themes` (
`ID_MEMBER` mediumint(8) NOT NULL default '0',
`ID_THEME` tinyint(4) unsigned NOT NULL default '1',
`variable` tinytext NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`ID_THEME`,`ID_MEMBER`,`variable`(30)),
KEY `ID_MEMBER` (`ID_MEMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_themes`
--
LOCK TABLES `smf_themes` WRITE;
/*!40000 ALTER TABLE `smf_themes` DISABLE KEYS */;
INSERT INTO `smf_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES (0,1,'name','SMF Default Theme - Core'),(0,1,'theme_url','http://www.dealerscript.com/forum/Themes/default'),(0,1,'images_url','http://www.dealerscript.com/forum/Themes/default/images'),(0,1,'theme_dir','/home/dealersc/public_html/forum/Themes/default'),(0,1,'show_bbc','1'),(0,1,'show_latest_member','1'),(0,1,'show_modify','1'),(0,1,'show_user_images','1'),(0,1,'show_blurb','1'),(0,1,'show_gender','0'),(0,1,'show_newsfader','0'),(0,1,'number_recent_posts','0'),(0,1,'show_member_bar','1'),(0,1,'linktree_link','1'),(0,1,'show_profile_buttons','1'),(0,1,'show_mark_read','1'),(0,1,'show_sp1_info','1'),(0,1,'linktree_inline','0'),(0,1,'show_board_desc','1'),(0,1,'newsfader_time','5000'),(0,1,'allow_no_censored','0'),(0,1,'additional_options_collapsable','1'),(0,1,'use_image_buttons','1'),(0,1,'enable_news','1'),(0,2,'name','Classic YaBB SE Theme'),(0,2,'theme_url','http://www.dealerscript.com/forum/Themes/classic'),(0,2,'images_url','http://www.dealerscript.com/forum/Themes/classic/images'),(0,2,'theme_dir','/home/dealersc/public_html/forum/Themes/classic'),(0,3,'name','Babylon Theme'),(0,3,'theme_url','http://www.dealerscript.com/forum/Themes/babylon'),(0,3,'images_url','http://www.dealerscript.com/forum/Themes/babylon/images'),(0,3,'theme_dir','/home/dealersc/public_html/forum/Themes/babylon'),(1,1,'show_board_desc','0'),(1,1,'show_children','0'),(1,1,'show_no_avatars','0'),(1,1,'show_no_signatures','0'),(1,1,'return_to_post','0'),(1,1,'no_new_reply_warning','0'),(1,1,'view_newest_first','0'),(1,1,'view_newest_pm_first','0'),(1,1,'calendar_start_day','0'),(1,1,'display_quick_reply','0'),(1,1,'display_quick_mod','0'),(1,1,'copy_to_outbox','1'),(1,1,'popup_messages','1'),(1,1,'auto_notify','0');
/*!40000 ALTER TABLE `smf_themes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `smf_topics`
--
DROP TABLE IF EXISTS `smf_topics`;
CREATE TABLE `smf_topics` (
`ID_TOPIC` mediumint(8) unsigned NOT NULL auto_increment,
`isSticky` tinyint(4) NOT NULL default '0',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`ID_FIRST_MSG` int(10) unsigned NOT NULL default '0',
`ID_LAST_MSG` int(10) unsigned NOT NULL default '0',
`ID_MEMBER_STARTED` mediumint(8) unsigned NOT NULL default '0',
`ID_MEMBER_UPDATED` mediumint(8) unsigned NOT NULL default '0',
`ID_POLL` mediumint(8) unsigned NOT NULL default '0',
`numReplies` int(10) unsigned NOT NULL default '0',
`numViews` int(10) unsigned NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID_TOPIC`),
UNIQUE KEY `lastMessage` (`ID_LAST_MSG`,`ID_BOARD`),
UNIQUE KEY `firstMessage` (`ID_FIRST_MSG`,`ID_BOARD`),
UNIQUE KEY `poll` (`ID_POLL`,`ID_TOPIC`),
KEY `isSticky` (`isSticky`),
KEY `ID_BOARD` (`ID_BOARD`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smf_topics`
--
LOCK TABLES `smf_topics` WRITE;
/*!40000 ALTER TABLE `smf_topics` DISABLE KEYS */;
INSERT INTO `smf_topics` (`ID_TOPIC`, `isSticky`, `ID_BOARD`, `ID_FIRST_MSG`, `ID_LAST_MSG`, `ID_MEMBER_STARTED`, `ID_MEMBER_UPDATED`, `ID_POLL`, `numReplies`, `numViews`, `locked`) VALUES (11,0,7,16,16,1,1,0,0,1,0),(7,0,2,7,12,6,1,0,5,139,0),(10,0,6,15,15,1,1,0,0,3,0);
/*!40000 ALTER TABLE `smf_topics` ENABLE KEYS */;
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
![\"DealerScript\"](\"skins/phpCS/images/comp_thumb.jpg\" "\\"Dealer")
DealerScript is a world class php vehicle listings script designed for novice and expert computer users alike. In just a few minutes time you can have a fully functional multi-page vehicle listings web site. With years of development time and customer feedback taken into consideration, DealerScript is your sure fire way to get noticed on the internet quickly and efficiently.![\"Dealer](\"skins/phpCS/images/grey_screen.jpg\")
![\"DealerScript](\"skins/phpCS/images/demo_button.png\" "\\"DealerScript")
![\"Sign](\"http://images.paypal.com/en_US/i/bnr/paypal_mrb_banner.gif\")
![](\"skins/phpCS/images/paypal_verified.gif\")
![](\"skins/phpCS/images/ebay.jpg\")
![\"Foxkeh\"](\"skins/phpCS/images/fox.png\" "\\"Foxkeh\\"")