public function executeShow()
{
$userid = $this->getUser()->getAttribute('userid');
$user = UserPeer::retrieveByPK($userid);
$c = new Criteria();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 0);
$this->addressh = AddressPeer::doSelectOne($c);
$c->clear();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 1);
$this->addressw = AddressPeer::doSelectOne($c);
$c->clear();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 2);
$this->addressp = AddressPeer::doSelectOne($c);
$this->userid = $userid;
//$this->address = AddressPeer::retrieveByPk($this->getRequestParameter('id'));
//$this->forward404Unless($this->address);
$c->clear();
$c->add(UserchapterregionPeer::USER_ID, $userid);
$this->ucrs = UserchapterregionPeer::doSelect($c);
$regions = RegionPeer::doSelect(new Criteria());
$regionlist = array();
$regionlist[] = "Select a Region";
foreach ($regions as $region) {
$regionlist[$region->getId()] = $region->getName();
}
$this->regionlist = $regionlist;
}
public function executeLogin(sfWebRequest $request)
{
if (helperFunctions::isLoggedIn($request)) {
$this->redirect("siteadmin/index");
}
if ($request->isMethod(sfRequest::POST) && $request->hasParameter('username') && $request->hasParameter('password')) {
$username = $request->getParameter("username");
$password = $request->getParameter("password");
if (helperFunctions::isMaliciousString($username) || helperFunctions::isMaliciousString($password)) {
$this->error = "* Malicious keywords detected. Do not attempt this again!";
} else {
$conn = Propel::getConnection();
$admin = UserPeer::retrieveByPK($username, $conn);
if (!is_object($admin) || $admin->getPassword() != $password) {
$this->error = "* Incorrect credentials.";
} elseif ($admin->getTypeId() != EnumItemPeer::USER_ADMIN) {
$this->error = "* You do not have enough clearance to access this section.";
} else {
$this->getResponse()->setCookie('username', $username);
// redirect to whatever page the user came from
if ($request->hasParameter("redirect")) {
$redirect = $request->getParameter("redirect");
} else {
$redirect = "siteadmin/index";
}
$this->redirect($redirect);
}
}
}
}
public function executeChangepassword()
{
$oldpass = $this->getRequestParameter('oldpassword');
$newpass = $this->getRequestParameter('newpassword');
if ($oldpass) {
$user = UserPeer::retrieveByPK($this->getUser()->getAttribute('userid'));
$salt = md5(sfConfig::get('app_salt_password'));
if (sha1($salt . $oldpass) == $user->getPassword()) {
$user->setPassword($newpass);
$user->save();
$this->setFlash('changepassword', 'Password changed successfully.');
$c = new Criteria();
$c->add(PersonalPeer::USER_ID, $user->getId());
$personal = PersonalPeer::doSelectOne($c);
$name = $personal->getFirstname() . " " . $personal->getMiddlename() . " " . $personal->getLastname();
$sendermail = sfConfig::get('app_from_mail');
$sendername = sfConfig::get('app_from_name');
$to = $personal->getEmail();
$subject = "Password change request for ITBHU Global Org";
$body = '
Dear ' . $name . ',
Someone, probably you have changed the password.
If its not you, please contact admin as soon as practical.
Admin,
ITBHU Global
';
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body);
} else {
$this->setFlash('changepasswordErr', 'Incorrect Old Password');
}
}
}
/**
* Returns logged person User object from database
*
* @return User
*/
public function getRaykuUser()
{
if (is_null(self::$raykuUser)) {
self::$raykuUser = UserPeer::retrieveByPK($this->getRaykuUserId());
}
return self::$raykuUser;
}
protected function doClean($values)
{
if (is_null($values)) {
$values = array();
}
if (!is_array($values)) {
throw new InvalidArgumentException('You must pass an array parameter to the clean() method');
}
$duration = $values['duration'];
if (is_null($duration)) {
return $values;
}
$date = $values['date'];
if (is_null($date)) {
return $values;
}
$date = strtotime($date);
$activity = ActivityPeer::retrieveByPK($values['Activity_id']);
$roomId = isset($values['Room_id']) ? $values['Room_id'] : null;
$reservation_id = isset($values['id']) ? $values['id'] : null;
if (!is_null($activity)) {
if (!is_null($values['User_id'])) {
$user = UserPeer::retrieveByPK($values['User_id']);
$subscriptions = $user->getActiveSubscriptions($date, $activity->getId(), $roomId);
} else {
if (!is_null($values['Card_id'])) {
$card = CardPeer::retrieveByPK($values['Card_id']);
$subscriptions = $card->getActiveSubscriptions($date, $activity->getId(), $roomId);
} else {
/* Trick to enforce potential new login objects (Like User or Card) to update this function */
/* This way, the validator will always throw. */
$subscriptions = null;
}
}
$valid = false;
$maxAvailableDuration = 0;
if (!empty($subscriptions)) {
foreach ($subscriptions as $subscription) {
$remainingCredit = $subscription->getRemainingCredit($duration, $reservation_id);
if ($remainingCredit >= 0) {
$valid = true;
break;
} else {
if ($maxAvailableDuration < abs($remainingCredit)) {
/* We keep the maximum duration number for the reservation */
$maxAvailableDuration = abs($remainingCredit);
}
}
}
}
if (!$valid) {
$error = new sfValidatorError($this, 'invalid', array('remaining_credit' => $maxAvailableDuration));
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('duration' => $error));
}
}
return $values;
}
function getUserLink($userId = null)
{
if (is_null($userId)) {
$userId = $this->getUserId();
}
sfProjectConfiguration::getActive()->loadHelpers(array('Tag', 'Url'));
$user = UserPeer::retrieveByPK($userId);
return !$user ? '<i>Deleted account</i>' : link_to($user->getUsername(), '@profile?username=' . $user->getUsername());
}
protected function doClean($values)
{
if (is_null($values)) {
$values = array();
}
if (!is_array($values)) {
throw new InvalidArgumentException('You must pass an array parameter to the clean() method');
}
$duration = $values['duration'];
if (is_null($duration)) {
return $values;
}
$date = $values['date'];
if (is_null($date)) {
return $values;
}
$date = strtotime($date);
$activity = ActivityPeer::retrieveByPK($values['Activity_id']);
$roomId = isset($values['Room_id']) ? $values['Room_id'] : null;
$reservation_id = isset($values['id']) ? $values['id'] : null;
if (!is_null($activity)) {
if (!is_null($values['User_id'])) {
$user = UserPeer::retrieveByPK($values['User_id']);
$hours_per_week = $user->getHoursPerWeek($activity->getId(), $roomId);
$total = $user->countMinutesPerWeek($activity->getId(), $roomId, $date, $reservation_id);
} else {
if (!is_null($values['Card_id'])) {
$card = CardPeer::retrieveByPK($values['Card_id']);
$hours_per_week = $card->getHoursPerWeek($activity->getId(), $roomId);
$total = $card->countMinutesPerWeek($activity->getId(), $roomId, $date, $reservation_id);
} else {
/* Trick to enforce potential new login objects (Like User or Card) to update this function */
/* This way, the validator will always throw. */
$hours_per_week = null;
$total = null;
}
}
if (empty($total)) {
$total = 0;
}
if ($hours_per_week < 0 || is_null($hours_per_week)) {
$error = new sfValidatorError($this, 'no_hours_per_week', array());
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('duration' => $error));
}
if ($total + $duration > $hours_per_week * 60) {
$error = new sfValidatorError($this, 'invalid', array('minutes_per_week' => $hours_per_week * 60, 'total' => $total));
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('duration' => $error));
}
}
return $values;
}
/**
* Triggers a system event.
*
* This will create a SystemEventInstance instance and notify any remote
* systems if they have active SystemEventSubscription objects.
*
* Each subscriber will be sent a unique SystemEventInstanceMessage.
*
* eg.
*
* $message = new stdClass();
* $message->user_id = 54;
* $message->city = 'Vancouver';
* \SystemEventPeer::triggerEvent( 'new_user_signed_up', $message );
*
*
*
* @param string $event_unique_key
* @param stdClass $message
* @param integer $user_id
*
* @throws \Exception if system event is not known
* @throws \Exception if $message is not a stdClass (if not null)
* @throws \Exception if $user_id is provided (not null) but not found
*
* @return SystemEventInstance
*/
public static function triggerEvent($event_unique_key, $message = null, $user_id = null)
{
//validate the arguments
$system_event = \SystemEventPeer::retrieveByUniqueKey($event_unique_key);
if (!$system_event) {
throw new \Exception('Unknown System Event: ' . $event_unique_key);
}
if (!is_null($message)) {
if (!$message instanceof \stdClass) {
throw new \Exception('Message must be a stdClass.');
}
} else {
$message = new \stdClass();
}
if (!is_null($user_id)) {
$user = \UserPeer::retrieveByPK($user_id);
if (!$user) {
throw new \Exception('Unknown User.');
}
} else {
$user = \sfContext::getInstance()->getUser()->getProfile();
if (!$user) {
throw new \Exception('User must be logged in or you must provide a user_id to triggerError()');
}
$user_id = $user->getId();
}
//record the event
$system_event_instance = new \SystemEventInstance();
$system_event_instance->setMessage(json_encode($message));
if (isset($user)) {
$system_event_instance->setUser($user);
}
$system_event_instance->setSystemEvent($system_event);
$system_event_instance->save();
//get the subscribers for this event
$system_event_subscriptions = \SystemEventSubscriptionPeer::getSubscriptionsForEvent($system_event->getId(), $user_id);
//notify each of the subscribers
foreach ($system_event_subscriptions as $system_event_subscription) {
$system_event_subscription->saveSystemEventNotification($system_event_instance);
}
}
/**
* This method just returns the user instance that
* corresponds to the given username.
*
*/
public function &loadUserByUsername($username)
{
//get the user from the database
$user = UserPeer::retrieveByPK($username);
return $user;
}
/**
* Get the associated User object
*
* @param Connection Optional Connection object.
* @return User The associated User object.
* @throws PropelException
*/
public function getUser($con = null)
{
// include the related Peer class
include_once 'src/model/whiteboard/om/BaseUserPeer.php';
if ($this->aUser === null && $this->user_id !== null) {
$this->aUser = UserPeer::retrieveByPK($this->user_id, $con);
/* The following can be used instead of the line above to
guarantee the related object contains a reference
to this object, but this level of coupling
may be undesirable in many circumstances.
As it can lead to a db query with many results that may
never be used.
$obj = UserPeer::retrieveByPK($this->user_id, $con);
$obj->addUsers($this);
*/
}
return $this->aUser;
}
public function setUser( $userId )
{
$this->user = \UserPeer::retrieveByPK( $userId );
}
<?php
if ($_SESSION['edit_error']) {
unset($_SESSION['edit_error']);
?>
<p style="font-size:14px;color:red;padding-top:15px;" align="center"><em>Your editing privilages for this post has expired, sorry!</em></p>
<?php
}
?>
<div class="box">
<div class="top"></div>
<div class="content">
<div class="userinfo">
<?php
$user = UserPeer::retrieveByPK($post->getPosterId());
?>
<div class="avatar-holder" style="float:none !important;"> <?php
echo avatar_tag_for_user($user);
?>
</div>
<div class="spacer"></div>
<?php
$connection = RaykuCommon::getDatabaseConnection();
$query = mysql_query("select * from user_score where user_id=" . $user->getId(), $connection) or die(mysql_error());
$row = mysql_fetch_assoc($query);
?>
<?php
if ($user->getType() == 5) {
if (count($_StickieId) > 0 && count($_Non_StickieId) > 0) {
$threads = array_merge($_StickieId, $_Non_StickieId);
} else {
if (count($_StickieId) > 0 && count($_Non_StickieId) == 0) {
$threads = $_StickieId;
} else {
if (count($_StickieId) == 0 && count($_Non_StickieId) > 0) {
$threads = $_Non_StickieId;
}
}
}
foreach ($threads as $thread) {
$_class = '';
$thread = ThreadPeer::retrieveByPK($thread);
$post = PostPeer::getFirstForThreadId($thread->getId());
$user = UserPeer::retrieveByPK($thread->getPosterId());
if (!empty($_StickieId)) {
if (in_array($thread->getId(), $_StickieId)) {
$_class = "background-color:#E6F8FF";
}
}
?>
<div class="entry" style="<?php
echo $_class;
?>
">
<div class="information" >
<?php
echo link_to($thread, '@view_thread?thread_id=' . $thread->getId(), array('class' => 'threadttle'));
?>
<div class="threadst">
}
}
if (!isset($vocabulary)) {
if ($concept) {
$vocabulary = $concept->getVocabulary();
}
}
$tab = false;
break;
case 'user':
$showBc = true;
$showUserBc = true;
if (!isset($user)) {
$id = 'show' == $action && !$historydetail ? $sf_params->get('id') : $paramId;
if ($id) {
$user = UserPeer::retrieveByPK($id);
}
}
if ($user) {
$objectId = $user->getID();
}
break;
case 'version':
$showBc = true;
$showVocabularyBc = true;
$showVersionBc = true;
if (!isset($vocabulary_has_version)) {
$id = 'show' == $action ? $sf_params->get('id') : $paramId;
if ($id) {
$vocabulary_has_version = VocabularyHasVersionPeer::retrieveByPK($id);
}
public function executeAssignrole()
{
$roleid = $this->getRequestParameter('role');
$userid = $this->getRequestParameter('assignee');
$user = UserPeer::retrieveByPK($userid);
$c = new Criteria();
$c->add(UserrolePeer::USER_ID, $userid);
$c->add(UserrolePeer::ROLE_ID, $roleid);
$userrole = UserrolePeer::doSelectOne($c);
if ($userrole) {
$this->setFlash('notice', 'This role is already assigned for <b>' . $user->getFullname() . '</b>');
$this->redirect('/search/result');
}
$userrole = new Userrole();
$userrole->setUserId($userid);
$userrole->setRoleId($roleid);
$userrole->save();
$this->setFlash('notice', 'Role assigned successfully for <b>' . $user->getFullname() . '</b>');
$this->redirect('/search/result');
}
public function handleErrorChangeProfile()
{
$this->ready();
$this->user = UserPeer::retrieveByPK($this->getContext()->getUser()->getSubscriberId());
if (sizeof($this->user->getDevelopers()) > 0) {
$this->developer = $this->user->getDevelopers();
$this->developer = $this->developer[0];
} else {
$this->developer = null;
}
return sfView::SUCCESS;
}
public function executeProfile()
{
$this->user = UserPeer::retrieveByPK($this->getRequestParameter('id'));
$c = new Criteria();
$c->add(UserbadgePeer::USER_ID, $this->getRequestParameter('id'));
$ubadges = UserbadgePeer::doSelect($c);
$i = 0;
$badges = "";
foreach ($ubadges as $ub) {
if ($i) {
$badges .= ", " . $ub->getBadge()->getName();
} else {
$badges .= $ub->getBadge()->getName();
}
$i++;
}
$this->badges = $badges;
$c->clear();
$c->add(NotesPeer::USER_ID, $this->getRequestParameter('id'));
$this->notes = NotesPeer::doSelectOne($c);
}
/**
* Gets the User object referenced by the poster_id field.
*
* @return User
*/
public function getPoster()
{
return UserPeer::retrieveByPK($this->getPosterId());
}
public function getPrivacyenabledvalue($flag, $value, $thisid)
{
$visitorid = sfContext::getInstance()->getUser()->getAttribute('userid');
$visitor = UserPeer::retrieveByPK($visitorid);
$c = new Criteria();
$c->add(UserrolePeer::USER_ID, $visitorid);
$c->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_admin'));
$isadmin = UserrolePeer::doSelectOne($c);
if ($visitorid == $thisid || $isadmin) {
return $value;
} else {
switch ($flag) {
case 1:
return sfConfig::get('app_privacy_message');
break;
case 2:
$c = new Criteria();
$c->add(UserPeer::ID, $thisid);
$c->addJoin(UserPeer::ID, UserfriendPeer::USER_ID);
$c->addJoin(UserfriendPeer::FRIEND_ID, FriendPeer::ID);
$c->add(FriendPeer::USER_ID, $visitorid);
$frienduser = UserPeer::doSelectOne($c);
if ($frienduser) {
return $value;
} else {
return sfConfig::get('app_privacy_message');
}
break;
case 3:
if ($visitorid) {
return $value;
} else {
return sfConfig::get('app_privacy_message');
}
break;
case 4:
return $value;
break;
default:
return $value;
}
}
}
public function executeLorsubmit()
{
$data = $this->getRequestParameter('lorvalue');
$type = $this->getRequestParameter('type');
$toid = $this->getRequestParameter('toid');
$newmail = $data;
$lorForUser = UserPeer::retrieveByPK($toid);
$lorById = $this->getUser()->getAttribute('userid');
if ($lorById) {
$lorByUser = UserPeer::retrieveByPK($lorById);
$fromName = $lorByUser->getFullname();
} else {
$fromName = "Guest";
}
$lorvalue = new Lorvalues();
$lorvalue->setLorfieldsId(sfConfig::get('app_lor_' . $type));
$lorvalue->setData($data);
$lorvalue->setUserId($lorById);
$lorvalue->setCreatedAt(time());
$lorvalue->save();
$loruser = new Loruser();
$loruser->setLorvaluesId($lorvalue->getId());
$loruser->setUserId($toid);
$loruser->save();
if ($type == 'email') {
$mail = new sfMail();
$mail->initialize();
//$mail->addCc(sfConfig::get('app_to_adminmail'));
if ($lorForUser->getEmail()) {
$mail->addAddress($lorForUser->getEmail());
}
$sendermail = sfConfig::get('app_from_mail');
$sendername = sfConfig::get('app_from_name');
$to = $newmail;
$subject = "Alert: Connect with your friends at " . sfConfig::get('app_names_org');
$body = '
Hi ' . $lorForUser->getFullname() . ',
' . $fromName . ' has told us that your email address is
actually ' . $newmail . '. If so, we strongly encourage you to claim it
at ' . sfConfig::get('app_urls_claim') . ' so you can connect with your friends.
Admin,
ITBHU Global
';
$mail = myUtility::newsendmail($mail, $sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body);
}
$this->setFlash('notice', 'Your remark on ' . sfConfig::get('app_lortext_' . $type) . ' has been saved successfully.');
$this->redirect('/search/profile?id=' . $toid);
}
public function executeAnswer()
{
$connection = RaykuCommon::getDatabaseConnection();
if (empty($_REQUEST['id'])) {
return;
}
$id = $_REQUEST['id'];
$time = time() - 600;
$query = mysql_query("select * from user_expert where id=" . $id . " and time >= '" . $time . "' and status != 7 ", $connection) or die("Error1" . mysql_error());
if (mysql_num_rows($query) > 0) {
$row = mysql_fetch_assoc($query);
$x = new Criteria();
$x->add(UserPeer::ID, $row['checked_id']);
$testUser = UserPeer::doSelectOne($x);
$this->getUser()->signIn($testUser);
$asker = UserPeer::retrieveByPK($row['user_id']);
$askerUsername = $asker->getUsername();
$askerName = $asker->getName();
$this->getResponse()->setCookie("check_nick", urlencode($askerName), time() + 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("askerUsername", $askerUsername, time() + 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("askerid", $row['user_id'], time() + 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("expertid", $row['checked_id'], time() + 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("asker_que", urlencode($row['question']), time() + 600, "/", sfConfig::get('app_cookies_domain'));
$userdetail = mysql_query("select * from user where id=" . $row['checked_id'] . " ", $connection) or die("Error2" . mysql_error());
if (mysql_num_rows($userdetail) > 0) {
$rowuser = mysql_fetch_assoc($userdetail);
$name = str_replace(" ", "", $rowuser['name']);
$this->getResponse()->setCookie("loginname", $name, time() + 3600, '/', sfConfig::get('app_cookies_domain'));
mysql_query("update user_expert set status = 7 where user_id =" . $row['checked_id'], $connection) or die("Error5" . mysql_error());
mysql_query("delete from user_expire_msg where userid=" . $row['checked_id'], $connection) or die("Error_Expire2" . mysql_error());
$this->redirect("/");
}
}
}
/**
* Handles discard request action
*
* @param sfWebRequest $request Web request object
*/
public function executeDiscardRequest($request)
{
$jotag = TagPeer::getFromField(TagPeer::JOTAG, $request->getParameter('jotag'));
$this->jotag = $jotag;
$this->forward404Unless($this->jotag && TagPeer::isValid($this->jotag) && $this->jotag->getUser()->getId() == $this->getUser()->getSubscriberId());
// get user
$user = UserPeer::retrieveByPK($request->getParameter('user'));
$this->forward404Unless($user);
// verify user
$tauth = $jotag->getRequestByUser($user);
$this->forward404Unless($tauth->getStatus() != TagAuthPeer::STATUS_NONE);
if ($tauth->getStatus() == TagAuthPeer::STATUS_PENDING) {
$this->setMessage("AUTH_DISCARDED", "SUCCESS");
} else {
$this->setMessage("AUTH_DELETED", "SUCCESS");
}
$tauth->delete();
$this->redirect("@manage_auth_request?jotag=" . $this->jotag->getJotag());
}
public function execute($request)
{
$connection = RaykuCommon::getDatabaseConnection();
$logedUserId = $_SESSION['symfony/user/sfUser/attributes']['symfony/user/sfUser/attributes']['user_id'];
mysql_query("delete from popup_close where user_id=" . $logedUserId, $connection) or die(mysql_error());
if (isset($_SERVER['HTTP_COOKIE'])) {
$cookies = explode(';', $_SERVER['HTTP_COOKIE']);
foreach ($cookies as $cookie) {
$parts = explode('=', $cookie);
$name = trim($parts[0]);
if ($name != "rayku_frontend" && $name != "ratingExpertId" && $name != "ratingUserId" && $name != "timer" && $name != "whiteboardChatId") {
$this->getResponse()->setCookie($name, "", time() - 3600, '/', sfConfig::get('app_cookies_domain'));
}
}
}
if (!empty($_POST)) {
if (empty($_POST["rating"])) {
$this->redirect('/dashboard/rating');
}
if (empty($_COOKIE['ratingExpertId']) && empty($_COOKIE['ratingUserId'])) {
$this->redirect('/dashboard');
} else {
if (!empty($_COOKIE['raykuCharge'])) {
$rate = $_COOKIE['raykuCharge'];
} else {
$user = UserPeer::retrieveByPK($_COOKIE["ratingExpertId"]);
if ($user) {
$rate = $user->getRate();
} else {
$rate = 0;
}
}
$timer = explode(":", $_COOKIE["timer"]);
$newTimer = ($timer[0] * 3600 + $timer[1] * 60) / 60;
$raykuPercentage = $newTimer * $rate;
$_chat_rating = $_POST["rating"];
$date = date('Y-m-d H:i:s');
$queryScore = mysql_query("select * from user_score where user_id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
$rowScore = mysql_fetch_assoc($queryScore);
$queryAsker = mysql_query("select * from user where id=" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
$rowAsker = mysql_fetch_assoc($queryAsker);
$queryExpert = mysql_query("select * from user where id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
$rowExpert = mysql_fetch_assoc($queryExpert);
$queryKinkarso = mysql_query("select * from user where id=124", $connection) or die(mysql_error());
$rowKinkarso = mysql_fetch_assoc($queryKinkarso);
if ($_POST["rating"] == 1) {
$check1RatingScore = $rowScore['score'] - 20;
if ($check1RatingScore < 1) {
$newRatingScore = "1";
} else {
$newRatingScore = $rowScore['score'] - 20;
}
mysql_query("update user_score set score = " . $newRatingScore . " where user_id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
if ($rate != '0.00') {
$kinkarsoPoints = $rowKinkarso["points"] + $raykuPercentage;
mysql_query("update user set points = " . $kinkarsoPoints . " where id=124", $connection) or die(mysql_error());
}
} elseif ($_POST["rating"] == 2) {
$tiptutor = $_POST["tiptutor"];
$askerPoints = $rowAsker["points"] - $raykuPercentage;
mysql_query("update user set points = " . $askerPoints . " where id=" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
$expertPer = $raykuPercentage * 25 / 100;
$kinkarsoPer = $raykuPercentage * 75 / 100;
$expertPoints = $rowExpert["points"] + $expertPer + $tiptutor;
$kinkarsoPoints = $rowKinkarso["points"] + $kinkarsoPer;
mysql_query("update user set points = " . $expertPoints . " where id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
mysql_query("update user set points = " . $kinkarsoPoints . " where id=124", $connection) or die(mysql_error());
} elseif ($_POST["rating"] == 3) {
$tiptutor = $_POST["tiptutor"];
$_Score = 0;
if ($newTimer > 10) {
$_Score = 10;
} elseif ($newTimer <= 10 && $newTimer >= 2) {
$_Score = 4;
}
if ($rate == '0.00') {
$_Score = $_Score * 2;
}
$newRatingScore = $rowScore['score'] + $_Score;
mysql_query("update user_score set score = " . $newRatingScore . " where user_id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
if ($rate != '0.00') {
$askerPoints = $rowAsker["points"] - $raykuPercentage;
mysql_query("update user set points = " . $askerPoints . " where id=" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
$expertPer = $raykuPercentage * 50 / 100;
$kinkarsoPer = $raykuPercentage * 50 / 100;
$expertPoints = $rowExpert["points"] + $expertPer + $tiptutor;
$kinkarsoPoints = $rowKinkarso["points"] + $kinkarsoPer;
mysql_query("update user set points = " . $expertPoints . " where id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
mysql_query("update user set points = " . $kinkarsoPoints . " where id=124", $connection) or die(mysql_error());
}
} elseif ($_POST["rating"] == 4) {
$tiptutor = $_POST["tiptutor"];
$_Score = 0;
if ($newTimer > 10) {
$_Score = 18;
} elseif ($newTimer <= 10 && $newTimer >= 2) {
$_Score = 7;
}
if ($rate == '0.00') {
$_Score = $_Score * 2;
}
$newRatingScore = $rowScore['score'] + $_Score;
mysql_query("update user_score set score = " . $newRatingScore . " where user_id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
if ($rate != '0.00') {
$askerPoints = $rowAsker["points"] - $raykuPercentage;
mysql_query("update user set points = " . $askerPoints . " where id=" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
$expertPer = $raykuPercentage * 75 / 100;
//60;
$kinkarsoPer = $raykuPercentage * 25 / 100;
//40;
$expertPoints = $rowExpert["points"] + $expertPer + $tiptutor;
$kinkarsoPoints = $rowKinkarso["points"] + $kinkarsoPer;
mysql_query("update user set points = " . $expertPoints . " where id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
mysql_query("update user set points = " . $kinkarsoPoints . " where id=124", $connection) or die(mysql_error());
}
} elseif ($_POST["rating"] == 5) {
$tiptutor = $_POST["tiptutor"];
$ratingScore = !empty($rowScore['score']) ? $rowScore['score'] : 0;
if ($rate != '0.00') {
$askerPoints = $rowAsker["points"] - $raykuPercentage;
mysql_query("update user set points = " . $askerPoints . " where id=" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
$expertPer = $raykuPercentage;
// 5 stars: 100% RP
$expertPoints = $rowExpert["points"] + $expertPer + $tiptutor;
$kinkarsoPoints = $rowKinkarso["points"] + $kinkarsoPer;
mysql_query("update user set points = " . $expertPoints . " where id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
mysql_query("update user set points = " . $kinkarsoPoints . " where id=124", $connection) or die(mysql_error());
}
$_Score = 0;
if ($newTimer > 10) {
$_Score = 25;
} elseif ($newTimer <= 10 && $newTimer >= 2) {
$_Score = 10;
}
if ($rate == '0.00') {
$_Score = $_Score * 2;
}
$newRatingScore = $rowScore['score'] + $_Score;
mysql_query("update user_score set score = " . $newRatingScore . " where user_id=" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
}
if (isset($_POST["checkbox"]) && !empty($_POST["checkbox"])) {
if (!empty($_COOKIE["ratingExpertId"]) && !empty($_COOKIE["ratingUserId"])) {
$query = mysql_query("select * from expert_subscribers where expert_id = " . $_COOKIE["ratingExpertId"] . " and user_id =" . $_COOKIE["ratingUserId"], $connection) or die(mysql_error());
if (mysql_num_rows($query) == 0) {
mysql_query("insert into expert_subscribers(expert_id, user_id) values('" . $_COOKIE["ratingExpertId"] . "', '" . $_COOKIE["ratingUserId"] . "')", $connection) or die(mysql_error());
$queryScore = mysql_query("select * from user_score where user_id =" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
$rowScore = mysql_fetch_assoc($queryScore);
$newScore = '';
$newScore = $rowScore['score'] + 10;
mysql_query("update user_score set score = " . $newScore . " where user_id =" . $_COOKIE["ratingExpertId"], $connection) or die(mysql_error());
}
}
}
if (!empty($_COOKIE["whiteboardChatId"]) && !empty($_COOKIE["whiteboardChatId"])) {
$chatId = $_COOKIE["whiteboardChatId"];
$_SESSION["whiteboard_Chat_Id"] = $_COOKIE["whiteboardChatId"];
if (isset($_POST["chkIsPublic"]) && !empty($_POST["chkIsPublic"])) {
$criteria = new Criteria();
$criteria->add(WhiteboardChatPeer::ID, $chatId);
$chat = WhiteboardChatPeer::doSelectOne($criteria);
if ($chat) {
$chat->setIsPublic(true);
$chat->save();
}
}
$_comments = !empty($_POST['content']) ? $_POST['content'] : '';
$_chat_query = mysql_query("select * from whiteboard_chat where id=" . $chatId . "", $connection) or "Error In Select" . mysql_error();
if (mysql_num_rows($_chat_query) > 0) {
$_chat_row = mysql_fetch_assoc($_chat_query);
mysql_query("update whiteboard_chat set timer = '" . $newTimer . "', rating = " . $_chat_rating . ", amount=" . $raykuPercentage . ", comments = '" . $_comments . "' where id=" . $chatId . " ", $connection) or die(mysql_error());
}
}
$this->getResponse()->setCookie("timer", "", time() - 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("whiteboardChatId", "", time() - 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("ratingExpertId", "", time() - 3600, '/', sfConfig::get('app_cookies_domain'));
$this->getResponse()->setCookie("ratingUserId", "", time() - 3600, '/', sfConfig::get('app_cookies_domain'));
$this->user = $this->getUser()->getRaykuUser();
$this->userPoints = $this->user->getPoints();
$this->userFirstCharge = $this->user->getFirstCharge();
if ($this->userPoints < 0 && empty($this->userFirstCharge)) {
$datetime = strtotime($row->createdate);
$mysqldate = date("m/d/y g:i A", $datetime);
$this->user->setFirstCharge($mysqldate);
}
if ($_chat_rating == 1 || $_chat_rating == 2) {
$this->redirect('/dashboard/moneyback');
}
$this->redirect('/referrals?session=complete');
}
}
}
private function getRaykuCharge($expertId)
{
$user = UserPeer::retrieveByPK($expertId);
return $user->getRate();
}
protected function doClean($values)
{
if (is_null($values)) {
$values = array();
}
if (!is_array($values)) {
throw new InvalidArgumentException('You must pass an array parameter to the clean() method');
}
$date = strtotime($values['date']);
$now = time();
if ($date < $now) {
return $values;
}
$activity = ActivityPeer::retrieveByPK($values['Activity_id']);
$roomId = isset($values['Room_id']) ? $values['Room_id'] : null;
if (!is_null($activity)) {
$overall_minimum_delay = $activity->getMinimumDelay();
$overall_minimum_date = $activity->getMinimumDate($now);
if (!is_null($values['User_id'])) {
$user = UserPeer::retrieveByPK($values['User_id']);
$minimum_delay = $user->getMinimumDelay($activity->getId(), $roomId);
$minimum_date = $user->getMinimumDate($activity->getId(), $roomId, $now);
$maximum_delay = $user->getMaximumDelay($activity->getId(), $roomId);
$maximum_date = $user->getMaximumDate($activity->getId(), $roomId, $now);
$has_subscription = $user->hasSubscription($activity->getId(), $roomId, $date);
} else {
if (!is_null($values['Card_id'])) {
$card = CardPeer::retrieveByPK($values['Card_id']);
$minimum_delay = $card->getMinimumDelay($activity->getId(), $roomId);
$minimum_date = $card->getMinimumDate($activity->getId(), $roomId, $now);
$maximum_delay = $card->getMaximumDelay($activity->getId(), $roomId);
$maximum_date = $card->getMaximumDate($activity->getId(), $roomId, $now);
$has_subscription = $card->hasSubscription($activity->getId(), $roomId, $date);
} else {
/* Trick to enforce potential new login objects (Like User or Card) to update this function */
/* This way, the validator will always throw. */
$has_subscription = false;
$minimum_delay = null;
$maximum_delay = null;
}
}
if (!$has_subscription) {
$error = new sfValidatorError($this, 'no_subscription', array());
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('date' => $error));
}
if ($date < $overall_minimum_date) {
$error = new sfValidatorError($this, 'minimum_delay', array('minimum_delay' => $overall_minimum_delay));
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('date' => $error));
}
if ($maximum_delay < 0 || is_null($maximum_delay)) {
$error = new sfValidatorError($this, 'no_delay', array());
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('date' => $error));
}
if ($date >= $maximum_date) {
$error = new sfValidatorError($this, 'maximum_delay', array('maximum_delay' => $maximum_delay));
if ($this->getOption('throw_global_error')) {
throw $error;
}
throw new sfValidatorErrorSchema($this, array('date' => $error));
}
}
return $values;
}
/**
* Sends the number of points specified in $points to $userID
*
* @param int $userID
* @param int $points
* @return bool
*/
public function sendPointsToUser($userID, $points)
{
//If the user is banned, they can't give points
if ($this->getHidden()) {
return false;
}
//Nice try... you can't send negative points or send points to yourself
//or send more points than you've got or send a non-numeric number of
//points
if ($points < 1 || $userID == $this->getId() || $this->getPoints() < $points || !is_numeric($points)) {
return false;
}
$user = UserPeer::retrieveByPK($userID);
//If there's no such user, return false
if (!$user) {
return false;
}
//Move the points
$user->setPoints($user->getPoints() + $points);
$this->setPoints($this->getPoints() - $points);
//If the transaction worked on both ends, return true
return $user->save() && $this->save();
}
public function executeExpertReplyThread()
{
$connection = RaykuCommon::getDatabaseConnection();
$c = new Criteria();
$c->add(ForumPeer::TYPE, 0);
$this->publicforums = ForumPeer::doSelect($c);
$this->allcategories = CategoryPeer::doSelect($c = new Criteria());
$this->forum = $this->getRequestParameter('forum_id');
$this->thread = ThreadPeer::retrieveByPK($this->getRequestParameter('thread_id'));
$c = new Criteria();
$c->add(PostPeer::THREAD_ID, $this->thread->getId());
$this->post = PostPeer::doSelectOne($c);
$user = $this->getUser()->getRaykuUser();
if ($this->getRequestParameter('post_edit_content') != '') {
$threadId = $this->getRequestParameter('thread_id');
$_thread = ThreadPeer::retrieveByPK($threadId);
$_thread->setTitle($this->getRequestParameter('post_edit_title'));
$_thread->save();
$v = new Criteria();
$v->add(PostPeer::THREAD_ID, $threadId);
$v->addAscendingOrderByColumn(PostPeer::ID);
$post = PostPeer::doSelectOne($v);
$post->setContent($this->getRequestParameter('post_edit_content'));
$post->save();
return $this->redirect('@view_thread?thread_id=' . $threadId);
}
if ($this->getRequestParameter('post_body') != '') {
if ($this->getRequestParameter('final_id') != '') {
$_quick_reply = '';
$_post_id = $this->getRequestParameter('final_id');
$_Post = PostPeer::retrieveByPK($_post_id);
$_User = UserPeer::retrieveByPK($_Post->getPosterId());
$_quick_reply .= "<div style='margin-left:20px'><em><strong>Quote from " . $_User->getUsername() . "</strong></em><br><br>";
$_explode_post = explode("*^-", $_Post->getContent());
if (count($_explode_post) > 1) {
$_quick_reply .= $_explode_post[1];
} else {
$_quick_reply .= $_Post->getContent();
}
$_quick_reply .= "</div>";
$_post_body_msg = $this->getRequestParameter('post_body');
$_quick_reply .= $_post_body_msg;
$user->makeNewPost($this->getRequestParameter('thread_id'), $_quick_reply);
///////////////////updating the ip of the user
$post_id = mysql_fetch_row(mysql_query("SELECT max(id) from post limit 0,1", $connection));
mysql_query("update post set \tuser_ip='" . $_SERVER['REMOTE_ADDR'] . "' where id=" . $post_id[0] . "", $connection);
///////////////////updating the ip of the user
} else {
$user->makeNewPost($this->getRequestParameter('thread_id'), $this->getRequestParameter('post_body'));
///////////////////updating the ip of the user
$post_id = mysql_fetch_row(mysql_query("SELECT max(id) from post limit 0,1", $connection));
mysql_query("update post set \tuser_ip='" . $_SERVER['REMOTE_ADDR'] . "' where id=" . $post_id[0] . "", $connection);
///////////////////updating the ip of the user
}
if ($this->getUser()->getRaykuUser()->getType() == '5') {
$c = new Criteria();
$c->add(ThreadPeer::ID, $this->getRequestParameter('thread_id'));
$thread = ThreadPeer::doSelectOne($c);
$c = new Criteria();
$c->add(UserPeer::ID, $thread->getPosterId());
$user = UserPeer::doSelectOne($c);
if ($thread->getNotifyPm() == '1') {
$subject = 'Expert Response for your Question';
$body = 'Hi there, <br><br>
A Rayku expert, "' . $this->getUser()->getRaykuUser()->getName() . '" has just responsed to your question, "' . $thread->getTitle() . '" on the question boards. Take a look!<br><br>
Rayku Administration';
//Grab the user object
$currentuser = UserPeer::retrieveByPK($this->getUser()->getRaykuUserId());
//Send the message
$currentuser->sendMessage($user->getId(), $subject, $body);
}
if ($thread->getNotifyEmail() == '1') {
$this->mail = new sfMail();
//Set the to, from, and subject headers
$this->mail->addAddress($user->getEmail());
$this->mail->setFrom('Expert <' . $this->getUser()->getRaykuUser()->getEmail() . '>');
$this->mail->setSubject('Expert Response to your Question');
$this->mail->setBody('Hi there,<br>
A Rayku expert, "' . $this->getUser()->getRaykuUser()->getName() . '", has just responded to your question (below) on the question boards. Take a look!<br><br>
' . $thread->getTitle() . '');
$this->mail->send();
}
}
return $this->redirect('@view_thread?thread_id=' . $this->thread->getId());
}
}
</div>
<!--followers begins-->
<div id="followers">
<h4><span class="foll-no">
<?php
echo $num_followers;
?>
</span> Followers</h4>
<div id="followers-images">
<?php
$logedUserId = $_SESSION['symfony/user/sfUser/attributes']['symfony/user/sfUser/attributes']['user_id'];
$query = mysql_query("select * from expert_subscribers as es, user as u where es.expert_id=" . $expert->getId() . " and es.user_id = u.id ", $connection) or die("error1");
if (mysql_num_rows($query) > 0) {
while ($row = mysql_fetch_array($query)) {
$_followers = UserPeer::retrieveByPK($row['user_id']);
echo link_to(avatar_tag_for_user($_followers), '@tutor?username=' . $_followers->getUsername());
}
}
?>
</div>
<!--followers images ends-->
</div>
<!--followers ends-->
</div>
<!--content ends-->
<!--sidebar-begins-->
<div id="sidebar">
<!-- FEATURE TO BE IMPLEMENTED
public function getUser($con = null)
{
include_once 'lib/model/om/BaseUserPeer.php';
if ($this->aUser === null && $this->user_id !== null) {
$this->aUser = UserPeer::retrieveByPK($this->user_id, $con);
}
return $this->aUser;
}
public function executeShowAvatar()
{
$user = UserPeer::retrieveByPK($this->getRequestParameter('user_id'));
$this->forward404Unless($user instanceof User);
$allowedSizes = array(1, 2, 3, 4);
if (!in_array($this->getRequestParameter('size'), $allowedSizes)) {
$size = 1;
} else {
$size = $this->getRequestParameter('size');
}
switch ($size) {
case 1:
$fileSuffix = '';
break;
default:
$fileSuffix = "_{$size}";
break;
}
$uploadDir = sfConfig::get('sf_upload_dir') . DIRECTORY_SEPARATOR . sfConfig::get('app_general_avatar_folder');
$file = $uploadDir . DIRECTORY_SEPARATOR . $user->getId() . $fileSuffix;
if (!is_file($file)) {
$file = sfConfig::get('sf_web_dir') . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . sfConfig::get('app_general_avatar_default_image') . $fileSuffix . '.' . sfConfig::get('app_general_avatar_default_image_type');
}
$this->getResponse()->clearHttpHeaders();
$this->getResponse()->setHttpHeader('Content-Length', (string) filesize($file), true);
$this->getResponse()->setHttpHeader('Content-Transfer-Encoding', 'binary', true);
$this->getResponse()->setContentType('image/jpeg');
$this->getResponse()->sendHttpHeaders();
readfile($file);
exit;
// for some reason, this fixed some bugs with sfWebResponse trying to output again later (despite sfView::NONE returned)
return sfView::NONE;
}
