Series: Added user management

Refs #53

14 files changed, 379 insertions, 2 deletions

@@ -77,8 +77,8 @@ function showForm($id, $title, $url, $category, $password, $errors)
         $template->add('ID_ERR', ifErrors($errors, 'id'));
         $template->add('TITLE_ERR', ifErrors($errors, 'title'));
         $template->add('URL_ERR', ifErrors($errors, 'url'));
-        $template->add('CATEGORY_ERR', ifErrors($errors, 'url'));
-        $template->add('PASSWORD_ERR', ifErrors($errors, 'url'));
+        $template->add('CATEGORY_ERR', ifErrors($errors, 'category'));
+        $template->add('PASSWORD_ERR', ifErrors($errors, 'password'));
 
         doErrors($template, $errors, 'id');
         doErrors($template, $errors, 'title');
@@ -0,0 +1,110 @@
+<?php
+
+/* InstaDisc Series - A Four Island Project */
+
+/** 
+ * require_once() is used to ensure
+ * the ACP files are being called by
+ * admin.php instead of their actual
+ * locations admin/.
+ * The _once() part ensures no problem
+ * arises as includes/instadisc.php has
+ * already been included from admin.php
+ */
+require_once('includes/instadisc.php');
+
+if (!isset($_SESSION['username']))
+{
+        header('Location: index.php');
+        exit;
+}
+
+if (!isset($_GET['submit']))
+{
+        showForm('','',array());
+} else {
+        $numOfErrors = 0;
+        $errors = array();
+
+        if ($_POST['username'] == '')
+        {
+                addError($numOfErrors, $errors, 'username', 'Username is a required field');
+        }
+
+        if ($_POST['password'] == '')
+        {
+                addError($numOfErrors, $errors, 'password', 'Password is a required field');
+        }
+
+        if ($numOfErrors > 0)
+        {
+                showForm($_POST['username'], $_POST['password'], $errors);
+        } else {
+                instaDisc_addUser($_POST['username'], $_POST['password']);
+
+                $template = new FITemplate('addeduser');
+                $template->add('SITENAME', instaDisc_getConfig('siteName'));
+                $template->display();
+        }
+}
+
+function showForm($username, $password, $errors)
+{
+        $template = new FITemplate('adduser');
+        $template->add('SITENAME', instaDisc_getConfig('siteName'));
+
+        if (isset($errors[1]))
+        {
+                $template->adds_block('ERROR', array('ex'=>'1'));
+
+                foreach ($errors as $name => $value)
+                {
+                        $template->adds_block('ERRORS', array(  'NAME' => $name,
+                                                                'MSG' => $value['msg']));
+                }
+        }
+
+        $template->add('USERNAME_ERR', ifErrors($errors, 'username'));
+        $template->add('PASSWORD_ERR', ifErrors($errors, 'password'));
+
+        doErrors($template, $errors, 'username');
+        doErrors($template, $errors, 'password');
+
+        $template->add('USERNAME', $username);
+        $template->add('PASSWORD', $password);
+
+        $template->display();
+}
+
+function ifErrors($errors, $id)
+{
+        foreach ($errors as $name => $value)
+        {
+                if ($value['field'] == $id)
+                {
+                        return ' error';
+                }
+        }
+
+        return '';
+}
+
+function doErrors($template, $errors, $id)
+{
+        foreach ($errors as $name => $value)
+        {
+                if ($value['field'] == $id)
+                {
+                        $template->adds_block(strtoupper($id) . '_ERRS', array( 'NAME' => $name,
+                                                                                'VALUE' => $value['msg']));
+                }
+        }
+}
+
+function addError(&$numOfErrors, &$errors, $field, $msg)
+{
+        $numOfErrors++;
+        $errors[$numOfErrors] = array('field' => $field, 'msg' => $msg);
+}
+
+?>
@@ -16,6 +16,7 @@ require_once('includes/instadisc.php');
 if (!isset($_SESSION['username']))
 {
         header('Location: index.php');
+        exit;
 }
 
 if (isset($_SESSION['username']))
@@ -65,6 +66,7 @@ if (isset($_SESSION['username']))
         }
 } else {
         header('Location: index.php');
+        exit;
 }
 
 function showForm($old, $new, $confirm, $errors)
@@ -16,6 +16,7 @@ require_once('includes/instadisc.php');
 if (!isset($_SESSION['username']))
 {
         header('Location: index.php');
+        exit;
 }
 
 if (!instaDisc_isAdmin($_SESSION['username']))
