From 1fe76ba743a3418da9a0883b29756d442384d0bc Mon Sep 17 00:00:00 2001 From: Horus3 Date: Thu, 25 Sep 2014 10:33:47 +0200 Subject: init --- blob/database_schema | 9 ------ blob/nginx_rewrite_rules | 73 ------------------------------------------------ 2 files changed, 82 deletions(-) delete mode 100644 blob/database_schema delete mode 100755 blob/nginx_rewrite_rules (limited to 'blob') diff --git a/blob/database_schema b/blob/database_schema deleted file mode 100644 index f83e2d9..0000000 --- a/blob/database_schema +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE banned_user (id INTEGER PRIMARY KEY, login_attempts INTEGER, ip TEXT, session_id TEXT, time INTEGER, user INTEGER); - -CREATE TABLE jg(id INTEGER PRIMARY KEY, name TEXT, adresse TEXT, telefonnummer INTEGER, handynummer INTEGER, email TEXT, geburtstag TEXT); - -CREATE TABLE log (id INTEGER PRIMARY KEY, user INTEGER, login INTEGER, FOREIGN KEY(user) REFERENCES user(id)); - -CREATE TABLE sprueche(id INTEGER PRIMARY KEY, spruch TEXT); - -CREATE TABLE user (id INTEGER PRIMARY KEY, name TEXT UNIQUE, password TEXT, email TEXT UNIQUE, status INTEGER, register INTEGER); diff --git a/blob/nginx_rewrite_rules b/blob/nginx_rewrite_rules deleted file mode 100755 index d8a6611..0000000 --- a/blob/nginx_rewrite_rules +++ /dev/null @@ -1,73 +0,0 @@ -error_page 401 /failure.php?e=401; -error_page 403 /failure.php?e=403; -error_page 404 /failure.php?e=404; - -error_page 500 /failure.php?e=500; -error_page 502 /failure.php?e=502; -error_page 504 /failure.php?e=504; - -location /robots.txt {} #stop rewriting the robots.txt - -location /favicon.ico {} -location /static {} - -location ~* ^/liste { - rewrite ^/liste/?$ /index.php?task=liste&id=0; - rewrite ^/liste/([0-9]+)/?$ /index.php?task=liste&id=$1; - rewrite ^/liste/updated?/?$ /index.php?task=update; - rewrite ^/liste/new_member/? /index.php?task=new_member; -} - -rewrite ^/banned /failure.php?e=401; -rewrite ^/quote/?$ /index.php?task=quote; -rewrite ^/quote/([0-9]+)/?$ /index.php?task=quote&id=$1; -rewrite ^/new_member/? /index.php?task=new_member; -rewrite ^/update/? /index.php?task=update; -rewrite ^/Startseite/? /index.php; -rewrite ^/startseite/? /index.php; -rewrite ^/help/? /help.php; -rewrite ^/hilfe/? /help.php; -rewrite ^/services?/? /index.php?task=services; - -location ~* ^/account { - rewrite ^/account/?$ /index.php?task=account; - rewrite ^/account/change:(user)/?$ /index.php?task=account&change=$1; - rewrite ^/account/change:(password)/?$ /index.php?task=account&change=$1; -} - -location ~* ^/?login/?([a-z0-9]+=[a-z0-9]+(&[a-z0-9]+=[a-z0-9]+)?)?$ { - rewrite ^/?login([?/]?.*) /index.php?task=login&arguments=$1 last; -} - -location ~* ^/?logout/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { - rewrite ^/?logout([?/]?.*) /index.php?task=logout&arguments=$1 last; -} - - -location ~* ^/?register/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { - rewrite ^/?register(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /index.php?task=register&arguments=$1 last; -} - -#location ~* ^/?invite/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { -# rewrite ^/?invite(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /index.php?task=invite&arguments=$1 last; -#} - -location ~* ^/?user/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { - rewrite ^/?user(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /index.php?task=user&arguments=$1 last; -} - -#location ~* ^/?download/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { -# rewrite ^/?download(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /index.php?task=download&arguments=$1 last; -#} - -location ~* ^/password_recover/?(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ { - rewrite ^/?password_recover(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? /index.php?task=password_recover&arguments=$1 last; -} -#location ~* \.php(\?[0-9a-zA-Z]+(=[0-9a-zA-Z]*)?)?$ {} #empty block to catch all - -#location / { -# rewrite ^/([0-9a-zA-Z-_]+)/(.*) /index.php?name=$1&folder=$2 last; -# rewrite ^/([0-9a-zA-Z-_]+)$ /index.php?name=$1&folder= last; -# rewrite ^/$ /index.php last; -# break; -#} -- cgit v1.2.3