Useful for queries that can't be accomplished through Idiorm,
particularly those using engine-specific features.
$items[] = $item["result"];
}
echo implode(";", $items);
});
$app->post('/genv/payhulu', function ($request, $response) {
$uid = $_SESSION['uid'];
$amount = $this->request->getParam("amount");
try {
ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
ORM::get_db()->beginTransaction();
//减去余额
$sql = vsprintf("UPDATE %s SET `balance` = balance-%d WHERE `uid` = %d and `balance`>=%d ", array(table("members_points"), $amount, $uid, $amount));
ORM::raw_execute($sql);
//增加积分；
$sql = vsprintf("UPDATE %s SET `points` = points+%d WHERE `uid` = %d ", array(table("members_points"), $amount, $uid));
ORM::raw_execute($sql);
echo ORM::get_last_query();
//
// Order::deduct_stock($order['coohua_id'], $order['product_id'], $order['order_code']);
// ORM::raw_execute("UPDATE `order` SET `check` = 5 WHERE `order_code` = ? and `check`=4 ", array($order['order_code']));
ORM::get_db()->commit();
ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
} catch (Exception $e) {
//dump($e);
ORM::get_db()->rollBack();
}
});
function listDir($dir)
{
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
<?php
if (isset($_GET["buy_tickets"]) && !empty($_GET["buy_tickets"])) {
$travel_id = $_GET["TRAVEL_ID"];
ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . "WHERE travel_id = :travel_id " . "AND updated_by = :user_id", array("status_value" => 'U', "travel_id" => $travel_id, "user_id" => 'user_id'));
}
?>
<script>
function ajax_post(seat_number){
// Create our XMLHttpRequest object
var hr = new XMLHttpRequest();
// Create some variables we need to send to our PHP file
var url = "reserve_seat.php";
//var fn = document.getElementById("1_1").innerHTML;
var fn = seat_number.innerHTML;
var user = "******";
var travel_id = <?php
echo $_GET["TRAVEL_ID"];
?>
;
var vars = "reserve_seat=true&seat_number="+fn+"&user_id="+user+"&travel_id="+travel_id+"&status_value=A";
//check if seat is not sold or reserved
hr.open("POST", "reserve_seat.php", true);
// Set content type header information for sending url encoded variables in the request
hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
// Access the onreadystatechange event for the XMLHttpRequest object
hr.onreadystatechange = function() {
/**
* @public
*/
static function prefs($prefs)
{
global $app;
$req = $app->request();
if (!has_session()) {
throw new AccessException();
}
if ($req->isGet()) {
return current_user()->getPrefs(true);
}
if ($req->isPost()) {
// preferences are set by the client, so we allow pretty much
// anything to be stored there - don't forget this!
// it's really designed for storing flags, like whether or not
// a particular screen or message has been seen before
foreach ($prefs as $pname => $value) {
$name = 'pref_' . trim($pname);
if (strlen($name) > UserSetting::MAX_NAME_LENGTH) {
throw new Exception("Preference name [{$pname}] is too long");
}
if (!preg_match('/^[\\w_-]+$/', $name)) {
throw new Exception("Invalid preference name [{$pname}] is too long");
}
ORM::raw_execute("\n INSERT INTO user_setting (\n `user_id`,\n `name`,\n `value`\n ) VALUES (\n ?, ?, ?\n ) ON DUPLICATE KEY UPDATE\n `user_id` = VALUES(`user_id`),\n `name` = VALUES(`name`),\n `value` = VALUES(`value`) \n ", array(current_user()->id, $name, maybe_serialize($value)));
}
}
if ($req->isDelete()) {
foreach ($prefs as $pname => $value) {
$name = 'pref_' . trim($pname);
ORM::raw_execute("\n DELETE FROM user_setting \n WHERE\n `user_id` = ?\n AND `name` = ?\n LIMIT 1\n ", array(current_user()->id, $name));
}
}
}
function update_resume_num($id)
{
$count = resume_log_num($id);
\ORM::raw_execute(vsprintf("update %s set num=%d where id=%d", array(table("resume_temp"), $count, $id)));
if ($count >= 3) {
update_resume_status($id);
//如果有三条都通过的记录，直接导入简历；
$rs = \ORM::for_table(table("resume_check_log"))->where("rid", $id)->where("pass", 1)->find_array();
if ($rs && count($rs) >= 3) {
import_resume_temp($id);
}
}
}
public function raw_execute($query, $parameters = array())
{
return \ORM::raw_execute($query, $parameters = array(), $this->connectionName);
}
<?php
require 'setup.php';
date_default_timezone_set('America/Mexico_City');
if (isset($_POST["reserve_seat"]) && !empty($_POST["reserve_seat"])) {
$travel_id = $_POST["travel_id"];
$seat_number = $_POST["seat_number"];
$status_value = $_POST['status_value'];
$user_id = $_POST['user_id'];
$check = ORM::for_table('seats')->select('seats.status')->where(array('travel_id' => $travel_id, 'seat_number' => $seat_number))->find_one();
$status = $check->status;
$user_check = ORM::for_table('seats')->select('seats.updated_by')->where(array('travel_id' => $travel_id, 'seat_number' => $seat_number))->find_one();
$user = $user_check->updated_by;
if ($status === '0') {
ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . ",updated_by = :updated_by " . "WHERE travel_id = :travel_id " . "AND seat_number = :seat_number ", array("status_value" => $status_value, "updated_by" => $user_id, "travel_id" => $travel_id, "seat_number" => $seat_number));
header("Content-type: text/xml");
echo '<this><is><color>#FFFF00</color></is></this>';
}
if ($status === 'A' && $user === $user_id) {
ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . ", updated_by= :updated_by " . "WHERE travel_id = :travel_id " . "AND seat_number = :seat_number ", array("status_value" => '0', "updated_by" => '', "travel_id" => $travel_id, "seat_number" => $seat_number));
header("Content-type: text/xml");
echo '<this><is><color>#006600</color></is></this>';
}
/*
else {
echo 'Alguien mas acaba de apartar este asiento';
}
*/
}
$ins = ORM::raw_execute("INSERT INTO `modules` VALUES (1, 'tv_shows', 'TV shows', 1)");
$ins = ORM::raw_execute("INSERT INTO `modules` VALUES (2, 'movies', 'Movies', 1)");
$ins = ORM::raw_execute("INSERT INTO `modules` VALUES (7, 'submit_links', 'Submit links', 1)");
$ins = ORM::raw_execute("INSERT INTO `modules` VALUES (6, 'requests', 'Requests', 1)");
print "<span style='color:#00aa00'>Success</span><br />";
?>
Adding default settings...
<?php
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (1, 'default_language', 'en')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (2, 'maxtvperpage', '50')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (3, 'maxmoviesperpage', '50')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (4, 'countdown_free', '30')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (5, 'countdown_user', '0')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (6, 'seo_links', '1')");
$ins = ORM::raw_execute("INSERT INTO `settings` VALUES (7, 'smart_bar', '0')");
print "<span style='color:#00aa00'>Success</span><br />";
?>
Changing Admin Panel Name...
<?php
rename(realpath(dirname(__FILE__)) . '/../control', realpath(dirname(__FILE__)) . '/../' . $_SESSION['admin_folder']);
print "<span style='color:#00aa00'>Success</span><br />";
?>
Congratulation. Your site is all set up<br /><br />
Next steps:<br /><br />
<ul>
<li><a href="<?php
print $_SESSION['site_url'];
// to let static ember help pages work even if unconfigured
date_default_timezone_set(defined('AMTC_TZ') ? AMTC_TZ : 'Europe/Berlin');
set_include_path(get_include_path() . PATH_SEPARATOR . AMTC_WEBROOT . '/lib' . PATH_SEPARATOR . AMTC_WEBROOT . '/lib/db-model');
spl_autoload_extensions('.php');
spl_autoload_register();
require 'idiorm.php';
require 'paris.php';
require 'Slim/Slim.php';
// Initialize http://j4mie.github.io/idiormandparis/
if (defined("AMTC_PDOSTRING")) {
ORM::configure(AMTC_PDOSTRING);
ORM::configure('username', AMTC_DBUSER);
ORM::configure('password', AMTC_DBPASS);
// small hack to enforce constraint checking for sqlite; requires 3.6+
if (substr(AMTC_PDOSTRING, 0, 6) == 'sqlite') {
ORM::raw_execute('PRAGMA foreign_keys = ON');
}
}
// Initialize http://www.slimframework.com/
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app->config('debug', false);
// false enables custom error handler below
$app->response()->header('Content-Type', 'application/json;charset=utf-8');
$app->notFound(function () {
echo json_encode(array('error' => 'Not found'));
});
$app->error(function (\Exception $e) {
echo strlen($e->getMessage()) > 128 ? substr($e->getMessage(), 0, 128) . '...' : $e->getMessage();
});
class SlimUtil
