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();
}
