From 12734da8826299ffd24c0a15f6dbf205892d7221 Mon Sep 17 00:00:00 2001 From: root Date: Mon, 14 Apr 2014 08:35:13 +0200 Subject: Pushed to v3 --- www/functions/func_user.php | 337 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 337 insertions(+) create mode 100755 www/functions/func_user.php (limited to 'www/functions/func_user.php') diff --git a/www/functions/func_user.php b/www/functions/func_user.php new file mode 100755 index 0000000..d9e202d --- /dev/null +++ b/www/functions/func_user.php @@ -0,0 +1,337 @@ +query("SELECT * FROM user WHERE name='".$_SESSION["username"]."';"); + $info_ar = $info_db->fetchArray(SQLITE3_NUM); + + $ls_db = $db->query("SELECT login FROM log WHERE user=".$info_ar[0]." ORDER BY id DESC"); + $last_seen = $ls_db->fetchArray(SQLITE3_NUM); + } + + echo " + + + + + Account :: Junge Gemeinde Adlershof + + + + + + + "; + include("static/head.php"); +// echo "loged in as: " . $_SESSION["username"]; +/* + echo "
+ + + + + + + + + + + + "; +*/ + + switch($var){ + case("password"): + $passage = "Falsches Passwort.
"; + break; + case(PASSWORD_SUCCESS): + $passage = "Dein Passwort wurde erfolgreich geändert.
"; + break; + case(CH_USERNAME_SUCCESS): + $passage = "Erfolg! Ab sofort bist du unter ".$_SESSION["username"]." bekannt.
"; + break; + case(CH_EMAIL_SUCCESS): + $passage = "Deine E-Mail Adresse wurde erfolgreich geändert.
"; + break; + case(CH_EMAIL_EXISTS): + $passage = "Diese E-Mail Adresse ist schon in Benutzung.
"; + break; + case(CH_USERNAME_EXISTS): + $passage = "Dieser Name ist schon in Benutzung.
"; + break; + default: + $passage = ""; + break; + } + + echo "
+ +

+
+

Account Informationen

+
+ ".$passage." +
+ +
+

Deine Daten: (ändern?)

+
+
NameE-Mail
".$info_ar[1]."".$info_ar[3]."
+ + + + +
+ Name: + +   + + ".$info_ar[1]." + +
+ E-Mail: + +   + + ".$info_ar[3]." +
 
+ Registrierungsdatum: + +   + + ".date("j.n.Y / H:i:s", $info_ar[5])." + + +   +
+ Zuletzt gesehen: + +   + + ".date("j.n.Y / H:i:s", $last_seen[0])." +
+
+ + + +
+
+
+
+

Passwort Verwaltung:

+
+ + + + + + +
+ Passwort ändern? + +   + + | + +   + + Passwort vergessen? +
+ + +
+
+

Wechsle deinen Spitznamen oder deine E-Mail Adresse. Bitte bestätige die Änderung mit deinem Passwort.

+
+
+ + + + + + + + + +
+ Name: + + +
+ E-Mail: + + +
+ Passwort: + + +
+ + +
+
+
+
+
+
+
+

Aktualisiere deine Passwort. Bitte bestätige die Änderung mit deinem aktuell gültigen Passwort. +

+ + + + + + + + + + + +
+ Neues Passwort: + + +
+ Neues Passwort wiederholen: + + +
+ +
+ Altes Passwort: + + +
+ + +
+
+
+
+ + "; + return true; +} + +function user_id($db, $user){ + + $owner_db = $db->query("SELECT id FROM user WHERE name='" . SQLite3::escapeString($user) . "';"); + $owner_ar = $owner_db->fetchArray(SQLITE3_NUM); + if(empty($owner_ar[0])){ + return false; + } + + $owner = $owner_ar[0]; + return $owner; +} + +function change_username($db, $oldname, $newname){ + $oldname = $db->escapeString($oldname); + $newname = $db->escapeString($newname); + $check_db = $db->query("SELECT 1 FROM user WHERE name='".$newname."'"); + $check_ar = $check_db->fetchArray(SQLITE3_NUM); + + if($check_ar[0] == 1){ + return CH_USERNAME_EXISTS; + } + + if($db->exec(" + BEGIN TRANSACTION; + UPDATE user SET name='".$newname."'WHERE name='".$oldname."'; + COMMIT; + ")){ + $_SESSION["username"] = $newname; + return CH_USERNAME_SUCCESS; + } else { + return DATABASE; + } +} + +function change_email($db, $name, $email){ + $res_db = $db->query("SELECT 1, name FROM user WHERE email='".$db->escapeString($email)."'"); + $res_ar = $res_db->fetchArray(SQLITE3_NUM); + + if($res_ar[0] == 1){ + if($name != $res_ar[1]){ + return CH_EMAIL_EXISTS; + } + } + + if($db->exec(" + BEGIN TRANSACTION; + UPDATE user SET email='".$db->escapeString($email)."' WHERE name='".$db->escapeString($name)."'; + COMMIT; + ")){ + return CH_EMAIL_SUCCESS; + } else { + return DATABASE; + } +} -- cgit v1.2.3