/** * Provisoner files evolution component * * @category Provisioning * @author S. Hamblett <*****@*****.**> * @copyright 2010 S. Hamblett * @license GPLv3 http://www.gnu.org/licenses/gpl.html * @link none * * @package provisioner * */ /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* format filename */ $file = rawurldecode($scriptProperties['file']); if (!file_exists($file)) { $response = errorFailure(" : No file found : ", array('name' => $file)); echo json_encode($response); return; } $filename = ltrim(strrchr($file, '/'), '/'); /* Encode into base64 for transmission */ $fbuffer = @file_get_contents($file); $fbuffer = base64_encode($fbuffer); $time_format = '%b %d, %Y %H:%I:%S %p'; $fa = array('name' => utf8_encode($filename), 'size' => filesize($file), 'last_accessed' => strftime($time_format, fileatime($file)), 'last_modified' => strftime($time_format, filemtime($file)), 'content' => $fbuffer); $response = errorSuccess('', $fa); echo toJSON($response);
echo json_encode($response); return; } else { $user = mysql_fetch_assoc($result); $sql = "SELECT * FROM " . $table_prefix . "manager_users " . "WHERE `id` = " . "'" . $scriptProperties['id'] . "'"; $result = mysql_query($sql, $db); $userMain = mysql_fetch_assoc($result); $user['username'] = $userMain['username']; $user['password'] = $userMain['password']; $response = errorSuccess('', $user); } } else { $sql = "SELECT * FROM " . $table_prefix . "web_user_attributes " . "WHERE `internalKey` = " . "'" . $scriptProperties['id'] . "'"; $result = mysql_query($sql, $db); if (mysql_num_rows($result) != 1) { $response = errorFailure("No web user found", array('id' => $id)); mysql_close($db); echo json_encode($response); return; } else { $user = mysql_fetch_assoc($result); $sql = "SELECT * FROM " . $table_prefix . "web_users " . "WHERE `id` = " . "'" . $scriptProperties['id'] . "'"; $result = mysql_query($sql, $db); $userMain = mysql_fetch_assoc($result); $user['username'] = $userMain['username']; $user['password'] = $userMain['password']; $response = errorSuccess('', $user); } } /* Formatting */ $user['dob'] = !empty($user['dob']) ? strftime('%m/%d/%Y', $user['dob']) : '';
break; case 'tv': $sql = "SELECT * FROM " . $table_prefix . "site_tmplvars" . " WHERE `id` = " . $id; $result = mysql_query($sql, $db); if (mysql_num_rows($result) == 0) { $response = errorFailure("No TV found", array('id' => $id)); } else { $element = mysql_fetch_assoc($result); $response = errorSuccess('', $element); } mysql_close($db); echo toJSON($response); break; case 'category': $sql = "SELECT * FROM " . $table_prefix . "categories" . " WHERE `id` = " . $id; $result = mysql_query($sql, $db); if (mysql_num_rows($result) == 0) { $response = errorFailure("No category found", array('id' => $id)); } else { $category = mysql_fetch_assoc($result); $category['parent'] = 0; $response = errorSuccess('', $category); } mysql_close($db); echo toJSON($response); break; default: $response = errorFailure("No such element type", array('type' => $type)); mysql_close($db); echo toJSON($response); }
* * */ /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* Get the resource from the database */ $db = connectToDb(); $sql = "SELECT * FROM " . $table_prefix . "site_content " . "WHERE `id` = " . $scriptProperties['id']; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid Resource query"); } if (mysql_num_rows($result) == 1) { $resource = mysql_fetch_assoc($result); } else { $response = errorFailure("No resource found", array('id' => $scriptProperties['id'])); mysql_close($db); echo json_encode($response); return; } /* Set the class key for correct creation in Revolution */ if ($resource['type'] == 'reference') { $resource['class_key'] = 'modWebLink'; } else { $resource['class_key'] = 'modDocument'; } $response = errorSuccess('', $resource); mysql_close($db); echo toJSON($response);