@@ -0,0 +1,49 @@
+<?php
+
+/* InstaDisc Series - A Four Island Project */
+
+/** 
+ * require_once() is used to ensure
+ * the ACP files are being called by
+ * admin.php instead of their actual
+ * locations admin/.
+ * The _once() part ensures no problem
+ * arises as includes/instadisc.php has
+ * already been included from admin.php
+ */
+require_once('includes/instadisc.php');
+
+if (!isset($_SESSION['username']))
+{
+        header('Location: index.php');
+        exit;
+}
+
+if (!instaDisc_isAdmin($_SESSION['username']))
+{
+        header('Location: index.php');
+        exit;
+}
+
+if (!isset($_GET['submit']))
+{
+        $template = new FITemplate('deleteuser');
+        $template->add('SITENAME',instaDisc_getConfig('siteName'));
+        $template->add('ID',$_GET['userid']);
+
+        $sub = instaDisc_getUserByID($_GET['userid']);
+        $template->add('USERNAME',$sub['username']);
+        $template->display();
+} else {
+        if ($_POST['submit'] == 'Yes')
+        {
+                instaDisc_deleteUser($_POST['id']);
+                
+                $template = new FITemplate('deleteduser');
+                $template->display();
+        } else {
+                header('Location: admin.php?id=main');
+        }
+}
+
+?>
@@ -16,6 +16,7 @@ require_once('includes/instadisc.php');
 if (!isset($_SESSION['username']))
 {
         header('Location: index.php');
+        exit;
 }
 
 $template = new FITemplate('main');
@@ -16,6 +16,7 @@ require_once('includes/instadisc.php');
 if (!isset($_SESSION['username']))
 {
         header('Location: index.php');
+        exit;
 }
 
 $template = new FITemplate('mansub');
@@ -0,0 +1,46 @@
+<?php
+
+/* InstaDisc Series - A Four Island Project */
+
+/** 
+ * require_once() is used to ensure
+ * the ACP files are being called by
+ * admin.php instead of their actual
+ * locations admin/.
+ * The _once() part ensures no problem
+ * arises as includes/instadisc.php has
+ * already been included from admin.php
+ */
+require_once('includes/instadisc.php');
+
+if (!isset($_SESSION['username']))
+{
+        header('Location: index.php');
+        exit;
+}
+
+$template = new FITemplate('manuser');
+$template->add('SITENAME', instaDisc_getConfig('siteName'));
+
+if (instaDisc_isAdmin($_SESSION['username']))
+{
+        $users = instaDisc_getAllUsers();
+} else {
+        header('Location: index.php');
+        exit;
+}
+$i=0; $j=0;
+for ($i=0;isset($users[$i]);$i++)
+{
+        $j++;
+}
+$j--;
+for ($i=0;$i<$j;$i++)
+{
+        $template->adds_block('USERS', array(   'USERNAME' => $users[$i]['username'],
+                                                'ID' => $users[$i]['id']));
+}
+
+$template->display();
+
+?>
@@ -130,4 +130,29 @@ function instaDisc_getSubscriptionByID($id)
         return $getsub3;
 }
 
+function instaDisc_addUser($username, $password)
+{
+        $insuser = "INSERT INTO users (username,password) VALUES (\"" . mysql_real_escape_string($username) . "\",\"" . mysql_real_escape_string(md5($password)) . "\")";
+        $insuser2 = mysql_query($insuser);
+}
+
+function instaDisc_deleteUser($id)
+{
+        $deluser = "DELETE FROM users WHERE id = " . $id;
+        $deluser2 = mysql_query($deluser);
+}
+
+function instaDisc_getAllUsers()
+{
+        $getusers = "SELECT * FROM users";
+        $getusers2 = mysql_query($getusers);
+        $i=0;
+        while ($getusers3[$i] = mysql_fetch_array($getusers2))
+        {
+                $i++;
+        }
+
+        return $getusers3;
+}
+
 ?>
