function format_query($d) { global $db; $properties = get_object_vars($d); $skip = array('date_modified', 'date_created', 'id', 'created', 'modified', 'children'); $i = 0; $u_q = "UPDATE documents SET "; foreach ($properties as $k => $v) { if (!in_array($k, $skip)) { if ($v == null) { $v = 'NULL'; } else { $v = is_numeric($v) ? intval($v) : '"' . $db->real_escape_string($v) . '"'; } if ($i > 0) { $u_q .= ", "; } $u_q .= $k . " = " . $v; $i++; } } $u_q .= " WHERE id=" . $d->id . ";" . "\n"; if ($db->query($u_q)) { $success = true; } else { $success = false; } foreach ($d->children as $child) { $success = format_query($child); } return $success; }
function print_results($query, $advanced = false) { global $perm, $sess, $HTTP_GET_VARS, $glob_userdata, $glob_search_words; $glob_search_words = array(); if (!defined("SEARCH_INC")) { include "search/search2.inc"; } if (!defined("LAY_DIRECTORY_INC")) { include "layout/lay_directory.inc"; } if (!defined("LAY_SEARCH_INC")) { include "layout/lay_search.inc"; } if (!defined("COMMON_PERMISSIONS_INC")) { include "commonapi/common_permissions.inc"; } $ciu = $HTTP_GET_VARS['ciu'] == "" ? 0 : $HTTP_GET_VARS['ciu']; $cit = $HTTP_GET_VARS['cit'] == "" ? 0 : $HTTP_GET_VARS['cit']; $cic = $HTTP_GET_VARS['cic'] == "" ? 0 : $HTTP_GET_VARS['cic']; if ($glob_userdata['ResPerPage'] == "") { $glob_userdata['ResPerPage'] = DIR_MAX_SEARCH; } if ($glob_userdata['HighlightSearch'] == "") { $glob_userdata['HighlightSearch'] = true; } $restriction = $HTTP_GET_VARS['restriction']; if ($query != "") { $err = ""; if ($advanced == false) { $query = format_query($query); } else { $query = format_query_simple($query); } // echo("freag: $query<p>"); $users = array(); if (!ereg('^/Experts', $restriction)) { $cats = execute_query($query, $sess->id, $cic, "c", $restriction, $glob_userdata['ResPerPage']); if (!isset($cats['error'])) { $trails = execute_query($query, $sess->id, $cit, "t", $restriction, $glob_userdata['ResPerPage']); $glob_search_words = $cats['resinfo']['words']; } else { $err = $cats['error']; } if (!is_array($err)) { $experts = execute_query($query, $sess->id, 0, "e", $restriction, $glob_userdata['ResPerPage']); } if (isset($experts['error']) and !is_array($err)) { $err = $experts['error']; } } else { $users = execute_query($query, $sess->id, $ciu, "t", $restriction, $glob_userdata['ResPerPage']); $glob_search_words = $cats['words']; // die($users['resinfo']['rescount']); if (isset($users['error'])) { $err = $users['error']; } $users['resinfo']['ci'] = $ciu; } } print_page_begin(); $tpl = new Template(APPLICATION_HOME . "/templates/search", "keep"); $tpl->set_file(array("main" => "main.html")); $caps = get_caps($perm, '/'); $tpl->set_var("IWANTTO", print_iwantto('/', $caps)); //printf("Test: %d / %d / %d<p>",count($trails['results']) ,count($trails['results']) ,count($trails['results']) ); //printf("Test: %d, %d, %d", count($cats['results']), count($trails['results']), count($users['results'])); if (count($cats['results']) == 0 and count($trails['results']) == 0 and count($users['results']) == 0 or $query == "") { if (is_array($err)) { $tpl->set_var("CATEGORIES", print_search_error($err)); } else { $tpl->set_var("CATEGORIES", implode("\n", file(TEMPLATE_ROOT . 'search/nothing_found.html'))); } $tpl->set_var("TRAILS", ""); $tpl->set_var("EXPERTS", ""); } elseif (count($users) > 0) { $tpl->set_var("CATEGORIES", print_found_users($users)); $tpl->set_var("EXPERTS", ""); $tpl->set_var("TRAILS", ""); } else { $tpl->set_var("CATEGORIES", print_found_categories($cats)); $tpl->set_var("TRAILS", print_found_trails($trails)); $tpl->set_var("EXPERTS", print_found_experts($experts)); } $tpl->parse("main", "main"); $tpl->p("main"); print_page_end(); }
function set_timezone($socket = NULL) { global $last_error; $tz_offset = "'" . date('P') . "'"; /* Difference to Greenwich time (GMT) with colon between hours and minutes */ $query = "SET TIME ZONE INTERVAL " . $tz_offset . " HOUR TO MINUTE"; $buf = mapi_write($socket, format_query($query, LANG_SQL)); // set_timezone is called only when connecting to an sql db $response = mapi_read($socket); if ($response == "") { return TRUE; } else { $last_error = $response; return $response; } }