From a04917816df17fb43979ecb4299d84ac3ae7e6e7 Mon Sep 17 00:00:00 2001
From: "Matteo Nastasi (mop)" <nastasi@alternativeoutput.it>
Date: Thu, 15 Oct 2015 18:38:30 +0200
Subject: [PATCH] add game_cnt and match_cnt fields to bsk_users table

---
 sql/sql.d/071-apprentice.sql |  8 ++++++++
 web/Obj/dbase_base.phh       | 27 +++++++++++++++++++++++++--
 2 files changed, 33 insertions(+), 2 deletions(-)

diff --git a/sql/sql.d/071-apprentice.sql b/sql/sql.d/071-apprentice.sql
index 376427b..eb905b7 100644
--- a/sql/sql.d/071-apprentice.sql
+++ b/sql/sql.d/071-apprentice.sql
@@ -6,3 +6,11 @@ CREATE TABLE #PFX#selfreg_chk (
        ip         integer,                           -- ip v4 address
        atime      timestamp DEFAULT to_timestamp(0)  -- access time
        );
+
+--
+--  Add counters to show how many matches and games are played
+--
+ALTER TABLE #PFX#users DROP COLUMN match_cnt;
+ALTER TABLE #PFX#users ADD COLUMN match_cnt integer DEFAULT 0;
+ALTER TABLE #PFX#users DROP COLUMN game_cnt;
+ALTER TABLE #PFX#users ADD COLUMN game_cnt integer DEFAULT 0;
diff --git a/web/Obj/dbase_base.phh b/web/Obj/dbase_base.phh
index b79e176..1e7a19a 100644
--- a/web/Obj/dbase_base.phh
+++ b/web/Obj/dbase_base.phh
@@ -34,8 +34,11 @@ class LoginDBItem {
     var $tos_vers;
     var $disa_reas;
     var $guar_code;
+    var $match_cnt;
+    var $game_cnt;
 
-    function LoginDBItem($code, $login, $pass, $email, $type, $last_dona, $supp_comp, $tos_vers, $disa_reas, $guar_code)
+    function LoginDBItem($code, $login, $pass, $email, $type, $last_dona, $supp_comp, $tos_vers,
+                         $disa_reas, $guar_code, $match_cnt, $game_cnt)
     {
         $this->code      = $code;
         $this->login     = $login;
@@ -47,13 +50,16 @@ class LoginDBItem {
         $this->tos_vers  = $tos_vers;
         $this->disa_reas = $disa_reas;
         $this->guar_code = $guar_code;
+        $this->match_cnt = $match_cnt;
+        $this->game_cnt  = $game_cnt;
     }
 
     static function LoginDBItemFromRecord($rec)
     {
         $ret = new LoginDBItem($rec->code, $rec->login, $rec->pass, 
                                $rec->email, $rec->type, $rec->last_dona,
-                               $rec->supp_comp, $rec->tos_vers, $rec->disa_reas, $rec->guar_code);
+                               $rec->supp_comp, $rec->tos_vers, $rec->disa_reas, $rec->guar_code,
+                               $rec->match_cnt, $rec->game_cnt);
 
         return ($ret);
     }
@@ -119,6 +125,23 @@ class LoginDBItem {
         return $this->guar_code;
     }
 
+    function match_cnt_get()
+    {
+        return $this->match_cnt;
+    }
+    function match_cnt_add($v)
+    {
+        return $this->match_cnt += $v;
+    }
+
+    function game_cnt_get()
+    {
+        return $this->game_cnt;
+    }
+    function game_cnt_add($v)
+    {
+        return $this->game_cnt += $v;
+    }
 }
 
 define('MAIL_TYP_CHECK', 1);
-- 
2.17.1