X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Ffunctions%2Fcovop_alert.sql;fp=database%2Ffunctions%2Fcovop_alert.sql;h=ea7212892904b6e5ef83dbf8ca4330645cb74bea;hp=1d3d2a6b7a4e85f3776b9b362934b0f3c0f93f67;hb=3dc80cedd5deba53a4082992de317fbc3acf805c;hpb=23e133163ef06e0afc2000152df31c966f4929b2 diff --git a/database/functions/covop_alert.sql b/database/functions/covop_alert.sql index 1d3d2a6..ea72128 100644 --- a/database/functions/covop_alert.sql +++ b/database/functions/covop_alert.sql @@ -1,6 +1,5 @@ - CREATE OR REPLACE FUNCTION covop_alert(secs integer, strucs integer, roids integer - , guards integer, gov governments, population integer) RETURNS integer + , guards integer, gov text, population integer) RETURNS integer AS $_$ SELECT ((50 + COALESCE($4*5.0/($3+1.0),$6)) * (1.0+2*LEAST(COALESCE($1::float/CASE $2