function getNearFrame() { $eventId = $_REQUEST['id'][0]; $frameId = $_REQUEST['id'][1]; $sql = 'select FrameId from Frames where EventId = ? and FrameId <= ? order by FrameId desc limit 1'; if (!($nearFrameId = dbFetchOne($sql, 'FrameId', array($eventId, $frameId)))) { $sql = 'select * from Frames where EventId = ? and FrameId > ? order by FrameId asc limit 1'; if (!($nearFrameId = dbFetchOne($sql, 'FrameId', array($eventId, $frameId)))) { return array(); } } $_REQUEST['entity'] = "frame"; $_REQUEST['id'][1] = $nearFrameId; return collectData(); }
<?php error_reporting(4095); include_once 'inc.php'; $dataStack = array(); collectData('socdem'); collectData('potreb'); function collectData($type) { initTable($type); $tables = array('socdem' => array('table' => 'ank1', 'field' => 'user_id'), 'potreb' => array('table' => 'ank2', 'field' => 'person_id', 'user_fnc' => 'personByUser')); $total = 0; $st = query('select * from panelie_user where status_id in (10,11) and is_tester=0'); while ($obj = mysql_fetch_assoc($st)) { if (isset($tables[$type]['user_fnc'])) { $obj['user_id'] = $tables[$type]['user_fnc']($obj['user_id']); } if ($obj1 = mysql_fetch_assoc(query('select * from panelie_' . $tables[$type]['table'] . ' where ' . $tables[$type]['field'] . '=' . $obj['user_id']))) { $binds = array(); $binds[] = 'id=' . $obj['user_id']; $st2 = query("select * from panelie_single_choice where anketa_type='{$type}' and anketa_id='" . $obj1['id'] . "'"); while ($ans = mysql_fetch_assoc($st2)) { $binds[] = $ans['question_name'] . "=" . $ans['value']; if ($ans['descr']) { $binds[] = $ans['question_name'] . "_descr='" . $ans['descr'] . "'"; } } $oldName = ''; $values = array(); $freqs = array(); $descr = NULL;
function getNearFrame() { $eventId = dbEscape($_REQUEST['id'][0]); $frameId = dbEscape($_REQUEST['id'][1]); $sql = "select FrameId from Frames where EventId = '" . $eventId . "' and FrameId <= '" . $frameId . "' order by FrameId desc limit 1"; if (!($nearFrameId = dbFetchOne($sql, 'FrameId'))) { $sql = "select * from Frames where EventId = '" . $eventId . "' and FrameId > '" . $frameId . "' order by FrameId asc limit 1"; if (!($nearFrameId = dbFetchOne($sql, 'FrameId'))) { return array(); } } $_REQUEST['entity'] = "frame"; $_REQUEST['id'][1] = $nearFrameId; return collectData(); }
function generate() { return collectData(); }