protected function logoutAction() { try { $userLogin = new Bobr_User_UserLogin(); $userLogin->logOut(); Lib_Messanger::addNote('Uzivatel byl odhlasen.'); Bobr_Request_HttpRequest::redirect(Link::build('login/login')); } catch (UserLoginException $e) { echo $e->getMessage(); } return ''; }
if($length < 10) { $size = 10; } */ $inp = new Input(); $inp->setName($colname); $inp->setValue($item); $inp->setSize(50); $inp->setMaxlength(128); /**/ $tr = new Tr(); $tr->add($colname); $tr->add($inp->dump()); $tr->build(); ++$i; /**/ } $tr = new Tr(); $tr->add(' '); $tr->add($submit->dump()); $tr->build(); unset($table); unset($form); $body->line('<hr />'); $backlink = new Link(); $backlink->setHref('controller.php?cmd=table_browse&table=' . $req->get('table')); $backlink->setName('Back to list'); $backlink->build(); include_once './inc/footer.php'; unset($body); unset($html);
if ($req->is('view')) { $q = "SELECT sql FROM sqlite_master WHERE type = 'view' AND name = '" . $req->get('table') . "' "; } else { $q = "SELECT sql FROM sqlite_master WHERE type = 'table' AND name = '" . $req->get('table') . "' "; } $sql->qo($q); $res = $sql->fo_one(); $body->line($res->sql); $body->line('<hr>'); if (!$req->is('view')) { // $body->line('create indexes - overview indexes'); $body->line('<h3>Indexes</h3>'); $idxadd = new Link(); $idxadd->setHref('controller.php?cmd=index_add&table=' . $req->get('table')); $idxadd->setName('Add index'); $idxadd->build(); $body->line(); $q = "PRAGMA index_list(" . $req->get('table') . ")"; $sql->qo($q); $res = $sql->fo(); if (!$res) { $body->line('No indexes defined<br>'); } else { $table = new Table(); $table->setClas('result'); $table->build(); $th = new Th(); $th->add('Name'); $th->add('Unique ?'); $th->add('Columns'); $th->add(' ');
$html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - show tables'); $head->setCss('./css/psa.css'); $head->setjs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line(); $link = new Link(); $link->setHref('controller.php?cmd=table_add'); $link->setClas('butter'); $link->setName('Add table'); $link->build(); $body->line('<hr>'); if (!$res) { $body->line('No tables defined.'); } else { $body->line('<h3>List tables</h3>'); $table = new Table(); $table->setClas('result'); $table->build(); foreach ($res as $item) { if ($item->name == 'sqlite_sequence') { continue; } $struct = new Link(); $struct->setHref('controller.php?cmd=tableinfo&table=' . $item->name); $struct->setName('Structure');
/** * Generates the pagination * * @TODO: Clean this up, this is batshit insane. * * @return string */ function pagination($class = '') { if (!$this->allowpaging) { return; } $this->set_boundaries(); // Build links before passing to template to handle AJAX if necessary $firstpagelink = new Link($this->page_link(0), 1, $this->ajax, $this->id, $this->response_target); $prevpagelink = new Link($this->page_link($this->pageno - 2), "<div class='pagin-left'></div>", $this->ajax, $this->id, $this->response_target); $fourprevpagelink = new Link($this->page_link($this->pageno - 5), $this->pageno - 4, $this->ajax, $this->id, $this->response_target); $threeprevpagelink = new Link($this->page_link($this->pageno - 4), $this->pageno - 3, $this->ajax, $this->id, $this->response_target); $twoprevpagelink = new Link($this->page_link($this->pageno - 3), $this->pageno - 2, $this->ajax, $this->id, $this->response_target); $oneprevpagelink = new Link($this->page_link($this->pageno - 2), $this->pageno - 1, $this->ajax, $this->id, $this->response_target); $onenextpagelink = new Link($this->page_link($this->pageno), $this->pageno + 1, $this->ajax, $this->id, $this->response_target); $twonextpagelink = new Link($this->page_link($this->pageno + 1), $this->pageno + 2, $this->ajax, $this->id, $this->response_target); $threenextpagelink = new Link($this->page_link($this->pageno + 2), $this->pageno + 3, $this->ajax, $this->id, $this->response_target); $fournextpagelink = new Link($this->page_link($this->pageno + 3), $this->pageno + 4, $this->ajax, $this->id, $this->response_target); $nextpagelink = new Link($this->page_link($this->pageno), "<div class='pagin-right'></div>", $this->ajax, $this->id, $this->response_target); $lastpagelink = new Link($this->page_link($this->lastpage - 1), $this->lastpage, $this->ajax, $this->id, $this->response_target); $template = new Template($this->pagination_template); $rendered = $template->render(array('count' => $this->count, 'lowerBound' => $this->lowerBound, 'upperBound' => $this->upperBound, 'pageno' => $this->pageno, 'firstpage' => $this->firstpage, 'lastpage' => $this->lastpage, 'firstpagelink' => $firstpagelink->build(), 'prevpagelink' => $prevpagelink->build(), 'fourprevpagelink' => $fourprevpagelink->build(), 'threeprevpagelink' => $threeprevpagelink->build(), 'twoprevpagelink' => $twoprevpagelink->build(), 'oneprevpagelink' => $oneprevpagelink->build(), 'onenextpagelink' => $onenextpagelink->build(), 'twonextpagelink' => $twonextpagelink->build(), 'threenextpagelink' => $threenextpagelink->build(), 'fournextpagelink' => $fournextpagelink->build(), 'nextpagelink' => $nextpagelink->build(), 'lastpagelink' => $lastpagelink->build(), 'class' => $class)); return $rendered; }
$next = new Link(); if ($is_view) { $next->setHref('controller.php?cmd=table_browse&table=' . $req->get('table') . '&direction=next&view=true'); } else { $next->setHref('controller.php?cmd=table_browse&table=' . $req->get('table') . '&direction=next'); } $next->setName('[>]'); $next->build(); $lastlink = new Link(); if ($is_view) { $lastlink->setHref('controller.php?cmd=table_browse&table=' . $req->get('table') . '&direction=last&view=true'); } else { $lastlink->setHref('controller.php?cmd=table_browse&table=' . $req->get('table') . '&direction=last'); } $lastlink->setName('[-->>]'); $lastlink->build(); $low = $sessie->getS('bottom') + 1; $high = $sessie->getS('bottom') + LIMIT; if ($high > $records) { $high = $records; } $body->line(' (total # of records : <b> ' . $records . '</b> -- showing <b>' . $low . '</b> till <b>' . $high . '</b>)<br />'); $titles = FALSE; $table = new Table(); $table->setClas('result'); $table->setId('listing'); $table->build(); foreach ($res as $item) { /**/ if (!$titles) { $tr = new Th();