public function register()
{
if ($this->get_uid()) {
return $this->get_uid();
}
$res = db::Query("INSERT INTO users.info DEFAULT VALUES RETURNING uid", [], true);
return $this->get_login($res->uid);
}
private function CheckForRequestFrame($network)
{
try {
$res = db::Query("UPDATE personal.frequency\n SET last_access=now()\n WHERE network=\$1\n AND now() - last_access > min_interval\n RETURNING *", [$network], true);
return $res();
} catch (Exception $e) {
return false;
}
}
private function new_income($data = [])
{
$trans = db::Begin();
$handle = db::Query("INSERT INTO transactions(system, data) VALUES (\$1, \$2) RETURNING id", ["yandex.wallet", json_encode($data)], true);
$result = $trans->Commit();
if (!$result) {
header('500 Failed to store transaction');
exit;
}
}
private function get_account_object($account_id)
{
if (!empty($this->loaded_accounts[$account_id])) {
return $this->loaded_accounts[$account_id];
}
$account = db::Query("SELECT *\n FROM personal.tokens\n WHERE uid=\$1\n AND account_id=\$2", [db::UID(), $account_id], true);
phoxy_protected_assert($account(), "Account not found. Please connect again");
list($obj, $user) = $this->network_signin($account->network, json_decode($account->token_data, true));
db::Query("UPDATE personal.tokens\n SET profile_id=\$2\n WHERE account_id=\$1", [$account_id, $user->id]);
return $this->loaded_accounts[$account_id] = $obj;
}
protected function register()
{
if (isset($_POST["register"])) {
if (!empty($_POST['username']) && !empty($_POST['password'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$sameusers = db::Query("select * from users WHERE username=\$1", [$username]);
if ($sameusers() == 0) {
$useradd = "INSERT INTO users (username,password) VALUES (\$1,\$2) RETURNING id";
$result = db::Query($useradd, [$username, $password], true);
if ($result() != 0) {
return "Аккаунт создан, вы прекрасны";
} else {
return "Ошибка :p";
}
} else {
return "Такой чувак уже есть.";
}
} else {
return "Поля незаполнены!";
}
}
}
protected function vote($id, $delta)
{
return db::Query("UPDATE quotes SET ratio=ratio+\$2 WHERE id=\$1 RETURNING ratio", [$id, $delta], true)->ratio;
}
<?php
require_once 'vendor/autoload.php';
if (!PRODUCTION) {
error_reporting(E_ALL);
ini_set('display_errors', 'On');
}
function phoxy_conf()
{
$ret = phoxy_default_conf();
$ret["api_xss_prevent"] = PRODUCTION;
return $ret;
}
function default_addons()
{
$ret = ["cache" => PRODUCTION ? ['global' => '10m'] : "no", "result" => "canvas"];
return $ret;
}
include 'phoxy/phoxy_return_worker.php';
phoxy_return_worker::$add_hook_cb = function ($that) {
global $USER_SENSITIVE;
if ($USER_SENSITIVE) {
$that->obj['cache'] = 'no';
}
};
phpsql\OneLineConfig(conf()->db->connection_string);
db::Query("INSERT INTO requests(url, get, post, headers, server) VALUES (\$1, \$2, \$3, \$4, \$5)", [$_SERVER['QUERY_STRING'], json_encode($_GET), json_encode($_POST), json_encode(getallheaders()), json_encode($_SERVER)]);
include 'phoxy/load.php';
public function info($account_id)
{
$account = db::Query("SELECT *\n FROM personal.tokens\n WHERE uid=\$1 AND account_id=\$2", [db::UID(), $account_id], true);
phoxy_protected_assert($account(), "Internal issue: account not found");
return $this->PrepareAccount($account);
}
protected function rendertags($id)
{
$sql_tags = db::Query("SELECT tag FROM tags WHERE quote_id=\$1", [$id]);
return ["design" => "quotes/tags", "data" => ["tags" => $sql_tags]];
}
public function Update($type, $resource_id, $data, $expiration)
{
// TODO: Update if exists
db::Query("DELETE FROM personal.account_cache WHERE expired < now()");
db::Query("INSERT INTO personal.account_cache\n (account_id, type, resource_id, data, expired)\n VALUES (\$1, \$2, \$3, \$4, 'epoch'::timestamp + \$5::int8 * '1 second'::interval)", [$this->AccountID(), $type, $resource_id, json_encode($data, true), $expiration]);
}
}
function SQLLoad($file)
{
header("SQL: {$file}", false);
$con = db::RawConnection();
$sql = file_get_contents($file);
pg_send_query($con, $sql);
if (($error = pg_last_error($con)) !== '') {
die("Failure at loading {{$file}} with {{$error}}");
}
while (pg_connection_busy($con)) {
sleep(1);
}
while (pg_get_result($con) !== false) {
if (($error = pg_last_error($con)) !== '') {
die("Failure at loading {{$file}} with {{$error}}");
}
}
}
if (db::RawConnection() == false) {
EmergencyCreateDB();
}
$res = @db::Query("SELECT * FROM quotes LIMIT 1");
if (is_string($res)) {
// then its error
SQLLoad("sql/schema.sql");
} else {
if (!$res()) {
}
}
header("SQL: OK", false);
public function Register()
{
return db::Query("INSERT INTO personal.users DEFAULT VALUES RETURNING uid", [], true)->uid;
}
