diff options
Diffstat (limited to 'include/dblayer/functions_sqlite.inc.php')
-rw-r--r-- | include/dblayer/functions_sqlite.inc.php | 29 |
1 files changed, 0 insertions, 29 deletions
diff --git a/include/dblayer/functions_sqlite.inc.php b/include/dblayer/functions_sqlite.inc.php index 7f02a06d1..48bb5fd89 100644 --- a/include/dblayer/functions_sqlite.inc.php +++ b/include/dblayer/functions_sqlite.inc.php @@ -59,7 +59,6 @@ function pwg_db_connect($host, $user, $password, $database) $link->createFunction('md5', 'md5', 1); $link->createFunction('if', 'pwg_if', 3); - $link->createAggregate('std', 'pwg_std_step', 'pwg_std_finalize'); $link->createFunction('regexp', 'pwg_regexp', 2); return $link; @@ -578,32 +577,4 @@ function pwg_regexp($pattern, $string) $pattern = sprintf('`%s`', $pattern); return preg_match($pattern, $string); } - -function pwg_std_step(&$values, $rownumber, $value) -{ - $values[] = $value; - - return $values; -} - -function pwg_std_finalize(&$values, $rownumber) -{ - if (count($values)<=1) - { - return 0; - } - - $total = 0; - $total_square = 0; - foreach ($values as $value) - { - $total += $value; - $total_square += pow($value, 2); - } - - $mean = $total/count($values); - $var = $total_square/count($values) - pow($mean, 2); - - return sqrt($var); -} ?> |