function storyInfo()
{
$uri = g('uri');
$userId = g('userId');
st_db_object()->rawQuery("CALL MOVESTORIESFORWARD()");
$db_data = st_db_object()->rawQuery("\n SELECT \n (SELECT COUNT(*) FROM `story_user` WHERE `story_user`.`FK_story_id` = `story`.`id`) AS num_players,\n `story`.`time_limit` AS time_limit,\n (CASE\n WHEN `story`.`current_turn` > 0 THEN\n (SELECT MAX(`turn`.`timestamp`) FROM `turn` WHERE `turn`.`FK_story_id` = `story`.`id`)\n ELSE\n `story`.`started_at`\n END) AS turn_start,\n NOW() AS now_time,\n `story`.`current_turn` AS current_turn,\n (SELECT `story_user`.`turn_order` FROM `story_user` WHERE `story_user`.`FK_user_id` = ? AND `story_user`.`FK_story_id` = `story`.`id` LIMIT 1) AS turn_order\n FROM \n `story` \n WHERE \n `story`.`uri` = ?\n ", array($userId, $uri));
echo json_encode($db_data[0]);
}
function complete()
{
//get search term
$searchTerm = $_GET['term'];
//get matched data from skills table
$query = st_db_object()->rawQuery("SELECT * FROM user WHERE name LIKE '%" . $searchTerm . "%' ORDER BY name ASC");
$data = [];
foreach ($query as $row) {
$data[] = $row['name'];
}
//return json data
echo json_encode($data);
}
<?php
define('ST_BASE_DIR', dirname(empty($_SERVER['SCRIPT_FILENAME']) ? dirname(__FILE__ . "/../") : $_SERVER['SCRIPT_FILENAME']) . '/../');
define('ST_INCLUDE_DIR', ST_BASE_DIR . 'include/');
require ST_INCLUDE_DIR . 'st-index.php';
//get search term
$searchTerm = $_GET['term'];
//get matched data from skills table
$query = st_db_object()->rawQuery("SELECT * FROM user WHERE name LIKE '%" . $searchTerm . "%' ORDER BY name ASC");
$data = [];
foreach ($query as $row) {
$data[] = $row['name'];
}
//return json data
echo json_encode($data);
function __construct()
{
$this->db = st_db_object();
}
function __construct()
{
$this->db = st_db_object();
session_start();
}
