function tag($tag) { $data['tag'] = $tag; $data['knowledges'] = new Knowledge(); $data['knowledges']->where("tag like '%{$tag}%'")->get_page(limit()); $this->template->build('knowledge_tag', $data); }
function tag($tag) { $data['tag'] = $tag; $data['informations'] = new Information(); lang_filter($data['informations']->where("tag like '%{$tag}%'"))->get_page(limit()); $this->template->build('information_tag', $data); }
function index() { $webboard_relate_dels = new Webboard_relate_del(); $data['webboard_relate_dels'] = $webboard_relate_dels->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->build('admin/webboard_relate_del_index', $data); }
/** * Load entity * * @param array $entity * @param array $crit * @param array $opts * * @return array */ function flat_load(array $entity, array $crit = [], array $opts = []) : array { $stmt = db()->prepare(select($entity['attr']) . from($entity['tab']) . where($crit, $entity['attr'], $opts) . order($opts['order'] ?? [], $entity['attr']) . limit($opts['limit'] ?? 0, $opts['offset'] ?? 0)); $stmt->execute(); if (!empty($opts['one'])) { return $stmt->fetch() ?: []; } return $stmt->fetchAll(); }
function index() { $data['type'] = array('7' => 'ico_notify_03.png', '8' => 'ico_notify_06.png', '9' => 'ico_notify_08.png', '193' => 'ico_notify_10.png'); $data['notices'] = new Notice(); @$_GET['titlesearch'] ? $data['notices']->like('title', $_GET['titlesearch']) : ''; @$_GET['type'] ? $data['notices']->where('category_id', $_GET['type']) : ''; lang_filter($data['notices'])->where("start_date <= date(sysdate()) and (end_date >= date(sysdate()) or end_date = date('0000-00-00')) and status = 'approve'")->order_by('start_date', 'desc')->get_page(limit()); $this->template->build('notice_index', $data); }
function index() { $data['english_zones'] = new English_zone(); if (@$_GET['search']) { $data['informations']->where("title like '%" . $_GET['search'] . "%'"); } auth_filter($data['english_zones'])->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/english_zone_index', $data); }
function index() { $menus = new Menu(); if (@$_GET['status']) { $menus->where('status', $_GET['status']); } $data['menus'] = $menus->order_by('orderlist', 'asc')->get_page(limit()); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/menu_index', $data); }
function index() { $data['polls'] = new poll(); if (isset($_POST['search'])) { $data['polls']->where('title like \'%' . $_POST['search'] . '%\''); } $data['polls']->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_checkbox()); $this->template->build('admin/poll_index', $data); }
function index() { $webboard_quizs = new Webboard_quiz(); if (@$_POST['category_id']) { $webboard_quizs->where('category_id', $_POST['category_id']); } $data['webboard_quizs'] = $webboard_quizs->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->build('admin/webboard_index', $data); }
function index($id = FALSE) { $data['categories'] = new Category($id); $galleries = new Gallery(); if (@$_POST['category_id']) { $id = $_POST['category_id']; } $data['galleries'] = $galleries->where('category_id', $id)->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->build('admin/gallery_index', $data); }
function index($category_id = FALSE) { $articles = new Article(); if ($category_id) { $category = new Category($category_id); $articles->where("category_id in (select id from categories where lft >= " . $category->lft . " and rgt <= " . $category->rgt . " and module = '" . $category->module . "')"); } $data['articles'] = $articles->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->build('admin/article_index', $data); }
function index() { $data['hilights'] = new hilight(); if (@$_GET['status']) { $data['hilights']->where('status', $_GET['status']); } auth_filter($data['hilights'])->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/hilight_index', $data); }
/** Select data from table * @param string * @param array result of $adminer->selectColumnsProcess()[0] * @param array result of $adminer->selectSearchProcess() * @param array result of $adminer->selectColumnsProcess()[1] * @param array result of $adminer->selectOrderProcess() * @param int result of $adminer->selectLimitProcess() * @param int index of page starting at zero * @param bool whether to print the query * @return Min_Result */ function select($table, $select, $where, $group, $order, $limit, $page, $print = false) { global $adminer, $jush; $is_group = count($group) < count($select); $query = $adminer->selectQueryBuild($select, $where, $group, $order, $limit, $page); if (!$query) { $query = "SELECT" . limit(($_GET["page"] != "last" && +$limit && $group && $is_group && $jush == "sql" ? "SQL_CALC_FOUND_ROWS " : "") . implode(", ", $select) . "\nFROM " . table($table), ($where ? "\nWHERE " . implode(" AND ", $where) : "") . ($group && $is_group ? "\nGROUP BY " . implode(", ", $group) : "") . ($order ? "\nORDER BY " . implode(", ", $order) : ""), $limit != "" ? +$limit : null, $page ? $limit * $page : 0, "\n"); } if ($print) { echo $adminer->selectQuery($query); } return $this->_conn->query($query); }
function index() { $data['weblinks'] = new Weblink(); if (@$_GET['search']) { $data['weblinks']->where("title like '%" . $_GET['search'] . "%'"); } if (@$_GET['category_id']) { $data['weblinks']->where("category_id = " . $_GET['category_id']); } $data['weblinks']->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->build('admin/weblinks_index', $data); }
function index() { $data['faqs'] = new Faq(); if (@$_GET['search']) { $data['faqs']->where("question like '%" . $_GET['search'] . "%'"); } if (@$_GET['category_id']) { $data['faqs']->where("category_id = " . $_GET['category_id']); } $data['faqs']->order_by('orderlist', 'asc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/faqs_index', $data); }
function index() { $data['executives'] = new Executive(); if (isset($_GET['search'])) { $data['executives']->where('title like \'%' . $_GET['search'] . '%\''); } if (@$_GET['status']) { $data['executives']->where('status', $_GET['status']); } auth_filter($data['executives'])->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox()); $this->template->append_metadata(js_checkbox('approve')); $this->template->build('admin/executive_index', $data); }
function index($category_id = FALSE) { $this->template->set_layout('layout_blank'); if ($category_id) { $data['categories'] = new Category($category_id); @$_GET['textsearch'] ? $data['categories']->academic->like('title', $_GET['textsearch']) : ''; $data['categories']->academic->where("status = 'approve'")->order_by('id', 'desc')->get_page(limit()); $this->template->build('academic_category_view', $data); } else { $data['categories'] = new Category(); $data['categories']->where("module = 'academics' and parents <> 0")->get_page(); $this->template->build('academic_index', $data); } }
function view($id, $group = FALSE) { $this->template->set_layout('layout_blank'); $data['catagory_id'] = $id; $data['galleries'] = new Gallery(); @$_POST['textsearch'] ? $data['galleries']->like('title', $_POST['textsearch']) : ''; @$_POST['groups'] ? $data['galleries']->where_related_category('group_id', $_POST['groups']) : ''; $data['galleries']->where("category_id = '{$id}'")->order_by('id', 'desc')->get_page(limit()); if ($group) { $data['group'] = new group($data['galleries']->category->user->group_id); $this->template->set_layout('group_blank'); } $this->template->build('gallery_view', $data); }
function index() { $data['notices'] = new Notice(); if (@$_GET['search']) { $data['notices']->where("title like '%" . $_GET['search'] . "%'"); } if (@$_GET['status']) { $data['notices']->where('status', $_GET['status']); } if (@$_GET['category_id']) { $data['notices']->where("category_id = " . $_GET['category_id']); } auth_filter($data['notices'])->order_by('id', 'desc')->get_page(limit()); $this->template->append_metadata(js_lightbox())->append_metadata(js_checkbox('approve')); $this->template->build('admin/notice_index', $data); }
function index($id = FALSE) { if ($id) { $data['user'] = new User($id); $data['user']->executive->where("start_date <= date(sysdate()) and (end_date >= date(sysdate()) or end_date = date('0000-00-00')) and status = 'approve'")->order_by('id', 'desc')->get_page(limit()); $this->template->build('index_id', $data); } else { $users = new User(); $data['users'] = $users->where("level_id = 6")->order_by('id', 'desc')->get(1); $data['executive_infos'] = new Executive_info(); $data['executive_infos']->order_by('id', 'desc')->get(5); $data['executive_its'] = new Executive_it(); $data['executive_its']->order_by('id', 'desc')->get(5); $executives = new Executive(); lang_filter($executives->where("start_date <= date(sysdate()) and (end_date >= date(sysdate()) or end_date = date('0000-00-00')) and status = 'approve'")); $data['executives'] = $executives->order_by('id', 'desc')->get(5); $data['videos'] = new Executive_video(); $data['videos']->order_by('id', 'desc')->get(5); $this->template->build('index', $data); } }
function index() { $data['users'] = new User(); if (@$_GET['first_name']) { $data['users']->like_related_profile('first_name', $_GET['first_name']); } if (@$_GET['last_name']) { $data['users']->like_related_profile('last_name', $_GET['last_name']); } if (@$_GET['email']) { $data['users']->like('username', $_GET['email']); } if (@$_GET['level_id']) { $data['users']->where('level_id', $_GET['level_id']); } if (user()->level->view == 2) { $data['users']->where('group_id', user()->group_id); } elseif (user()->level->view == 3) { $data['users']->where('id', user()->id); } $data['users']->order_by('id', 'desc')->get_page(limit()); $this->template->build('admin/user_index', $data); }
echo "</div>\n"; $adminer->selectColumnsPrint($select, $columns); $adminer->selectSearchPrint($where, $columns, $indexes); $adminer->selectOrderPrint($order, $columns, $indexes); $adminer->selectLimitPrint($limit); $adminer->selectLengthPrint($text_length); $adminer->selectActionPrint($indexes); echo "</form>\n"; $page = $_GET["page"]; if ($page == "last") { $found_rows = $connection->result("SELECT COUNT(*) FROM " . table($TABLE) . ($where ? " WHERE " . implode(" AND ", $where) : "")); $page = floor(max(0, $found_rows - 1) / $limit); } $query = $adminer->selectQueryBuild($select, $where, $group, $order, $limit, $page); if (!$query) { $query = "SELECT" . limit((+$limit && $group && $is_group && $jush == "sql" ? "SQL_CALC_FOUND_ROWS " : "") . $from, ($where ? "\nWHERE " . implode(" AND ", $where) : "") . $group_by, $limit != "" ? +$limit : null, $page ? $limit * $page : 0, "\n"); } echo $adminer->selectQuery($query); $result = $connection->query($query); if (!$result) { echo "<p class='error'>" . error() . "\n"; } else { if ($jush == "mssql") { $result->seek($limit * $page); } $email_fields = array(); echo "<form action='' method='post' enctype='multipart/form-data'>\n"; $rows = array(); while ($row = $result->fetch_assoc()) { if ($page && $jush == "oracle") { unset($row["RNUM"]);
<div class="topic"><img src="<?php echo topic("topic_weblink.png"); ?> "></div> <div id="data" style="margin:5px 0 0 0;"> <div id="mediaitem"> <div class="groupname"><?php echo lang_decode($categories->name, ''); ?> </div> <div class="tbmedia"> <table><tbody> <?php foreach ($categories->weblink->get_page(limit()) as $weblink) { ?> <tr> <td><a href="<?php echo $weblink->url; ?> " target="<?php echo $weblink->target; ?> "><img src="uploads/weblinks/<?php echo $weblink->image; ?> " height="90" width="98"></a></td> <td style="padding: 10px; font-size:12px;" valign="top"> <?php echo lang_decode($weblink->description);
function checkBoxList($table, $id_field, $value_field, $id_value, $field_name, $condition = '', $chars = 25) { $out = ''; $uneq_string = randomStringUtil(5); if ($condition) { $condition = " where " . $condition; } $sql = "select {$id_field} , {$value_field} from {$table} {$condition} order by {$value_field} ASC"; $res = mysql_query($sql); $rows = mysql_num_rows($res); if ($rows > 0) { $i = 0; while ($i < $rows) { $id = mysql_result($res, $i, $id_field); $name = mysql_result($res, $i, $value_field); $class = 'chebox_0'; $che = ''; if (is_array($id_value)) { if (in_array($id, $id_value)) { $class = 'chebox_1'; $che = ' checked '; } } $out .= '<div class="' . $class . '" onclick="chekBoxSel(\'' . $uneq_string . '\',' . $i . ')" id="chDiv' . $uneq_string . $i . '"> <input type="checkbox" ' . $che . ' name="' . $field_name . '[]" id="ch' . $uneq_string . $i . '" value="' . $id . '" style="display:none" /> <b>' . ucfirst(limit($name, $chars)) . '</b></div>'; $i++; } } return $out; }
function getWidget($widget_id, $page_id, $condition) { $wid_settings = getWidgetSettings($widget_id); $widget_title = lookupField('cms_widgets', 'id', 'title', $widget_id); $module_id = lookupField('cms_widgets', 'id', 'module_id', $widget_id); $table_name = lookupField('cms_modules', 'id', 'table_name', $module_id); $temp_html = getTemplate($widget_id, $wid_settings['template_id']); $template_main_html = $temp_html['main_html']; $template_item_html = $temp_html['item_html']; $final_condition = $wid_settings['condition']; if ($final_condition && $condition) { $final_condition = $wid_settings['condition'] . ' AND ' . $condition; } elseif ($condition) { $final_condition = ' WHERE ' . $condition; } $widget_sql = "SELECT * FROM `{$table_name}` " . $final_condition . " " . $wid_settings['limit']; $widget_result = mysql_query($widget_sql); $widget_numrows = mysql_num_rows($widget_result); $widget_total_numrows = mysql_num_rows(mysql_query("SELECT * FROM `{$table_name}` " . $final_condition)); if ($widget_numrows) { $s = 0; while ($s < $widget_numrows) { $sql = "SELECT * FROM cms_widget_fields wid_fields, cms_template_fields temp_fields \n\t\t\tWHERE wid_fields.widget_id='{$widget_id}' and temp_fields.id=wid_fields.template_field_id"; $result = mysql_query($sql); $numrows = mysql_num_rows($result); if ($numrows) { $i = 0; $item_html = $template_item_html; while ($i < $numrows) { $template_field_id = mysql_result($result, $i, 'wid_fields.template_field_id'); $template_field_title = mysql_result($result, $i, 'temp_fields.title'); $temp_feild_settings = getTempFieldSettings($template_field_id); $module_field_id = mysql_result($result, $i, 'wid_fields.module_field_id'); $module_field_title = lookupField('cms_module_fields', 'id', 'title', $module_field_id); $module_field_type = lookupField('cms_module_fields', 'id', 'type', $module_field_id); $item_val = mysql_result($widget_result, $s, $module_field_title); $sub_page_id = mysql_result($widget_result, $s, 'page_id'); $sub_page_title = lookupField('cms_pages', 'id', 'title', $sub_page_id); $sub_page_link = _PREF . $_SESSION['pLang'] . '/page' . $sub_page_id . '/' . $sub_page_title; if ($module_field_type == 'photo') { if ($temp_feild_settings['resize_type'] == 'crop' || $temp_feild_settings['resize_type'] == 'resize') { $thumb = viewPhoto($item_val, $temp_feild_settings['resize_type'], $temp_feild_settings['width'], $temp_feild_settings['height'], 'css', 1, $_SESSION['dots'], 0); } else { $thumb = viewPhoto($item_val, 'full', '', '', 'css', 1, $_SESSION['dots'], 0); } $thumb = str_replace(');', '', str_replace('background-image:url(', '', $thumb)); $item_val = $thumb; } else { if ($temp_feild_settings['limit']) { $item_val = limit($item_val, $temp_feild_settings['limit']); } } $item_html = str_replace("##{$template_field_title}##", $item_val, $item_html); $item_html = str_replace("##sub_link##", $sub_page_link, $item_html); $i++; } $extra_widgets_arr = getContents($item_html, '##wid_start##', '##wid_end##'); foreach ($extra_widgets_arr as $widget_content) { $sub_widget_id = getContents($widget_content, '##wid_id_start##', '##wid_id_end##')[0]; $widget_condition = getContents($widget_content, '##wid_con_start##', '##wid_con_end##')[0]; $con_fields_arr = getContents($widget_condition, '##', '##'); foreach ($con_fields_arr as $field) { $widget_condition = str_replace("##{$field}##", mysql_result($widget_result, $s, $field), $widget_condition); } $extra_widgets = getWidget($sub_widget_id, '', $widget_condition); $item_html = replaceContents($item_html, '##ws' . $sub_widget_id . '##', '##we' . $sub_widget_id . '##', $extra_widgets); $item_html = str_replace('##ws' . $sub_widget_id . '##', '', str_replace('##we' . $sub_widget_id . '##', '', $item_html)); } $widget_items_html .= $item_html; } $s++; } } $extra_widgets_arr = getContents($template_main_html, '##wid_start##', '##wid_end##'); foreach ($extra_widgets_arr as $widget_content) { $widget_id = getContents($widget_content, '##wid_id_start##', '##wid_id_end##')[0]; $widget_condition = getContents($widget_content, '##wid_con_start##', '##wid_con_end##')[0]; $con_fields_arr = getContents($widget_condition, '##', '##'); foreach ($con_fields_arr as $field) { $widget_condition = str_replace("##{$field}##", mysql_result($widget_result, 0, $field), $widget_condition); } $extra_widgets = getWidget($widget_id, '', $widget_condition); $template_main_html = replaceContents($template_main_html, '##ws' . $widget_id . '##', '##we' . $widget_id . '##', $extra_widgets); $template_main_html = str_replace('##ws' . $widget_id . '##', '', str_replace('##we' . $widget_id . '##', '', $template_main_html)); } $link = _PREF . $_SESSION['pLang'] . '/page' . $page_id . '/pn^/' . $widget_title; $main_page_title = lookupField('cms_pages', 'id', 'title', $page_id); $final_html = str_replace("##main_page_title##", $main_page_title, $template_main_html); $final_html = str_replace("##site_pref##", _PREF, $final_html); $final_html = str_replace("##template_items##", $widget_items_html, $final_html); $final_html .= getPagination($wid_settings['pagination_id'], $widget_total_numrows, $wid_settings['limit_num'], $link); if (!$final_html) { $final_html = ''; } return $final_html; }
public function _load_child($child, $id) { if ($this->_stack == '_search_index' && $child == 'object') { if ($this->count() == 0) { return null; } $objects = array(); for ($key = 0; $key < count($this->_data); $key++) { $this->_data[$key]->object = NULL; $row = $this->_data[$key]; if (!isset($objects[$row->object_name])) { $objects[$row->object_name] = array(); } $objects[$row->object_name][$row->object_id] = $key; } $return = null; foreach ($objects as $object_name => $ids) { foreach (where('id IN %$', array_keys($ids))->get($object_name) as $child_object) { if (isset($ids[$child_object->id])) { $key = $ids[$child_object->id]; $this->_data[$key]->object = $child_object; if ($this->_data[$key]->id == $id) { $return =& $this->_data[$key]->object; } } } } return $return; } else { if (isset($this->_relations[$child])) { if ($this->count() == 0) { return array(); } $objects = array(); $local_key = $this->_relations[$child]['local_key']; $foreign_key = $this->_relations[$child]['foreign_key']; if ($local_key == 'id') { $local_keys = $this->_ids; } else { $local_keys = array(); for ($i = 0; $i < count($this->_data); $i++) { $local_keys[] = $this->_data[$i]->{$local_key}; } } if (isset($this->_relations[$child]['link_table'])) { $child_ids = $relation_ids = array(); $link_local_key = $this->_relations[$child]['link_local_key']; $link_foreign_key = $this->_relations[$child]['link_foreign_key']; if ($local_key == 'id') { $local_keys = $this->_ids; } else { $local_keys = array(); foreach ($this->_data as $row) { $local_keys[] = $row->{$local_key}; } } $child_objects = where($link_local_key . ' IN %$', $local_keys); if (isset($this->_relations[$child]['order'])) { $child_objects->order_by($this->_relations[$child]['order']); } $child_objects = $child_objects->get($this->_relations[$child]['link_table']); if ($child_objects->count() > 0) { foreach ($child_objects as $child_object) { $child_ids[] = array($child_object->{$link_local_key}, $child_object->{$link_foreign_key}); $relation_ids[] = $child_object->{$link_foreign_key}; } $child_objects = where($foreign_key . ' IN %$', $relation_ids)->get($this->_relations[$child]['source']); $children = array(); foreach ($child_objects as $child_object) { $children[$child_object->{$foreign_key}] = $child_object; //$child_object->_set_resultset($this); } foreach ($child_ids as $child_object) { if (!isset($objects[$child_object[0]])) { $objects[$child_object[0]] = array(); } $objects[$child_object[0]][$children[$child_object[1]]->id] = $children[$child_object[1]]; } } for ($key = 0; $key < count($this->_data); $key++) { $resultset = new Resultset($child_objects, $this->_stack . '/' . $child, $child); $resultset->_data = isset($objects[$this->_data[$key]->id]) ? array_values($objects[$this->_data[$key]->id]) : array(); $resultset->_rowcount = count($resultset->_data); $resultset->_ids = isset($objects[$this->_data[$key]->id]) ? array_keys($objects[$this->_data[$key]->id]) : array(); $this->_data[$key]->{$child} = $resultset; if ($this->_data[$key]->id == $id) { $return =& $this->_data[$key]->{$child}; } } } else { $child_objects = where($foreign_key . ' IN %$', $local_keys); if (isset($this->_relations[$child]['order'])) { $child_objects->order_by($this->_relations[$child]['order']); } $child_objects = $child_objects->get($this->_relations[$child]['source']); foreach ($child_objects as $child_object) { if ($foreign_key == 'id') { $objects[$child_object->id] = $child_object; } else { if (!isset($objects[$child_object->parent_id])) { $objects[$child_object->parent_id] = array(); } $objects[$child_object->parent_id][$child_object->id] = $child_object; } } for ($key = 0; $key < count($this->_data); $key++) { if ($foreign_key == 'id') { $this->_data[$key]->{$child} = isset($objects[$this->_data[$key]->{$local_key}]) ? $objects[$this->_data[$key]->{$local_key}] : NULL; } else { $resultset = new Resultset($child_objects, $this->_relations[$child]['source'], $child); $resultset->_data = isset($objects[$this->_data[$key]->{$local_key}]) ? array_values($objects[$this->_data[$key]->{$local_key}]) : array(); $resultset->_rowcount = count($resultset->_data); $resultset->_ids = isset($objects[$this->_data[$key]->{$local_key}]) ? array_keys($objects[$this->_data[$key]->{$local_key}]) : array(); $this->_data[$key]->{$child} = $resultset; } if ($this->_data[$key]->id == $id) { $return =& $this->_data[$key]->{$child}; } } } return $return; } else { if (isset($this->_children[$child])) { if ($this->count() == 0) { return array(); } $objects = array(); $parent_key = $this->_name . '_id'; $query = is_bool($this->_children[$child]) ? limit(false) : $this->_children[$child]; if ($limit = $query->limit()) { $query->limit(false); } $child_objects = $query->where($parent_key . ' IN %$', $this->_ids)->get($this->_stack . '>' . $child); foreach ($child_objects as $child_object) { if (!isset($objects[$child_object->{$parent_key}])) { $objects[$child_object->{$parent_key}] = array(); } //$child_object->_set_resultset($this); if (!$limit || count($objects[$child_object->{$parent_key}]) < $limit) { $objects[$child_object->{$parent_key}][$child_object->id] = $child_object; } } $return = array(); for ($key = 0; $key < count($this->_data); $key++) { $resultset = new Resultset($child_objects, $this->_stack . '/' . $child, $child); $resultset->_data = isset($objects[$this->_data[$key]->id]) ? array_values($objects[$this->_data[$key]->id]) : array(); $resultset->_rowcount = count($resultset->_data); $resultset->_ids = isset($objects[$this->_data[$key]->id]) ? array_keys($objects[$this->_data[$key]->id]) : array(); $this->_data[$key]->{$child} = $resultset; if ($this->_data[$key]->id == $id) { $return =& $this->_data[$key]->{$child}; } } return $return; } } } return false; }
function limit1($query, $where) { return limit($query, $where, 1); }
/** Print results of search in all tables * @uses $_GET["where"][0] * @uses $_POST["tables"] * @return null */ function search_tables() { global $adminer, $connection; $_GET["where"][0]["op"] = "LIKE %%"; $_GET["where"][0]["val"] = $_POST["query"]; $found = false; foreach (table_status('', true) as $table => $table_status) { $name = $adminer->tableName($table_status); if (isset($table_status["Engine"]) && $name != "" && (!$_POST["tables"] || in_array($table, $_POST["tables"]))) { $result = $connection->query("SELECT" . limit("1 FROM " . table($table), " WHERE " . implode(" AND ", $adminer->selectSearchProcess(fields($table), array())), 1)); if (!$result || $result->fetch_row()) { if (!$found) { echo "<ul>\n"; $found = true; } echo "<li>" . ($result ? "<a href='" . h(ME . "select=" . urlencode($table) . "&where[0][op]=" . urlencode($_GET["where"][0]["op"]) . "&where[0][val]=" . urlencode($_GET["where"][0]["val"])) . "'>{$name}</a>\n" : "{$name}: <span class='error'>" . error() . "</span>\n"); } } } echo ($found ? "</ul>" : "<p class='message'>" . lang('No tables.')) . "\n"; }
$select = array(); foreach ($fields as $name => $field) { if (isset($field["privileges"]["select"])) { $as = convert_field($field); if ($_POST["clone"] && $field["auto_increment"]) { $as = "''"; } if ($jush == "sql" && ereg("enum|set", $field["type"])) { $as = "1*" . idf_escape($name); } $select[] = ($as ? "{$as} AS " : "") . idf_escape($name); } } $row = array(); if ($select) { $rows = get_rows("SELECT" . limit(implode(", ", $select) . " FROM " . table($TABLE), " WHERE {$where}", isset($_GET["select"]) ? 2 : 1)); $row = isset($_GET["select"]) && count($rows) != 1 ? null : reset($rows); } } if ($row === false) { echo "<p class='error'>" . lang('No rows.') . "\n"; } ?> <form action="" method="post" enctype="multipart/form-data" id="form"> <?php if ($fields) { echo "<table cellspacing='0' onkeydown='return editingKeydown(event);'>\n"; foreach ($fields as $name => $field) { echo "<tr><th>" . $adminer->fieldName($field); $default = $_GET["set"][bracket_escape($name)];
} $textwithlinks .= "</tr>\n"; } $textwithlinks .= "</table>\n"; } if ($cleantext != "" && isset($_REQUEST['pastebin'])) { $url = pastebin($cleantext, $name); $pastebin = "Pastebin url: <a href=\"{$url}\" target=\"_blank\">{$url}</a>"; } $cleantext = "<h1>translated for copy and paste</h1>\n<pre>{$cleantext}</pre>"; return array('PASTEBIN' => $pastebin, 'RESULTCLEAN' => $cleantext, 'RESULTHTML' => $textwithlinks); } $res['PASTEBIN'] = ""; /*initianlize vars for template*/ $res['RESULTHTML'] = ""; $res['RESULTCLEAN'] = ""; $res['TEXTAREA'] = getinfolog(); $res['TRANSLATOR'] = "http://springrts.com:8000"; $res['INFO'] = ""; if ($res['TEXTAREA'] != "") { limit(); $tmp = xmlrpcrequest($res['TRANSLATOR'], $res['TEXTAREA']); /* if (array_key_exists('faultString',$tmp)){ $res['INFO']="<h1>Warning: using local translator, as remote can't translate</h1>"; $res['TRANSLATOR']="http://abma.de:8000"; $tmp=xmlrpcrequest($res['TRANSLATOR'],$res['TEXTAREA']); }*/ $res = array_merge($res, parse_result($tmp, getVersion($res['TEXTAREA']))); } $res['ACTION'] = $_SERVER['SCRIPT_NAME']; echo parse_template("index.tpl", $res);