* @since RC1 **/ class query extends admin { /** * Query Interface * * @author Jason Warner * @since RC1 * @return string HTML **/ function execute() { $this->set_title($this->lang->query); $this->tree($this->lang->query); if (!isset($this->post['submit'])) { return $this->message($this->lang->query, " "); } else { $result = $this->db->query($this->post['sql']); if (is_resource($result)) { $sql = htmlspecialchars($this->post['sql']); $show_headers = true; $out = $this->message($this->lang->query, "
"); $out .= $this->table; while ($row = $this->db->nqfetch($result)) { if ($show_headers) { $out .= "\n"; foreach ($row as $col => $data) { $out .= "$col\n"; } $out .= "\n

"; $show_headers = false; } $out .= "\n"; foreach ($row as $col => $data) { $out .= "" . $this->format($data, FORMAT_HTMLCHARS) . "\n"; } $out .= "

\n"; } return $out . $this->etable; } else { return $this->message($this->lang->query, $this->lang->query_your . ' ' . ($result ? $this->lang->query_success : $this->lang->query_failed)); } } } } ?>