diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2008-09-18 21:59:23 +0000 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2008-09-18 21:59:23 +0000 |
| commit | fd3f2cbdaa1e3c160727c3cf09ef03d06174c114 (patch) | |
| tree | 12ea30a00c68891f2fbc01f5b2730bc6edc153aa /series/trunk/includes/instadisc.php | |
| parent | d2a7b26e98569624347d717d7fdfe6c3074658a9 (diff) | |
| download | instadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.tar.gz instadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.tar.bz2 instadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.zip | |
Series: Removed Series component
Refs #57
Diffstat (limited to 'series/trunk/includes/instadisc.php')
| -rw-r--r-- | series/trunk/includes/instadisc.php | 167 |
1 files changed, 0 insertions, 167 deletions
| diff --git a/series/trunk/includes/instadisc.php b/series/trunk/includes/instadisc.php deleted file mode 100644 index f4aed39..0000000 --- a/series/trunk/includes/instadisc.php +++ /dev/null | |||
| @@ -1,167 +0,0 @@ | |||
| 1 | <?php | ||
| 2 | |||
| 3 | /* InstaDisc Series - A Four Island Project */ | ||
| 4 | |||
| 5 | include('includes/db.php'); | ||
| 6 | include('includes/template.php'); | ||
| 7 | include('includes/xmlrpc/xmlrpc.inc'); | ||
| 8 | include('includes/xmlrpc/xmlrpcs.inc'); | ||
| 9 | |||
| 10 | function instaDisc_subscriptionExists($id) | ||
| 11 | { | ||
| 12 | $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($id) . "\""; | ||
| 13 | $getsub2 = mysql_query($getsub); | ||
| 14 | $getsub3 = mysql_fetch_array($getsub2); | ||
| 15 | if ($getsub3['identity'] != $id) | ||
| 16 | { | ||
| 17 | return 'false'; | ||
| 18 | } else { | ||
| 19 | return 'true'; | ||
| 20 | } | ||
| 21 | } | ||
| 22 | |||
| 23 | function instaDisc_getSubscription($id) | ||
| 24 | { | ||
| 25 | $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($id) . "\""; | ||
| 26 | $getsub2 = mysql_query($getsub); | ||
| 27 | $getsub3 = mysql_fetch_array($getsub2); | ||
| 28 | |||
| 29 | return $getsub3; | ||
| 30 | } | ||
| 31 | |||
| 32 | function instaDisc_getAllSubscriptions() | ||
| 33 | { | ||
| 34 | $getsubs = "SELECT * FROM subscriptions"; | ||
| 35 | $getsubs2 = mysql_query($getsubs); | ||
| 36 | $i=0; | ||
| 37 | while ($getsubs3[$i] = mysql_fetch_array($getsubs2)) | ||
| 38 | { | ||
| 39 | $i++; | ||
| 40 | } | ||
| 41 | |||
| 42 | return $getsubs3; | ||
| 43 | } | ||
| 44 | |||
| 45 | function instaDisc_getConfig($name) | ||
| 46 | { | ||
| 47 | $getconfig = "SELECT * FROM config WHERE name = \"" . mysql_real_escape_string($name) . "\""; | ||
| 48 | $getconfig2 = mysql_query($getconfig); | ||
| 49 | $getconfig3 = mysql_fetch_array($getconfig2); | ||
| 50 | |||
| 51 | return $getconfig3['value']; | ||
| 52 | } | ||
| 53 | |||
| 54 | function instaDisc_verifyUser($username, $password) | ||
| 55 | { | ||
| 56 | $getusers = "SELECT * FROM users WHERE username = \"" . mysql_real_escape_string($username) . "\" AND password = \"" . mysql_real_escape_string(md5($password)) . "\""; | ||
| 57 | $getusers2 = mysql_query($getusers); | ||
| 58 | $getusers3 = mysql_fetch_array($getusers2); | ||
| 59 | |||
| 60 | return ($getusers3['username'] == $username); | ||
| 61 | } | ||
| 62 | |||
| 63 | function instaDisc_changePassword($username, $password) | ||
| 64 | { | ||
| 65 | $setconfig = "UPDATE users SET password = \"" . mysql_real_escape_string(md5($password)) . "\" WHERE username = \"" . mysql_real_escape_string($username) . "\""; | ||
| 66 | $setconfig2 = mysql_query($setconfig); | ||
| 67 | $setconfig3 = mysql_fetch_array($setconfig2); | ||
| 68 | } | ||
| 69 | |||
| 70 | function instaDisc_initSubscription($username, $subscriptionID, $subscriptionURL, $subscriptionTitle, $subscriptionCategory, $subscriptionPassword) | ||
| 71 | { | ||
| 72 | $getuser = "SELECT * FROM users WHERE username = \"" . $username . "\""; | ||
| 73 | $getuser2 = mysql_query($getuser); | ||
| 74 | $getuser3 = mysql_fetch_array($getuser2); | ||
| 75 | if ($getuser3['username'] == $username) | ||
| 76 | { | ||
| 77 | $getsub = "SELECT * FROM subscriptions WHERE identity = \"" . mysql_real_escape_string($subscriptionID) . "\""; | ||
| 78 | $getsub2 = mysql_query($getsub); | ||
| 79 | $getsub3 = mysql_fetch_array($getsub2); | ||
| 80 | if ($getsub3['identity'] == $subscriptionID) | ||
| 81 | { | ||
| 82 | if (!instaDisc_isAdmin($username) && ($getsub3['username'] != $username)) | ||
| 83 | { | ||
| 84 | return false; | ||
| 85 | } | ||
| 86 | |||
| 87 | $setsub = "UPDATE subscriptions SET title = \"" . mysql_real_escape_string($subscriptionTitle) . "\", url = \"" . mysql_real_escape_string($subscriptionURL) . "\", category = \"" . mysql_real_escape_string($subscriptionCategory) . "\", password = \"" . mysql_real_escape_string($subscriptionPassword) . "\" WHERE identity = \"" . mysql_real_escape_string($subscriptionID) . "\""; | ||
| 88 | $setsub2 = mysql_query($setsub); | ||
| 89 | } else { | ||
| 90 | $inssub = "INSERT INTO subscriptions (identity, title, url, category, username, password) VALUES (\"" . mysql_real_escape_string($subscriptionID) . "\",\"" . mysql_real_escape_string($subscriptionTitle) . "\",\"" . mysql_real_escape_string($subscriptionURL) . "\",\"" . mysql_real_escape_string($subscriptionCategory) . "\",\"" . mysql_real_escape_string($username) . "\",\"" . mysql_real_escape_string($subscriptionPassword) . "\")"; | ||
| 91 | $inssub2 = mysql_query($inssub); | ||
| 92 | } | ||
| 93 | |||
| 94 | return true; | ||
| 95 | } else { | ||
| 96 | return false; | ||
| 97 | } | ||
| 98 | } | ||
| 99 | |||
| 100 | function instaDisc_listSubscriptions($username) | ||
| 101 | { | ||
| 102 | $getsubs = "SELECT * FROM subscriptions WHERE username = \"" . mysql_real_escape_string($username) . "\""; | ||
| 103 | $getsubs2 = mysql_query($getsubs); | ||
| 104 | $i=0; | ||
| 105 | while ($getsubs3[$i] = mysql_fetch_array($getsubs2)) | ||
| 106 | { | ||
| 107 | $i++; | ||
| 108 | } | ||
| 109 | |||
| 110 | return $getsubs3; | ||
| 111 | } | ||
| 112 | |||
| 113 | function instaDisc_deleteSubscription($id) | ||
| 114 | { | ||
| 115 | $delsub = "DELETE FROM subscriptions WHERE id = " . $id; | ||
| 116 | $delsub2 = mysql_query($delsub); | ||
| 117 | } | ||
| 118 | |||
| 119 | function instaDisc_isAdmin($username) | ||
| 120 | { | ||
| 121 | return ($username == instaDisc_getConfig('adminUser')); | ||
| 122 | } | ||
| 123 | |||
| 124 | function instaDisc_getSubscriptionByID($id) | ||
| 125 | { | ||
| 126 | $getsub = "SELECT * FROM subscriptions WHERE id = " . $id; | ||
| 127 | $getsub2 = mysql_query($getsub); | ||
| 128 | $getsub3 = mysql_fetch_array($getsub2); | ||
| 129 | |||
| 130 | return $getsub3; | ||
| 131 | } | ||
| 132 | |||
| 133 | function instaDisc_addUser($username, $password) | ||
| 134 | { | ||
| 135 | $insuser = "INSERT INTO users (username,password) VALUES (\"" . mysql_real_escape_string($username) . "\",\"" . mysql_real_escape_string(md5($password)) . "\")"; | ||
| 136 | $insuser2 = mysql_query($insuser); | ||
| 137 | } | ||
| 138 | |||
| 139 | function instaDisc_deleteUser($id) | ||
| 140 | { | ||
| 141 | $deluser = "DELETE FROM users WHERE id = " . $id; | ||
| 142 | $deluser2 = mysql_query($deluser); | ||
| 143 | } | ||
| 144 | |||
| 145 | function instaDisc_getAllUsers() | ||
| 146 | { | ||
| 147 | $getusers = "SELECT * FROM users"; | ||
| 148 | $getusers2 = mysql_query($getusers); | ||
| 149 | $i=0; | ||
| 150 | while ($getusers3[$i] = mysql_fetch_array($getusers2)) | ||
| 151 | { | ||
| 152 | $i++; | ||
| 153 | } | ||
| 154 | |||
| 155 | return $getusers3; | ||
| 156 | } | ||
| 157 | |||
| 158 | function instaDisc_getUserByID($id) | ||
| 159 | { | ||
| 160 | $getuser = "SELECT * FROM users WHERE id = " . $id; | ||
| 161 | $getuser2 = mysql_query($getuser); | ||
| 162 | $getuser3 = mysql_fetch_array($getuser2); | ||
| 163 | |||
| 164 | return $getuser3; | ||
| 165 | } | ||
| 166 | |||
| 167 | ?> | ||
