function rewardBetaTesters() { $testers = array(); require_once PATH_CORE . '/classes/user.class.php'; require_once PATH_CORE . '/classes/challenges.class.php'; $ct = new ChallengeCompletedTable($this->db); $cc = $ct->getRowObject(); $challengeTable = new ChallengeTable($this->db); $betaTestChallenge = $challengeTable->getRowObject(); if (!$betaTestChallenge->loadWhere("shortName='betaTest'")) { echo "Couldn't find betaTest challenge"; return false; } $userTable = new UserTable($this->db); $user = $userTable->getRowObject(); $backdate = "2009-02-28 00:00:00"; foreach ($testers as $email) { if ($user->loadWhere("email='{$email}'")) { echo "User {$user->name}, {$email} found..."; $statuscode = ''; if (!$ct->submitAutomaticChallenge($user->userid, 'betaTest', &$statuscode, false)) { echo "Challenge approval failure: {$statuscode}"; } else { echo $statuscode; // TODO: take this out when done testing //$this->db->log($statuscode); // now backdate it! if ($cc->loadWhere("userid={$user->userid} AND challengeid={$betaTestChallenge->id}")) { //$cc->dateSubmitted = $backdate; // can leave this probably $cc->dateAwarded = $backdate; $cc->update(); echo "...backdated succesfully"; } else { echo "Couldnt find CC to backdate!"; } } } else { echo "No user found with email {$email}."; } echo "<br />"; } }
/////////////////////////// // NEW require_once PATH_CORE . '/classes/user.class.php'; $ut = new UserInfoTable(); $memberids = $ut->getFbIdsForUsers(array($completed_challenge['userid'])); $memberid = $memberids[0]; echo '<a href="' . URL_CANVAS . '?p=profile&memberid=' . $memberid . '&viewSubmitted"> Click here to see profile with challenge submit records</a>'; //echo 'this is where the report goes'; //////////////////////////////////////////////////////////////// // figure out how many points would normally be credited require_once PATH_CORE . '/classes/challenges.class.php'; $ct = new ChallengeTable(); //$this->db->setDebug(true); $completedTable = new ChallengeCompletedTable(); $completed = $completedTable->getRowObject(); if ($completed->load($completed_challenge['id'])) { $challenge = $ct->getRowObject(); if ($challenge->load($completed->challengeid)) { $points = $challenge->pointValue; } else { $points = '?'; echo 'oops, couldnt load challenge ' . $completed->challengeid; } } echo '<hr>'; echo 'Challenge title: ' . $challenge->title . '<br>'; echo 'Challenge description: ' . $challenge->description . '<br>'; //echo 'Challenge title: '.$challenge->title .'<br>'; echo '<hr>'; ?>
function fetchChallengeCompletedFeedItem($action, $fbId, $returnerrors = false, $noFiltering = false) { $ago .= self::getElapsedString(strtotime($action->t)); require_once PATH_CORE . '/classes/template.class.php'; require_once PATH_CORE . '/classes/challenges.class.php'; $ct = new ChallengeTable($this->db); // $this->db->setDebug(true); // NEVER TURN ON FOR LIVE SITE $completedTable = new ChallengeCompletedTable($this->db); $completed = $completedTable->getRowObject(); if (!$action->itemid) { if ($returnerrors) { $code = 'completedChallenge itemid empty:' . print_r($action, true); } return; } if ($completed->load($action->itemid)) { $challenge = $ct->getRowObject(); if ($challenge->load($completed->challengeid)) { // hack to cleanup actionFeed of CCs that should be hidden or now have custom feed items $filterPastChallenges = array('levelIncrease', 'addBookmarkTool', 'friendSignup'); if (!$noFiltering && array_search($challenge->shortName, $filterPastChallenges) !== false) { return ''; } // filtered $photocode = $this->buildPhotos($completed->id, &$pcount); if ($pcount > 1) { $submittedText .= 'photos '; $submittedContent .= $photocode; } else { if ($pcount > 0) { $submittedText .= 'a photo '; $submittedContent .= $photocode; } } $videocode = $this->buildVideos($completed->id, &$vcount); if ($pcount > 0 and $vcount > 0) { $submittedText .= ' and '; } if ($vcount > 1) { $submittedText .= 'videos '; $submittedContent .= $videocode; } else { if ($vcount > 0) { $submittedText .= 'a video '; $submittedContent .= $videocode; } } if ($completed->status == 'awarded') { /*$code .= template::buildLinkedProfilePic($fbIds[0], 'size="square"') .' '. template::buildLinkedProfileName($fbId) .' completed the challenge '. template::buildChallengeLink($challenge->title, $challenge->id) . ' for ' . $completed->pointsAwarded . ' points and submitted ' . $submittedText; */ if (!$this->showOnlyChallengeBlog) { $code .= '<div class="thumb">' . template::buildLinkedChallengePic($challenge->id, $challenge->thumbnail) . '</div> <div class="storyBlockWrap"> <div class="feed_poster"><div class="avatar">' . template::buildLinkedProfilePic($fbId, 'size="square" with="30" height="30"') . '</div> <h3><span class="bold">' . template::buildLinkedProfileName($fbId) . ' completed a challenge </span> ' . $ago . '</h3> </div> <p class="storyHead">' . template::buildChallengeLink($challenge->title, $challenge->id) . ' </p> <p class="storyCaption"> <span class="pointValue"> for ' . $completed->pointsAwarded . '<span class="pts"> points </span></span></p> ' . $submittedContent . ($completed->comments != '' ? ' <blockquote> <div class="quotes">' . $completed->comments . ' </div> </blockquote>' : '') . '</div><!__end "storyBlockWrap"__> '; } else { $code .= '<div class="profilePicLarger">' . template::buildLinkedProfilePic($fbId, 'size="square"') . '</div> <div class="storyBlockWrap"> <div class="feed_poster"> <h3><span class="bold">' . template::buildLinkedProfileName($fbId) . ' </span> ' . $ago . '</h3> </div> ' . $submittedContent . ($completed->comments != '' ? ' <blockquote> <div class="quotes"> ' . $completed->comments . ' </div> </blockquote>' : '') . '</div><!__end "storyBlockWrap"__> '; } } else { /*$code .= template::buildLinkedProfilePic($fbIds[0], 'size="square"') .' '. template::buildLinkedProfileName($fbId) .' submitted '. $submittedText . 'for the challenge '. template::buildChallengeLink($challenge->title, $challenge->id); */ $code .= '<div class="thumb">' . template::buildLinkedChallengePic($challenge->id, $challenge->thumbnail) . '</div> <div class="storyBlockWrap"> <div class="feed_poster"><div class="avatar">' . template::buildLinkedProfilePic($fbId, 'size="square" with="30" height="30"') . '</div> <h3><span class="bold">' . template::buildLinkedProfileName($fbId) . ' submitted ' . $submittedText . ' for the challenge ' . template::buildChallengeLink($challenge->title, $challenge->id) . ' </span> ' . $ago . '</h3> </div>' . '<p class="storyCaption">' . $submittedContent . '</p> </div><!__end "storyBlockWrap"__> '; } //$code .= self::getElapsedString(strtotime($action->t)); } else { if ($returnerrors) { $code = 'Couldnt load challengeid ' . $completed->id . '<br>'; } } // debugging } else { if ($returnerrors) { $code = 'Couldnt load completedid ' . $action->itemid . '<br>'; } } // debugging return $code; }
static function processChallengeSubmit(&$code, &$passback) { //$debug = $_POST['debugSubmit']; // NEVER TURN ON FOR LIVE SITE echo '<h2>Processing, please wait...</h2>'; if ($debug) { echo "POST<pre>" . print_r($_POST, true) . "</pre>"; } // TODO: grab session keys from post, validate session $passback .= "&text={$_POST['text']}"; $passback .= "&embedCode={$_POST['embedCode']}"; if ($debug) { echo $passback; } if (isset($_POST['challengeid']) && $_POST['challengeid']) { $challengeid = $_POST['challengeid']; } else { $code = "There was no challenge id present in your submission"; return false; } if (isset($_POST['text'])) { $evidence = $_POST['text']; } else { $evidence = ''; /*$code = "Your text submission was empty."; return false;*/ } if (isset($_POST['userid']) && $_POST['userid']) { $userid = $_POST['userid']; } else { $code = 'Either you aren\'t a registered user or your session is expired. Please return to the home page or sign in to facebook again.'; return false; } require_once PATH_CORE . '/classes/db.class.php'; $db = new cloudDatabase(); // create a CompletedChallenges object //$userid = $this->page->session->userid; /* if (!$userid) { echo "<pre>" . print_r($this->page->session, true) . "</pre>"; return "Could not get userid from session."; }*/ require_once PATH_CORE . '/classes/user.class.php'; require_once PATH_CORE . '/classes/challenges.class.php'; $challengeTable = new ChallengeTable($db); $userTable = new UserTable($db); $userInfoTable = new UserInfoTable($db); $completedTable = new ChallengeCompletedTable($db); $user = $userTable->getRowObject(); $userInfo = $userInfoTable->getRowObject(); $challenge = $challengeTable->getRowObject(); $completed = $completedTable->getRowObject(); dbRowObject::$debug = $debug; $user->load($userid); $userInfo->load($userid); $challenge->load($challengeid); // validate challenge submission info // validate eligibility, date, membership if ($challenge->remainingCompletions <= 0 && $challenge->initialCompletions > 0) { $code = 'This challenge can no longer be completed for credit.'; return false; } if (!ChallengeTable::userIsEligible($challenge->eligibility, $user->eligibility)) { $code = 'We\'re sorry, you are not eligible to receive credit for this challenge.'; return false; } if (preg_match("/text/i", $challenge->requires) && !($evidence != '')) { $code = 'Sorry, you need to convince us you actually did this!'; return false; } //if () // TODO: now is between date start and end $now = time(); $dateStart = strtotime($challenge->dateStart); $dateEnd = strtotime($challenge->dateEnd); if ($now > $dateEnd) { $code = 'Sorry, you are too late to receive credit for this challenge!'; return false; } if ($now < $dateStart) { $code = 'Sorry, you can\'t receive credit for this challenge yet -- try again later!'; return false; } // if () TODO: check user maximum by querying order histor // more... // everythings ok: $challenge->remainingCompletions--; $completed->userid = $user->userid; $completed->challengeid = $challenge->id; $phpnow = time(); $completed->dateSubmitted = date('Y-m-d H:i:s', $phpnow); $completed->status = 'submitted'; $completed->evidence = $evidence; $completed->comments = $evidence; // editors will review these later /* * The following code is a bit tricky. There are two things going on. The first is that photos * or videos are being checked for and their records are being created, but we have * tentatively created a CompleteChallenge record first so they can back-reference it * * If a required photo or video turns out not to have appeared, we have to then return an error * and delete the CC record. * * An extra wrinkle is that if both video and photo are in the requires field, we can accept * one or the other. * */ // Create the completed to attach to the media records... if (!$completed->insert()) { $code = 'Internal error submitting your evidence, please try again.'; return false; } if (preg_match("/photo/i", $challenge->requires) || preg_match("/optionalphoto/i", $challenge->requires)) { if ($photoFilename = self::processChallengeSubmitPhoto($userid, $completed->id)) { if (!preg_match("/\\.(jpg|png|gif|jpeg?)\$/i", $photoFilename)) { $msg = 'Sorry, your photo did not appear to be of type jpg, png, or gif.'; $error = true; } else { // create photo in our db require_once PATH_CORE . '/classes/photo.class.php'; $photoTable = new PhotoTable($db); $photoTable->createPhotoForCompletedChallenge($userid, $completed->id, $photoFilename, 'Photo submitted for ' . $challenge->title); $photoSubmitted = true; // indicate that a photo was found } } else { if (!preg_match("/optionalphoto/i", $challenge->requires)) { $msg = 'No photo submitted'; $error = true; } } } //$passback .= "&photo1={$photoFilename}"; // wont be correct filename, actually quite complicated to make this work properly //echo $passback; if (preg_match("/video/i", $challenge->requires)) { if ($videoEmbedCode = self::processChallengeSubmitVideo($userid, $completed->id)) { // create photo in our db require_once PATH_CORE . '/classes/video.class.php'; $videoTable = new VideoTable($db); $videoTable->createVideoForCompletedChallenge($userid, $completed->id, $videoEmbedCode, 'Video submitted for ' . $challenge->title); $videoSubmitted = true; // indicate video found } else { $msg = 'You must enter a YouTube video url.'; $error = true; } } // HACK: now handle the case where both photo and video boxes appeared, and only one was entered if ($photoSubmitted or $videoSubmitted) { $error = false; } // set the $error flag set by the other one to false if one of them was sucessfully created if ($error) { $completed->delete(); // delete the temporary CC record $code = $msg; return false; } $challenge->update(); require_once PATH_CORE . '/classes/template.class.php'; $code .= 'We have received your submission for the challenge <b>' . $challenge->title . '</b> (reference number #' . $completed->id . ')'; dbRowObject::$debug = 0; // NEVER TURN ON FOR LIVE SITE // for testing purposes -- approve free points right away if ($challenge->shortName == 'testPoints10k') { $code2 = ''; if (!$completedTable->approveChallenge($completed->id, $challenge->pointValue, &$code2, false)) { $code = $code2; return false; } else { $code = 'Free points awarded!'; } } return true; }
public function approve_completed_challenge() { // slight hack, since this now handles rejection as well if (isset($_POST['completed_challenge']['id']) && preg_match('/^[0-9]+$/', $_POST['completed_challenge']['id'])) { $id = $_POST['completed_challenge']['id']; } else { set_flash(array('error' => "Invalid {$group} -- {$action} -- id: {$id}.")); redirect(url_for('street_team', 'completed_challenges')); } if ($_POST['reject']) { /* * //$_POST['completed_challenge[status]']='rejected'; // set status to rejected // update to set comment text if (($result = $this->db->update($_POST['completed_challenge'])) == 1) { */ // grrr russell require_once PATH_CORE . '/classes/challenges.class.php'; $cct = new ChallengeCompletedTable(); $cc = $cct->getRowObject(); if ($cc->load($id)) { $cc->status = 'rejected'; $cc->update(); set_flash(array('notice' => "Challenge submission {$id} rejected.")); redirect(url_for('street_team', 'view_completed_challenge', $id)); } else { set_flash(array('error' => 'Could not update your completed_challenge! Please try again. ' . $result)); redirect(url_for('street_team', 'modify_completed_challenge', $id)); } } elseif (isset($_POST['pointsAwarded'])) { // update to set comment text if (($result = $this->db->update($_POST['completed_challenge'])) == 1) { } else { set_flash(array('error' => 'Could not update your completed_challenge! Please try again. ' . $result)); redirect(url_for('street_team', 'modify_completed_challenge', $id)); } // djm: require_once PATH_CORE . '/classes/challenges.class.php'; $cct = new ChallengeCompletedTable(); $cct->approveChallenge($id, $_POST['pointsAwarded'], &$code); /* if (($result = $this->db->update($_POST['completed_challenge'])) == 1) { set_flash(array('notice' => 'Successfully updated completed_challenge.')); redirect(url_for('street_team', 'view_completed_challenge', $id)); } else { set_flash(array('error' => 'Could not update your completed_challenge! Please try again. '.$result)); redirect(url_for('street_team', 'review_completed_challenge', $id)); }*/ set_flash(array('notice' => $code)); redirect(url_for('street_team', 'view_completed_challenge', $id)); } else { set_flash(array('error' => 'Form data not submitted properly, please try again.')); redirect(url_for('street_team', 'view_completed_challenge', $id)); } }