From 0edb4b26c049e07af0970e081fab699d2bdd333b Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Thu, 30 Apr 2009 00:08:10 -0700
Subject: [PATCH 1/1] NEW FEATURE: show number of tricks a person made

only shows 0,1,few or many tricks, so that we don't give too much information away. Might adjust or change this in the future.
This addresses issues #11.
---
 css/standard021.css   | 17 +++++++++++++----
 include/db.php        |  6 ++++++
 include/functions.php | 17 +++++++++++++++++
 include/game.php      |  1 +
 4 files changed, 37 insertions(+), 4 deletions(-)

diff --git a/css/standard021.css b/css/standard021.css
index 6488b8f..6957924 100644
--- a/css/standard021.css
+++ b/css/standard021.css
@@ -270,7 +270,9 @@ hr {clear:both;}
 /*ul.tricks li:hover div.table{ display:block; }*/
 
 /* left player */
-ul.tricks li div div.card0 img,ul.tricks li div div.card0 .score, .vorbehalt0 {
+ul.tricks li div div.card0 img,
+ul.tricks li div div.card0 .score,
+.vorbehalt0 {
   position:absolute;
   margin:0;
   padding:0;
@@ -281,6 +283,7 @@ ul.tricks li div div.card0 img,ul.tricks li div div.card0 .score, .vorbehalt0 {
   width:6%;
   z-index:30;
 }
+
 .vorbehalt0 {
   left:37.5%;
   right:57.5%;
@@ -299,7 +302,9 @@ ul.tricks li div div.card0 span.comment{
 }
 
 /* top player */
-ul.tricks li div div.card1 img,ul.tricks li div div.card1 .score, .vorbehalt1 {
+ul.tricks li div div.card1 img,
+ul.tricks li div div.card1 .score,
+.vorbehalt1 {
   position:absolute;
   margin:0;
   padding:0;
@@ -330,7 +335,9 @@ ul.tricks li div div.card1 span.comment{
 }
 
 /* right player */
-ul.tricks li div div.card2 img,ul.tricks li div div.card2 .score, .vorbehalt2{
+ul.tricks li div div.card2 img,
+ul.tricks li div div.card2 .score,
+.vorbehalt2{
   position:absolute;
   margin:0;
   padding:0;
@@ -360,7 +367,9 @@ ul.tricks li div div.card2 span.comment{
 }
 
 /* bottom player */
-ul.tricks li div div.card3 img,ul.tricks li div div.card3 .score, .vorbehalt3{
+ul.tricks li div div.card3 img,
+ul.tricks li div div.card3 .score,
+.vorbehalt3{
   position:absolute;
   margin:0;
   padding:0;
diff --git a/include/db.php b/include/db.php
index 3d9d98c..b8b184d 100644
--- a/include/db.php
+++ b/include/db.php
@@ -1149,4 +1149,10 @@ function DB_played_by_others($gameid)
       $gameids[]=$r[0];
   return $gameids;
 }
+
+function DB_get_number_of_tricks($gameid,$position)
+{
+  $r = DB_query_array("SELECT COUNT(winner) FROM Trick Where game_id='$gameid' and winner='$position'");
+  return $r[0];
+}
 ?>
\ No newline at end of file
diff --git a/include/functions.php b/include/functions.php
index e57c2e5..3e21e6d 100644
--- a/include/functions.php
+++ b/include/functions.php
@@ -816,6 +816,7 @@ function display_table ()
       $call      = $r[5];
       $hash      = $r[7];
       $timezone  = $r[8];
+      $wins      = DB_get_number_of_tricks($gameid,$pos);
       date_default_timezone_set($defaulttimezone);
       $lastlogin = strtotime($r[6]);
       date_default_timezone_set($timezone);
@@ -939,6 +940,22 @@ function display_table ()
 	                     "last login: ".date("Y-m-d H:i:s",$lastlogin)."\">".
 			     "<img src=\"pics/button/time-info.png\" class=\"tinybutton\" alt=\"time info\" />".
 			     "</span>\n";
+
+      /* show how many tricks the person made */
+      switch($wins)
+	{
+	case 0:
+	  echo "#tricks 0"; break;
+	case 1:
+	  echo "#tricks 1"; break;
+	case 2:
+	case 3:
+	case 4:
+	  echo "#tricks few"; break;
+	default:
+	  echo "#tricks many"; break;
+	}
+
       echo "   </div>\n";
 
     }
diff --git a/include/game.php b/include/game.php
index f9daf65..a11e6b6 100644
--- a/include/game.php
+++ b/include/game.php
@@ -1295,6 +1295,7 @@ switch($mystatus)
 	/* end of trick? */
 	if($seq==4)
 	  {
+	    $winner    = get_winner($play,$gametype); /* returns the position */
 	    echo "    </div>\n  </li>\n";  /* end div trick, end li trick */
 	  }
       }
-- 
2.25.1