
--
-- Table structure for table `idx_link_temp`
--

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `spam` char(1) NOT NULL DEFAULT '0',
  `link_id` mediumint(9) DEFAULT NULL,
  `category_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `url` text NOT NULL,
  `description` text NOT NULL,
  `contact_name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `hits` mediumint(9) DEFAULT NULL,
  `votes` smallint(6) DEFAULT NULL,
  `rating` float(4,2) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bid` smallint(6) NOT NULL DEFAULT '0',
  `new` char(1) DEFAULT NULL,
  `hot` char(1) DEFAULT NULL,
  `top_rated` char(1) DEFAULT NULL,
  `pick` char(1) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `updated` char(1) DEFAULT NULL,
  `reviews` smallint(6) DEFAULT NULL,
  `avg_review` float(4,2) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `official_review` text,
  `keywords` varchar(255) DEFAULT NULL,
  `cat1` mediumint(6) NOT NULL DEFAULT '0',
  `cat2` mediumint(6) NOT NULL DEFAULT '0',
  `suspended` char(1) NOT NULL DEFAULT '0',
  `reciprocal_url` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp`
--


--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp_user`
--


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_user`
--


--
-- Table structure for table `idx_mailing_list`
--

CREATE TABLE `idx_mailing_list` (
  `email` varchar(50) NOT NULL DEFAULT '',
  `code` varchar(4) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `body` text,
  `subject` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_message`
--


--
-- Table structure for table `idx_notification`
--

CREATE TABLE `idx_notification` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `category_id` mediumint(9) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_notification`
--


--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `engine` char(1) NOT NULL DEFAULT '',
  `rank` tinyint(4) NOT NULL DEFAULT '0',
  `last_update` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pagerank`
--

INSERT INTO `idx_pagerank` VALUES (11,'g',0,'2011-11-15'),(1,'g',0,'2012-02-23'),(17,'g',0,'2012-02-03'),(25,'g',0,'2011-12-04'),(31,'g',0,'2011-12-04'),(44,'g',0,'2011-12-04'),(16,'g',0,'2012-02-03'),(18,'g',0,'2012-02-03'),(51,'g',0,'2012-02-06'),(49,'g',0,'2012-02-06'),(14,'g',0,'2012-02-06'),(54,'g',0,'2012-02-06'),(56,'g',0,'2012-02-06'),(50,'g',0,'2012-02-06'),(53,'g',0,'2012-02-06'),(48,'g',0,'2012-02-06'),(19,'g',0,'2012-02-06'),(28,'g',0,'2012-02-03'),(55,'g',0,'2011-11-23'),(21,'g',0,'2012-02-03'),(22,'g',0,'2011-11-23'),(58,'g',0,'2011-12-30'),(29,'g',0,'2012-02-03'),(36,'g',0,'2012-02-03'),(41,'g',0,'2012-02-03'),(52,'g',0,'2012-02-03'),(40,'g',0,'2012-02-03'),(27,'g',0,'2012-01-19'),(26,'g',0,'2012-02-24'),(39,'g',0,'2012-01-03'),(30,'g',0,'2012-01-24'),(43,'g',0,'2012-01-24'),(45,'g',0,'2012-01-24'),(42,'g',0,'2012-01-09'),(8,'g',0,'2011-12-28'),(47,'g',0,'2012-02-03'),(23,'g',0,'2012-01-19'),(3,'g',0,'2012-02-06'),(57,'g',0,'2012-02-06'),(35,'g',0,'2012-02-06'),(62,'g',0,'2011-12-03'),(34,'g',0,'2012-03-04'),(37,'g',0,'2012-01-09'),(2,'g',0,'2012-01-09'),(20,'g',0,'2011-12-03'),(24,'g',0,'2011-12-03'),(4,'g',0,'2012-01-09'),(5,'g',0,'2012-01-09'),(60,'g',0,'2012-01-09'),(9,'g',0,'2012-01-09'),(61,'g',0,'2012-03-01'),(59,'g',0,'2012-01-09'),(6,'g',0,'2012-01-09'),(7,'g',0,'2012-01-19'),(12,'g',0,'2012-01-19'),(32,'g',0,'2012-01-19'),(10,'g',0,'2012-01-19'),(15,'g',0,'2012-01-19'),(13,'g',0,'2012-01-19'),(33,'g',0,'2012-01-19'),(63,'g',0,'2011-11-04'),(38,'g',0,'2011-11-06'),(46,'g',0,'2012-01-19'),(331,'g',0,'2011-11-25'),(67,'g',0,'2011-11-25'),(65,'g',0,'2011-11-25'),(323,'g',0,'2011-11-25'),(389,'g',0,'2011-11-25'),(325,'g',0,'2011-11-25'),(72,'g',0,'2011-11-25'),(74,'g',0,'2011-11-25'),(87,'g',0,'2011-11-25'),(73,'g',0,'2011-11-25'),(71,'g',0,'2011-11-25'),(86,'g',0,'2011-11-25'),(157,'g',0,'2011-11-26'),(458,'g',0,'2011-11-26'),(508,'g',0,'2011-11-26'),(354,'g',0,'2011-11-26'),(247,'g',0,'2011-11-26'),(104,'g',0,'2011-11-26'),(100,'g',0,'2011-11-26'),(173,'g',0,'2011-11-26'),(341,'g',0,'2011-11-26'),(575,'g',0,'2011-11-26'),(188,'g',0,'2011-11-26'),(77,'g',0,'2011-11-26'),(187,'g',0,'2011-11-26'),(69,'g',0,'2011-11-26'),(152,'g',0,'2011-11-26'),(178,'g',0,'2011-11-26'),(186,'g',0,'2011-11-26'),(90,'g',0,'2011-11-26'),(578,'g',0,'2011-11-26'),(455,'g',0,'2011-11-26'),(418,'g',0,'2011-11-26'),(330,'g',0,'2011-11-26'),(165,'g',0,'2011-11-27'),(155,'g',0,'2011-11-27'),(283,'g',0,'2011-11-27'),(196,'g',0,'2011-11-27'),(284,'g',0,'2011-11-27'),(260,'g',0,'2011-11-27'),(268,'g',0,'2011-11-27'),(135,'g',0,'2011-11-27'),(64,'g',0,'2011-11-29'),(68,'g',0,'2011-11-29'),(250,'g',0,'2011-11-29'),(223,'g',0,'2011-11-29'),(154,'g',0,'2011-11-29'),(156,'g',0,'2011-11-29'),(153,'g',0,'2011-11-29'),(142,'g',0,'2011-11-29'),(75,'g',0,'2011-11-29'),(342,'g',0,'2011-11-29'),(168,'g',0,'2011-11-29'),(146,'g',0,'2011-11-29'),(319,'g',0,'2011-11-29'),(167,'g',0,'2011-11-29'),(304,'g',0,'2011-11-29'),(93,'g',0,'2011-11-29'),(99,'g',0,'2011-11-29'),(84,'g',0,'2011-11-29'),(621,'g',0,'2011-11-29'),(452,'g',0,'2011-11-29'),(612,'g',0,'2011-11-29'),(845,'g',0,'2011-11-29'),(293,'g',0,'2011-11-29'),(627,'g',0,'2011-11-29'),(475,'g',0,'2011-11-30'),(374,'g',0,'2011-12-01'),(574,'g',0,'2011-12-01'),(467,'g',0,'2011-12-01'),(797,'g',0,'2011-12-01'),(435,'g',0,'2011-12-01'),(443,'g',0,'2011-12-01'),(264,'g',0,'2011-12-01'),(148,'g',0,'2011-12-02'),(143,'g',0,'2011-12-02'),(407,'g',0,'2011-12-02'),(424,'g',0,'2011-12-02'),(505,'g',0,'2011-12-02'),(158,'g',0,'2011-12-02'),(257,'g',0,'2011-12-02'),(141,'g',0,'2011-12-02'),(151,'g',0,'2011-12-02'),(237,'g',0,'2011-12-02'),(80,'g',0,'2011-12-04'),(185,'g',0,'2011-12-04'),(366,'g',0,'2011-12-04'),(337,'g',0,'2011-12-04'),(280,'g',0,'2011-12-04'),(265,'g',0,'2011-12-04'),(390,'g',0,'2011-12-04'),(305,'g',0,'2011-12-04'),(95,'g',0,'2011-12-05'),(92,'g',0,'2011-12-05'),(91,'g',0,'2011-12-05'),(81,'g',0,'2011-12-05'),(78,'g',0,'2011-12-05'),(96,'g',0,'2011-12-05'),(94,'g',0,'2011-12-05'),(108,'g',0,'2011-12-05'),(109,'g',0,'2011-12-05'),(114,'g',0,'2011-12-05'),(115,'g',0,'2011-12-05'),(88,'g',0,'2011-12-05'),(98,'g',0,'2011-12-05'),(121,'g',0,'2011-12-05'),(350,'g',0,'2011-12-05'),(279,'g',0,'2011-12-05'),(183,'g',0,'2011-12-05'),(355,'g',0,'2011-12-06'),(385,'g',0,'2011-12-06'),(351,'g',0,'2011-12-06'),(500,'g',0,'2011-12-06'),(373,'g',0,'2011-12-06'),(399,'g',0,'2011-12-06'),(515,'g',0,'2011-12-06'),(465,'g',0,'2011-12-06'),(482,'g',0,'2011-12-06'),(1035,'g',0,'2011-12-06'),(633,'g',0,'2011-12-07'),(106,'g',0,'2011-12-07'),(105,'g',0,'2011-12-07'),(634,'g',0,'2011-12-07'),(557,'g',0,'2011-12-07'),(472,'g',0,'2011-12-07'),(481,'g',0,'2011-12-07'),(1025,'g',0,'2011-12-07'),(893,'g',0,'2011-12-07'),(1517,'g',0,'2011-12-07'),(1844,'g',0,'2011-12-07'),(3242,'g',0,'2011-12-07'),(2972,'g',0,'2011-12-07'),(1817,'g',0,'2011-12-07'),(1137,'g',0,'2011-12-07'),(2444,'g',0,'2011-12-07'),(1762,'g',0,'2011-12-07'),(2181,'g',0,'2011-12-07'),(504,'g',0,'2011-12-07'),(243,'g',0,'2011-12-07'),(262,'g',0,'2011-12-07'),(1192,'g',0,'2011-12-07'),(1834,'g',0,'2011-12-07'),(177,'g',0,'2011-12-07'),(256,'g',0,'2011-12-07'),(272,'g',0,'2011-12-07'),(301,'g',0,'2011-12-07'),(174,'g',0,'2011-12-07'),(269,'g',0,'2011-12-07'),(2358,'g',0,'2011-12-07'),(2502,'g',0,'2011-12-07'),(1059,'g',0,'2011-12-07'),(1840,'g',0,'2011-12-07'),(82,'g',0,'2011-12-07'),(1684,'g',0,'2011-12-07'),(1098,'g',0,'2011-12-07'),(543,'g',0,'2011-12-07'),(1723,'g',0,'2011-12-07'),(3191,'g',0,'2011-12-07'),(4026,'g',0,'2011-12-07'),(2398,'g',0,'2011-12-07'),(1264,'g',0,'2011-12-08'),(2717,'g',0,'2011-12-08'),(3547,'g',0,'2011-12-08'),(112,'g',0,'2011-12-08'),(640,'g',0,'2011-12-08'),(1926,'g',0,'2011-12-08'),(4880,'g',0,'2011-12-09'),(906,'g',0,'2011-12-09'),(775,'g',0,'2011-12-09'),(1011,'g',0,'2011-12-09'),(1399,'g',0,'2011-12-09'),(1063,'g',0,'2011-12-09'),(1530,'g',0,'2011-12-09'),(85,'g',0,'2011-12-09'),(119,'g',0,'2011-12-09'),(478,'g',0,'2011-12-09'),(242,'g',0,'2011-12-09'),(118,'g',0,'2011-12-09'),(136,'g',0,'2011-12-09'),(459,'g',0,'2011-12-09'),(144,'g',0,'2011-12-09'),(107,'g',0,'2011-12-09'),(1496,'g',0,'2011-12-09'),(1466,'g',0,'2011-12-09'),(842,'g',0,'2011-12-09'),(317,'g',0,'2011-12-09'),(134,'g',0,'2011-12-09'),(97,'g',0,'2011-12-09'),(353,'g',0,'2011-12-09'),(872,'g',0,'2011-12-09'),(274,'g',0,'2011-12-09'),(320,'g',0,'2011-12-09'),(128,'g',0,'2011-12-09'),(1019,'g',0,'2011-12-09'),(290,'g',0,'2011-12-09'),(1015,'g',0,'2011-12-09'),(376,'g',0,'2011-12-09'),(89,'g',0,'2011-12-09'),(466,'g',0,'2011-12-09'),(339,'g',0,'2011-12-09'),(462,'g',0,'2011-12-09'),(122,'g',0,'2011-12-09'),(161,'g',0,'2011-12-10'),(125,'g',0,'2011-12-10'),(120,'g',0,'2011-12-10'),(573,'g',0,'2011-12-10'),(310,'g',0,'2011-12-10'),(878,'g',0,'2011-12-10'),(312,'g',0,'2011-12-10'),(123,'g',0,'2011-12-10'),(326,'g',0,'2011-12-10'),(234,'g',0,'2011-12-11'),(309,'g',0,'2011-12-11'),(292,'g',0,'2011-12-11'),(311,'g',0,'2011-12-11'),(127,'g',0,'2011-12-11'),(286,'g',0,'2011-12-11'),(308,'g',0,'2011-12-11'),(844,'g',0,'2011-12-11'),(1089,'g',0,'2011-12-11'),(534,'g',0,'2011-12-11'),(313,'g',0,'2011-12-11'),(655,'g',0,'2011-12-11'),(6933,'g',0,'2011-12-13'),(6430,'g',0,'2011-12-13'),(6602,'g',0,'2011-12-13'),(6577,'g',0,'2011-12-13'),(6886,'g',0,'2011-12-13'),(6547,'g',0,'2011-12-13'),(6854,'g',0,'2011-12-13'),(6504,'g',0,'2011-12-13'),(6879,'g',0,'2011-12-13'),(6934,'g',0,'2011-12-13'),(6862,'g',0,'2011-12-13'),(6917,'g',0,'2011-12-13'),(6910,'g',0,'2011-12-13'),(6915,'g',0,'2011-12-13'),(7475,'g',0,'2011-12-13'),(7480,'g',0,'2011-12-13'),(7242,'g',0,'2011-12-13'),(7256,'g',0,'2011-12-13'),(7491,'g',0,'2011-12-13'),(7472,'g',0,'2011-12-13'),(7340,'g',0,'2011-12-13'),(7441,'g',0,'2011-12-13'),(7535,'g',0,'2011-12-13'),(7406,'g',0,'2011-12-13'),(7246,'g',0,'2011-12-14'),(7222,'g',0,'2011-12-14'),(7400,'g',0,'2011-12-14'),(7260,'g',0,'2011-12-14'),(7261,'g',0,'2011-12-14'),(7608,'g',0,'2011-12-14'),(7259,'g',0,'2011-12-14'),(8284,'g',0,'2011-12-14'),(8130,'g',0,'2011-12-14'),(8145,'g',0,'2011-12-14'),(8143,'g',0,'2011-12-14'),(8106,'g',0,'2011-12-14'),(8144,'g',0,'2011-12-14'),(8492,'g',0,'2011-12-14'),(8683,'g',0,'2011-12-15'),(8703,'g',0,'2011-12-15'),(8680,'g',0,'2011-12-15'),(8701,'g',0,'2011-12-15'),(8685,'g',0,'2011-12-15'),(8699,'g',0,'2011-12-15'),(8704,'g',0,'2011-12-15'),(8682,'g',0,'2011-12-15'),(8684,'g',0,'2011-12-15'),(8689,'g',0,'2011-12-15'),(8419,'g',0,'2011-12-15'),(8290,'g',0,'2011-12-15'),(8364,'g',0,'2011-12-15'),(8224,'g',0,'2011-12-15'),(8356,'g',0,'2011-12-15'),(8719,'g',0,'2011-12-15'),(8325,'g',0,'2011-12-15'),(8697,'g',0,'2011-12-15'),(8375,'g',0,'2011-12-15'),(8359,'g',0,'2011-12-15'),(8060,'g',0,'2011-12-15'),(8062,'g',0,'2011-12-15'),(8474,'g',0,'2011-12-15'),(8110,'g',0,'2011-12-15'),(8064,'g',0,'2011-12-15'),(8118,'g',0,'2011-12-15'),(8112,'g',0,'2011-12-15'),(8186,'g',0,'2011-12-15'),(8634,'g',0,'2011-12-15'),(7807,'g',0,'2011-12-15'),(8702,'g',0,'2011-12-15'),(8427,'g',0,'2011-12-15'),(8117,'g',0,'2011-12-15'),(8220,'g',0,'2011-12-15'),(8258,'g',0,'2011-12-15'),(8628,'g',0,'2011-12-15'),(8070,'g',0,'2011-12-15'),(8418,'g',0,'2011-12-15'),(8238,'g',0,'2011-12-15'),(8516,'g',0,'2011-12-15'),(8429,'g',0,'2011-12-15'),(8413,'g',0,'2011-12-15'),(8246,'g',0,'2011-12-15'),(8668,'g',0,'2011-12-15'),(8275,'g',0,'2011-12-15'),(8169,'g',0,'2011-12-15'),(6904,'g',0,'2011-12-15'),(6518,'g',0,'2011-12-15'),(6489,'g',0,'2011-12-15'),(6481,'g',0,'2011-12-15'),(6412,'g',0,'2011-12-15'),(11478,'g',0,'2011-12-15'),(11373,'g',0,'2011-12-15'),(11379,'g',0,'2011-12-15'),(11393,'g',0,'2011-12-15'),(11537,'g',0,'2011-12-15'),(11428,'g',0,'2011-12-15'),(11417,'g',0,'2011-12-15'),(11536,'g',0,'2011-12-15'),(11447,'g',0,'2011-12-15'),(6671,'g',0,'2011-12-15'),(11459,'g',0,'2011-12-15'),(6655,'g',0,'2011-12-15'),(6758,'g',0,'2011-12-15'),(7822,'g',0,'2011-12-15'),(7782,'g',0,'2011-12-15'),(7712,'g',0,'2011-12-15'),(7752,'g',0,'2011-12-15'),(7726,'g',0,'2011-12-15'),(7668,'g',0,'2011-12-15'),(7719,'g',0,'2011-12-15'),(11733,'g',0,'2012-02-03'),(11726,'g',0,'2011-12-15'),(11721,'g',0,'2011-12-15'),(11724,'g',0,'2011-12-15'),(11731,'g',0,'2012-02-03'),(11723,'g',0,'2011-12-15'),(11720,'g',0,'2011-12-15'),(11729,'g',0,'2011-12-15'),(11165,'g',0,'2011-12-16'),(10993,'g',0,'2011-12-16'),(11420,'g',0,'2011-12-16'),(11022,'g',0,'2011-12-16'),(11268,'g',0,'2011-12-16'),(11181,'g',0,'2011-12-16'),(11700,'g',0,'2011-12-16'),(10985,'g',0,'2011-12-16'),(11712,'g',0,'2012-01-24'),(11750,'g',0,'2012-01-24'),(11677,'g',0,'2012-01-24'),(11672,'g',0,'2012-01-24'),(11706,'g',0,'2012-01-24'),(11689,'g',0,'2012-01-24'),(11629,'g',0,'2012-01-24'),(11649,'g',0,'2012-01-24'),(11741,'g',0,'2012-01-24'),(11246,'g',0,'2011-12-16'),(11074,'g',0,'2011-12-16'),(10756,'g',0,'2011-12-16'),(10152,'g',0,'2011-12-16'),(11272,'g',0,'2011-12-16'),(11009,'g',0,'2011-12-16'),(10324,'g',0,'2011-12-16'),(10896,'g',0,'2011-12-16'),(11678,'g',0,'2011-12-16'),(10350,'g',0,'2011-12-16'),(11745,'g',0,'2012-01-19'),(11744,'g',0,'2012-01-19'),(11752,'g',0,'2012-01-19'),(10817,'g',0,'2011-12-17'),(11005,'g',0,'2011-12-17'),(10967,'g',0,'2011-12-17'),(10864,'g',0,'2011-12-17'),(11179,'g',0,'2011-12-17'),(11380,'g',0,'2011-12-17'),(11454,'g',0,'2011-12-17'),(11739,'g',0,'2012-02-03'),(11386,'g',0,'2011-12-17'),(11170,'g',0,'2011-12-17'),(11599,'g',0,'2012-01-19'),(11244,'g',0,'2011-12-17'),(11760,'g',0,'2012-01-19'),(11577,'g',0,'2012-01-19'),(11031,'g',0,'2011-12-17'),(11598,'g',0,'2012-01-19'),(10892,'g',0,'2011-12-17'),(11070,'g',0,'2011-12-17'),(10333,'g',0,'2011-12-17'),(10307,'g',0,'2011-12-17'),(11248,'g',0,'2011-12-17'),(11229,'g',0,'2011-12-17'),(10337,'g',0,'2011-12-17'),(10148,'g',0,'2011-12-17'),(10326,'g',0,'2011-12-17'),(11255,'g',0,'2011-12-17'),(11259,'g',0,'2011-12-17'),(11759,'g',0,'2011-12-18'),(6736,'g',0,'2011-12-18'),(7610,'g',0,'2011-12-18'),(7636,'g',0,'2011-12-18'),(7438,'g',0,'2011-12-18'),(6505,'g',0,'2011-12-18'),(7265,'g',0,'2011-12-18'),(6565,'g',0,'2011-12-18'),(7378,'g',0,'2011-12-18'),(6762,'g',0,'2011-12-18'),(7125,'g',0,'2011-12-18'),(11692,'g',0,'2012-02-01'),(11716,'g',0,'2012-02-01'),(11513,'g',0,'2012-02-01'),(11674,'g',0,'2012-02-01'),(11473,'g',0,'2011-12-18'),(11711,'g',0,'2012-02-01'),(11698,'g',0,'2012-02-01'),(11608,'g',0,'2012-02-01'),(11605,'g',0,'2012-02-01'),(11757,'g',0,'2012-02-01'),(11737,'g',0,'2012-02-23'),(11728,'g',0,'2012-02-23'),(11754,'g',0,'2012-02-23'),(11736,'g',0,'2012-02-23'),(11632,'g',0,'2012-02-23'),(11686,'g',0,'2012-02-23'),(11755,'g',0,'2012-02-23'),(11702,'g',0,'2011-12-18'),(11688,'g',0,'2011-12-18'),(11659,'g',0,'2012-02-23'),(11740,'g',0,'2012-02-06'),(11753,'g',0,'2012-02-06'),(11690,'g',0,'2012-02-06'),(11732,'g',0,'2012-02-06'),(11738,'g',0,'2012-02-03'),(11719,'g',0,'2012-02-03'),(11709,'g',0,'2012-02-03'),(11696,'g',0,'2012-02-06'),(11685,'g',0,'2012-02-06'),(11735,'g',0,'2011-12-18'),(11701,'g',0,'2011-12-18'),(11616,'g',0,'2012-02-03'),(11511,'g',0,'2011-12-18'),(12054,'g',0,'2011-12-18'),(11965,'g',0,'2011-12-18'),(11988,'g',0,'2011-12-18'),(11949,'g',0,'2011-12-18'),(12109,'g',0,'2011-12-18'),(12004,'g',0,'2011-12-18'),(11966,'g',0,'2011-12-18'),(11790,'g',0,'2011-12-18'),(11865,'g',0,'2011-12-18'),(11851,'g',0,'2011-12-18'),(11819,'g',0,'2011-12-18'),(11837,'g',0,'2011-12-18'),(12007,'g',0,'2011-12-18'),(11942,'g',0,'2011-12-18'),(11987,'g',0,'2011-12-18'),(11815,'g',0,'2011-12-18'),(11707,'g',0,'2011-12-18'),(11756,'g',0,'2011-12-18'),(11722,'g',0,'2011-12-18'),(11747,'g',0,'2011-12-18'),(11708,'g',0,'2011-12-18'),(11705,'g',0,'2011-12-18'),(11811,'g',0,'2011-12-18'),(11519,'g',0,'2012-02-06'),(11546,'g',0,'2012-02-06'),(11614,'g',0,'2012-02-06'),(11529,'g',0,'2012-02-06'),(11552,'g',0,'2012-02-06'),(11734,'g',0,'2012-02-06'),(11786,'g',0,'2011-12-19'),(11889,'g',0,'2012-02-03'),(12092,'g',0,'2011-12-19'),(12101,'g',0,'2011-12-19'),(12303,'g',0,'2011-12-19'),(12309,'g',0,'2011-12-19'),(12377,'g',0,'2011-12-19'),(11927,'g',0,'2011-12-19'),(11687,'g',0,'2012-02-03'),(11730,'g',0,'2012-02-03'),(11691,'g',0,'2012-02-03'),(11682,'g',0,'2012-02-03'),(12103,'g',0,'2011-12-20'),(11838,'g',0,'2011-12-20'),(12087,'g',0,'2011-12-20'),(12190,'g',0,'2011-12-20'),(11907,'g',0,'2011-12-20'),(11915,'g',0,'2011-12-20'),(11944,'g',0,'2011-12-20'),(11693,'g',0,'2011-12-20'),(12438,'g',0,'2011-12-20'),(11589,'g',0,'2011-12-20'),(11574,'g',0,'2011-12-20'),(11582,'g',0,'2011-12-20'),(11668,'g',0,'2011-12-20'),(12439,'g',0,'2011-12-20'),(12441,'g',0,'2011-12-20'),(11572,'g',0,'2011-12-20'),(11579,'g',0,'2011-12-20'),(11654,'g',0,'2011-12-20'),(11573,'g',0,'2011-12-20'),(11495,'g',0,'2011-12-20'),(11587,'g',0,'2011-12-20'),(11585,'g',0,'2011-12-20'),(11499,'g',0,'2011-12-20'),(11584,'g',0,'2011-12-20'),(11683,'g',0,'2011-12-20'),(11766,'g',0,'2011-12-20'),(11764,'g',0,'2011-12-20'),(11767,'g',0,'2011-12-20'),(11768,'g',0,'2011-12-20'),(11765,'g',0,'2011-12-20'),(11554,'g',0,'2011-12-20'),(11742,'g',0,'2011-12-20'),(11665,'g',0,'2011-12-20'),(11769,'g',0,'2011-12-20'),(12035,'g',0,'2011-12-20'),(12461,'g',0,'2012-02-01'),(12444,'g',0,'2011-12-20'),(11818,'g',0,'2011-12-20'),(12168,'g',0,'2011-12-20'),(11931,'g',0,'2011-12-20'),(12194,'g',0,'2011-12-20'),(12421,'g',0,'2011-12-20'),(11996,'g',0,'2011-12-20'),(12171,'g',0,'2012-02-27'),(11558,'g',0,'2012-03-04'),(11782,'g',0,'2012-02-03'),(12179,'g',0,'2012-02-27'),(11748,'g',0,'2012-02-27'),(12086,'g',0,'2011-12-21'),(12026,'g',0,'2012-02-27'),(12430,'g',0,'2012-02-07'),(11856,'g',0,'2011-12-21'),(11830,'g',0,'2011-12-21'),(11794,'g',0,'2011-12-21'),(11761,'g',0,'2011-12-21'),(12178,'g',0,'2011-12-21'),(11524,'g',0,'2012-02-07'),(11515,'g',0,'2012-02-07'),(11749,'g',0,'2012-02-07'),(11924,'g',0,'2011-12-21'),(11530,'g',0,'2012-02-07'),(11567,'g',0,'2012-01-27'),(11575,'g',0,'2012-01-27'),(12455,'g',0,'2012-01-27'),(11538,'g',0,'2012-01-27'),(11516,'g',0,'2012-01-27'),(12451,'g',0,'2012-01-27'),(11550,'g',0,'2012-01-27'),(11673,'g',0,'2012-01-27'),(11681,'g',0,'2012-01-27'),(11549,'g',0,'2012-01-27'),(12081,'g',0,'2011-12-21'),(12284,'g',0,'2011-12-21'),(12373,'g',0,'2011-12-21'),(12102,'g',0,'2011-12-21'),(12365,'g',0,'2011-12-21'),(12386,'g',0,'2011-12-21'),(12380,'g',0,'2011-12-21'),(12053,'g',0,'2011-12-21'),(12293,'g',0,'2012-02-07'),(12371,'g',0,'2011-12-21'),(12406,'g',0,'2011-12-21'),(12270,'g',0,'2011-12-21'),(12279,'g',0,'2011-12-21'),(12328,'g',0,'2011-12-21'),(12046,'g',0,'2012-02-28'),(12049,'g',0,'2011-12-21'),(11964,'g',0,'2011-12-21'),(12033,'g',0,'2011-12-21'),(12343,'g',0,'2011-12-21'),(12372,'g',0,'2011-12-21'),(11999,'g',0,'2011-12-21'),(12396,'g',0,'2011-12-21'),(11893,'g',0,'2011-12-21'),(12093,'g',0,'2011-12-21'),(11809,'g',0,'2011-12-21'),(12038,'g',0,'2011-12-21'),(11795,'g',0,'2011-12-21'),(12030,'g',0,'2011-12-21'),(11864,'g',0,'2012-02-20'),(12060,'g',0,'2011-12-22'),(11871,'g',0,'2011-12-22'),(12420,'g',0,'2011-12-22'),(12126,'g',0,'2011-12-22'),(12130,'g',0,'2011-12-22'),(11874,'g',0,'2011-12-22'),(12136,'g',0,'2011-12-22'),(12139,'g',0,'2011-12-22'),(11841,'g',0,'2011-12-22'),(11870,'g',0,'2011-12-22'),(12141,'g',0,'2011-12-22'),(12124,'g',0,'2011-12-22'),(11631,'g',0,'2011-12-22'),(11881,'g',0,'2011-12-22'),(11867,'g',0,'2011-12-22'),(11603,'g',0,'2011-12-22'),(11955,'g',0,'2011-12-22'),(12316,'g',0,'2011-12-22'),(11906,'g',0,'2011-12-22'),(11997,'g',0,'2011-12-22'),(12340,'g',0,'2011-12-22'),(12351,'g',0,'2011-12-22'),(12302,'g',0,'2011-12-22'),(12401,'g',0,'2011-12-22'),(11992,'g',0,'2011-12-22'),(11799,'g',0,'2011-12-22'),(12170,'g',0,'2012-02-03'),(12296,'g',0,'2011-12-22'),(12177,'g',0,'2012-02-03'),(11775,'g',0,'2011-12-22'),(12423,'g',0,'2011-12-22'),(12151,'g',0,'2011-12-22'),(12181,'g',0,'2011-12-22'),(11812,'g',0,'2011-12-22'),(12193,'g',0,'2011-12-22'),(12382,'g',0,'2011-12-22'),(12132,'g',0,'2011-12-22'),(12142,'g',0,'2011-12-22'),(12138,'g',0,'2011-12-23'),(12131,'g',0,'2011-12-23'),(12122,'g',0,'2011-12-23'),(11564,'g',0,'2011-12-23'),(11597,'g',0,'2011-12-23'),(12134,'g',0,'2011-12-23'),(11808,'g',0,'2011-12-23'),(11803,'g',0,'2011-12-23'),(11600,'g',0,'2011-12-23'),(12129,'g',0,'2011-12-23'),(12469,'g',0,'2012-03-04'),(11601,'g',0,'2011-12-23'),(12436,'g',0,'2011-12-23'),(12472,'g',0,'2011-12-23'),(11512,'g',0,'2011-12-23'),(11526,'g',0,'2011-12-23'),(11540,'g',0,'2011-12-23'),(11525,'g',0,'2011-12-23'),(11539,'g',0,'2011-12-23'),(11522,'g',0,'2011-12-23'),(12125,'g',0,'2011-12-23'),(11869,'g',0,'2011-12-23'),(11527,'g',0,'2011-12-23'),(11945,'g',0,'2011-12-23'),(12137,'g',0,'2011-12-23'),(12370,'g',0,'2011-12-23'),(11986,'g',0,'2011-12-23'),(11850,'g',0,'2011-12-23'),(12008,'g',0,'2011-12-23'),(11887,'g',0,'2011-12-23'),(11934,'g',0,'2011-12-23'),(11885,'g',0,'2011-12-23'),(11932,'g',0,'2011-12-23'),(11746,'g',0,'2011-12-23'),(11810,'g',0,'2011-12-23'),(11935,'g',0,'2011-12-23'),(11933,'g',0,'2011-12-23'),(11886,'g',0,'2011-12-23'),(11776,'g',0,'2011-12-23'),(11523,'g',0,'2011-12-23'),(11509,'g',0,'2011-12-23'),(12133,'g',0,'2011-12-23'),(11883,'g',0,'2011-12-23'),(11615,'g',0,'2011-12-23'),(11981,'g',0,'2011-12-23'),(12140,'g',0,'2011-12-23'),(12128,'g',0,'2011-12-23'),(12123,'g',0,'2011-12-23'),(12127,'g',0,'2011-12-23'),(12118,'g',0,'2011-12-23'),(12120,'g',0,'2011-12-23'),(12110,'g',0,'2011-12-23'),(12115,'g',0,'2011-12-23'),(12119,'g',0,'2011-12-23'),(12095,'g',0,'2011-12-23'),(12107,'g',0,'2011-12-23'),(12105,'g',0,'2011-12-23'),(12112,'g',0,'2011-12-23'),(12121,'g',0,'2011-12-23'),(11891,'g',0,'2011-12-23'),(11545,'g',0,'2011-12-23'),(11894,'g',0,'2011-12-23'),(11594,'g',0,'2011-12-23'),(11798,'g',0,'2011-12-24'),(12088,'g',0,'2012-02-03'),(12475,'g',0,'2011-12-24'),(12029,'g',0,'2011-12-25'),(12024,'g',0,'2011-12-25'),(12041,'g',0,'2011-12-25'),(12022,'g',0,'2011-12-25'),(12057,'g',0,'2011-12-25'),(12074,'g',0,'2011-12-25'),(12010,'g',0,'2011-12-25'),(12467,'g',0,'2011-12-25'),(12039,'g',0,'2011-12-25'),(12070,'g',0,'2011-12-25'),(12433,'g',0,'2011-12-26'),(11788,'g',0,'2011-12-26'),(12437,'g',0,'2011-12-26'),(11878,'g',0,'2012-02-21'),(12458,'g',0,'2011-12-26'),(12459,'g',0,'2011-12-26'),(11855,'g',0,'2011-12-26'),(12454,'g',0,'2012-02-06'),(12440,'g',0,'2011-12-26'),(11802,'g',0,'2011-12-26'),(12463,'g',0,'2011-12-26'),(11840,'g',0,'2011-12-26'),(12148,'g',0,'2011-12-26'),(12432,'g',0,'2011-12-27'),(11528,'g',0,'2011-12-27'),(11796,'g',0,'2011-12-27'),(11559,'g',0,'2012-02-03'),(11553,'g',0,'2012-02-03'),(12447,'g',0,'2011-12-27'),(11817,'g',0,'2011-12-27'),(11520,'g',0,'2011-12-27'),(11725,'g',0,'2011-12-27'),(11565,'g',0,'2012-02-03'),(11773,'g',0,'2011-12-27'),(11800,'g',0,'2011-12-27'),(12452,'g',0,'2011-12-27'),(12508,'g',0,'2012-02-07'),(11715,'g',0,'2011-12-28'),(11787,'g',0,'2011-12-28'),(11710,'g',0,'2011-12-28'),(11718,'g',0,'2011-12-28'),(11717,'g',0,'2011-12-28'),(11496,'g',0,'2011-12-29'),(11781,'g',0,'2011-12-29'),(11498,'g',0,'2011-12-29'),(11880,'g',0,'2012-02-21'),(11713,'g',0,'2011-12-29'),(11779,'g',0,'2011-12-29'),(11879,'g',0,'2012-02-20'),(12526,'g',0,'2012-02-07'),(12143,'g',0,'2011-12-29'),(12144,'g',0,'2011-12-29'),(12238,'g',0,'2011-12-29'),(12228,'g',0,'2011-12-30'),(12214,'g',0,'2011-12-30'),(12216,'g',0,'2011-12-30'),(12236,'g',0,'2011-12-30'),(11921,'g',0,'2012-02-20'),(12233,'g',0,'2011-12-30'),(11923,'g',0,'2012-02-20'),(11876,'g',0,'2012-02-20'),(12234,'g',0,'2011-12-30'),(12239,'g',0,'2011-12-30'),(12217,'g',0,'2011-12-30'),(12237,'g',0,'2011-12-30'),(12275,'g',0,'2011-12-30'),(12266,'g',0,'2011-12-30'),(12264,'g',0,'2011-12-30'),(12253,'g',0,'2011-12-30'),(12265,'g',0,'2011-12-30'),(12259,'g',0,'2011-12-30'),(12255,'g',0,'2011-12-30'),(12254,'g',0,'2011-12-30'),(12256,'g',0,'2011-12-30'),(12287,'g',0,'2011-12-30'),(12251,'g',0,'2011-12-30'),(12257,'g',0,'2011-12-30'),(12263,'g',0,'2011-12-30'),(12268,'g',0,'2011-12-30'),(12250,'g',0,'2011-12-30'),(12258,'g',0,'2011-12-30'),(12252,'g',0,'2011-12-30'),(12262,'g',0,'2011-12-30'),(12260,'g',0,'2011-12-30'),(12267,'g',0,'2011-12-30'),(12531,'g',0,'2011-12-30'),(12528,'g',0,'2011-12-30'),(12530,'g',0,'2011-12-30'),(12491,'g',0,'2012-02-03'),(12504,'g',0,'2011-12-30'),(12511,'g',0,'2011-12-30'),(12310,'g',0,'2011-12-31'),(12247,'g',0,'2011-12-31'),(12244,'g',0,'2011-12-31'),(12246,'g',0,'2011-12-31'),(12308,'g',0,'2011-12-31'),(12320,'g',0,'2011-12-31'),(12312,'g',0,'2011-12-31'),(12245,'g',0,'2011-12-31'),(12203,'g',0,'2011-12-31'),(12243,'g',0,'2012-01-01'),(12210,'g',0,'2012-01-01'),(12315,'g',0,'2012-01-01'),(12291,'g',0,'2012-01-01'),(12295,'g',0,'2012-01-01'),(12324,'g',0,'2012-01-01'),(12323,'g',0,'2012-01-01'),(12213,'g',0,'2012-01-01'),(12305,'g',0,'2012-01-01'),(12298,'g',0,'2012-01-01'),(12313,'g',0,'2012-01-01'),(12242,'g',0,'2012-01-01'),(12145,'g',0,'2012-01-01'),(12248,'g',0,'2012-01-01'),(12241,'g',0,'2012-01-01'),(12307,'g',0,'2012-01-01'),(11877,'g',0,'2012-02-20'),(12163,'g',0,'2012-01-01'),(12201,'g',0,'2012-01-02'),(12306,'g',0,'2012-01-02'),(12206,'g',0,'2012-01-02'),(12289,'g',0,'2012-01-02'),(12514,'g',0,'2012-01-02'),(12187,'g',0,'2012-01-02'),(12249,'g',0,'2012-01-02'),(12317,'g',0,'2012-01-02'),(12299,'g',0,'2012-01-02'),(12483,'g',0,'2012-01-02'),(12519,'g',0,'2012-01-03'),(12322,'g',0,'2012-01-03'),(12547,'g',0,'2012-02-07'),(12304,'g',0,'2012-01-03'),(12539,'g',0,'2012-01-03'),(12558,'g',0,'2012-01-03'),(12389,'g',0,'2012-02-20'),(12466,'g',0,'2012-02-25'),(12403,'g',0,'2012-02-20'),(11780,'g',0,'2012-02-21'),(12091,'g',0,'2012-01-03'),(12208,'g',0,'2012-01-03'),(12240,'g',0,'2012-01-03'),(12199,'g',0,'2012-01-03'),(12314,'g',0,'2012-01-03'),(12556,'g',0,'2012-01-04'),(11882,'g',0,'2012-02-21'),(12546,'g',0,'2012-02-07'),(12398,'g',0,'2012-02-07'),(12557,'g',0,'2012-01-07'),(12582,'g',0,'2012-01-07'),(12576,'g',0,'2012-01-07'),(12587,'g',0,'2012-01-08'),(12565,'g',0,'2012-01-08'),(12066,'g',0,'2012-01-09'),(11770,'g',0,'2012-01-10'),(12018,'g',0,'2012-02-19'),(12017,'g',0,'2012-02-19'),(12625,'g',0,'2012-01-15'),(12624,'g',0,'2012-01-15'),(12623,'g',0,'2012-01-15'),(12577,'g',0,'2012-01-15'),(12545,'g',0,'2012-01-15'),(12608,'g',0,'2012-01-15'),(12610,'g',0,'2012-01-15'),(12578,'g',0,'2012-01-15'),(12085,'g',0,'2012-02-20'),(12707,'g',0,'2012-01-17'),(12702,'g',0,'2012-01-17'),(12061,'g',0,'2012-01-17'),(11771,'g',0,'2012-01-18'),(12583,'g',0,'2012-01-19'),(12628,'g',0,'2012-01-19'),(12621,'g',0,'2012-01-19'),(12640,'g',0,'2012-01-20'),(12652,'g',0,'2012-01-20'),(12554,'g',0,'2012-01-21'),(12743,'g',0,'2012-01-23'),(12774,'g',0,'2012-01-25'),(12762,'g',0,'2012-02-28'),(12756,'g',0,'2012-01-27'),(12761,'g',0,'2012-01-28'),(12766,'g',0,'2012-01-28'),(12789,'g',0,'2012-01-28'),(12760,'g',0,'2012-01-28'),(12647,'g',0,'2012-01-28'),(12542,'g',0,'2012-01-28'),(12785,'g',0,'2012-01-28'),(12655,'g',0,'2012-01-29'),(12642,'g',0,'2012-01-29'),(12744,'g',0,'2012-01-29'),(12705,'g',0,'2012-01-29'),(12763,'g',0,'2012-01-29'),(12794,'g',0,'2012-01-29'),(12485,'g',0,'2012-01-29'),(12653,'g',0,'2012-01-29'),(12586,'g',0,'2012-01-29'),(12633,'g',0,'2012-01-29'),(12506,'g',0,'2012-01-29'),(12589,'g',0,'2012-01-29'),(12516,'g',0,'2012-01-29'),(12507,'g',0,'2012-01-29'),(12701,'g',0,'2012-01-29'),(12776,'g',0,'2012-01-29'),(12484,'g',0,'2012-01-29'),(12510,'g',0,'2012-01-29'),(12593,'g',0,'2012-01-29'),(12548,'g',0,'2012-01-29'),(12771,'g',0,'2012-01-29'),(12718,'g',0,'2012-01-29'),(12534,'g',0,'2012-01-30'),(12645,'g',0,'2012-01-30'),(12739,'g',0,'2012-01-30'),(12585,'g',0,'2012-01-30'),(12512,'g',0,'2012-01-30'),(12708,'g',0,'2012-01-30'),(12494,'g',0,'2012-01-30'),(12715,'g',0,'2012-01-30'),(12573,'g',0,'2012-01-30'),(12803,'g',0,'2012-02-01'),(12764,'g',0,'2012-02-01'),(12765,'g',0,'2012-02-01'),(12837,'g',0,'2012-02-04'),(12816,'g',0,'2012-02-06'),(12832,'g',0,'2012-02-07'),(12911,'g',0,'2012-02-10'),(12914,'g',0,'2012-02-13'),(12928,'g',0,'2012-02-13'),(12932,'g',0,'2012-02-15'),(12946,'g',0,'2012-02-15'),(12890,'g',0,'2012-02-15'),(12943,'g',0,'2012-02-15'),(12931,'g',0,'2012-02-17'),(12787,'g',0,'2012-02-18'),(12535,'g',0,'2012-02-18'),(12493,'g',0,'2012-02-18'),(12540,'g',0,'2012-02-18'),(12657,'g',0,'2012-02-18'),(11534,'g',0,'2012-02-18'),(11807,'g',0,'2012-02-18'),(12559,'g',0,'2012-02-18'),(12509,'g',0,'2012-02-18'),(12551,'g',0,'2012-02-18'),(12639,'g',0,'2012-02-18'),(12745,'g',0,'2012-02-18'),(12830,'g',0,'2012-02-18'),(12714,'g',0,'2012-02-18'),(12720,'g',0,'2012-02-18'),(12747,'g',0,'2012-02-18'),(12746,'g',0,'2012-02-18'),(12754,'g',0,'2012-02-18'),(12750,'g',0,'2012-02-18'),(12788,'g',0,'2012-02-18'),(12712,'g',0,'2012-02-18'),(12799,'g',0,'2012-02-18'),(12811,'g',0,'2012-02-18'),(12818,'g',0,'2012-02-18'),(11789,'g',0,'2012-02-18'),(12806,'g',0,'2012-02-18'),(12831,'g',0,'2012-02-18'),(12801,'g',0,'2012-02-18'),(11504,'g',0,'2012-02-18'),(12618,'g',0,'2012-02-18'),(11806,'g',0,'2012-02-18'),(12948,'g',0,'2012-02-18'),(11533,'g',0,'2012-02-18'),(11532,'g',0,'2012-02-18'),(11561,'g',0,'2012-02-18'),(12706,'g',0,'2012-02-18'),(12650,'g',0,'2012-02-18'),(12838,'g',0,'2012-02-18'),(11517,'g',0,'2012-02-18'),(12609,'g',0,'2012-02-18'),(11505,'g',0,'2012-02-18'),(11503,'g',0,'2012-02-18'),(11542,'g',0,'2012-02-18'),(12594,'g',0,'2012-02-18'),(12700,'g',0,'2012-02-18'),(12596,'g',0,'2012-02-18'),(12513,'g',0,'2012-02-18'),(12638,'g',0,'2012-02-18'),(12518,'g',0,'2012-02-18'),(12579,'g',0,'2012-02-18'),(12656,'g',0,'2012-02-18'),(11852,'g',0,'2012-02-19'),(11774,'g',0,'2012-02-19'),(11791,'g',0,'2012-02-19'),(11827,'g',0,'2012-02-19'),(11918,'g',0,'2012-02-19'),(12819,'g',0,'2012-02-19'),(11917,'g',0,'2012-02-19'),(11872,'g',0,'2012-02-19'),(12777,'g',0,'2012-02-19'),(11853,'g',0,'2012-02-19'),(11592,'g',0,'2012-02-19'),(12165,'g',0,'2012-02-19'),(12156,'g',0,'2012-02-19'),(12167,'g',0,'2012-02-19'),(12164,'g',0,'2012-02-19'),(12422,'g',0,'2012-02-19'),(12951,'g',0,'2012-02-19'),(11902,'g',0,'2012-02-19'),(12344,'g',0,'2012-02-19'),(12537,'g',0,'2012-02-19'),(12568,'g',0,'2012-02-19'),(12532,'g',0,'2012-02-19'),(12552,'g',0,'2012-02-19'),(12550,'g',0,'2012-02-19'),(12563,'g',0,'2012-02-19'),(12549,'g',0,'2012-02-19'),(12571,'g',0,'2012-02-19'),(12560,'g',0,'2012-02-19'),(12755,'g',0,'2012-02-19'),(12713,'g',0,'2012-02-19'),(12716,'g',0,'2012-02-19'),(12719,'g',0,'2012-02-19'),(12666,'g',0,'2012-02-19'),(12664,'g',0,'2012-02-19'),(12662,'g',0,'2012-02-19'),(12665,'g',0,'2012-02-19'),(12725,'g',0,'2012-02-19'),(12703,'g',0,'2012-02-19'),(12663,'g',0,'2012-02-19'),(12780,'g',0,'2012-02-19'),(11814,'g',0,'2012-02-19'),(11926,'g',0,'2012-02-19'),(12538,'g',0,'2012-02-19'),(11974,'g',0,'2012-02-19'),(12741,'g',0,'2012-02-19'),(11957,'g',0,'2012-02-19'),(12153,'g',0,'2012-02-19'),(12155,'g',0,'2012-02-19'),(11650,'g',0,'2012-02-19'),(11873,'g',0,'2012-02-19'),(11908,'g',0,'2012-02-19'),(11551,'g',0,'2012-02-19'),(11510,'g',0,'2012-02-19'),(11543,'g',0,'2012-02-19'),(11514,'g',0,'2012-02-19'),(11541,'g',0,'2012-02-19'),(11548,'g',0,'2012-02-19'),(11506,'g',0,'2012-02-19'),(11507,'g',0,'2012-02-19'),(11547,'g',0,'2012-02-19'),(12930,'g',0,'2012-02-19'),(12952,'g',0,'2012-02-19'),(12784,'g',0,'2012-02-19'),(12758,'g',0,'2012-02-19'),(12836,'g',0,'2012-02-19'),(12770,'g',0,'2012-02-19'),(12852,'g',0,'2012-02-19'),(12891,'g',0,'2012-02-19'),(12889,'g',0,'2012-02-19'),(12849,'g',0,'2012-02-19'),(12825,'g',0,'2012-02-19'),(12769,'g',0,'2012-02-19'),(12814,'g',0,'2012-02-19'),(12660,'g',0,'2012-02-20'),(11801,'g',0,'2012-02-20'),(11820,'g',0,'2012-02-20'),(12730,'g',0,'2012-02-20'),(11826,'g',0,'2012-02-20'),(11831,'g',0,'2012-02-20'),(12912,'g',0,'2012-02-20'),(11784,'g',0,'2012-02-20'),(11805,'g',0,'2012-02-20'),(11836,'g',0,'2012-02-20'),(11772,'g',0,'2012-02-20'),(11824,'g',0,'2012-02-20'),(12802,'g',0,'2012-02-20'),(12913,'g',0,'2012-02-20'),(11943,'g',0,'2012-02-20'),(12347,'g',0,'2012-02-20'),(11895,'g',0,'2012-02-20'),(12362,'g',0,'2012-02-20'),(12277,'g',0,'2012-02-20'),(12735,'g',0,'2012-02-20'),(12731,'g',0,'2012-02-20'),(12768,'g',0,'2012-02-20'),(12937,'g',0,'2012-02-20'),(12757,'g',0,'2012-02-20'),(12893,'g',0,'2012-02-20'),(12800,'g',0,'2012-02-20'),(12941,'g',0,'2012-02-20'),(12828,'g',0,'2012-02-20'),(11946,'g',0,'2012-02-20'),(12636,'g',0,'2012-02-20'),(12722,'g',0,'2012-02-20'),(11862,'g',0,'2012-02-20'),(12502,'g',0,'2012-02-20'),(11849,'g',0,'2012-02-20'),(12823,'g',0,'2012-02-20'),(11783,'g',0,'2012-02-20'),(12031,'g',0,'2012-02-20'),(12945,'g',0,'2012-02-20'),(12525,'g',0,'2012-02-20'),(12742,'g',0,'2012-02-20'),(12020,'g',0,'2012-02-20'),(12524,'g',0,'2012-02-20'),(11861,'g',0,'2012-02-20'),(12567,'g',0,'2012-02-20'),(12601,'g',0,'2012-02-20'),(11956,'g',0,'2012-02-20'),(12390,'g',0,'2012-02-20'),(12189,'g',0,'2012-02-20'),(12465,'g',0,'2012-02-20'),(12104,'g',0,'2012-02-20'),(12154,'g',0,'2012-02-20'),(11521,'g',0,'2012-02-20'),(11610,'g',0,'2012-02-20'),(11909,'g',0,'2012-02-20'),(12363,'g',0,'2012-02-20'),(11502,'g',0,'2012-02-20'),(12184,'g',0,'2012-02-20'),(11843,'g',0,'2012-02-20'),(12778,'g',0,'2012-02-20'),(12734,'g',0,'2012-02-20'),(12810,'g',0,'2012-02-20'),(12505,'g',0,'2012-02-20'),(12515,'g',0,'2012-02-20'),(12082,'g',0,'2012-02-20'),(12781,'g',0,'2012-02-20'),(12388,'g',0,'2012-02-20'),(12404,'g',0,'2012-02-20'),(11844,'g',0,'2012-02-20'),(12895,'g',0,'2012-02-20'),(11825,'g',0,'2012-02-20'),(12813,'g',0,'2012-02-20'),(12927,'g',0,'2012-02-20'),(12919,'g',0,'2012-02-20'),(12779,'g',0,'2012-02-20'),(12940,'g',0,'2012-02-20'),(11793,'g',0,'2012-02-20'),(12021,'g',0,'2012-02-20'),(11892,'g',0,'2012-02-20'),(11896,'g',0,'2012-02-20'),(12569,'g',0,'2012-02-20'),(12321,'g',0,'2012-02-20'),(12658,'g',0,'2012-02-20'),(12575,'g',0,'2012-02-20'),(12273,'g',0,'2012-02-20'),(12667,'g',0,'2012-02-20'),(12607,'g',0,'2012-02-20'),(11792,'g',0,'2012-02-20'),(11959,'g',0,'2012-02-20'),(11823,'g',0,'2012-02-20'),(11839,'g',0,'2012-02-20'),(12448,'g',0,'2012-02-20'),(11508,'g',0,'2012-02-20'),(11606,'g',0,'2012-02-20'),(11953,'g',0,'2012-02-20'),(12434,'g',0,'2012-02-20'),(11961,'g',0,'2012-02-20'),(12456,'g',0,'2012-02-20'),(12224,'g',0,'2012-02-20'),(12220,'g',0,'2012-02-20'),(12078,'g',0,'2012-02-20'),(11936,'g',0,'2012-02-20'),(12944,'g',0,'2012-02-20'),(12924,'g',0,'2012-02-20'),(12751,'g',0,'2012-02-20'),(12732,'g',0,'2012-02-20'),(12661,'g',0,'2012-02-20'),(12529,'g',0,'2012-02-20'),(12503,'g',0,'2012-02-20'),(12782,'g',0,'2012-02-20'),(12892,'g',0,'2012-02-20'),(12292,'g',0,'2012-02-20'),(12281,'g',0,'2012-02-20'),(11901,'g',0,'2012-02-20'),(12908,'g',0,'2012-02-20'),(11900,'g',0,'2012-02-20'),(12767,'g',0,'2012-02-20'),(12812,'g',0,'2012-02-20'),(12894,'g',0,'2012-02-20'),(11777,'g',0,'2012-02-20'),(11842,'g',0,'2012-02-20'),(11888,'g',0,'2012-02-20'),(11816,'g',0,'2012-02-20'),(12572,'g',0,'2012-02-20'),(12654,'g',0,'2012-02-20'),(12468,'g',0,'2012-02-20'),(12597,'g',0,'2012-02-20'),(11875,'g',0,'2012-02-20'),(11804,'g',0,'2012-02-20'),(12521,'g',0,'2012-02-20'),(11863,'g',0,'2012-02-20'),(11911,'g',0,'2012-02-20'),(11866,'g',0,'2012-02-20'),(12541,'g',0,'2012-02-20'),(12523,'g',0,'2012-02-20'),(12603,'g',0,'2012-02-20'),(12748,'g',0,'2012-02-20'),(11958,'g',0,'2012-02-20'),(12397,'g',0,'2012-02-20'),(11939,'g',0,'2012-02-20'),(12413,'g',0,'2012-02-20'),(11929,'g',0,'2012-02-20'),(11535,'g',0,'2012-02-20'),(12460,'g',0,'2012-02-20'),(12368,'g',0,'2012-02-20'),(12099,'g',0,'2012-02-20'),(12445,'g',0,'2012-02-20'),(11854,'g',0,'2012-02-20'),(12733,'g',0,'2012-02-20'),(12773,'g',0,'2012-02-20'),(12613,'g',0,'2012-02-20'),(12612,'g',0,'2012-02-20'),(11684,'g',0,'2012-02-20'),(12783,'g',0,'2012-02-20'),(12935,'g',0,'2012-02-20'),(12820,'g',0,'2012-02-20'),(11919,'g',0,'2012-02-20'),(12910,'g',0,'2012-02-20'),(12369,'g',0,'2012-02-20'),(11858,'g',0,'2012-02-20'),(11913,'g',0,'2012-02-20'),(12834,'g',0,'2012-02-20'),(12005,'g',0,'2012-02-20'),(12759,'g',0,'2012-02-20'),(11890,'g',0,'2012-02-20'),(12833,'g',0,'2012-02-20'),(11857,'g',0,'2012-02-20'),(11846,'g',0,'2012-02-20'),(11916,'g',0,'2012-02-20'),(11994,'g',0,'2012-02-20'),(12704,'g',0,'2012-02-20'),(12651,'g',0,'2012-02-20'),(12617,'g',0,'2012-02-20'),(11990,'g',0,'2012-02-20'),(11993,'g',0,'2012-02-21'),(12522,'g',0,'2012-02-21'),(12500,'g',0,'2012-02-21'),(12457,'g',0,'2012-02-21'),(12449,'g',0,'2012-02-21'),(12641,'g',0,'2012-02-21'),(11976,'g',0,'2012-02-21'),(12037,'g',0,'2012-02-21'),(12555,'g',0,'2012-02-21'),(11995,'g',0,'2012-02-21'),(12023,'g',0,'2012-02-21'),(12648,'g',0,'2012-02-21'),(12615,'g',0,'2012-02-21'),(12012,'g',0,'2012-02-21'),(11972,'g',0,'2012-02-21'),(12599,'g',0,'2012-02-21'),(12649,'g',0,'2012-02-21'),(12527,'g',0,'2012-02-21'),(12600,'g',0,'2012-02-21'),(12736,'g',0,'2012-02-21'),(12116,'g',0,'2012-02-21'),(12076,'g',0,'2012-02-21'),(12117,'g',0,'2012-02-21'),(11500,'g',0,'2012-02-21'),(11813,'g',0,'2012-02-21'),(12464,'g',0,'2012-02-21'),(12442,'g',0,'2012-02-21'),(11699,'g',0,'2012-02-21'),(12786,'g',0,'2012-02-21'),(12520,'g',0,'2012-02-21'),(12614,'g',0,'2012-02-21'),(12772,'g',0,'2012-02-21'),(12387,'g',0,'2012-02-21'),(12235,'g',0,'2012-02-21'),(12938,'g',0,'2012-02-21'),(12942,'g',0,'2012-02-21'),(11905,'g',0,'2012-02-21'),(12717,'g',0,'2012-02-21'),(12804,'g',0,'2012-02-21'),(11848,'g',0,'2012-02-21'),(11847,'g',0,'2012-02-21'),(12016,'g',0,'2012-02-21'),(12646,'g',0,'2012-02-21'),(12925,'g',0,'2012-02-21'),(11778,'g',0,'2012-02-21'),(12495,'g',0,'2012-02-21'),(11868,'g',0,'2012-02-21'),(11898,'g',0,'2012-02-21'),(11860,'g',0,'2012-02-21'),(11557,'g',0,'2012-02-21'),(11925,'g',0,'2012-02-21'),(12230,'g',0,'2012-02-21'),(12581,'g',0,'2012-02-21'),(12488,'g',0,'2012-02-21'),(12631,'g',0,'2012-02-21'),(11910,'g',0,'2012-02-21'),(11979,'g',0,'2012-02-21'),(12604,'g',0,'2012-02-21'),(12629,'g',0,'2012-02-21'),(12162,'g',0,'2012-02-21'),(12032,'g',0,'2012-02-21'),(12000,'g',0,'2012-02-21'),(12592,'g',0,'2012-02-21'),(12602,'g',0,'2012-02-21'),(12637,'g',0,'2012-02-21'),(12740,'g',0,'2012-02-21'),(12043,'g',0,'2012-02-21'),(11951,'g',0,'2012-02-21'),(11971,'g',0,'2012-02-21'),(12040,'g',0,'2012-02-21'),(12710,'g',0,'2012-02-21'),(12042,'g',0,'2012-02-21'),(11977,'g',0,'2012-02-21'),(12391,'g',0,'2012-02-21'),(12644,'g',0,'2012-02-21'),(11593,'g',0,'2012-02-21'),(12926,'g',0,'2012-02-21'),(12019,'g',0,'2012-02-21'),(11555,'g',0,'2012-02-21'),(11859,'g',0,'2012-02-21'),(11656,'g',0,'2012-02-21'),(11653,'g',0,'2012-02-21'),(12619,'g',0,'2012-02-21'),(12620,'g',0,'2012-02-21'),(12605,'g',0,'2012-02-21'),(12737,'g',0,'2012-02-21'),(12584,'g',0,'2012-02-21'),(12726,'g',0,'2012-02-21'),(12489,'g',0,'2012-02-21'),(12728,'g',0,'2012-02-21'),(12496,'g',0,'2012-02-21'),(12630,'g',0,'2012-02-21'),(12490,'g',0,'2012-02-21'),(12499,'g',0,'2012-02-21'),(11568,'g',0,'2012-02-21'),(12659,'g',0,'2012-02-21'),(11652,'g',0,'2012-02-21'),(12566,'g',0,'2012-02-21'),(12611,'g',0,'2012-02-21'),(11671,'g',0,'2012-02-21'),(11612,'g',0,'2012-02-21'),(11695,'g',0,'2012-02-21'),(11613,'g',0,'2012-02-21'),(11743,'g',0,'2012-02-21'),(11651,'g',0,'2012-02-21'),(11928,'g',0,'2012-02-21'),(11714,'g',0,'2012-02-21'),(12543,'g',0,'2012-02-21'),(11727,'g',0,'2012-02-21'),(12544,'g',0,'2012-02-21'),(12921,'g',0,'2012-02-21'),(12933,'g',0,'2012-02-21'),(12807,'g',0,'2012-02-21'),(12839,'g',0,'2012-02-21'),(12883,'g',0,'2012-02-21'),(12934,'g',0,'2012-02-21'),(12815,'g',0,'2012-02-21'),(12817,'g',0,'2012-02-21'),(12915,'g',0,'2012-02-21'),(12805,'g',0,'2012-02-21'),(12881,'g',0,'2012-02-21'),(12882,'g',0,'2012-02-21'),(12854,'g',0,'2012-02-21'),(12863,'g',0,'2012-02-21'),(12859,'g',0,'2012-02-21'),(12588,'g',0,'2012-02-21'),(12862,'g',0,'2012-02-21'),(12865,'g',0,'2012-02-21'),(12857,'g',0,'2012-02-21'),(12753,'g',0,'2012-02-21'),(12861,'g',0,'2012-02-21'),(12856,'g',0,'2012-02-21'),(12574,'g',0,'2012-02-21'),(12860,'g',0,'2012-02-21'),(12855,'g',0,'2012-02-21'),(12487,'g',0,'2012-02-21'),(12858,'g',0,'2012-02-21'),(12866,'g',0,'2012-02-21'),(12843,'g',0,'2012-02-21'),(12492,'g',0,'2012-02-21'),(12846,'g',0,'2012-02-21'),(12853,'g',0,'2012-02-21'),(12497,'g',0,'2012-02-21'),(12867,'g',0,'2012-02-21'),(12809,'g',0,'2012-02-21'),(12840,'g',0,'2012-02-21'),(12920,'g',0,'2012-02-21'),(12808,'g',0,'2012-02-21'),(12842,'g',0,'2012-02-21'),(12868,'g',0,'2012-02-21'),(12870,'g',0,'2012-02-21'),(12847,'g',0,'2012-02-21'),(12580,'g',0,'2012-02-21'),(12872,'g',0,'2012-02-21'),(12918,'g',0,'2012-02-21'),(12848,'g',0,'2012-02-21'),(12864,'g',0,'2012-02-21'),(12873,'g',0,'2012-02-21'),(12845,'g',0,'2012-02-21'),(12869,'g',0,'2012-02-21'),(12871,'g',0,'2012-02-21'),(12841,'g',0,'2012-02-21'),(12626,'g',0,'2012-02-21'),(12339,'g',0,'2012-02-21'),(12045,'g',0,'2012-02-21'),(11978,'g',0,'2012-02-21'),(12844,'g',0,'2012-02-21'),(12775,'g',0,'2012-02-21'),(11930,'g',0,'2012-02-21'),(12721,'g',0,'2012-02-21'),(11984,'g',0,'2012-02-21'),(12729,'g',0,'2012-02-21'),(12616,'g',0,'2012-02-21'),(12598,'g',0,'2012-02-21'),(12517,'g',0,'2012-02-21'),(12711,'g',0,'2012-02-21'),(12590,'g',0,'2012-02-21'),(11571,'g',0,'2012-02-22'),(12591,'g',0,'2012-02-22'),(12453,'g',0,'2012-02-22'),(11655,'g',0,'2012-02-22'),(11607,'g',0,'2012-02-22'),(11630,'g',0,'2012-02-22'),(12470,'g',0,'2012-02-22'),(12562,'g',0,'2012-02-22'),(12501,'g',0,'2012-02-22'),(11675,'g',0,'2012-02-22'),(12709,'g',0,'2012-02-22'),(11657,'g',0,'2012-02-22'),(12561,'g',0,'2012-02-22'),(12533,'g',0,'2012-02-22'),(12443,'g',0,'2012-02-22'),(12564,'g',0,'2012-02-22'),(12450,'g',0,'2012-02-22'),(12553,'g',0,'2012-02-22'),(11914,'g',0,'2012-02-22'),(12727,'g',0,'2012-02-22'),(12486,'g',0,'2012-02-22'),(12635,'g',0,'2012-02-22'),(12435,'g',0,'2012-02-22'),(12627,'g',0,'2012-02-22'),(12446,'g',0,'2012-02-22'),(12227,'g',0,'2012-02-24'),(12160,'g',0,'2012-02-25'),(12100,'g',0,'2012-02-25'),(12058,'g',0,'2012-02-25'),(12723,'g',0,'2012-02-25'),(12077,'g',0,'2012-02-25'),(11758,'g',0,'2012-02-25'),(12226,'g',0,'2012-02-25'),(12059,'g',0,'2012-02-25'),(11751,'g',0,'2012-02-26'),(12062,'g',0,'2012-02-26'),(12096,'g',0,'2012-02-26'),(12989,'g',0,'2012-02-29'),(12984,'g',0,'2012-03-01'),(12997,'g',0,'2012-03-01'),(12965,'g',0,'2012-03-01'),(12959,'g',0,'2012-03-01'),(12986,'g',0,'2012-03-01'),(12974,'g',0,'2012-03-01'),(12966,'g',0,'2012-03-01'),(12990,'g',0,'2012-03-01'),(11960,'g',0,'2012-03-02'),(13006,'g',0,'2012-03-07'),(13019,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) DEFAULT NULL,
  `sponsored` char(1) DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `enable` char(1) DEFAULT NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `detail` text,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `plugin_file` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL,
  `option_plugin` text,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_plugin`
--


--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_review`
--


--
-- Table structure for table `idx_searchlog`
--

CREATE TABLE `idx_searchlog` (
  `keyword` varchar(100) NOT NULL DEFAULT '',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `result` mediumint(9) unsigned DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_searchlog`
--


--
-- Table structure for table `idx_sessions`
--

CREATE TABLE `idx_sessions` (
  `SESSKEY` varchar(32) NOT NULL DEFAULT '',
  `EXPIRY` int(11) unsigned NOT NULL DEFAULT '0',
  `EXPIREREF` varchar(64) DEFAULT NULL,
  `DATA` text NOT NULL,
  PRIMARY KEY (`SESSKEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_sessions`
--

INSERT INTO `idx_sessions` VALUES ('8da59f8c8ab45e3f371497742bc35abf',1331147057,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.147%22%3B'),('169990308c970acb718d24cb972bd6bf',1331148017,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Fdetail%2F12588%2Findex.php%22%3Bindexu_session_ip%7Cs%3A12%3A%22199.21.99.94%22%3B'),('e6896aeae6aede51e72e1c02779307eb',1331148140,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Ftag%2Fwall-sconces%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('6b50b9709b2620c0166c892912385c22',1331148142,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Ftag%2Fwall-covering%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('10ea9d0156ac547f8207b45c9761c4b6',1331148143,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A26%3A%22%2Ftag%2Ftravertine-fort-worth%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('1cca50bf71c910fccff03f1f373bb1de',1331148144,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A31%3A%22%2Ftag%2Fsri-lanka-holiday-packages%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('031beddf6fb84a4709780924f5212d1a',1331148145,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A33%3A%22%2Ftag%2Fenglish-to-german-translator%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('97ccf988b9d17896ee2334888ba82269',1331148146,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Ftag%2Fdial-a-bin%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('ce53db773742029633049c52ef285a4a',1331148148,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A24%3A%22%2Ftag%2Fchild-care-pearland%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('d2de8eb48f6bb35c3790ce2bc573becb',1331148149,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fgifts%2Fmore2.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B'),('a95a92542a3993ff2474db1610475bbd',1331148151,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A34%3A%22%2Fdetail%2F12005%2Fpaving-delaware.html%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.71%22%3B');

--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(255) DEFAULT NULL,
  `set_hook_place` text,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(255) DEFAULT NULL,
  `setting_value` text,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_setting`
--

INSERT INTO `idx_setting` VALUES (4,'site_name','jumpitup.biz'),(5,'site_url','http://jumpitup.biz'),(6,'email_address','diana.werst@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/jumpitup/public_html/themes/'),(9,'admin_template_path','/home/jumpitup/public_html/admin_tpl/'),(10,'plugin_path','/home/jumpitup/public_html/plugin/'),(12,'active_theme','_jumpitup'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','0'),(26,'only_registered_can_add_review','0'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) NOT NULL DEFAULT '',
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `total` int(11) NOT NULL DEFAULT '0',
  `tag_path` varchar(64) NOT NULL,
  PRIMARY KEY (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_tags`
--


--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL AUTO_INCREMENT,
  `link_id` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `who_is` varchar(255) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) DEFAULT NULL,
  `record_execution` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_users`
--

CREATE TABLE `idx_users` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `vcode` varchar(4) DEFAULT NULL,
  `group_id` tinyint(4) DEFAULT NULL,
  `homepage` varchar(100) DEFAULT NULL,
  `icq` varchar(20) DEFAULT NULL,
  `aol` varchar(20) DEFAULT NULL,
  `yahoo` varchar(20) DEFAULT NULL,
  `biography` text,
  `location` varchar(50) DEFAULT NULL,
  `interest` varchar(50) DEFAULT NULL,
  `occupation` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_users`
--

INSERT INTO `idx_users` VALUES ('admin','b7c0a086fd7fb859c0a4977e9c2e16a2','Administrator','diana.werst@gmail.com','2011-09-22','1','',0,'','','','','','','','');

--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `ip` varchar(100) DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_votes`
--



