function parseQuery($caller, $s)
{
//simple replaces
$cmd = array("#db->", "#dbfilter->", "#by_bizness");
$sql = array(get_class($caller) . "_", "(SELECT * FROM ", "WHERE biznessUID=" . osBackBizness() . ")");
$s = str_replace($cmd, $sql, $s);
//functional replaces
//finally
return $s;
}
function add($email, $password, $passwordagain, $userName, $Address, $Country, $PostalCode, $role)
{
//check if the email is already registered
query("SELECT * FROM user_info WHERE email='" . $email . "' ;");
if ($row = fetch()) {
if ($email == $row["email"]) {
return -1;
//user already exist
}
} else {
if ($password == $passwordagain) {
//save the new user in the database
$vcode = $this->createVerificationCode();
$hashPassword = $this->sha1Hash($email, $password);
query("INSERT INTO user_info (email,password,verificationCode,biznessUID,userName,Address,Country,PostalCode,role) VALUES ('" . $email . "', '" . $hashPassword . "','" . $vcode . "','" . osBackBizness() . "','" . $userName . "','" . $Address . "','" . $Country . "','" . $PostalCode . "','" . $role . "');");
// A welcome message to the user...
$msg = "Welcome! Please login to your account and verify by this code: " . $vcode;
$mailheader = 'From: register@sam-rad.com' . "\r\n" . 'Reply-To: register@sam-rad.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
//send an email to the user. FIX MAILING FUNCTION!
$this->sendEmail($email, "Welcome to buziness!", $msg, $mailheader);
//to get the fresh userUID...
query("SELECT * FROM user_info WHERE email='" . $email . "' ;");
if ($row = fetch()) {
$this->userUID = $row['userUID'];
}
$this->loggedIn = 2;
//All set - user added and logged in!
return 1;
} else {
return -2;
}
}
}
function add($email, $password, $passwordagain)
{
//check if the email is already registered
query("SELECT * FROM user_info WHERE email='" . $email . "' ;");
if ($row = fetch()) {
if ($email == $row["email"]) {
return -1;
//user already exist
}
} else {
if ($password == $passwordagain) {
//save the new user in the database
$vcode = $this->createVerificationCode();
$hashPassword = $this->sha1Hash($email, $password);
query("INSERT INTO user_info (email,password,verificationCode,biznessUID) VALUES ('" . $email . "', '" . $hashPassword . "','" . $vcode . "','" . osBackBizness() . "');");
// A welcome message to the user...
$msg = "Welcome! Please verify your account using this code: " . $vcode;
//send an email to the user. FIX MAILING FUNCTION!
$this->sendEmail($email, "Welcome to buziness!", $msg);
//to get the fresh userUID...
query("SELECT * FROM user_info WHERE email='" . $email . "' ;");
if ($row = fetch()) {
$this->userUID = $row['userUID'];
}
$this->loggedIn = 2;
//All set - user added and logged in!
return 1;
} else {
return -2;
}
}
}
function init()
{
if ($this->catUID == 0) {
//----ROOT it is
query("SELECT c.catUID as catUID, c.Lable AS lable, t.name AS type_name FROM category_cat AS c,category_type AS t WHERE c.typeUID=t.typeUID AND c.owner_type ='bizness' AND c.owner_UID='" . osBackBizness() . "'");
if ($row = fetch()) {
$this->catUID = $row['catUID'];
$this->lable = $row['lable'];
$this->type_name = $row['type_name'];
}
} else {
//---Specific category
query("SELECT c.Lable AS lable, t.Name AS type_name FROM category_cat AS c,category_type AS t WHERE c.typeUID=t.typeUID AND c.catUID=" . $this->catUID);
if ($row = fetch()) {
$this->lable = $row['lable'];
$this->type_name = $row['type_name'];
}
}
}
