function show_guestbook_add_page($dbconn, $diary_login) { $sql = "SELECT u.uid, s.page_guestbook_add FROM " . TABLE_USERS . " AS u, " . TABLE_SETTINGS . " AS s WHERE s.uid=u.uid AND u.login='******' LIMIT 1"; $result = pg_query($sql) or die(pg_last_error($dbconn)); $data = pg_fetch_object($result, NULL); echo assign_vars($data->page_guestbook_add, array('{login}' => $diary_login, '{hrefguestbook}' => 'http://' . $_SERVER['SERVER_NAME'] . '/' . PAGE_GUESTBOOK)); }
function show_main_page($dbconn, $diary_login) { $sql = "SELECT u.uid, s.page_main, s.format_note FROM " . TABLE_SETTINGS . " AS s, " . TABLE_USERS . " AS u WHERE u.login='******' AND s.uid=u.uid LIMIT 1"; $result = pg_query($dbconn, $sql) or die(pg_last_error($dbconn)); $data = pg_fetch_object($result, NULL); echo assign_vars($data->page_main, array('{login}' => $diary_login, '{diary}' => get_last_notes($dbconn, $diary_login, $data->format_note), '{hrefguestbook}' => 'http://' . $_SERVER['SERVER_NAME'] . '/' . PAGE_GUESTBOOK, '{archive}' => get_archive($dbconn, $diary_login), '{links}' => get_links($dbconn, $diary_login))); }
function show_error_page($dbconn, $diary_login, $message) { $sql = "SELECT u.uid, s.page_error FROM " . TABLE_SETTINGS . " AS s, " . TABLE_USERS . " AS u WHERE u.login='******' AND s.uid=u.uid LIMIT 1"; $result = pg_query($sql) or die(pg_last_error($dbconn)); $data = pg_fetch_object($result, NULL); pg_free_result($result); echo assign_vars($data->page_error, array('{login}' => $diary_login, '{errormessage}' => $message)); }
function show_archive_page($dbconn, $diary_login, $mode) { $nid = empty($_GET['nid']) ? NULL : (int) $_GET['nid']; $month = empty($_GET['month']) ? NULL : (int) $_GET['month']; $year = empty($_GET['year']) ? NULL : (int) $_GET['year']; $sql = "SELECT u.uid, s.page_archive, s.format_note FROM " . TABLE_SETTINGS . " AS s, " . TABLE_USERS . " AS u WHERE u.login='******' AND s.uid=u.uid LIMIT 1"; $result = pg_query($sql) or die(pg_last_error($dbconn)); $settings = pg_fetch_object($result, NULL); switch ($mode) { case SHOW_NOTE: $sql2 = "SELECT COUNT(*) AS commentscount FROM " . TABLE_COMMENTS . " AS c WHERE c.uid='1' AND c.nid='" . $nid . "'"; $result2 = pg_query($sql2) or die(pg_last_error($dbconn)); $data2 = pg_fetch_object($result2, NULL); echo assign_vars($settings->page_archive, array('{login}' => $diary_login, '{archive}' => get_note($dbconn, $diary_login, $settings->format_note, $nid), '{commentscount}' => $data2->commentscount)); break; case SHOW_MONTH: $sql = "SELECT * FROM notes"; $result = pg_query($sql) or die(pg_last_error($dbconn)); $data = pg_fetch_object($result, NULL); echo assign_vars($settings->page_archive, array('{login}' => $diary_login, '{archive}' => get_archive_notes($dbconn, $diary_login, $settings->format_note, $month, $year))); break; } }
function show_comment_add_page($dbconn, $diary_login) { $nid = (int) $_GET['nid']; $sql = "SELECT u.uid, s.page_comment_add FROM " . TABLE_USERS . " AS u, " . TABLE_SETTINGS . " AS s WHERE s.uid=u.uid AND u.login='******' LIMIT 1"; $result = pg_query($sql) or die(pg_last_error($dbconn)); $data = pg_fetch_object($result, NULL); echo assign_vars($data->page_comment_add, array('{login}' => $diary_login, '{hrefcomment}' => 'http://' . $_SERVER['SERVER_NAME'] . '/' . PAGE_COMMENTS . '&nid=' . $nid, '{nid}' => $nid)); }
public function displayPage($template) { \assign_vars($this->te); $this->setupTemplateVariables(); return $this->te->display($template); }