From 0292e86cf884a26108a59d81d69cee83b54f4c88 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?John=20Ankarstr=C3=B6m?= <john@ankarstrom.se>
Date: Sat, 18 Sep 2021 10:38:09 +0200
Subject: Clean up database code

---
 t/front.t |  4 ++--
 t/post.t  | 10 +++++-----
 2 files changed, 7 insertions(+), 7 deletions(-)

(limited to 't')

diff --git a/t/front.t b/t/front.t
index fcdecdb..fd9f46c 100644
--- a/t/front.t
+++ b/t/front.t
@@ -2,8 +2,8 @@
 <h1><%= site.name %></h1>
 <h3>Latest posts</h3>
 <table border="1">
-	<% while(post = getpost(stmt, 0)){
-		user = getuser(byid("users", post->user), 1); %>
+	<% while(post = nextpost(stmt)){
+		user = getuser(byid("users", post->user)); %>
 	<tr>
 		<td><a href="?post=<% printf("%d", post->id); %>"><%= post->subject %></a></td>
 		<td><a href="?user=<% printf("%d", post->user); %>"><%= user->name %></a></td>
diff --git a/t/post.t b/t/post.t
index 549b4ec..b1cbe99 100644
--- a/t/post.t
+++ b/t/post.t
@@ -13,16 +13,16 @@
 <pre>
 <%= post->text %>
 </pre>
-<% if(attachment = getattachment(stmt, 0)){ %>
+<% if(att = nextatt(stmt)){ %>
 <h3>Attachments</h3>
 <table border="1">
 	<% do{ %>
 	<tr>
-		<td><a href="?attachment=<% printf("%d", attachment->id); %>"><%= attachment->name %></a></td>
-		<td><%= attachment->mime %></td>
-		<td><%= attachment->description %></td>
+		<td><a href="?att=<% printf("%d", att->id); %>"><%= att->name %></a></td>
+		<td><%= att->mime %></td>
+		<td><%= att->description %></td>
 	</tr>
-	<% }while(attachment = getattachment(stmt, 0)); %>
+	<% }while(att = nextatt(stmt)); %>
 </table>
 <% } %>
 <% #include "foot.tc" %>
\ No newline at end of file
-- 
cgit v1.2.3