-- MySQL dump 10.10 -- -- Host: localhost Database: symtoms_smf1 -- ------------------------------------------------------ -- Server version 5.0.27-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 `smf_attachments` -- DROP TABLE IF EXISTS `smf_attachments`; CREATE TABLE `smf_attachments` ( `ID_ATTACH` int(10) unsigned NOT NULL auto_increment, `ID_THUMB` int(10) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `attachmentType` tinyint(3) unsigned NOT NULL default '0', `filename` tinytext NOT NULL, `size` int(10) unsigned NOT NULL default '0', `downloads` mediumint(8) unsigned NOT NULL default '0', `width` mediumint(8) unsigned NOT NULL default '0', `height` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID_ATTACH`), UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_ATTACH`), KEY `ID_MSG` (`ID_MSG`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_attachments` -- LOCK TABLES `smf_attachments` WRITE; /*!40000 ALTER TABLE `smf_attachments` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_attachments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_ban_groups` -- DROP TABLE IF EXISTS `smf_ban_groups`; CREATE TABLE `smf_ban_groups` ( `ID_BAN_GROUP` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `ban_time` int(10) unsigned NOT NULL default '0', `expire_time` int(10) unsigned default NULL, `cannot_access` tinyint(3) unsigned NOT NULL default '0', `cannot_register` tinyint(3) unsigned NOT NULL default '0', `cannot_post` tinyint(3) unsigned NOT NULL default '0', `cannot_login` tinyint(3) unsigned NOT NULL default '0', `reason` tinytext NOT NULL, `notes` text NOT NULL, PRIMARY KEY (`ID_BAN_GROUP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_ban_groups` -- LOCK TABLES `smf_ban_groups` WRITE; /*!40000 ALTER TABLE `smf_ban_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_ban_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_ban_items` -- DROP TABLE IF EXISTS `smf_ban_items`; CREATE TABLE `smf_ban_items` ( `ID_BAN` mediumint(8) unsigned NOT NULL auto_increment, `ID_BAN_GROUP` smallint(5) unsigned NOT NULL default '0', `ip_low1` tinyint(3) unsigned NOT NULL default '0', `ip_high1` tinyint(3) unsigned NOT NULL default '0', `ip_low2` tinyint(3) unsigned NOT NULL default '0', `ip_high2` tinyint(3) unsigned NOT NULL default '0', `ip_low3` tinyint(3) unsigned NOT NULL default '0', `ip_high3` tinyint(3) unsigned NOT NULL default '0', `ip_low4` tinyint(3) unsigned NOT NULL default '0', `ip_high4` tinyint(3) unsigned NOT NULL default '0', `hostname` tinytext NOT NULL, `email_address` tinytext NOT NULL, `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `hits` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID_BAN`), KEY `ID_BAN_GROUP` (`ID_BAN_GROUP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_ban_items` -- LOCK TABLES `smf_ban_items` WRITE; /*!40000 ALTER TABLE `smf_ban_items` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_ban_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_board_permissions` -- DROP TABLE IF EXISTS `smf_board_permissions`; CREATE TABLE `smf_board_permissions` ( `ID_GROUP` smallint(5) NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `permission` varchar(30) NOT NULL default '', `addDeny` tinyint(4) NOT NULL default '1', PRIMARY KEY (`ID_GROUP`,`ID_BOARD`,`permission`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_board_permissions` -- LOCK TABLES `smf_board_permissions` WRITE; /*!40000 ALTER TABLE `smf_board_permissions` DISABLE KEYS */; INSERT INTO `smf_board_permissions` VALUES (-1,0,'poll_view',1),(0,0,'remove_own',1),(0,0,'lock_own',1),(0,0,'mark_any_notify',1),(0,0,'mark_notify',1),(0,0,'modify_own',1),(0,0,'poll_add_own',1),(0,0,'poll_edit_own',1),(0,0,'poll_lock_own',1),(0,0,'poll_post',1),(0,0,'poll_view',1),(0,0,'poll_vote',1),(0,0,'post_attachment',1),(0,0,'post_new',1),(0,0,'post_reply_any',1),(0,0,'post_reply_own',1),(0,0,'delete_own',1),(0,0,'report_any',1),(0,0,'send_topic',1),(0,0,'view_attachments',1),(2,0,'moderate_board',1),(2,0,'post_new',1),(2,0,'post_reply_own',1),(2,0,'post_reply_any',1),(2,0,'poll_post',1),(2,0,'poll_add_any',1),(2,0,'poll_remove_any',1),(2,0,'poll_view',1),(2,0,'poll_vote',1),(2,0,'poll_edit_any',1),(2,0,'report_any',1),(2,0,'lock_own',1),(2,0,'send_topic',1),(2,0,'mark_any_notify',1),(2,0,'mark_notify',1),(2,0,'delete_own',1),(2,0,'modify_own',1),(2,0,'make_sticky',1),(2,0,'lock_any',1),(2,0,'remove_any',1),(2,0,'move_any',1),(2,0,'merge_any',1),(2,0,'split_any',1),(2,0,'delete_any',1),(2,0,'modify_any',1),(3,0,'moderate_board',1),(3,0,'post_new',1),(3,0,'post_reply_own',1),(3,0,'post_reply_any',1),(3,0,'poll_post',1),(3,0,'poll_add_own',1),(3,0,'poll_remove_any',1),(3,0,'poll_view',1),(3,0,'poll_vote',1),(3,0,'report_any',1),(3,0,'lock_own',1),(3,0,'send_topic',1),(3,0,'mark_any_notify',1),(3,0,'mark_notify',1),(3,0,'delete_own',1),(3,0,'modify_own',1),(3,0,'make_sticky',1),(3,0,'lock_any',1),(3,0,'remove_any',1),(3,0,'move_any',1),(3,0,'merge_any',1),(3,0,'split_any',1),(3,0,'delete_any',1),(3,0,'modify_any',1); /*!40000 ALTER TABLE `smf_board_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_boards` -- DROP TABLE IF EXISTS `smf_boards`; CREATE TABLE `smf_boards` ( `ID_BOARD` smallint(5) unsigned NOT NULL auto_increment, `ID_CAT` tinyint(4) unsigned NOT NULL default '0', `childLevel` tinyint(4) unsigned NOT NULL default '0', `ID_PARENT` smallint(5) unsigned NOT NULL default '0', `boardOrder` smallint(5) NOT NULL default '0', `ID_LAST_MSG` int(10) unsigned NOT NULL default '0', `ID_MSG_UPDATED` int(10) unsigned NOT NULL default '0', `memberGroups` varchar(255) NOT NULL default '-1,0', `name` tinytext NOT NULL, `description` text NOT NULL, `numTopics` mediumint(8) unsigned NOT NULL default '0', `numPosts` mediumint(8) unsigned NOT NULL default '0', `countPosts` tinyint(4) NOT NULL default '0', `ID_THEME` tinyint(4) unsigned NOT NULL default '0', `permission_mode` tinyint(4) unsigned NOT NULL default '0', `override_theme` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`ID_BOARD`), UNIQUE KEY `categories` (`ID_CAT`,`ID_BOARD`), KEY `ID_PARENT` (`ID_PARENT`), KEY `ID_MSG_UPDATED` (`ID_MSG_UPDATED`), KEY `memberGroups` (`memberGroups`(48)) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_boards` -- LOCK TABLES `smf_boards` WRITE; /*!40000 ALTER TABLE `smf_boards` DISABLE KEYS */; INSERT INTO `smf_boards` VALUES (1,1,0,0,1,1,1,'-1,0','General Discussion','Feel free to talk about anything and everything in this board.',1,1,0,0,0,0); /*!40000 ALTER TABLE `smf_boards` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_calendar` -- DROP TABLE IF EXISTS `smf_calendar`; CREATE TABLE `smf_calendar` ( `ID_EVENT` smallint(5) unsigned NOT NULL auto_increment, `startDate` date NOT NULL default '0001-01-01', `endDate` date NOT NULL default '0001-01-01', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', `title` varchar(48) NOT NULL default '', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID_EVENT`), KEY `startDate` (`startDate`), KEY `endDate` (`endDate`), KEY `topic` (`ID_TOPIC`,`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_calendar` -- LOCK TABLES `smf_calendar` WRITE; /*!40000 ALTER TABLE `smf_calendar` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_calendar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_calendar_holidays` -- DROP TABLE IF EXISTS `smf_calendar_holidays`; CREATE TABLE `smf_calendar_holidays` ( `ID_HOLIDAY` smallint(5) unsigned NOT NULL auto_increment, `eventDate` date NOT NULL default '0001-01-01', `title` varchar(30) NOT NULL default '', PRIMARY KEY (`ID_HOLIDAY`), KEY `eventDate` (`eventDate`) ) ENGINE=MyISAM AUTO_INCREMENT=168 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_calendar_holidays` -- LOCK TABLES `smf_calendar_holidays` WRITE; /*!40000 ALTER TABLE `smf_calendar_holidays` DISABLE KEYS */; INSERT INTO `smf_calendar_holidays` VALUES (1,'0004-01-01','New Year\'s'),(2,'0004-12-25','Christmas'),(3,'0004-02-14','Valentine\'s Day'),(4,'0004-03-17','St. Patrick\'s Day'),(5,'0004-04-01','April Fools'),(6,'0004-04-22','Earth Day'),(7,'0004-10-24','United Nations Day'),(8,'0004-10-31','Halloween'),(9,'2004-05-09','Mother\'s Day'),(10,'2005-05-08','Mother\'s Day'),(11,'2006-05-14','Mother\'s Day'),(12,'2007-05-13','Mother\'s Day'),(13,'2008-05-11','Mother\'s Day'),(14,'2009-05-10','Mother\'s Day'),(15,'2010-05-09','Mother\'s Day'),(16,'2011-05-08','Mother\'s Day'),(17,'2012-05-13','Mother\'s Day'),(18,'2013-05-12','Mother\'s Day'),(19,'2014-05-11','Mother\'s Day'),(20,'2015-05-10','Mother\'s Day'),(21,'2016-05-08','Mother\'s Day'),(22,'2017-05-14','Mother\'s Day'),(23,'2018-05-13','Mother\'s Day'),(24,'2019-05-12','Mother\'s Day'),(25,'2020-05-10','Mother\'s Day'),(26,'2004-06-20','Father\'s Day'),(27,'2005-06-19','Father\'s Day'),(28,'2006-06-18','Father\'s Day'),(29,'2007-06-17','Father\'s Day'),(30,'2008-06-15','Father\'s Day'),(31,'2009-06-21','Father\'s Day'),(32,'2010-06-20','Father\'s Day'),(33,'2011-06-19','Father\'s Day'),(34,'2012-06-17','Father\'s Day'),(35,'2013-06-16','Father\'s Day'),(36,'2014-06-15','Father\'s Day'),(37,'2015-06-21','Father\'s Day'),(38,'2016-06-19','Father\'s Day'),(39,'2017-06-18','Father\'s Day'),(40,'2018-06-17','Father\'s Day'),(41,'2019-06-16','Father\'s Day'),(42,'2020-06-21','Father\'s Day'),(43,'2004-06-20','Summer Solstice'),(44,'2005-06-20','Summer Solstice'),(45,'2006-06-21','Summer Solstice'),(46,'2007-06-21','Summer Solstice'),(47,'2008-06-20','Summer Solstice'),(48,'2009-06-20','Summer Solstice'),(49,'2010-06-21','Summer Solstice'),(50,'2011-06-21','Summer Solstice'),(51,'2012-06-20','Summer Solstice'),(52,'2013-06-21','Summer Solstice'),(53,'2014-06-21','Summer Solstice'),(54,'2015-06-21','Summer Solstice'),(55,'2016-06-20','Summer Solstice'),(56,'2017-06-20','Summer Solstice'),(57,'2018-06-21','Summer Solstice'),(58,'2019-06-21','Summer Solstice'),(59,'2020-06-20','Summer Solstice'),(60,'2004-03-19','Vernal Equinox'),(61,'2005-03-20','Vernal Equinox'),(62,'2006-03-20','Vernal Equinox'),(63,'2007-03-20','Vernal Equinox'),(64,'2008-03-19','Vernal Equinox'),(65,'2009-03-20','Vernal Equinox'),(66,'2010-03-20','Vernal Equinox'),(67,'2011-03-20','Vernal Equinox'),(68,'2012-03-20','Vernal Equinox'),(69,'2013-03-20','Vernal Equinox'),(70,'2014-03-20','Vernal Equinox'),(71,'2015-03-20','Vernal Equinox'),(72,'2016-03-19','Vernal Equinox'),(73,'2017-03-20','Vernal Equinox'),(74,'2018-03-20','Vernal Equinox'),(75,'2019-03-20','Vernal Equinox'),(76,'2020-03-19','Vernal Equinox'),(77,'2004-12-21','Winter Solstice'),(78,'2005-12-21','Winter Solstice'),(79,'2006-12-22','Winter Solstice'),(80,'2007-12-22','Winter Solstice'),(81,'2008-12-21','Winter Solstice'),(82,'2009-12-21','Winter Solstice'),(83,'2010-12-21','Winter Solstice'),(84,'2011-12-22','Winter Solstice'),(85,'2012-12-21','Winter Solstice'),(86,'2013-12-21','Winter Solstice'),(87,'2014-12-21','Winter Solstice'),(88,'2015-12-21','Winter Solstice'),(89,'2016-12-21','Winter Solstice'),(90,'2017-12-21','Winter Solstice'),(91,'2018-12-21','Winter Solstice'),(92,'2019-12-21','Winter Solstice'),(93,'2020-12-21','Winter Solstice'),(94,'2004-09-22','Autumnal Equinox'),(95,'2005-09-22','Autumnal Equinox'),(96,'2006-09-22','Autumnal Equinox'),(97,'2007-09-23','Autumnal Equinox'),(98,'2008-09-22','Autumnal Equinox'),(99,'2009-09-22','Autumnal Equinox'),(100,'2010-09-22','Autumnal Equinox'),(101,'2011-09-23','Autumnal Equinox'),(102,'2012-09-22','Autumnal Equinox'),(103,'2013-09-22','Autumnal Equinox'),(104,'2014-09-22','Autumnal Equinox'),(105,'2015-09-23','Autumnal Equinox'),(106,'2016-09-22','Autumnal Equinox'),(107,'2017-09-22','Autumnal Equinox'),(108,'2018-09-22','Autumnal Equinox'),(109,'2019-09-23','Autumnal Equinox'),(110,'2020-09-22','Autumnal Equinox'),(111,'0004-07-04','Independence Day'),(112,'0004-05-05','Cinco de Mayo'),(113,'0004-06-14','Flag Day'),(114,'0004-11-11','Veterans Day'),(115,'0004-02-02','Groundhog Day'),(116,'2004-11-25','Thanksgiving'),(117,'2005-11-24','Thanksgiving'),(118,'2006-11-23','Thanksgiving'),(119,'2007-11-22','Thanksgiving'),(120,'2008-11-27','Thanksgiving'),(121,'2009-11-26','Thanksgiving'),(122,'2010-11-25','Thanksgiving'),(123,'2011-11-24','Thanksgiving'),(124,'2012-11-22','Thanksgiving'),(125,'2013-11-21','Thanksgiving'),(126,'2014-11-20','Thanksgiving'),(127,'2015-11-26','Thanksgiving'),(128,'2016-11-24','Thanksgiving'),(129,'2017-11-23','Thanksgiving'),(130,'2018-11-22','Thanksgiving'),(131,'2019-11-21','Thanksgiving'),(132,'2020-11-26','Thanksgiving'),(133,'2004-05-31','Memorial Day'),(134,'2005-05-30','Memorial Day'),(135,'2006-05-29','Memorial Day'),(136,'2007-05-28','Memorial Day'),(137,'2008-05-26','Memorial Day'),(138,'2009-05-25','Memorial Day'),(139,'2010-05-31','Memorial Day'),(140,'2011-05-30','Memorial Day'),(141,'2012-05-28','Memorial Day'),(142,'2013-05-27','Memorial Day'),(143,'2014-05-26','Memorial Day'),(144,'2015-05-25','Memorial Day'),(145,'2016-05-30','Memorial Day'),(146,'2017-05-29','Memorial Day'),(147,'2018-05-28','Memorial Day'),(148,'2019-05-27','Memorial Day'),(149,'2020-05-25','Memorial Day'),(150,'2004-09-06','Labor Day'),(151,'2005-09-05','Labor Day'),(152,'2006-09-04','Labor Day'),(153,'2007-09-03','Labor Day'),(154,'2008-09-01','Labor Day'),(155,'2009-09-07','Labor Day'),(156,'2010-09-06','Labor Day'),(157,'2011-09-05','Labor Day'),(158,'2012-09-03','Labor Day'),(159,'2013-09-09','Labor Day'),(160,'2014-09-08','Labor Day'),(161,'2015-09-07','Labor Day'),(162,'2016-09-05','Labor Day'),(163,'2017-09-04','Labor Day'),(164,'2018-09-03','Labor Day'),(165,'2019-09-09','Labor Day'),(166,'2020-09-07','Labor Day'),(167,'0004-06-06','D-Day'); /*!40000 ALTER TABLE `smf_calendar_holidays` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_categories` -- DROP TABLE IF EXISTS `smf_categories`; CREATE TABLE `smf_categories` ( `ID_CAT` tinyint(4) unsigned NOT NULL auto_increment, `catOrder` tinyint(4) NOT NULL default '0', `name` tinytext NOT NULL, `canCollapse` tinyint(1) NOT NULL default '1', PRIMARY KEY (`ID_CAT`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_categories` -- LOCK TABLES `smf_categories` WRITE; /*!40000 ALTER TABLE `smf_categories` DISABLE KEYS */; INSERT INTO `smf_categories` VALUES (1,0,'General Category',1); /*!40000 ALTER TABLE `smf_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_collapsed_categories` -- DROP TABLE IF EXISTS `smf_collapsed_categories`; CREATE TABLE `smf_collapsed_categories` ( `ID_CAT` tinyint(4) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID_CAT`,`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_collapsed_categories` -- LOCK TABLES `smf_collapsed_categories` WRITE; /*!40000 ALTER TABLE `smf_collapsed_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_collapsed_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_actions` -- DROP TABLE IF EXISTS `smf_log_actions`; CREATE TABLE `smf_log_actions` ( `ID_ACTION` int(10) unsigned NOT NULL auto_increment, `logTime` int(10) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `action` varchar(30) NOT NULL default '', `extra` text NOT NULL, PRIMARY KEY (`ID_ACTION`), KEY `logTime` (`logTime`), KEY `ID_MEMBER` (`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_actions` -- LOCK TABLES `smf_log_actions` WRITE; /*!40000 ALTER TABLE `smf_log_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_activity` -- DROP TABLE IF EXISTS `smf_log_activity`; CREATE TABLE `smf_log_activity` ( `date` date NOT NULL default '0001-01-01', `hits` mediumint(8) unsigned NOT NULL default '0', `topics` smallint(5) unsigned NOT NULL default '0', `posts` smallint(5) unsigned NOT NULL default '0', `registers` smallint(5) unsigned NOT NULL default '0', `mostOn` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`date`), KEY `hits` (`hits`), KEY `mostOn` (`mostOn`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_activity` -- LOCK TABLES `smf_log_activity` WRITE; /*!40000 ALTER TABLE `smf_log_activity` DISABLE KEYS */; INSERT INTO `smf_log_activity` VALUES ('2007-05-23',0,0,0,0,1),('2007-05-24',0,0,0,0,1),('2007-05-25',0,0,0,0,1),('2007-05-26',0,0,0,0,1),('2007-05-27',0,0,0,0,1),('2007-05-28',0,0,0,0,1),('2007-05-29',0,0,0,0,1),('2007-05-31',0,0,0,0,1),('2007-06-01',0,0,0,0,1),('2007-06-04',0,0,0,0,1),('2007-06-05',0,0,0,0,1),('2007-06-07',0,0,0,0,1),('2007-06-08',0,0,0,0,1),('2007-06-09',0,0,0,0,1),('2007-06-10',0,0,0,0,1),('2007-06-11',0,0,0,0,1),('2007-06-16',0,0,0,0,1),('2007-06-18',0,0,0,0,1),('2007-06-19',0,0,0,0,1),('2007-06-20',0,0,0,0,1),('2007-06-21',0,0,0,0,1),('2007-06-24',0,0,0,0,1),('2007-06-25',0,0,0,0,1),('2007-06-26',0,0,0,0,1),('2007-06-27',0,0,0,0,1),('2007-06-29',0,0,0,0,1),('2007-06-30',0,0,0,0,1),('2007-07-03',0,0,0,0,1),('2007-07-04',0,0,0,0,1),('2007-07-05',0,0,0,0,1),('2007-07-08',0,0,0,0,1),('2007-07-09',0,0,0,0,1),('2007-07-12',0,0,0,0,1),('2007-07-14',0,0,0,0,1),('2007-07-15',0,0,0,0,1),('2007-07-16',0,0,0,0,1),('2007-07-17',0,0,0,0,1),('2007-07-18',0,0,0,0,1),('2007-07-20',0,0,0,0,1),('2007-07-21',0,0,0,0,1),('2007-07-23',0,0,0,0,1),('2007-07-24',0,0,0,0,1),('2007-07-25',0,0,0,0,1),('2007-07-27',0,0,0,0,1),('2007-07-31',0,0,0,0,2),('2007-08-02',0,0,0,0,1),('2007-08-03',0,0,0,0,1),('2007-08-04',0,0,0,0,1),('2007-08-05',0,0,0,0,1),('2007-08-06',0,0,0,0,1),('2007-08-07',0,0,0,0,1),('2007-08-08',0,0,0,0,1),('2007-08-09',0,0,0,0,1),('2007-08-11',0,0,0,0,1),('2007-08-13',0,0,0,0,1),('2007-08-15',0,0,0,0,1),('2007-08-16',0,0,0,0,1),('2007-08-17',0,0,0,0,1),('2007-08-18',0,0,0,0,1); /*!40000 ALTER TABLE `smf_log_activity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_banned` -- DROP TABLE IF EXISTS `smf_log_banned`; CREATE TABLE `smf_log_banned` ( `ID_BAN_LOG` mediumint(8) unsigned NOT NULL auto_increment, `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `email` tinytext NOT NULL, `logTime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ID_BAN_LOG`), KEY `logTime` (`logTime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_banned` -- LOCK TABLES `smf_log_banned` WRITE; /*!40000 ALTER TABLE `smf_log_banned` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_banned` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_boards` -- DROP TABLE IF EXISTS `smf_log_boards`; CREATE TABLE `smf_log_boards` ( `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ID_MEMBER`,`ID_BOARD`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_boards` -- LOCK TABLES `smf_log_boards` WRITE; /*!40000 ALTER TABLE `smf_log_boards` DISABLE KEYS */; INSERT INTO `smf_log_boards` VALUES (1,1,1); /*!40000 ALTER TABLE `smf_log_boards` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_errors` -- DROP TABLE IF EXISTS `smf_log_errors`; CREATE TABLE `smf_log_errors` ( `ID_ERROR` mediumint(8) unsigned NOT NULL auto_increment, `logTime` int(10) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `url` text NOT NULL, `message` text NOT NULL, `session` varchar(32) NOT NULL default '', PRIMARY KEY (`ID_ERROR`), KEY `logTime` (`logTime`), KEY `ID_MEMBER` (`ID_MEMBER`), KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_errors` -- LOCK TABLES `smf_log_errors` WRITE; /*!40000 ALTER TABLE `smf_log_errors` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_errors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_floodcontrol` -- DROP TABLE IF EXISTS `smf_log_floodcontrol`; CREATE TABLE `smf_log_floodcontrol` ( `ip` char(16) NOT NULL default '', `logTime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_floodcontrol` -- LOCK TABLES `smf_log_floodcontrol` WRITE; /*!40000 ALTER TABLE `smf_log_floodcontrol` DISABLE KEYS */; INSERT INTO `smf_log_floodcontrol` VALUES ('83.222.23.202',1187314850); /*!40000 ALTER TABLE `smf_log_floodcontrol` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_karma` -- DROP TABLE IF EXISTS `smf_log_karma`; CREATE TABLE `smf_log_karma` ( `ID_TARGET` mediumint(8) unsigned NOT NULL default '0', `ID_EXECUTOR` mediumint(8) unsigned NOT NULL default '0', `logTime` int(10) unsigned NOT NULL default '0', `action` tinyint(4) NOT NULL default '0', PRIMARY KEY (`ID_TARGET`,`ID_EXECUTOR`), KEY `logTime` (`logTime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_karma` -- LOCK TABLES `smf_log_karma` WRITE; /*!40000 ALTER TABLE `smf_log_karma` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_karma` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_mark_read` -- DROP TABLE IF EXISTS `smf_log_mark_read`; CREATE TABLE `smf_log_mark_read` ( `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ID_MEMBER`,`ID_BOARD`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_mark_read` -- LOCK TABLES `smf_log_mark_read` WRITE; /*!40000 ALTER TABLE `smf_log_mark_read` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_mark_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_notify` -- DROP TABLE IF EXISTS `smf_log_notify`; CREATE TABLE `smf_log_notify` ( `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `sent` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`ID_MEMBER`,`ID_TOPIC`,`ID_BOARD`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_notify` -- LOCK TABLES `smf_log_notify` WRITE; /*!40000 ALTER TABLE `smf_log_notify` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_notify` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_online` -- DROP TABLE IF EXISTS `smf_log_online`; CREATE TABLE `smf_log_online` ( `session` varchar(32) NOT NULL default '', `logTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ip` int(10) unsigned NOT NULL default '0', `url` text NOT NULL, PRIMARY KEY (`session`), KEY `logTime` (`logTime`), KEY `ID_MEMBER` (`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_online` -- LOCK TABLES `smf_log_online` WRITE; /*!40000 ALTER TABLE `smf_log_online` DISABLE KEYS */; INSERT INTO `smf_log_online` VALUES ('ip24.37.120.244','2007-08-18 13:25:15',0,405108980,'a:1:{s:10:\"USER_AGENT\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6\";}'); /*!40000 ALTER TABLE `smf_log_online` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_polls` -- DROP TABLE IF EXISTS `smf_log_polls`; CREATE TABLE `smf_log_polls` ( `ID_POLL` mediumint(8) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_CHOICE` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID_POLL`,`ID_MEMBER`,`ID_CHOICE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_polls` -- LOCK TABLES `smf_log_polls` WRITE; /*!40000 ALTER TABLE `smf_log_polls` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_polls` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_search_messages` -- DROP TABLE IF EXISTS `smf_log_search_messages`; CREATE TABLE `smf_log_search_messages` ( `ID_SEARCH` tinyint(3) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ID_SEARCH`,`ID_MSG`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_search_messages` -- LOCK TABLES `smf_log_search_messages` WRITE; /*!40000 ALTER TABLE `smf_log_search_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_search_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_search_results` -- DROP TABLE IF EXISTS `smf_log_search_results`; CREATE TABLE `smf_log_search_results` ( `ID_SEARCH` tinyint(3) unsigned NOT NULL default '0', `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', `relevance` smallint(5) unsigned NOT NULL default '0', `num_matches` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`ID_SEARCH`,`ID_TOPIC`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_search_results` -- LOCK TABLES `smf_log_search_results` WRITE; /*!40000 ALTER TABLE `smf_log_search_results` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_search_results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_search_subjects` -- DROP TABLE IF EXISTS `smf_log_search_subjects`; CREATE TABLE `smf_log_search_subjects` ( `word` varchar(20) NOT NULL default '', `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`word`,`ID_TOPIC`), KEY `ID_TOPIC` (`ID_TOPIC`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_search_subjects` -- LOCK TABLES `smf_log_search_subjects` WRITE; /*!40000 ALTER TABLE `smf_log_search_subjects` DISABLE KEYS */; INSERT INTO `smf_log_search_subjects` VALUES ('discussion',1),('forum',1),('org',1),('symtoms',1),('to',1),('welcome',1); /*!40000 ALTER TABLE `smf_log_search_subjects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_search_topics` -- DROP TABLE IF EXISTS `smf_log_search_topics`; CREATE TABLE `smf_log_search_topics` ( `ID_SEARCH` tinyint(3) unsigned NOT NULL default '0', `ID_TOPIC` mediumint(9) NOT NULL default '0', PRIMARY KEY (`ID_SEARCH`,`ID_TOPIC`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_search_topics` -- LOCK TABLES `smf_log_search_topics` WRITE; /*!40000 ALTER TABLE `smf_log_search_topics` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_log_search_topics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_log_topics` -- DROP TABLE IF EXISTS `smf_log_topics`; CREATE TABLE `smf_log_topics` ( `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ID_MEMBER`,`ID_TOPIC`), KEY `ID_TOPIC` (`ID_TOPIC`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_log_topics` -- LOCK TABLES `smf_log_topics` WRITE; /*!40000 ALTER TABLE `smf_log_topics` DISABLE KEYS */; INSERT INTO `smf_log_topics` VALUES (1,1,1); /*!40000 ALTER TABLE `smf_log_topics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_membergroups` -- DROP TABLE IF EXISTS `smf_membergroups`; CREATE TABLE `smf_membergroups` ( `ID_GROUP` smallint(5) unsigned NOT NULL auto_increment, `groupName` varchar(80) NOT NULL default '', `onlineColor` varchar(20) NOT NULL default '', `minPosts` mediumint(9) NOT NULL default '-1', `maxMessages` smallint(5) unsigned NOT NULL default '0', `stars` tinytext NOT NULL, PRIMARY KEY (`ID_GROUP`), KEY `minPosts` (`minPosts`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_membergroups` -- LOCK TABLES `smf_membergroups` WRITE; /*!40000 ALTER TABLE `smf_membergroups` DISABLE KEYS */; INSERT INTO `smf_membergroups` VALUES (1,'Administrator','#FF0000',-1,0,'5#staradmin.gif'),(2,'Global Moderator','#0000FF',-1,0,'5#stargmod.gif'),(3,'Moderator','',-1,0,'5#starmod.gif'),(4,'Newbie','',0,0,'1#star.gif'),(5,'Jr. Member','',50,0,'2#star.gif'),(6,'Full Member','',100,0,'3#star.gif'),(7,'Sr. Member','',250,0,'4#star.gif'),(8,'Hero Member','',500,0,'5#star.gif'); /*!40000 ALTER TABLE `smf_membergroups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_members` -- DROP TABLE IF EXISTS `smf_members`; CREATE TABLE `smf_members` ( `ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment, `memberName` varchar(80) NOT NULL default '', `dateRegistered` int(10) unsigned NOT NULL default '0', `posts` mediumint(8) unsigned NOT NULL default '0', `ID_GROUP` smallint(5) unsigned NOT NULL default '0', `lngfile` tinytext NOT NULL, `lastLogin` int(10) unsigned NOT NULL default '0', `realName` tinytext NOT NULL, `instantMessages` smallint(5) NOT NULL default '0', `unreadMessages` smallint(5) NOT NULL default '0', `buddy_list` text NOT NULL, `pm_ignore_list` tinytext NOT NULL, `messageLabels` text NOT NULL, `passwd` varchar(64) NOT NULL default '', `emailAddress` tinytext NOT NULL, `personalText` tinytext NOT NULL, `gender` tinyint(4) unsigned NOT NULL default '0', `birthdate` date NOT NULL default '0001-01-01', `websiteTitle` tinytext NOT NULL, `websiteUrl` tinytext NOT NULL, `location` tinytext NOT NULL, `ICQ` tinytext NOT NULL, `AIM` varchar(16) NOT NULL default '', `YIM` varchar(32) NOT NULL default '', `MSN` tinytext NOT NULL, `hideEmail` tinyint(4) NOT NULL default '0', `showOnline` tinyint(4) NOT NULL default '1', `timeFormat` varchar(80) NOT NULL default '', `signature` text NOT NULL, `timeOffset` float NOT NULL default '0', `avatar` tinytext NOT NULL, `pm_email_notify` tinyint(4) NOT NULL default '0', `karmaBad` smallint(5) unsigned NOT NULL default '0', `karmaGood` smallint(5) unsigned NOT NULL default '0', `usertitle` tinytext NOT NULL, `notifyAnnouncements` tinyint(4) NOT NULL default '1', `notifyOnce` tinyint(4) NOT NULL default '1', `notifySendBody` tinyint(4) NOT NULL default '0', `notifyTypes` tinyint(4) NOT NULL default '2', `memberIP` tinytext NOT NULL, `memberIP2` tinytext NOT NULL, `secretQuestion` tinytext NOT NULL, `secretAnswer` varchar(64) NOT NULL default '', `ID_THEME` tinyint(4) unsigned NOT NULL default '0', `is_activated` tinyint(3) unsigned NOT NULL default '1', `validation_code` varchar(10) NOT NULL default '', `ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0', `additionalGroups` tinytext NOT NULL, `smileySet` varchar(48) NOT NULL default '', `ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0', `totalTimeLoggedIn` int(10) unsigned NOT NULL default '0', `passwordSalt` varchar(5) NOT NULL default '', PRIMARY KEY (`ID_MEMBER`), KEY `memberName` (`memberName`(30)), KEY `dateRegistered` (`dateRegistered`), KEY `ID_GROUP` (`ID_GROUP`), KEY `birthdate` (`birthdate`), KEY `posts` (`posts`), KEY `lastLogin` (`lastLogin`), KEY `lngfile` (`lngfile`(30)), KEY `ID_POST_GROUP` (`ID_POST_GROUP`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_members` -- LOCK TABLES `smf_members` WRITE; /*!40000 ALTER TABLE `smf_members` DISABLE KEYS */; INSERT INTO `smf_members` VALUES (1,'admin',1179924909,0,1,'',1179926715,'Administrator',0,0,'','','','dd09cd4aa10c00a1c777479332f2a8841ac2cf04','info@symtoms.org','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',0,0,0,'',1,1,0,2,'70.83.155.37','70.83.155.37','','',0,1,'',1,'','',0,258,'dbb5'); /*!40000 ALTER TABLE `smf_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_message_icons` -- DROP TABLE IF EXISTS `smf_message_icons`; CREATE TABLE `smf_message_icons` ( `ID_ICON` smallint(5) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `filename` varchar(80) NOT NULL default '', `ID_BOARD` mediumint(8) unsigned NOT NULL default '0', `iconOrder` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`ID_ICON`), KEY `ID_BOARD` (`ID_BOARD`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_message_icons` -- LOCK TABLES `smf_message_icons` WRITE; /*!40000 ALTER TABLE `smf_message_icons` DISABLE KEYS */; INSERT INTO `smf_message_icons` VALUES (1,'Standard','xx',0,0),(2,'Thumb Up','thumbup',0,1),(3,'Thumb Down','thumbdown',0,2),(4,'Exclamation point','exclamation',0,3),(5,'Question mark','question',0,4),(6,'Lamp','lamp',0,5),(7,'Smiley','smiley',0,6),(8,'Angry','angry',0,7),(9,'Cheesy','cheesy',0,8),(10,'Grin','grin',0,9),(11,'Sad','sad',0,10),(12,'Wink','wink',0,11); /*!40000 ALTER TABLE `smf_message_icons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_messages` -- DROP TABLE IF EXISTS `smf_messages`; CREATE TABLE `smf_messages` ( `ID_MSG` int(10) unsigned NOT NULL auto_increment, `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `posterTime` int(10) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ID_MSG_MODIFIED` int(10) unsigned NOT NULL default '0', `subject` tinytext NOT NULL, `posterName` tinytext NOT NULL, `posterEmail` tinytext NOT NULL, `posterIP` tinytext NOT NULL, `smileysEnabled` tinyint(4) NOT NULL default '1', `modifiedTime` int(10) unsigned NOT NULL default '0', `modifiedName` tinytext NOT NULL, `body` text NOT NULL, `icon` varchar(16) NOT NULL default 'xx', PRIMARY KEY (`ID_MSG`), UNIQUE KEY `topic` (`ID_TOPIC`,`ID_MSG`), UNIQUE KEY `ID_BOARD` (`ID_BOARD`,`ID_MSG`), UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_MSG`), KEY `ipIndex` (`posterIP`(15),`ID_TOPIC`), KEY `participation` (`ID_MEMBER`,`ID_TOPIC`), KEY `showPosts` (`ID_MEMBER`,`ID_BOARD`), KEY `ID_TOPIC` (`ID_TOPIC`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_messages` -- LOCK TABLES `smf_messages` WRITE; /*!40000 ALTER TABLE `smf_messages` DISABLE KEYS */; INSERT INTO `smf_messages` VALUES (1,1,1,1179924909,0,1,'Welcome to Symtoms.org Discussion Forum','symptoms.org','cabano@gmail.com','127.0.0.1',1,1179926723,'Administrator','Welcome to Symtoms.org!

We hope you enjoy using your forum.  If you have any problems, please feel free to contact us.

Thanks!
Symtoms.org Team.','xx'); /*!40000 ALTER TABLE `smf_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_moderators` -- DROP TABLE IF EXISTS `smf_moderators`; CREATE TABLE `smf_moderators` ( `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID_BOARD`,`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_moderators` -- LOCK TABLES `smf_moderators` WRITE; /*!40000 ALTER TABLE `smf_moderators` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_moderators` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_package_servers` -- DROP TABLE IF EXISTS `smf_package_servers`; CREATE TABLE `smf_package_servers` ( `ID_SERVER` smallint(5) unsigned NOT NULL auto_increment, `name` tinytext NOT NULL, `url` tinytext NOT NULL, PRIMARY KEY (`ID_SERVER`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_package_servers` -- LOCK TABLES `smf_package_servers` WRITE; /*!40000 ALTER TABLE `smf_package_servers` DISABLE KEYS */; INSERT INTO `smf_package_servers` VALUES (1,'Simple Machines Third-party Mod Site','http://mods.simplemachines.org'); /*!40000 ALTER TABLE `smf_package_servers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_permissions` -- DROP TABLE IF EXISTS `smf_permissions`; CREATE TABLE `smf_permissions` ( `ID_GROUP` smallint(5) NOT NULL default '0', `permission` varchar(30) NOT NULL default '', `addDeny` tinyint(4) NOT NULL default '1', PRIMARY KEY (`ID_GROUP`,`permission`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_permissions` -- LOCK TABLES `smf_permissions` WRITE; /*!40000 ALTER TABLE `smf_permissions` DISABLE KEYS */; INSERT INTO `smf_permissions` VALUES (-1,'search_posts',1),(-1,'calendar_view',1),(-1,'view_stats',1),(-1,'profile_view_any',1),(0,'view_mlist',1),(0,'search_posts',1),(0,'profile_view_own',1),(0,'profile_view_any',1),(0,'pm_read',1),(0,'pm_send',1),(0,'calendar_view',1),(0,'view_stats',1),(0,'who_view',1),(0,'profile_identity_own',1),(0,'profile_extra_own',1),(0,'profile_remove_own',1),(0,'profile_server_avatar',1),(0,'profile_upload_avatar',1),(0,'profile_remote_avatar',1),(0,'karma_edit',1),(2,'view_mlist',1),(2,'search_posts',1),(2,'profile_view_own',1),(2,'profile_view_any',1),(2,'pm_read',1),(2,'pm_send',1),(2,'calendar_view',1),(2,'view_stats',1),(2,'who_view',1),(2,'profile_identity_own',1),(2,'profile_extra_own',1),(2,'profile_remove_own',1),(2,'profile_server_avatar',1),(2,'profile_upload_avatar',1),(2,'profile_remote_avatar',1),(2,'profile_title_own',1),(2,'calendar_post',1),(2,'calendar_edit_any',1),(2,'karma_edit',1); /*!40000 ALTER TABLE `smf_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_personal_messages` -- DROP TABLE IF EXISTS `smf_personal_messages`; CREATE TABLE `smf_personal_messages` ( `ID_PM` int(10) unsigned NOT NULL auto_increment, `ID_MEMBER_FROM` mediumint(8) unsigned NOT NULL default '0', `deletedBySender` tinyint(3) unsigned NOT NULL default '0', `fromName` tinytext NOT NULL, `msgtime` int(10) unsigned NOT NULL default '0', `subject` tinytext NOT NULL, `body` text NOT NULL, PRIMARY KEY (`ID_PM`), KEY `ID_MEMBER` (`ID_MEMBER_FROM`,`deletedBySender`), KEY `msgtime` (`msgtime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_personal_messages` -- LOCK TABLES `smf_personal_messages` WRITE; /*!40000 ALTER TABLE `smf_personal_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_personal_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_pm_recipients` -- DROP TABLE IF EXISTS `smf_pm_recipients`; CREATE TABLE `smf_pm_recipients` ( `ID_PM` int(10) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `labels` varchar(60) NOT NULL default '-1', `bcc` tinyint(3) unsigned NOT NULL default '0', `is_read` tinyint(3) unsigned NOT NULL default '0', `deleted` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID_PM`,`ID_MEMBER`), UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`deleted`,`ID_PM`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_pm_recipients` -- LOCK TABLES `smf_pm_recipients` WRITE; /*!40000 ALTER TABLE `smf_pm_recipients` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_pm_recipients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_poll_choices` -- DROP TABLE IF EXISTS `smf_poll_choices`; CREATE TABLE `smf_poll_choices` ( `ID_POLL` mediumint(8) unsigned NOT NULL default '0', `ID_CHOICE` tinyint(3) unsigned NOT NULL default '0', `label` tinytext NOT NULL, `votes` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`ID_POLL`,`ID_CHOICE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_poll_choices` -- LOCK TABLES `smf_poll_choices` WRITE; /*!40000 ALTER TABLE `smf_poll_choices` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_poll_choices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_polls` -- DROP TABLE IF EXISTS `smf_polls`; CREATE TABLE `smf_polls` ( `ID_POLL` mediumint(8) unsigned NOT NULL auto_increment, `question` tinytext NOT NULL, `votingLocked` tinyint(1) NOT NULL default '0', `maxVotes` tinyint(3) unsigned NOT NULL default '1', `expireTime` int(10) unsigned NOT NULL default '0', `hideResults` tinyint(3) unsigned NOT NULL default '0', `changeVote` tinyint(3) unsigned NOT NULL default '0', `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `posterName` tinytext NOT NULL, PRIMARY KEY (`ID_POLL`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_polls` -- LOCK TABLES `smf_polls` WRITE; /*!40000 ALTER TABLE `smf_polls` DISABLE KEYS */; /*!40000 ALTER TABLE `smf_polls` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_sessions` -- DROP TABLE IF EXISTS `smf_sessions`; CREATE TABLE `smf_sessions` ( `session_id` varchar(32) NOT NULL default '', `last_update` int(10) unsigned NOT NULL default '0', `data` text NOT NULL, PRIMARY KEY (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_sessions` -- LOCK TABLES `smf_sessions` WRITE; /*!40000 ALTER TABLE `smf_sessions` DISABLE KEYS */; INSERT INTO `smf_sessions` VALUES ('e2029e1fe4cb6a9b3c1e87393c1a9991',1186535106,'rand_code|s:32:\"cacbb9713e663ed920712e972c98ef37\";ban|a:5:{s:12:\"last_checked\";i:1186535106;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186535106;timeOnlineUpdated|i:1186535106;old_url|s:47:\"http://symtoms.org/forum/index.php?action=login\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('8c0f5f47fc2ea312d6246da388aeccb4',1186533325,'rand_code|s:32:\"415e0c008dc1a466de5433528d6e9e87\";ban|a:5:{s:12:\"last_checked\";i:1186533325;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186533325;timeOnlineUpdated|i:1186533325;old_url|s:46:\"http://symtoms.org/forum/index.php?action=help\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('0544ce5e83badd660115964cfd4c7e6b',1186532871,'rand_code|s:32:\"254339d24ada494f1046c2abaaeb702e\";ban|a:5:{s:12:\"last_checked\";i:1186532871;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186532871;timeOnlineUpdated|i:1186532871;old_url|s:34:\"http://symtoms.org/forum/index.php\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('9aacf3a6ec478f692d74a6ba9119f918',1186532256,'rand_code|s:32:\"df33aad88fb9a7ea6662d56af7cb919d\";ban|a:5:{s:12:\"last_checked\";i:1186532256;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186532256;timeOnlineUpdated|i:1186532256;old_url|s:48:\"http://symtoms.org/forum/index.php?action=search\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('e1bd211f091f7ddfc8d3764b9c664829',1186532078,'rand_code|s:32:\"4ddc42eb3662afdbbec93b8fded47078\";ban|a:5:{s:12:\"last_checked\";i:1186532078;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186532078;timeOnlineUpdated|i:1186532078;old_url|s:59:\"http://symtoms.org/forum/index.php?board=1.0;sort=last_post\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('cd5765ea0849606f636244fed95e21ab',1186530412,'rand_code|s:32:\"2dc8019d62a4b9b184554adff76ba01d\";ban|a:5:{s:12:\"last_checked\";i:1186530412;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186530412;timeOnlineUpdated|i:1186530412;old_url|s:48:\"http://symtoms.org/forum/index.php?action=recent\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('8ba0dcc6ae664efae204bbacedb903af',1186530412,'rand_code|s:32:\"3361dc7b0f556508bf721864b513cf70\";ban|a:5:{s:12:\"last_checked\";i:1186530412;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186530412;timeOnlineUpdated|i:1186530412;old_url|s:44:\"http://symtoms.org/forum/index.php?board=1.0\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('9d11e49093fde29258a8381a2bb1ca98',1186530412,'rand_code|s:32:\"d7ee55f8e05608654c253e0aecaae7fb\";ban|a:5:{s:12:\"last_checked\";i:1186530412;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186530412;timeOnlineUpdated|i:1186530412;old_url|s:57:\"http://symtoms.org/forum/index.php?action=search;advanced\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('82969f5db3df89cd6b98cfdfa9975503',1186496866,'rand_code|s:32:\"ced590422d179f0f1301b09ee4f04a7a\";ban|a:5:{s:12:\"last_checked\";i:1186496864;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:14:\"194.176.105.41\";s:3:\"ip2\";s:14:\"194.176.105.41\";s:5:\"email\";s:0:\"\";}log_time|i:1186496866;timeOnlineUpdated|i:1186496866;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:46:\"Mozilla/4.0 (compatible; MSIE 5.0; Windows NT)\";'),('573c365ece8ece416b5bf349e7aea621',1186453840,'rand_code|s:32:\"7b0c4bd5139992d298df1f2d0f1381c7\";ban|a:5:{s:12:\"last_checked\";i:1186453840;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"70.249.73.34\";s:3:\"ip2\";s:12:\"70.249.73.34\";s:5:\"email\";s:0:\"\";}log_time|i:1186453840;timeOnlineUpdated|i:1186453840;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:46:\"Mozilla/4.0 (compatible; MSIE 5.0; Windows NT)\";'),('f7e557ab1dbc59f8b9f41d74a8c3ee82',1186355243,'rand_code|s:32:\"cc92897d11662456a605ea7ac50f24d6\";ban|a:5:{s:12:\"last_checked\";i:1186355242;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"72.36.94.103\";s:3:\"ip2\";s:12:\"72.36.94.103\";s:5:\"email\";s:0:\"\";}log_time|i:1186355242;timeOnlineUpdated|i:1186355242;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:112:\"CazoodleBot/CazoodleBot-0.1 (CazoodleBot Crawler; http://www.cazoodle.com/cazoodlebot; cazoodlebot@cazoodle.com)\";'),('9ae5541228be6b0024b850d87c12c37b',1186346812,'rand_code|s:32:\"e6ed56c7cf550c759448de20360ad38a\";ban|a:5:{s:12:\"last_checked\";i:1186346812;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186346812;timeOnlineUpdated|i:1186346812;old_url|s:48:\"http://symtoms.org/forum/index.php?action=search\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('70504ee836b3193ea54b1fc083e21d4f',1186333487,'rand_code|s:32:\"f093a16d7c89d5509edd659c4e375ee5\";ban|a:5:{s:12:\"last_checked\";i:1186333487;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186333487;timeOnlineUpdated|i:1186333487;expanded_stats|a:1:{i:2007;a:1:{i:0;i:7;}}old_url|s:61:\"http://symtoms.org/forum/index.php?action=stats;expand=200707\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('acc1313dd9dbeb59b859e5c35b88be52',1186333415,'rand_code|s:32:\"6c12316cddc52eb72ade7ddbedc85d8d\";ban|a:5:{s:12:\"last_checked\";i:1186333415;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186333415;timeOnlineUpdated|i:1186333415;expanded_stats|a:1:{i:2007;a:1:{i:0;i:8;}}old_url|s:61:\"http://symtoms.org/forum/index.php?action=stats;expand=200708\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('25c57e697fa44874d2e4e091546402b5',1186278558,'rand_code|s:32:\"7f01f93d081c870012909a6f7899d102\";ban|a:5:{s:12:\"last_checked\";i:1186278558;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186278558;timeOnlineUpdated|i:1186278558;last_read_topic|i:1;old_url|s:58:\"http://symtoms.org/forum/index.php?topic=1.msg%25msg_id%25\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('928e0be186a4dbea8ca17cee80525b34',1186278550,'rand_code|s:32:\"bdfd68f171dfac2df6fe93529cae5079\";ban|a:5:{s:12:\"last_checked\";i:1186278550;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186278550;timeOnlineUpdated|i:1186278550;old_url|s:60:\"http://symtoms.org/forum/index.php?action=help;page=loginout\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('2a3856399bf670487ec6772518a47dd2',1186278455,'rand_code|s:32:\"e3f79ba0c2e55f2ceef72b09256a3788\";ban|a:5:{s:12:\"last_checked\";i:1186278455;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186278455;timeOnlineUpdated|i:1186278455;old_url|s:59:\"http://symtoms.org/forum/index.php?action=help;page=profile\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('ee48b6a7179ca39fee6e6767d225611e',1186278450,'rand_code|s:32:\"b488426755ced55f95628fba2b5c6d49\";ban|a:5:{s:12:\"last_checked\";i:1186278450;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186278450;timeOnlineUpdated|i:1186278450;old_url|s:66:\"http://symtoms.org/forum/index.php?action=profile;u=1;sa=showPosts\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('efe6d19bea984e5f7c704a78225c5115',1186277639,'rand_code|s:32:\"fa85aba2803e8437b6c963b78bda917b\";ban|a:5:{s:12:\"last_checked\";i:1186277639;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186277639;timeOnlineUpdated|i:1186277639;old_url|s:48:\"http://symtoms.org/forum/index.php?action=recent\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('1abd89440aa4c1b2f7d50956b140a4ad',1186276998,'rand_code|s:32:\"36a1e88cc96f0d299be4c0fb23b610c7\";ban|a:5:{s:12:\"last_checked\";i:1186276998;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186276998;timeOnlineUpdated|i:1186276998;old_url|s:47:\"http://symtoms.org/forum/index.php?action=login\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('738a58115fc96a8b5e53759fe8ffaddc',1186276982,'rand_code|s:32:\"4644c1acfee65eda769be29dc6865a48\";ban|a:5:{s:12:\"last_checked\";i:1186276982;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186276982;timeOnlineUpdated|i:1186276982;old_url|s:46:\"http://symtoms.org/forum/index.php?action=help\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('e0a2435ec220f733a4e1faa1681b90aa',1186276618,'rand_code|s:32:\"e3125e47a834c6572efe7b8137aaf3ac\";ban|a:5:{s:12:\"last_checked\";i:1186276618;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186276618;timeOnlineUpdated|i:1186276618;old_url|s:47:\"http://symtoms.org/forum/index.php?action=stats\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('dcb13cbb93b6f0bdbe11f8ed961a89d8',1186205177,'rand_code|s:32:\"d4df0c613d9e0b4b4ceeccf03a62afda\";ban|a:5:{s:12:\"last_checked\";i:1186205177;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186205177;timeOnlineUpdated|i:1186205177;old_url|s:78:\"http://symtoms.org/forum/index.php/index.php?action=helpadmin;help=time_format\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('5abd808879ac5322d50be86345cd909d',1186204081,'rand_code|s:32:\"28a6b6aec31141a50b9fa5e20ebe060f\";ban|a:5:{s:12:\"last_checked\";i:1186204081;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186204081;timeOnlineUpdated|i:1186204081;old_url|s:66:\"http://symtoms.org/forum/index.php?action=profile;u=1;sa=statPanel\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('c797b9590321e899d1b24d6309f0b766',1186203525,'rand_code|s:32:\"d71baef353da0896d1979299575137bf\";ban|a:5:{s:12:\"last_checked\";i:1186203525;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186203525;timeOnlineUpdated|i:1186203525;old_url|s:56:\"http://symtoms.org/forum/index.php?action=help;page=post\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('fa36c8623d476a07f1a47a7888140dce',1186203518,'rand_code|s:32:\"5bc582acad9dc1900c3b74f0711e3524\";ban|a:5:{s:12:\"last_checked\";i:1186203518;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186203518;timeOnlineUpdated|i:1186203518;old_url|s:63:\"http://symtoms.org/forum/index.php?action=help;page=registering\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('5600ac57d43597abcfd2cce28f3f3994',1186203093,'rand_code|s:32:\"67fd5c81dcfefb051a7e00903f0b13fc\";ban|a:5:{s:12:\"last_checked\";i:1186203093;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186203093;timeOnlineUpdated|i:1183253158;visual_verification_code|s:5:\"KWKWH\";old_url|s:145:\"http://symtoms.org/forum/index.php?PHPSESSID=5600ac57d43597abcfd2cce28f3f3994&action=verificationcode;rand=e4c95c5d97b3c81a9cbc9107c067eca8;sound\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('f4472eb338855d6cd0f64a2d6c9c2198',1186200886,'rand_code|s:32:\"012ddb960551a043c661e0835a994a9b\";ban|a:5:{s:12:\"last_checked\";i:1186200886;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186200886;timeOnlineUpdated|i:1186200886;old_url|s:61:\"http://symtoms.org/forum/index.php?action=help;page=searching\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('f9590eb02fd1f85be60b5641aaf407f2',1186209031,'rand_code|s:32:\"2ace6977410c1c1721111ca778ea7a7b\";ban|a:5:{s:12:\"last_checked\";i:1186209031;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186209031;timeOnlineUpdated|i:1186201714;visual_verification_code|s:5:\"ARVBY\";old_url|s:145:\"http://symtoms.org/forum/index.php?PHPSESSID=f9590eb02fd1f85be60b5641aaf407f2&action=verificationcode;rand=987ae89ee0922e28c0e7e02358d9e67b;sound\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('c4fdc25b0f5665802868ed854532172f',1186201898,'rand_code|s:32:\"cbec83326a66dc89c633857abe360cd1\";ban|a:5:{s:12:\"last_checked\";i:1186201898;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186201898;timeOnlineUpdated|i:1186201898;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('a622ddc6963d10ce4bfabfe3db13c507',1186202442,'rand_code|s:32:\"d92b4e1fbeeb982f32587d9d91aaac39\";ban|a:5:{s:12:\"last_checked\";i:1186202442;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186202442;timeOnlineUpdated|i:1186202442;last_read_topic|i:1;old_url|s:47:\"http://symtoms.org/forum/index.php?topic=1.msg1\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('f3df93768a478f482e1f7d9af16afbe8',1186202874,'rand_code|s:32:\"ca3523aeeaeb3d498b0d2b71cd4b4b7c\";ban|a:5:{s:12:\"last_checked\";i:1186202874;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186202874;timeOnlineUpdated|i:1186202874;old_url|s:50:\"http://symtoms.org/forum/index.php?action=reminder\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('ad7c1757b15f666ca9e1c3ade711b836',1186583597,'rand_code|s:32:\"2c9a78357af8ebf249aa6eae7e19b3d4\";ban|a:5:{s:12:\"last_checked\";i:1186583595;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"70.83.155.37\";s:3:\"ip2\";s:12:\"70.83.155.37\";s:5:\"email\";s:0:\"\";}log_time|i:1186583597;timeOnlineUpdated|i:1186583583;old_url|s:34:\"http://symtoms.org/forum/index.php\";USER_AGENT|s:90:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6\";'),('1f610d6f568ef169ede5bbec49a28841',1186590127,'rand_code|s:32:\"b24066666c5ece2d367269ba65c38d05\";ban|a:5:{s:12:\"last_checked\";i:1186590125;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590127;timeOnlineUpdated|i:1186590127;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('0bf140846313be9abbdb3bb48e2df7ab',1186590129,'rand_code|s:32:\"9312d7ccb4249b10d6829bf36df24280\";ban|a:5:{s:12:\"last_checked\";i:1186590129;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590129;timeOnlineUpdated|i:1186590129;old_url|s:54:\"http://symtoms.org/forum/index.php?action=help;page=pm\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('5632bcbee0e3472f6af271fa43c9d9f2',1186590241,'rand_code|s:32:\"521fa12f38fbe69e3b633e7f73f58144\";ban|a:5:{s:12:\"last_checked\";i:1186590231;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590240;timeOnlineUpdated|i:1186590240;old_url|s:57:\"http://symtoms.org/forum/index.php?action=help;page=index\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('8d7a46adc0848c6899d4a62333949c4e',1186590246,'rand_code|s:32:\"1058ae7493c3c5b6f504b08624736330\";ban|a:5:{s:12:\"last_checked\";i:1186590246;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590246;timeOnlineUpdated|i:1186590246;last_read_topic|i:1;old_url|s:47:\"http://symtoms.org/forum/index.php?topic=1.msg1\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('a54f1ca31d1da298596f23509670b505',1186590254,'rand_code|s:32:\"3d184bf9c4ad82b55e02690966cb4aa4\";ban|a:5:{s:12:\"last_checked\";i:1186590252;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590254;timeOnlineUpdated|i:1186590254;last_read_topic|i:1;old_url|s:44:\"http://symtoms.org/forum/index.php?topic=1.0\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('9a5e9d9099f8614da67ecc5fd5503bda',1186590257,'rand_code|s:32:\"c9c5b2a125760821e7669b500e5aeca8\";ban|a:5:{s:12:\"last_checked\";i:1186590256;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590256;timeOnlineUpdated|i:1186590256;old_url|s:50:\"http://symtoms.org/forum/index.php?action=reminder\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('a00272146a0617e62bd23229050b0a91',1186590257,'rand_code|s:32:\"c6d7f84e5a437ca7b6ca2ca21c63e75b\";ban|a:5:{s:12:\"last_checked\";i:1186590257;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590257;timeOnlineUpdated|i:1186590257;login_url|s:58:\"http://symtoms.org/forum/index.php?action=unread;board=1.0\";old_url|s:58:\"http://symtoms.org/forum/index.php?action=unread;board=1.0\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('ec0f94409a41ecd869742e3d9a0a4f0e',1186590260,'rand_code|s:32:\"e029d9788ef075cb099fdb94bcf0f7d8\";ban|a:5:{s:12:\"last_checked\";i:1186590260;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186590260;timeOnlineUpdated|i:1186590260;old_url|s:53:\"http://symtoms.org/forum/index.php?action=profile;u=1\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('05270d2c7e0a0c40f4084a4351bdb53c',1186598274,'rand_code|s:32:\"0694ad965f3a3a273edf0355bb8916ee\";ban|a:5:{s:12:\"last_checked\";i:1186598273;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186598274;timeOnlineUpdated|i:1186598274;old_url|s:59:\"http://symtoms.org/forum/index.php?action=help;page=profile\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('390207fb1dd95680caa73c8a90453eee',1186628429,'rand_code|s:32:\"9e4d74518ece04a99c5efbe53c8a710d\";ban|a:5:{s:12:\"last_checked\";i:1186628429;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:14:\"65.222.176.124\";s:3:\"ip2\";s:14:\"65.222.176.124\";s:5:\"email\";s:0:\"\";}log_time|i:1186628429;timeOnlineUpdated|i:1186628429;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:46:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows XP)\";'),('450ef45f6c0cd5fd648b10022d4dc9f6',1186634420,'rand_code|s:32:\"0a6908a2f3342946d2eba781dc4761bd\";ban|a:5:{s:12:\"last_checked\";i:1186634419;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186634419;timeOnlineUpdated|i:1186634419;old_url|s:63:\"http://symtoms.org/forum/index.php?action=help;page=registering\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('a2d1bebb8682131140aacde07c842814',1186672060,'rand_code|s:32:\"f8791754cc84035830af97b3c5e6e38e\";ban|a:5:{s:12:\"last_checked\";i:1186672058;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"70.83.155.37\";s:3:\"ip2\";s:12:\"70.83.155.37\";s:5:\"email\";s:0:\"\";}log_time|i:1186672060;timeOnlineUpdated|i:1186672060;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:90:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6\";'),('99650cb1150c1384b6c50fd9fcfb09c7',1186683833,'rand_code|s:32:\"6bb82cd00e8c578ff638b111b63b1b54\";ban|a:5:{s:12:\"last_checked\";i:1186683831;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186683833;timeOnlineUpdated|i:1186683833;old_url|s:66:\"http://symtoms.org/forum/index.php?action=profile;u=1;sa=statPanel\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('248d6f4b43ccc7bbf16d5c3fd6c701ca',1186683844,'rand_code|s:32:\"63af78cc37a8ba1ac0ba107030fbed8c\";ban|a:5:{s:12:\"last_checked\";i:1186683842;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}log_time|i:1186683844;timeOnlineUpdated|i:1186683844;last_read_topic|i:1;old_url|s:59:\"http://symtoms.org/forum/index.php?topic=1.0;prev_next=prev\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('6c392ad2faf1a928371b1a699426f963',1186703524,'rand_code|s:32:\"ab82c837e22b015427e011072f3f0a4a\";ban|a:5:{s:12:\"last_checked\";i:1186703524;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:11:\"74.6.72.249\";s:3:\"ip2\";s:11:\"74.6.72.249\";s:5:\"email\";s:0:\"\";}log_time|i:1186703524;timeOnlineUpdated|i:1186703524;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:83:\"Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)\";'),('47fe9996760c4bd0e05ed652b6a70b9d',1186728342,'rand_code|s:32:\"66b24e7e2ce38e79a332ca385ad1e59d\";ban|a:5:{s:12:\"last_checked\";i:1186728342;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.55.212.16\";s:3:\"ip2\";s:12:\"65.55.212.16\";s:5:\"email\";s:0:\"\";}old_url|s:55:\"http://symtoms.org/forum/index.php?type=rss;action=.xml\";USER_AGENT|s:52:\"msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)\";'),('ec511d28d69bd480d4793ebc780c9ae6',1186812324,'rand_code|s:32:\"fa3962cccf730b643861dea75dfe9cd8\";ban|a:5:{s:12:\"last_checked\";i:1186812324;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:10:\"74.6.70.59\";s:3:\"ip2\";s:10:\"74.6.70.59\";s:5:\"email\";s:0:\"\";}log_time|i:1186812324;timeOnlineUpdated|i:1186812324;old_url|s:48:\"http://symtoms.org/forum/index.php?action=search\";USER_AGENT|s:83:\"Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)\";'),('7a89b1b4010fd2c170d9d3084d3a0f36',1186844193,'rand_code|s:32:\"a41f8acb4868fc1a81c5623bdba4fa31\";ban|a:5:{s:12:\"last_checked\";i:1186844193;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:10:\"74.6.70.84\";s:3:\"ip2\";s:10:\"74.6.70.84\";s:5:\"email\";s:0:\"\";}log_time|i:1186844193;timeOnlineUpdated|i:1186844193;old_url|s:50:\"http://symtoms.org/forum/index.php?action=reminder\";USER_AGENT|s:83:\"Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)\";'),('1bc2d58fb7639455ca4d1bcbc6c34dc6',1186863942,'rand_code|s:32:\"daaabe2b44e89a1983aee1defe4de737\";ban|a:5:{s:12:\"last_checked\";i:1186863942;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"65.54.188.13\";s:3:\"ip2\";s:12:\"65.54.188.13\";s:5:\"email\";s:0:\"\";}log_time|i:1186863942;timeOnlineUpdated|i:1186863942;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:46:\"msnbot/1.0 (+http://search.msn.com/msnbot.htm)\";'),('4c3bde7f2fbfb1d8d461bb6a0cc9fe49',1186909646,'rand_code|s:32:\"ca0a099e5059909ea2dee0138e2fea05\";ban|a:5:{s:12:\"last_checked\";i:1186909646;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1186909646;timeOnlineUpdated|i:1186909646;last_read_topic|i:1;old_url|s:59:\"http://symtoms.org/forum/index.php?topic=1.0;prev_next=next\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('f5607dce24230ad09dfaf4918d98b792',1187006912,'rand_code|s:32:\"a2139f9b0e99f16a3d5fddc41fa115e5\";ban|a:5:{s:12:\"last_checked\";i:1187006910;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:10:\"74.6.74.31\";s:3:\"ip2\";s:10:\"74.6.74.31\";s:5:\"email\";s:0:\"\";}log_time|i:1187006911;timeOnlineUpdated|i:1187006911;old_url|s:34:\"http://symtoms.org/forum/index.php\";USER_AGENT|s:83:\"Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)\";'),('fb5bda3c36ef6d8ab14fd00c4bcbf009',1187077168,'rand_code|s:32:\"bbec4839367bafdd59018e65864e781f\";ban|a:5:{s:12:\"last_checked\";i:1187077167;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:11:\"74.6.71.189\";s:3:\"ip2\";s:11:\"74.6.71.189\";s:5:\"email\";s:0:\"\";}log_time|i:1187077168;timeOnlineUpdated|i:1187077168;old_url|s:44:\"http://symtoms.org/forum/index.php?board=1.0\";USER_AGENT|s:83:\"Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)\";'),('ee90ab15b4e03091a85f76e09c095fde',1187188502,'rand_code|s:32:\"38f4086d11579eff3bdb6dd99bb4e789\";ban|a:5:{s:12:\"last_checked\";i:1187188496;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"66.249.65.230\";s:3:\"ip2\";s:13:\"66.249.65.230\";s:5:\"email\";s:0:\"\";}log_time|i:1187188502;timeOnlineUpdated|i:1187188502;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";'),('2ee774e00cdb3438c4a678dedb0d433c',1187297416,'rand_code|s:32:\"4d9252a42a7b4a6e255f02c69ec6f32c\";ban|a:5:{s:12:\"last_checked\";i:1187297395;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"74.124.192.3\";s:3:\"ip2\";s:12:\"74.124.192.3\";s:5:\"email\";s:0:\"\";}log_time|i:1187297416;timeOnlineUpdated|i:1187297416;old_url|s:47:\"http://symtoms.orghttp://www.symtoms.org/forum/\";USER_AGENT|s:30:\"i0rrn0bya uv0xbqgxejdkmjnhxgro\";'),('263bf4dc0caa9247a4fbcc06ecfae7d5',1187297536,'rand_code|s:32:\"f669fee5a4f873bb59e2e8ce9ba5f091\";ban|a:5:{s:12:\"last_checked\";i:1187297535;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"74.124.192.3\";s:3:\"ip2\";s:12:\"74.124.192.3\";s:5:\"email\";s:0:\"\";}log_time|i:1187297536;timeOnlineUpdated|i:1187297536;old_url|s:64:\"http://symtoms.orghttp://symtoms.org/forum/index.php?action=help\";USER_AGENT|s:32:\"nivpmposkmpdaidksvuadduvtig8giad\";'),('a614536b81f774d52c13d5f628fb03ea',1187314857,'rand_code|s:32:\"49151f3883fffc41029f0b4862946b37\";ban|a:5:{s:12:\"last_checked\";i:1187314854;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"83.222.23.202\";s:3:\"ip2\";s:13:\"83.222.23.202\";s:5:\"email\";s:0:\"\";}log_time|i:1187314857;timeOnlineUpdated|i:1187314844;old_url|s:96:\"http://symtoms.org/forum/index.php?PHPSESSID=a614536b81f774d52c13d5f628fb03ea&action=search2\";USER_AGENT|s:51:\"Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)\";search_cache|a:3:{s:9:\"ID_SEARCH\";s:1:\"4\";s:11:\"num_results\";i:0;s:6:\"params\";s:152:\"YWR2YW5jZWR8J3wwfCJ8YnJkfCd8MXwifHNob3dfY29tcGxldGV8J3x8InxzdWJqZWN0X29ubHl8J3x8Inxzb3J0X2RpcnwnfGRlc2N8Inxzb3J0fCd8cmVsZXZhbmNlfCJ8c2VhcmNofCd8bG81ODBs\";}'),('bd7c97ca0fcd18a632b4bcfd2624c9fa',1187367827,'rand_code|s:32:\"5c341acd6eae497ac6fb86ae21b04b72\";ban|a:5:{s:12:\"last_checked\";i:1187367826;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:12:\"70.56.60.231\";s:3:\"ip2\";s:12:\"70.56.60.231\";s:5:\"email\";s:0:\"\";}log_time|i:1187367827;timeOnlineUpdated|i:1187367624;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:51:\"Mozilla/4.0 (compatible ; MSIE 6.0; Windows NT 5.1)\";'),('76a396154831427667b7be2749401085',1187443515,'rand_code|s:32:\"288520939ec4cf389fbca3e1c2052009\";ban|a:5:{s:12:\"last_checked\";i:1187443513;s:9:\"ID_MEMBER\";i:0;s:2:\"ip\";s:13:\"24.37.120.244\";s:3:\"ip2\";s:13:\"24.37.120.244\";s:5:\"email\";s:0:\"\";}log_time|i:1187443515;timeOnlineUpdated|i:1187443515;old_url|s:25:\"http://symtoms.org/forum/\";USER_AGENT|s:90:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6\";'); /*!40000 ALTER TABLE `smf_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_settings` -- DROP TABLE IF EXISTS `smf_settings`; CREATE TABLE `smf_settings` ( `variable` tinytext NOT NULL, `value` text NOT NULL, PRIMARY KEY (`variable`(30)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_settings` -- LOCK TABLES `smf_settings` WRITE; /*!40000 ALTER TABLE `smf_settings` DISABLE KEYS */; INSERT INTO `smf_settings` VALUES ('smfVersion','1.1.1'),('news','SMF - Just Installed!'),('compactTopicPagesContiguous','5'),('compactTopicPagesEnable','1'),('enableStickyTopics','1'),('todayMod','1'),('karmaMode','0'),('karmaTimeRestrictAdmins','1'),('enablePreviousNext','1'),('pollMode','1'),('enableVBStyleLogin','1'),('enableCompressedOutput','1'),('karmaWaitTime','1'),('karmaMinPosts','0'),('karmaLabel','Karma:'),('karmaSmiteLabel','[smite]'),('karmaApplaudLabel','[applaud]'),('attachmentSizeLimit','128'),('attachmentPostLimit','192'),('attachmentNumPerPostLimit','4'),('attachmentDirSizeLimit','10240'),('attachmentUploadDir','/home/symtoms/public_html/forum/attachments'),('attachmentExtensions','doc,gif,jpg,mpg,pdf,png,txt,zip'),('attachmentCheckExtensions','0'),('attachmentShowImages','1'),('attachmentEnable','1'),('attachmentEncryptFilenames','1'),('attachmentThumbnails','1'),('attachmentThumbWidth','150'),('attachmentThumbHeight','150'),('censorIgnoreCase','1'),('mostOnline','2'),('mostOnlineToday','1'),('mostDate','1185934954'),('allow_disableAnnounce','1'),('trackStats','1'),('userLanguage','1'),('titlesEnable','1'),('topicSummaryPosts','15'),('enableErrorLogging','1'),('max_image_width','0'),('max_image_height','0'),('onlineEnable','0'),('cal_holidaycolor','000080'),('cal_bdaycolor','920AC4'),('cal_eventcolor','078907'),('cal_enabled','0'),('cal_maxyear','2010'),('cal_minyear','2004'),('cal_daysaslink','0'),('cal_defaultboard',''),('cal_showeventsonindex','0'),('cal_showbdaysonindex','0'),('cal_showholidaysonindex','0'),('cal_showeventsoncalendar','1'),('cal_showbdaysoncalendar','1'),('cal_showholidaysoncalendar','1'),('cal_showweeknum','0'),('cal_maxspan','7'),('smtp_host',''),('smtp_port','25'),('smtp_username',''),('smtp_password',''),('mail_type','0'),('timeLoadPageEnable','0'),('totalTopics','1'),('totalMessages','1'),('simpleSearch','0'),('censor_vulgar',''),('censor_proper',''),('enablePostHTML','0'),('theme_allow','1'),('theme_default','1'),('theme_guests','1'),('enableEmbeddedFlash','0'),('xmlnews_enable','1'),('xmlnews_maxlen','255'),('hotTopicPosts','15'),('hotTopicVeryPosts','25'),('registration_method','0'),('send_validation_onChange','0'),('send_welcomeEmail','1'),('allow_editDisplayName','1'),('allow_hideOnline','1'),('allow_hideEmail','1'),('guest_hideContacts','0'),('spamWaitTime','5'),('pm_spam_settings','10,5,20'),('reserveWord','0'),('reserveCase','1'),('reserveUser','1'),('reserveName','1'),('reserveNames','Admin\nWebmaster\nGuest\nroot'),('autoLinkUrls','1'),('banLastUpdated','0'),('smileys_dir','/home/symtoms/public_html/forum/Smileys'),('smileys_url','http://symtoms.org/forum/Smileys'),('avatar_directory','/home/symtoms/public_html/forum/avatars'),('avatar_url','http://symtoms.org/forum/avatars'),('avatar_max_height_external','65'),('avatar_max_width_external','65'),('avatar_action_too_large','option_html_resize'),('avatar_max_height_upload','65'),('avatar_max_width_upload','65'),('avatar_resize_upload','1'),('avatar_download_png','1'),('failed_login_threshold','3'),('oldTopicDays','120'),('edit_wait_time','90'),('edit_disable_time','0'),('autoFixDatabase','1'),('allow_guestAccess','1'),('time_format','%B %d, %Y, %I:%M:%S %p'),('number_format','1234.00'),('enableBBC','1'),('max_messageLength','20000'),('max_signatureLength','300'),('autoOptDatabase','7'),('autoOptMaxOnline','0'),('autoOptLastOpt','1187188496'),('defaultMaxMessages','15'),('defaultMaxTopics','20'),('defaultMaxMembers','30'),('enableParticipation','1'),('recycle_enable','0'),('recycle_board','0'),('maxMsgID','1'),('enableAllMessages','0'),('fixLongWords','0'),('knownThemes','1,2,3'),('who_enabled','1'),('time_offset','0'),('cookieTime','60'),('lastActive','15'),('smiley_sets_known','default,classic'),('smiley_sets_names','Default\nClassic'),('smiley_sets_default','default'),('cal_days_for_index','7'),('requireAgreement','1'),('unapprovedMembers','0'),('default_personalText',''),('package_make_backups','1'),('databaseSession_enable','1'),('databaseSession_loose','1'),('databaseSession_lifetime','2880'),('search_cache_size','50'),('search_results_per_page','30'),('search_weight_frequency','30'),('search_weight_age','25'),('search_weight_length','20'),('search_weight_subject','15'),('search_weight_first_message','10'),('search_max_results','1200'),('permission_enable_deny','0'),('permission_enable_postgroups','0'),('permission_enable_by_board','0'),('localCookies','1'),('memberlist_updated','1179924909'),('latestMember','1'),('totalMembers','1'),('latestRealName',''),('mostOnlineUpdated','2007-08-18'),('search_pointer','4'); /*!40000 ALTER TABLE `smf_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_smileys` -- DROP TABLE IF EXISTS `smf_smileys`; CREATE TABLE `smf_smileys` ( `ID_SMILEY` smallint(5) unsigned NOT NULL auto_increment, `code` varchar(30) NOT NULL default '', `filename` varchar(48) NOT NULL default '', `description` varchar(80) NOT NULL default '', `smileyRow` tinyint(4) unsigned NOT NULL default '0', `smileyOrder` smallint(5) unsigned NOT NULL default '0', `hidden` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`ID_SMILEY`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_smileys` -- LOCK TABLES `smf_smileys` WRITE; /*!40000 ALTER TABLE `smf_smileys` DISABLE KEYS */; INSERT INTO `smf_smileys` VALUES (1,':)','smiley.gif','Smiley',0,0,0),(2,';)','wink.gif','Wink',0,1,0),(3,':D','cheesy.gif','Cheesy',0,2,0),(4,';D','grin.gif','Grin',0,3,0),(5,'>:(','angry.gif','Angry',0,4,0),(6,':(','sad.gif','Sad',0,5,0),(7,':o','shocked.gif','Shocked',0,6,0),(8,'8)','cool.gif','Cool',0,7,0),(9,'???','huh.gif','Huh?',0,8,0),(10,'::)','rolleyes.gif','Roll Eyes',0,9,0),(11,':P','tongue.gif','Tongue',0,10,0),(12,':-[','embarrassed.gif','Embarrassed',0,11,0),(13,':-X','lipsrsealed.gif','Lips Sealed',0,12,0),(14,':-\\','undecided.gif','Undecided',0,13,0),(15,':-*','kiss.gif','Kiss',0,14,0),(16,':\'(','cry.gif','Cry',0,15,0),(17,'>:D','evil.gif','Evil',0,16,1),(18,'^-^','azn.gif','Azn',0,17,1),(19,'O0','afro.gif','Afro',0,18,1); /*!40000 ALTER TABLE `smf_smileys` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_themes` -- DROP TABLE IF EXISTS `smf_themes`; CREATE TABLE `smf_themes` ( `ID_MEMBER` mediumint(8) NOT NULL default '0', `ID_THEME` tinyint(4) unsigned NOT NULL default '1', `variable` tinytext NOT NULL, `value` text NOT NULL, PRIMARY KEY (`ID_THEME`,`ID_MEMBER`,`variable`(30)), KEY `ID_MEMBER` (`ID_MEMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_themes` -- LOCK TABLES `smf_themes` WRITE; /*!40000 ALTER TABLE `smf_themes` DISABLE KEYS */; INSERT INTO `smf_themes` VALUES (0,1,'name','SMF Default Theme - Core'),(0,1,'theme_url','http://symtoms.org/forum/Themes/default'),(0,1,'images_url','http://symtoms.org/forum/Themes/default/images'),(0,1,'theme_dir','/home/symtoms/public_html/forum/Themes/default'),(0,1,'show_bbc','1'),(0,1,'show_latest_member','1'),(0,1,'show_modify','1'),(0,1,'show_user_images','1'),(0,1,'show_blurb','1'),(0,1,'show_gender','0'),(0,1,'show_newsfader','0'),(0,1,'number_recent_posts','0'),(0,1,'show_member_bar','1'),(0,1,'linktree_link','1'),(0,1,'show_profile_buttons','1'),(0,1,'show_mark_read','1'),(0,1,'show_sp1_info','1'),(0,1,'linktree_inline','0'),(0,1,'show_board_desc','1'),(0,1,'newsfader_time','5000'),(0,1,'allow_no_censored','0'),(0,1,'additional_options_collapsable','1'),(0,1,'use_image_buttons','1'),(0,1,'enable_news','1'),(0,2,'name','Classic YaBB SE Theme'),(0,2,'theme_url','http://symtoms.org/forum/Themes/classic'),(0,2,'images_url','http://symtoms.org/forum/Themes/classic/images'),(0,2,'theme_dir','/home/symtoms/public_html/forum/Themes/classic'),(0,3,'name','Babylon Theme'),(0,3,'theme_url','http://symtoms.org/forum/Themes/babylon'),(0,3,'images_url','http://symtoms.org/forum/Themes/babylon/images'),(0,3,'theme_dir','/home/symtoms/public_html/forum/Themes/babylon'); /*!40000 ALTER TABLE `smf_themes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smf_topics` -- DROP TABLE IF EXISTS `smf_topics`; CREATE TABLE `smf_topics` ( `ID_TOPIC` mediumint(8) unsigned NOT NULL auto_increment, `isSticky` tinyint(4) NOT NULL default '0', `ID_BOARD` smallint(5) unsigned NOT NULL default '0', `ID_FIRST_MSG` int(10) unsigned NOT NULL default '0', `ID_LAST_MSG` int(10) unsigned NOT NULL default '0', `ID_MEMBER_STARTED` mediumint(8) unsigned NOT NULL default '0', `ID_MEMBER_UPDATED` mediumint(8) unsigned NOT NULL default '0', `ID_POLL` mediumint(8) unsigned NOT NULL default '0', `numReplies` int(10) unsigned NOT NULL default '0', `numViews` int(10) unsigned NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', PRIMARY KEY (`ID_TOPIC`), UNIQUE KEY `lastMessage` (`ID_LAST_MSG`,`ID_BOARD`), UNIQUE KEY `firstMessage` (`ID_FIRST_MSG`,`ID_BOARD`), UNIQUE KEY `poll` (`ID_POLL`,`ID_TOPIC`), KEY `isSticky` (`isSticky`), KEY `ID_BOARD` (`ID_BOARD`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `smf_topics` -- LOCK TABLES `smf_topics` WRITE; /*!40000 ALTER TABLE `smf_topics` DISABLE KEYS */; INSERT INTO `smf_topics` VALUES (1,0,1,1,1,0,0,0,0,25,0); /*!40000 ALTER TABLE `smf_topics` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; -- Dump completed on 2007-08-18 13:25:56