@@ -0,0 +1,13 @@
+<HTML>
+        <HEAD>
+                <TITLE><!--SITENAME--> InstaDisc Series Control</TITLE>
+        </HEAD>
+
+        <BODY>
+                <CENTER>
+                        <H1>InstaDisc Add User</H1>
+
+                        <P>You've successfully added a user! <A HREF="admin.php">Back to the ACP</A>
+                </CENTER>
+        </BODY>
+</HTML>
@@ -0,0 +1,61 @@
+<HTML>
+        <HEAD>
+                <TITLE><!--SITENAME--> InstaDisc Series Control</TITLE>
+                <LINK REL="stylesheet" TYPE="text/css" HREF="theme/uniform.css">
+        </HEAD>
+
+        <BODY>
+                <CENTER>
+                        <H1>InstaDisc Add User</H1>
+
+                        <P>If you would like to add a new user to Series Control, please fill out the form below.
+                </CENTER>
+
+                <FORM CLASS="uniform" ACTION="./admin.php?id=adduser&amp;submit=" METHOD="POST">
+
+                        <!--BEGIN ERROR-->
+                        <DIV ID="errorMsg">Uh oh! Validation errors!<P>
+                                <OL>
+                        <!--END ERROR-->
+
+                        <!--BEGIN ERRORS-->
+                                        <LI><A HREF="#error<!--ERRORS.NAME-->"><!--ERRORS.MSG--></A></LI>
+                        <!--END ERRORS-->
+
+                        <!--BEGIN ERROR-->
+                                </OL>
+                        </DIV>
+                        <!--END ERROR-->
+
+                        <FIELDSET CLASS="inlineLabels">
+                                <LEGEND>User Info</LEGEND>
+
+                                <DIV CLASS="ctrlHolder<!--USERNAME_ERR-->">
+                                        <!--BEGIN USERNAME_ERRS-->
+                                                <P ID="error<!--USERNAME_ERRS.NAME-->" CLASS="errorField"><EM>*</EM>
+                                                        <!--USERNAME_ERRS.MSG-->
+                                                </P>
+                                        <!--END USERNAME_ERRS-->
+
+                                        <LABEL FOR="username"><EM>*</EM> Username: </LABEL>
+                                        <INPUT TYPE="text" ID="username" NAME="username" CLASS="textInput" VALUE="<!--USERNAME-->">
+                                </DIV>
+
+                                <DIV CLASS="ctrlHolder<!--PASSWORD_ERR-->">
+                                        <!--BEGIN PASSWORD_ERRS-->
+                                                <P ID="error<!--PASSWORD_ERRS.NAME-->" CLASS="errorField"><EM>*</EM>
+                                                        <!--PASSWORD_ERRS.MSG-->
+                                                </P>
+                                        <!--END PASSWORD_ERRS-->
+
+                                        <LABEL FOR="password">Password: </LABEL>
+                                        <INPUT TYPE="password" ID="password" NAME="password" CLASS="textInput" VALUE="<!--PASSWORD-->">
+                                </DIV>
+                        </FIELDSET>
+
+                        <DIV CLASS="buttonHolder">
+                                <INPUT TYPE="submit" NAME="submit" VALUE="Submit">
+                        </DIV>
+                </FORM>
+        </BODY>
+</HTML>
@@ -0,0 +1,15 @@
+<HTML>
+        <HEAD>
+                <TITLE><!--SITENAME--> InstaDisc Series Control</TITLE>
+        </HEAD>
+
+        <BODY>
+                <CENTER>
+                        <H1>InstaDisc User Deletion</H1>
+
+                        <P>You have successfully deleted your user!
+
+                        <P><A HREF="admin.php?id=main">Back to User Panel</A>
+                </CENTER>
+        </BODY>
+</HTML>
@@ -0,0 +1,21 @@
+<HTML>
+        <HEAD>
+                <TITLE><!--SITENAME--> InstaDisc Series Control</TITLE>
+        </HEAD>
+
+        <BODY>
+                <CENTER>
+                        <H1>InstaDisc User Deletion</H1>
+
+                        <P>Are you sure you would like to delete <!--USERNAME-->?
+
+                        <FORM ACTION="./admin.php?id=deleteuser&amp;submit=" METHOD="POST">
+                                <INPUT TYPE="hidden" NAME="id" VALUE="<!--ID-->">
+                                <INPUT TYPE="submit" NAME="submit" VALUE="Yes">
+                                <INPUT TYPE="submit" NAME="submit" VALUE="No">
+                        </FORM>
+                </CENTER>
+        </BODY>
+</HTML>
+
+
@@ -0,0 +1,32 @@
+<HTML>
+        <HEAD>
+                <TITLE><!--SITENAME--> InstaDisc Series Control</TITLE>
+                <LINK REL="stylesheet" HREF="theme/table.css">
+        </HEAD>
+
+        <BODY>
+                <CENTER>
+                        <H1>InstaDisc User Management</H1>
+
+                        <P>You can manage your users here.
+
+                        <TABLE>
+                                <TR>
+                                        <TH>Username</TH>
+                                        <TH>Actions</TH>
+                                </TR>
+
+                                <!--BEGIN USERS-->
+                                <TR>
+                                        <TD><!--USERS.USERNAME--></TD>
+                                        <TD>
+                                                <A HREF="admin.php?id=deleteuser&amp;userid=<!--USERS.ID-->">Delete</A>
+                                        </TD>
+                                </TR>
+                                <!--END USERS-->
+                        </TABLE>
+
+                        <P><A HREF="admin.php?id=main">Back to User Panel</A>
+                </CENTER>
+        </BODY>
+</HTML>