// Copyright 2011 JMB Software, Inc. // // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // http://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. require_once 'includes/global.php'; Request::Setup(); if (AuthenticateUser::Login()) { $username = AuthenticateUser::GetUsername(); $video_id = $_REQUEST['video_id']; $reason_id = $_REQUEST['reason_id']; $DB = GetDB(); if ($DB->QueryCount('SELECT COUNT(*) FROM `tbx_video_featured` WHERE `username`=? AND `video_id`=?', array($username, $video_id)) == 0) { StatsRollover(); $DB->Update('INSERT INTO `tbx_video_featured` VALUES (?,?,?,?)', array($video_id, $username, $reason_id, Database_MySQL::Now())); $DB->Update('UPDATE `tbx_video_stat` SET ' . '`today_num_featured`=`today_num_featured`+1,' . '`week_num_featured`=`week_num_featured`+1,' . '`month_num_featured`=`month_num_featured`+1,' . '`total_num_featured`=`total_num_featured`+1 ' . 'WHERE `video_id`=?', array($video_id)); echo _T('Text:Feature request recorded'); } else { echo _T('Validation:You have already featured this video'); } } else { echo _T('Validation:Must be logged in'); }
// // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // http://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. require_once 'includes/global.php'; Request::Setup(); $flag_guest_ratings = Config::Get('flag_guest_ratings'); if (AuthenticateUser::Login() || $flag_guest_ratings) { $username = AuthenticateUser::GetUsername(); if ($flag_guest_ratings && empty($username)) { $username = $_SERVER['REMOTE_ADDR']; } $rating = $_REQUEST['rating']; $video_id = $_REQUEST['video_id']; if ($rating >= 1 && $rating <= 5) { $DB = GetDB(); if ($DB->QuerySingleColumn('SELECT `allow_ratings` FROM `tbx_video` WHERE `video_id`=?', array($video_id)) == 1) { if ($DB->QueryCount('SELECT COUNT(*) FROM `tbx_video_rating` WHERE `username`=? AND `video_id`=?', array($username, $video_id)) == 0) { StatsRollover(); $DB->Update('INSERT INTO `tbx_video_rating` VALUES (?,?,?,?)', array($username, $video_id, $rating, Database_MySQL::Now())); $DB->Update('UPDATE `tbx_video_stat` SET ' . '`today_num_ratings`=`today_num_ratings`+1,' . '`today_sum_of_ratings`=`today_sum_of_ratings`+?,' . '`today_avg_rating`=`today_sum_of_ratings`/`today_num_ratings`,' . '`week_num_ratings`=`week_num_ratings`+1,' . '`week_sum_of_ratings`=`week_sum_of_ratings`+?,' . '`week_avg_rating`=`week_sum_of_ratings`/`week_num_ratings`,' . '`month_num_ratings`=`month_num_ratings`+1,' . '`month_sum_of_ratings`=`month_sum_of_ratings`+?,' . '`month_avg_rating`=`month_sum_of_ratings`/`month_num_ratings`,' . '`total_num_ratings`=`total_num_ratings`+1,' . '`total_sum_of_ratings`=`total_sum_of_ratings`+?,' . '`total_avg_rating`=`total_sum_of_ratings`/`total_num_ratings` ' . 'WHERE `video_id`=?', array($rating, $rating, $rating, $rating, $video_id)); echo _T('Text:Rating recorded'); } else {
function tbxLogin() { global $t; AuthenticateUser::Login(); $v = Validator::Create(); $v->Register(AuthenticateUser::Authenticated(), Validator_Type::IS_TRUE, AuthenticateUser::GetError()); if (!$v->Validate()) { $t->Assign('g_errors', $v->GetErrors()); $t->Assign('g_form', $_REQUEST); return tbxDisplayLogin(); } if (empty($_REQUEST['referrer']) || stristr($_REQUEST['referrer'], Config::Get('base_url')) === false) { $t->Assign('g_logged_in', true); tbxDisplayMyAccount(true); } else { header('Location: ' . $_REQUEST['referrer']); } }