handles most of the database stuff

1 files changed, 31 insertions, 6 deletions

diff --git a/www/index.php b/www/index.php
index 91f7e4d..99c1c85 100644
--- a/www/index.php
+++ b/www/index.php
@@ -2,13 +2,31 @@
 
 session_start();
 
+echo $_GET[name];
+echo $_GET[folder];
+
+echo "<br><br>Currently loged in as: ";
+echo $_SESSION["username"];
+
+$safe_name=SQLite3::escapeString("$_SESSION[username]");
+
+	$db = new SQLite3("../database/sqlite.db");
+
+        $invite_db = $db->query("SELECT invites FROM user WHERE name='$safe_name';");
+        $invite_ar = $invite_db->fetchArray(SQLITE3_NUM);
+        $invite = $invite_ar[0];
+
+echo "<br><br>";
+echo "You have currently $invite invites.";
+echo "<br><br>";
+
 if(empty($_GET)){
-/*	if($_SESSION["login"]){
-		header("Refresh: 0; $_SESSION['username']");
+	if($_SESSION[login]){
+		header("Refresh: 0; $_SESSION[username]");
 	} else {
-*/
+
 		header("Refresh: 0; /login");
-//	}
+	}
 } else {
 
 	#print_r($_GET);
@@ -34,5 +52,12 @@ if(empty($_GET)){
 	#header("Refresh: 0; /login");
 
 }
-
-
+?>
+<form method="post" action="testreg.php">
+<p>Name: <input type="text" name="name"></p>
+<p>pswd: <input type="text" name="pswd"></p>
+<p>2ndpsdw: <input type="text" name="2ndpswd"></p>
+<p>key: <input type="text" name="key"></p>
+<p>email: <input type="text" name="email"></p>
+<p><input type="submit"></p>
+</form>