Changeset 25532
- Timestamp:
- 12/01/08 13:27:02 (4 years ago)
- Location:
- lang/perl/MENTA/trunk/app
- Files:
-
- 4 modified
-
controller/demo/bbs.mt (modified) (1 diff)
-
controller/demo/bbs_sqlite.pl (modified) (2 diffs)
-
data/data.sqlite (modified) (previous)
-
data/session.dbm.pag (modified) (previous)
Legend:
- Unmodified
- Added
- Removed
-
lang/perl/MENTA/trunk/app/controller/demo/bbs.mt
r25380 r25532 2 2 ?= render('header.mt', 'SQLite をつかった一行掲示板') 3 3 <div class="blocked-content"> 4 <form method="post" action="<?= uri_for('demo/bbs_sqlite') ?>"> 5 <input type="text" name="body"> 6 <input type="submit" value="送信"> 7 </form> 4 5 ? if (my $user = openid_get_user()) { 6 <?= $user->{nickname} ?> さんこんにちは 7 8 <form method="post" action="<?= uri_for('demo/bbs_sqlite') ?>"> 9 <input type="text" name="body"> 10 <input type="submit" value="送信"> 11 </form> 12 13 <form method="post" action="<?= session_logout_url(uri_for('demo/openid')) ?>"> 14 <input type="submit" value="ログアウト" /> 15 </form> 16 ? } else { 17 発言するにはログインが必要です (個人情報は記録/公開されます) 18 <ul> 19 <? my $map = openid_login_url_map( cancelled => uri_for('demo/bbs'), verified => uri_for('demo/bbs') ) ?> 20 <? while (my ($name, $url) = each %$map) { ?> 21 <li><a href="<?= $url ?>"><?= $name ?> でログイン</a></li> 22 <? } ?> 23 </ul> 24 ? } 8 25 9 26 <ul> 10 27 ? for my $entry (@{$entries}) { 11 <li class="hentry"><?= $entry->{id} ?> <?= $entry->{body} ?> </li>28 <li class="hentry"><?= $entry->{id} ?> <?= $entry->{body} ?> by <a href="<?= $entry->{openid} ?>"><?= $entry->{nickname} ?></a></li> 12 29 ? } 13 30 </ul> -
lang/perl/MENTA/trunk/app/controller/demo/bbs_sqlite.pl
r25415 r25532 2 2 3 3 sub run { 4 sql_prepare_exec(q{CREATE TABLE IF NOT EXISTS entries (id INTEGER PRIMARY KEY, body VARCHAR(255))});4 sql_prepare_exec(q{CREATE TABLE IF NOT EXISTS entries (id INTEGER PRIMARY KEY, nickname VARCHAR(255), openid TEXT, body VARCHAR(255))}); 5 5 6 6 if (is_post_request()) { 7 my $user = openid_get_user(); 7 8 my $body = param('body'); 8 if ($body ) {9 sql_prepare_exec('INSERT INTO entries (body ) VALUES (?)', $body);9 if ($body && $user) { 10 sql_prepare_exec('INSERT INTO entries (body, nickname, openid) VALUES (?, ?, ?)', $body, $user->{nickname}, $user->{openid}); 10 11 } 11 12 redirect(uri_for('demo/bbs_sqlite')); 12 13 } else { 13 14 my ( $rows, $pager ) = sql_select_paginate( 14 'SELECT id, body FROM entries ORDER BY id DESC',15 'SELECT id, body, nickname, openid FROM entries ORDER BY id DESC', 15 16 [], 16 17 { … … 19 20 } 20 21 ); 21 render_and_print('demo/bbs.mt', $rows , $pager);22 render_and_print('demo/bbs.mt', $rows||[], $pager); 22 23 } 23 24 }
![(please configure the [header_logo] section in trac.ini)](/share/chrome/site/your_project_logo.png)