NEW FEATURE: list game points in last email

add a few lines to show the total amount of game points for this game in the email
that gets send out

diff --git a/index.php b/index.php
index a0e2fb2445180d6c407fb43417c761c6ee167307..8acb8715b28289a76a7daf1b048db88c7b85026e 100644 (file)
--- a/index.php
+++ b/index.php
@@ -1638,6 +1638,30 @@ else if(myisset("me"))
                    }
 
 
+                 /* add score points to email */
+                 $message .= "\n";
+                 $Tpoint = 0;
+                 $message .= " Points Re: \n";
+                 $queryresult = mysql_query("SELECT score FROM Score ".
+                                            "  WHERE game_id=$gameid AND party='re'".
+                                            " ");
+                 while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+                   {
+                     $message .= "   ".$r[0]."\n";
+                     $Tpoint ++;
+                   }
+                 $message .= " Points Contra: \n";
+                 $queryresult = mysql_query("SELECT score FROM Score ".
+                                            "  WHERE game_id=$gameid AND party='contra'".
+                                            " ");
+                 while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+                   {
+                     $message .= "   ".$r[0]."\n";
+                     $Tpoint --;
+                   }
+                 $message .= " Total Points (from Re points of view): $Tpoint\n";
+                 $message .= "\n";
+
                  /* send out final email */
                  $all = array();