Example #1
0
/**
 * 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);
Example #2
0
        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']) : '';
Example #3
0
        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);
}
Example #4
0
 *
 *
 */
/* 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);