Example #1
0
 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;
         }
     }
 }
Example #2
0
    /**
     * 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&amp;Itemid={$Itemid}&amp;view=Tips&amp;rid=" . $this->jRound->getPrev());
            ?>
'>&laquo; <?php 
            echo $jLang['_COM_PREV_ROUND'];
            ?>
</a>
			<?php 
        }
        echo "&nbsp;" . $jLang['_COM_DASH_ROUND'] . " " . $this->jRound->round . "&nbsp;";
        if ($this->jRound->getNext()) {
            ?>
			<a  style="font-size:smaller;" href='<?php 
            echo jTipsRoute("index.php?option=com_jtips&amp;Itemid={$Itemid}&amp;view=Tips&amp;rid=" . $this->jRound->getNext());
            ?>
'><?php 
            echo $jLang['_COM_NEXT_ROUND'];
            ?>
 &raquo;</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 "&nbsp;";
            }
            ?>
			</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 "&nbsp;" . $jLang['_COM_GAME_DRAW'] . "&nbsp;";
            } else {
                echo "&nbsp;";
            }
            ?>
</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;
            ?>
>&nbsp;</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>&nbsp;
						<?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 = "&nbsp;";
                        }
                    }
                    ?>
                        <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 {
                        ?>
&nbsp;<?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;'>&nbsp;<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;'>&nbsp;<?php 
                    echo $jLang['_COM_TEAM_VS'];
                    ?>
&nbsp;</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 {
                        ?>
&nbsp;<?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 = "&nbsp;";
                        }
                    }
                    ?>
                        <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 
                }
                ?>
						&nbsp;<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 {
                        ?>
&nbsp;<?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;'>&nbsp;</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 "&nbsp;";
                    }
                    ?>
</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};
                    ?>
&nbsp;</th>
						<?php 
                }
                ?>
<td><?php 
                if (!empty($jGame->description)) {
                    $description = nl2br(stripslashes($jGame->description));
                    echo jTipsToolTip($description, $jLang['_COM_GAME_ADDITIONAL_INFO']);
                } else {
                    echo "&nbsp;";
                }
                ?>
</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>&nbsp;<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 
        }
    }
Example #3
0
 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);
 }
Example #4
0
/**
 * 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();
    }
Example #5
0
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
Example #6
0
 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);
 }
Example #7
0
    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&amp;task=userProfile&amp;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%">&nbsp;</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;
            ?>
&nbsp;</td>
					<?php 
            if (!in_array('actual', $hideColumns)) {
                ?>
						<td class="sectiontableentry1" align="left"><?php 
                echo $winnerName;
                ?>
&nbsp;</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';
                                }
                            }
                        }
                    }
                }
                ?>
						&nbsp;</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;
                ?>
&nbsp;</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};
                    ?>
&nbsp;</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';
                    }
                    ?>
						&nbsp;</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;
                ?>
&nbsp;</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});
                    ?>
&nbsp;</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';
                    }
                    ?>
						&nbsp;</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;
                ?>
&nbsp;</td>
					<?php 
                if (!in_array('actual', $hideColumns)) {
                    ?>
						<td class="sectiontableentry<?php 
                    echo $subIndex % 2 + 1;
                    ?>
"><?php 
                    echo $bonusTeam;
                    ?>
&nbsp;</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';
                    }
                    ?>
						&nbsp;</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;
                ?>
&nbsp;</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>";
        }
    }
Example #8
0
 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;
 }
Example #9
0
    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 
                }
Example #10
0
<?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');
Example #11
0
    $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";
Example #12
0
 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;
 }