X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRoot.pm;h=2b16db2b71cc6435af34a4be89360eda88796963;hp=cda2e94f62f1f5d20958bf809ff7b9d640e3ce22;hb=f6206b8cc6a5d1acfacebe8cabda5889e3369a14;hpb=bbf7be110f409388f96635a412854a9a2de644dc diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm index cda2e94..2b16db2 100644 --- a/lib/NDWeb/Controller/Root.pm +++ b/lib/NDWeb/Controller/Root.pm @@ -172,7 +172,8 @@ sub end : ActionClass('RenderView') { $fleetupdate = 0 unless defined $fleetupdate; } - my ($unread,$newposts) = $dbh->selectrow_array(unread_query,undef,$c->user->id) or die $dbh->errstr; + my ($unread,$newposts) = $dbh->selectrow_array(q{SELECT * FROM unread_posts($1)} + ,undef,$c->user->id); $c->stash(user => { id => $c->user->id,