aboutsummaryrefslogtreecommitdiff
path: root/account.php
blob: 92be6d704c2e42d249cfc8c19e5cfa0c5d726ee7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<?php include('auth.php');
include("header.php");

if ($_SESSION["username"] != "jg-adlershof"){

	$username = $_SESSION["username"];
	$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';");
	while($email_array = $email_db->fetchArray(SQLITE3_NUM)){
		foreach($email_array as $thirdelement){
                        $email=$thirdelement;
                }
        }

	/*Anzahl der hochgeladenen Dateien.*/
        $count_db = $db_check->query("SELECT count(*) as count FROM file where fk=(SELECT id from user where name='$safe_username');");
	$count_array = $count_db->fetchArray();
	$count = $count_array["count"];


//echo "$username Test $email";
echo "
<div id='content_container' align='center'>
        <br>
        <div class='kleineschrift'>
                <div class='ueberschrift'><p>JUNGE GEMEINDE ADLERSHOF</p>
                </div>
        </div>

<br>
<div class='mittlereschrift'>
	Verwalte deine Account Informationen hier.
</div>
<br>


<table><tr>
<td><p>Name:&#160</td><td align='right'>$username</p></td></tr>
<tr><td><p>E-Mail:</td><td align='right'>$email</p></td></tr>
<tr><td align='left'><p>Stored files:</td> <td align='right'>$count</p></td></tr>
</table>


";


} else {
header("Location: member_login.php");
exit;
}

?>