From 1fe76ba743a3418da9a0883b29756d442384d0bc Mon Sep 17 00:00:00 2001 From: Horus3 Date: Thu, 25 Sep 2014 10:33:47 +0200 Subject: init --- www/functions/func_user.php | 341 -------------------------------------------- 1 file changed, 341 deletions(-) delete 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 deleted file mode 100755 index 394a8f7..0000000 --- a/www/functions/func_user.php +++ /dev/null @@ -1,341 +0,0 @@ -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]; - if($owner != ""){ - return $owner; - } else { - return false; - } -} - -function change_username($db, $oldname, $newname){ - $oldname = $db->escapeString(htmlentities($oldname)); - $newname = $db->escapeString(htmlentities($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(htmlentities($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(htmlentities($email))."' WHERE name='".$db->escapeString(htmlentities($name))."'; - COMMIT; - ")){ - return CH_EMAIL_SUCCESS; - } else { - return DATABASE; - } -} -- cgit v1.2.3