From c24d0c2607d677546fd6ee5a763fc11ca0ebacab Mon Sep 17 00:00:00 2001 From: Horus3 Date: Sun, 9 Feb 2014 18:54:34 +0100 Subject: removed hard coded stuff --- account.php | 2 +- check.php | 4 ++-- inreg.php | 2 +- insert.php | 2 +- liste.php | 2 +- member_login.php | 2 +- quote.php | 2 +- reset.php | 2 +- share.php | 2 +- update.php | 2 +- 10 files changed, 11 insertions(+), 11 deletions(-) diff --git a/account.php b/account.php index 0717182..92be6d7 100644 --- a/account.php +++ b/account.php @@ -4,7 +4,7 @@ include("header.php"); if ($_SESSION["username"] != "jg-adlershof"){ $username = $_SESSION["username"]; - $db_check = new SQLite3("/var/www/jungegemeinde/database/share.db"); + $db_check = new SQLite3("../database/share.db"); $safe_username = SQLite3::escapeString("$username"); $email_db = $db_check->query("SELECT email FROM user where name='$safe_username';"); diff --git a/check.php b/check.php index b3911de..2004b64 100644 --- a/check.php +++ b/check.php @@ -10,7 +10,7 @@ session_start(); $username = SQLite3::escapeString("$unsafe_username"); $passwort = SQLite3::escapeString("$unsafe_passwort"); - $db_check = new SQLite3("/var/www/jungegemeinde/database/share.db"); + $db_check = new SQLite3("../database/share.db"); $salt_db = $db_check->query("SELECT salt FROM user WHERE name='$username';"); while($salt_array = $salt_db->fetchArray(SQLITE3_NUM)){ foreach($salt_array as $firstelement){ @@ -39,7 +39,7 @@ if ($real_password == $hash_password) { /*___Datenbankabfrage: Spruch___*/ $zufall = mt_rand(1,52); - $db = new SQLite3("/var/www/jungegemeinde/database/jg.db"); + $db = new SQLite3("../database/jg.db"); $zufall = SQLite3::escapeString("$zufall"); diff --git a/inreg.php b/inreg.php index 54bbf28..ce8488d 100644 --- a/inreg.php +++ b/inreg.php @@ -5,7 +5,7 @@ $name = $_POST["name"]; $cleartext_password = $_POST["pswd"]; $email = $_POST["email"]; -$db = new SQLite3("/var/www/jungegemeinde/database/share.db"); +$db = new SQLite3("../database/share.db"); $safe_name = SQLite3::escapeString("$name"); $safe_email = SQLite3::escapeString("$email"); diff --git a/insert.php b/insert.php index cca6118..856c0b8 100644 --- a/insert.php +++ b/insert.php @@ -2,7 +2,7 @@ include("header.php"); if ($_SERVER['REQUEST_METHOD'] == 'POST') { - $db = new SQLite3('/var/www/jungegemeinde/database/jg.db'); + $db = new SQLite3('../database/jg.db'); $safe1 = SQLite3::escapeString("$_POST[name]"); $safe2 = SQLite3::escapeString("$_POST[adresse]"); diff --git a/liste.php b/liste.php index c6fd146..824e604 100644 --- a/liste.php +++ b/liste.php @@ -1,7 +1,7 @@ diff --git a/member_login.php b/member_login.php index 1d3b6d9..8dc6ad4 100644 --- a/member_login.php +++ b/member_login.php @@ -26,7 +26,7 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') { $safe_username = SQLite3::escapeString("$username"); $safe_passwort = SQLite3::escapeString("$passwort"); - $db_check = new SQLite3("/var/www/jungegemeinde/database/share.db"); + $db_check = new SQLite3("../database/share.db"); $salt_db = $db_check->query("SELECT salt FROM user WHERE name='$safe_username';"); while($salt_array = $salt_db->fetchArray(SQLITE3_NUM)){ foreach($salt_array as $firstelement){ diff --git a/quote.php b/quote.php index 022d2ff..96549b1 100644 --- a/quote.php +++ b/quote.php @@ -4,7 +4,7 @@ include("header.php"); $zufall = $_GET["id"]; /*__Datenbank___*/ -$db = new SQLite3("/var/www/jungegemeinde/database/jg.db"); +$db = new SQLite3("..database/jg.db"); $rows = $db->query("SELECT count(*) as count FROM sprueche;"); $row = $rows->fetchArray(); $numRows = $row["count"]; diff --git a/reset.php b/reset.php index 9a84e79..793f000 100644 --- a/reset.php +++ b/reset.php @@ -49,7 +49,7 @@ echo " } else { /*___Datenbank___*/ - $db_check = new SQLite3("/var/www/jungegemeinde/database/share.db"); + $db_check = new SQLite3("../database/share.db"); $safe_email = SQLite3::escapeString("$email_post"); $email_db = $db_check->query("SELECT email FROM user WHERE email='$safe_email';"); diff --git a/share.php b/share.php index 7aeaf9c..87c1ddb 100644 --- a/share.php +++ b/share.php @@ -10,7 +10,7 @@ include("header.php"); query("SELECT filename FROM file WHERE private=0;"); diff --git a/update.php b/update.php index f3f6b4d..8ad75fc 100644 --- a/update.php +++ b/update.php @@ -15,7 +15,7 @@ $bday = $_POST["geburtstag"]; -$db = new SQLite3('/var/www/jungegemeinde/database/jg.db'); +$db = new SQLite3('../database/jg.db'); $result = $db->exec("UPDATE member SET name='$name' where id=$id;"); $result = $db->exec("UPDATE member SET adresse='$adresse' where id=$id;"); -- cgit v1.2.3