-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
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
+
+ function verify($key)
+ {
+ // if key matches verify_key
+ // copy into person or other entity...
+ // and delete....
+ //$this->whereAdd("verify_key = '".$key."'");
+ $row = $this->get("verify_key",$key);
+ if(!empty($row)){
+ $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();
+
+ //login
+ @session_start();
+
+ $_SESSION['Hydra']['authUser'] = $p ? serialize($p) : false;
+
+ //mail pwd
+ $htmlStr = "";
+ $htmlStr .= "Dear ".$p->honor.".".$p->lastname."<br /><br />";
+ $htmlStr .= "Congratulations on Joining HydRa.<br /><br />"
+ $htmlStr .= "If you need to access the system again please log in using the password ";
+ $htmlStr .= $temp_pwd;
+
+ $name = "Roojs";
+ $email_sender = "no-reply@roojs.com";
+ $subject = "Congratulations";
+ $recipient_email = $p->email;
+
+ $headers = "MIME-Version: 1.0\r\n";
+ $headers .= "Content-type: text/html; charset=utf-8\r\n";
+ $headers .= "From: {$name} ";
+ $headers .= "<";
+ $headers .= $email_sender;
+ $headers .= ">\r\n";
+
+ }else{
+ error_log("db insert error");
+ return false;
+ }
+ }
+ return false;
+
+ }
}
\ No newline at end of file