X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRoot.pm;h=2b16db2b71cc6435af34a4be89360eda88796963;hb=af67320b296a7ebc59fcbe227efc2b0362c0a13d;hp=cda2e94f62f1f5d20958bf809ff7b9d640e3ce22;hpb=3f84c80fb02cc6c90abe1979359ecad3d529676d;p=ndwebbie.git 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,