Add more to access tab

diff --git a/plugins/sql_auth/SQL/user.php b/plugins/sql_auth/SQL/user.php
index 440cb9c8f9ab31a6e02da9e16df642f2cfd20f0d..f9c248bbe147639718390eb7d16f2b3203fa1a2c 100644 (file)
--- a/plugins/sql_auth/SQL/user.php
+++ b/plugins/sql_auth/SQL/user.php
@@ -7,7 +7,9 @@ class SQLA_User
     private $passhash = NULL;
     public $first_name = NULL;
     public $last_name = NULL;
+    public $created = NULL;
     public $user_meta = [];
+    public $bio = NULL;
 
     /**
      * Find a user in the database by name or ID
@@ -38,6 +40,8 @@ class SQLA_User
             $this->passhash = $data['user_pass'];
             $this->first_name = $data['user_fname'] ?? NULL;
             $this->last_name = $data['user_lname'] ?? NULL;
+            $this->created = $data['created'];
+            $this->bio = $data['user_bio'];
             $this->user_meta = (new SQLA_User_Meta($this->id))->list;
         }
     }
@@ -92,10 +96,11 @@ function create_new_user(array $user) : bool
     $password = password_hash($user['user_pass'], PASSWORD_ARGON2ID);
     $first_name = (isset($user['fname'])) ? $user['fname'] : NULL;
     $last_name = (isset($user['lname'])) ? $user['lname'] : NULL;
+    
 
     $conn = sqlnew();
-    $prep = $conn->prepare("INSERT INTO " . SQL_PREFIX . "users (user_name, user_pass, user_fname, user_lname) VALUES (:name, :pass, :fname, :lname)");
-    $prep->execute(["name" => $username, "pass" => $password, "fname" => $first_name, "lname" => $last_name]);
+    $prep = $conn->prepare("INSERT INTO " . SQL_PREFIX . "users (user_name, user_pass, user_fname, user_lname, created) VALUES (:name, :pass, :fname, :lname, :created)");
+    $prep->execute(["name" => $username, "pass" => $password, "fname" => $first_name, "lname" => $last_name, "created" => date("Y-m-d H:i:s")]);
     
     return true;
 }

diff --git a/plugins/sql_auth/index.php b/plugins/sql_auth/index.php
index 54568e22c7e6670ba3f2b0666073dd65d398f9ef..97602cbc801f489d1463f4b531721c5bf3ba8499 100644 (file)
--- a/plugins/sql_auth/index.php
+++ b/plugins/sql_auth/index.php
@@ -7,12 +7,6 @@ require_once "SQL/sql.php";
 require_once "SQL/user.php";
 do_log($_POST);
 
-if (isset($_POST))
-{
-    $p = $_POST;
-    
-}
-var_dump($_POST);
 
 $conn = sqlnew();
 $result = $conn->query("SELECT user_id FROM " . SQL_PREFIX . "users");
@@ -29,7 +23,16 @@ while($row =  $result->fetch())
 }
 ?>
 <h4>Panel Access Overview</h4>
+<?php
+    if (isset($_POST))
+    {
+        $p = $_POST;
+        if (isset($p['do_add_user']))
+        {
 
+        }        
+    }
+?>
 Click on a username to view more information.
 <br><br>
 <div id="Users">
@@ -37,7 +40,8 @@ Click on a username to view more information.
             <form method="post">
 <p><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#myModal">
                        Add New User
-       </button></p></table>
+       </button></p>
+</table>
        <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="confirmModalCenterTitle" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered" role="document">
                <div class="modal-content">
@@ -48,18 +52,30 @@ Click on a username to view more information.
                        </button>
                </div>
                <div class="modal-body">
-               
-                <div class="align_label">Username: </div> <input class="curvy" type="text" id="user_add" name="user_add"><br>
-                <div class="align_label">Password: </div> <input class="curvy" type="password" name="password" id="password"><br>
-                <div class="align_label">Confirm: </div> <input class="curvy" type="password" name="confirm_password" id="confirm_password"><br>
-                <div class="align_label">First Name: </div> <input class="curvy" type="text" name="add_first_name" id="add_first_name"><br>
-                <div class="align_label">Last Name: </div> <input class="curvy" type="text" name="add_last_name" id="add_last_name"><br>
-                <div class="align_label">Info/Bio: </div> <input class="curvy" type="text" name="add_bio" id="add_bio"><br>
+            <div class="input-group mb-3">
+                <label for="name_add"  name="user_add" id="user_add">Username
+                    <input style="width: 170%;" name="user_add" id="user_add" class="form-control curvy" type="text"></label>
+            </div>
+            <div class="input-group mb-3">
+                <label for="password" id="user_add">Password
+                    <input style="width: 170%;" name="password" id="password" class="form-control curvy" type="password"></label>
+            </div>
+            <div class="input-group mb-3">
+                <label for="add_first_name" id="user_add">First Name
+                    <input style="width: 170%;" name="add_first_name" id="add_first_name" class="form-control curvy" type="text"></label>
+            </div><div class="input-group mb-3">
+                <label for="password" id="user_add">Last Name
+                    <input style="width: 170%;" name="add_last_name" id="add_last_name" class="form-control curvy" type="text"></label>
+            </div>
+            <div class="input-group mb-3">
+                <label for="password" id="user_add">Info /Bio
+                    <textarea style="width: 170%;" name="user_bio" class="form-control curvy" aria-label="With textarea"></textarea></label>
+            </div>
         </div>
                                                
                <div class="modal-footer">
                        <button id="CloseButton" type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
-                       <button type="submit" class="btn btn-danger">Add User</button>
+                       <button type="submit" name="do_add_user" class="btn btn-danger">Add User</button>
                        
                </div>
                </div>
@@ -73,16 +89,21 @@ Click on a username to view more information.
        <th scope="col">Username</th>
        <th scope="col">First Name</th>
        <th scope="col">Last Name</th>
+    <th scope="col">Created</th>
+    <th scope="col">Bio</th>
+    
        </thead>
        <tbody>
        <?php
                foreach($userlist as $user)
                {
                        
-                       echo "<td scope=\"col\"><input type=\"checkbox\" value='" .base64_encode($user->id) . "' name=\"sqluser[]\"></td>";
+                       echo "<td scope=\"col\"><input type=\"checkbox\" value='" .$user->id . "' name=\"userch[]\"></td>";
                        echo "<td scope=\"col\">".$user->username."</td>";
                        echo "<td scope=\"col\">".$user->first_name."</td>";
                        echo "<td scope=\"col\">".$user->last_name."</td>";
+                       echo "<td scope=\"col\">".$user->created."</td>";
+                       echo "<td scope=\"col\">".$user->bio."</td>";
                        echo "</tr>";
                }
        ?></tbody></table><p><button type="button" class="btn btn-danger" data-toggle="modal" data-target="#myModal2">
@@ -103,7 +124,7 @@ Click on a username to view more information.
                </div>
                <div class="modal-footer">
                        <button id="CloseButton" type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
-                       <button type="submit" action="post" class="btn btn-danger">Delete</button>
+                       <button type="submit" action="post" name="delete_user" class="btn btn-danger">Delete</button>
                        
                </div>
                </div>