summaryrefslogtreecommitdiff
path: root/blob
diff options
context:
space:
mode:
Diffstat (limited to 'blob')
-rw-r--r--blob/database_schema6
-rw-r--r--blob/files.conf50
2 files changed, 6 insertions, 50 deletions
diff --git a/blob/database_schema b/blob/database_schema
new file mode 100644
index 0000000..94ac055
--- /dev/null
+++ b/blob/database_schema
@@ -0,0 +1,6 @@
+#Database schema for SQLite3 database, stored in "../database/sqlite.db", based on the "www" directory
+
+CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UIQUE, senpai INTEGER, key TEXT, status INTEGER, invites INTEGER, salt TEXT, password TEXT, email TEXT UNIQUE);
+
+#Create table dynamically for every user, where $name=user
+CREATE TABLE $name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, public TEXT);
diff --git a/blob/files.conf b/blob/files.conf
deleted file mode 100644
index 9b7ab95..0000000
--- a/blob/files.conf
+++ /dev/null
@@ -1,50 +0,0 @@
-server {
- listen 80;
- server_name files.iamfabulous.de;
- index index.html;
- root /var/www/files/www;
- #location / {
- # autoindex on;
- #}
-
- error_page 404 /lolrndm.php;
- error_page 401 /lolrndm.php;
-
- location ~* \.php {
- fastcgi_pass unix:/var/run/php5-fpm.sock;
- include fastcgi_params;# SCRIPT_FILENAME $document_root$fastcgi_script_name;
-# fastcgi_param SCRIPT_FILENAME $request_filename;
- }
-
- #try_files $URI /files.php;
-
- location ~* ^/?login(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
- rewrite ^/?login(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /login.php?$1 last;
- }
-
- location ~* ^/?register(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
- rewrite ^/?register(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /register.php?$1 last;
- }
-
- location ~* ^/?invite(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
- rewrite ^/?invite(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /invite.php?$1 last;
- }
-
- location ~* \.php(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
- }
-
- location / {
- rewrite ^/([0-9a-zA-Z-_]*)/(.*) /index.php?name=$1&folder=$2 last;
- rewrite ^/([0-9a-zA-Z-_]*) /index.php?name=$1&folder=$2 last;
- break;
- }
-
- #rewrite ^/(.*) /files.php?$1 break;
- #rewrite ^/(.*) https://$server_name/$1 permanent;
-
-# location /admin {
-# autoindex on;
-# auth_basic "protected";
-# auth_basic_user_file /etc/nginx/claudio.passwd;
-# }
-}