PHP UserPeer::doSelectFromConfirmationCode方法代码示例

    /**
     * Action to handle getting a confirmation code. Confirms user and spits out
     * a success page if the code checks out... spits out an error page otherwise
     */
    public function executeConfirmUser()
    {
        $user = UserPeer::doSelectFromConfirmationCode($this->getRequestParameter('code'));
        if (!$user) {
            $newCode = $this->getRequestParameter('code');
            $oC = new Criteria();
            $oC->add(UserPeer::ID, "SHA1(CONCAT(user.password, 'salt', user.id)) = '{$newCode}'", Criteria::CUSTOM);
            $oC->add(UserPeer::TYPE, '1');
            $userCheck = UserPeer::doSelectOne($oC);
            if (!$userCheck) {
                return sfView::ERROR;
            }
        }
        if ($user) {
            $user->setTypeConfirmed();
            $user->save();
        }
        if ($user) {
            $this->getUser()->signIn($user);
        } else {
            $this->getUser()->signIn($userCheck);
        }
        if ($kinkarsoUser) {
            if ($user) {
                $query = mysql_query("select * from  shout where recipient_id=" . $user->getId() . " and  poster_id=" . $kinkarsoUser->getId() . "") or die(mysql_error());
                if (mysql_num_rows($query) == 0) {
                    ShoutPeer::createWelcomeComment($user, $kinkarsoUser);
                }
            }
            $subject = 'Here\'s how to start tutoring on Rayku';
            if ($user) {
                $body = 'Hey ' . $user->getName() . ', welcome to Rayku.com!<br><br>';
            }
            $body .= 'Thanks for joining our community!<br><br>

                Before you get started, there are 3 important steps before you can start tutoring!<br><br>
                1) Activated your tutor status by clicking \'on\' in your <a href="' . sfConfig::get('app_rayku_url') . '/dashboard">dashboard page</a>.<br>
                2) Important: Learn how to tutor on Rayku in 10 minutes by watching our <a href="' . sfConfig::get('app_rayku_url') . '/tutorshelp">tutor help videos</a>.<br>
                3) Prepare to receive question notifications by connecting to our <strong><a href="' . sfConfig::get('app_notification_bot_url') . '/download/rayku.dmg">MacOS</a> / <a href="http://notification-bot.rayku.com/download/rayku.exe">Windows</a> notification software</strong>, <a href="http://rayku.com/dashboard/gtalk">google talk</a> and <a href="http://rayku.com/dashboard/facebook">facebook chat</a>.<br><br>

                Enjoy, and do let us know if you ever have any questions - we\'re here to help!<br><br>

                Thanks!<br>
                Rayku Administration';
            $currentuser = $kinkarsoUser;
            //Send the message
            if ($user) {
                $currentuser->sendMessage($user->getId(), $subject, $body);
            }
        }
        $this->forward('regtutor', 'profile');
    }

 public function executeConfirmuser()
 {
     //Load the user from activation code
     $user = UserPeer::doSelectFromConfirmationCode($_REQUEST['confirmationcode']);
     //If the user doesn't exist, display an error
     if (!$user) {
         $oC = new Criteria();
         $oC->add(UserPeer::ID, "SHA1( CONCAT( user.password, 'salt', user.id ) ) = '{$newCode}'", Criteria::CUSTOM);
         $oC->add(UserPeer::TYPE, '1');
         $userCheck = UserPeer::doSelectOne($oC);
         if (!$userCheck) {
             $_SESSION['confirm_user_error'] = "Invalid Confirmation Code.";
             $this->redirect("/quickreg/confirmationcode");
             //return sfView::ERROR;
         }
     }
     //print_r($_POST);exit;
     $newCode = $_REQUEST['confirmationcode'];
     $courseId = $_REQUEST['course_id'];
     $education = $_REQUEST['edu'];
     $university = $_REQUEST['name'];
     $courseCode = $_REQUEST['course_code'];
     $year = $_REQUEST['asker_year'];
     $grade = $_REQUEST['asker_grade'];
     $dashHidden = $_REQUEST['dash_hidden'];
     $_SESSION['course_id'] = $courseId;
     $_SESSION['edu'] = $education;
     $_SESSION['name'] = $university;
     $_SESSION['course_code'] = $courseCode;
     $_SESSION['dash_hidden'] = $dashHidden;
     if ($year != 'Choose year') {
         $_SESSION['year'] = $year;
     }
     if ($grade != 'Choose grade') {
         $_SESSION['grade'] = $grade;
     }
     if ($user) {
         $user->setTypeConfirmed();
         $user->save();
     }
     if ($user) {
         $this->getUser()->signIn($user);
     } else {
         $this->getUser()->signIn($userCheck);
     }
     $this->redirect("/expertmanager/list");
 }

 /**
  * Action to handle getting a confirmation code. Confirms user and spits out
  * a success page if the code checks out... spits out an error page otherwise
  */
 public function executeConfirmUser()
 {
     if (strlen($this->getRequestParameter('code')) > 40) {
         $req = unserialize(base64_decode(urldecode($this->getRequestParameter('code'))));
         $code = $req['code'];
         $question = $req['question'];
     } else {
         $code = $this->getRequestParameter('code');
     }
     $user = UserPeer::doSelectFromConfirmationCode($code);
     if (!$user) {
         $newCode = $this->getRequestParameter('code');
         $oC = new Criteria();
         $oC->add(UserPeer::ID, "SHA1( CONCAT( user.password, 'salt', user.id ) ) = '{$code}'", Criteria::CUSTOM);
         $oC->add(UserPeer::TYPE, '1');
         $userCheck = UserPeer::doSelectOne($oC);
         if (!$userCheck) {
             return sfView::ERROR;
         }
     }
     if ($user) {
         $user->setTypeConfirmed();
         $user->save();
         // Referral module
         // Rajesh Soni - 23 November 2012
         $ref_points = 6;
         $ref_points_user = 4;
         $sql2 = "select referred_by from user where id=" . $user->getId();
         if ($user->getId()) {
             $result = mysql_query($sql2) or die($sql2 . mysql_error());
             $row = mysql_fetch_row($result) or die($sql2 . mysql_error());
             $ref_by_user = $row[0];
             if ($ref_by_user) {
                 $sql2 = "update user set points= points + " . $ref_points . " where id=" . $ref_by_user . " LIMIT 1";
                 mysql_query($sql2) or die($sql2 . mysql_error());
                 $sql2 = "update user set points='" . $ref_points_user . "' where id=" . $user->getId() . " LIMIT 1";
                 mysql_query($sql2) or die($sql2 . mysql_error());
             }
         }
     }
     if ($user) {
         $this->getUser()->signIn($user);
     } else {
         $this->getUser()->signIn($userCheck);
     }
     if ($question) {
         $this->getRequest()->setParameter('question', $question);
         // Rajesh Soni - 28 November 2012
         $this->redirect("/referrals?register=success");
     } elseif ($user) {
         // Rajesh Soni - 28 November 2012
         $this->redirect("/referrals?register=success");
     } else {
         $this->redirect("/referrals?register=success");
     }
 }