aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLibravatar neptune 2023-07-23 00:56:46 -0400
committerLibravatar neptune 2023-07-23 00:56:46 -0400
commit9e24e523a94b904b9f8bb43e00d0c70c2f24cf55 (patch)
tree004c0d59add0e8fb92d9c12a9595fc246f1d63f4
parent929389cf6397211cc7359be7f0408804f97717c6 (diff)
downloadweabot-master.tar.gz
weabot-master.tar.xz
weabot-master.zip
Agregando archivos de ejemploHEADmaster
-rw-r--r--README.md56
-rw-r--r--cgi/settings.py124
-rw-r--r--weabot.sql268
3 files changed, 448 insertions, 0 deletions
diff --git a/README.md b/README.md
new file mode 100644
index 0000000..3f7f938
--- /dev/null
+++ b/README.md
@@ -0,0 +1,56 @@
+weabot
+======
+weabot is a Python textboard and imageboard script made for Bienvenido a Internet BBS/IB. It's based on PyIB.
+
+New features
+------------
+- Textboards
+- Home page
+- Report system
+- Thread locking and permasaging
+- Mobile website
+- IDs
+- Noko
+- View and delete posts by IP
+- Oekaki
+- Flexible filetypes (such as Flash)
+- Wordfilters
+- Proper markdown and HTML
+- API
+- Many bugfixes and security improvements, and other minor improvements
+
+Requirements
+------------
+* Python 2.x
+* MySQL/MariaDB
+* MySQL-Python (MySQLdb)
+* WSGI/FastCGI (Optional)
+
+Installation
+------------
+1. Set up your web server to run Python scripts as CGI or FastCGI (see .htaccess example)
+2. Create a MySQL/MariaDB database and import the `weabot.sql` file
+3. Enter your database information and preferences in `cgi/settings.py`
+4. Navigate to http://yoursite.com/cgi/weabot.py/manage
+5. Log-in with credentials admin/admin - then create your own staff account and delete admin
+
+Authors
+-------
+weabot fork by Bienvenido a Internet N.P.O. <burocracia@bienvenidoainternet.org>
+Original work by tslocum <tslocum@gmail.com> https://github.com/tslocum/PyIB
+
+License
+-------
+weabot is licensed under the AGPLv3, with portions under the GPLv3.
+If you run weabot, even on a web server, you must publish any changes of the source code, and under the same license.
+Please read the full text of the license for more details (LICENSE file).
+If you don't agree with the license terms, please choose one of the alternatives to weabot listed below.
+
+Alternatives
+------------
+Some alternatives to weabot are:
+
+* [Wakaba/Kareha](http://wakaba.c3.cx/s/web/wakaba_kareha)
+* [TinyIB](https://github.com/tslocum/TinyIB)
+* [Tinyboard](http://tinyboard.org/)
+* [PyIB](https://github.com/tslocum/PyIB)
diff --git a/cgi/settings.py b/cgi/settings.py
new file mode 100644
index 0000000..dfe3d49
--- /dev/null
+++ b/cgi/settings.py
@@ -0,0 +1,124 @@
+# coding=utf-8
+import threading
+
+class SettingsLocal(threading.local):
+ USING_SQLALCHEMY = False # If SQLAlchemy is installed, set to True to use it
+
+ # Ignore these
+ BOARD = None
+ CONN = None
+
+ IS_TOR = None
+ IS_PROXY = None
+ HOST = None
+
+class Settings(object):
+ LANG = "es"
+
+ # *************** PATH INFORMATION ***************
+ NAME = "localhost"
+ DOMAIN = ".localdomain"
+ ROOT_DIR = "/var/www/"
+ HOME_DIR = "/var/www/"
+ IMAGES_DIR = "/var/www/"
+ STATIC_DIR = "/var/www/static/"
+ HOME_URL = "http://localhost/"
+ BOARDS_URL = "/"
+ CGI_URL = "/cgi/" # URL to folder containing the script
+ IMAGES_URL = "/"
+ STATIC_URL = "/static/"
+ USE_MULTITHREADING = False
+ MAX_PROGRAM_THREADS = 8 # Maximum threads this Python application can start (must be 2 or greater)
+ # Setting this too high can cause the program to terminate before finishing
+ # (Only needed if multithreading is on)
+
+ CONVERT_PATH = "convert" # Location to ImageMagick's convert tool
+ FFMPEG_PATH = "ffmpeg"
+ FFPROBE_PATH = "ffprobe"
+ # CONVERT_PATH = "C:\\Utils\\ImageMagick-6.7.0-Q16\\convert"
+
+ # *************** DATABASE INFORMATION ***************
+ DATABASE_HOST = "localhost"
+ DATABASE_USERNAME = "user"
+ DATABASE_PASSWORD = "pass"
+ DATABASE_DB = "db"
+ # The following two entries apply only if USING_SQLALCHEMY is set to True
+ DATABASE_POOL_SIZE = 5 # Initial number of database connections
+ DATABASE_POOL_OVERFLOW = 21 # Maximum number of database connections
+
+ # Keys
+ SECRET = 'CHANGEME' # Random seed for secure tripcodes, change it to something random
+ GOOGLE_API_KEY = ''
+ DISCORD_HOOK_URL = ''
+
+ # *************** HOME PAGE INFORMATION ***************
+ SITE_TITLE = "My site"
+ SITE_LOGO = Env.STATIC_URL + "logo.png"
+ SITE_SLOGAN = "My slogan"
+ MAINTENANCE = False # Set to True if you are making changes to the server so users can't post
+ FULL_MAINTENANCE = False
+ ENABLE_RSS = False
+ ENABLE_DISCORD_HOOK = True
+
+ # *************** BANNER INFORMATION ***************
+ ENABLE_BANNERS = True
+ banners_folder = Env.STATIC_URL + "img/" # Folder containing banners
+ banners = { # filename, width, height
+ 'default': [("default.png", "500", "81")],
+ }
+
+ # *************** IMAGES ***************
+ THUMB_QUALITY = 85 # Image quality for thumbnails (0-100)
+
+ # *************** BANS ***************
+ HTACCESS_GEN = True # Set to True to use .htaccess for bans (needed for blind bans!)
+ EXCLUDE_GLOBAL_BANS = [] # Excludes the following boards from global bans (not board specific bans)
+
+ # 'Name': ('Tripcode', 'New BBS name', 'New IB name', 'New ID', Hide Slip[bool])
+ CAPCODES = {}
+
+ # *************** BOARDS ***************
+ MAX_THREADS = 500 # IB
+ TXT_MAX_THREADS = 10000 # BBS
+
+ TRIM_METHOD = 0 # Which threads are trimmed first:
+ TXT_TRIM_METHOD = 1 # 0 = oldest (Futaba), 1 = inactive (2ch), 2 = least bumped (4chan)
+
+ CLOSE_THREAD_ON_REPLIES = 1000
+ TXT_CLOSE_THREAD_ON_REPLIES = 1000
+
+ MAX_AGE_ALERT = 0.15 # Multiplier for thread expiration alert
+
+ ALLOW_SECURE_TRIPCODES = False
+ TRIP_CHAR = '◆'
+
+ HOME_NEWS = 10 # News posts shown on home
+ HOME_LASTPOSTS = 25 # Last posts shown on home
+ HOME_NEWTHREADS = 17 # New threads shown on home
+ HOME_LASTPOSTS_LENGTH = 100
+
+ MODNEWS_MAX_POSTS = 30 # Max posts in the Manage front page
+ REPORTS_ENABLE = True # Enable or disable report system
+ REPORTS_PER_PAGE = 100
+ RECYCLEBIN_POSTS_PER_PAGE = 25
+
+ DELETE_FORBID_LENGTH = 5 # User can't delete own thread if replies exceed this
+ ARCHIVE_MIN_LENGTH = 5 # Minimum thread length to archive (0 = archive always)
+
+ # *************** STYLES ***************
+ STYLES = ('Rene', 'Dickgirl', 'Red', 'Photon', 'Cyber', 'Easymodo', 'Guro', 'Night', 'Futaba', 'Buri', 'Kraut', 'VNDB', 'Putaba')
+ STYLES_DEFAULT = 0
+
+ TXT_STYLES = ('4am', 'Amber', 'Ayashii', 'Baisano', 'BIOS', 'Blue Moon', 'Ciber', 'Futanari', 'Headline', 'Postal', 'Ventanas')
+ TXT_STYLES_DEFAULT = 3
+
+ # *************** MISC ***************
+ TIME_ZONE = -3
+ USE_MARKDOWN = False
+ USE_HTML = False
+ VIDEO_THUMBS = False
+ VIDEO_THUMBS_LIMIT = 5
+
+ SESSION_TIME = 30 * 60
+
+ _ = SettingsLocal() # Used when running multiple threads
diff --git a/weabot.sql b/weabot.sql
new file mode 100644
index 0000000..e91a8f2
--- /dev/null
+++ b/weabot.sql
@@ -0,0 +1,268 @@
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `archive` (
+ `id` int(10) unsigned NOT NULL,
+ `boardid` smallint(5) unsigned NOT NULL,
+ `timestamp` int(20) unsigned NOT NULL,
+ `subject` varchar(255) CHARACTER SET latin1 NOT NULL,
+ `length` smallint(5) unsigned NOT NULL,
+ PRIMARY KEY (`id`,`boardid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `bans` (
+ `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
+ `ip` int(15) unsigned NOT NULL,
+ `netmask` int(15) unsigned DEFAULT NULL,
+ `boards` text NOT NULL,
+ `added` int(10) unsigned NOT NULL,
+ `until` int(10) unsigned NOT NULL,
+ `staff` varchar(50) NOT NULL,
+ `reason` text NOT NULL,
+ `note` text NOT NULL,
+ `blind` tinyint(1) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `ip` (`ip`)
+) ENGINE=MyISAM AUTO_INCREMENT=980 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `boards` (
+ `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
+ `dir` varchar(16) NOT NULL,
+ `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `name` varchar(64) NOT NULL,
+ `longname` varchar(128) NOT NULL,
+ `subname` char(3) NOT NULL,
+ `postarea_desc` text NOT NULL,
+ `postarea_extra` text NOT NULL,
+ `force_css` varchar(255) NOT NULL,
+ `board_type` tinyint(1) unsigned NOT NULL,
+ `anonymous` varchar(128) NOT NULL DEFAULT 'Sin Nombre',
+ `subject` varchar(64) NOT NULL DEFAULT 'Sin asunto',
+ `message` varchar(128) NOT NULL DEFAULT 'Sin mensaje',
+ `disable_name` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `disable_subject` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `useid` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `slip` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `countrycode` tinyint(1) unsigned DEFAULT '0',
+ `recyclebin` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `secret` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `allow_spoilers` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `allow_oekaki` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `allow_noimage` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `allow_images` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `allow_image_replies` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `maxsize` smallint(5) unsigned NOT NULL DEFAULT '500',
+ `thumb_px` smallint(3) unsigned NOT NULL DEFAULT '250',
+ `numthreads` tinyint(2) unsigned NOT NULL DEFAULT '10',
+ `numcont` tinyint(2) unsigned NOT NULL DEFAULT '10',
+ `numline` tinyint(3) unsigned NOT NULL DEFAULT '20',
+ `maxage` smallint(3) unsigned NOT NULL DEFAULT '0',
+ `maxinactive` smallint(3) unsigned NOT NULL DEFAULT '0',
+ `archive` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `threadsecs` smallint(4) unsigned NOT NULL DEFAULT '600',
+ `postsecs` tinyint(3) unsigned NOT NULL DEFAULT '30',
+ PRIMARY KEY (`id`),
+ KEY `dir` (`dir`)
+) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `boards_filetypes` (
+ `boardid` smallint(5) unsigned NOT NULL,
+ `filetypeid` smallint(5) unsigned NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `filetypes` (
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `ext` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
+ `mime` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `image` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `preserve_name` tinyint(1) NOT NULL,
+ `ffmpeg_thumb` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `filters` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `boards` text NOT NULL,
+ `type` tinyint(1) NOT NULL,
+ `action` tinyint(1) NOT NULL,
+ `from` varchar(255) NOT NULL,
+ `from_trip` varchar(30) NOT NULL,
+ `to` text NOT NULL,
+ `reason` varchar(255) NOT NULL,
+ `seconds` int(20) unsigned NOT NULL,
+ `blind` tinyint(1) NOT NULL,
+ `redirect_url` varchar(40) NOT NULL,
+ `redirect_time` tinyint(3) unsigned NOT NULL,
+ `staff` varchar(50) NOT NULL,
+ `added` int(20) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `last` (
+ `id` int(10) unsigned NOT NULL,
+ `boardid` smallint(5) unsigned NOT NULL,
+ `board_name` varchar(64) NOT NULL,
+ `timestamp` int(20) NOT NULL,
+ `timestamp_formatted` varchar(50) NOT NULL,
+ `content` varchar(200) NOT NULL,
+ `url` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`,`boardid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `logs` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `timestamp` int(20) unsigned NOT NULL,
+ `staff` varchar(75) NOT NULL,
+ `action` text NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=4138 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `news` (
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `type` tinyint(1) NOT NULL,
+ `staffid` tinyint(3) unsigned NOT NULL,
+ `staff_name` varchar(50) NOT NULL,
+ `title` varchar(255) NOT NULL,
+ `message` text NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `timestamp_formatted` varchar(255) NOT NULL,
+ `timestamp` int(20) unsigned NOT NULL,
+ PRIMARY KEY (`type`,`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `posts` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `boardid` smallint(5) unsigned NOT NULL,
+ `parentid` mediumint(10) unsigned NOT NULL,
+ `timestamp` int(20) unsigned DEFAULT NULL,
+ `timestamp_formatted` varchar(50) NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `tripcode` varchar(255) NOT NULL,
+ `email` varchar(255) NOT NULL,
+ `subject` varchar(255) NOT NULL,
+ `message` text NOT NULL,
+ `password` varchar(255) NOT NULL,
+ `file` varchar(75) NOT NULL,
+ `file_hex` varchar(75) NOT NULL,
+ `file_size` int(20) unsigned NOT NULL,
+ `image_width` smallint(5) unsigned NOT NULL,
+ `image_height` smallint(5) unsigned NOT NULL,
+ `thumb` varchar(255) NOT NULL,
+ `thumb_width` smallint(5) unsigned NOT NULL,
+ `thumb_height` smallint(5) unsigned NOT NULL,
+ `ip` int(15) unsigned NOT NULL,
+ `IS_DELETED` tinyint(1) NOT NULL,
+ `bumped` int(20) unsigned NOT NULL,
+ `last` int(20) unsigned NOT NULL,
+ `locked` tinyint(1) NOT NULL,
+ `expires` int(20) unsigned NOT NULL,
+ `expires_formatted` varchar(30) NOT NULL,
+ `expires_alert` tinyint(1) NOT NULL,
+ `length` smallint(4) unsigned NOT NULL,
+ PRIMARY KEY (`boardid`,`id`),
+ KEY `parentid` (`parentid`),
+ KEY `bumped` (`bumped`)
+) ENGINE=MyISAM AUTO_INCREMENT=1743 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `reports` (
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
+ `board` varchar(16) NOT NULL,
+ `postid` int(10) unsigned NOT NULL,
+ `parentid` int(10) unsigned NOT NULL,
+ `link` varchar(64) NOT NULL,
+ `ip` varchar(15) NOT NULL,
+ `reason` varchar(255) NOT NULL,
+ `reporterip` varchar(15) NOT NULL,
+ `timestamp` int(20) unsigned NOT NULL,
+ `timestamp_formatted` varchar(50) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=811 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search` (
+ `id` int(10) NOT NULL,
+ `boardid` smallint(5) NOT NULL,
+ `timestamp` int(20) NOT NULL,
+ `subject` varchar(255) CHARACTER SET latin1 NOT NULL,
+ `message` text CHARACTER SET latin1 NOT NULL,
+ `parentid` int(10) NOT NULL,
+ `parenttime` int(20) NOT NULL,
+ `parentsub` varchar(255) CHARACTER SET latin1 NOT NULL,
+ `num` smallint(5) NOT NULL,
+ PRIMARY KEY (`id`,`boardid`),
+ FULLTEXT KEY `message` (`message`),
+ FULLTEXT KEY `subject` (`subject`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_kako` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `boardid` smallint(5) unsigned NOT NULL,
+ `pid` int(10) unsigned NOT NULL,
+ `subject` varchar(255) CHARACTER SET latin1 NOT NULL,
+ `message` text CHARACTER SET latin1 NOT NULL,
+ `parentid` int(10) unsigned NOT NULL,
+ `num` smallint(5) unsigned NOT NULL,
+ `timestamp_formatted` varchar(50) CHARACTER SET latin1 NOT NULL,
+ PRIMARY KEY (`id`,`boardid`),
+ FULLTEXT KEY `kakoindex` (`message`,`subject`)
+) ENGINE=MyISAM AUTO_INCREMENT=115631 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_log` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `timestamp` int(20) unsigned NOT NULL,
+ `keyword` varchar(255) CHARACTER SET latin1 NOT NULL,
+ `ita` varchar(16) CHARACTER SET latin1 NOT NULL,
+ `ip` int(20) unsigned NOT NULL,
+ `res` smallint(5) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=3593 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `session` (
+ `session_id` varbinary(32) NOT NULL,
+ `expires` int(32) NOT NULL,
+ `staff_id` tinyint(3) NOT NULL,
+ PRIMARY KEY (`session_id`),
+ KEY `staff_id` (`staff_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `staff` (
+ `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
+ `username` varchar(50) NOT NULL,
+ `password` varchar(255) NOT NULL,
+ `added` int(10) unsigned NOT NULL,
+ `lastactive` int(10) unsigned NOT NULL,
+ `rights` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`),
+ KEY `username` (`username`,`password`)
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+INSERT INTO `filetypes` VALUES (1,'jpg','image/jpeg','',0,0),(2,'png','image/png','',0,0),(3,'gif','image/gif','',0,0),(4,'swf','application/x-shockwave-flash','mime/swf.png',1,0),(5,'webm','video/webm','',0,1),(6,'ogg','audio/ogg','',0,1),(7,'opus','audio/opus','',0,1),(8,'mod','audio/mod','mime/mod.png',0,0),(9,'xm','audio/xm','mime/xm.png',0,0),(10,'s3m','audio/s3m','mime/s3m.png',0,0),(11,'mp3','audio/mpeg','',0,1),(12,'torrent','application/x-bittorrent','mime/torrent.png',1,0),(13,'pdf','application/pdf','mime/pdf.png',1,0),(14,'epub','application/epub+zip','mime/epub.png',1,0);