-- MariaDB dump 10.19-11.4.0-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: thwboard_webboard -- ------------------------------------------------------ -- Server version 11.4.0-MariaDB /*!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 utf8mb4 */; /*!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 `webboard_adminlog` -- DROP TABLE IF EXISTS `webboard_adminlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_adminlog` ( `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, `logtype` varchar(12) NOT NULL DEFAULT '', `logtime` int(10) unsigned NOT NULL DEFAULT 0, `loguser` varchar(64) NOT NULL DEFAULT '0', `logip` varchar(16) NOT NULL DEFAULT '', `logscript` varchar(32) NOT NULL DEFAULT '', `logaction` varchar(32) NOT NULL DEFAULT '', `lognotes` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`logid`) ) ENGINE=MyISAM AUTO_INCREMENT=218 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_adminlog` -- LOCK TABLES `webboard_adminlog` WRITE; /*!40000 ALTER TABLE `webboard_adminlog` DISABLE KEYS */; INSERT INTO `webboard_adminlog` VALUES (1,'LOG_ADMIN',1149513206,'admin','','','',''), (2,'LOG_ADMIN',1149513328,'admin','','','EditSettings',''), (3,'LOG_ADMIN',1149513560,'admin','','','WriteSettings',''), (4,'LOG_ADMIN',1149513565,'admin','','','',''), (5,'LOG_ADMIN',1149513588,'admin','','','RenameCategory',''), (6,'LOG_ADMIN',1149513593,'admin','','','SetCategoryName',''), (7,'LOG_ADMIN',1149513596,'admin','','','',''), (8,'LOG_ADMIN',1149513599,'admin','','','edit',''), (9,'LOG_ADMIN',1149513643,'admin','','','edit',''), (10,'LOG_ADMIN',1149513646,'admin','','','',''), (11,'LOG_ADMIN',1149513654,'admin','','','newboard',''), (12,'LOG_ADMIN',1149513658,'admin','','','',''), (13,'LOG_ADMIN',1149513666,'admin','','','addcat',''), (14,'LOG_ADMIN',1149513671,'admin','','','addcat',''), (15,'LOG_ADMIN',1149513676,'admin','','','newboard',''), (16,'LOG_ADMIN',1149513711,'admin','','','newboard',''), (17,'LOG_ADMIN',1149513714,'admin','','','',''), (18,'LOG_ADMIN',1149513735,'admin','','','edit',''), (19,'LOG_ADMIN',1149513737,'admin','','','edit',''), (20,'LOG_ADMIN',1149513739,'admin','','','',''), (21,'LOG_ADMIN',1149513743,'admin','','','grouppermtable',''), (22,'LOG_ADMIN',1149513747,'admin','','','',''), (23,'LOG_ADMIN',1149513749,'admin','','','',''), (24,'LOG_ADMIN',1149513755,'admin','','','ListStyles',''), (25,'LOG_ADMIN',1149513851,'admin','','','ImportStyle',''), (26,'LOG_ADMIN',1149513856,'admin','','','ListStyles',''), (27,'LOG_ADMIN',1149513859,'admin','','','NewStyle',''), (28,'LOG_ADMIN',1149514007,'admin','','','InsertStyle',''), (29,'LOG_ADMIN',1149514014,'admin','','','',''), (30,'LOG_ADMIN',1149514017,'admin','','','edit',''), (31,'LOG_ADMIN',1149514023,'admin','','','edit',''), (32,'LOG_ADMIN',1149514038,'admin','','','NewStyle',''), (33,'LOG_ADMIN',1149514250,'admin','','','InsertStyle',''), (34,'LOG_ADMIN',1149514254,'admin','','','',''), (35,'LOG_ADMIN',1149514256,'admin','','','edit',''), (36,'LOG_ADMIN',1149514260,'admin','','','edit',''), (37,'LOG_ADMIN',1149514353,'admin','','','',''), (38,'LOG_ADMIN',1149514358,'admin','','','ListStyles',''), (39,'LOG_ADMIN',1149514359,'admin','','','EditStyle',''), (40,'LOG_ADMIN',1149514370,'admin','','','UpdateStyle',''), (41,'LOG_ADMIN',1149514375,'admin','','','ListStyles',''), (42,'LOG_ADMIN',1149514617,'admin','','','EditStyle',''), (43,'LOG_ADMIN',1149514621,'admin','','','',''), (44,'LOG_ADMIN',1149514623,'admin','','','RenameCategory',''), (45,'LOG_ADMIN',1149514625,'admin','','','',''), (46,'LOG_ADMIN',1149514627,'admin','','','edit',''), (47,'LOG_ADMIN',1149514634,'admin','','','edit',''), (48,'LOG_ADMIN',1149514636,'admin','','','',''), (49,'LOG_ADMIN',1149514637,'admin','','','edit',''), (50,'LOG_ADMIN',1149514641,'admin','','','edit',''), (51,'LOG_ADMIN',1149514645,'admin','','','',''), (52,'LOG_ADMIN',1149514648,'admin','','','edit',''), (53,'LOG_ADMIN',1149514651,'admin','','','edit',''), (54,'LOG_ADMIN',1185947981,'admin','62.178.39.180','index.php','',''), (55,'LOG_ADMIN',1185947999,'admin','62.178.39.180','boards.php','',''), (56,'LOG_MOD',1185948018,'admin','62.178.39.180','threadops.php','deleted','thread id: 5'), (57,'LOG_MOD',1185948027,'admin','62.178.39.180','threadops.php','deleted','thread id: 4'), (58,'LOG_MOD',1185948035,'admin','62.178.39.180','threadops.php','deleted','thread id: 3'), (59,'LOG_MOD',1185948041,'admin','62.178.39.180','threadops.php','deleted','thread id: 2'), (60,'LOG_MOD',1185948047,'admin','62.178.39.180','threadops.php','deleted','thread id: 1'), (61,'LOG_ADMIN',1187588127,'admin','62.178.39.180','index.php','',''), (62,'LOG_ADMIN',1187588160,'admin','62.178.39.180','index.php','',''), (63,'LOG_MOD',1187588173,'admin','62.178.39.180','threadops.php','deleted','thread id: 23'), (64,'LOG_MOD',1187588180,'admin','62.178.39.180','threadops.php','deleted','thread id: 22'), (65,'LOG_MOD',1187588188,'admin','62.178.39.180','threadops.php','deleted','thread id: 21'), (66,'LOG_MOD',1187588195,'admin','62.178.39.180','threadops.php','deleted','thread id: 6'), (67,'LOG_MOD',1187588202,'admin','62.178.39.180','threadops.php','deleted','thread id: 7'), (68,'LOG_MOD',1187588208,'admin','62.178.39.180','threadops.php','deleted','thread id: 8'), (69,'LOG_MOD',1187588216,'admin','62.178.39.180','threadops.php','deleted','thread id: 9'), (70,'LOG_MOD',1187588222,'admin','62.178.39.180','threadops.php','deleted','thread id: 11'), (71,'LOG_MOD',1187588228,'admin','62.178.39.180','threadops.php','deleted','thread id: 12'), (72,'LOG_MOD',1187588240,'admin','62.178.39.180','threadops.php','deleted','thread id: 13'), (73,'LOG_MOD',1187588246,'admin','62.178.39.180','threadops.php','deleted','thread id: 15'), (74,'LOG_MOD',1187588305,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (75,'LOG_MOD',1187588314,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (76,'LOG_MOD',1187588324,'admin','62.178.39.180','threadops.php','deleted','thread id: 20'), (77,'LOG_MOD',1187588331,'admin','62.178.39.180','threadops.php','deleted','thread id: 19'), (78,'LOG_MOD',1187588340,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (79,'LOG_MOD',1187588345,'admin','62.178.39.180','threadops.php','deleted','thread id: 17'), (80,'LOG_MOD',1187588358,'admin','62.178.39.180','threadops.php','deleted','thread id: 16'), (81,'LOG_MOD',1187588365,'admin','62.178.39.180','threadops.php','deleted','thread id: 14'), (82,'LOG_MOD',1187588372,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (83,'LOG_MOD',1187588442,'admin','62.178.39.180','threadops.php','deleted','thread id: 10'), (84,'LOG_MOD',1187588447,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (85,'LOG_MOD',1187588475,'admin','62.178.39.180','threadops.php','deleted','thread id: 18'), (86,'LOG_ADMIN',1187588537,'admin','62.178.39.180','index.php','',''), (87,'LOG_ADMIN',1187588544,'admin','62.178.39.180','useredit.php','DeleteUser',''), (88,'LOG_ADMIN',1187588551,'admin','62.178.39.180','useredit.php','Filter',''), (89,'LOG_ADMIN',1187588555,'admin','62.178.39.180','useredit.php','ListUsers',''), (90,'LOG_ADMIN',1187588562,'admin','62.178.39.180','useredit.php','DeleteUser',''), (91,'LOG_ADMIN',1187588566,'admin','62.178.39.180','useredit.php','Filter',''), (92,'LOG_ADMIN',1187588567,'admin','62.178.39.180','useredit.php','ListUsers',''), (93,'LOG_ADMIN',1187588631,'admin','62.178.39.180','useredit.php','',''), (94,'LOG_ADMIN',1187588635,'admin','62.178.39.180','useredit.php','Filter',''), (95,'LOG_ADMIN',1187588637,'admin','62.178.39.180','useredit.php','ListUsers',''), (96,'LOG_ADMIN',1187588646,'admin','62.178.39.180','boards.php','',''), (97,'LOG_ADMIN',1187588651,'admin','62.178.39.180','boards.php','RenameCategory',''), (98,'LOG_ADMIN',1187588657,'admin','62.178.39.180','groups.php','grouppermtable',''), (99,'LOG_MOD',1187887246,'admin','193.80.57.6','threadops.php','deleted','thread id: 27'), (100,'LOG_MOD',1187887252,'admin','193.80.57.6','threadops.php','deleted','thread id: 26'), (101,'LOG_MOD',1187887258,'admin','193.80.57.6','threadops.php','deleted','thread id: 25'), (102,'LOG_MOD',1187887262,'admin','193.80.57.6','threadops.php','deleted','thread id: 24'), (103,'LOG_ADMIN',1187887272,'admin','193.80.57.6','index.php','',''), (104,'LOG_ADMIN',1187887283,'admin','193.80.57.6','boards.php','',''), (105,'LOG_ADMIN',1187887290,'admin','193.80.57.6','groups.php','grouppermtable',''), (106,'LOG_ADMIN',1187887294,'admin','193.80.57.6','boards.php','RenameCategory',''), (107,'LOG_ADMIN',1187887297,'admin','193.80.57.6','boards.php','edit',''), (108,'LOG_ADMIN',1187887308,'admin','193.80.57.6','boards.php','edit',''), (109,'LOG_ADMIN',1187887310,'admin','193.80.57.6','boards.php','',''), (110,'LOG_ADMIN',1187887328,'admin','193.80.57.6','boards.php','edit',''), (111,'LOG_ADMIN',1187887332,'admin','193.80.57.6','boards.php','edit',''), (112,'LOG_ADMIN',1187887335,'admin','193.80.57.6','boards.php','',''), (113,'LOG_ADMIN',1187887342,'admin','193.80.57.6','groups.php','grouppermtable',''), (114,'LOG_ADMIN',1187887352,'admin','193.80.57.6','index.php','',''), (115,'LOG_ADMIN',1194070558,'admin','62.178.39.180','index.php','',''), (116,'LOG_ADMIN',1194070714,'admin','62.178.39.180','boards.php','',''), (117,'LOG_ADMIN',1194070719,'admin','62.178.39.180','boards.php','RenameCategory',''), (118,'LOG_ADMIN',1194070725,'admin','62.178.39.180','boards.php','edit',''), (119,'LOG_ADMIN',1194070748,'admin','62.178.39.180','boards.php','',''), (120,'LOG_ADMIN',1194070750,'admin','62.178.39.180','groups.php','grouppermtable',''), (121,'LOG_ADMIN',1194070768,'admin','62.178.39.180','index.php','',''), (122,'LOG_ADMIN',1194070779,'admin','62.178.39.180','useredit.php','Filter',''), (123,'LOG_ADMIN',1194070787,'admin','62.178.39.180','users.php','bans',''), (124,'LOG_ADMIN',1194070796,'admin','62.178.39.180','useredit.php','DeleteUser',''), (125,'LOG_ADMIN',1194070800,'admin','62.178.39.180','boards.php','',''), (126,'LOG_ADMIN',1194070808,'admin','62.178.39.180','boards.php','RenameCategory',''), (127,'LOG_ADMIN',1194070818,'admin','62.178.39.180','boards.php','edit',''), (128,'LOG_ADMIN',1194070824,'admin','62.178.39.180','groups.php','grouppermtable',''), (129,'LOG_ADMIN',1194070854,'admin','62.178.39.180','groups.php','editgroupboard',''), (130,'LOG_ADMIN',1194070879,'admin','62.178.39.180','index.php','EditSettings',''), (131,'LOG_ADMIN',1194070948,'admin','62.178.39.180','index.php','WriteSettings',''), (132,'LOG_ADMIN',1194070956,'admin','62.178.39.180','index.php','',''), (133,'LOG_MOD',1194070971,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (134,'LOG_MOD',1194070979,'admin','62.178.39.180','postops.php','reveal ip','post id:'), (135,'LOG_MOD',1194070986,'admin','62.178.39.180','threadops.php','deleted','thread id: 104'), (136,'LOG_MOD',1194070992,'admin','62.178.39.180','threadops.php','deleted','thread id: 103'), (137,'LOG_MOD',1194071004,'admin','62.178.39.180','threadops.php','deleted','thread id: 102'), (138,'LOG_MOD',1194071008,'admin','62.178.39.180','threadops.php','deleted','thread id: 101'), (139,'LOG_MOD',1194071015,'admin','62.178.39.180','threadops.php','deleted','thread id: 100'), (140,'LOG_MOD',1194071020,'admin','62.178.39.180','threadops.php','deleted','thread id: 99'), (141,'LOG_MOD',1194071039,'admin','62.178.39.180','threadops.php','deleted','thread id: 98'), (142,'LOG_MOD',1194071046,'admin','62.178.39.180','threadops.php','deleted','thread id: 97'), (143,'LOG_MOD',1194071052,'admin','62.178.39.180','threadops.php','deleted','thread id: 96'), (144,'LOG_MOD',1194071058,'admin','62.178.39.180','threadops.php','deleted','thread id: 95'), (145,'LOG_MOD',1194071066,'admin','62.178.39.180','threadops.php','deleted','thread id: 94'), (146,'LOG_MOD',1194071071,'admin','62.178.39.180','threadops.php','deleted','thread id: 93'), (147,'LOG_MOD',1194071081,'admin','62.178.39.180','threadops.php','deleted','thread id: 92'), (148,'LOG_MOD',1194071085,'admin','62.178.39.180','threadops.php','deleted','thread id: 91'), (149,'LOG_MOD',1194071091,'admin','62.178.39.180','threadops.php','deleted','thread id: 90'), (150,'LOG_MOD',1194071095,'admin','62.178.39.180','threadops.php','deleted','thread id: 89'), (151,'LOG_MOD',1194071102,'admin','62.178.39.180','threadops.php','deleted','thread id: 88'), (152,'LOG_MOD',1194071108,'admin','62.178.39.180','threadops.php','deleted','thread id: 87'), (153,'LOG_MOD',1194071113,'admin','62.178.39.180','threadops.php','deleted','thread id: 86'), (154,'LOG_MOD',1194071117,'admin','62.178.39.180','threadops.php','deleted','thread id: 85'), (155,'LOG_MOD',1194071146,'admin','62.178.39.180','threadops.php','deleted','thread id: 84'), (156,'LOG_MOD',1194071170,'admin','62.178.39.180','threadops.php','deleted','thread id: 83'), (157,'LOG_MOD',1194071174,'admin','62.178.39.180','threadops.php','deleted','thread id: 82'), (158,'LOG_MOD',1194071189,'admin','62.178.39.180','threadops.php','deleted','thread id: 81'), (159,'LOG_MOD',1194071192,'admin','62.178.39.180','threadops.php','deleted','thread id: 80'), (160,'LOG_MOD',1194071198,'admin','62.178.39.180','threadops.php','deleted','thread id: 79'), (161,'LOG_MOD',1194071203,'admin','62.178.39.180','threadops.php','deleted','thread id: 78'), (162,'LOG_MOD',1194071227,'admin','62.178.39.180','threadops.php','deleted','thread id: 77'), (163,'LOG_MOD',1194071232,'admin','62.178.39.180','threadops.php','deleted','thread id: 76'), (164,'LOG_MOD',1194071240,'admin','62.178.39.180','threadops.php','deleted','thread id: 75'), (165,'LOG_MOD',1194071248,'admin','62.178.39.180','threadops.php','deleted','thread id: 74'), (166,'LOG_MOD',1194071259,'admin','62.178.39.180','threadops.php','deleted','thread id: 73'), (167,'LOG_MOD',1194071264,'admin','62.178.39.180','threadops.php','deleted','thread id: 72'), (168,'LOG_MOD',1194071268,'admin','62.178.39.180','threadops.php','deleted','thread id: 71'), (169,'LOG_MOD',1194071301,'admin','62.178.39.180','threadops.php','deleted','thread id: 70'), (170,'LOG_MOD',1194071318,'admin','62.178.39.180','threadops.php','deleted','thread id: 69'), (171,'LOG_MOD',1194071344,'admin','62.178.39.180','threadops.php','deleted','thread id: 68'), (172,'LOG_MOD',1194071348,'admin','62.178.39.180','threadops.php','deleted','thread id: 67'), (173,'LOG_MOD',1194071352,'admin','62.178.39.180','threadops.php','deleted','thread id: 66'), (174,'LOG_MOD',1194071357,'admin','62.178.39.180','threadops.php','deleted','thread id: 65'), (175,'LOG_MOD',1194071362,'admin','62.178.39.180','threadops.php','deleted','thread id: 64'), (176,'LOG_MOD',1194071367,'admin','62.178.39.180','threadops.php','deleted','thread id: 63'), (177,'LOG_MOD',1194071372,'admin','62.178.39.180','threadops.php','deleted','thread id: 62'), (178,'LOG_MOD',1194071377,'admin','62.178.39.180','threadops.php','deleted','thread id: 61'), (179,'LOG_MOD',1194071400,'admin','62.178.39.180','threadops.php','deleted','thread id: 60'), (180,'LOG_MOD',1194071403,'admin','62.178.39.180','threadops.php','deleted','thread id: 59'), (181,'LOG_MOD',1194071409,'admin','62.178.39.180','threadops.php','deleted','thread id: 58'), (182,'LOG_MOD',1194071417,'admin','62.178.39.180','threadops.php','deleted','thread id: 57'), (183,'LOG_MOD',1194071420,'admin','62.178.39.180','threadops.php','deleted','thread id: 56'), (184,'LOG_MOD',1194071432,'admin','62.178.39.180','threadops.php','deleted','thread id: 55'), (185,'LOG_MOD',1194071436,'admin','62.178.39.180','threadops.php','deleted','thread id: 54'), (186,'LOG_MOD',1194071465,'admin','62.178.39.180','threadops.php','deleted','thread id: 53'), (187,'LOG_MOD',1194071487,'admin','62.178.39.180','threadops.php','deleted','thread id: 52'), (188,'LOG_MOD',1194071491,'admin','62.178.39.180','threadops.php','deleted','thread id: 51'), (189,'LOG_MOD',1194071514,'admin','62.178.39.180','threadops.php','deleted','thread id: 50'), (190,'LOG_MOD',1194071518,'admin','62.178.39.180','threadops.php','deleted','thread id: 49'), (191,'LOG_MOD',1194071541,'admin','62.178.39.180','threadops.php','deleted','thread id: 48'), (192,'LOG_MOD',1194071546,'admin','62.178.39.180','threadops.php','deleted','thread id: 47'), (193,'LOG_MOD',1194071549,'admin','62.178.39.180','threadops.php','deleted','thread id: 46'), (194,'LOG_MOD',1194071577,'admin','62.178.39.180','threadops.php','deleted','thread id: 45'), (195,'LOG_MOD',1194071582,'admin','62.178.39.180','threadops.php','deleted','thread id: 44'), (196,'LOG_MOD',1194071585,'admin','62.178.39.180','threadops.php','deleted','thread id: 43'), (197,'LOG_MOD',1194071590,'admin','62.178.39.180','threadops.php','deleted','thread id: 42'), (198,'LOG_MOD',1194071595,'admin','62.178.39.180','threadops.php','deleted','thread id: 41'), (199,'LOG_MOD',1194071599,'admin','62.178.39.180','threadops.php','deleted','thread id: 40'), (200,'LOG_MOD',1194071603,'admin','62.178.39.180','threadops.php','deleted','thread id: 39'), (201,'LOG_MOD',1194071606,'admin','62.178.39.180','threadops.php','deleted','thread id: 38'), (202,'LOG_MOD',1194071609,'admin','62.178.39.180','threadops.php','deleted','thread id: 37'), (203,'LOG_MOD',1194071612,'admin','62.178.39.180','threadops.php','deleted','thread id: 36'), (204,'LOG_MOD',1194071616,'admin','62.178.39.180','threadops.php','deleted','thread id: 35'), (205,'LOG_MOD',1194071631,'admin','62.178.39.180','threadops.php','deleted','thread id: 34'), (206,'LOG_MOD',1194071635,'admin','62.178.39.180','threadops.php','deleted','thread id: 33'), (207,'LOG_MOD',1194071638,'admin','62.178.39.180','threadops.php','deleted','thread id: 32'), (208,'LOG_MOD',1194071656,'admin','62.178.39.180','threadops.php','deleted','thread id: 30'), (209,'LOG_MOD',1194071660,'admin','62.178.39.180','threadops.php','deleted','thread id: 29'), (210,'LOG_MOD',1194071664,'admin','62.178.39.180','threadops.php','deleted','thread id: 28'), (211,'LOG_MOD',1194071819,'admin','62.178.39.180','threadops.php','deleted','thread id: 31'), (212,'LOG_ADMIN',1194071852,'admin','62.178.39.180','index.php','',''), (213,'LOG_ADMIN',1194071857,'admin','62.178.39.180','useredit.php','Filter',''), (214,'LOG_ADMIN',1194071859,'admin','62.178.39.180','useredit.php','ListUsers',''), (215,'LOG_ADMIN',1194072051,'admin','62.178.39.180','useredit.php','',''), (216,'LOG_ADMIN',1194072063,'admin','62.178.39.180','useredit.php','Filter',''), (217,'LOG_ADMIN',1194072064,'admin','62.178.39.180','useredit.php','ListUsers',''); /*!40000 ALTER TABLE `webboard_adminlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_avatar` -- DROP TABLE IF EXISTS `webboard_avatar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_avatar` ( `avatarid` int(8) unsigned NOT NULL AUTO_INCREMENT, `avatarname` varchar(128) NOT NULL DEFAULT '', `avatarurl` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`avatarid`), UNIQUE KEY `avatarname` (`avatarname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_avatar` -- LOCK TABLES `webboard_avatar` WRITE; /*!40000 ALTER TABLE `webboard_avatar` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_avatar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_ban` -- DROP TABLE IF EXISTS `webboard_ban`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_ban` ( `banid` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` int(10) unsigned NOT NULL DEFAULT 0, `banpubreason` mediumtext NOT NULL, `banreason` mediumtext NOT NULL, `bansetbyid` int(10) unsigned NOT NULL DEFAULT 0, `banexpire` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`banid`), KEY `userid` (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_ban` -- LOCK TABLES `webboard_ban` WRITE; /*!40000 ALTER TABLE `webboard_ban` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_ban` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_bannedwords` -- DROP TABLE IF EXISTS `webboard_bannedwords`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_bannedwords` ( `wordid` int(11) NOT NULL AUTO_INCREMENT, `banword` varchar(128) NOT NULL DEFAULT '', `modword` varchar(128) NOT NULL DEFAULT '', `ispartofword` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`wordid`), UNIQUE KEY `banword` (`banword`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_bannedwords` -- LOCK TABLES `webboard_bannedwords` WRITE; /*!40000 ALTER TABLE `webboard_bannedwords` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_bannedwords` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_board` -- DROP TABLE IF EXISTS `webboard_board`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_board` ( `boardid` int(10) unsigned NOT NULL AUTO_INCREMENT, `boardname` varchar(255) NOT NULL DEFAULT '', `boardlastpost` int(11) unsigned NOT NULL DEFAULT 0, `boardthreads` int(10) unsigned NOT NULL DEFAULT 0, `boardposts` int(10) unsigned NOT NULL DEFAULT 0, `boarddescription` text NOT NULL, `categoryid` int(11) unsigned NOT NULL DEFAULT 0, `boardorder` int(11) unsigned NOT NULL DEFAULT 0, `styleid` int(10) unsigned NOT NULL DEFAULT 0, `boardlastpostby` varchar(64) NOT NULL DEFAULT '', `boardthreadtopic` varchar(255) NOT NULL DEFAULT '', `boardthreadid` int(10) unsigned NOT NULL DEFAULT 0, `boarddisabled` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`boardid`), KEY `boardid` (`boardid`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_board` -- LOCK TABLES `webboard_board` WRITE; /*!40000 ALTER TABLE `webboard_board` DISABLE KEYS */; INSERT INTO `webboard_board` VALUES (1,'ao-colegas',0,0,0,'Atos Origin Colleagues\' \r\n\r\nWebboard',1,1,0,'','',0,0), (2,'heimam',0,0,0,'heimam\'s Webboard',2,1,3,'','',0,0); /*!40000 ALTER TABLE `webboard_board` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_calendar` -- DROP TABLE IF EXISTS `webboard_calendar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_calendar` ( `eventid` int(11) NOT NULL AUTO_INCREMENT, `eventtime` date DEFAULT NULL, `eventsubject` varchar(255) DEFAULT NULL, `eventtext` text DEFAULT NULL, `eventactive` smallint(1) NOT NULL DEFAULT 1, `userid` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`eventid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_calendar` -- LOCK TABLES `webboard_calendar` WRITE; /*!40000 ALTER TABLE `webboard_calendar` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_calendar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_category` -- DROP TABLE IF EXISTS `webboard_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_category` ( `categoryid` int(11) unsigned NOT NULL AUTO_INCREMENT, `categoryname` varchar(250) NOT NULL DEFAULT '', `categoryorder` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`categoryid`), KEY `categoryid` (`categoryid`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_category` -- LOCK TABLES `webboard_category` WRITE; /*!40000 ALTER TABLE `webboard_category` DISABLE KEYS */; INSERT INTO `webboard_category` VALUES (1,'public',1), (2,'private',2); /*!40000 ALTER TABLE `webboard_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_group` -- DROP TABLE IF EXISTS `webboard_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_group` ( `groupid` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL DEFAULT '', `accessmask` int(10) unsigned NOT NULL DEFAULT 0, `nodelete` tinyint(1) unsigned NOT NULL DEFAULT 0, `title` varchar(255) NOT NULL DEFAULT '', `titlepriority` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`groupid`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_group` -- LOCK TABLES `webboard_group` WRITE; /*!40000 ALTER TABLE `webboard_group` DISABLE KEYS */; INSERT INTO `webboard_group` VALUES (1,'Default Group',135,1,'',0), (2,'Guest Group',1,1,'',0), (3,'Admin Group',4194303,1,'Administrator',0), (4,'Moderator Group',1806767,1,'Moderator',0); /*!40000 ALTER TABLE `webboard_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_groupboard` -- DROP TABLE IF EXISTS `webboard_groupboard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_groupboard` ( `boardid` int(10) unsigned NOT NULL DEFAULT 0, `groupid` int(10) unsigned NOT NULL DEFAULT 0, `accessmask` int(10) unsigned NOT NULL DEFAULT 0, KEY `boardid` (`boardid`,`groupid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_groupboard` -- LOCK TABLES `webboard_groupboard` WRITE; /*!40000 ALTER TABLE `webboard_groupboard` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_groupboard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_lastvisited` -- DROP TABLE IF EXISTS `webboard_lastvisited`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_lastvisited` ( `boardid` int(10) unsigned NOT NULL DEFAULT 0, `userid` int(10) unsigned NOT NULL DEFAULT 0, `lastvisitedtime` int(10) unsigned NOT NULL DEFAULT 0, KEY `useridboardid` (`userid`,`boardid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_lastvisited` -- LOCK TABLES `webboard_lastvisited` WRITE; /*!40000 ALTER TABLE `webboard_lastvisited` DISABLE KEYS */; INSERT INTO `webboard_lastvisited` VALUES (1,1,1194071820); /*!40000 ALTER TABLE `webboard_lastvisited` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_news` -- DROP TABLE IF EXISTS `webboard_news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_news` ( `newsid` int(11) NOT NULL AUTO_INCREMENT, `newstopic` varchar(250) NOT NULL DEFAULT '', `newstext` mediumtext NOT NULL, `newstime` int(11) NOT NULL DEFAULT 0, `boardid` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`newsid`), KEY `newsid` (`newsid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_news` -- LOCK TABLES `webboard_news` WRITE; /*!40000 ALTER TABLE `webboard_news` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_online` -- DROP TABLE IF EXISTS `webboard_online`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_online` ( `onlineid` int(10) unsigned NOT NULL AUTO_INCREMENT, `onlineip` varchar(16) NOT NULL DEFAULT '', `onlinetime` int(10) unsigned NOT NULL DEFAULT 0, `userid` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`onlineid`), KEY `onlinetime` (`onlinetime`) ) ENGINE=MyISAM AUTO_INCREMENT=2204182 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_online` -- LOCK TABLES `webboard_online` WRITE; /*!40000 ALTER TABLE `webboard_online` DISABLE KEYS */; INSERT INTO `webboard_online` VALUES (2204167,'216.244.66.230',1706978458,0), (2204181,'47.128.31.197',1706993695,0), (2204180,'54.36.148.64',1706992404,0), (2204179,'54.36.148.28',1706991391,0), (2204178,'216.244.66.230',1706991360,0), (2204177,'54.36.148.189',1706990316,0), (2204176,'54.36.148.102',1706989146,0), (2204175,'54.36.149.10',1706988150,0), (2204174,'54.36.148.249',1706982666,0), (2204173,'85.203.47.32',1706982293,0), (2204172,'85.203.47.51',1706982293,0), (2204171,'85.203.47.53',1706982292,0), (2204170,'54.36.148.113',1706980685,0), (2204169,'54.36.148.179',1706979703,0), (2204168,'54.36.148.184',1706978812,0); /*!40000 ALTER TABLE `webboard_online` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_pm` -- DROP TABLE IF EXISTS `webboard_pm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_pm` ( `pmid` int(10) unsigned NOT NULL AUTO_INCREMENT, `pmfromid` int(10) unsigned NOT NULL DEFAULT 0, `pmtoid` int(10) unsigned NOT NULL DEFAULT 0, `pmtopic` varchar(128) NOT NULL DEFAULT '', `pmtext` mediumtext NOT NULL, `pmtime` int(10) unsigned NOT NULL DEFAULT 0, `pmflags` tinyint(4) NOT NULL DEFAULT 0, `pmfolder` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`pmid`), KEY `pmid` (`pmid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_pm` -- LOCK TABLES `webboard_pm` WRITE; /*!40000 ALTER TABLE `webboard_pm` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_pm` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_post` -- DROP TABLE IF EXISTS `webboard_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_post` ( `postid` int(10) unsigned NOT NULL AUTO_INCREMENT, `posttime` int(11) unsigned DEFAULT NULL, `posttext` text NOT NULL, `userid` int(10) unsigned NOT NULL DEFAULT 0, `postguestname` varchar(64) NOT NULL DEFAULT '', `threadid` int(11) unsigned NOT NULL DEFAULT 0, `postemailnotify` tinyint(1) unsigned NOT NULL DEFAULT 0, `postip` varchar(16) NOT NULL DEFAULT '', `postsmilies` tinyint(1) NOT NULL DEFAULT 0, `postcode` tinyint(1) NOT NULL DEFAULT 0, `postsignature` tinyint(1) NOT NULL DEFAULT 0, `postlasteditby` varchar(64) NOT NULL DEFAULT '', `postlastedittime` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`postid`), KEY `postid` (`postid`), KEY `userid` (`userid`), KEY `threadid` (`threadid`,`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_post` -- LOCK TABLES `webboard_post` WRITE; /*!40000 ALTER TABLE `webboard_post` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_qlink` -- DROP TABLE IF EXISTS `webboard_qlink`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_qlink` ( `linkid` int(3) unsigned NOT NULL AUTO_INCREMENT, `linkcaption` varchar(50) NOT NULL DEFAULT '', `linkalt` varchar(255) NOT NULL DEFAULT '', `linkhttp` text NOT NULL, `linkcounter` int(11) unsigned NOT NULL DEFAULT 0, `linkactive` int(1) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`linkid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_qlink` -- LOCK TABLES `webboard_qlink` WRITE; /*!40000 ALTER TABLE `webboard_qlink` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_qlink` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_rank` -- DROP TABLE IF EXISTS `webboard_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_rank` ( `rankid` int(10) unsigned NOT NULL AUTO_INCREMENT, `ranktitle` varchar(255) NOT NULL DEFAULT '', `rankimage` varchar(255) NOT NULL DEFAULT '', `rankposts` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`rankid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_rank` -- LOCK TABLES `webboard_rank` WRITE; /*!40000 ALTER TABLE `webboard_rank` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_rank` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_registry` -- DROP TABLE IF EXISTS `webboard_registry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_registry` ( `keyname` varchar(255) NOT NULL DEFAULT '', `keyvalue` mediumtext NOT NULL, `keytype` enum('string','integer','boolean','array') NOT NULL DEFAULT 'string', `keydescription` varchar(32) NOT NULL DEFAULT '', `keydetails` varchar(255) NOT NULL DEFAULT '', `keygroupid` int(10) unsigned NOT NULL DEFAULT 0, `keydisplayorder` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`keyname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_registry` -- LOCK TABLES `webboard_registry` WRITE; /*!40000 ALTER TABLE `webboard_registry` DISABLE KEYS */; INSERT INTO `webboard_registry` VALUES ('board_name','mam\'s thwboard','string','Board name','',1,0), ('board_baseurl','http://webboard.mamweb.at','string','Board URL','Used in eMails',1,1), ('board_admin','mam@heimam.at','string','Board Admin/Tech eMail','',1,2), ('site_name','mam\'s collection of webboards','string','Board site name','',1,3), ('site_url','http://webboard.mamweb.at','string','Board site URL','',1,4), ('userrating','0','boolean','Enable userrating','(currently unavailable)',2,0), ('privatemessages','1','boolean','Allow private messages?','',2,1), ('smilies','1','boolean','Allow smilies?','',2,2), ('enable_quicklinks','1','boolean','Enable quicklinks?','',2,3), ('enable_ranks','0','boolean','Enable userranks?','',2,4), ('debugmode','0','boolean','Enable debug-mode?','Prints debug/development messages for admins',2,5), ('forumclosed','0','boolean','Forum closed?','Allows you to close your forums, e.g. for maintenance. Note: Administrators can still view the \r\n\r\nforums.',5,1), ('use_email','0','boolean','Use eMail functions?','If your server does not support sending eMails via php\'s mail() function, disable this.',2,7), ('guestprefix','_','string','Guest name prefix','The char put in front of a guest name.',2,9), ('showprivateboards','1','boolean','Show private boards?','View boards that are inaccessisble for a user? (The user is still not able to view \r\n\r\nit)',2,10), ('uppercase_prot','1','boolean','Use uppercase topic protection?','Prevents users from using only caps in topics. CAN BE VERY USEFUL',2,11), ('allowregister','0','boolean','Allow users to register?','You can disable the register option for users here.',2,12), ('vars_t_amount','50','integer','Topics per page','The number of topic rows per board-page.',3,0), ('vars_m_amount','25','integer','Message amount','The number of posts within a thread.',3,1), ('subject_maxlength','64','integer','Topic maxlength','The maximum length (in chars) allowed in a thread\'s topic.',3,2), ('subject_minlength','2','integer','Topic minlength','The minimum length.',3,3), ('message_maxlength','10000','integer','Message maxlength','The maximum length in a post\'s text (in chars).',3,4), ('message_minlength','2','integer','Message minlength','Minimum post length.',3,5), ('showpostslevel','2','integer','Show posts level','Show posts:
0 - Never, don\'t show any post counts.
1 - Show own postcount only.
2 \r\n\r\n- No restriction',3,6), ('imageslevel','1','integer','Image usage level','Allow images:
0 - No restriction
1 - Allow images in posts only
2 - Do not allow any \r\n\r\nimages',3,7), ('max_usernamelength','24','integer','Maximum user name length','The maximum length of a username, in chars.',3,8), ('min_usernamelength','2','integer','Minimum user name length','The minimum length of a username, in chars.',3,9), ('pm_maxlength','8000','integer','Private message maximum length','The maximum length of a private message, in chars.',3,10), ('postdelay','30','integer','Post flood protection','Minimum delay between posts, in seconds.',4,0), ('editlimit','1800','integer','Edit time limit','Users will be unable to edit posts after posttime + limit. Set to 0 to disable.',4,1), ('timeoffset','0','integer','Time offset','Time offset, in hours (can be negative)',5,0), ('closedmsg','sorry,\r\n\r\ndas web board ist momentan leider nicht verfügbar!','array','Forum closed message','This message appears if users \r\n\r\ntry to access the closed forum.',5,2), ('bannednames','','array','Nick register protection','Allows you to specify invalid nicks. Users will be unable to register these nicks, one \r\n\r\nname per line. Example: \"adm\" disallows Admin as well as fooadmbar...',5,4), ('bannedemails','','array','Email register protection','Allows you to specify invalid email addresses. Use one eMail per line, eg @aol bans \r\n\r\ndude@aol.com as well as notme@aol.net',5,3), ('version','2.81','string','Version','The internal version, please do not change.',0,0), ('sig_maxlen','600','integer','Max. signature length','The maximum length of a signature, in bytes (chars).',6,1), ('max_privmsg','50','integer','Max PM count','The maximum amount of private messages per user. Users will be unable to recieve PMs if their box \r\n\r\nis full.',3,11), ('pmalive','0','integer','PM max life','Set the maximum age of private messages, in days. Set to 0 to disable life check.',3,12), ('sig_maxlines','5','integer','Max. signature lines','The maximum number of lines allowed in a signature. Note that a line can be wrapped \r\n\r\ndepending on the users browser size. Thus you should set an appropriate max length in chars as well. One average line has about 120 chars at a \r\n\r\nresolution of 1024*7',6,2), ('sig_restrict','1','boolean','Enable signature restrictions?','Enable this to restrict the signature length using the options below.',6,0), ('uselastthreads','1','boolean','Enable last-threads-form?','Enables a select form on the index page to display threads within the last 3/5/7.. \r\n\r\ndays.',2,13), ('max_useronline','14|1445759683','string','Do not modify or delete','Do not modify or delete',0,0), ('default_groupid','1','integer','Dont modify!','Dont modify!',0,0), ('guest_groupid','2','integer','Dont modify!','Dont modify!',0,0), ('avatarheight','64','integer','Avatar maximum height','The maximum height of the user-defined Avatars.',7,2), ('avatarwidth','64','integer','Avatar maximum width','The maximum width of the user-defined Avatars.',7,1), ('useravatar','3','integer','Avatar-Settings','Enable avatars:
0 - Avatars are disabled
1 - Only pre-installed \r\n\r\navatars
2 - Only user-defined avatars
3 - Both',7,0), ('usebwordprot','3','integer','Badwords protection','Do not modify',0,7), ('compression','0','boolean','Enable compression?','Gzip compression can save a lot of traffic, but requires a bit more cpu time',2,14), ('slow_search','1','boolean','Case-insensitive (slow) search?','Slower, but more precisely.',2,15); /*!40000 ALTER TABLE `webboard_registry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_registrygroup` -- DROP TABLE IF EXISTS `webboard_registrygroup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_registrygroup` ( `keygroupid` int(10) unsigned NOT NULL AUTO_INCREMENT, `keygroupname` varchar(64) NOT NULL DEFAULT '', `keygroupdisplayorder` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`keygroupid`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_registrygroup` -- LOCK TABLES `webboard_registrygroup` WRITE; /*!40000 ALTER TABLE `webboard_registrygroup` DISABLE KEYS */; INSERT INTO `webboard_registrygroup` VALUES (1,'General',0), (2,'Options',1), (3,'General vars',2), (4,'Post options',3), (5,'Misc',6), (6,'Signature control',4), (7,'Avatar settings',5); /*!40000 ALTER TABLE `webboard_registrygroup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_session` -- DROP TABLE IF EXISTS `webboard_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_session` ( `sessionid` varchar(32) NOT NULL DEFAULT '', `lastaction` int(10) unsigned NOT NULL DEFAULT 0, `userid` int(10) unsigned NOT NULL DEFAULT 0, `username` varchar(64) NOT NULL DEFAULT '', `ip` varchar(16) NOT NULL DEFAULT '0', PRIMARY KEY (`sessionid`), KEY `sessionid` (`sessionid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_session` -- LOCK TABLES `webboard_session` WRITE; /*!40000 ALTER TABLE `webboard_session` DISABLE KEYS */; INSERT INTO `webboard_session` VALUES ('476e0ba430ff986b6d90018c2308d7ce',1194072064,1,'admin','62.178.39.180'); /*!40000 ALTER TABLE `webboard_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_style` -- DROP TABLE IF EXISTS `webboard_style`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_style` ( `styleid` int(10) unsigned NOT NULL AUTO_INCREMENT, `stylename` varchar(32) NOT NULL DEFAULT '', `colorbg` varchar(8) NOT NULL DEFAULT '', `colorbgfont` varchar(8) NOT NULL DEFAULT '', `color4` varchar(8) NOT NULL DEFAULT '', `col_he_fo_font` varchar(8) NOT NULL DEFAULT '', `color1` varchar(8) NOT NULL DEFAULT '', `CellA` varchar(8) NOT NULL DEFAULT '', `CellB` varchar(8) NOT NULL DEFAULT '', `border_col` varchar(8) NOT NULL DEFAULT '', `color_err` varchar(8) NOT NULL DEFAULT '', `col_link` varchar(8) NOT NULL DEFAULT '', `col_link_v` varchar(8) NOT NULL DEFAULT '', `col_link_hover` varchar(8) NOT NULL DEFAULT '', `stdfont` varchar(128) NOT NULL DEFAULT '', `boardimage` varchar(128) NOT NULL DEFAULT '', `newtopicimage` varchar(128) NOT NULL DEFAULT '', `styleispublic` tinyint(1) unsigned NOT NULL DEFAULT 0, `styleisdefault` tinyint(1) unsigned NOT NULL DEFAULT 0, `styletemplate` varchar(32) NOT NULL DEFAULT 'default', PRIMARY KEY (`styleid`), KEY `styleid` (`styleid`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_style` -- LOCK TABLES `webboard_style` WRITE; /*!40000 ALTER TABLE `webboard_style` DISABLE KEYS */; INSERT INTO `webboard_style` VALUES (1,'Default','#FAFAFA','#454545','#1B6ECC','#ECECEC','#323232','#FAFAFA','#F5F5F5','#DEDEDE','#990000','#1B6ECC','#1B6ECC','#69B271','Verdana, Helvetica','./templates/default/images/space.gif','./templates/default/images/newtopic.gif',0,1,'default'), (2,'AO','#FFFFFF','#333333','#FF9900','#FFFFFF','#333333','#FFFFFF','#ECECEC','#000000','#FF0000','#FF6600','#FF6600','#6699CC','Verdana, Helvetica','./templates/default/images/space.gif','',0,0,'default'), (3,'heiMAM','#FFFFFF','#333333','#336600','#FFFFFF','#333333','#FFFFFF','#ECECEC','#666666','#FF0000','#336600','#336600','#669900','Verdana, Helvetica','./templates/default/images/space.gif','',0,0,'default'); /*!40000 ALTER TABLE `webboard_style` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_thread` -- DROP TABLE IF EXISTS `webboard_thread`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_thread` ( `threadid` int(11) unsigned NOT NULL AUTO_INCREMENT, `threadtopic` varchar(255) NOT NULL DEFAULT '', `threadtime` int(11) unsigned NOT NULL DEFAULT 0, `threadauthor` varchar(64) NOT NULL DEFAULT '', `threadreplies` int(11) unsigned NOT NULL DEFAULT 0, `boardid` int(11) unsigned NOT NULL DEFAULT 0, `threadlastreplyby` varchar(64) NOT NULL DEFAULT '', `threadiconid` smallint(6) unsigned NOT NULL DEFAULT 0, `threadviews` int(10) unsigned NOT NULL DEFAULT 0, `threadlink` int(10) unsigned NOT NULL DEFAULT 0, `threadclosed` tinyint(1) unsigned NOT NULL DEFAULT 0, `threadtop` tinyint(1) unsigned NOT NULL DEFAULT 0, `threadcreationtime` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`threadid`), KEY `threadid` (`threadid`), KEY `boardid` (`boardid`,`threadtop`,`threadtime`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_thread` -- LOCK TABLES `webboard_thread` WRITE; /*!40000 ALTER TABLE `webboard_thread` DISABLE KEYS */; /*!40000 ALTER TABLE `webboard_thread` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webboard_user` -- DROP TABLE IF EXISTS `webboard_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webboard_user` ( `userid` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(64) NOT NULL DEFAULT '', `userjoin` int(11) unsigned NOT NULL DEFAULT 0, `userlastpost` int(11) unsigned NOT NULL DEFAULT 0, `userposts` int(11) unsigned NOT NULL DEFAULT 0, `useremail` varchar(128) NOT NULL DEFAULT '', `userpassword` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `userhomepage` varchar(128) NOT NULL DEFAULT '', `userlocation` varchar(128) NOT NULL DEFAULT '', `usericq` int(11) unsigned NOT NULL DEFAULT 0, `useraim` varchar(50) NOT NULL DEFAULT '', `usermsn` varchar(50) NOT NULL DEFAULT '', `userbday` date NOT NULL DEFAULT '0000-00-00', `styleid` int(10) unsigned NOT NULL DEFAULT 0, `useroccupation` varchar(128) NOT NULL DEFAULT '', `userinterests` mediumtext NOT NULL, `usersignature` mediumtext NOT NULL, `userbanned` tinyint(1) unsigned NOT NULL DEFAULT 0, `usertitle` varchar(64) NOT NULL DEFAULT '', `userhidesig` tinyint(1) unsigned NOT NULL DEFAULT 0, `userrating` tinyint(3) unsigned NOT NULL DEFAULT 0, `uservotes` smallint(5) unsigned NOT NULL DEFAULT 0, `userhideemail` tinyint(1) unsigned NOT NULL DEFAULT 0, `userisadmin` tinyint(1) unsigned NOT NULL DEFAULT 0, `userinvisible` tinyint(1) unsigned NOT NULL DEFAULT 0, `usernoding` tinyint(1) unsigned NOT NULL DEFAULT 0, `useravatar` varchar(255) NOT NULL DEFAULT '', `groupids` varchar(128) NOT NULL DEFAULT '', `usernodelete` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`userid`), UNIQUE KEY `username` (`username`), KEY `userid` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=280 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webboard_user` -- LOCK TABLES `webboard_user` WRITE; /*!40000 ALTER TABLE `webboard_user` DISABLE KEYS */; INSERT INTO `webboard_user` VALUES (1,'admin',1149513169,0,0,'mam@heimam.at','5a9361b28ee51795f1e82d9054919034','','',0,'','','0000-00-00',0,'','','',0,'',0,0,0,0,1,0,0,'',',3,',1); /*!40000 ALTER TABLE `webboard_user` 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 2024-02-04 18:41:52