include_once "$com_base/skip_hit_analysis/skip_hit_analysis_com.php";
$highest_skips=get_highest_skips_for_pick($game_id,$number,$digit);
$unit_height=$full_height/$highest_skips;
$draw_stats=get_draw_stats($game_id);
$last_draw_date=$draw_stats[3];
$should_appear=ceil($draw_stats[0]/10);
$query="select count(game_id) from stats_skiphit where game_id='$game_id' and number=$number and digit='$digit' and highlighted_results like '%span%' and stats_type='REG' and skips>=0 order by draws";
$result=mysql_query($query) or die(mysql_error());
if(($row=mysql_fetch_array($result))!=NULL){
$actual_appear=$row[0];
mysql_free_result($result);
}else{
$actual_appear=0;
}
$average_lower_limit=floor($should_appear*0.94); // 6% lower than average
$average_upper_limit=ceil($should_appear*1.06); // 6% above than average
if($actual_appear<$average_lower_limit){
$performance_text="below average";
}elseif($actual_appear>$average_upper_limit){
$performance_text="above average";
}else{
$performance_text="close to average";
}
$query="select highlighted_results,skips,date_format(draw_date,'%a %b %d, %Y') from stats_skiphit where game_id='$game_id' and number=$number and digit='$digit' and stats_type='$ball_type' order by draw_date desc limit 1";
$result=mysql_query($query) or die(mysql_error());
if(($row=mysql_fetch_array($result))!=NULL){
if(!strstr($row[0], "span")){ // the number did not appear in the last draw
$last_skip=$row[1];
}else{ // the number appeared in the last draw
$last_skip=0;
$last_draw=$row[0];
$last_date=$row[2];
}
mysql_free_result($result);
}
if($last_skip>0){
$query="select highlighted_results,date_format(draw_date,'%a %b %d, %Y') from stats_skiphit where game_id='$game_id' and number=$number and digit='$digit' and stats_type='$ball_type' and highlighted_results like '%span%' order by draw_date desc limit 1";
$result=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_array($result);
$last_draw=$row[0];
$last_date=$row[1];
mysql_free_result($result);
}
$query="select skips from stats_skiphit where number=$number and digit='$digit' and game_id='$game_id' and stats_type='$ball_type' order by skips desc limit 1";
$result=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_array($result);
$longest_skips=$row[0];
mysql_free_result($result);
$query="select skips from stats_skiphit where number=$number and digit='$digit' and game_id='$game_id' and stats_type='$ball_type' and skips>=0 order by skips limit 1";
$result=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_array($result);
$shortest_skips=$row[0];
mysql_free_result($result);
$query="select count(*) from stats_skiphit where number=$number and digit='$digit' and game_id='$game_id' and stats_type='$ball_type' and skips=0";
$result=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_array($result);
$consecutive_wins=$row[0];
mysql_free_result($result);
$ball_color='white';
$num_inline=inline_num($number,'grey');
echo "
";
echo "
$number
\n";
echo "
Digit $digit";
echo "
";
echo "The chart below shows you the skip and hit patterns for number $num_inline on digit $digit, in $combined_game_name draws, from $draw_stats[1] to $draw_stats[2]. There were $draw_stats[0] draws during this period, and the chart is updated after each $game_name winning results are announced.
";
?>
Texas Pick 3 Day is a lottery game which randomly chooses 3 winning numbers from 3 different sets of numbers, in which each number set has 10 numbers from 0 to 9.
During the past from to , each number on each digit should appear times theoretically. The
number on digit 1 actually appeared times, which was performance.
The last hit of number on digit 1 was on (). It just appeared in the latest draw.
In the past draws from to , the longest time period number on digit 1 did not appear was draws. The shortest time period number on digit 1 did not appear was draws
(the number appeared in 2 consecutive draws).
Table './statelottery/stats_skiphit' is marked as crashed and last (automatic?) repair failed