--- /dev/null
+ALTER TABLE users ALTER COLUMN defense_points TYPE NUMERIC(4,1);
+ALTER TABLE users ALTER COLUMN attack_points TYPE NUMERIC(3,0);
+UPDATE users set humor_points = -100 where humor_points < -100;
+ALTER TABLE users ALTER COLUMN humor_points TYPE NUMERIC(3,0);
+ALTER TABLE users ALTER COLUMN scan_points TYPE NUMERIC(5,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)
);
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)
<th><a href="[% c.uri_for('points','humor_points') %]">Humor</a></th>
</tr>
[% FOR m IN members %]
- <tr class="[% loop.count % 2 == 0 ? 'even' : 'odd' %]">
- <td>[% m.username %]</td>
+ <tr align="right" class="[% loop.count % 2 == 0 ? 'even' : 'odd' %]">
+ <td align="left">[% m.username %]</td>
<td>[% m.total_points %]</td>
<td>[% m.defense_points %]</td>
<td>[% m.attack_points %]</td>