function write_json($query, $reversed, $line) { if ($query == 'line') { write_ok($line); } elseif ($query == 'bus') { $bus = $line[0]; $bus_info = get_bus_info($bus, $reversed); $bus_pos = cache_bus_pos($bus, $reversed); $result = array('bus_info' => $bus_info['info'], 'bus_station' => $bus_info['station'], 'bus_pos' => $bus_pos); write_ok($result); } else { write_error($GLOBALS['ERR_PARAMS_QUERY']); } }
function get_joke($type, $joke_id, $cat_id, $limit) { if ($joke_id) { $sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` where `id` = {$joke_id}"; } elseif ($cat_id == -1) { $sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` order by rand() limit {$limit}"; } else { $sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` where `cat_id` = {$cat_id} order by rand() limit {$limit}"; } $jokes = query_sql($sql); if ($type == 'text') { $result = ""; foreach ($jokes as $joke) { $result .= $joke['title'] . "\n" . $joke['content'] . "\n\n"; } write_ok_text($result); } elseif ($type == 'json') { write_ok($jokes); } else { write_error($GLOBALS['ERR_PARAMS_TYPE']); } }