DataObjects/Core_person_signup.php

[Pman.Core] / DataObjects / Core_person_signup.php

diff --git a/DataObjects/Core_person_signup.php b/DataObjects/Core_person_signup.php
index 588838e..8e0351f 100644 (file)
--- a/DataObjects/Core_person_signup.php
+++ b/DataObjects/Core_person_signup.php
@@ -1,19 +1,3 @@
-CREATE TABLE core_person_signup (
-  id int(11) NOT NULL auto_increment,
-  PRIMARY KEY  (id)
-) ;
-
-
-ALTER TABLE core_person_signup ADD COLUMN   name varchar(128)  NOT NULL  DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   honor varchar(32) NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   firstname_alt varchar(128) NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   lastname_alt varchar(128) NOT NULL DEFAULT '';
-
-ALTER TABLE core_person_signup ADD COLUMN   email varchar(256)  NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   verify_key varchar(256)  NOT NULL DEFAULT '';
-ALTER TABLE core_person_signup ADD COLUMN   created_dt DATETIME  NOT NULL;
 <?php
 /**
  * Table Definition for Person
@@ -30,16 +14,16 @@ class Pman_Core_DataObjects_Core_person_signup extends DB_DataObject
     public $id;                              // int(11)  not_null primary_key auto_increment
     public $email;                           // string(128)  not_null
     
-    public $name;                            // string(128)  not_null
+    //public $name;                            // string(128)  not_null
     public $firstname;                            // string(128)  not_null
     public $lastname;                            // string(128)  not_null
-    public $firstname_alt;                            // string(128)  not_null
-    public $lastname_alt;                            // string(128)  not_null
+    //public $firstname_alt;                            // string(128)  not_null
+    //public $lastname_alt;                            // string(128)  not_null
     
     
     public $honor;                            // string(128)  not_null
     public $verify_key;                      // int(11)
-
+    public $verified;
     
 
     public $created_dt;                      // datetime(19)  binary
@@ -47,6 +31,37 @@ class Pman_Core_DataObjects_Core_person_signup extends DB_DataObject
     
     
     
+    
+    function verify($key)
+    {
+        // if key matches verify_key
+        // copy into person or other entity...
+        // and delete....
+        $this->whereAdd("verify_key = '".$key."'");
+        if($this->count() > 0 ){
+            $row = $this->fetch();
+            $p = DB_DataObject::factory('person');
+            $p->honor = $row->honor;
+            $p->name = $row->name;
+            $p->email = $row->email;
+            $p->firstname = $row->firstname;
+            $p->lastname = $row->lastname;
+            $p->firstname_alt = $row->firstname_alt;
+            $p->lastname_alt = $row->lastname_alt;
+            $temp_pwd = $p->generatePassword();
+            //$temp_pwd = mt_rand(100000,999999);
+            //$p->passwd = $temp_pwd;
+            if($p->insert()){
+                $this->delete();
+                return $temp_pwd;
+            }else{
+                error_log("db insert error");
+                return false;
+            }   
+        }
+        return false;
+        
+    }
 }
 
     
\ No newline at end of file