| |
|
|
|
|
select_row($sql_event);
$event_id = $res_event[0]['event_id'];
$cat_id = $res_event[0]['category'];
$num_event = $db->recordCount($sql_event);
$sqlcat = "select * from category where catid = '$cat_id'";
$rescat = $db->select_row($sqlcat);
if ($num_event > 0)
{
$tbl_bgcolor = 'bgcolor="'.$rescat[0]['catcolour'].'"';
$day_css = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor = '';
$day_css = "black_text";
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
$td_style = '';
}
$td_css = "#FFFFFF";
}
else if (($flag == true) && ($k<$num_days_last))
{
$k = $k + 1;
$str_day = $k;
$c_day = mktime(0,0,0,$mth_last,$str_day,$yr_last);
$sql_event = "SELECT * FROM `events` WHERE UNIX_TIMESTAMP(create_date) <= ".$c_day." and ".$c_day." <= UNIX_TIMESTAMP(until_date)";
$res_event = $db->select_row($sql_event);
$event_id = $res_event[0]['event_id'];
$cat_id = $res_event[0]['category'];
$num_event = $db->recordCount($sql_event);
$sqlcat = "select * from category where catid = '$cat_id'";
$rescat = $db->select_row($sqlcat);
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
if ($dd == $k)
{
$tbl_bgcolor = 'bgcolor="'.$rescat[0]['catcolour'].'"';
$day_css = "white_text";
}
else
{
$tbl_bgcolor = '';
$day_css = "black_text";
}
if ($num_event > 0)
{
$tbl_bgcolor = 'bgcolor="'.$rescat[0]['catcolour'].'"';
$day_css = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor = '';
$day_css = "black_text";
$td_style = '';
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
}
$td_css = "#FFFFFF";
}
else if ($k>=$num_days_last)
{
$num_event = 0;
$s = $s + 1;
$str_day = $s;
$td_css = "#b5b4a0";
$td_onclick = 'onclick="javascript: goto_other_days("'.$str_day.'","'.$mth.'","'.$yr.'")"';
$tbl_bgcolor = '';
$day_css = "white_text";
}
?>
|
=$num_days_last)
$i = $i + 3;
}//for ?>
|
|
|
|
|
select_row($sql_event2);
$event_id2 = $res_event2[0]['event_id'];
$cat_id2 = $res_event2[0]['category'];
$sqlcat2 = "select * from category where catid = '$cat_id2'";
$rescat2 = $db->select_row($sqlcat2);
$num_event2 = $db->recordCount($sql_event2);
if ($num_event2 > 0)
{
$tbl_bgcolor2 = 'bgcolor="'.$rescat2[0]['catcolour'].'"';
$day_css2 = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style2 = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor2 = '';
$day_css2 = "black_text";
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
$td_style2 = '';
}
$td_css2 = "#FFFFFF";
}
else if (($flag2 == true) && ($k2<$num_days_next))
{
$k2 = $k2 + 1;
$str_day2 = $k2;
$c_day2 = mktime(0,0,0,$mth_next,$str_day2,$yr_next);
$sql_event2 = "SELECT * FROM `events` WHERE UNIX_TIMESTAMP(create_date) <= ".$c_day2." and ".$c_day2." <= UNIX_TIMESTAMP(until_date)";
$res_event2 = $db->select_row($sql_event2);
$event_id2 = $res_event2[0]['event_id'];
$cat_id2 = $res_event2[0]['category'];
$num_event2 = $db->recordCount($sql_event2);
$sqlcat2 = "select * from category where catid = '$cat_id2'";
$rescat2 = $db->select_row($sqlcat2);
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
if ($dd == $k2)
{
$tbl_bgcolor2 = 'bgcolor="'.$rescat2[0]['catcolour'].'"';
$day_css2 = "white_text";
}
else
{
$tbl_bgcolor2 = '';
$day_css2 = "black_text";
}
if ($num_event2 > 0)
{
$tbl_bgcolor2 = 'bgcolor="'.$rescat2[0]['catcolour'].'"';
$day_css2 = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style2 = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor2 = '';
$day_css2 = "black_text";
$td_style2 = '';
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
}
$td_css2 = "#FFFFFF";
}
else if ($k2>=$num_days_next)
{
$num_event2 = 0;
$s2 = $s2 + 1;
$str_day2 = $s2;
$td_css2 = "#b5b4a0";
//$td_onclick2 = 'onclick="javascript: goto_other_days("'.$str_day2.'","'.$mth_next1.'","'.$yr_next1.'")"';
$tbl_bgcolor2 = '';
$day_css2 = "white_text";
}
?>
|
=$num_days_next)
$i = $i + 3;
}//for ?>
|
|
|
|
select_row($sql_event1);
$event_id1 = $res_event1[0]['event_id'];
$cat_id1 = $res_event1[0]['category'];
$num_event1 = $db->recordCount($sql_event1);
$sqlcat1 = "select * from category where catid = '$cat_id1'";
$rescat1 = $db->select_row($sqlcat1);
if ($num_event1 > 0)
{
$tbl_bgcolor1 = 'bgcolor="'.$rescat1[0]['catcolour'].'"';
$day_css1 = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style1 = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor1 = '';
$day_css1 = "black_text";
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
$td_style1 = '';
}
$td_css1 = "#FFFFFF";
}
else if (($flag1 == true) && ($k1<$num_days))
{
$k1 = $k1 + 1;
$str_day1 = $k1;
$c_day1 = mktime(0,0,0,$mth,$str_day1,$yr);
$sql_event1 = "SELECT * FROM `events` WHERE UNIX_TIMESTAMP(create_date) <= ".$c_day1." and ".$c_day1." <= UNIX_TIMESTAMP(until_date)";
$res_event1 = $db->select_row($sql_event1);
$event_id1 = $res_event1[0]['event_id'];
$cat_id1 = $res_event1[0]['category'];
$num_event1 = $db->recordCount($sql_event1);
$sqlcat1 = "select * from category where catid = '$cat_id1'";
$rescat1 = $db->select_row($sqlcat1);
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
//$td_style = 'style="cursor:hand"';
if ($dd == $k1)
{
$tbl_bgcolor1 = 'bgcolor="'.$rescat1[0]['catcolour'].'"';
$day_css1 = "white_text";
}
else
{
$tbl_bgcolor1 = '';
$day_css1 = "black_text";
}
if ($num_event1 > 0)
{
$tbl_bgcolor1 = 'bgcolor="'.$rescat1[0]['catcolour'].'"';
$day_css1 = "white_text";
//$td_onclick = 'onclick="javascript: calculateResult("'.$str_day.'")"';
$td_style1 = 'style="cursor:hand"';
}
else
{
$tbl_bgcolor1 = '';
$day_css1 = "black_text";
$td_style1 = '';
//$td_onclick = 'onclick="javascript: goto_days('.$str_day.')"';
}
$td_css1 = "#FFFFFF";
}
else if ($k1>=$num_days)
{
$num_event1 = 0;
$s1 = $s1 + 1;
$str_day1 = $s1;
$td_css1 = "#b5b4a0";
$td_onclick1 = 'onclick="javascript: goto_other_days("'.$str_day.'","'.$mth_next.'","'.$yr_next.'")"';
$tbl_bgcolor1 = '';
$day_css1 = "white_text";
}
?>
|
=$num_days)
$i = $i + 3;
}//for ?>
|
|
|
