X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FCovOp.pm;h=faf4296660d9de465ec6436a44106b00b286e412;hb=740a99f01c0ee354ec1681e8d1d5ba5bf166b724;hp=21a47ebeb571c3d4d3e16d5fcb54ab6152c7b5cc;hpb=afc9eb5d8aa7c2c0af9906f236e23f1bcd0e7236;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/CovOp.pm b/lib/NDWeb/Controller/CovOp.pm index 21a47eb..faf4296 100644 --- a/lib/NDWeb/Controller/CovOp.pm +++ b/lib/NDWeb/Controller/CovOp.pm @@ -50,12 +50,12 @@ sub list : Private { my $dbh = $c->model; my $query = $dbh->prepare(q{SELECT id, coords, metal, crystal, eonium - , covop_alert(seccents,structures,gov,0) AS minalert - , covop_alert(seccents,structures,gov,50) AS maxalert + , covop_alert(seccents,structures,size,guards,gov,0) AS minalert + , covop_alert(seccents,structures,size,guards,gov,50) AS maxalert , distorters,gov , MaxResHack,co.tick AS lastcovop - FROM (SELECT p.id,coords(x,y,z), metal,crystal,eonium, - seccents,NULLIF(ss.total::integer,0) AS structures,distorters + FROM (SELECT p.id,coords(x,y,z),size, metal,crystal,eonium,guards + ,seccents,NULLIF(ss.total::integer,0) AS structures,distorters ,max_bank_hack(metal,crystal,eonium,p.value ,(SELECT value FROM current_planet_stats WHERE id = ?)) AS MaxResHack , planet_status, relationship,gov