From 973edb08ed5ff35644328c244d5d584f44a70591 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?John=20Ankarstr=C3=B6m?= <john@ankarstrom.se>
Date: Sat, 18 Sep 2021 11:58:56 +0200
Subject: Implement `add' functions

---
 t/front.t | 18 +++++++++++++++---
 t/user.t  | 10 ++++++++++
 2 files changed, 25 insertions(+), 3 deletions(-)

(limited to 't')

diff --git a/t/front.t b/t/front.t
index a12d712..9d39469 100644
--- a/t/front.t
+++ b/t/front.t
@@ -2,14 +2,26 @@
 <h1><%= site.name %></h1>
 <h3>Latest posts</h3>
 <table border="1">
-	<% while(post = nextpost(stmt)){
-		user = getuser(byid("users", post->user)); %>
+	<% while(post = nextpost(pstmt)){
+		user = getuser(selectbyint("users", "oid", 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>
 		<td><% printdate(post->created); %></td>
 	</tr>
-	<% free(post);
+	<% free(user);
+	free(post);
+	} %>
+</table>
+<h3>Latest users</h3>
+<table border="1">
+	<% while(user = nextuser(ustmt)){ %>
+	<tr>
+		<td><a href="?user=<% printf("%d", user->id); %>"><%= user->name %></a></td>
+		<td><%= user->full %></td>
+		<td><% printdate(user->created); %></td>
+	</tr>
+	<% free(user);
 	} %>
 </table>
 <% #include "foot.tc" %>
\ No newline at end of file
diff --git a/t/user.t b/t/user.t
index af7c8cd..b69633a 100644
--- a/t/user.t
+++ b/t/user.t
@@ -1,3 +1,13 @@
 <% #include "head.tc" %>
 <h1>User <% printf("%d", id); %>: <%= user->name %></h1>
+<h3>Latest posts</h3>
+<table border="1">
+	<% while(post = nextpost(stmt)){ %>
+	<tr>
+		<td><a href="?post=<% printf("%d", post->id); %>"><%= post->subject %></a></td>
+		<td><% printdate(post->created); %></td>
+	</tr>
+	<% free(post);
+	} %>
+</table>
 <% #include "foot.tc" %>
\ No newline at end of file
-- 
cgit v1.2.3