From f2753472d759af4a08320290e454e7bcbe9a9bf3 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Sun, 3 Aug 2008 20:08:22 +0000
Subject: Central: Added Subscription ownership functions

---
 central/trunk/instadisc.php | 106 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 106 insertions(+)

(limited to 'central/trunk/instadisc.php')

diff --git a/central/trunk/instadisc.php b/central/trunk/instadisc.php
index 98a9385..de0a90e 100644
--- a/central/trunk/instadisc.php
+++ b/central/trunk/instadisc.php
@@ -239,4 +239,110 @@ function instaDisc_getConfig($key)
 	return $getconfig3['value'];
 }
 
+function instaDisc_listSubscriptions($username)
+{
+	$getsubs = "SELECT * FROM subscriptions WHERE username = \"" . mysql_escape_string($username) . "\" AND owner = \"true\"";
+	$getsubs2 = mysql_query($getsubs);
+	$i=0;
+	while ($getsubs3[$i] = mysql_fetch_array($getsubs2))
+	{
+		$subs[$i] = $getsubs3[$i]['url'];
+
+		$i++;
+	}
+
+	$subs['size'] = $i;
+	return $subs;
+}
+
+function instaDisc_addSubscription($username, $url)
+{
+	$getcode = "SELECT * FROM pending2 WHERE username = \"" . mysql_escape_string($username) . "\" AND url = \"" . mysql_escape_string($url) . "\"";
+	$getcode2 = mysql_query($getcode);
+	$getcode3 = mysql_fetch_array($getcode2);
+	if ($getcode3['username'] == $username)
+	{
+		$delcode = "DELETE FROM pending2 WHERE username = \"" . mysql_escape_string($username) . "\" AND url = \"" . mysql_escape_string($url) . "\"";
+		$delcode2 = mysql_query($delcode);
+
+		$c = curl_init();
+		curl_setopt($c, CURLOPT_URL, $url);
+		curl_setopt($c, CURLOPT_HEADER, false);
+		curl_setopt($c, CURLOPT_RETURNTRANSFER, true);
+		$page_data = curl_exec($c);
+		curl_close($c);
+
+		$headers = split("\n", $page_date);
+		foreach ($headers as $name => $value)
+		{
+			$header = split(": ", $value);
+			$headerMap[$header[0]] = $header[1];
+		}
+
+		if (isset($header['Subscription']))
+		{
+			if (isset($header['Title']))
+			{
+				if (isset($header['Category']))
+				{
+					if (isset($header['Key']))
+					{
+						if ($header['Key'] == $getcode3['code'])
+						{
+							$inssub = "INSERT INTO subscriptions (username,url,owner) VALUES (\"" . mysql_escape_string($username) . "\", \"" . mysql_escape_string($header['Subscription']) . "\", \"true\")";
+							$inssub2 = mysql_query($inssub);
+
+							return true;
+						}
+					}
+				}
+			}
+		}
+	}
+
+	return false;
+}
+
+function instaDisc_listPendingSubscriptions($username)
+{
+	$getsubs = "SELECT * FROM pending2 WHERE username = \"" . mysql_escape_string($username) . "\"";
+	$getsubs2 = mysql_query($getsubs);
+	$i=0;
+	while ($getsubs3[$i] = mysql_fetch_array($getsubs2))
+	{
+		$subs[$i] = array('url' => $getsubs3[$i]['url'], 'key' => $getsubs3[$i]['key']);
+
+		$i++;
+	}
+
+	$subs['size'] = $i;
+	return $subs;
+}
+
+function instaDisc_generateSubscriptionActivation($username, $url)
+{
+	$key = md5(rand(1,65536));
+
+	$inspending = "INSERT INTO pending2 (username, url, key) VALUES (\"" . mysql_escape_string($username) . "\", \"" . mysql_escape_string($url) . "\", \"" . mysql_escape_string($key) . "\")";
+	$inspending2 = mysql_query($inspending);
+
+	return $key;
+}
+
+function instaDisc_deleteSubscription($username, $url)
+{
+	$delsub = "DELETE FROM subscriptions WHERE username = \"" . mysql_escape_string($username) . "\" AND url = \"" . mysql_escape_string($url) . "\")";
+	$delsub2 = mysql_query($delsub);
+
+	return true;
+}
+
+function instaDisc_cancelSubscription($username, $url)
+{
+	$delsub = "DELETE FROM pending2 WHERE username = \"" . mysql_escape_string($username) . "\" AND url = \"" . mysql_escape_string($url) . "\")";
+	$delsub2 = mysql_query($delsub);
+
+	return true;
+}
+
 ?>
-- 
cgit 1.4.1