Series: Integrated Update

Refs #55

1 files changed, 28 insertions, 1 deletions

@@ -39,7 +39,34 @@ function sendFromUpdate($username, $verification, $verificationID, $seriesURL, $
 {
         if (instaDisc_checkVerification($username, $verification, $verificationID, 'users', 'username', 'password'))
         {
-                
+                $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($seriesID) . "\"";
+                $getsub2 = mysql_query($getsub);
+                $getsub3 = mysql_fetch_array($getsub2);
+                if ($getsub3['identity'] == $seriesID)
+                {
+                        if ($getsub3['username'] != $username)
+                        {
+                                return new xmlrpcresp(new xmlrpcval('1', 'int'));
+                        }
+
+                        $setsub = "UPDATE subscriptions SET title = \"" . mysql_real_escape_string($subscriptionTitle) . "\", url = \"" . mysql_real_escape_string($subscriptionURL) . "\", category = \"" . mysql_real_escape_string($subscriptionCategory) . "\", personal = \"" . mysql_real_escape_string($subscriptionPersonal) . "\"";
+                        $setsub2 = mysql_query($setsub);
+                } else {
+                        $inssub = "INSERT INTO subscriptions (identity, title, url, category, personal, username) VALUES (\"" . mysql_real_escape_string($seriesID) . "\",\"" . mysql_real_escape_string($subscriptionTitle) . "\",\"" . mysql_real_escape_string($subscriptionURL) . "\",\"" . mysql_real_escape_string($subscriptionCategory) . "\",\"" . mysql_real_escape_string($subscriptionPersonal) . "\",\"" . mysql_real_escape_string($username) . "\")";
+                        $inssub2 = mysql_query($inssub);
+                }
+
+                $client = xmlrpc_client('http://central.fourisland.com/xmlrpc.php');
+                $msg = new xmlrpcmsg("InstaDisc.sendFromSeries", array( new xmlrpcval($seriesURL, 'string'),
+                                                                        new xmlrpcval($seriesID, 'string'),
+                                                                        new xmlrpcval($title, 'string'),
+                                                                        new xmlrpcval($author, 'string'),
+                                                                        new xmlrpcval($url, 'string'),
+                                                                        new xmlrpcval($semantics, 'string'),
+                                                                        new xmlrpcval($encryptionID, 'int')));
+                $client->send($msg);
+
+                return new xmlrpcresp(new xmlrpcval('0', 'int'));
         } else {
                 return new xmlrpcresp(new xmlrpcval('2', 'int'));
         }