X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=6dcc1f67e5f3563fd440a23579f09ab9c63fd0f3;hb=77bd36f5189b0de25ff99ffec16d9e9187feb2fd;hp=bb31b694b6484b96cdca34a533bf148eb4ed5b13;hpb=49d3f8fb2b3bcf25f88d909e7982b20f1db3246d;p=ndwebbie.git

diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm
index bb31b69..6dcc1f6 100644
--- a/lib/NDWeb/Controller/Members.pm
+++ b/lib/NDWeb/Controller/Members.pm
@@ -32,7 +32,7 @@ sub index : Path : Args(0) {
 	$c->stash(comma => \&comma_value);
 	$c->stash(u => $dbh->selectrow_hashref(q{SELECT planet,defense_points
 			,attack_points,scan_points,humor_points
-			, (attack_points+defense_points+scan_points/20) as total_points
+			, (attack_points+defense_points+scan_points/20)::NUMERIC(5,1) as total_points
 			, sms,rank,hostmask FROM users WHERE uid = ?
 			},undef,$c->user->id)
 	);
@@ -265,6 +265,7 @@ sub postircrequest : Local {
 		(uid,channel,message) VALUES($1,$2,$3)
 		});
 	$query->execute($c->user->id,$c->req->param('channel'),$c->req->param('message'));
+	system 'killall','-USR1', 'irssi';
 
 	$c->flash(reply => "Msg sent to: ".$c->req->param('channel'));
 	$c->res->redirect($c->uri_for('ircrequest'));
@@ -285,7 +286,7 @@ sub points : Local {
 
 	my $query = $dbh->prepare(qq{SELECT username,defense_points,attack_points
 		,scan_points,humor_points
-		,(attack_points+defense_points+scan_points/20) as total_points
+		,(attack_points+defense_points+scan_points/20)::NUMERIC(4,0) as total_points
 		, count(NULLIF(rc.launched,FALSE)) AS raid_points
 		FROM users u LEFT OUTER JOIN raid_claims rc USING (uid)
 		WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 2)