function loadByParams($params = array(), $limit = FALSE, $offset = FALSE)
{
global $database;
$extra_clause = "";
if ($limit !== FALSE and !empty($limit)) {
$extra_clause .= " LIMIT {$limit}";
}
if ($offset !== FALSE and !empty($offset)) {
$extra_clause .= " OFFSET {$offset}";
}
$query = "SELECT " . $this->_tbl . ".id FROM " . $this->_tbl . " " . buildWhere($params) . " {$extra_clause};";
jTipsLogger::_log("FULL QUERY: {$query}");
$database->setQuery($query);
$database->query();
if ($database->getNumRows() > 1) {
$jObjs = array();
$list = (array) $database->loadResultArray();
foreach ($list as $id) {
$jObj = new jTip($database);
$jObj->load($id);
array_push($jObjs, $jObj);
}
return $jObjs;
} else {
if ($database->getNumRows() == 1) {
$this->load($database->loadResult());
return $this;
} else {
return FALSE;
}
}
}
/**
* Take data assigned in $data and display it
*/
function display()
{
global $jTipsCurrentUser, $mainframe, $database, $jLang, $jTips, $mosConfig_live_site;
$mosConfig_offset = $mainframe->getCfg('offset');
//$Itemid = jTipsGetParam($_REQUEST, 'Itemid', '');
global $Itemid;
//$mainframe->setPageTitle(getComponentName($Itemid).' > '.$jTips['Menu']['Tips']);
//jTipsCommonHTML::loadOverlib();
$useJs = false;
if ($jTips['JsLadder'] != 'none') {
$useJs = true;
}
if ($jTips['EnableComments'] == 1 and $jTips['EnableCommentFilter'] == 1) {
$checkComment = "onclick='return validateComment(\"comment\");'";
} else {
$checkComment = "onClick='document.tips_form.submit();'";
}
//jtips_HTML::buildMenu('tips', $this->jSeason, $this->jTipsUser);
//jtips_HTML::seasonsList($this->jTipsUser, $this->jSeasons, "onchange='getSeason(this);'", true, jTipsGetParam($_REQUEST, 'season', jTipsGetParam($_REQUEST, 'season_id', false)));
$postURL = jTipsRoute("index.php?option=com_jtips&Itemid={$Itemid}");
?>
<script type='text/javascript'>
function getSeason(obj) {
var id = obj.options[obj.selectedIndex].value;
return window.location.href='<?php
echo html_entity_decode(jTipsRoute("index.php?option=com_jtips&Itemid={$Itemid}&task=Tips&season="));
?>
' + id;
}
</script>
<form action='<?php
echo $postURL;
?>
' method='post' name='tips_form' id='tips_form'>
<input type='hidden' name='option' value='com_jtips' />
<input type='hidden' name='view' value='Tips' />
<input type="hidden" name="action" value="save" />
<input type='hidden' name='user_id' value='<?php
echo $jTipsCurrentUser->id;
?>
' />
<input type="hidden" name="<?php
echo jTipsSpoofValue();
?>
" value="1" />
<h2 class="contentheading jmain_heading"><?php
echo $this->jSeason->name;
?>
</h2>
<h3 align="center">
<?php
if ($this->jRound->getPrev()) {
?>
<a style="font-size:smaller;" href='<?php
echo jTipsRoute("index.php?option=com_jtips&Itemid={$Itemid}&view=Tips&rid=" . $this->jRound->getPrev());
?>
'>« <?php
echo $jLang['_COM_PREV_ROUND'];
?>
</a>
<?php
}
echo " " . $jLang['_COM_DASH_ROUND'] . " " . $this->jRound->round . " ";
if ($this->jRound->getNext()) {
?>
<a style="font-size:smaller;" href='<?php
echo jTipsRoute("index.php?option=com_jtips&Itemid={$Itemid}&view=Tips&rid=" . $this->jRound->getNext());
?>
'><?php
echo $jLang['_COM_NEXT_ROUND'];
?>
»</a>
<?php
}
?>
</h3>
<?php
if ($this->jRound->exists()) {
$jGameParams = array('round_id' => $this->jRound->id, 'order' => array('type' => 'order', 'by' => 'position', 'direction' => 'ASC'));
$jGame = new jGame($database);
$jGames = forceArray($jGame->loadByParams($jGameParams));
$tags = "class='sectiontableheader jtableheader'";
?>
<table width="100%" cellspacing="0">
<thead>
<tr class="sectiontableheader">
<th <?php
echo $tags;
?>
width="33%"><?php
echo $jLang['_COM_TIPS_TIPPING_CLOSE'];
?>
</th>
<?php
if ($jTips['ShowJSCountdown'] == 1) {
?>
<th <?php
echo $tags;
?>
width="34%"><?php
echo $jLang['_COM_TIPS_TIME_TO_CLOSE'];
?>
</th>
<?php
}
?>
<th <?php
echo $tags;
?>
width="33%"><?php
echo $jLang['_COM_TIPS_LASTUP'];
?>
</th>
</tr>
</thead>
<tbody>
<tr class="sectiontableentry1">
<td style="text-align:center;">
<?php
//BUG 136 - show closed/closes depending on start time
echo TimeDate::toDisplayDateTime($this->jRound->start_time, false);
?>
</td>
<?php
if ($jTips['ShowJSCountdown'] == 1) {
?>
<td><div id='countdown' style="text-align:center;" class="highlight"><?php
echo $jLang['_COM_CLOSED'];
?>
</div></td>
<?php
}
$jTipParams = array('game_id' => array('type' => 'reference', 'query' => "SELECT DISTINCT id FROM #__jtips_games WHERE round_id = " . $this->jRound->id), 'user_id' => $jTipsCurrentUser->id);
$jTip = new jTip($database);
$jTipss = forceArray($jTip->loadByParams($jTipParams));
?>
<td><?php
if (count($jTipss) > 0) {
echo TimeDate::toDisplayDateTime($jTipss[0]->updated, false);
} else {
echo " ";
}
?>
</td>
</tr>
</tbody>
</table>
<?php
if (jTipsGetParam($jTips, 'TeamLadderPopup', 0)) {
$url = "view=TeamLadder&Itemid={$Itemid}&menu=0";
?>
<p style="text-align:center;font-weight:bold;"><?php
if (isJoomla15()) {
/*?>
<a class="modal" rel="{handler: 'iframe', size: {x: <?php echo $jTips['ShowTipsWidth']; ?>, y: <?php echo $jTips['ShowTipsHeight']; ?>}}" href="<?php echo jTipsRoute("index2.php?option=com_jtips&" .$url); ?>" title='Team Ladder'><?php echo $jLang['_COM_TIPS_SHOWHIDE']; ?></a>
<?php*/
// better popup handling in J1.5
JHTML::_('behavior.modal');
$rel = json_encode(array('size' => array('x' => $jTips['ShowTipsWidth'], 'y' => $jTips['ShowTipsHeight'])));
$url = jTipsRoute("index.php?option=com_jtips&tmpl=component&" . $url);
$attribs = array('class' => 'modal', 'rel' => str_replace('"', "'", $rel), 'title' => $jLang['_COM_TIPS_SHOWHIDE']);
echo JHTML::link($url, $jLang['_COM_TIPS_SHOWHIDE'], $attribs);
} else {
?>
<a href='javascript:void(0);' onClick="openPopup('<?php
echo $url;
?>
', 'Team Ladder');"><?php
echo $jLang['_COM_TIPS_SHOWHIDE'];
?>
</a>
<?php
}
?>
</p><?php
}
//BUG 189 - Which order should the tips panel be shown in
if ($this->jSeason->tips_layout == 'away') {
$left = 'away';
$right = 'home';
} else {
$left = 'home';
$right = 'away';
}
?>
<table align='center' width='100%' class="jdatatable" cellspacing="0">
<tr>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_GAME_' . strtoupper($left)];
?>
</th>
<?php
if ($this->jSeason->team_starts) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_' . strtoupper($left) . 'START'];
?>
</th>
<?php
}
if ($this->jSeason->pick_score == 1) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_' . strtoupper($left) . 'SCORE'];
?>
</th>
<?php
}
?>
<th <?php
echo $tags;
?>
>
<?php
if ($this->jSeason->pick_draw == 1 and ($this->jSeason->pick_score and !$jTips['HideTeamSelect'] or !$this->jSeason->pick_score)) {
echo " " . $jLang['_COM_GAME_DRAW'] . " ";
} else {
echo " ";
}
?>
</th>
<?php
if ($this->jSeason->pick_score == 1) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_' . strtoupper($right) . 'SCORE'];
?>
</th>
<?php
}
if ($this->jSeason->team_starts) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_' . strtoupper($right) . 'START'];
?>
</th>
<?php
}
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_GAME_' . strtoupper($right)];
?>
</th>
<?php
if ($this->jSeason->pick_margin == 1) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_MARGIN'];
?>
</th>
<?php
}
if ($this->jSeason->pick_bonus >= 1) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_BONUS'];
?>
</th>
<?php
}
if ($this->jSeason->game_times) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_TIME'];
?>
</th>
<?php
}
if ($this->jRound->scored == 1) {
?>
<th <?php
echo $tags;
?>
><?php
echo $jLang['_COM_TIPS_RESULT'];
?>
</th>
<?php
}
?>
<th <?php
echo $tags;
?>
> </th>
</tr>
<?php
// BUG 316 - have TimeDate::toDatabaseDateTime around jRound->start_time was deducting an offset from a GMT time - bad
if ($this->jRound->start_time < gmdate('Y-m-d H:i:s') or $jTipsCurrentUser->hasTipped($this->jRound->id) and $jTips['TipLockout'] == 1) {
$disabled = "disabled";
} else {
$disabled = '';
}
$hasTipped = count($jTipss) > 0;
$rowIndex = 0;
foreach ($jGames as $jGame) {
$leftTeam = new jTeam($database);
$rightTeam = new jTeam($database);
$jTipParams = array('user_id' => $jTipsCurrentUser->id, 'game_id' => $jGame->id);
$jTip->loadByParams($jTipParams);
$left_id_field = $left . '_id';
$right_id_field = $right . '_id';
$leftLoaded = $rightLoaded = false;
if ($jGame->{$left_id_field}) {
$leftTeam->load($jGame->{$left_id_field});
$leftLoaded = true;
}
if ($jGame->{$right_id_field}) {
$rightTeam->load($jGame->{$right_id_field});
$rightLoaded = true;
}
if (!$leftLoaded and $rightLoaded) {
$this->byes[] = $rightTeam;
}
if ($leftLoaded and !$rightLoaded) {
$this->byes[] = $leftTeam;
}
if (!$leftLoaded or !$rightLoaded) {
continue;
}
if ($jGame->winner_id == $leftTeam->id) {
$left_style = "font-weight:bold;";
$right_style = "";
} else {
if ($jGame->winner_id == -1) {
$left_style = "font-style:italics;";
$right_style = "font-style:italics;";
} else {
if ($jGame->winner_id == $rightTeam->id) {
$left_style = "";
$right_style = "font-weight:bold;";
} else {
$left_style = "";
$right_style = "";
}
}
}
$rowClasses = "class='sectiontableentry" . ($rowIndex % 2 + 1) . " jtablerow" . ($rowIndex % 2 + 1) . "'";
if ($this->jSeason->pick_score and $jGame->has_score) {
$onClick = 'onClick="switchScore(' . $jGame->id . ');"';
} else {
$onClick = '';
}
?>
<tr <?php
echo $rowClasses;
?>
>
<td style='text-align:right;<?php
echo $left_style;
?>
'><label for="<?php
echo $left;
?>
_game<?php
echo $jGame->id;
?>
"><?php
echo $leftTeam->getDisplayLogoName('right');
?>
</label>
<?php
if ($this->jSeason->pick_score and !$jTips['HideTeamSelect'] or !$this->jSeason->pick_score) {
?>
<input type='radio' <?php
echo $onClick;
?>
class="inputbox" name='game<?php
echo $jGame->id;
?>
' id='<?php
echo $left;
?>
_game<?php
echo $jGame->id;
?>
' value='<?php
echo $leftTeam->id;
?>
' <?php
echo $jTip->tip_id == $leftTeam->id ? 'checked="checked"' : '';
?>
<?php
echo $disabled;
?>
/>
<?php
}
?>
</td>
<?php
if ($this->jSeason->team_starts) {
$left_start_field = $left . '_start';
$leftStart = $jGame->{$left_start_field} + 0;
if ($jGame->{$left_start_field} > 0) {
$leftStart = "+{$leftStart}";
} else {
if ($leftStart == 0) {
$leftStart = " ";
}
}
?>
<td style='text-align:center;'><?php
echo $leftStart;
?>
</td>
<?php
}
if ($this->jSeason->pick_score == 1) {
?>
<td style='text-align:center;'>
<?php
if ($jGame->has_score == 1) {
?>
<input type='text' onKeyUp="this.value=this.value.replace(/[^\d]+/, '');" class="inputbox" id="<?php
echo $left . $jGame->id;
?>
" name='<?php
echo $left . $jGame->id;
?>
' style='text-align:center;' maxLength='5' size='5' value='<?php
$left_score_field = $left . '_score';
echo $jTip->{$left_score_field};
?>
' <?php
echo $disabled;
?>
onBlur="setSelectedTeam(<?php
echo $jGame->id;
?>
);" />
<?php
} else {
?>
<?php
}
?>
</td>
<?php
}
if ($this->jSeason->pick_draw == 1 and ($this->jSeason->pick_score and !$jTips['HideTeamSelect'] or !$this->jSeason->pick_score)) {
?>
<td style='text-align:center;'> <input class="inputbox" type='radio' name='game<?php
echo $jGame->id;
?>
' id="draw_game<?php
echo $jGame->id;
?>
" value='-1' <?php
echo $jTip->tip_id == -1 ? 'checked="checked"' : '';
?>
<?php
echo $disabled;
?>
<?php
echo $onClick;
?>
/></td>
<?php
} else {
?>
<td style='text-align:center;'> <?php
echo $jLang['_COM_TEAM_VS'];
?>
</td>
<?php
}
if ($this->jSeason->pick_score == 1) {
?>
<td style='text-align:center;'>
<?php
if ($jGame->has_score == 1) {
?>
<input type='text' onKeyUp="this.value=this.value.replace(/[^\d]+/, '');" class="inputbox" id="<?php
echo $right . $jGame->id;
?>
" name='<?php
echo $right . $jGame->id;
?>
' style='text-align:center;' maxLength='5' size='5' value='<?php
$right_score_field = $right . '_score';
echo $jTip->{$right_score_field};
?>
' <?php
echo $disabled;
?>
onBlur="setSelectedTeam(<?php
echo $jGame->id;
?>
);" />
<?php
} else {
?>
<?php
}
?>
</td>
<?php
}
$right_start_field = $right . '_start';
if ($this->jSeason->team_starts) {
$rightStart = $jGame->{$right_start_field} + 0;
if ($jGame->{$right_start_field} > 0) {
$rightStart = "+{$rightStart}";
} else {
if ($rightStart == 0) {
$rightStart = " ";
}
}
?>
<td style='text-align:center;'><?php
echo $rightStart;
?>
</td>
<?php
}
?>
<td style='text-align:left;<?php
echo $right_style;
?>
'>
<?php
if ($this->jSeason->pick_score and !$jTips['HideTeamSelect'] or !$this->jSeason->pick_score) {
?>
<input type='radio' <?php
echo $onClick;
?>
class="inputbox" name='game<?php
echo $jGame->id;
?>
' value='<?php
echo $rightTeam->id;
?>
' <?php
echo $jTip->tip_id == $rightTeam->id ? 'checked="checked"' : '';
?>
<?php
echo $disabled;
?>
id="<?php
echo $right;
?>
_game<?php
echo $jGame->id;
?>
"/>
<?php
}
?>
<label for="<?php
echo $right;
?>
_game<?php
echo $jGame->id;
?>
"><?php
echo $rightTeam->getDisplayLogoName('left');
?>
</label>
</td>
<?php
if ($this->jSeason->pick_margin == 1) {
?>
<td style='text-align:center;'>
<?php
if ($jGame->has_margin == 1) {
?>
<input type='text' onKeyUp="this.value=this.value.replace(/[^\d]+/, '');" class="inputbox" name='margin<?php
echo $jGame->id;
?>
' style='text-align:center;' maxLength='5' size='5' value='<?php
echo $jTip->margin;
?>
' <?php
echo $disabled;
?>
/>
<?php
} else {
?>
<?php
}
?>
</td>
<?php
}
if ($this->jSeason->pick_bonus > 0) {
if ($jGame->has_bonus == 1) {
// BUG 302 - awayTeam and homeTeam do not exist anymore
$bonusTeams = array('' => $jLang['_ADMIN_CONF_NONE'], $jGame->{$left_id_field} => $leftTeam->getName(), $jGame->{$right_id_field} => $rightTeam->getName());
if ($this->jSeason->pick_bonus == 2) {
$bonusTeams['-2'] = $jLang['_ADMIN_SEASON_EPTB_BOT'];
}
?>
<td style='text-align:center;'><?php
echo makeSelectList($bonusTeams, 'bonus' . $jGame->id, "{$disabled} class='inputbox'", $jTip->bonus_id);
?>
</td>
<?php
} else {
?>
<td style='text-align:center;'> </td>
<?php
}
}
//show the game time
if ($this->jSeason->game_times) {
?>
<td><?php
if ($jGame->start_time) {
echo TimeDate::toDisplayDateTime($jGame->start_time, false);
} else {
echo " ";
}
?>
</td><?php
}
if ($this->jRound->scored == 1) {
$left_score_field = $left . '_score';
$right_score_field = $right . '_score';
?>
<th <?php
echo $tags;
?>
><?php
echo $jGame->{$left_score_field} . " - " . $jGame->{$right_score_field};
?>
</th>
<?php
}
?>
<td><?php
if (!empty($jGame->description)) {
$description = nl2br(stripslashes($jGame->description));
echo jTipsToolTip($description, $jLang['_COM_GAME_ADDITIONAL_INFO']);
} else {
echo " ";
}
?>
</td>
</tr>
<?php
$rowIndex++;
}
?>
</table>
<div>
<?php
$this->renderByes();
?>
<table width="100%" cellspacing="10">
<?php
if ($jTips['DoubleUp'] == 1) {
if ($jTipsCurrentUser->doubleup > 0 && $jTipsCurrentUser->doubleup < $this->jRound->id || $disabled == 'disabled') {
$disable_doubleup = 'disabled';
} else {
$disable_doubleup = '';
}
?>
<tr>
<td style='text-align:center'><h4><label for="doubleup"><?php
echo $jLang['_COM_GAME_USEDOUBLE'];
?>
</label> <input type='checkbox' class="inputbox" id="doubleup" name='doubleup' value='<?php
echo $this->jRound->id;
?>
' <?php
echo $jTipsCurrentUser->doubleup == $this->jRound->id ? "checked" : "";
?>
<?php
echo $disable_doubleup;
?>
/></h4></td>
</tr>
<?php
}
if ($jTips['EnableComments'] == 1) {
if ($disabled == 'disabled') {
$commentArea = "<em>";
if (strlen($this->jComment->comment) > 0) {
$commentArea .= $this->jComment->comment;
} else {
$commentArea .= $jLang['_ADMIN_CONF_NONE'];
}
$commentArea .= "</em>";
} else {
$comment = str_replace('"', "'", $this->jComment->comment);
$commentArea = '
<input name="comment" id="comment" size="50" class="inputbox" value="' . $comment . '" />
';
}
?>
<tr>
<td style="text-align:center;"><?php
echo $jLang['_COM_DASH_COMMENT'];
?>
: <?php
echo $commentArea;
?>
</td>
</tr>
<?php
}
?>
<tr>
<td style='text-align:center' id='submittipsbuttonarea'><?php
echo $disabled != "disabled" ? "<input type='button' class='button' name='submittips' id='submittips' value='" . $jLang['_COM_TIPS_SAVE'] . "' {$checkComment} />" : "";
?>
</td>
</tr>
<tr>
<td style='text-align:center; padding-top:5px; display:none;' id='ajaxloading'></td>
</tr>
</table>
</div>
<input type='hidden' name='round_id' value='<?php
echo $this->jRound->id;
?>
' />
</form>
<?php
} else {
if ($this->jRound->exists() and TimeDate::toDatabaseDateTime($this->jRound->start_time) > gmdate('Y-m-d H:i:s')) {
?>
<h2 style='text-align:center'><?php
echo $jLang['_COM_DASH_ROUND'] . " " . $this->jRound->round;
?>
</h2>
<h2 style='text-align:center'><?php
echo $jLang['_COM_ROUND_CLOSED'];
?>
</h2>
<?php
} else {
if ($this->jRound->exists()) {
?>
<h2 style='text-align:center'><?php
echo $jLang['_COM_DASH_ROUND'] . " " . $this->jRound->round;
?>
</h2>
<?php
} else {
?>
<h2 style='text-align:center'><?php
echo $jLang['_COM_ROUND_NOGAMES'];
?>
</h2>
<?php
}
}
}
if ($this->jRound->getStatus() === false and !empty($jTipsCurrentUser->id)) {
$userTime = strtotime($this->jRound->start_time) - TimeDate::getOffset(false);
$targetTime = date('Y-m-d H:i:s', $userTime);
if ($jTips['ShowJSCountdown'] == 1) {
$field = "'countdown'";
} else {
$field = "false";
}
?>
<script type='text/javascript'>
window.addEvent('domready', function(){
var year = <?php
echo TimeDate::format($targetTime, '%Y', true, false);
?>
;
var month = <?php
echo TimeDate::format($targetTime, '%m', true, false) - 1;
?>
;
var day = <?php
echo TimeDate::format($targetTime, '%d', true, false);
?>
;
var hour = <?php
echo TimeDate::format($targetTime, '%H', true, false);
?>
;
var min = <?php
echo TimeDate::format($targetTime, '%M', true, false);
?>
;
var sec = 0;
jTipsCountdown(year, month, day, hour, min, 1, <?php
echo $field;
?>
);
});
</script>
<?php
}
}
function destroy($id = false)
{
if ($id == FALSE) {
$id = $this->id;
}
jTipsLogger::_log("Delete " . $this->_tbl . " record with id = '{$id}'");
//delete all history records for this user and season
if (!$this->id) {
$this->load($id);
}
// BUG 129 - Unsubscribing from season leaves history
$params = array('user_id' => $id);
//deleting history etc can take a while, so dont time out
set_time_limit(0);
$jHistory = new jHistory($this->_db);
$jHistories = forceArray($jHistory->loadByParams($params));
jTipsLogger::_log('Found ' . count($jHistories) . ' history records for user ' . $id, 'INFO');
if (is_array($jHistories) and !empty($jHistories)) {
foreach ($jHistories as $jHist) {
jTipsLogger::_log('deleting history record', 'INFO');
$jHist->destroy();
}
}
//reset outof and ranks for remaining users
//get the rounds to be updated firs
$query = "SELECT id FROM #__jtips_rounds WHERE season_id = '" . $this->season_id . "' AND scored = 1";
$this->_db->setQuery($query);
$rids = $this->_db->loadResultArray();
//die(implode(", ", $rids));
if (!empty($rids)) {
foreach ($rids as $r) {
$jHistory->setRanks($r);
}
}
//Now delete the tips
$tip = new jTip($this->_db);
$tips = forceArray($tip->loadByParams($params));
if (!empty($tips)) {
foreach ($tips as $t) {
$t->destroy();
}
}
// BUG 402 - need to also delete any comments made
$comment = new jComment($this->_db);
$comments = $comment->loadByParams($params);
if (!empty($comments)) {
foreach ($comments as $c) {
$c->destroy();
}
}
return $this->delete($id);
}
/**
* Author: Jeremy Roberts
* Company: jTips
* Website: www.jtips.com.au
* Licence: Commercial. May not be copied, modified or redistributed
*/
defined('_JEXEC') or defined('_VALID_MOS') or die('Direct Access to this location is not allowed.');
require_once 'components/com_jtips/classes/jtip.class.php';
global $database, $jTips;
jTipsSpoofCheck();
//jTipsDebug($_REQUEST);
$game_ids = jTipsGetParam($_REQUEST, 'game_id', array());
//jTipsDebug($game_ids);
foreach ($game_ids as $index => $gid) {
$jTip = new jTip($database);
if (!empty($_REQUEST['id'][$index])) {
$jTip->load($_REQUEST['id'][$index]);
}
$game_index = "g{$gid}";
$jTip->tip_id = jTipsGetParam($_REQUEST[$game_index], 'tip_id');
$jTip->home_score = jTipsGetParam($_REQUEST[$game_index], 'home_score');
$jTip->away_score = jTipsGetParam($_REQUEST[$game_index], 'away_score');
$jTip->margin = jTipsGetParam($_REQUEST[$game_index], 'margin');
$jTip->bonus_id = jTipsGetParam($_REQUEST[$game_index], 'bonus_id');
$jTip->game_id = $gid;
$jTip->user_id = jTipsGetParam($_REQUEST, 'user_id');
if (!empty($jTip->user_id)) {
jTipsLogger::_log("ADMIN: saving tips. Tip_id = " . $jTip->tip_id);
$jTip->save();
}
if (!$jRound->id or $jRound->getStatus() !== false) {
// trying to post to an invalid round or round in progress
jTipsRedirect('index.php?option=com_jtips&Itemid=' . $Itemid, $jLang['_COM_CANNOT_POST_CLOSED']);
exit;
}
$jSeason = new jSeason($database);
$jSeason->load($jRound->season_id);
$jGame = new jGame($database);
$jGameParams = array('round_id' => $jRound->id);
$jGames = forceArray($jGame->loadByParams($jGameParams));
$myTips = array();
$isUpdate = null;
foreach ($jGames as $jGame) {
$game_id = 'game' . $jGame->id;
jTipsLogger::_log('saving tips for game ' . $jGame->id);
$jTip = new jTip($database);
$jTipParams = array('user_id' => $jTipsCurrentUser->id, 'game_id' => $jGame->id);
$jTip->loadByParams($jTipParams);
if ($jTip->exists() === false || empty($jTip->user_id) || empty($jTip->game_id)) {
$jTip->user_id = $jTipsCurrentUser->id;
$jTip->game_id = $jGame->id;
if (is_null($isUpdate)) {
$isUpdate = false;
}
} else {
// we are updating or adding to existing tips
if (is_null($isUpdate)) {
$isUpdate = true;
}
}
//Set the team tipped
function destroy($id = false)
{
global $database;
if ($id == false) {
$id = $this->id;
}
jTipsLogger::_log("Delete " . $this->_tbl . " record with id = '{$id}'");
//delete all games and tips where this team was involved
//first, the games
$query = "SELECT id FROM #__jtips_games WHERE home_id = " . $database->Quote($id) . " OR away_id = " . $database->Quote($id);
jTipsLogger::_log('loading games to delete');
$database->setQuery($query);
$ids = $database->loadResultArray();
if (!empty($ids)) {
$jGame = new jGame($database);
foreach ($ids as $id) {
$jGame->destroy($id);
}
}
//now the tips
$query = "SELECT id FROM #__jtips_tips WHERE game_id IN ('" . implode("', '", $ids) . "')";
jTipsLogger::_log('loading tips to delete');
$database->setQuery($query);
$ids = $database->loadResultArray();
if (!empty($ids)) {
$jTip = new jTip($database);
foreach ($ids as $id) {
$jTip->destroy($id);
}
}
return $this->delete($id);
}
function display($hideColumns = array(), $showThisRound = true)
{
global $database, $jTips, $jLang, $mosConfig_live_site, $mainframe, $jTipsCurrentUser, $Itemid;
if (empty($this->jTipsUser->id)) {
echo "";
return;
}
?>
<style type="text/css">
@import url(<?php
echo $mosConfig_live_site;
?>
/templates/<?php
echo jTipsGetTemplateName();
?>
/css/template.css);
@import url(<?php
echo $mosConfig_live_site;
?>
/components/com_jtips/css/jtips-popup.css);
</style>
<script type='text/javascript' src='<?php
echo $mosConfig_live_site;
?>
/components/com_jtips/js/mootools.js'></script>
<script type='text/javascript' src='<?php
echo $mosConfig_live_site;
?>
/components/com_jtips/js/Popup.js'></script>
<?php
$width = $jTips['ShowTipsWidth'] - 40;
if ($jTips['ShowTipsPadding']) {
?>
<div style="padding-top:10px;padding-left:10px;padding-right:10px;padding-bottom:10px;width:<?php
echo $width;
?>
px;text-align:center;">
<?php
}
?>
<h2 style='text-align:center;'><?php
echo $this->jSeason->name;
?>
<?php
echo $jLang['_COM_SHOWTIPS_ROUND'];
?>
<?php
echo $this->jRound->round;
?>
</h2>
<?php
if ($jTips['SocialIntegration'] and $showThisRound) {
if ($jTips['SocialIntegration'] == 'cb') {
$imgSrc = getCommunityBuilderAvatar($this->jTipsUser->user_id);
$link = jTipsRoute("index.php?option=com_comprofiler&task=userProfile&user={$this->jTipsUser->user_id}");
} else {
$imgSrc = getJomSocialAvatar($this->jTipsUser->user_id);
$link = getJomSocialProfileLink($this->jTipsUser->user_id);
}
?>
<div style="text-align:center;">
<a href="javascript:void(0);" onClick="parent.location='<?php
echo $link;
?>
';" title='View Profile' id='userLadderLink_<?php
echo $this->jTipsUser->id;
?>
'>
<img src="<?php
echo $imgSrc;
?>
" border="0" alt="" />
</a>
</div>
<?php
}
if ($this->stats) {
$this->showStats();
}
//BUG 189 - Which order should the tips panel be shown in
if ($this->jSeason->tips_layout == 'away') {
$left = 'away';
$right = 'home';
} else {
$left = 'home';
$right = 'away';
}
?>
<table align='center' width='100%' border='0' cellspacing='0' style="padding-top:25px;">
<thead>
<tr class="sectiontableheader">
<?php
if (!in_array($left, $hideColumns)) {
?>
<th class="sectiontableheader TB_th"><?php
echo $jLang['_COM_GAME_' . strtoupper($left)];
?>
</th><?php
}
if (!in_array($right, $hideColumns)) {
?>
<th class="sectiontableheader TB_th"><?php
echo $jLang['_COM_GAME_' . strtoupper($right)];
?>
</th><?php
}
if (!in_array('tipped', $hideColumns)) {
?>
<th class="sectiontableheader TB_th"><?php
echo $jLang['_COM_DASH_TIPPED'];
?>
</th><?php
}
if (!in_array('result', $hideColumns)) {
?>
<th class="sectiontableheader TB_th"><?php
echo $jLang['_COM_TIPS_RESULT'];
?>
</th><?php
}
if (!in_array('more', $hideColumns)) {
?>
<th class="sectiontableheader TB_th"><?php
echo $jLang['_COM_TIPS_MORE'];
?>
</th><?php
}
?>
</tr>
</thead>
<tbody>
<?php
$rowIndex = 0;
$i = 1;
$hasTipped = $this->jTipsUser->hasTipped($this->jRound->id);
$byeTeams = array();
// Might want to list the byes somewhere later
foreach ($this->jGames as $jGame) {
$leftTeam = new jTeam($database);
$left_id = $left . '_id';
//$leftTeam->load($jGame->$left_id);
$rightTeam = new jTeam($database);
$right_id = $right . '_id';
//$rightTeam->load($jGame->$right_id);
// Skip games with byes
$leftLoaded = $rightLoaded = false;
if ($jGame->{$left_id}) {
$leftTeam->load($jGame->{$left_id});
$leftLoaded = true;
}
if ($jGame->{$right_id}) {
$rightTeam->load($jGame->{$right_id});
$rightLoaded = true;
}
if (!$leftLoaded and $rightLoaded) {
$byeTeams[] = $rightTeam;
}
if ($leftLoaded and !$rightLoaded) {
$byeTeams[] = $leftTeam;
}
if (!$leftLoaded or !$rightLoaded) {
continue;
}
$jTip = new jTip($database);
$jTipParams = array('user_id' => $this->jTipsUser->id, 'game_id' => $jGame->id);
$jTip->loadByParams($jTipParams);
$overlib_text = "";
if ($jTip->tip_id == $leftTeam->id) {
$tipName = $leftTeam->getName();
$tip = $leftTeam->getDisplayLogoName();
$nonName = $rightTeam->getName();
} else {
if ($jTip->tip_id == $rightTeam->id) {
$tipName = $rightTeam->getName();
$tip = $rightTeam->getDisplayLogoName();
$nonName = $leftTeam->getName();
} else {
if ($jTip->tip_id == -1) {
$tip = $jLang['_COM_GAME_DRAW'];
$tipName = $leftTeam->getName();
$nonName = $rightTeam->getName();
} else {
$tip = $jLang['_ADMIN_CONF_NONE'];
}
}
}
if ($jGame->winner_id == $jTip->tip_id) {
$result = "<img src='" . $mosConfig_live_site . "/administrator/images/tick.png' alt='Y' border='0' align='middle' />";
} else {
$result = "<img src='" . $mosConfig_live_site . "/administrator/images/publish_x.png' alt='N' border='0' align='middle' />";
}
$onClick = "onClick='toggleMore(" . $jGame->id . ", this)'";
$more = "<img src='{$mosConfig_live_site}/components/com_jtips/images/show.gif' alt='more' border='0' {$onClick} style='cursor:pointer;' />";
$rowIndex++;
?>
<tr class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" valign='middle'>
<?php
if (!in_array($left, $hideColumns)) {
if ($jGame->winner_id == $leftTeam->id) {
$style = "style='font-weight:bold;'";
} else {
if ($jGame->winner_id == -1) {
$style = "style='font-style:italic;'";
} else {
$style = '';
}
}
?>
<td class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" align="left" <?php
echo $style;
?>
><?php
echo $leftTeam->getDisplayLogoName();
?>
</td><?php
}
if (!in_array($right, $hideColumns)) {
if ($jGame->winner_id == $rightTeam->id) {
$style = "style='font-weight:bold;'";
} else {
if ($jGame->winner_id == -1) {
$style = "style='font-style:italic;'";
} else {
$style = '';
}
}
?>
<td class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" align="left" <?php
echo $style;
?>
><?php
echo $rightTeam->getDisplayLogoName();
?>
</td><?php
}
if (!in_array('tipped', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" align="left"><?php
echo $tip;
?>
</td><?php
}
if (!in_array('result', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" style='text-align:center;'><?php
echo $result;
?>
</td><?php
}
if (!in_array('more', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $i % 2 + 1;
?>
" style='text-align:center;'><?php
echo $more;
?>
</td><?php
}
?>
</tr>
<?php
/*
* Process the in-depth game analysis
*/
$left_score_field = $left . '_score';
$right_score_field = $right . '_score';
if ($jGame->winner_id == $leftTeam->id) {
$winnerName = $leftTeam->getDisplayLogoName();
} else {
if ($jGame->winner_id == $rightTeam->id) {
$winnerName = $rightTeam->getDisplayLogoName();
} else {
if ($jGame->winner_id == -1) {
$winnerName = $jLang['_COM_GAME_DRAW'];
} else {
$winnerName = '';
}
}
}
$gameTotal = 0;
$tipWidth = 30;
if (in_array('actual', $hideColumns)) {
$tipWidth += 30;
}
if (in_array('awarded', $hideColumns)) {
$tipWidth += 10;
}
?>
<tr>
<td colspan="50" id="moreInfo<?php
echo $jGame->id;
?>
" style="display:none;">
<table width="100%" cellspacing="0">
<thead>
<tr class="sectiontableheader">
<th class="sectiontableheader" width="30%"> </th>
<th class="sectiontableheader" width="<?php
echo $tipWidth;
?>
%"><?php
echo $jLang['_COM_SHOWTIPS_PREDICTED'];
?>
</th>
<?php
if (!in_array('actual', $hideColumns)) {
?>
<th class="sectiontableheader" width="30%"><?php
echo $jLang['_COM_SHOWTIPS_ACTUAL'];
?>
</th>
<?php
}
if (!in_array('awarded', $hideColumns)) {
?>
<th class="sectiontableheader" width="10%"><?php
echo $jLang['_COM_SHOWTIPS_AWARDED'];
?>
</th>
<?php
}
?>
</tr>
</thead>
<tbody>
<tr class="sectiontableentry1">
<th class="sectiontableentry1"><?php
echo $jLang['_COM_DASH_TIPPED'];
?>
</th>
<td class="sectiontableentry1" align="left"><?php
echo $tip;
?>
</td>
<?php
if (!in_array('actual', $hideColumns)) {
?>
<td class="sectiontableentry1" align="left"><?php
echo $winnerName;
?>
</td>
<?php
}
if (!in_array('awarded', $hideColumns)) {
?>
<td class="sectiontableentry1" style="text-align:right;">
<?php
if ($hasTipped) {
if ($jGame->winner_id == $jTip->tip_id) {
// BUG 379 - Incorrect value displayed when draw correctly picked
if ($jGame->winner_id == -1) {
echo $this->jSeason->user_draw;
$gameTotal += $this->jSeason->user_draw;
} else {
echo $this->jSeason->user_correct;
$gameTotal += $this->jSeason->user_correct;
}
} else {
echo '0';
}
} else {
//what were the default points here?
if ($this->jSeason->user_none >= 0) {
echo $this->jSeason->user_none;
$gameTotal += $this->jSeason->user_none;
} else {
if ($this->jSeason->user_none == -1) {
//holy crap! you got the lowest score equivalence!
echo $jLang['_ADMIN_CONF_ACT_NA'];
} else {
if ($this->jSeason->user_none == -2) {
//you got all the away teams
if ($jGame->winner_id == $jGame->away_id) {
echo $this->jSeason->user_correct;
$gameTotal += $this->jSeason->user_correct;
} else {
echo '0';
}
}
}
}
}
?>
</td>
<?php
}
?>
</tr>
<?php
$subIndex = 1;
if ($jGame->has_score) {
?>
<tr class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
">
<th class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jLang['_COM_DASH_POINTS'];
?>
</th>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jTip->{$left_score_field} + 0;
?>
- <?php
echo $jTip->{$right_score_field} + 0;
?>
</td>
<?php
if (!in_array('actual', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jGame->{$left_score_field};
?>
- <?php
echo $jGame->{$right_score_field};
?>
</td>
<?php
}
if (!in_array('awarded', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
" style="text-align:right;">
<?php
if ($jTip->{$left_score_field} == $jGame->{$left_score_field} and $jTip->{$right_score_field} == $jGame->{$right_score_field}) {
echo $this->jSeason->user_pick_score;
$gameTotal += $this->jSeason->user_pick_score;
} else {
echo '0';
}
?>
</td>
<?php
}
?>
</tr>
<?php
$subIndex++;
}
if ($jGame->has_margin) {
?>
<tr class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
">
<th class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jLang['_COM_TIPS_MARGIN'];
?>
</th>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jTip->margin + 0;
?>
</td>
<?php
if (!in_array('actual', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo abs($jGame->{$left_score_field} - $jGame->{$right_score_field});
?>
</td>
<?php
}
if (!in_array('awarded', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
" style="text-align:right;">
<?php
if ($jTip->margin == abs($jGame->{$left_score_field} - $jGame->{$right_score_field})) {
echo $this->jSeason->user_pick_margin;
$gameTotal += $this->jSeason->user_pick_margin;
} else {
echo '0';
}
?>
</td>
<?php
}
?>
</tr>
<?php
$subIndex++;
}
if ($jGame->has_bonus) {
if ($jGame->bonus_id == $leftTeam->id) {
$bonusTeam = $leftTeam->getDisplayLogoName();
} else {
if ($jGame->bonus_id == $rightTeam->id) {
$bonusTeam = $rightTeam->getDisplayLogoName();
} else {
if ($jGame->bonus_id == -2) {
$bonusTeam = 'Both Teams';
} else {
$bonusTeam = "";
}
}
}
if ($jTip->bonus_id == $leftTeam->id) {
$bonusTip = $leftTeam->getDisplayLogoName();
} else {
if ($jTip->bonus_id == $rightTeam->id) {
$bonusTip = $rightTeam->getDisplayLogoName();
} else {
if ($jTip->bonus_id == -2) {
$bonusTip = 'Both Teams';
} else {
$bonusTip = $jLang['_ADMIN_CONF_NONE'];
}
}
}
?>
<tr class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
">
<th class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $jLang['_COM_SHOWTIPS_BONUS_TEAM'];
?>
</th>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
" align="left"><?php
echo $bonusTip;
?>
</td>
<?php
if (!in_array('actual', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
"><?php
echo $bonusTeam;
?>
</td>
<?php
}
if (!in_array('awarded', $hideColumns)) {
?>
<td class="sectiontableentry<?php
echo $subIndex % 2 + 1;
?>
" style="text-align:right;">
<?php
if ($jGame->bonus_id == $jTip->bonus_id) {
echo $this->jSeason->user_pick_bonus;
$gameTotal += $this->jSeason->user_pick_bonus;
} else {
echo '0';
}
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
<?php
if (!in_array('awarded', $hideColumns)) {
?>
<tfoot>
<tr class="sectiontableheader">
<th class="sectiontableheader" colspan="3"><?php
echo $jLang['_COM_SHOWTIPS_TOTAL'];
?>
</th>
<th class="sectiontableheader" style="text-align:right;"><?php
echo $gameTotal;
?>
</th>
</tr>
</tfoot>
<?php
}
?>
</table>
</td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
<?php
/*
* Do we have a comment to show
*/
$jComment = new jComment($database);
$jCommentParams = array('user_id' => $this->jTipsUser->id, 'round_id' => $this->jRound->id);
$jComment->loadByParams($jCommentParams);
if (isset($jComment->comment) && !empty($jComment->comment)) {
?>
<hr />
<p align="center"><?php
echo jTipsStripslashes($jComment->comment);
?>
</p>
<?php
}
/*
* Show the Peek into Next Round link be shown and parsed
*/
if ($jTips['EnableShowTips'] == 1 and $showThisRound) {
//getCurrentUser
$current_round_id = $this->jSeason->getCurrentRound();
$showFuture = false;
if (isset($jTipsCurrentUser->id) and !empty($jTipsCurrentUser->id)) {
if ($jTips['ShowTipsAccess'] == 'any' or $jTips['ShowTipsAccess'] == 'processed' and $jTipsCurrentUser->hasTipped($current_round_id) or $jTips['ShowTipsAccess'] == 'inprogress' and $this->jRound->getStatus() !== false) {
$showFuture = true;
}
} else {
if ($jTips['ShowTipsAccess'] == 'any') {
$showFuture = true;
}
}
if ($current_round_id != $this->jRound->id and $current_round_id and $showFuture) {
$hide = array('result', 'actual', 'awarded');
$colsToHide = json_encode($hide);
$data = "&season={$this->jSeason->id}&hide=" . rawurlencode($colsToHide);
if ($Itemid) {
$data .= "&Itemid={$Itemid}";
}
if (isJoomla15()) {
?>
<p align="center"><a href="<?php
echo jTipsRoute("index2.php?option=com_jtips&view=CompetitionLadder&menu=0&action=ShowTips&uid=" . $this->jTipsUser->id . "&rid=" . $current_round_id . $data);
?>
"><?php
echo $jLang['_POPUP_TIPS_PEEK'];
?>
</a></p>
<?php
} else {
?>
<p align="center"><a href="javascript:loadTipsPopup(<?php
echo $this->jTipsUser->id;
?>
, <?php
echo $current_round_id;
?>
, $('mb_caption'), '<?php
echo $data;
?>
');"><?php
echo $jLang['_POPUP_TIPS_PEEK'];
?>
</a></p>
<?php
}
}
}
if ($jTips['ShowTipsPadding']) {
echo "</div>";
}
}
function process()
{
global $database, $jTips, $mosConfig_absolute_path;
$this->clearHistory();
$params = array('round_id' => $this->id);
$jSeason = new jSeason($database);
$jSeason->load($this->season_id);
$jGame = new jGame($database);
$jGames = forceArray($jGame->loadByParams($params));
$params = array('season_id' => $this->season_id);
$jTipsUser = new jTipsUser($database);
$jTipsUsers = forceArray($jTipsUser->loadByParams($params));
$noTips = $scores = $worst_precision = array();
$played = count($jGames);
foreach ($jTipsUsers as $jTipsUser) {
jTipsLogger::_log("Processing scores for user " . $jTipsUser->id);
$score = $matching = $precision = $allAwayScore = 0;
if ($jTipsUser->hasTipped($this->id)) {
jTipsLogger::_log($jTipsUser->id . " has tipped in round " . $this->id);
foreach ($jGames as $jGame) {
jTipsLogger::_log("Processing game " . $jGame->id);
$params = array('user_id' => $jTipsUser->id, 'game_id' => $jGame->id);
$jTip = new jTip($database);
$jTip->loadByParams($params);
// make sure this is not a bye game
if (!$jGame->home_id or !$jGame->away_id or !$jGame->winner_id) {
jTipsLogger::_log('attempting to process tips on a bye game, skipping', 'INFO');
continue;
}
/*
* Feature Request 101 - Team Starts
* Determine the winner when we take the starts into account
* We only care about the starts for picking the winner/draw
* For picking the margins and scores, use the actual winner
*/
if ($jSeason->team_starts) {
jTipsLogger::_log('processing team starts');
$homeScore = $awayScore = 0;
$homeScore = $jGame->home_score + ($jGame->home_start + 0);
$awayScore = $jGame->away_score + ($jGame->away_start + 0);
if ($homeScore > $awayScore) {
$winnerID = $jGame->home_id;
} else {
if ($homeScore < $awayScore) {
$winnerID = $jGame->away_id;
} else {
if ($homeScore == $awayScore) {
$winnerID = -1;
}
}
}
jTipsLogger::_log('feature 101: With starts, the winner is ' . $winnerID . ', otherwise the winner is ' . $jGame->winner_id . " HOME {$homeScore} v AWAY {$awayScore}");
} else {
$winnerID = $jGame->winner_id;
}
if ($jTip->tip_id == $winnerID) {
//User tipped right!
jTipsLogger::_log("CORRECT TIP by " . $jTipsUser->id . " in round_id " . $this->id . " in game_id " . $jGame->id);
//BUG 248 - Add ToughScore if enabled
if ($jSeason->tough_score and $jGame->tough_score) {
$score += $jGame->tough_score;
}
if ($winnerID == -1) {
$score += isset($jSeason->user_draw) ? $jSeason->user_draw : 0;
jTipsLogger::_log("Draw correctly picked!");
} else {
$score += isset($jSeason->user_correct) ? $jSeason->user_correct : 0;
}
$matching++;
}
if ($winnerID == $jGame->away_id) {
$allAwayScore += $jSeason->user_correct;
}
//Check for correct margins and handle precision score gathering
if ($jSeason->pick_margin == 1 and $jGame->has_margin == 1) {
$margin = abs($jGame->home_score - $jGame->away_score);
if ($jTip->margin == $margin) {
$score += isset($jSeason->user_pick_margin) ? $jSeason->user_pick_margin : 0;
jTipsLogger::_log("correct margin picked!");
}
if ($jSeason->precision_score == 1) {
if ($jGame->winner_id == $jTip->tip_id) {
$margin_offset = abs($margin - $jTip->margin);
} else {
$margin_offset = abs($margin + $jTip->margin);
}
if (isset($worst_precision[$jGame->id]) && $margin_offset > $worst_precision[$jGame->id] || empty($worst_precision[$jGame->id])) {
$worst_precision[$jGame->id] = $margin_offset;
}
$precision += $margin_offset;
jTipsLogger::_log("PICK_MARGIN: Adding {$margin_offset} to precision of {$precision}");
}
}
//Check for correct scores and handle precision score gathering
if ($jSeason->pick_score == 1 and $jGame->has_score == 1) {
$margin = abs($jGame->home_score - $jGame->away_score);
if ($jTip->home_score == $jGame->home_score and $jTip->away_score == $jGame->away_score) {
$score += isset($jSeason->user_pick_score) ? $jSeason->user_pick_score : 0;
jTipsLogger::_log("Correct scores picked!");
}
if ($jSeason->precision_score == 1) {
$pickedScoreMargin = abs($jTip->home_score - $jTips->away_score);
if ($jGame->winner_id == $jTip->tip_id) {
$score_offset = abs($margin - $pickedScoreMargin);
} else {
$score_offset = abs($margin + $pickedScoreMargin);
}
if (isset($worst_precision[$jGame->id]) and $score_offset > $worst_precision[$jGame->id] or empty($worst_precision[$jGame->id])) {
$worst_precision[$jGame->id] = $score_offset;
}
$precision += $score_offset;
jTipsLogger::_log("PICK_SCORE: Adding {$score_offset} to precision of {$precision}");
jTipsLogger::_log("PREC DEBUG: {$jTipsUser->id}-{$jTipsUser->user_id} Picked Margin: {$pickedScoreMargin}. Actual Margin: {$margin}. Applied Precision: {$score_offset}. Running Precision: {$precision}", 'INFO');
}
}
//Check for a bonus team selection
if ($jSeason->pick_bonus >= 1 and $jGame->has_bonus == 1) {
if ($jTip->bonus_id == $jGame->bonus_id && $jGame->bonus_id != -1) {
$score += isset($jSeason->user_pick_bonus) ? $jSeason->user_pick_bonus : 0;
}
}
}
//was a perfect round picked?
if ($matching == $played) {
$score += isset($jSeason->user_bonus) ? $jSeason->user_bonus : 0;
}
//did the user use their 'doubleup'
if ($jTipsUser->doubleup == $this->id and $jTips['DoubleUp'] == 1) {
$score = $score * 2;
}
$scores[] = $score;
//Save the data to the history object
$jHistory = new jHistory($database);
$jHistory->user_id = $jTipsUser->id;
$jHistory->round_id = $this->id;
jTipsLogger::_log("Score for user_id " . $jTipsUser->id . " in round_id " . $this->id . " is {$score}");
$jHistory->points = $score;
//Update rank after all users have been saved
$jHistory->outof = count($jTipsUsers);
//$jHistory->comment = $jTipsUser->comment;
if ($jSeason->precision_score == 1) {
jTipsLogger::_log("setting precision to {$precision} for user_id " . $jTipsUser->id . " in round_id " . $this->id);
$jHistory->precision = $precision;
} else {
$jHistory->precision = 0;
}
if ($jHistory->save() !== false) {
$results[] = 1;
} else {
jTipsLogger::_log("Error saving history: " . $jHistory->_error);
$results[] = 0;
}
//remove the current comment
$jTipsUser->comment = null;
$jTipsUser->save();
// Check if the AlphaUserPoints config option is set
if (isJoomla15()) {
$api_AUP = JPATH_SITE . DS . 'components' . DS . 'com_alphauserpoints' . DS . 'helper.php';
} else {
$api_AUP = $mosConfig_absolute_path . 'components/com_alphauserpoints/helper.php';
}
if (!$this->scored and $jTips['AlphaUserPoints'] and jTipsFileExists($api_AUP)) {
require_once $api_AUP;
jTipsLogger::_log('sending ' . $score . ' points for user ' . $jTipsUser->user_id, 'INFO');
$refID = AlphaUserPointsHelper::getAnyUserReferreID($jTipsUser->user_id);
AlphaUserPointsHelper::newpoints('plgaup_jtips_total_points', $refID, '', '', $score);
}
if (!$this->scored and $jTips['JomSocialActivities'] and $jTips['JomSocialUserResults']) {
global $mosConfig_absolute_path;
require_once $mosConfig_absolute_path . '/administrator/components/com_jtips/utils/jTipsJomSocial.php';
jTipsJomSocial::writeRoundResult($jSeason, $this, $jTipsUser->user_id, $score);
}
} else {
$noTips[] = $jTipsUser;
}
}
if (count($noTips) > 0) {
/////////////////////////////////////////////////
// Feature Request 71
// Allow users that did not to be assigned
// all the away teams
//
/*if ($jSeason->user_none != -1) {
$thisRound = $jSeason->user_none;
} else if (is_array($scores) && count($scores) > 0) {
$thisRound = min($scores);
} else {
$thisRound = 0;
}*/
if ($jSeason->user_none == -2) {
//handle all away teams
$thisRound = $allAwayScore;
jTipsLogger::_log("didn't tip? You'll be stuck with the away teams. You got {$thisRound}");
} else {
if ($jSeason->user_none == -1) {
//handle lowest possible score
if (is_array($scores) and count($scores) > 0) {
$thisRound = min($scores);
jTipsLogger::_log("didn't tip? You'll be stuck with the lowest score this round, {$thisRound}");
} else {
$thisRound = 0;
jTipsLogger::_log("didn't tip? You'll be stuck {$thisRound}");
}
} else {
//handle allocated score
$thisRound = $jSeason->user_none;
jTipsLogger::_log("didn't tip? You're getting {$thisRound}");
}
}
//
// END Feature Request 71
////////////////////////////////////////////////////
foreach ($noTips as $jTipsUser) {
$jHistory = new jHistory($database);
$jHistory->user_id = $jTipsUser->id;
$jHistory->round_id = $this->id;
$jHistory->points = $thisRound;
$jHistory->precision = array_sum($worst_precision);
//$jHistory->outof = count($jTipsUsers);
//$jHistory->comment = $jTipsUser->comment;
if ($jHistory->save() !== false) {
$results[] = 1;
} else {
$results[] = 0;
}
$jTipsUser->save();
// Check if the AlphaUserPoints config option is set
if (isJoomla15()) {
$api_AUP = JPATH_SITE . DS . 'components' . DS . 'com_alphauserpoints' . DS . 'helper.php';
} else {
$api_AUP = $mosConfig_absolute_path . 'components/com_alphauserpoints/helper.php';
}
if (!$this->scored and $jTips['AlphaUserPoints'] and jTipsFileExists($api_AUP)) {
require_once $api_AUP;
jTipsLogger::_log('sending ' . $score . ' points for user ' . $jTipsUser->user_id, 'INFO');
$refID = AlphaUserPointsHelper::getAnyUserReferreID($jTipsUser->user_id);
AlphaUserPointsHelper::newpoints('plgaup_jtips_total_points', $refID, '', '', $thisRound);
}
if (!$this->scored and $jTips['JomSocialActivities']) {
global $mosConfig_absolute_path;
require_once $mosConfig_absolute_path . '/administrator/components/com_jtips/utils/jTipsJomSocial.php';
if ($jTips['JomSocialUserResults']) {
jTipsJomSocial::writeRoundResult($jSeason, $this, $jTipsUser->user_id, $score);
}
if ($jTips['JomSocialOnNoTips']) {
jTipsJomSocial::writeOnNoTips($jTipsUser->user_id, $jSeason, $this);
}
}
}
}
$jHistory = new jHistory($database);
$jHistory->setRanks($this->id, true);
if (!$this->scored and $jTips['JomSocialActivities']) {
// find out who won the round and write it to the JomSocial stream
$winners = $this->getRoundWinners();
jTipsJomSocial::writeRoundWinners($winners, $this, $jSeason);
}
$this->scored = 1;
$result = $this->save();
//if ($this->scored != 1) {
jTeam::updateLadder($this, $jSeason);
//}
//$this->scored = 1;
//return $this->save();
return $result;
}
if (!$jTipsMyTipsUser->id) {
?>
<p class="message">Join the <?php
echo $jSeason->name;
?>
competition!</p><?php
} else {
// valid user and season, get their tips
$round_id = $jSeason->getCurrentRound();
if (!$round_id) {
?>
<p class="message">Competition has ended.</p><?php
} else {
// valid everything, get the tips
$jTipParams = array('user_id' => $jTipsMyTipsUser->id, 'game_id' => array('type' => 'join', 'join_table' => '#__jtips_games', 'lhs_table' => '#__jtips_tips', 'lhs_key' => 'game_id', 'rhs_table' => '#__jtips_games', 'rhs_key' => 'id', 'supplement' => "AND #__jtips_games.round_id = '" . $round_id . "'"));
$jTip = new jTip($database);
$tips = $jTip->loadByParams($jTipParams);
if (empty($tips)) {
?>
<p class="message">Tips not yet submitted.</p><?php
} else {
?>
<table width="100%" border="0" cellspacing="0">
<thead>
<tr class="sectiontableheader">
<th class="sectiontableheader">Team</th>
<?php
if ($jSeason->pick_score) {
?>
<th class="sectiontableheader" align="center">Score</th><?php
}
<?php
/**
* Author: Jeremy Roberts
* Company: jTips
* Website: www.jtips.com.au
* Licence: Commercial. May not be copied, modified or redistributed
*/
defined('_JEXEC') or defined('_VALID_MOS') or die('Restricted access');
global $database, $jTips;
require_once 'components/com_jtips/classes/jtip.class.php';
$jTip = new jTip($database);
$limitstart = jTipsGetParam($_REQUEST, 'limitstart', 0);
$limit = jTipsGetParam($_REQUEST, 'limit', $jTips['NumMax']);
$params = array('join' => array('type' => 'join', 'join_table' => '#__jtips_games', 'lhs_table' => '#__jtips_tips', 'lhs_key' => 'game_id', 'rhs_table' => '#__jtips_games', 'rhs_key' => 'id'), 'group' => array('type' => 'group', 'by' => 'round_id`, `user_id'), 'order' => array('type' => 'order', 'by' => 'round_id', 'direction' => 'DESC'));
if ($user_id = jTipsGetParam($_REQUEST, 'user_id', false)) {
$params['user_id'] = $user_id;
}
$jTipArray = forceArray($jTip->loadByParams($params, $limit, $limitstart));
unset($params['order']);
$pageNav = new mosPageNav($jTip->getCount($params, true), $limitstart, $limit);
$header = array('', 'User', 'Round', 'Season');
$data = array();
$i = 0;
foreach ($jTipArray as $tip) {
$tip->fillInAdditionalFields();
$data[$tip->id] = array(makeListLink($tip->user->getName(), $i++), $tip->round_num, $tip->season->name);
}
$jSeason = new jSeason($database);
$jSeasons = forceArray($jSeason->loadByParams(array()));
$seasons = objectsToSelectList($jSeasons, 'name');
$jTipsUser = new jTipsUser($database);
$jTipsUsers = forceArray($jTipsUser->loadByParams($params));
$user_options = objectsToSelectList($jTipsUsers, 'getName', true);
asort($user_options);
$filters['Select User'] = makeSelectList($user_options, 'user_id', "id='user_id' onChange='this.form.submit();'", $user_id);
}
$tpl->selectLists = $filters;
$data = array();
//Now we have the preliminary options, get the set of games
if ($season_id and $round_id and $user_id) {
$params = array('round_id' => $round_id);
$jGame = new jGame($database);
$jGames = forceArray($jGame->loadByParams($params));
foreach ($jGames as $game) {
$params = array('game_id' => $game->id, 'user_id' => $user_id);
$jTip = new jTip($database);
$jTip->loadByParams($params);
//jTipsDebug($jTip);
$jHome = new jTeam($database);
$jAway = new jTeam($database);
$jHome->load($game->home_id);
$jAway->load($game->away_id);
$team_options = array('' => '--None--', $jHome->id => $jHome->getName(), $jAway->id => $jAway->getName());
$bonus_options = $team_options;
$bonus_options['-2'] = '--Both Teams--';
$data[$game->id] = array('home' => $jHome, 'away' => $jAway, 'home_score' => $jTip->home_score, 'away_score' => $jTip->away_score, 'margin' => $jTip->margin, 'bonus_id' => makeSelectList($team_options, 'g' . $game->id . '[bonus_id]', "", ''), 'home_tipped' => '', 'away_tipped' => '', 'draw_tipped' => '', 'id' => $jTip->id);
if ($jTip->tip_id == $jHome->id) {
$data[$game->id]['home_tipped'] = "checked";
} else {
if ($jTip->tip_id == $jAway->id) {
$data[$game->id]['away_tipped'] = "checked";
function getTips($user_id)
{
global $database;
$query = "SELECT id FROM #__jtips_tips WHERE game_id = " . $this->id . " AND user_id = " . $user_id . ";";
$database->setQuery($query);
$jTip = new jTip($database);
$jTip->load($database->loadResult());
return $jTip;
}