From 76f208ddcc490280885c3fd2fd2917e6be0b65b5 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Wed, 30 Dec 2015 20:18:45 -0500
Subject: + Created db table child class for User table

---
 app/class/user.class.php | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 app/class/user.class.php

(limited to 'app')

diff --git a/app/class/user.class.php b/app/class/user.class.php
new file mode 100644
index 0000000..8ef91ae
--- /dev/null
+++ b/app/class/user.class.php
@@ -0,0 +1,30 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * Application users
+ */
+class User extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "key",
+            "salt",
+            "alias",
+            "email",
+            "emailConf",
+            "emailConfKey"
+        );
+
+        parent::__construct("user", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 58dacd8e07d8d8eddf0d5c0a598a5eae27796473 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Wed, 30 Dec 2015 20:49:36 -0500
Subject: + Created class file for extern-user table

---
 app/class/externuser.class.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 app/class/externuser.class.php

(limited to 'app')

diff --git a/app/class/externuser.class.php b/app/class/externuser.class.php
new file mode 100644
index 0000000..8f5c9d0
--- /dev/null
+++ b/app/class/externuser.class.php
@@ -0,0 +1,26 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * Non-application users
+ */
+class ExternUser extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "email",
+            "emailConfKey"
+        );
+
+        parent::__construct("extern-user", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 00b391ab20e1b0d6e65bfe907819bceef3d1ed84 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Wed, 30 Dec 2015 22:51:42 -0500
Subject: + Added class file for group table

---
 app/class/group.class.php | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 app/class/group.class.php

(limited to 'app')

diff --git a/app/class/group.class.php b/app/class/group.class.php
new file mode 100644
index 0000000..2f3af40
--- /dev/null
+++ b/app/class/group.class.php
@@ -0,0 +1,20 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * User groups
+ */
+class Group extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        parent::__construct();
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 3231db3d578c510d130b1377d3809228a273b118 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Thu, 31 Dec 2015 20:13:26 -0500
Subject: + Added class file for Pad table

---
 app/class/pad.class.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 app/class/pad.class.php

(limited to 'app')

diff --git a/app/class/pad.class.php b/app/class/pad.class.php
new file mode 100644
index 0000000..335ef63
--- /dev/null
+++ b/app/class/pad.class.php
@@ -0,0 +1,26 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * Scrott pads
+ */
+class Pad extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "stage",
+            "nextIssueNumber"
+        );
+
+        parent::__construct("pad", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 231a312a77f7f774b48fb5700bea780b274ed82a Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Thu, 31 Dec 2015 23:02:23 -0500
Subject: + Added class file for stage table

---
 app/class/stage.class.php | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 app/class/stage.class.php

(limited to 'app')

diff --git a/app/class/stage.class.php b/app/class/stage.class.php
new file mode 100644
index 0000000..a2dfba5
--- /dev/null
+++ b/app/class/stage.class.php
@@ -0,0 +1,25 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * Pad stages
+ */
+class Stage extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "stage"
+        );
+
+        parent::__construct("stage", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From c139f96610ba12f5035f1c3a18448a290714d851 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Fri, 1 Jan 2016 00:08:50 -0500
Subject: + Added class file for issue table

---
 app/class/issue.class.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 app/class/issue.class.php

(limited to 'app')

diff --git a/app/class/issue.class.php b/app/class/issue.class.php
new file mode 100644
index 0000000..90a095c
--- /dev/null
+++ b/app/class/issue.class.php
@@ -0,0 +1,28 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * Pad issues
+ */
+class Issue extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "number",
+            "assignee",
+            "unread",
+            "desc"
+        );
+
+        parent::__construct("issue", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 4f2f824cfef24b572994c9831dd4bf4bbc575dc1 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Fri, 1 Jan 2016 14:27:53 -0500
Subject: + Added class file for message table

---
 app/class/message.class.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 app/class/message.class.php

(limited to 'app')

diff --git a/app/class/message.class.php b/app/class/message.class.php
new file mode 100644
index 0000000..d39bea8
--- /dev/null
+++ b/app/class/message.class.php
@@ -0,0 +1,26 @@
+<?php
+
+require_once "class/object.class.php";
+
+/*
+ * User messages and log messages
+ */
+class Message extends Object
+{
+    /*
+     * Constructor
+     */
+    function __construct($guid = null)
+    {
+        $cols = array(
+            "guid",
+            "author",
+            "message"
+        );
+
+        parent::__construct("message", $cols);
+        $this->loadObj($guid);
+    }
+}
+
+?>
-- 
cgit v1.2.3


From 0a92a484554f214d0e499c872807e6b0a3e865ad Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Fri, 1 Jan 2016 16:50:22 -0500
Subject: + Added class file for setting table

---
 app/class/framework.class.php |  2 +-
 app/class/setting.class.php   | 28 ++++++++++++++++++++++++++++
 2 files changed, 29 insertions(+), 1 deletion(-)
 create mode 100644 app/class/setting.class.php

(limited to 'app')

diff --git a/app/class/framework.class.php b/app/class/framework.class.php
index eea6c25..d1293de 100644
--- a/app/class/framework.class.php
+++ b/app/class/framework.class.php
@@ -50,7 +50,7 @@ abstract class Framework
     /*
      * Get or create the app's database connection object (this is a singleton object and dependent on system-level config)
      */
-    function getDbConnection()
+    static function getDbConnection()
     {
         global $_SCROTT;
 
diff --git a/app/class/setting.class.php b/app/class/setting.class.php
new file mode 100644
index 0000000..ea5fac3
--- /dev/null
+++ b/app/class/setting.class.php
@@ -0,0 +1,28 @@
+<?php
+
+require_once "class/framework.class.php";
+
+/*
+ * Scrott administrative settings
+ */
+class Setting extends Framework
+{
+    /*
+     * Helper function for getting setting values from the database
+     */
+    static function getValue($key)
+    {
+        $db = parent::getDbConnection();
+        $escdKey = $db->esc($key);
+
+        $query = "SELECT `value` FROM `setting` WHERE `key` = '" . $escdKey . "'";
+        $res = $db->query($query);
+
+        if (count($res) == 0)
+            return false;
+
+        return $res[0]['value'];
+    }
+}
+
+?>
-- 
cgit v1.2.3