Series: Started work on Series Control

Refs #28

1 files changed, 43 insertions, 0 deletions

@@ -0,0 +1,43 @@
+<?php
+
+/* InstaDisc Series - A Four Island Project */
+
+include('includes/db.php');
+include('includes/template.php');
+
+function instaDisc_subscriptionExists($id)
+{
+        $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($id) . "\"";
+        $getsub2 = mysql_query($getsub);
+        $getsub3 = mysql_fetch_array($getsub2);
+        if ($getsub3['identity'] != $id)
+        {
+                return 'false';
+        } else {
+                return 'true';
+        }
+}
+
+function instaDisc_getSubscription($id)
+{
+        $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($id) . "\"";
+        $getsub2 = mysql_query($getsub);
+        $getsub3 = mysql_fetch_array($getsub2);
+
+        return $getsub3;
+}
+
+function instaDisc_getAllSubscriptions()
+{
+        $getsubs = "SELECT * FROM subscriptions";
+        $getsubs2 = mysql_query($getsubs);
+        $i=0;
+        while ($getsubs3[$i] = mysql_fetch_array($getsubs2))
+        {
+                $i++;
+        }
+
+        return $getsubs3;
+}
+
+?>