From 4ebad93f7755f3a3b0ba650303cd6226f72e62b8 Mon Sep 17 00:00:00 2001
From: "Matteo Nastasi (mop)" <nastasi@alternativeoutput.it>
Date: Thu, 12 Dec 2013 07:15:53 +0100
Subject: [PATCH] add guar_code field to users table and related classes
 extensions

---
 sql/sql.d/064-user-guarant.sql |  3 +++
 web/Obj/dbase_base.phh         | 10 ++++++++--
 web/index_wr.php               |  1 -
 3 files changed, 11 insertions(+), 3 deletions(-)
 create mode 100644 sql/sql.d/064-user-guarant.sql

diff --git a/sql/sql.d/064-user-guarant.sql b/sql/sql.d/064-user-guarant.sql
new file mode 100644
index 0000000..980dab5
--- /dev/null
+++ b/sql/sql.d/064-user-guarant.sql
@@ -0,0 +1,3 @@
+-- add guarantee of a user
+ALTER TABLE #PFX#users DROP COLUMN guar_code;
+ALTER TABLE #PFX#users ADD COLUMN guar_code integer DEFAULT -1;  -- who guaranted this user
diff --git a/web/Obj/dbase_base.phh b/web/Obj/dbase_base.phh
index d0ca39a..d587352 100644
--- a/web/Obj/dbase_base.phh
+++ b/web/Obj/dbase_base.phh
@@ -33,8 +33,9 @@ class LoginDBItem {
     var $supp_comp;
     var $tos_vers;
     var $disa_reas;
+    var $guar_code;
 
-    function LoginDBItem($code, $login, $pass, $email, $type, $last_dona, $supp_comp, $tos_vers, $disa_reas)
+    function LoginDBItem($code, $login, $pass, $email, $type, $last_dona, $supp_comp, $tos_vers, $disa_reas, $guar_code)
     {
         $this->code      = $code;
         $this->login     = $login;
@@ -45,13 +46,14 @@ class LoginDBItem {
         $this->supp_comp = $supp_comp;
         $this->tos_vers  = $tos_vers;
         $this->disa_reas = $disa_reas;
+        $this->guar_code = $guar_code;
     }
 
     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->supp_comp, $rec->tos_vers, $rec->disa_reas, $rec->guar_code);
 
         return ($ret);
     }
@@ -112,6 +114,10 @@ class LoginDBItem {
     {
         $this->disa_reas = $disa_reas;
     }
+    function guar_code_get()
+    {
+        return $this->guar_code;
+    }
 
 }
 
diff --git a/web/index_wr.php b/web/index_wr.php
index 014b125..e8768ce 100644
--- a/web/index_wr.php
+++ b/web/index_wr.php
@@ -78,7 +78,6 @@ $mlang_indwr = array( 'btn_backtotab' => array( 'it' => 'Torna ai tavoli.',
                                            'en' => '<br>You or someone with your same IP address is standing up from a table without the permission of the other players <br><br>You will wait '), 
                       'badsit_b' => array( 'it' => ' prima di poterti sedere nuovamente.<br><br>Se non sei stato tu ad alzarti e possiedi un login con password, autenticandoti con quello, potrai accedere.',
                                            'en' => ' before you can sit down again. If you don\'t leave the table and you have a login with a password, authenticating with this one you will access')
-
                       );
 
 define('LICMGR_CHO_ACCEPT', 0);
-- 
2.17.1