3 # Copyright (c) 2008, 2009, Simon Morgan <sjm@spamcop.net>
5 # Permission to use, copy, modify, and/or distribute this software for any
6 # purpose with or without fee is hereby granted, provided that the above
7 # copyright notice and this permission notice appear in all copies.
9 # THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
10 # WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
11 # MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
12 # ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
13 # WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
14 # ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
15 # OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
18 #import cgitb; cgitb.enable()
24 form
= cgi
.FieldStorage()
26 print "Content-type: text/html; charset=UTF-8\n"
28 print '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">'
31 common
.print_headers(config
.TITLE
)
33 conn
= common
.connect()
35 numposts
= common
.getnumposts(conn
)
37 print '<p>Nothing here yet. How about you <a href="post.cgi">post</a> something interesting?</p>'
39 if form
.has_key("id"):
40 if common
.getnumposts(conn
, form
.getvalue("id")) > 0:
41 (title
, text
, date
) = conn
.execute("SELECT title, text, date FROM entries WHERE id = ?", (form
.getvalue("id"),)).fetchone()
42 common
.print_post(title
, text
, date
)
44 common
.print_error("No such post.")
47 if form
.has_key("offset"):
48 offset
= int(form
.getvalue("offset"))
49 for (postid
, title
, text
, date
) in conn
.execute("SELECT id, title, text, date FROM entries ORDER BY date DESC LIMIT ? OFFSET ?", (config
.NUMPOSTS
, offset
)):
50 title
= '<a href="index.cgi?id=%s">%s</a>' % (postid
, title
)
51 common
.print_post(title
, text
, date
)
53 # Only print the navigation bar if the number of posts exceeds
54 # the number to be displayed per page.
55 if numposts
> config
.NUMPOSTS
:
56 print '<div id="navigation">'
58 newoffset
= offset
- config
.NUMPOSTS
61 print '<a href="index.cgi?offset=%s">Prev</a>' % newoffset
62 if offset
+ config
.NUMPOSTS
< numposts
:
63 newoffset
= offset
+ config
.NUMPOSTS
64 print '<a href="index.cgi?offset=%s">Next</a>' % newoffset