From 44c3bc48b5db7b3dc6517d2b073a55af5d4b52db Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 10 Sep 2008 21:06:49 +0000
Subject: Series: Moved around directory structure

Refs #55
---
 series/trunk/includes/instadisc.php | 72 +++++++++++++++++++++++++++++++++++++
 1 file changed, 72 insertions(+)
 create mode 100644 series/trunk/includes/instadisc.php

(limited to 'series/trunk/includes/instadisc.php')

diff --git a/series/trunk/includes/instadisc.php b/series/trunk/includes/instadisc.php
new file mode 100644
index 0000000..dd879c6
--- /dev/null
+++ b/series/trunk/includes/instadisc.php
@@ -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);
+}
+
+?>
-- 
cgit 1.4.1