-- MySQL dump 10.9 -- -- Host: localhost Database: accscrip_auto50 -- ------------------------------------------------------ -- Server version 4.1.22-standard-log /*!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 `accs_admin` -- DROP TABLE IF EXISTS `accs_admin`; CREATE TABLE `accs_admin` ( `id` int(11) NOT NULL auto_increment, `right` smallint(1) NOT NULL default '0', `username` varchar(255) default NULL, `password` varchar(40) default NULL, `password1` varchar(40) NOT NULL default '', `email` varchar(255) NOT NULL default '', `noemail` tinyint(1) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `phone` varchar(255) NOT NULL default '', `fax` varchar(255) NOT NULL default '', `address` varchar(255) NOT NULL default '', `country` varchar(255) NOT NULL default '', `state` varchar(255) NOT NULL default '', `city` varchar(255) NOT NULL default '', `zip` varchar(255) NOT NULL default '', `logo` varchar(40) NOT NULL default '', `description` text NOT NULL, `nocars` int(11) NOT NULL default '0', `nopictures` int(11) NOT NULL default '0', `adprofiles` int(11) NOT NULL default '0', `unic_id` varchar(32) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `delay` int(5) NOT NULL default '60', `date_delay` date NOT NULL default '2005-05-09', `emailrenewsent` smallint(1) NOT NULL default '0', `daystoexpire` int(5) NOT NULL default '0', `daysactive` int(5) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_admin` -- LOCK TABLES `accs_admin` WRITE; /*!40000 ALTER TABLE `accs_admin` DISABLE KEYS */; INSERT INTO `accs_admin` VALUES (1,1,'admin','21232f297a57a5a743894a0e4a801fc3','21232f297a57a5a743894a0e4a801fc3','sales@accscripts.com',1,'Alex','','','','Romania','','','','','test',999,999,2,'',3,0,'2009-02-05',0,-1,1); /*!40000 ALTER TABLE `accs_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_adprofiles` -- DROP TABLE IF EXISTS `accs_adprofiles`; CREATE TABLE `accs_adprofiles` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, `titleok` varchar(255) NOT NULL default '', `titleok1` varchar(255) NOT NULL default '', `titleok2` varchar(255) NOT NULL default '', `titleok3` varchar(255) NOT NULL default '', `textok` text NOT NULL, `textok1` text NOT NULL, `textok2` text NOT NULL, `textok3` text NOT NULL, `titlenotok` varchar(255) NOT NULL default '', `titlenotok1` varchar(255) NOT NULL default '', `titlenotok2` varchar(255) NOT NULL default '', `titlenotok3` varchar(255) NOT NULL default '', `textnotok` text NOT NULL, `textnotok1` text NOT NULL, `textnotok2` text NOT NULL, `textnotok3` text NOT NULL, `days` int(5) NOT NULL default '0', `price` float(11,2) NOT NULL default '0.00', `nocars` int(4) NOT NULL default '0', `nopictures` int(4) NOT NULL default '0', `order` int(3) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `accs_adprofiles` -- LOCK TABLES `accs_adprofiles` WRITE; /*!40000 ALTER TABLE `accs_adprofiles` DISABLE KEYS */; INSERT INTO `accs_adprofiles` VALUES (2,'test','test','','','test','test','','','test','test','','','test','test','','','test','test','','','test','test','','',30,1.00,1,1,1,1); /*!40000 ALTER TABLE `accs_adprofiles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_banner` -- DROP TABLE IF EXISTS `accs_banner`; CREATE TABLE `accs_banner` ( `id` int(11) NOT NULL auto_increment, `type` int(11) NOT NULL default '0', `bannerimage` varchar(255) NOT NULL default '', `bannersourcecode` text NOT NULL, `title` varchar(255) NOT NULL default '', `desc1` varchar(255) NOT NULL default '', `desc2` varchar(255) NOT NULL default '', `url1` varchar(255) NOT NULL default '', `url2` varchar(255) NOT NULL default '', `httptype` varchar(255) NOT NULL default '', `price` float(11,2) NOT NULL default '0.00', `weeks` varchar(255) NOT NULL default '', `sdate` date NOT NULL default '0000-00-00', `noviews` int(11) NOT NULL default '0', `noclicks` int(11) NOT NULL default '0', `status` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `timebanneractive` int(11) NOT NULL default '0', `ctime` varchar(14) default NULL, `mtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_banner` -- LOCK TABLES `accs_banner` WRITE; /*!40000 ALTER TABLE `accs_banner` DISABLE KEYS */; INSERT INTO `accs_banner` VALUES (1,3,'','','Acc Autos','Professional solution','for a car dealership website','www.accscripts.com','www.accscripts.com/autos/','http://',0.00,'','0000-00-00',2002,2,'',1,0,'20070116182541','2009-02-07 10:38:46'); /*!40000 ALTER TABLE `accs_banner` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_bannerclicks` -- DROP TABLE IF EXISTS `accs_bannerclicks`; CREATE TABLE `accs_bannerclicks` ( `id` int(11) NOT NULL auto_increment, `banner` int(11) NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `time` time default NULL, `ip` varchar(255) NOT NULL default '', `language` varchar(255) NOT NULL default '', `ctime` varchar(14) default NULL, `mtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_bannerclicks` -- LOCK TABLES `accs_bannerclicks` WRITE; /*!40000 ALTER TABLE `accs_bannerclicks` DISABLE KEYS */; INSERT INTO `accs_bannerclicks` VALUES (1,1,'2009-02-06','07:29:10','208.111.154.16','','20090206072910','2009-02-06 07:29:10'); /*!40000 ALTER TABLE `accs_bannerclicks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_bannerdates` -- DROP TABLE IF EXISTS `accs_bannerdates`; CREATE TABLE `accs_bannerdates` ( `id` int(11) NOT NULL auto_increment, `banner` int(11) NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `noviews` int(11) NOT NULL default '0', `noclicks` int(11) NOT NULL default '0', `ctime` varchar(14) default NULL, `mtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_bannerdates` -- LOCK TABLES `accs_bannerdates` WRITE; /*!40000 ALTER TABLE `accs_bannerdates` DISABLE KEYS */; INSERT INTO `accs_bannerdates` VALUES (1,1,'2009-02-05',57,0,'20090205164630','2009-02-05 23:21:15'),(2,1,'2009-02-06',213,1,'20090206000551','2009-02-06 23:50:50'),(3,1,'2009-02-07',84,0,'20090207000449','2009-02-07 10:38:46'); /*!40000 ALTER TABLE `accs_bannerdates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_bannersettings` -- DROP TABLE IF EXISTS `accs_bannersettings`; CREATE TABLE `accs_bannersettings` ( `id` int(11) NOT NULL auto_increment, `adsensecode1` text NOT NULL, `adsensecode2` text NOT NULL, `adsensecode3` text NOT NULL, `adsensecode4` text NOT NULL, `colortitle` varchar(255) NOT NULL default '', `colorbackground` varchar(255) NOT NULL default '', `colortext` varchar(255) NOT NULL default '', `colorurl` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_bannersettings` -- LOCK TABLES `accs_bannersettings` WRITE; /*!40000 ALTER TABLE `accs_bannersettings` DISABLE KEYS */; INSERT INTO `accs_bannersettings` VALUES (1,'','','','','#990000','#FFFFFF','#006666','#990000'); /*!40000 ALTER TABLE `accs_bannersettings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_bodytype` -- DROP TABLE IF EXISTS `accs_bodytype`; CREATE TABLE `accs_bodytype` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_bodytype` -- LOCK TABLES `accs_bodytype` WRITE; /*!40000 ALTER TABLE `accs_bodytype` DISABLE KEYS */; INSERT INTO `accs_bodytype` VALUES (1,'convertible','','',''),(2,'Other','','',''); /*!40000 ALTER TABLE `accs_bodytype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_cars` -- DROP TABLE IF EXISTS `accs_cars`; CREATE TABLE `accs_cars` ( `id` int(11) NOT NULL auto_increment, `stock` varchar(255) NOT NULL default '', `admin` int(11) NOT NULL default '0', `category` int(11) NOT NULL default '0', `make` int(11) NOT NULL default '0', `model` varchar(255) NOT NULL default '', `typeofvehicle` int(11) NOT NULL default '0', `doors` int(11) NOT NULL default '0', `power` int(11) NOT NULL default '0', `classifyemissions` int(11) NOT NULL default '0', `gearbox` int(11) NOT NULL default '0', `climaticcontrol` int(11) NOT NULL default '0', `year` int(4) NOT NULL default '0', `price` float(11,2) NOT NULL default '0.00', `specialprice` float(11,2) NOT NULL default '0.00', `pricemesg` varchar(255) NOT NULL default '', `pricemesg1` varchar(255) NOT NULL default '', `pricemesg2` varchar(255) NOT NULL default '', `pricemesg3` varchar(255) NOT NULL default '', `vin` varchar(255) NOT NULL default '', `bodytype` varchar(255) NOT NULL default '0', `engine` varchar(255) NOT NULL default '', `stereo` varchar(255) NOT NULL default '', `fueltype` varchar(255) NOT NULL default '', `transmission` varchar(255) NOT NULL default '', `shortdescription` text NOT NULL, `shortdescription1` text NOT NULL, `shortdescription2` text NOT NULL, `shortdescription3` text NOT NULL, `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, `intcolor` varchar(255) NOT NULL default '', `extcolor` varchar(255) NOT NULL default '', `miles` int(11) NOT NULL default '0', `latitude` varchar(255) NOT NULL default '', `longitude` varchar(255) NOT NULL default '', `customa` varchar(255) NOT NULL default '', `customa1` varchar(255) NOT NULL default '', `customa2` varchar(255) NOT NULL default '', `customa3` varchar(255) NOT NULL default '', `customb` varchar(255) NOT NULL default '', `customb1` varchar(255) NOT NULL default '', `customb2` varchar(255) NOT NULL default '', `customb3` varchar(255) NOT NULL default '', `customc` varchar(255) NOT NULL default '', `customc1` varchar(255) NOT NULL default '', `customc2` varchar(255) NOT NULL default '', `customc3` varchar(255) NOT NULL default '', `customd` varchar(255) NOT NULL default '', `customd1` varchar(255) NOT NULL default '', `customd2` varchar(255) NOT NULL default '', `customd3` varchar(255) NOT NULL default '', `custome` varchar(255) NOT NULL default '', `custome1` varchar(255) NOT NULL default '', `custome2` varchar(255) NOT NULL default '', `custome3` varchar(255) NOT NULL default '', `customf` varchar(255) NOT NULL default '', `customf1` varchar(255) NOT NULL default '', `customf2` varchar(255) NOT NULL default '', `customf3` varchar(255) NOT NULL default '', `customg` varchar(255) NOT NULL default '', `customg1` varchar(255) NOT NULL default '', `customg2` varchar(255) NOT NULL default '', `customg3` varchar(255) NOT NULL default '', `customh` varchar(255) NOT NULL default '', `customh1` varchar(255) NOT NULL default '', `customh2` varchar(255) NOT NULL default '', `customh3` varchar(255) NOT NULL default '', `customi` varchar(255) NOT NULL default '', `customi1` varchar(255) NOT NULL default '', `customi2` varchar(255) NOT NULL default '', `customi3` varchar(255) NOT NULL default '', `customj` varchar(255) NOT NULL default '', `customj1` varchar(255) NOT NULL default '', `customj2` varchar(255) NOT NULL default '', `customj3` varchar(255) NOT NULL default '', `noview` int(11) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', `date_add` date NOT NULL default '0000-00-00', `date_modify` date NOT NULL default '0000-00-00', `sitetitle` varchar(255) NOT NULL default '', `sitetitle1` varchar(255) NOT NULL default '', `sitetitle2` varchar(255) NOT NULL default '', `sitetitle3` varchar(255) NOT NULL default '', `metadescription` text NOT NULL, `metadescription1` text NOT NULL, `metadescription2` text NOT NULL, `metadescription3` text NOT NULL, `metakeywords` text NOT NULL, `metakeywords1` text NOT NULL, `metakeywords2` text NOT NULL, `metakeywords3` text NOT NULL, `displaymodel` tinyint(2) NOT NULL default '0', `delay` int(3) NOT NULL default '60', `date_delay` date NOT NULL default '2005-05-09', `unicid` varchar(50) default NULL, `emailrenewsent` smallint(1) NOT NULL default '0', `daystoexpire` int(5) NOT NULL default '0', `daysactive` int(5) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_cars` -- LOCK TABLES `accs_cars` WRITE; /*!40000 ALTER TABLE `accs_cars` DISABLE KEYS */; INSERT INTO `accs_cars` VALUES (1,'1',1,2,1,'3',3,1,110,1,2,2,1996,3550.00,0.00,'','','','','','1','','','Diesel','1','second-hand vehicle, 149.415 km\r\n110 kW (150 PS), petrol, Manual gearbox,\r\nAir-Conditioning, schwarz-metallic, ','','','','

second-hand vehicle, 149.415 km
\r\n110 kW (150 PS), petrol, Manual gearbox,
\r\nAir-Conditioning, schwarz-metallic,

','','','','1','1',0,'46.78408','4.84978','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',99,0,'2007-01-16','2009-02-07','','','','','','','','','','','','',0,0,'2009-01-14','',0,-24,2); /*!40000 ALTER TABLE `accs_cars` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_carsdealer` -- DROP TABLE IF EXISTS `accs_carsdealer`; CREATE TABLE `accs_carsdealer` ( `id` int(11) NOT NULL auto_increment, `stock` varchar(255) NOT NULL default '', `admin` int(11) NOT NULL default '0', `category` int(11) NOT NULL default '0', `make` int(11) NOT NULL default '0', `model` varchar(255) NOT NULL default '', `year` int(4) NOT NULL default '0', `price` float(11,2) NOT NULL default '0.00', `specialprice` float(11,2) NOT NULL default '0.00', `pricemesg` varchar(255) NOT NULL default '', `pricemesg1` varchar(255) NOT NULL default '', `pricemesg2` varchar(255) NOT NULL default '', `pricemesg3` varchar(255) NOT NULL default '', `dealerprice` float(11,2) NOT NULL default '0.00', `vin` varchar(255) NOT NULL default '', `bodytype` varchar(255) NOT NULL default '0', `engine` varchar(255) NOT NULL default '', `stereo` varchar(255) NOT NULL default '', `fueltype` varchar(255) NOT NULL default '', `transmission` varchar(255) NOT NULL default '', `shortdescription` text NOT NULL, `shortdescription1` text NOT NULL, `shortdescription2` text NOT NULL, `shortdescription3` text NOT NULL, `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, `intcolor` varchar(255) NOT NULL default '', `extcolor` varchar(255) NOT NULL default '', `miles` int(11) NOT NULL default '0', `noview` int(11) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', `date_add` date NOT NULL default '0000-00-00', `date_modify` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_carsdealer` -- LOCK TABLES `accs_carsdealer` WRITE; /*!40000 ALTER TABLE `accs_carsdealer` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_carsdealer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_carsdealerfeatures` -- DROP TABLE IF EXISTS `accs_carsdealerfeatures`; CREATE TABLE `accs_carsdealerfeatures` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `featuresid` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_carsdealerfeatures` -- LOCK TABLES `accs_carsdealerfeatures` WRITE; /*!40000 ALTER TABLE `accs_carsdealerfeatures` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_carsdealerfeatures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_carsdealergallery` -- DROP TABLE IF EXISTS `accs_carsdealergallery`; CREATE TABLE `accs_carsdealergallery` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `picture` varchar(40) NOT NULL default '', `thumbnail` varchar(40) NOT NULL default '', `description` varchar(255) NOT NULL default '', `description1` varchar(255) NOT NULL default '', `description2` varchar(255) NOT NULL default '', `description3` varchar(255) NOT NULL default '', `order` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_carsdealergallery` -- LOCK TABLES `accs_carsdealergallery` WRITE; /*!40000 ALTER TABLE `accs_carsdealergallery` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_carsdealergallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_carsfeatures` -- DROP TABLE IF EXISTS `accs_carsfeatures`; CREATE TABLE `accs_carsfeatures` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `featuresid` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=164 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_carsfeatures` -- LOCK TABLES `accs_carsfeatures` WRITE; /*!40000 ALTER TABLE `accs_carsfeatures` DISABLE KEYS */; INSERT INTO `accs_carsfeatures` VALUES (163,1,11),(162,1,10),(161,1,9),(160,1,8),(159,1,7),(158,1,6),(157,1,5),(156,1,4),(155,1,3),(154,1,2),(153,1,1); /*!40000 ALTER TABLE `accs_carsfeatures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_category` -- DROP TABLE IF EXISTS `accs_category`; CREATE TABLE `accs_category` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, `order` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_category` -- LOCK TABLES `accs_category` WRITE; /*!40000 ALTER TABLE `accs_category` DISABLE KEYS */; INSERT INTO `accs_category` VALUES (1,'Small car','','','','
Small car
','','','',0),(2,'Sports car1','','','','
Sports car1
','','','',0),(3,'AAA','AAA','','','','','','',0),(32,'Cars','','','','','','','',0); /*!40000 ALTER TABLE `accs_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_classifyemissions` -- DROP TABLE IF EXISTS `accs_classifyemissions`; CREATE TABLE `accs_classifyemissions` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_classifyemissions` -- LOCK TABLES `accs_classifyemissions` WRITE; /*!40000 ALTER TABLE `accs_classifyemissions` DISABLE KEYS */; INSERT INTO `accs_classifyemissions` VALUES (1,'Euro 3','','',''),(2,'Euro 4','','',''),(3,'Other','','',''); /*!40000 ALTER TABLE `accs_classifyemissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_climaticcontrol` -- DROP TABLE IF EXISTS `accs_climaticcontrol`; CREATE TABLE `accs_climaticcontrol` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_climaticcontrol` -- LOCK TABLES `accs_climaticcontrol` WRITE; /*!40000 ALTER TABLE `accs_climaticcontrol` DISABLE KEYS */; INSERT INTO `accs_climaticcontrol` VALUES (1,'climate control(auto)','','',''),(2,'Automatic air-conditioning','','',''),(3,'no auto climate control','','',''),(4,'Other','','',''); /*!40000 ALTER TABLE `accs_climaticcontrol` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_customlinks` -- DROP TABLE IF EXISTS `accs_customlinks`; CREATE TABLE `accs_customlinks` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `content` text NOT NULL, `content1` text NOT NULL, `content2` text NOT NULL, `content3` text NOT NULL, `sitetitle` varchar(255) NOT NULL default '', `sitetitle1` varchar(255) NOT NULL default '', `sitetitle2` varchar(255) NOT NULL default '', `sitetitle3` varchar(255) NOT NULL default '', `metadescription` text NOT NULL, `metadescription1` text NOT NULL, `metadescription2` text NOT NULL, `metadescription3` text NOT NULL, `metakeywords` text NOT NULL, `metakeywords1` text NOT NULL, `metakeywords2` text NOT NULL, `metakeywords3` text NOT NULL, `order` int(11) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_customlinks` -- LOCK TABLES `accs_customlinks` WRITE; /*!40000 ALTER TABLE `accs_customlinks` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_customlinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_dealers` -- DROP TABLE IF EXISTS `accs_dealers`; CREATE TABLE `accs_dealers` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255) default NULL, `password` varchar(40) default NULL, `password1` varchar(40) NOT NULL default '', `email` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `phone` varchar(255) NOT NULL default '', `country` varchar(255) NOT NULL default '', `state` varchar(255) NOT NULL default '', `city` varchar(255) NOT NULL default '', `description` text NOT NULL, `unic_id` varchar(32) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_dealers` -- LOCK TABLES `accs_dealers` WRITE; /*!40000 ALTER TABLE `accs_dealers` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_dealers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_doors` -- DROP TABLE IF EXISTS `accs_doors`; CREATE TABLE `accs_doors` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_doors` -- LOCK TABLES `accs_doors` WRITE; /*!40000 ALTER TABLE `accs_doors` DISABLE KEYS */; INSERT INTO `accs_doors` VALUES (1,'2|3','','',''),(2,'4|5','','',''),(3,'6|7','','',''),(4,'Other','','',''); /*!40000 ALTER TABLE `accs_doors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_extcolor` -- DROP TABLE IF EXISTS `accs_extcolor`; CREATE TABLE `accs_extcolor` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_extcolor` -- LOCK TABLES `accs_extcolor` WRITE; /*!40000 ALTER TABLE `accs_extcolor` DISABLE KEYS */; INSERT INTO `accs_extcolor` VALUES (1,'Beige','','',''),(2,'Black','','',''),(3,'Blue','','',''),(4,'Brown','','',''),(5,'Burgundy','','',''),(6,'Charcoal','','',''),(7,'Gold','','',''),(8,'Gray','','',''),(9,'Green','','',''),(10,'Off White','','',''),(11,'Orange','','',''),(12,'Pink','','',''),(13,'Purple','','',''),(14,'Red','','',''),(15,'Silver','','',''),(16,'Tan','','',''),(17,'Turquoise','','',''),(18,'White','','',''),(19,'Yellow','','',''),(20,'','','',''); /*!40000 ALTER TABLE `accs_extcolor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_faq` -- DROP TABLE IF EXISTS `accs_faq`; CREATE TABLE `accs_faq` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `content` text NOT NULL, `content1` text NOT NULL, `content2` text NOT NULL, `content3` text NOT NULL, `order` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_faq` -- LOCK TABLES `accs_faq` WRITE; /*!40000 ALTER TABLE `accs_faq` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_faq` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_features` -- DROP TABLE IF EXISTS `accs_features`; CREATE TABLE `accs_features` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_features` -- LOCK TABLES `accs_features` WRITE; /*!40000 ALTER TABLE `accs_features` DISABLE KEYS */; INSERT INTO `accs_features` VALUES (1,'CD player','','',''),(2,'Cruise control','','',''),(3,'Handicap-equipped','','',''),(4,'Leather seats','','',''),(5,'Power door locks','','',''),(6,'Power mirrors','','',''),(7,'Power windows','','',''),(8,'Rear window defroster','','',''),(9,'Side airbags','','',''),(10,'Tilt Telescope wheel','','',''),(11,'Tinted glass','','',''); /*!40000 ALTER TABLE `accs_features` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_fieldsorder` -- DROP TABLE IF EXISTS `accs_fieldsorder`; CREATE TABLE `accs_fieldsorder` ( `id` int(11) NOT NULL auto_increment, `field` varchar(255) NOT NULL default '0', `relation` int(11) NOT NULL default '0', `defaultvalue` varchar(255) NOT NULL default '', `checkedvalue` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_fieldsorder` -- LOCK TABLES `accs_fieldsorder` WRITE; /*!40000 ALTER TABLE `accs_fieldsorder` DISABLE KEYS */; INSERT INTO `accs_fieldsorder` VALUES (1,'cars__stock',1,'',0),(2,'cars__admin',2,'',0),(3,'cars__category',3,'',0),(4,'cars__make',4,'',0),(5,'cars__model',5,'',0),(6,'cars__typeofvehicle',6,'',0),(7,'cars__doors',7,'',0),(8,'cars__power',8,'',0),(9,'cars__classifyemissions',9,'',0),(10,'cars__gearbox',10,'',0),(11,'cars__climaticcontrol',11,'',0),(12,'cars__year',12,'',0),(13,'cars__price',13,'',0),(14,'cars__specialprice',14,'',0),(15,'cars__pricemesg',15,'',0),(16,'cars__vin',16,'',0),(17,'cars__bodytype',17,'',0),(18,'cars__engine',18,'',0),(19,'cars__stereo',19,'',0),(20,'cars__fueltype',20,'',0),(21,'cars__transmission',21,'',0),(22,'cars__shortdescription',22,'',0),(23,'cars__description',23,'',0),(24,'cars__intcolor',24,'',0),(25,'cars__extcolor',25,'',0),(26,'cars__miles',26,'',0),(27,'cars__latitude',27,'',0),(28,'cars__longitude',28,'',0),(29,'cars__customa',29,'',0),(30,'cars__customb',30,'',0),(31,'cars__customc',31,'',0),(32,'cars__customd',32,'',0),(33,'cars__custome',33,'',0),(34,'cars__customf',34,'',0),(35,'cars__customg',35,'',0),(36,'cars__customh',36,'',0),(37,'cars__customi',37,'',0),(38,'cars__customj',38,'',0),(39,'cars__active',39,'',0),(40,'cars__sitetitle',40,'',0),(41,'cars__metadescription',41,'',0),(42,'cars__metakeywords',42,'',0),(43,'cars__displaymodel',43,'',0); /*!40000 ALTER TABLE `accs_fieldsorder` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_fieldstranslate` -- DROP TABLE IF EXISTS `accs_fieldstranslate`; CREATE TABLE `accs_fieldstranslate` ( `id` int(11) NOT NULL auto_increment, `field` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_fieldstranslate` -- LOCK TABLES `accs_fieldstranslate` WRITE; /*!40000 ALTER TABLE `accs_fieldstranslate` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_fieldstranslate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_gallery` -- DROP TABLE IF EXISTS `accs_gallery`; CREATE TABLE `accs_gallery` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `picture` varchar(40) NOT NULL default '', `thumbnail` varchar(40) NOT NULL default '', `description` varchar(255) NOT NULL default '', `description1` varchar(255) NOT NULL default '', `description2` varchar(255) NOT NULL default '', `description3` varchar(255) NOT NULL default '', `order` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_gallery` -- LOCK TABLES `accs_gallery` WRITE; /*!40000 ALTER TABLE `accs_gallery` DISABLE KEYS */; INSERT INTO `accs_gallery` VALUES (4,1,'195cbeb78f4ef4ab081dd0ae67132a6d.jpg','1ba957188bec0af8fcace85508bee679.jpg','test2','','','',2),(5,1,'1939330b05cc4dbf76c4646afd6ea55c.jpg','194f08ca4fa61ef4dffd059b8dacfbd8.jpg','test3','','','',3); /*!40000 ALTER TABLE `accs_gallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_gearbox` -- DROP TABLE IF EXISTS `accs_gearbox`; CREATE TABLE `accs_gearbox` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_gearbox` -- LOCK TABLES `accs_gearbox` WRITE; /*!40000 ALTER TABLE `accs_gearbox` DISABLE KEYS */; INSERT INTO `accs_gearbox` VALUES (1,'Manual gearbox','','',''),(2,'Automatic transmission','','',''),(3,'Semi-automatic','','',''),(4,'Other','','',''); /*!40000 ALTER TABLE `accs_gearbox` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_helpowner` -- DROP TABLE IF EXISTS `accs_helpowner`; CREATE TABLE `accs_helpowner` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_helpowner` -- LOCK TABLES `accs_helpowner` WRITE; /*!40000 ALTER TABLE `accs_helpowner` DISABLE KEYS */; INSERT INTO `accs_helpowner` VALUES (1,'Help Page','','','','Help Page','','',''); /*!40000 ALTER TABLE `accs_helpowner` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_homepage` -- DROP TABLE IF EXISTS `accs_homepage`; CREATE TABLE `accs_homepage` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_homepage` -- LOCK TABLES `accs_homepage` WRITE; /*!40000 ALTER TABLE `accs_homepage` DISABLE KEYS */; INSERT INTO `accs_homepage` VALUES (1,'Welcome to Acc Autos php script :: auto dealer script','','','','

Acc Autos php script : is a professional solution for a car sales website. Although you need only ten minutes to install, it is both easy to use and rich in the features you need. The right choice for your business! Keep it simple, keep it productive, keep it focused! Please check the online demo and the limited price offer!.

\r\n


\r\n

New in version 5.0
\r\n- new design
\r\n- google map search
\r\n- owner page in front end
\r\n- seo settings (you can choose and customize now the sitetitle, metakeywords and metadescription for every page)
\r\n- select the add/modify cars form fields order
\r\n- add up to 10 custom fields for cars form
\r\n- we make the relation between category, make and model (you can also disable this and leave only make - model relation)
\r\n- import category, make, model and import settings

\r\n\r\n


\r\nAcc Autos script was intended and developed as a solution for small car dealerships, which were planning to get online. Acc Autos script makes easy managing your vehicle inventory and displaying the vehicles your dealership has for sale.
\r\n
\r\nAcc Autos script is a web content management solution designed for Vehicle Listings showcasing. Easy to install and use, the product is meant for those who create or manage a website for an independent salesperson, an automobile dealership, selling on consignment, private sales and much more... Acc Autos software allows salespersons as well as non-technical users to quickly create, publish and manage vehicle listings to their website. The peculiarity of the software is that, a user needs only his browser.
\r\n
\r\nAre you a car dealer? If you are, just imagine having your own site, FULLY MAINTAINED by yourself which means NO EXTRA COSTS! Sounds interesting? Then, see what it could look like within 15 MINUTES OF PURCHASING!!

\r\n


\r\n

Why us?

\r\n\r\n','','',''); /*!40000 ALTER TABLE `accs_homepage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_homepageowner` -- DROP TABLE IF EXISTS `accs_homepageowner`; CREATE TABLE `accs_homepageowner` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_homepageowner` -- LOCK TABLES `accs_homepageowner` WRITE; /*!40000 ALTER TABLE `accs_homepageowner` DISABLE KEYS */; INSERT INTO `accs_homepageowner` VALUES (1,'Welcome owner','','','','

Welcome owner.

\r\n


To add a cars press `Cars` from left menu , and then Add from top.

','','',''); /*!40000 ALTER TABLE `accs_homepageowner` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_importcategorysettings` -- DROP TABLE IF EXISTS `accs_importcategorysettings`; CREATE TABLE `accs_importcategorysettings` ( `id` int(11) NOT NULL auto_increment, `field` varchar(255) NOT NULL default '0', `relation` int(11) NOT NULL default '0', `defaultvalue` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_importcategorysettings` -- LOCK TABLES `accs_importcategorysettings` WRITE; /*!40000 ALTER TABLE `accs_importcategorysettings` DISABLE KEYS */; INSERT INTO `accs_importcategorysettings` VALUES (1,'cars__make',1,''),(2,'cars__model',2,''),(3,'cars__category',999999,''),(4,'cars__category1',999999,''),(5,'cars__make1',999999,''),(6,'cars__model1',999999,''); /*!40000 ALTER TABLE `accs_importcategorysettings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_importsettings` -- DROP TABLE IF EXISTS `accs_importsettings`; CREATE TABLE `accs_importsettings` ( `id` int(11) NOT NULL auto_increment, `field` varchar(255) NOT NULL default '0', `relation` int(11) NOT NULL default '0', `defaultvalue` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_importsettings` -- LOCK TABLES `accs_importsettings` WRITE; /*!40000 ALTER TABLE `accs_importsettings` DISABLE KEYS */; INSERT INTO `accs_importsettings` VALUES (1,'cars__stock',1,''),(2,'cars__admin',2,''),(3,'cars__category',3,''),(4,'cars__make',4,''),(5,'cars__model',5,''),(6,'cars__typeofvehicle',6,''),(7,'cars__doors',7,''),(8,'cars__power',8,''),(9,'cars__classifyemissions',9,''),(10,'cars__gearbox',10,''),(11,'cars__climaticcontrol',11,''),(12,'cars__year',12,''),(13,'cars__price',13,''),(14,'cars__specialprice',14,''),(15,'cars__pricemesg',15,''),(16,'cars__vin',16,''),(17,'cars__bodytype',17,''),(18,'cars__engine',18,''),(19,'cars__stereo',19,''),(20,'cars__fueltype',20,''),(21,'cars__transmission',21,''),(22,'cars__shortdescription',22,''),(23,'cars__description',23,''),(24,'cars__intcolor',24,''),(25,'cars__extcolor',25,''),(26,'cars__miles',26,''),(27,'cars__latitude',27,''),(28,'cars__longitude',28,''),(29,'cars__customa',29,''),(30,'cars__customb',30,''),(31,'cars__active',31,''),(32,'cars__sitetitle',32,''),(33,'cars__metadescription',33,''),(34,'cars__metakeywords',34,''),(35,'cars__displaymodel',35,''),(36,'features__1',36,''),(37,'features__2',37,''),(38,'features__3',38,''),(39,'features__4',39,''),(40,'features__5',40,''),(41,'features__6',41,''),(42,'features__7',42,''),(43,'features__8',43,''),(44,'features__9',44,''),(45,'features__10',45,''),(46,'features__11',46,''),(47,'gallery__1',47,''),(48,'gallery__2',48,''),(49,'gallery__3',49,''),(50,'gallery__4',50,''),(51,'gallery__5',51,''); /*!40000 ALTER TABLE `accs_importsettings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_intcolor` -- DROP TABLE IF EXISTS `accs_intcolor`; CREATE TABLE `accs_intcolor` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_intcolor` -- LOCK TABLES `accs_intcolor` WRITE; /*!40000 ALTER TABLE `accs_intcolor` DISABLE KEYS */; INSERT INTO `accs_intcolor` VALUES (1,'Beige','','',''),(2,'Black','','',''),(3,'Blue','','',''),(4,'Brown','','',''),(5,'Burgundy','','',''),(6,'Charcoal','','',''),(7,'Gold','','',''),(8,'Gray','','',''),(9,'Green','','',''),(10,'Off White','','',''),(11,'Orange','','',''),(12,'Pink','','',''),(13,'Purple','','',''),(14,'Red','','',''),(15,'Silver','','',''),(16,'Tan','','',''),(17,'Turquoise','','',''),(18,'White','','',''),(19,'Yellow','','',''),(20,'','','',''); /*!40000 ALTER TABLE `accs_intcolor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_ips` -- DROP TABLE IF EXISTS `accs_ips`; CREATE TABLE `accs_ips` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(255) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `date_start` date NOT NULL default '0000-00-00', `date_ends` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_ips` -- LOCK TABLES `accs_ips` WRITE; /*!40000 ALTER TABLE `accs_ips` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_ips` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_javascript` -- DROP TABLE IF EXISTS `accs_javascript`; CREATE TABLE `accs_javascript` ( `id` int(11) NOT NULL auto_increment, `categoryjavascript` longtext NOT NULL, `makejavascript` longtext NOT NULL, `modeljavascript` longtext NOT NULL, `bodytypejavascript` longtext NOT NULL, `transmissionjavascript` longtext NOT NULL, `intcolorjavascript` longtext NOT NULL, `extcolorjavascript` longtext NOT NULL, `makemodeljavascript` longtext NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_javascript` -- LOCK TABLES `accs_javascript` WRITE; /*!40000 ALTER TABLE `accs_javascript` DISABLE KEYS */; INSERT INTO `accs_javascript` VALUES (1,'','','','','','','',''); /*!40000 ALTER TABLE `accs_javascript` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_logging` -- DROP TABLE IF EXISTS `accs_logging`; CREATE TABLE `accs_logging` ( `id` int(11) NOT NULL auto_increment, `admin` varchar(255) NOT NULL default '', `action` text NOT NULL, `sql` text NOT NULL, `ctime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_logging` -- LOCK TABLES `accs_logging` WRITE; /*!40000 ALTER TABLE `accs_logging` DISABLE KEYS */; INSERT INTO `accs_logging` VALUES (1,'1','User login admin','','2009-02-05 16:47:31'),(2,'1','User login admin','','2009-02-05 16:47:49'),(3,'1','Edit Admin ( 1: admin) ','UPDATE `accs_admin` SET `id`=\'1\' , `right` = \'1\' , `username` = \'admin\' , `password` = \'21232f297a57a5a743894a0e4a801fc3\' , `email` = \'admin@admin.com\' , `noemail` = \'1\' , `name` = \'Alex\' , `phone` = \'\' , `fax` = \'\' , `address` = \'\' , `country` = \'Romania\' , `state` = \'\' , `city` = \'\' , `zip` = \'\' , `logo` = \'\' , `description` = \'test\' , `nocars` = \'999\' , `nopictures` = \'999\' , `adprofiles` = \'2\' , `unic_id` = \'\' , `active` = \'1\' , `delay` = \'0\' , `date_delay` = \'2009-02-05\' , `emailrenewsent` = \'\' , `daystoexpire` = \'\' , `daysactive` = \'\' WHERE `id`=\'1\' limit 1','2009-02-05 16:48:04'),(4,'1','Edit Admin ( 1: admin) ','UPDATE `accs_admin` SET `id`=\'1\' , `right` = \'1\' , `username` = \'admin\' , `password` = \'21232f297a57a5a743894a0e4a801fc3\' , `email` = \'sales@accscripts.com\' , `noemail` = \'1\' , `name` = \'Alex\' , `phone` = \'\' , `fax` = \'\' , `address` = \'\' , `country` = \'Romania\' , `state` = \'\' , `city` = \'\' , `zip` = \'\' , `logo` = \'\' , `description` = \'test\' , `nocars` = \'999\' , `nopictures` = \'999\' , `adprofiles` = \'2\' , `unic_id` = \'\' , `active` = \'1\' , `delay` = \'0\' , `date_delay` = \'2009-02-05\' , `emailrenewsent` = \'\' , `daystoexpire` = \'\' , `daysactive` = \'\' WHERE `id`=\'1\' limit 1','2009-02-05 16:48:14'),(5,'1','Delete Gallery ( 1: ) ','delete from `accs_gallery` WHERE `id`=\'1\'','2009-02-05 16:48:40'),(6,'1','User logout','','2009-02-05 17:22:41'),(7,'90.209.153.198','User try to login: user (Username not exist in database!) ','','2009-02-05 21:33:13'),(8,'90.209.153.198','User try to login: user (Username not exist in database!) ','','2009-02-05 21:33:34'),(9,'130.13.113.38','User try to login: () ','','2009-02-05 22:39:48'),(10,'1','User login admin','','2009-02-05 23:22:15'),(11,'1','User login admin','','2009-02-06 01:10:20'),(12,'130.13.113.38','User try to login: user (Username not exist in database!) ','','2009-02-06 01:14:28'),(13,'87.221.77.187','User try to login: user (Username not exist in database!) ','','2009-02-06 11:30:27'),(14,'87.221.77.187','User try to login: user (Username not exist in database!) ','','2009-02-06 11:30:45'),(15,'1','User login admin','','2009-02-06 11:31:25'),(16,'62.162.98.194','User try to login: user (Username not exist in database!) ','','2009-02-06 13:39:14'),(17,'62.162.98.194','User try to login: user (Username not exist in database!) ','','2009-02-06 13:39:28'),(18,'1','User login admin','','2009-02-06 13:39:48'),(19,'1','User login admin','','2009-02-06 14:45:38'),(20,'1','Edit Gallery ( 3: ) ','UPDATE `accs_gallery` SET `id`=\'3\' , `carsid` = \'1\' , `picture` = \'1912f28c0d94f5a73b84de9d0af303b5.jpg\' , `thumbnail` = \'16c364018b85d12a407d7105c7b3e78d.jpg\' , `description` = \'test\' , `description1` = \'\' , `description2` = \'\' , `description3` = \'\' , `order` = \'0\' WHERE `id`=\'3\' limit 1','2009-02-06 14:47:41'),(21,'1','User logout','','2009-02-06 14:49:27'),(22,'79.126.134.27','User try to login: user (Username not exist in database!) ','','2009-02-06 14:50:10'),(23,'79.126.134.27','User try to login: user (Username not exist in database!) ','','2009-02-06 14:50:18'),(24,'1','User login admin','','2009-02-06 19:33:10'),(25,'1','Edit Settings ( 1: ) ','UPDATE `accs_settings` SET `id`=\'1\' , `nrpageuser` = \'6\' , `nrpageadmin` = \'10\' , `currency` = \'USD\' , `nocars` = \'3\' , `nopictures` = \'6\' , `rights_signupuser` = \'2\' , `titlesite` = \'Acc Autos\' , `titlesite1` = \'\' , `titlesite2` = \'\' , `titlesite3` = \'\' , `description` = \'Acc Autos is a professional solution for a car sales website. Although you need only ten minutes to install, it is both easy to use and rich in the features you need.\' , `description1` = \'\' , `description2` = \'\' , `description3` = \'\' , `keywords` = \'Acc Autos, auto dealer script, php scripts and programs, PHP Classified Ads, PHP Autos, car sales website, buy car script, auto scripts, cms, auto dealers website\' , `keywords1` = \'\' , `keywords2` = \'\' , `keywords3` = \'\' , `header` = \'\' , `header1` = \'\' , `header2` = \'\' , `header3` = \'\' , `footer` = \'auto dealer script\' , `footer1` = \'\' , `footer2` = \'\' , `footer3` = \'\' , `picture_width` = \'300\' , `picture_height` = \'300\' , `thumbnail_width` = \'85\' , `thumbnail_height` = \'85\' , `picture` = \'6cd336564b67ca69c6ba962671531a1e.jpg\' , `thumbnail` = \'679e18dead31419c3970e35110fa1131.jpg\' , `logo` = \'be4cd43c8fb0780211ec6a165bb4d54b.jpg\' , `bigimage` = \'\' , `language` = \'english.php\' , `charsetlang` = \'utf-8\' , `language1` = \'-1\' , `charsetlang1` = \'\' , `language2` = \'-1\' , `charsetlang2` = \'\' , `language3` = \'-1\' , `charsetlang3` = \'\' , `languageadmin` = \'english.php\' , `wysiwyg` = \'1\' , `adprofiles` = \'\' , `config_date_format` = \'M d, Y\' , `config_date_format_admin` = \'M d, Y\' , `config_price1_format` = \'.\' , `config_price2_format` = \',\' , `config_price3_format` = \'0\' , `config_separator` = \' ::\' , `banned_ip_after_try_to_loggin` = \'10\' , `add_image_text_` = \'1\' , `add_image_text_width_position` = \'1\' , `add_image_text_height_position` = \'2\' , `add_image_text_position` = \'0\' , `add_image_text_font` = \'4\' , `add_image_text_string` = \'Acc Autos\' , `add_image_text_color` = \'255|255|255\' , `add_image_text_color_to_thumb` = \'0\' , `aMaxLifeTime` = \'300\' , `show_one_homepage_lastlisting` = \'1\' , `no_show_one_homepage_lastlisting` = \'4\' , `show_lastlisting_onallpages` = \'1\' , `show_one_homepage_sponsored` = \'1\' , `no_show_one_homepage_sponsored` = \'4\' , `show_sponsored_onallpages` = \'1\' , `use_old_sponsored_format` = \'0\' , `price_before` = \'1\' , `delay_How_many_days_this_object_will_be_active` = \'30\' , `how_many_days_before_expire_object_send_email` = \'3\' , `how_many_days_before_expire_canbe_reactivated` = \'3\' , `how_many_days_before_expire_account_send_email` = \'3\' , `send_email_to_admin_every_day` = \'0\' , `show_only_yes_no_for_active` = \'0\' , `googlekey` = \'ABQIAAAAh9CYXq3TnRq3WF6pNciQCxRi_j0U6kJrkFvY4-OX2XYmEAa76BSxI9sJndrDb59e-MOTZ87rWcOezw\' , `categorymakemodel` = \'1\' WHERE `id`=\'1\' limit 1','2009-02-06 19:34:16'),(26,'1','Delete Gallery ( 3: ) ','delete from `accs_gallery` WHERE `id`=\'3\'','2009-02-06 19:35:13'),(27,'1','User login admin','','2009-02-07 02:16:11'),(28,'1','User login admin','','2009-02-07 05:27:26'),(29,'1','User logout','','2009-02-07 05:28:15'),(30,'80.80.161.140','User try to login: user (Username not exist in database!) ','','2009-02-07 05:28:31'),(31,'80.80.161.140','User try to login: user (Username not exist in database!) ','','2009-02-07 05:28:44'),(32,'80.80.161.140','User try to login: user (Username not exist in database!) ','','2009-02-07 05:29:12'),(33,'80.80.161.140','User try to login: user (Username not exist in database!) ','','2009-02-07 05:29:41'),(34,'80.80.161.140','User try to login: admin (Please input the security code) ','','2009-02-07 05:30:22'),(35,'122.164.155.90','User try to login: user (Username not exist in database!) ','','2009-02-07 09:06:40'),(36,'122.164.155.90','User try to login: admin (Please input the security code) ','','2009-02-07 09:07:04'),(37,'122.164.155.90','User try to login: admin (Please input the security code) ','','2009-02-07 09:07:22'),(38,'1','User login admin','','2009-02-07 09:07:37'),(39,'1','User login admin','','2009-02-07 10:44:50'); /*!40000 ALTER TABLE `accs_logging` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_make` -- DROP TABLE IF EXISTS `accs_make`; CREATE TABLE `accs_make` ( `id` int(11) NOT NULL auto_increment, `categoryid` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_make` -- LOCK TABLES `accs_make` WRITE; /*!40000 ALTER TABLE `accs_make` DISABLE KEYS */; INSERT INTO `accs_make` VALUES (1,2,'Acura','Acura','',''),(2,1,'Alfa Romeo','Alfa Romeo','',''),(3,2,'Alpina','Alpina','',''),(6,32,'Alfa Romeo','','',''),(7,32,'Volvo','','',''); /*!40000 ALTER TABLE `accs_make` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_members` -- DROP TABLE IF EXISTS `accs_members`; CREATE TABLE `accs_members` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '0', `unic_id` varchar(255) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `date_add` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_members` -- LOCK TABLES `accs_members` WRITE; /*!40000 ALTER TABLE `accs_members` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_messages` -- DROP TABLE IF EXISTS `accs_messages`; CREATE TABLE `accs_messages` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `name` varchar(40) NOT NULL default '', `email` varchar(40) NOT NULL default '', `phone` varchar(255) NOT NULL default '', `message` text, `date_add` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_messages` -- LOCK TABLES `accs_messages` WRITE; /*!40000 ALTER TABLE `accs_messages` DISABLE KEYS */; INSERT INTO `accs_messages` VALUES (1,1,'test','sales@vacationrentalscript.com','test','test test test test test test test test test test test test test test test ','2008-10-07'); /*!40000 ALTER TABLE `accs_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_model` -- DROP TABLE IF EXISTS `accs_model`; CREATE TABLE `accs_model` ( `id` int(11) NOT NULL auto_increment, `categoryid` int(11) NOT NULL default '0', `makeid` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_model` -- LOCK TABLES `accs_model` WRITE; /*!40000 ALTER TABLE `accs_model` DISABLE KEYS */; INSERT INTO `accs_model` VALUES (1,2,1,'MDX','MDX','',''),(2,2,1,'NSX','NSX','',''),(3,2,1,'Alfa 33','Alfa 33','',''),(39,32,6,'149','','',''),(5,2,3,'B3','B3','',''),(6,2,3,'Roadster S','Roadster S','',''),(7,2,3,'B12','B12','',''),(8,2,3,'gdada','gdada','',''),(58,32,6,'GT','','',''),(40,32,6,'8C','','',''),(41,32,6,'Alfa 145','','',''),(42,32,6,'Alfa 146','','',''),(43,32,6,'Alfa 147','','',''),(44,32,6,'Alfa 155','','',''),(45,32,6,'Alfa 156','','',''),(46,32,6,'Alfa 159','','',''),(47,32,6,'Alfa 164','','',''),(48,32,6,'Alfa 166','','',''),(49,32,6,'Alfa 33','','',''),(50,32,6,'Alfa 75','','',''),(51,32,6,'Alfa 90','','',''),(52,32,6,'Alfasud','','',''),(53,32,6,'Alfetta','','',''),(54,32,6,'Brera','','',''),(55,32,6,'Crosswagon','','',''),(56,32,6,'Giulia','','',''),(57,32,6,'Giulietta','','',''),(59,32,6,'GTV','','',''),(60,32,6,'Junior','','',''),(61,32,6,'MiTo','','',''),(62,32,6,'RZ/SZ','','',''),(63,32,6,'Spider','','',''),(64,32,6,'Sprint','','',''),(65,32,6,'Other','','',''),(66,32,7,'240','','',''),(67,32,7,'244','','',''),(68,32,7,'245','','',''),(69,32,7,'262','','',''),(70,32,7,'264','','',''),(71,32,7,'340','','',''),(72,32,7,'360','','',''),(73,32,7,'440','','',''),(74,32,7,'460','','',''),(75,32,7,'480','','',''),(76,32,7,'740','','',''),(77,32,7,'744','','',''),(78,32,7,'745','','',''),(79,32,7,'760','','',''),(80,32,7,'780','','',''),(81,32,7,'850','','',''),(82,32,7,'855','','',''),(83,32,7,'940','','',''),(84,32,7,'944','','',''),(85,32,7,'945','','',''),(86,32,7,'960','','',''),(87,32,7,'965','','',''),(88,32,7,'Amazon','','',''),(89,32,7,'C30','','',''),(90,32,7,'C70','','',''),(91,32,7,'Polar','','',''),(92,32,7,'S40','','',''),(93,32,7,'S60','','',''),(94,32,7,'S70','','',''),(95,32,7,'S80','','',''),(96,32,7,'S90','','',''),(97,32,7,'V40','','',''),(98,32,7,'V50','','',''),(99,32,7,'V70','','',''),(100,32,7,'V90','','',''),(101,32,7,'XC 60','','',''),(102,32,7,'XC 70','','',''),(103,32,7,'XC 90','','',''),(104,32,7,'Other','','',''); /*!40000 ALTER TABLE `accs_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_news` -- DROP TABLE IF EXISTS `accs_news`; CREATE TABLE `accs_news` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `title1` varchar(255) NOT NULL default '', `title2` varchar(255) NOT NULL default '', `title3` varchar(255) NOT NULL default '', `content` text NOT NULL, `content1` text NOT NULL, `content2` text NOT NULL, `content3` text NOT NULL, `date` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_news` -- LOCK TABLES `accs_news` WRITE; /*!40000 ALTER TABLE `accs_news` DISABLE KEYS */; INSERT INTO `accs_news` VALUES (1,'New in version 5.0','','','','

New in version 5.0
\r\n
\r\n- new design
\r\n- google map search
\r\n- owner page in front end
\r\n- seo settings (you can choose and customize now the sitetitle, metakeywords and metadescription for every page)
\r\n- select the add/modify cars form fields order
\r\n- add up to 10 custom fields for cars form
\r\n- we make the relation between category, make and model (you can also disable this and leave only make - model relation)
\r\n- import category, make, model and import settings

','','','','2009-02-05'); /*!40000 ALTER TABLE `accs_news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_orders` -- DROP TABLE IF EXISTS `accs_orders`; CREATE TABLE `accs_orders` ( `id` int(10) unsigned NOT NULL auto_increment, `receiver_email` varchar(60) default NULL, `item_name` varchar(100) default NULL, `item_number` varchar(10) default NULL, `quantity` varchar(6) default NULL, `payment_status` varchar(10) default NULL, `pending_reason` varchar(10) default NULL, `payment_date` varchar(20) default NULL, `mc_gross` varchar(20) default NULL, `mc_fee` varchar(20) default NULL, `tax` varchar(20) default NULL, `mc_currency` varchar(3) default NULL, `txn_id` varchar(20) default NULL, `txn_type` varchar(10) default NULL, `first_name` varchar(30) default NULL, `last_name` varchar(40) default NULL, `address_street` varchar(50) default NULL, `address_city` varchar(30) default NULL, `address_state` varchar(30) default NULL, `address_zip` varchar(20) default NULL, `address_country` varchar(30) default NULL, `address_status` varchar(10) default NULL, `payer_email` varchar(60) default NULL, `payer_status` varchar(10) default NULL, `payment_type` varchar(10) default NULL, `notify_version` varchar(10) default NULL, `verify_sign` varchar(10) default NULL, `referrer_id` varchar(10) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_orders` -- LOCK TABLES `accs_orders` WRITE; /*!40000 ALTER TABLE `accs_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_payment` -- DROP TABLE IF EXISTS `accs_payment`; CREATE TABLE `accs_payment` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `business` varchar(255) NOT NULL default '', `item_name` varchar(255) NOT NULL default '', `currency_code` varchar(255) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_payment` -- LOCK TABLES `accs_payment` WRITE; /*!40000 ALTER TABLE `accs_payment` DISABLE KEYS */; INSERT INTO `accs_payment` VALUES (1,'Paypal','sales@accscripts.com','One year cars at accscripts.com','USD',1),(2,'AuthorizeNET','cnpdev4444','623P88zxd6Pj3Pz6','1',1),(3,'2Checkout','561941','8','1.268',1); /*!40000 ALTER TABLE `accs_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_paymenthistory` -- DROP TABLE IF EXISTS `accs_paymenthistory`; CREATE TABLE `accs_paymenthistory` ( `id` int(11) NOT NULL auto_increment, `adminid` int(11) NOT NULL default '0', `amout` float(11,2) NOT NULL default '0.00', `message` text, `date_add` date NOT NULL default '0000-00-00', `success` smallint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_paymenthistory` -- LOCK TABLES `accs_paymenthistory` WRITE; /*!40000 ALTER TABLE `accs_paymenthistory` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_paymenthistory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_rights` -- DROP TABLE IF EXISTS `accs_rights`; CREATE TABLE `accs_rights` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `settings` tinyint(1) NOT NULL default '0', `template` tinyint(1) NOT NULL default '0', `admin_add` smallint(1) NOT NULL default '0', `admin_view` smallint(1) NOT NULL default '0', `admin_delete` smallint(1) NOT NULL default '0', `admin_edit` smallint(1) NOT NULL default '0', `rights_add` smallint(1) NOT NULL default '0', `rights_view` smallint(1) NOT NULL default '0', `rights_delete` smallint(1) NOT NULL default '0', `rights_edit` smallint(1) NOT NULL default '0', `category_add` smallint(1) NOT NULL default '0', `category_view` smallint(1) NOT NULL default '0', `category_delete` smallint(1) NOT NULL default '0', `category_edit` smallint(1) NOT NULL default '0', `make_add` smallint(1) NOT NULL default '0', `make_view` smallint(1) NOT NULL default '0', `make_delete` smallint(1) NOT NULL default '0', `make_edit` smallint(1) NOT NULL default '0', `cars_add` smallint(1) NOT NULL default '0', `cars_view` smallint(1) NOT NULL default '0', `cars_delete` smallint(1) NOT NULL default '0', `cars_edit` smallint(1) NOT NULL default '0', `view_all_cars` tinyint(1) NOT NULL default '0', `features_add` smallint(1) NOT NULL default '0', `features_view` smallint(1) NOT NULL default '0', `features_delete` smallint(1) NOT NULL default '0', `features_edit` smallint(1) NOT NULL default '0', `news_add` smallint(1) NOT NULL default '0', `news_view` smallint(1) NOT NULL default '0', `news_delete` smallint(1) NOT NULL default '0', `news_edit` smallint(1) NOT NULL default '0', `customlinks_add` smallint(1) NOT NULL default '0', `customlinks_view` smallint(1) NOT NULL default '0', `customlinks_delete` smallint(1) NOT NULL default '0', `customlinks_edit` smallint(1) NOT NULL default '0', `faq_add` smallint(1) NOT NULL default '0', `faq_view` smallint(1) NOT NULL default '0', `faq_delete` smallint(1) NOT NULL default '0', `faq_edit` smallint(1) NOT NULL default '0', `members_add` smallint(1) NOT NULL default '0', `members_view` smallint(1) NOT NULL default '0', `members_delete` smallint(1) NOT NULL default '0', `members_edit` smallint(1) NOT NULL default '0', `sponsored_add` smallint(1) NOT NULL default '0', `sponsored_view` smallint(1) NOT NULL default '0', `sponsored_delete` smallint(1) NOT NULL default '0', `sponsored_edit` smallint(1) NOT NULL default '0', `sendemail` smallint(1) NOT NULL default '0', `homepage` smallint(1) NOT NULL default '0', `sendemailadmin` smallint(1) NOT NULL default '0', `adprofiles_add` smallint(1) NOT NULL default '0', `adprofiles_view` smallint(1) NOT NULL default '0', `adprofiles_delete` smallint(1) NOT NULL default '0', `adprofiles_edit` smallint(1) NOT NULL default '0', `payment` tinyint(1) NOT NULL default '0', `orders_add` smallint(1) NOT NULL default '0', `orders_view` smallint(1) NOT NULL default '0', `orders_delete` smallint(1) NOT NULL default '0', `orders_edit` smallint(1) NOT NULL default '0', `model_add` smallint(1) NOT NULL default '0', `model_view` smallint(1) NOT NULL default '0', `model_delete` smallint(1) NOT NULL default '0', `model_edit` smallint(1) NOT NULL default '0', `summary` smallint(1) NOT NULL default '0', `backup` smallint(1) NOT NULL default '0', `tpl` smallint(1) NOT NULL default '0', `language` smallint(1) NOT NULL default '0', `bodytype_add` smallint(1) NOT NULL default '0', `bodytype_view` smallint(1) NOT NULL default '0', `bodytype_delete` smallint(1) NOT NULL default '0', `bodytype_edit` smallint(1) NOT NULL default '0', `transmission_add` smallint(1) NOT NULL default '0', `transmission_view` smallint(1) NOT NULL default '0', `transmission_delete` smallint(1) NOT NULL default '0', `transmission_edit` smallint(1) NOT NULL default '0', `intcolor_add` smallint(1) NOT NULL default '0', `intcolor_view` smallint(1) NOT NULL default '0', `intcolor_delete` smallint(1) NOT NULL default '0', `intcolor_edit` smallint(1) NOT NULL default '0', `extcolor_add` smallint(1) NOT NULL default '0', `extcolor_view` smallint(1) NOT NULL default '0', `extcolor_delete` smallint(1) NOT NULL default '0', `extcolor_edit` smallint(1) NOT NULL default '0', `ips_add` smallint(1) NOT NULL default '0', `ips_view` smallint(1) NOT NULL default '0', `ips_delete` smallint(1) NOT NULL default '0', `ips_edit` smallint(1) NOT NULL default '0', `logging_add` smallint(1) NOT NULL default '0', `logging_view` smallint(1) NOT NULL default '0', `logging_delete` smallint(1) NOT NULL default '0', `logging_edit` smallint(1) NOT NULL default '0', `bannersettings` smallint(1) NOT NULL default '0', `banner_add` smallint(1) NOT NULL default '0', `banner_view` smallint(1) NOT NULL default '0', `banner_delete` smallint(1) NOT NULL default '0', `banner_edit` smallint(1) NOT NULL default '0', `import` smallint(1) NOT NULL default '0', `importsettings` smallint(1) NOT NULL default '0', `export` smallint(1) NOT NULL default '0', `fixtools` smallint(1) NOT NULL default '0', `paymenthistory_add` smallint(1) NOT NULL default '0', `paymenthistory_view` smallint(1) NOT NULL default '0', `paymenthistory_delete` smallint(1) NOT NULL default '0', `paymenthistory_edit` smallint(1) NOT NULL default '0', `statssettings` smallint(1) NOT NULL default '0', `stats` smallint(1) NOT NULL default '0', `typeofvehicle_add` smallint(1) NOT NULL default '0', `typeofvehicle_view` smallint(1) NOT NULL default '0', `typeofvehicle_delete` smallint(1) NOT NULL default '0', `typeofvehicle_edit` smallint(1) NOT NULL default '0', `doors_add` smallint(1) NOT NULL default '0', `doors_view` smallint(1) NOT NULL default '0', `doors_delete` smallint(1) NOT NULL default '0', `doors_edit` smallint(1) NOT NULL default '0', `classifyemissions_add` smallint(1) NOT NULL default '0', `classifyemissions_view` smallint(1) NOT NULL default '0', `classifyemissions_delete` smallint(1) NOT NULL default '0', `classifyemissions_edit` smallint(1) NOT NULL default '0', `gearbox_add` smallint(1) NOT NULL default '0', `gearbox_view` smallint(1) NOT NULL default '0', `gearbox_delete` smallint(1) NOT NULL default '0', `gearbox_edit` smallint(1) NOT NULL default '0', `climaticcontrol_add` smallint(1) NOT NULL default '0', `climaticcontrol_view` smallint(1) NOT NULL default '0', `climaticcontrol_delete` smallint(1) NOT NULL default '0', `climaticcontrol_edit` smallint(1) NOT NULL default '0', `homepageowner` smallint(1) NOT NULL default '0', `helpowner` smallint(1) NOT NULL default '0', `importimportsettings` tinyint(1) NOT NULL default '0', `exportimportsettings` tinyint(1) NOT NULL default '0', `fieldstranslate` tinyint(1) NOT NULL default '0', `fieldsorder` tinyint(1) NOT NULL default '0', `importcategorymakemodel` tinyint(1) NOT NULL default '0', `exportcategorymakemodel` tinyint(1) NOT NULL default '0', `importcategorysettings` tinyint(1) NOT NULL default '0', `seosettings` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_rights` -- LOCK TABLES `accs_rights` WRITE; /*!40000 ALTER TABLE `accs_rights` DISABLE KEYS */; INSERT INTO `accs_rights` VALUES (1,'superadmin',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1),(2,'agent',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); /*!40000 ALTER TABLE `accs_rights` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_seosettings` -- DROP TABLE IF EXISTS `accs_seosettings`; CREATE TABLE `accs_seosettings` ( `id` int(11) NOT NULL auto_increment, `field` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_seosettings` -- LOCK TABLES `accs_seosettings` WRITE; /*!40000 ALTER TABLE `accs_seosettings` DISABLE KEYS */; INSERT INTO `accs_seosettings` VALUES (1,'homepage_sitetitle','|datetoday|'),(2,'homepage_metadescription','|datetoday|'),(3,'homepage_metakeywords','|datetoday|'),(4,'signup_sitetitle','signup'),(5,'signup_metadescription','signup'),(6,'signup_metakeywords','signup'),(7,'newsfront_sitetitle','news page'),(8,'newsfront_metadescription','news page'),(9,'newsfront_metakeywords','news page'),(10,'faqfront_sitetitle','faq'),(11,'faqfront_metadescription','faq'),(12,'faqfront_metakeywords','faq'),(13,'contact_sitetitle','contact the owner |name|'),(14,'contact_metadescription','contact the owner |name|'),(15,'contact_metakeywords','contact the owner |name|'),(16,'search_sitetitle','search page |category| |make| |model| page |page|'),(17,'search_metadescription','search page |category| |make| |model| page |page|'),(18,'search_metakeywords','search page |category| |make| |model| page |page|'),(19,'view_sitetitle','view all category'),(20,'view_metadescription','view all category'),(21,'view_metakeywords','view all category'),(22,'advsearch_sitetitle','advanced search page |category| |make| |model|'),(23,'advsearch_metadescription','advanced search page |category| |make| |model|'),(24,'advsearch_metakeywords','advanced search page |category| |make| |model|'),(25,'contactus_sitetitle','contact us'),(26,'contactus_metadescription','contact us'),(27,'contactus_metakeywords','contact us'),(28,'paymentfront_sitetitle','payment page |category| |make| |model| |stock| |id|'),(29,'paymentfront_metadescription','payment page |category| |make| |model| |stock| |id|'),(30,'paymentfront_metakeywords','payment page |category| |make| |model| |stock| |id|'),(31,'send_sitetitle','send to a friend page |year| |make| |model|'),(32,'send_metadescription','send to a friend page |year| |make| |model|'),(33,'send_metakeywords','send to a friend page |year| |make| |model|'),(34,'vehicle_information_sitetitle','print |year| |make| |model| |price| |id|'),(35,'vehicle_information_metadescription','print |year| |make| |model| |price| |id|'),(36,'vehicle_information_metakeywords','print |year| |make| |model| |price| |id|'),(37,'details_sitetitle','|year| |make| |model| |price| |features|'),(38,'details_metadescription','|year| |make| |model| |features|'),(39,'details_metakeywords','|year|, |make|, |model|, |stock|, |id|, |price|, |engine|, |extcolor|, |features|'),(40,'mycars_sitetitle','wishlist'),(41,'mycars_metadescription','wishlist'),(42,'mycars_metakeywords','wishlist'); /*!40000 ALTER TABLE `accs_seosettings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_sessions` -- DROP TABLE IF EXISTS `accs_sessions`; CREATE TABLE `accs_sessions` ( `SessionID` varchar(255) NOT NULL default '', `LastUpdated` datetime NOT NULL default '0000-00-00 00:00:00', `DataValue` text, `username` varchar(255) NOT NULL default '', `location` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '', PRIMARY KEY (`SessionID`), KEY `LastUpdated` (`LastUpdated`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `accs_sessions` -- LOCK TABLES `accs_sessions` WRITE; /*!40000 ALTER TABLE `accs_sessions` DISABLE KEYS */; INSERT INTO `accs_sessions` VALUES ('9800336beda42953030ffcd035a7c914','2009-02-07 10:58:37','language_session|N;language_sessionset|i:1;','admin','%2Fautos%2Fdemo%2Fadmin%2Findex.php%3Fp%3Dbackup%26page%3D0','62.205.249.249'); /*!40000 ALTER TABLE `accs_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_settings` -- DROP TABLE IF EXISTS `accs_settings`; CREATE TABLE `accs_settings` ( `id` int(11) NOT NULL auto_increment, `nrpageuser` int(11) NOT NULL default '0', `nrpageadmin` int(11) NOT NULL default '0', `currency` varchar(50) NOT NULL default '', `nocars` int(11) NOT NULL default '0', `nopictures` int(11) NOT NULL default '0', `rights_signupuser` int(11) NOT NULL default '0', `titlesite` varchar(255) NOT NULL default '', `titlesite1` varchar(255) NOT NULL default '', `titlesite2` varchar(255) NOT NULL default '', `titlesite3` varchar(255) NOT NULL default '', `description` text NOT NULL, `description1` text NOT NULL, `description2` text NOT NULL, `description3` text NOT NULL, `keywords` text NOT NULL, `keywords1` text NOT NULL, `keywords2` text NOT NULL, `keywords3` text NOT NULL, `header` text NOT NULL, `header1` text NOT NULL, `header2` text NOT NULL, `header3` text NOT NULL, `footer` text NOT NULL, `footer1` text NOT NULL, `footer2` text NOT NULL, `footer3` text NOT NULL, `picture_width` int(11) NOT NULL default '0', `picture_height` int(11) NOT NULL default '0', `thumbnail_width` int(11) NOT NULL default '0', `thumbnail_height` int(11) NOT NULL default '0', `picture` varchar(40) NOT NULL default '', `thumbnail` varchar(40) NOT NULL default '', `logo` varchar(40) NOT NULL default '', `bigimage` varchar(40) NOT NULL default '', `language` varchar(255) NOT NULL default '', `charsetlang` varchar(255) NOT NULL default 'iso-8859-1', `language1` varchar(255) NOT NULL default '', `charsetlang1` varchar(255) NOT NULL default 'iso-8859-1', `language2` varchar(255) NOT NULL default '', `charsetlang2` varchar(255) NOT NULL default 'iso-8859-1', `language3` varchar(255) NOT NULL default '', `charsetlang3` varchar(255) NOT NULL default 'iso-8859-1', `languageadmin` varchar(255) NOT NULL default '', `wysiwyg` smallint(1) NOT NULL default '0', `adprofiles` tinyint(1) NOT NULL default '0', `config_date_format` varchar(255) NOT NULL default '', `config_date_format_admin` varchar(255) NOT NULL default '', `config_price1_format` varchar(255) NOT NULL default '', `config_price2_format` varchar(255) NOT NULL default '', `config_price3_format` int(11) NOT NULL default '0', `config_separator` varchar(255) NOT NULL default '', `banned_ip_after_try_to_loggin` int(3) NOT NULL default '30', `add_image_text_` tinyint(1) NOT NULL default '0', `add_image_text_width_position` int(3) NOT NULL default '0', `add_image_text_height_position` int(3) NOT NULL default '0', `add_image_text_position` int(3) NOT NULL default '0', `add_image_text_font` tinyint(1) NOT NULL default '0', `add_image_text_string` varchar(255) NOT NULL default '', `add_image_text_color` varchar(255) NOT NULL default '', `add_image_text_color_to_thumb` tinyint(1) NOT NULL default '0', `aMaxLifeTime` int(4) NOT NULL default '0', `show_one_homepage_lastlisting` tinyint(1) NOT NULL default '0', `no_show_one_homepage_lastlisting` int(3) NOT NULL default '0', `show_lastlisting_onallpages` tinyint(1) NOT NULL default '0', `show_one_homepage_sponsored` tinyint(1) NOT NULL default '0', `no_show_one_homepage_sponsored` int(3) NOT NULL default '0', `show_sponsored_onallpages` tinyint(1) NOT NULL default '0', `use_old_sponsored_format` tinyint(1) NOT NULL default '0', `price_before` tinyint(1) NOT NULL default '0', `delay_How_many_days_this_object_will_be_active` int(11) NOT NULL default '0', `how_many_days_before_expire_object_send_email` int(11) NOT NULL default '0', `how_many_days_before_expire_canbe_reactivated` int(11) NOT NULL default '0', `how_many_days_before_expire_account_send_email` int(11) NOT NULL default '0', `send_email_to_admin_every_day` smallint(1) NOT NULL default '0', `show_only_yes_no_for_active` smallint(1) NOT NULL default '0', `googlekey` varchar(255) NOT NULL default '', `categorymakemodel` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_settings` -- LOCK TABLES `accs_settings` WRITE; /*!40000 ALTER TABLE `accs_settings` DISABLE KEYS */; INSERT INTO `accs_settings` VALUES (1,6,10,'USD',3,6,2,'Acc Autos','','','','Acc Autos is a professional solution for a car sales website. Although you need only ten minutes to install, it is both easy to use and rich in the features you need.','','','','Acc Autos, auto dealer script, php scripts and programs, PHP Classified Ads, PHP Autos, car sales website, buy car script, auto scripts, cms, auto dealers website','','','','','','','','auto dealer script','','','',300,300,85,85,'6cd336564b67ca69c6ba962671531a1e.jpg','679e18dead31419c3970e35110fa1131.jpg','be4cd43c8fb0780211ec6a165bb4d54b.jpg','','english.php','utf-8','-1','','-1','','-1','','english.php',1,0,'M d, Y','M d, Y','.',',',0,' ::',10,1,1,2,0,4,'Acc Autos','255|255|255',0,300,1,4,1,1,4,1,0,1,30,3,3,3,0,0,'ABQIAAAAh9CYXq3TnRq3WF6pNciQCxRi_j0U6kJrkFvY4-OX2XYmEAa76BSxI9sJndrDb59e-MOTZ87rWcOezw',1); /*!40000 ALTER TABLE `accs_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_settingsupdate` -- DROP TABLE IF EXISTS `accs_settingsupdate`; CREATE TABLE `accs_settingsupdate` ( `id` int(11) NOT NULL auto_increment, `lastupdate` varchar(14) default NULL, `lastupdateaccounts` varchar(14) default NULL, `lastupdateemailsent` varchar(14) default NULL, `lastupdateemailsentaccounts` varchar(14) default NULL, `emailsenttoday` smallint(1) NOT NULL default '0', `emailsenttodayaccounts` smallint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_settingsupdate` -- LOCK TABLES `accs_settingsupdate` WRITE; /*!40000 ALTER TABLE `accs_settingsupdate` DISABLE KEYS */; INSERT INTO `accs_settingsupdate` VALUES (1,'20090207000449','20090206000551','20061124144636','20090206193300',1,1); /*!40000 ALTER TABLE `accs_settingsupdate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_sponsored` -- DROP TABLE IF EXISTS `accs_sponsored`; CREATE TABLE `accs_sponsored` ( `id` int(11) NOT NULL auto_increment, `carid` int(11) NOT NULL default '0', `date_start` date NOT NULL default '0000-00-00', `date_ends` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_sponsored` -- LOCK TABLES `accs_sponsored` WRITE; /*!40000 ALTER TABLE `accs_sponsored` DISABLE KEYS */; INSERT INTO `accs_sponsored` VALUES (3,1,'2008-04-01','2012-01-08'); /*!40000 ALTER TABLE `accs_sponsored` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_statistics` -- DROP TABLE IF EXISTS `accs_statistics`; CREATE TABLE `accs_statistics` ( `id` int(11) NOT NULL auto_increment, `carsid` int(11) NOT NULL default '0', `carsviews` int(11) NOT NULL default '0', `contactownerviews` int(11) NOT NULL default '0', `contactownersend` int(11) NOT NULL default '0', `emailstofriendviews` int(11) NOT NULL default '0', `emailstofriendsend` int(11) NOT NULL default '0', `carsprints` int(11) NOT NULL default '0', `addstowishlist` int(11) NOT NULL default '0', `date_add` date NOT NULL default '0000-00-00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_statistics` -- LOCK TABLES `accs_statistics` WRITE; /*!40000 ALTER TABLE `accs_statistics` DISABLE KEYS */; INSERT INTO `accs_statistics` VALUES (1,1,7,0,0,0,0,0,0,'2009-02-05'),(2,1,2,0,0,0,0,0,0,'2009-02-06'); /*!40000 ALTER TABLE `accs_statistics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_statssettings` -- DROP TABLE IF EXISTS `accs_statssettings`; CREATE TABLE `accs_statssettings` ( `id` int(11) NOT NULL auto_increment, `ignoredomains` text NOT NULL, `ignoresubdomenins` tinyint(1) NOT NULL default '0', `rowsperpage` int(2) NOT NULL default '30', `ctime` varchar(14) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_statssettings` -- LOCK TABLES `accs_statssettings` WRITE; /*!40000 ALTER TABLE `accs_statssettings` DISABLE KEYS */; INSERT INTO `accs_statssettings` VALUES (1,'',0,30,'20061010130714'); /*!40000 ALTER TABLE `accs_statssettings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_statssettingsupdate` -- DROP TABLE IF EXISTS `accs_statssettingsupdate`; CREATE TABLE `accs_statssettingsupdate` ( `id` int(11) unsigned NOT NULL auto_increment, `data` longtext, `datareferrers` longtext NOT NULL, `datasearches` longtext NOT NULL, `sistem` longtext NOT NULL, `lastupdate` varchar(14) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_statssettingsupdate` -- LOCK TABLES `accs_statssettingsupdate` WRITE; /*!40000 ALTER TABLE `accs_statssettingsupdate` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_statssettingsupdate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_statsvisits` -- DROP TABLE IF EXISTS `accs_statsvisits`; CREATE TABLE `accs_statsvisits` ( `id` int(11) unsigned NOT NULL auto_increment, `ctime` varchar(16) default NULL, `ip` varchar(15) NOT NULL default '', `fromreferer` varchar(255) NOT NULL default '', `fromdomain` varchar(255) NOT NULL default '', `page` varchar(255) NOT NULL default '', `page_title` varchar(255) NOT NULL default '', `OSName` varchar(20) NOT NULL default '', `BrowserName` varchar(25) NOT NULL default '', `ScreenSize` varchar(15) NOT NULL default '', `Colours` varchar(15) NOT NULL default '', `searchterms` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `dt` (`ctime`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Dumping data for table `accs_statsvisits` -- LOCK TABLES `accs_statsvisits` WRITE; /*!40000 ALTER TABLE `accs_statsvisits` DISABLE KEYS */; /*!40000 ALTER TABLE `accs_statsvisits` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_template` -- DROP TABLE IF EXISTS `accs_template`; CREATE TABLE `accs_template` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `from` varchar(255) NOT NULL default '', `signup_subject` varchar(255) NOT NULL default '', `signup_subject1` varchar(255) NOT NULL default '', `signup_subject2` varchar(255) NOT NULL default '', `signup_subject3` varchar(255) NOT NULL default '', `signup_body` text NOT NULL, `signup_body1` text NOT NULL, `signup_body2` text NOT NULL, `signup_body3` text NOT NULL, `contact_subject` varchar(255) NOT NULL default '', `contact_subject1` varchar(255) NOT NULL default '', `contact_subject2` varchar(255) NOT NULL default '', `contact_subject3` varchar(255) NOT NULL default '', `contact_body` text NOT NULL, `contact_body1` text NOT NULL, `contact_body2` text NOT NULL, `contact_body3` text NOT NULL, `signupmembers_subject` varchar(255) NOT NULL default '', `signupmembers_subject1` varchar(255) NOT NULL default '', `signupmembers_subject2` varchar(255) NOT NULL default '', `signupmembers_subject3` varchar(255) NOT NULL default '', `signupmembers_body` text NOT NULL, `signupmembers_body1` text NOT NULL, `signupmembers_body2` text NOT NULL, `signupmembers_body3` text NOT NULL, `payment_subject` varchar(255) NOT NULL default '', `payment_subject1` varchar(255) NOT NULL default '', `payment_subject2` varchar(255) NOT NULL default '', `payment_subject3` varchar(255) NOT NULL default '', `payment_body` text NOT NULL, `payment_body1` text NOT NULL, `payment_body2` text NOT NULL, `payment_body3` text NOT NULL, `friend_subject` varchar(255) NOT NULL default '', `friend_subject1` varchar(255) NOT NULL default '', `friend_subject2` varchar(255) NOT NULL default '', `friend_subject3` varchar(255) NOT NULL default '', `friend_body` text NOT NULL, `friend_body1` text NOT NULL, `friend_body2` text NOT NULL, `friend_body3` text NOT NULL, `delaymessages_subject` varchar(255) default NULL, `delaymessages_subject1` varchar(255) NOT NULL default '', `delaymessages_subject2` varchar(255) NOT NULL default '', `delaymessages_subject3` varchar(255) NOT NULL default '', `delaymessages_body` text NOT NULL, `delaymessages_body1` text NOT NULL, `delaymessages_body2` text NOT NULL, `delaymessages_body3` text NOT NULL, `delaymessagesaccounts_subject` varchar(255) default NULL, `delaymessagesaccounts_subject1` varchar(255) NOT NULL default '', `delaymessagesaccounts_subject2` varchar(255) NOT NULL default '', `delaymessagesaccounts_subject3` varchar(255) NOT NULL default '', `delaymessagesaccounts_body` text NOT NULL, `delaymessagesaccounts_body1` text NOT NULL, `delaymessagesaccounts_body2` text NOT NULL, `delaymessagesaccounts_body3` text NOT NULL, `messagepaymentfailed_subject` varchar(255) default NULL, `messagepaymentfailed_subject1` varchar(255) NOT NULL default '', `messagepaymentfailed_subject2` varchar(255) NOT NULL default '', `messagepaymentfailed_subject3` varchar(255) NOT NULL default '', `messagepaymentfailed_body` text NOT NULL, `messagepaymentfailed_body1` text NOT NULL, `messagepaymentfailed_body2` text NOT NULL, `messagepaymentfailed_body3` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_template` -- LOCK TABLES `accs_template` WRITE; /*!40000 ALTER TABLE `accs_template` DISABLE KEYS */; INSERT INTO `accs_template` VALUES (1,'sales@accscripts.com','','Welcome {username} to sell cars','','','','Hello {username}
Please click here to confirm this email address:
{link}

Details:
Username: {username}
Password: {password}
Email: {email}

Thanks.','','','','New message for car {model}-#{id}1','','','','Hello {name}
You just receive a new message for the car:
{model}-#{id}
from:
______
Name: {guest_name}
Phone: {guest_phone}
Email: {guest_email}
Message: {guest_message}
_____
Thanks.','','','','Sign Up Members1','','','','Please click here to confirm this email address:
{link}

Details:
Name: {name}
Email: {email}

Thanks.','','','','Account renewed','','','','
\r\nAlexandru Cuibari:
\r\n
\r\n{date}
\r\n
\r\nThank you for renewing your account.
\r\nYour account ({id} - {username}) has been successfully renewed.
\r\n
\r\nAmount: {amout}
\r\nPeriod: {days}days
\r\n
\r\nClick here to go in your account\r\n
\r\nThank you.
','','','','Subject send to a friend1','','','','Hello {friendname}
You just receive a new message from {guest_name} ( {guest_email} ) :
______
Message: {guest_message}

Visit this site to view:
{url}','','','','Subject for delay email','','','','

Hello {name}
\r\nYour objects:
\r\n

\r\n~~~repeatstart~~~
\r\n{category}-{make}-{model}-#{id} will expire in {daysremain} days. \r\nClick here to continue your object:.
> \r\nClick here for another {days} days
\r\n~~~repeatend~~~\r\n

\r\nOr ignore this email and you add will be suspended.
\r\nThanks.\r\n\r\n','','','','Subject for renew account','','','','Hello {name}\r\n
Your account will expire in {daysremain} days.
\r\nClick here to and renew your account

\r\n\r\nOr ignore this email and you account will be suspended.
\r\nThanks.','','','','','','','','','','',''); /*!40000 ALTER TABLE `accs_template` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_transmission` -- DROP TABLE IF EXISTS `accs_transmission`; CREATE TABLE `accs_transmission` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_transmission` -- LOCK TABLES `accs_transmission` WRITE; /*!40000 ALTER TABLE `accs_transmission` DISABLE KEYS */; INSERT INTO `accs_transmission` VALUES (1,'AUTOMATIC','','',''),(2,'Other','','',''); /*!40000 ALTER TABLE `accs_transmission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accs_typeofvehicle` -- DROP TABLE IF EXISTS `accs_typeofvehicle`; CREATE TABLE `accs_typeofvehicle` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `name1` varchar(255) NOT NULL default '', `name2` varchar(255) NOT NULL default '', `name3` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `accs_typeofvehicle` -- LOCK TABLES `accs_typeofvehicle` WRITE; /*!40000 ALTER TABLE `accs_typeofvehicle` DISABLE KEYS */; INSERT INTO `accs_typeofvehicle` VALUES (1,'Single day registration','','',''),(2,'Demonstration vehicle','','',''),(3,'Classic vehicle','','',''),(4,'Other','','',''); /*!40000 ALTER TABLE `accs_typeofvehicle` 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 */;