add guar_code field to users table and related classes extensions

diff --git a/sql/sql.d/064-user-guarant.sql b/sql/sql.d/064-user-guarant.sql
new file mode 100644 (file)
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 (file)
--- 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 (file)
--- 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);