Feature 1559 : remove custom function (std) for sqlite

git-svn-id: http://piwigo.org/svn/trunk@5503 68402e56-0260-453c-a942-63ccdbb3a9ee
Piwigo · Mar 31, 2010 · c790511 · c790511
1 parent fc99828
commit c790511
Show file tree

Hide file tree

Showing 2 changed files with 0 additions and 58 deletions.
diff --git a/include/dblayer/functions_pdo-sqlite.inc.php b/include/dblayer/functions_pdo-sqlite.inc.php
@@ -50,7 +50,6 @@ function pwg_db_connect($host, $user, $password, $database)
   $link->sqliteCreateFunction('md5', 'md5', 1);
   $link->sqliteCreateFunction('if', 'pwg_if', 3);
 
-  $link->sqliteCreateAggregate('std', 'pwg_std_step', 'pwg_std_finalize');
   $link->sqliteCreateFunction('regexp', 'pwg_regexp', 2);
 
   return $link;
@@ -566,32 +565,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);
-}
 ?>
diff --git 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);
-}
 ?>