public static function getWinningVideoId($id)
{
$logger = new FileWriter('win_id_log', 'a');
if (!is_integer($id) || $id <= 0) {
$fnOk = MyUtil::fnOk(false, "Invalid Session ID: {$id}" . !is_integer($id) . "-" . ($id <= 0), null);
$logger->writeLog($fnOk['reason']);
return $fnOk;
}
$stm = "SELECT COALESCE(winner_video_id, 0) as winner_video_id FROM " . self::$table_name . " WHERE id = {$id}";
$logger->writeLog($stm);
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
$row = pg_fetch_assoc($result);
if ($row['winner_video_id'] > 0) {
return MyUtil::fnOk(true, "Video Id Found", $row['winner_video_id']);
} else {
$stm = " SELECT COALESCE(id, 0) as winner_video_id " . " FROM spire.videos " . " WHERE session_id = {$id} " . " AND votes = (SELECT MAX(votes) FROM spire.videos WHERE session_id = {$id})";
$logger->writeLog($stm);
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
$row = pg_fetch_assoc($result);
if ($row['winner_video_id'] > 0) {
return MyUtil::fnOk(true, "Video Id Found", $row['winner_video_id']);
} else {
return MyUtil::fnOk(false, "Video Id Not Found", null);
}
}
}
//api/index.php
define('FACEBOOK_SDK_V4_SRC_DIR', '/home1/enderrac/SpirePHP/facebook-php-sdk-v4-4.0-dev/src/Facebook/');
require '/home1/enderrac/SpirePHP/facebook-php-sdk-v4-4.0-dev/autoload.php';
require '/home1/enderrac/SpirePHP/JsonResponse.php';
require '/home1/enderrac/SpirePHP/SpirePHP.php';
require '/home1/enderrac/SpirePHP/User.php';
use Facebook\FacebookSession;
use Facebook\FacebookRequest;
use Facebook\GraphUser;
use Facebook\FacebookRequestException;
use Facebook\FacebookRedirectLoginHelper;
FacebookSession::setDefaultApplication('879340512104772', '44e7ebc4f1bff480297ce6878f02ff40');
$logger = new FileWriter('spire_api_log', 'a');
$request_data = json_decode(file_get_contents("php://input"));
$logger->writeLog("\n#####NEW REQUEST#####");
$logger->writeLog("Request Type: " . $_SERVER['REQUEST_METHOD']);
$logger->writeLog("_GET = " . json_encode($_GET));
$logger->writeLog("_FILES = " . json_encode($_FILES));
$logger->writeLog("_POST = " . json_encode($_POST));
$logger->writeLog("request_data = " . json_encode($request_data));
$headers = apache_request_headers();
foreach ($headers as $header => $value) {
$logger->writeLog("{$header}: {$value}");
}
$TOKEN = $headers['Token'];
$logger->writeLog("\$TOKEN: {$TOKEN}");
$TOKEN_DATA = null;
$tokenDataHash = LoginDao::getTokenData($TOKEN);
if ($tokenDataHash['ok']) {
$TOKEN_DATA = $tokenDataHash['result'];
