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 />"; } }
function revokeAutomaticChallengeAward($userid, $shortname) { require_once PATH_CORE . '/classes/user.class.php'; $challengeTable = new ChallengeTable($db); $userTable = new UserTable($db); $userInfoTable = new UserInfoTable($db); $completedTable = $this; $user = $userTable->getRowObject(); $userInfo = $userInfoTable->getRowObject(); $challenge = $challengeTable->getRowObject(); $completed = $completedTable->getRowObject(); $ccid; $res = $this->db->query("SELECT SQL_CALC_FOUND_ROWS ChallengesCompleted.id AS ccid \n\t\t\t\t\t\t\t\t\tFROM ChallengesCompleted,Challenges \n\t\t\t\t\t\t\t\t\t\tWHERE userid={$userid} \n\t\t\t\t\t\t\t\t\t\t\tAND Challenges.id = challengeid \n\t\t\t\t\t\t\t\t\t\t\tAND Challenges.shortName='{$shortname}'\n\t\t\t\t\t\t\t\t\t\t\tAND ChallengesCompleted.status='awarded';"); if ($this->db->countQ($res)) { $data = $this->db->readQ($res); } else { return false; } $ccid = $data->ccid; if (!$completed->load($ccid)) { return false; } $completed->pointsAwarded = 0; $completed->dateAwarded = date('Y-m-d H:i:s', time()); $completed->update(); return true; }
function fetchChallengeDetail($id, $noButtons = false, &$challenge) { require_once PATH_CORE . '/classes/challenges.class.php'; $challengeTable = new ChallengeTable($this->db); $challenge = $challengeTable->getRowObject(); if ($id && $challenge->load($id)) { if ($challenge->maxUserCompletionsPerDay > 0 || $challenge->maxUserCompletions > 0) { $challengelimits = "You may receive points for this challenge " . ($challenge->maxUserCompletionsPerDay > 0 ? "{$challenge->maxUserCompletionsPerDay} times per day" : "") . ($challenge->maxUserCompletionsPerDay > 0 && $challenge->maxUserCompletions ? " and " : "") . ($challenge->maxUserCompletions > 0 ? "{$challenge->maxUserCompletions} times" . $this->templateObj->templates['CompletionTimesClause'] . "" : "") . '. '; } $challengelimits .= $challenge->initialCompletions > 0 ? "We will only award points to the \n\t\t\t\t\t\tfirst {$challenge->initialCompletions} users that complete it." : ''; // if challenge expired, no buttons sscanf($challenge->dateEnd, "%4u-%2u-%2u %2u:%2u:%2u", $year, $month, $day, $hour, $min, $sec); $newtstamp = mktime($hour, $min, $sec, $month, $day, $year); if ($newtstamp < time()) { $noButtons = true; $isExpired = true; } else { $isExpired = false; } $designcode = ' <div id="readStoryList"> <div class="panel_block"> <div class="thumb"><img src="' . URL_THUMBNAILS . '/' . $challenge->thumbnail . '" width="180" alt="challenge thumbnail" /></div> <div class="storyBlockWrap"> <p class="storyHead">' . $challenge->title . '</p> <div class="storyBlockMeta"> <p class="pointValue">Earn ' . ($challenge->pointValue == 0 ? 'flex' : $challenge->pointValue) . ' <span class="pts">pts</span></p> </div><!--end "storyBlockMeta"--> <!--<p class="storyCaption">--><p>' . $challenge->description . '</p>' . $this->templateObj->templates['ChallengeDescriptionFootnote'] . ($challenge->type == 'automatic' ? '<h3>This challenge is part of the ' . SITE_TITLE . ' application itself, you will receive credit automatically just by using the site</h3>' : '') . '<h3>' . ($isExpired ? 'This challenge is expired' : $challengelimits) . '</h3>' . '</div><!--end "storyBlockWrap"--> <p class=""> ' . ($noButtons ? '' : template::buildChallengeSubmitLink("I did this", $challenge->id, "btn_1 " . ($challenge->type == 'automatic' ? 'hidden' : ''))) . ' </p> </div><!--end "panel_block"--> </div><!--end "readStoryList"--> '; $code = $designcode; } else { $code .= "Invalid challenge id='{$id}', please try again."; } $code = '<div class="">' . $code . '</div>'; //$code .= 'TODO: We did this panel goes here:'; return $code; }
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>'; ?>
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; }
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; }