コード例 #1
0
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));
}
コード例 #2
0
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)));
}
コード例 #3
0
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));
}
コード例 #4
0
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;
    }
}
コード例 #5
0
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));
}
コード例 #6
0
ファイル: Page.php プロジェクト: KuberKode/grase-www-portal
 public function displayPage($template)
 {
     \assign_vars($this->te);
     $this->setupTemplateVariables();
     return $this->te->display($template);
 }