Cache the title and userid of the notifications

These aren't likely to change anyway, and things will become less easy
to display when other types of notifications are added.

1 files changed, 2 insertions, 9 deletions

diff --git a/lib/VNDB/DB/Users.pm b/lib/VNDB/DB/Users.pm
index 63ac2270..bade6ca1 100644
--- a/lib/VNDB/DB/Users.pm
+++ b/lib/VNDB/DB/Users.pm
@@ -177,21 +177,14 @@ sub dbNotifyGet {
   );
 
   my @join = (
-    $o{what} =~ /titles/ ? (
-      q|LEFT JOIN threads t ON n.ltype = 't' AND t.id = n.iid|,
-      q|LEFT JOIN threads_posts tp ON n.ltype = 't' AND tp.tid = t.id AND n.subid = tp.num|,
-      q|LEFT JOIN users tu ON tp.uid = tu.id|
-    ) : ()
+    $o{what} =~ /titles/ ? 'LEFT JOIN users u ON n.c_byuser = u.id' : (),
   );
 
   my @select = (
     qw|n.id n.ntype n.ltype n.iid n.subid|,
     q|extract('epoch' from n.date) as date|,
     q|extract('epoch' from n.read) as read|,
-    $o{what} =~ /titles/ ? (
-      q|COALESCE(t.title,'') AS title|,
-      q|COALESCE(tu.username,'') AS subtitle|,
-    ) : (),
+    $o{what} =~ /titles/ ? qw|u.username n.c_title| : (),
   );
 
   my($r, $np) = $s->dbPage(\%o, q|