CLEANUP: fixed a typo, changed copyright, added Jeff for database scheme

diff --git a/include/output.php b/include/output.php
index e4a06e8f078488ae373a192cf2f03607052989da..48f31e4ac73ff3b5b80f74d7f12ea36c1c16d81b 100644 (file)
--- a/include/output.php
+++ b/include/output.php
@@ -317,7 +317,7 @@ function output_footer()
 
   echo "</div>\n\n";
   echo "<div class=\"footer\">\n";
 
   echo "</div>\n\n";
   echo "<div class=\"footer\">\n";

-  echo "  <p class=\"left\"> copyright 2006-2008 Arun Persaud, Lance Thornton <br />\n".
+  echo "  <p class=\"left\"> copyright 2006-2009 Arun Persaud, Lance Thornton(graphics), Jeff Zerger(database support) <br />\n".

     "  Verwendung der [deutschen] Kartenbilder mit Genehmigung <br />der Spielkartenfabrik Altenburg GmbH,(c) ASS Altenburger <br />\n".
     "  - ASS Altenburger Spielkarten - Spielkartenfabrik Altenburg GmbH <br />\n".
     "  a Carta Mundi Company Email: info@spielkarten.com Internet: www.spielkarten.com</p>\n";
     "  Verwendung der [deutschen] Kartenbilder mit Genehmigung <br />der Spielkartenfabrik Altenburg GmbH,(c) ASS Altenburger <br />\n".
     "  - ASS Altenburger Spielkarten - Spielkartenfabrik Altenburg GmbH <br />\n".
     "  a Carta Mundi Company Email: info@spielkarten.com Internet: www.spielkarten.com</p>\n";

diff --git a/include/stats.php b/include/stats.php
index dad254c3ef82b19a5327b3232dbdc3be2472bffa..8c83b6d87a6238b8ed7a42a0bcaa60df85981315 100644 (file)
--- a/include/stats.php
+++ b/include/stats.php
@@ -207,7 +207,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) )
   array_unshift($result,array("Name","Number of active games"));
   echo output_table($result,"Active games","stats");
 
   array_unshift($result,array("Name","Number of active games"));
   echo output_table($result,"Active games","stats");
 

-  /* respones by user*/
+  /* response time of users*/

   $result = DB_query_array_all("SELECT User.fullname,".
                               "IFNULL(AVG(if(P1.sequence in (2,3,4),".
                               "-timestampdiff(MINUTE,mod_date,(select mod_date from Play P2 where P1.trick_id=P2.trick_id  and P2.sequence=P1.sequence-1)),NULL )),1e9) as a, ".
   $result = DB_query_array_all("SELECT User.fullname,".
                               "IFNULL(AVG(if(P1.sequence in (2,3,4),".
                               "-timestampdiff(MINUTE,mod_date,(select mod_date from Play P2 where P1.trick_id=P2.trick_id  and P2.sequence=P1.sequence-1)),NULL )),1e9) as a, ".


@@ -219,7 +219,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) )
                               "GROUP BY user_id ".
                               "HAVING na>8 ".
                               "ORDER BY a " );
                               "GROUP BY user_id ".
                               "HAVING na>8 ".
                               "ORDER BY a " );

-  array_unshift($result,array("Name","Average minutes before respond","NR"));
+  array_unshift($result,array("Name","Average minutes before response","trick count"));

   echo output_table($result,"Response","stats");
 
   /*
   echo output_table($result,"Response","stats");
 
   /*