1 files changed, 72 insertions, 0 deletions

@@ -0,0 +1,72 @@
+<?php
+
+/* InstaDisc Series - A Four Island Project */
+
+include('includes/db.php');
+include('includes/template.php');
+include('includes/xmlrpc/xmlrpc.inc');
+include('includes/xmlrpc/xmlrpcs.inc');
+
+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;
+}
+
+function instaDisc_getConfig($name)
+{
+        $getconfig = "SELECT * FROM config WHERE name = \"" . mysql_real_escape_string($name) . "\"";
+        $getconfig2 = mysql_query($getconfig);
+        $getconfig3 = mysql_fetch_array($getconfig2);
+
+        return $getconfig3['value'];
+}
+
+function instaDisc_verifyUser($username, $password)
+{
+        return (($username == instaDisc_getConfig('adminUser')) && (md5($password) == instaDisc_getConfig('adminPass')));
+}
+
+function instaDisc_changePassword($password)
+{
+        $setconfig = "UPDATE config SET value = \"" . mysql_real_escape_string(md5($password)) . "\" WHERE name = \"adminPass\"";
+        $setconfig2 = mysql_query($setconfig);
+        $setconfig3 = mysql_fetch_array($setconfig2);
+}
+
+function instaDisc_addSubscription($id, $title, $url, $category, $password = '')
+{
+        $inssub = "INSERT INTO subscriptions (identity, title, url, category, password, personal) VALUES (\"" . mysql_real_escape_string($id) . "\",\"" . mysql_real_escape_string($title) . "\",\"" . mysql_real_escape_string($url) . "\",\"" . mysql_real_escape_string($category) . "\",\"" . mysql_real_escape_string(($password == '' ? '' : md5($password))) . "\",\"false\")";
+        $inssub2 = mysql_query($inssub);
+}
+
+?>