function big_calendar_list_widget()
{
    require_once "frontend_functions.php";
    global $wpdb;
    $widget = isset($_GET['widget']) && (int) $_GET['widget'] ? (int) $_GET['widget'] : 0;
    $many_sp_calendar = isset($_GET['many_sp_calendar']) && is_numeric(esc_html($_GET['many_sp_calendar'])) ? esc_html($_GET['many_sp_calendar']) : 1;
    $calendar_id = isset($_GET['calendar']) ? (int) $_GET['calendar'] : '';
    $theme_id = isset($_GET['theme_id']) ? (int) $_GET['theme_id'] : 1;
    $date = isset($_GET['date']) && IsDate_inputed(esc_html($_GET['date'])) ? esc_html($_GET['date']) : '';
    $view_select = isset($_GET['select']) ? esc_html($_GET['select']) : 'month,';
    $path_sp_cal = isset($_GET['cur_page_url']) ? esc_html($_GET['cur_page_url']) : '';
    $site_url = get_option("home", get_site_url()) . '/wp-admin/admin-ajax.php';
    ///////////////////////////////////////////////////////////////////////////////////
    if (isset($_GET['cat_id'])) {
        $cat_id = $_GET['cat_id'];
    } else {
        $cat_id = "";
    }
    if (isset($_GET['cat_ids'])) {
        $cat_ids = $_GET['cat_ids'];
    } else {
        $cat_ids = "";
    }
    if ($cat_ids == '') {
        $cat_ids .= $cat_id . ',';
    } else {
        $cat_ids .= ',' . $cat_id . ',';
    }
    $cat_ids = substr($cat_ids, 0, -1);
    function getelementcountinarray($array, $element)
    {
        $t = 0;
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t++;
            }
        }
        return $t;
    }
    function getelementindexinarray($array, $element)
    {
        $t = '';
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t .= $i . ',';
            }
        }
        return $t;
    }
    $cat_ids_array = explode(',', $cat_ids);
    if ($cat_id != '') {
        if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
            $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
            $index_array = explode(',', $index_in_line);
            array_pop($index_array);
            for ($j = 0; $j < count($index_array); $j++) {
                unset($cat_ids_array[$index_array[$j]]);
            }
            $cat_ids = implode(',', $cat_ids_array);
        }
    } else {
        $cat_ids = substr($cat_ids, 0, -1);
    }
    ///////////////////////////////////////////////////////////////////////////////////////////////////////
    $theme = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . $wpdb->prefix . 'spidercalendar_widget_theme WHERE id=%d', $theme_id));
    $weekstart = $theme->week_start_day;
    $bg = '#' . str_replace('#', '', $theme->header_bgcolor);
    $bg_color_selected = '#' . str_replace('#', '', $theme->bg_color_selected);
    $color_arrow = '#' . str_replace('#', '', $theme->arrow_color);
    $evented_color = '#' . str_replace('#', '', $theme->text_color_this_month_evented);
    $evented_color_bg = '#' . str_replace('#', '', $theme->bg_color_this_month_evented);
    $sun_days = '#' . str_replace('#', '', $theme->text_color_sun_days);
    $text_color_other_months = '#' . str_replace('#', '', $theme->text_color_other_months);
    $text_color_this_month_unevented = '#' . str_replace('#', '', $theme->text_color_this_month_unevented);
    $text_color_month = '#' . str_replace('#', '', $theme->text_color_month);
    $color_week_days = '#' . str_replace('#', '', $theme->text_color_week_days);
    $text_color_selected = '#' . str_replace('#', '', $theme->text_color_selected);
    $border_day = '#' . str_replace('#', '', $theme->border_day);
    $calendar_width = $theme->width;
    $calendar_bg = '#' . str_replace('#', '', $theme->footer_bgcolor);
    $weekdays_bg_color = '#' . str_replace('#', '', $theme->weekdays_bg_color);
    $weekday_su_bg_color = '#' . str_replace('#', '', $theme->su_bg_color);
    $cell_border_color = '#' . str_replace('#', '', $theme->cell_border_color);
    $year_font_size = $theme->year_font_size;
    $year_font_color = '#' . str_replace('#', '', $theme->year_font_color);
    $year_tabs_bg_color = '#' . str_replace('#', '', $theme->year_tabs_bg_color);
    $font_year = $theme->font_year;
    $font_month = $theme->font_month;
    $font_day = $theme->font_day;
    $font_weekday = $theme->font_weekday;
    $show_cat = 1;
    $ev_title_color = '#' . str_replace('#', '', $theme->ev_title_color);
    $popup_width = $theme->popup_width;
    $popup_height = $theme->popup_height;
    $show_event_bgcolor = '#' . str_replace('#', '', $theme->show_event_bgcolor);
    __('January', 'sp_calendar');
    __('February', 'sp_calendar');
    __('March', 'sp_calendar');
    __('April', 'sp_calendar');
    __('May', 'sp_calendar');
    __('June', 'sp_calendar');
    __('July', 'sp_calendar');
    __('August', 'sp_calendar');
    __('September', 'sp_calendar');
    __('October', 'sp_calendar');
    __('November', 'sp_calendar');
    __('December', 'sp_calendar');
    if ($date != '') {
        $date_REFERER = $date;
    } else {
        $date_REFERER = date("Y-m");
        $date = date("Y") . '-' . php_Month_num(date("F")) . '-' . date("d");
    }
    $year_REFERER = substr($date_REFERER, 0, 4);
    $month_REFERER = Month_name(substr($date_REFERER, 5, 2));
    $day_REFERER = substr($date_REFERER, 8, 2);
    $year = substr($date, 0, 4);
    $month = Month_name(substr($date, 5, 2));
    $day = substr($date, 8, 2);
    $this_month = substr($year . '-' . add_0(Month_num($month)), 5, 2);
    $prev_month = add_0((int) $this_month - 1);
    $next_month = add_0((int) $this_month + 1);
    $cell_width = $calendar_width / 7;
    $cell_width = (int) $cell_width - 2;
    $view = 'bigcalendarlist_widget';
    $views = explode(',', $view_select);
    $defaultview = 'list';
    array_pop($views);
    $display = '';
    if (count($views) == 0) {
        $display = "display:none";
    }
    if (count($views) == 1 && $views[0] == $defaultview) {
        $display = "display:none";
    }
    ?>
  <style type='text/css'>
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 table {
      border-collapse: initial;
      border:0px;
	  margin: 0;
    }
	#TB_iframeContent{
		background-color: <?php 
    echo $show_event_bgcolor;
    ?>
;
	}
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 table td {
      padding: 0px;
      vertical-align: none;
      border-top:none;
      line-height: none;
      text-align: none;
    }
	#calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .arrow-left {
		width: 0px;
		height: 0px;
		border-top: 7px solid transparent;
		border-bottom: 7px solid transparent;
		border-right: 13px solid;
		margin: 0 auto;	
	}
	
	#calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .arrow-right {
		width: 0px;
		height: 0px;
		border-top: 7px solid transparent;
		border-bottom: 7px solid transparent;
		border-left: 13px solid;
		margin: 0 auto;
	}
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cell_body td {
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
;
      font-family: <?php 
    echo $font_day;
    ?>
;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 p, ol, ul, dl, address {
      margin-bottom: 0;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 td,
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 tr,
    #spiderCalendarTitlesList_<?php 
    echo $many_sp_calendar;
    ?>
 td,
    #spiderCalendarTitlesList_<?php 
    echo $many_sp_calendar;
    ?>
 tr {
       border:none;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:link,
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:visited {
      color: <?php 
    echo $color_arrow;
    ?>
;
      text-decoration: none;
      background: none;
      font-size: 16px;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:hover {
      color: <?php 
    echo $color_arrow;
    ?>
;
      text-decoration:none;
      background:none;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:link,
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:visited {
      text-decoration:underline;
      background:none;
      font-size:11px;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 a {
      font-weight: normal;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:hover {
      font-size:12px;
      text-decoration:none;
      background:none;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calyear_table {
      border-spacing:0;
      width:100%;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calmonth_table {	
      border-spacing: 0;
      vertical-align: middle;
      width: 100%;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calbg {
      background-color:<?php 
    echo $bg;
    ?>
 !important;
      text-align:center;
      vertical-align: middle;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_other_months {
      color:<?php 
    echo $text_color_other_months;
    ?>
;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_this_month_unevented {
      color:<?php 
    echo $text_color_this_month_unevented;
    ?>
;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calfont_year {
      font-size:24px;
      font-weight:bold;
      color:<?php 
    echo $year_font_color;
    ?>
;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calsun_days {
      color:<?php 
    echo $sun_days;
    ?>
;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .calborder_day {
      border: solid <?php 
    echo $border_day;
    ?>
 1px;
    }
    #TB_window {
      z-index: 10000;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .views {
      float: right;
      background-color: <?php 
    echo $calendar_bg;
    ?>
 !important;
      height: 25px;
      width: <?php 
    echo $calendar_width / 4 - 2;
    ?>
px;
      margin-left: 2px;
      text-align: center;
      cursor:pointer;
      position: relative;
      top: 3px;
      font-family: <?php 
    echo $font_month;
    ?>
;
	  font-size: 14px;
    }
    #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 table tr {
      background: transparent !important;
    }
	
#calendar_<?php 
    echo $many_sp_calendar;
    ?>
 .views_select ,
#calendar_<?php 
    echo $many_sp_calendar;
    ?>
 #views_select
{
width: 120px;
text-align: center;
cursor: pointer;
padding: 6px;
position: relative;
}


#drop_down_views
{
	list-style-type:none !important;
	position: absolute;
	top: 46px;
	left: -15px;
	display:none;
	z-index: 4545;
	
}

#drop_down_views >li
{
	border-bottom:1px solid #fff !important;
}


#views_tabs_select 
{
	display:none;
}
  </style>
  <div id="calendar_<?php 
    echo $many_sp_calendar;
    ?>
" style="width:<?php 
    echo $calendar_width;
    ?>
px;">
    <table cellpadding="0" cellspacing="0" style="border-spacing:0; width:<?php 
    echo $calendar_width;
    ?>
px; margin:0; padding:0;background-color:<?php 
    echo $calendar_bg;
    ?>
 !important">
      <tr style="background-color:#FFFFFF;">
        <td style="background-color:#FFFFFF;">
          <div id="views_tabs" style="width: 101%;margin-left: -2px;<?php 
    echo $display;
    ?>
">
            <div class="views" style="<?php 
    if (!in_array('day', $views) and $defaultview != 'day') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarday_widget') {
        echo 'background-color:' . $bg . ' !important;height:28px;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_day_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="line-height: 2;color:<?php 
    echo $text_color_month;
    ?>
;"><?php 
    echo __('Day', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('week', $views) and $defaultview != 'week') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarweek_widget') {
        echo 'background-color:' . $bg . ' !important;height:28px;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_week_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'months' => $prev_month . ',' . $this_month . ',' . $next_month, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="line-height: 2;color:<?php 
    echo $text_color_month;
    ?>
;"><?php 
    echo __('Week', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="margin-left: 3px;margin-right: 1px;<?php 
    if (!in_array('list', $views) and $defaultview != 'list') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarlist_widget') {
        echo 'background-color:' . $bg . ' !important;height:28px;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_list_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><span style="line-height: 2;color:<?php 
    echo $text_color_month;
    ?>
;"><?php 
    echo __('List', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('month', $views) and $defaultview != 'month') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarmonth_widget') {
        echo 'background-color:' . $bg . ' !important;height:28px;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_month_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="line-height: 2;color:<?php 
    echo $text_color_month;
    ?>
;"><?php 
    echo __('Month', 'sp_calendar');
    ?>
</span>
            </div>
          </div>
        </td>
      </tr>
      <tr>
        <td width="100%" style="padding:0; margin:0;">
          <form action="" method="get" style="background:none; margin:0; padding:0;">
            <table cellpadding="0" cellspacing="0" border="0" style="border-spacing:0; font-size:12px; margin:0; padding:0;" width="<?php 
    echo $calendar_width;
    ?>
">
              <tr height="28px" style="width:<?php 
    echo $calendar_width;
    ?>
px;">
                <td class="calbg" colspan="7" style="background-image:url('<?php 
    echo plugins_url('/images/Stver.png', __FILE__);
    ?>
');margin:0; padding:0;background-repeat: no-repeat;background-size: 100% 100%;" >
                  <?php 
    //MONTH TABLE
    ?>
                  <table cellpadding="0" cellspacing="0" border="0" align="center" class="calmonth_table"  style="width:100%; margin:0; padding:0">
                    <tr>
                      <td style="text-align:left; margin:0; padding:0; line-height:16px" class="cala_arrow" width="20%">
                        <a href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    if (Month_num($month) == 1) {
        $needed_date = $year - 1 . '-12';
    } else {
        $needed_date = $year . '-' . add_0(Month_num($month) - 1);
    }
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview . '_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><div class="arrow-left"></div>
                        </a>
                      </td>
                      <td width="60%" style="text-align:center; margin:0; padding:0; font-family:<?php 
    echo $font_month;
    ?>
">
                        <input type="hidden" name="month" readonly="" value="<?php 
    echo $month;
    ?>
"/>
                        <span style="font-size:<?php 
    echo $year_font_size;
    ?>
px;?>; color:<?php 
    echo $text_color_month;
    ?>
;"><?php 
    echo __($month, 'sp_calendar');
    ?>
</span>
                      </td>
                      <td style="text-align:right; margin:0; padding:0; line-height:16px"  class="cala_arrow" width="20%">
                        <a href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    if (Month_num($month) == 12) {
        $needed_date = $year + 1 . '-01';
    } else {
        $needed_date = $year . '-' . add_0(Month_num($month) + 1);
    }
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview . '_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><div class="arrow-right"></div>
                        </a>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
              
              <tr>
                <td colspan="7">
  <?php 
    $month_first_weekday = date("N", mktime(0, 0, 0, Month_num($month), 1, $year));
    if ($weekstart == "su") {
        $month_first_weekday++;
        if ($month_first_weekday == 8) {
            $month_first_weekday = 1;
        }
    }
    $month_days = date("t", mktime(0, 0, 0, Month_num($month), 1, $year));
    $last_month_days = date("t", mktime(0, 0, 0, Month_num($month) - 1, 1, $year));
    $weekday_i = $month_first_weekday;
    $last_month_days = $last_month_days - $weekday_i + 2;
    $percent = 1;
    $sum = $month_days - 8 + $month_first_weekday;
    if ($sum % 7 != 0) {
        $percent = $percent + 1;
    }
    $sum = $sum - $sum % 7;
    $percent = $percent + $sum / 7;
    $percent = 107 / $percent;
    $all_calendar_files = php_getdays(0, $calendar_id, $date, $theme_id, $widget);
    $categories = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercalendar_event_category WHERE published=1");
    $calendar = isset($_GET['calendar']) ? $_GET['calendar'] : '';
    $array_days = $all_calendar_files[0]['array_days'];
    $array_days1 = $all_calendar_files[0]['array_days1'];
    $title = $all_calendar_files[0]['title'];
    $ev_ids = $all_calendar_files[0]['ev_ids'];
    sort($array_days, SORT_NUMERIC);
    if (!$array_days) {
        echo '<table style="height:14px;border-spacing:0;border-spacing:0;width: 100%;background-color:#D6D4D5 !important;">
            <tr>
              <td style="padding-left:10px; font-size:12px;font-weight:bold;width:10px;text-align:center;background-color:' . $bg . ' !important;color:#949394;"></td>
              <td><p style="font-size:12px;color:' . $bg . '; border:none">&nbsp;' . __('There are no events for this month', 'sp_calendar') . '</p></td>
            </tr>
          </table>';
    }
    for ($i = 0; $i < count($array_days); $i++) {
        $week_day = date('D', mktime(0, 0, 0, Month_num($month), $array_days[$i], $year));
        if ($array_days[$i] <= $month_days) {
            echo '<table style="width:100%; border-spacing:0;">
            <tr>
              <td style="height:14px;font-size:12px; padding-left:10px;background-color:#D6D4D5 !important; color:#6E7276">
                <span style="padding-left:10px; font-size:12px;color:' . $color_week_days . '">' . week_convert($week_day) . '</span>
                <span style="font-size:12px;color:#949394;">(' . add_0($array_days[$i]) . ' ' . __($month, 'sp_calendar') . ')</span>
              </td>
            </tr>
            <tr>
              <td>';
            foreach ($title as $key => $value) {
                if ($key == $array_days[$i]) {
                    $ev_id = explode('<br>', $ev_ids[$key]);
                    array_pop($ev_id);
                    $ev_ids_inline = implode(',', $ev_id);
                    $ev_title = explode('</p>', $value);
                    array_pop($ev_title);
                    for ($j = 0; $j < count($ev_title); $j++) {
                        $queryy = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercalendar_event_category.color AS color FROM " . $wpdb->prefix . "spidercalendar_event  JOIN " . $wpdb->prefix . "spidercalendar_event_category\r\n\t       ON " . $wpdb->prefix . "spidercalendar_event.category=" . $wpdb->prefix . "spidercalendar_event_category.id WHERE " . $wpdb->prefix . "spidercalendar_event.calendar=%d AND \r\n\t       " . $wpdb->prefix . "spidercalendar_event.published='1' AND " . $wpdb->prefix . "spidercalendar_event_category.published='1' AND " . $wpdb->prefix . "spidercalendar_event.id=%d", $calendar, $ev_id[$j]);
                        $cat_color = $wpdb->get_row($queryy);
                        if (($j + 1) % 2 == 0) {
                            $color = $bg;
                            $table_color = $calendar_bg;
                        } else {
                            $color = $bg;
                            $table_color = $calendar_bg;
                        }
                        if (!isset($cat_color->color)) {
                            $cat_color = new stdClass();
                            $cat_color->color = $bg;
                        }
                        echo '<table class="last_table" style="overflow:hidden;height:14px;border-spacing:0;width: 100%;background-color:' . $table_color . '">
                  <tr>
                    <td style="font-size:14px;font-weight:bold;width:15px;text-align:center;background-color:#' . str_replace('#', '', $cat_color->color) . ' !important;color:' . $calendar_bg . '">' . ($j + 1) . '</td>
                    <td>
                      <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="text-decoration:none;font-size:13px;background:none;color:' . $ev_title_color . ';"
                        href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $array_days[$i], 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . $ev_title[$j] . '</b>
                      </a>
                    </td>
                  </tr>
                </table>';
                    }
                }
            }
            echo '</td></tr></table>';
        }
    }
    ?>
                </td>
              </tr>
              <tr style="height:<?php 
    echo $year_font_size + 2;
    ?>
px; font-family: <?php 
    echo $font_year;
    ?>
;">
                <td colspan="2" onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview . '_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year - 1 . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'cat_id' => '', 'cat_ids' => $cat_ids, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="cursor:pointer;font-size:<?php 
    echo $year_font_size;
    ?>
px;color:<?php 
    echo $year_font_color;
    ?>
;text-align: center;background-color:<?php 
    echo $year_tabs_bg_color;
    ?>
 !important">
                  <?php 
    echo $year - 1;
    ?>
                </td>
                <td colspan="3" style="font-size:<?php 
    echo $year_font_size + 2;
    ?>
px;color:<?php 
    echo $year_font_color;
    ?>
;text-align: center;border-right:1px solid <?php 
    echo $cell_border_color;
    ?>
;border-left:1px solid <?php 
    echo $cell_border_color;
    ?>
">
                  <?php 
    echo $year;
    ?>
                </td>
                <td colspan="2" onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview . '_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year + 1 . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'cat_id' => '', 'cat_ids' => $cat_ids, 'TB_iframe' => 1), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="cursor:pointer;font-size:<?php 
    echo $year_font_size;
    ?>
px;text-align: center;background-color:<?php 
    echo $year_tabs_bg_color;
    ?>
 !important;color:<?php 
    echo $year_font_color;
    ?>
">
                  <?php 
    echo $year + 1;
    ?>
                </td>
              </tr>
            </table>
            <input type="text" value="1" name="day" style="display:none" />
          </form>
        </td>
      </tr>
    </table>
  </div>
 <style>
 #calendar_<?php 
    echo $many_sp_calendar;
    ?>
 table{
	width: 100%;
   }
    .spider_categories_widget{
		display:inline-block;
		cursor:pointer;
	}
	
	.spider_categories_widget p{
		color: #fff;
		padding: 2px 10px !important;
		margin: 2px 0 !important;
		font-size: 13px;
	}
  </style>
  <?php 
    //reindex cat_ids_array
    $re_cat_ids_array = array_values($cat_ids_array);
    for ($i = 0; $i < count($re_cat_ids_array); $i++) {
        echo '
<style>
#cats_widget_' . $many_sp_calendar . ' #category' . $re_cat_ids_array[$i] . '
{
	text-decoration:underline;
	cursor:pointer;

}

</style>';
    }
    if ($cat_ids == '') {
        $cat_ids = '';
    }
    if ($show_cat) {
        echo '<ul id="cats_widget_' . $many_sp_calendar . '" style="list-style-type:none; margin-top: 10px;">';
        foreach ($categories as $category) {
            ?>

<li class="spider_categories_widget"><p id="category<?php 
            echo $category->id;
            ?>
" style="background-color:#<?php 
            echo str_replace('#', '', $category->color);
            ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
            echo $many_sp_calendar;
            ?>
', '<?php 
            echo add_query_arg(array('action' => 'spiderbigcalendar_list_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . add_0($day), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => $category->id, 'cat_ids' => $cat_ids, 'widget' => $widget, 'TB_iframe' => 1), $site_url);
            ?>
','<?php 
            echo $many_sp_calendar;
            ?>
','<?php 
            echo $widget;
            ?>
')"> <?php 
            echo $category->title;
            ?>
</p></li>


<?php 
        }
        if (!empty($categories)) {
            ?>
<li class="spider_categories_widget"><p class="categories2" id="category0" style="background-color:#<?php 
            echo str_replace('#', '', $bg);
            ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
            echo $many_sp_calendar;
            ?>
', '<?php 
            echo add_query_arg(array('action' => 'spiderbigcalendar_list_widget', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . add_0($day), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => '', 'widget' => $widget, 'TB_iframe' => 1), $site_url);
            ?>
','<?php 
            echo $many_sp_calendar;
            ?>
','<?php 
            echo $widget;
            ?>
')"><?php 
            echo __('All categories', 'sp_calendar');
            ?>
</p></li>
<?php 
            echo '</ul>';
        }
    }
    die;
}
Example #2
0
function getcategorycolor($ev_day, $ev_month, $ev_year, $i, $eventIDs)
{
    $db = JFactory::getDBO();
    $calendar_id = JRequest::getVar('calendar');
    $cat_id = JRequest::getVar('cat_id');
    $cat_ids = JRequest::getVar('cat_ids');
    if (isset($eventIDs[$i])) {
        $ev_ids = explode('<br>', $eventIDs[$i]);
        array_pop($ev_ids);
        $ev_ids_inline = implode(',', $ev_ids);
        if ($cat_ids == '') {
            $cat_ids .= $cat_id . ',';
        } else {
            $cat_ids .= ',' . $cat_id . ',';
        }
        $cat_ids = substr($cat_ids, 0, -1);
        $cat_ids_array = explode(',', $cat_ids);
        if ($cat_id != '') {
            if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
                $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
                $index_array = explode(',', $index_in_line);
                array_pop($index_array);
                for ($j = 0; $j < count($index_array); $j++) {
                    unset($cat_ids_array[$index_array[$j]]);
                }
                $cat_ids = implode(',', $cat_ids_array);
            }
        } else {
            $cat_ids = substr($cat_ids, 0, -1);
        }
        if ($cat_ids != '') {
            $query = "SELECT DISTINCT sec.color FROM #__spidercalendar_event AS se JOIN  \n\t\t#__spidercalendar_event_category AS sec ON se.category=sec.id  WHERE  se.published='1' AND sec.published='1' AND se.calendar=" . $calendar_id . " AND se.id IN (" . $ev_ids_inline . ") ";
        } else {
            $query = "SELECT DISTINCT sec.color FROM #__spidercalendar_event AS se JOIN  \n\t\t#__spidercalendar_event_category AS sec ON se.category=sec.id WHERE  se.published='1' AND sec.published='1' AND se.calendar=" . $calendar_id . " AND se.id IN (" . $ev_ids_inline . ")  ";
        }
        $db->setQuery($query);
        $rows = $db->loadObjectList();
        return $rows;
    }
}
Example #3
0
function big_calendar_day()
{
    require_once "frontend_functions.php";
    global $wpdb;
    $widget = isset($_GET['widget']) && (int) $_GET['widget'] ? (int) $_GET['widget'] : 0;
    $many_sp_calendar = isset($_GET['many_sp_calendar']) && is_numeric(esc_html($_GET['many_sp_calendar'])) ? esc_html($_GET['many_sp_calendar']) : 1;
    $calendar_id = isset($_GET['calendar']) ? (int) $_GET['calendar'] : '';
    $theme_id = isset($_GET['theme_id']) ? (int) $_GET['theme_id'] : 1;
    $date = isset($_GET['date']) && IsDate_inputed(esc_html($_GET['date'])) ? esc_html($_GET['date']) : '';
    $view_select = isset($_GET['select']) ? esc_html($_GET['select']) : 'month,';
    $path_sp_cal = isset($_GET['cur_page_url']) ? esc_html($_GET['cur_page_url']) : '';
    $site_url = get_option("home", get_site_url()) . '/wp-admin/admin-ajax.php';
    ///////////////////////////////////////////////////////////////////////////////////
    if (isset($_GET['cat_id'])) {
        $cat_id = $_GET['cat_id'];
    } else {
        $cat_id = "";
    }
    if (isset($_GET['cat_ids'])) {
        $cat_ids = $_GET['cat_ids'];
    } else {
        $cat_ids = "";
    }
    if ($cat_ids == '') {
        $cat_ids .= $cat_id . ',';
    } else {
        $cat_ids .= ',' . $cat_id . ',';
    }
    $cat_ids = substr($cat_ids, 0, -1);
    function getelementcountinarray($array, $element)
    {
        $t = 0;
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t++;
            }
        }
        return $t;
    }
    function getelementindexinarray($array, $element)
    {
        $t = '';
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t .= $i . ',';
            }
        }
        return $t;
    }
    $cat_ids_array = explode(',', $cat_ids);
    if ($cat_id != '') {
        if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
            $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
            $index_array = explode(',', $index_in_line);
            array_pop($index_array);
            for ($j = 0; $j < count($index_array); $j++) {
                unset($cat_ids_array[$index_array[$j]]);
            }
            $cat_ids = implode(',', $cat_ids_array);
        }
    } else {
        $cat_ids = substr($cat_ids, 0, -1);
    }
    ///////////////////////////////////////////////////////////////////////////////////////////////////////
    $theme = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . $wpdb->prefix . 'spidercalendar_theme WHERE id=%d', $theme_id));
    $cal_width = $theme->width;
    $bg_top = '#' . str_replace('#', '', $theme->bg_top);
    $bg_bottom = '#' . str_replace('#', '', $theme->bg_bottom);
    $border_color = '#' . str_replace('#', '', $theme->border_color);
    $text_color_year = '#' . str_replace('#', '', $theme->text_color_year);
    $text_color_month = '#' . str_replace('#', '', $theme->text_color_month);
    $color_week_days = '#' . str_replace('#', '', $theme->text_color_week_days);
    $text_color_other_months = '#' . str_replace('#', '', $theme->text_color_other_months);
    $text_color_this_month_unevented = '#' . str_replace('#', '', $theme->text_color_this_month_unevented);
    $evented_color = '#' . str_replace('#', '', $theme->text_color_this_month_evented);
    $evented_color_bg = '#' . str_replace('#', '', $theme->bg_color_this_month_evented);
    $color_arrow_year = '#' . str_replace('#', '', $theme->arrow_color_year);
    $color_arrow_month = '#' . str_replace('#', '', $theme->arrow_color_month);
    $sun_days = '#' . str_replace('#', '', $theme->text_color_sun_days);
    $event_title_color = '#' . str_replace('#', '', $theme->event_title_color);
    $current_day_border_color = '#' . str_replace('#', '', $theme->current_day_border_color);
    $cell_border_color = '#' . str_replace('#', '', $theme->cell_border_color);
    $cell_height = $theme->cell_height;
    $popup_width = $theme->popup_width;
    $popup_height = $theme->popup_height;
    $number_of_shown_evetns = $theme->number_of_shown_evetns;
    $sundays_font_size = $theme->sundays_font_size;
    $other_days_font_size = $theme->other_days_font_size;
    $weekdays_font_size = $theme->weekdays_font_size;
    $border_width = $theme->border_width;
    $top_height = $theme->top_height;
    $bg_color_other_months = '#' . str_replace('#', '', $theme->bg_color_other_months);
    $sundays_bg_color = '#' . str_replace('#', '', $theme->sundays_bg_color);
    $weekdays_bg_color = '#' . str_replace('#', '', $theme->weekdays_bg_color);
    $weekstart = $theme->week_start_day;
    $weekday_sunday_bg_color = '#' . str_replace('#', '', $theme->weekday_sunday_bg_color);
    $border_radius = $theme->border_radius;
    $border_radius2 = $border_radius - $border_width;
    $week_days_cell_height = $theme->week_days_cell_height;
    $year_font_size = $theme->year_font_size;
    $month_font_size = $theme->month_font_size;
    $arrow_size = $theme->arrow_size;
    $arrow_size_hover = $arrow_size + 5;
    $next_month_text_color = '#' . str_replace('#', '', $theme->next_month_text_color);
    $prev_month_text_color = '#' . str_replace('#', '', $theme->prev_month_text_color);
    $next_month_arrow_color = '#' . str_replace('#', '', $theme->next_month_arrow_color);
    $prev_month_arrow_color = '#' . str_replace('#', '', $theme->prev_month_arrow_color);
    $next_month_font_size = $theme->next_month_font_size;
    $prev_month_font_size = $theme->prev_month_font_size;
    $month_type = $theme->month_type;
    $date_bg_color = '#' . str_replace('#', '', $theme->date_bg_color);
    $event_bg_color1 = '#' . str_replace('#', '', $theme->event_bg_color1);
    $event_bg_color2 = '#' . str_replace('#', '', $theme->event_bg_color2);
    $event_num_bg_color1 = '#' . str_replace('#', '', $theme->event_num_bg_color1);
    $event_num_bg_color2 = '#' . str_replace('#', '', $theme->event_num_bg_color2);
    $event_num_color = '#' . str_replace('#', '', $theme->event_num_color);
    $date_font_size = $theme->date_font_size;
    $event_num_font_size = $theme->event_num_font_size;
    $event_table_height = $theme->event_table_height;
    $date_height = $theme->date_height;
    $day_month_font_size = $theme->day_month_font_size;
    $week_font_size = $theme->week_font_size;
    $day_month_font_color = '#' . str_replace('#', '', $theme->day_month_font_color);
    $week_font_color = '#' . str_replace('#', '', $theme->week_font_color);
    $views_tabs_bg_color = '#' . str_replace('#', '', $theme->views_tabs_bg_color);
    $views_tabs_text_color = '#' . str_replace('#', '', $theme->views_tabs_text_color);
    $views_tabs_font_size = $theme->views_tabs_font_size;
    $date_bg_color = '#' . str_replace('#', '', $theme->date_bg_color);
    $event_bg_color1 = '#' . str_replace('#', '', $theme->event_bg_color1);
    $event_bg_color2 = '#' . str_replace('#', '', $theme->event_bg_color2);
    $event_num_bg_color1 = '#' . str_replace('#', '', $theme->event_num_bg_color1);
    $event_num_bg_color2 = '#' . str_replace('#', '', $theme->event_num_bg_color2);
    $event_num_color = '#' . str_replace('#', '', $theme->event_num_color);
    $date_font_size = $theme->date_font_size;
    $event_num_font_size = $theme->event_num_font_size;
    $show_numbers_for_events = $theme->day_start;
    __('January', 'sp_calendar');
    __('February', 'sp_calendar');
    __('March', 'sp_calendar');
    __('April', 'sp_calendar');
    __('May', 'sp_calendar');
    __('June', 'sp_calendar');
    __('July', 'sp_calendar');
    __('August', 'sp_calendar');
    __('September', 'sp_calendar');
    __('October', 'sp_calendar');
    __('November', 'sp_calendar');
    __('December', 'sp_calendar');
    if ($cell_height == '') {
        $cell_height = 70;
    }
    if ($cal_width == '') {
        $cal_width = 700;
    }
    if ($date != '') {
        $date_REFERER = $date;
    } else {
        $date_REFERER = date("Y-m");
        $date = date("Y") . '-' . php_Month_num(date("F")) . '-' . date("d");
    }
    $year_REFERER = substr($date_REFERER, 0, 4);
    $month_REFERER = Month_name(substr($date_REFERER, 5, 2));
    $day_REFERER = substr($date_REFERER, 8, 2);
    $year = substr($date, 0, 4);
    $month = Month_name(substr($date, 5, 2));
    $day = substr($date, 8, 2);
    $cell_width = $cal_width / 7;
    $month_day_count = date('t', mktime(0, 0, 0, Month_num($month), 1, $year));
    $prev_month_day_count = date('t', mktime(0, 0, 0, Month_num($month) - 1, 1, $year));
    if ($day > $month_day_count) {
        $month = Month_name(Month_num($month) + 1);
        $day = '01';
    }
    if ((int) $day < 1) {
        $month = Month_name(Month_num($month) - 1);
        $day = $prev_month_day_count;
    }
    $this_month = substr($year . '-' . add_0(Month_num($month)), 5, 2);
    $prev_month = add_0((int) $this_month - 1);
    $next_month = add_0((int) $this_month + 1);
    $view = 'bigcalendarday';
    $views = explode(',', $view_select);
    $defaultview = 'day';
    array_pop($views);
    $display = '';
    if (count($views) == 0) {
        $display = "display:none";
    }
    if (count($views) == 1 && $views[0] == $defaultview) {
        $display = "display:none";
    }
    ?>
  <style type='text/css'>
	
	.day_ev{
		border-top-left-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
		border-top-right-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
		border-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
		border-bottom-left-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
	}
  
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 td, #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 tr, #spiderCalendarTitlesList td, #spiderCalendarTitlesList tr {
      border: none !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . general_table {
      border-radius: <?php 
    echo $border_radius;
    ?>
px !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . top_table {
      border-top-left-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
      border-top-right-radius: <?php 
    echo $border_radius2;
    ?>
px !important;
    }
	.general_table table table:last-child .day_ev:last-child td,
	.general_table table table:last-child .week_list:last-child td{
		border-bottom-left-radius:<?php 
    echo $border_radius2;
    ?>
px;
		
  }
	
	.general_table table tr:last-child >td:last-child{
	border-bottom-right-radius: <?php 
    echo $border_radius2;
    ?>
px;
	border-top-right-radius: <?php 
    echo $border_radius2;
    ?>
px;
	}
	
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_arrow a : link, #bigcalendar .cala_arrow a:visited {
      text-decoration: none !important;
      background: none !important;
      font-size: <?php 
    echo $arrow_size;
    ?>
px !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_arrow {
      vertical-align: middle !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_arrow a : hover {
      font-size: <?php 
    echo $arrow_size_hover;
    ?>
px !important;
      text-decoration: none !important;
      background: none !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_day a : link, #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_day a : visited {
      text-decoration: none !important;
      background: none !important;
      font-size: 12px !important;
      color: red;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_day a : hover {
      text-decoration: none !important;
      background: none !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . cala_day {
      border: 1px solid  <?php 
    echo $cell_border_color;
    ?>
 !important;
      <?php 
    echo 'vertical-align:top !important;';
    ?>
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . weekdays {
      vertical-align: middle !important;
      border: 1px solid  <?php 
    echo $cell_border_color;
    ?>
 !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . week_days {
      font-size: <?php 
    echo $weekdays_font_size;
    ?>
px !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . calyear_table {
      border-spacing: 0 !important;
      width: 100% !important;
    }
    . calyear_table table #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . calmonth_table {
      border-spacing: 0 !important;
      width: 100% !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . calbg, #bigcalendar .calbg td {
      text-align: center !important;
      width: 14% !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . caltext_color_other_months {
      color: <?php 
    echo $text_color_other_months;
    ?>
 !important;
      border: 1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      <?php 
    echo 'vertical-align:top !important;';
    ?>
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . caltext_color_this_month_unevented {
      color: <?php 
    echo $text_color_this_month_unevented;
    ?>
 !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 . calfont_year {
      font-size: 24px !important;
      font-weight: bold !important;
      color: <?php 
    echo $text_color_year;
    ?>
 !important;
    }
    .general_table table, .general_table td, .general_table tr {
      border: inherit !important;
      vertical-align: initial !important;
      border-collapse: inherit !important;
      margin: inherit !important;
      padding: inherit !important;
    }
    .general_table {
      border-collapse: inherit !important;
      margin: inherit !important;
    }
    .general_table p {
      margin: inherit !important;
      padding: inherit !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calsun_days {
      color: <?php 
    echo $sun_days;
    ?>
 !important;
      border: 1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      <?php 
    echo 'vertical-align:top !important; text-align:left !important;';
    ?>
      background-color: <?php 
    echo $sundays_bg_color;
    ?>
 !important;
    }
    #TB_window {
      z-index: 10000;
    }
    
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 td {
      vertical-align: middle !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table {
      border-collapse: initial;
      border:0px;
      max-width: none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table tr:hover td {
      background: none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table td {
      padding: 0px;
      vertical-align: none;
      border-top:none;
      line-height: none;
      text-align: none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 p, ol, ul, dl, address {
      margin-bottom:0;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 td,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 tr,
    #spiderCalendarTitlesList td,
    #spiderCalendarTitlesList tr {
      border:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .general_table {
      border-radius: <?php 
    echo $border_radius;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .top_table {
      border-top-left-radius: <?php 
    echo $border_radius2;
    ?>
px;
      border-top-right-radius: <?php 
    echo $border_radius2;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:link,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:visited {
      text-decoration:none;
      background:none;
      font-size: <?php 
    echo $arrow_size;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:hover {
      text-decoration:none;
      background:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:link,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:visited {
      text-decoration:none;
      background:none;
      font-size:12px;
      color:red;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:hover {
      text-decoration:none;
      background:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day {
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
;
      vertical-align:top;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .weekdays {
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .week_days {
      font-size:<?php 
    echo $weekdays_font_size;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calyear_table {
      border-spacing:0;
      width:100%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calmonth_table {	
      border-spacing:0;
      width:100%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calbg,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calbg td {
      text-align:center;
      width:14%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_other_months {
      color:<?php 
    echo $text_color_other_months;
    ?>
;
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
;
      vertical-align:top;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_this_month_unevented {
      color:<?php 
    echo $text_color_this_month_unevented;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calfont_year {
      font-size:24px;
      font-weight:bold;
      color:<?php 
    echo $text_color_year;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calsun_days {
      color:<?php 
    echo $sun_days;
    ?>
;
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
;
      vertical-align:top;
      text-align:left;
      background-color:<?php 
    echo $sundays_bg_color;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views {
      float: right;
      background-color: <?php 
    echo $views_tabs_bg_color;
    ?>
;
      min-height: 25px;
      min-width: 70px;
      margin-right: 2px;
      text-align: center;
      cursor:pointer;
      position: relative;
      top: 5px;
    }
	
	
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views_select ,
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 #views_select
	{
		background-color: <?php 
    echo $views_tabs_bg_color;
    ?>
;
		width: 120px;
		text-align: center;
		cursor: pointer;
		padding: 6px;
		position: relative;
	}

 #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views span{
		padding: 7px;
	}

#drop_down_views
{
	list-style-type:none !important;
	position: absolute;
	top: 46px;
	left: -15px;
	display:none;
	z-index: 4545;
	
}

#drop_down_views >li:hover .views_select, #drop_down_views >li.active .views_select
{
	background:<?php 
    echo $bg_top;
    ?>
;
}

#drop_down_views >li
{
	border-bottom:1px solid #fff !important;
}


#views_tabs_select 
{
	display:none;
}

  </style>
  <div  id="afterbig<?php 
    echo $many_sp_calendar;
    ?>
" style="<?php 
    echo $display;
    ?>
">
  <div style="width:100%;">
    <table  cellpadding="0" cellspacing="0" style="width:100%;">
      <tr>
        <td>
		
          <div id="views_tabs" style="width: 100%;<?php 
    echo $display;
    ?>
">
            <div class="views" style="<?php 
    if (!in_array('day', $views) and $defaultview != 'day') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarday') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Day', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('week', $views) and $defaultview != 'week') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarweek') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_week', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'months' => $prev_month . ',' . $this_month . ',' . $next_month, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Week', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('list', $views) and $defaultview != 'list') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarlist') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_list', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('List', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('month', $views) and $defaultview != 'month') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarmonth') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Month', 'sp_calendar');
    ?>
</span>
            </div>
          </div>
		  <div id="views_tabs_select" style="display:none" >
<div  id="views_select" style="background-color:<?php 
    echo $bg_top;
    ?>
 !important;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">
<?php 
    if ($view == 'bigcalendarday') {
        echo 'Day';
    }
    if ($view == 'bigcalendarmonth') {
        echo 'Month';
    }
    if ($view == 'bigcalendarweek') {
        echo 'Week';
    }
    if ($view == 'bigcalendarlist') {
        echo 'List';
    }
    ?>
<span>&#9658;</span>
</div>
<ul id="drop_down_views" style="float: left;top: inherit;left: -20px;margin-top: 0px;">
<li <?php 
    if ($view == 'bigcalendarday') {
        ?>
 class="active" <?php 
    }
    ?>
  style="<?php 
    if (!in_array('day', $views) and $defaultview != 'day') {
        echo 'display:none;';
    }
    ?>
">
<div class="views_select"   
				onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"  >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Day</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarweek') {
        ?>
 class="active" <?php 
    }
    ?>
 style="<?php 
    if (!in_array('week', $views) and $defaultview != 'week') {
        echo 'display:none;';
    }
    ?>
" ><div class="views_select"  
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_week', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'months' => $prev_month . ',' . $this_month . ',' . $next_month, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')">
	<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Week</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarlist') {
        ?>
 class="active" <?php 
    }
    ?>
 style="<?php 
    if (!in_array('list', $views) and $defaultview != 'list') {
        echo 'display:none;';
    }
    ?>
"><div class="views_select"   
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_list', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">List</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarmonth') {
        ?>
 class="active" <?php 
    }
    ?>
  style="<?php 
    if (!in_array('month', $views) and $defaultview != 'month') {
        echo 'display:none;';
    }
    ?>
"><div class="views_select"   
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Month</span></div></li>

</ul>
</div>
		  
        </td>
      </tr>
      <tr>
        <td>
          <table cellpadding="0" cellspacing="0"  class="general_table"  style="border-spacing:0; width:100%; border:<?php 
    echo $border_color;
    ?>
 solid <?php 
    echo $border_width;
    ?>
px; margin:0; padding:0; background-color:<?php 
    echo $bg_bottom;
    ?>
 !important;">
            <tr>
              <td width="100%" style="padding:0; margin:0;">
                <table cellpadding="0" cellspacing="0" border="0" style="border-spacing:0; font-size:12px; margin:0; padding:0; width:100%;" >
                  <tr style="height:40px; width:100%;">
                    <td class="top_table" align="center" colspan="7" style="z-index: 5;position: relative;background-image:url('<?php 
    echo plugins_url('/images/Stver.png', __FILE__);
    ?>
');padding:0; margin:0; background-color:<?php 
    echo $bg_top;
    ?>
 !important;height:20px; background-repeat: no-repeat;background-size: 100% 100%;">
                      <table cellpadding="0" cellspacing="0" border="0" align="center" class="calyear_table" style="margin:0; padding:0; text-align:center; width:99.8%; height:<?php 
    echo $top_height;
    ?>
px;">
                        <tr>
                          <td width="15%">
                            <div onclick="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year - 1 . '-' . add_0(Month_num($month)) . '-' . $day, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="text-align:center; cursor:pointer; width:102%; background-color:#000000; filter:alpha(opacity=30); opacity:0.3;">
                              <span style="font-size:18px; color:#FFF"><?php 
    echo $year - 1;
    ?>
</span>
                            </div>
                          </td>
                          <td style="width:100%;vertical-align:center">
                            <table style="width:100%;">
                              <tr>
                                <td class="cala_arrow" width="15%"  style="text-align:right;margin:0px;padding:0px">
                                  <a style="text-shadow: 1px 1px 2px black;color:<?php 
    echo $color_arrow_month;
    ?>
" href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    if ($day == '01' && Month_num(Month_name(Month_num($month) - 1)) != '12') {
        $needed_date = $year . '-' . add_0(Month_num($month) - 1) . '-' . $prev_month_day_count;
    } else {
        if (Month_num(Month_name(Month_num($month) - 1)) == '12' && $day == '01') {
            $needed_date = $year - 1 . '-' . add_0(Month_num($month) - 1) . '-' . $prev_month_day_count;
        } else {
            $needed_date = $year . '-' . add_0(Month_num($month)) . '-' . add_0($day - 1);
        }
    }
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')">&#9668;
                                  </a>
                                </td>
                                <td style="text-align:center; margin:0;" width="40%">
                                  <input type="hidden" name="month" readonly="" value="<?php 
    echo $month;
    ?>
"/>
                                  <span style="line-height: 30px;font-family:arial; color:<?php 
    echo $text_color_month;
    ?>
; font-size:<?php 
    echo $month_font_size;
    ?>
px;text-shadow: 1px 1px  black;"><?php 
    echo $day . ' ' . __($month, 'sp_calendar') . ' ' . $year;
    ?>
</span>
                                </td>
								<?php 
    if ($day == $month_day_count && Month_num(Month_name(Month_num($month) + 1)) != '1') {
        $needed_date = $year . '-' . add_0(Month_num($month) + 1) . '-01';
    } else {
        if (Month_num(Month_name(Month_num($month) + 1)) == '1' && $day == $month_day_count) {
            $needed_date = $year + 1 . '-' . add_0(Month_num($month + 1)) . '-01';
        } else {
            $needed_date = $year . '-' . add_0(Month_num($month)) . '-' . add_0($day + 1);
        }
    }
    ?>
								
                                <td style="margin:0; padding:0;text-align:left" width="15%" class="cala_arrow">
                                  <a style="text-shadow: 1px 1px 2px black;color:<?php 
    echo $color_arrow_month;
    ?>
" href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')">&#9658;
                                  </a>
                                </td>
                                <td width="15%">
                                  <div onclick="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year + 1 . '-' . add_0(Month_num($month)) . '-' . $day, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="text-align:center; cursor:pointer; width:102%; background-color:#000000; filter:alpha(opacity=30); opacity:0.3;">
                                    <span style="font-size:18px; color:#FFF"><?php 
    echo $year + 1;
    ?>
</span>
                                  </div>
                                </td>
                              </tr>
                            </table>
                          </td>	
                        </tr>
							        </table>
                    </td>
                    
                  </tr>
                </tr>
                <tr>	
                  <td>
  <?php 
    $month_first_weekday = date("N", mktime(0, 0, 0, Month_num($month), 1, $year));
    if ($weekstart == "su") {
        $month_first_weekday++;
        if ($month_first_weekday == 8) {
            $month_first_weekday = 1;
        }
    }
    $month_days = date("t", mktime(0, 0, 0, Month_num($month), 1, $year));
    $last_month_days = date("t", mktime(0, 0, 0, Month_num($month) - 1, 1, $year));
    $weekday_i = $month_first_weekday;
    $last_month_days = $last_month_days - $weekday_i + 2;
    $percent = 1;
    $sum = $month_days - 8 + $month_first_weekday;
    if ($sum % 7 != 0) {
        $percent = $percent + 1;
    }
    $sum = $sum - $sum % 7;
    $percent = $percent + $sum / 7;
    $percent = 107 / $percent;
    $all_calendar_files = php_getdays(0, $calendar_id, $date, $theme_id, $widget);
    $categories = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercalendar_event_category WHERE published=1");
    $calendar = isset($_GET['calendar']) ? $_GET['calendar'] : '';
    $array_days = $all_calendar_files[0]['array_days'];
    $array_days1 = $all_calendar_files[0]['array_days1'];
    $title = $all_calendar_files[0]['title'];
    $ev_ids = $all_calendar_files[0]['ev_ids'];
    sort($array_days, SORT_NUMERIC);
    if (!$array_days || !in_array((int) $day, $array_days)) {
        $week_day = date('D', mktime(0, 0, 0, Month_num($month), (int) $day, $year));
        echo '<table style="border-spacing:0;width:100%;border-bottom:1px solid ' . $cell_border_color . '">
            <tr>
              <td style="height:' . $date_height . 'px;font-size:' . $date_font_size . 'px; padding-left:10px;background-color:' . $date_bg_color . ' !important; color:#6E7276">
                <span style="padding-left:10px; font-size:' . $week_font_size . 'px;color:' . $week_font_color . '">' . week_convert($week_day) . '</span>
                <span style="font-size:' . $day_month_font_size . 'px;color:' . $day_month_font_color . '">(' . __($month, 'sp_calendar') . ' ' . (int) $day . ', ' . $year . ')</span>
              </td>
            </tr>
            <tr>
              <td>
                <table style="border-bottom-left-radius: ' . $border_radius2 . 'px;border-bottom-right-radius: ' . $border_radius2 . 'px;height:' . $event_table_height . 'px;border-spacing:0;width: 100%;background-color:' . $event_bg_color1 . '" class="week_list">
                  <tr>
                    <td style="font-size:22px;font-weight:bold;width:15px;text-align:center;background-color:' . $event_num_bg_color1 . ' !important;color:' . $event_num_color . '"></td>
                    <td><p style="color:' . $event_title_color . ';border:none;">&nbsp;' . __('There Is No Event In This Day', 'sp_calendar') . '</p></td>
                  </tr>
                </table>
              </td>
            </tr>
          </table>';
    }
    if (in_array((int) $day, $array_days)) {
        $week_day = date('D', mktime(0, 0, 0, Month_num($month), (int) $day, $year));
        echo '<table style="border-spacing:0;width:100%;border-bottom:1px solid ' . $cell_border_color . '">
            <tr>
              <td style="height:' . $date_height . 'px;font-size:' . $date_font_size . 'px; padding-left:10px;background-color:' . $date_bg_color . ' !important; color:#6E7276">
                <span style="padding-left:10px; font-size:' . $date_font_size . 'px;color:' . $week_font_color . '">' . week_convert($week_day) . '</span>
                <span style="font-size:' . $day_month_font_size . 'px;color:' . $day_month_font_color . '">(' . __($month, 'sp_calendar') . ' ' . (int) $day . ', ' . $year . ')</span>
              </td>
            <tr>
              <td>';
        foreach ($title as $key => $value) {
            if ($key == (int) $day) {
                $ev_id = explode('<br>', $ev_ids[$key]);
                array_pop($ev_id);
                $ev_ids_inline = implode(',', $ev_id);
                $ev_title = explode('</p>', $value);
                array_pop($ev_title);
                for ($j = 0; $j < count($ev_title); $j++) {
                    $query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercalendar_event_category.color AS color FROM " . $wpdb->prefix . "spidercalendar_event  JOIN " . $wpdb->prefix . "spidercalendar_event_category\n\t       ON " . $wpdb->prefix . "spidercalendar_event.category=" . $wpdb->prefix . "spidercalendar_event_category.id WHERE " . $wpdb->prefix . "spidercalendar_event.calendar=%d AND \n\t       " . $wpdb->prefix . "spidercalendar_event.published='1' AND " . $wpdb->prefix . "spidercalendar_event_category.published='1' AND " . $wpdb->prefix . "spidercalendar_event.id=%d", $calendar, $ev_id[$j]);
                    $cat_color = $wpdb->get_row($query);
                    if (!isset($cat_color->color)) {
                        $cat_color = new stdClass();
                        $cat_color->color = "";
                    }
                    if (($j + 1) % 2 == 0) {
                        $color = $event_num_bg_color2;
                        $table_color = $event_bg_color2;
                    } else {
                        $color = $event_num_bg_color1;
                        $table_color = $event_bg_color1;
                    }
                    echo '<table style="margin: 0;border-spacing:0;height:' . $event_table_height . 'px;border-spacing:0;width: 100%;background-color:' . $table_color . ' !important;" class="day_ev">
                  <tr>
                    <td style="font-size:' . $event_num_font_size . 'px;font-weight:bold;width:15px;text-align:center;background-color: #' . str_replace('#', '', $cat_color->color) . ' !important;color:' . $event_num_color . '">' . ($show_numbers_for_events ? $j + 1 : '') . '</td>
                    <td>
                      <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:15px;background:none;text-decoration:none;color:' . $event_title_color . '; "
                        href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . (int) $day, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . $ev_title[$j] . '</b>
                      </a>
                    </td>
                  </tr>
                </table>';
                }
            }
        }
        echo '</td></tr></table>';
    }
    ?>
                  </td>
                </tr>
              </table>
            </tr>
          </table>
        </td>
      </tr>
    </table>
 
 <script>
  
		   jQuery(document).ready(function (){
					  
			jQuery('#views_select').click(function () {
			jQuery('#drop_down_views').stop(true, true).delay(200).slideDown(500);
		  }, function () {
			jQuery('#drop_down_views').stop(true, true).slideUp(500);
		  });
		  if(jQuery(window).width() > 640 )
		  {
			jQuery('drop_down_views').hide();
		  }
	});
  </script>
  
  
  <style>
  
  @media only screen and (max-width : 640px) { 
 
#views_tabs ,#drop_down_views
{
	display:none;
}

#views_tabs_select
{
	display:block !important;
}


 
}

@media only screen and (max-width : 968px) { 
#cats >li
{
	float:none;
}



}
  .categories1 , .categories2
		{
			display:inline-block;
		}

		.categories2
		{
			position:relative;
			left: -10px;
			cursor:pointer;
		}
		.categories2:first-letter
		{
			color:#fff;
			letter-spacing: 3px;
		}
  </style>
  <?php 
    //reindex cat_ids_array
    $re_cat_ids_array = array_values($cat_ids_array);
    for ($i = 0; $i < count($re_cat_ids_array); $i++) {
        echo '
<style>
#cats #category' . $re_cat_ids_array[$i] . '
{
	text-decoration:underline;
	cursor:pointer;

}

</style>';
    }
    if ($cat_ids == '') {
        $cat_ids = '';
    }
    echo '<ul id="cats" style="list-style-type:none;">';
    foreach ($categories as $category) {
        ?>

<li style="float:left;"><p class="categories1" style="background-color:#<?php 
        echo str_replace('#', '', $category->color);
        ?>
  !important">&nbsp;&nbsp;&nbsp;&nbsp;</p><p class="categories2" id="category<?php 
        echo $category->id;
        ?>
" style="color:#<?php 
        echo str_replace('#', '', $category->color);
        ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
        echo $many_sp_calendar;
        ?>
', '<?php 
        echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . add_0($day), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => $category->id, 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
        ?>
','<?php 
        echo $many_sp_calendar;
        ?>
','<?php 
        echo $widget;
        ?>
')"> <?php 
        echo $category->title;
        ?>
</p></li>


<?php 
    }
    if (!empty($categories)) {
        ?>
<li style="float:left;"><p class="categories1" style="background-color:#<?php 
        echo str_replace('#', '', $bg_top);
        ?>
 !important">&nbsp;&nbsp;&nbsp;&nbsp;</p><p class="categories2" id="category0" style="color:#<?php 
        echo str_replace('#', '', $bg_top);
        ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
        echo $many_sp_calendar;
        ?>
', '<?php 
        echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . add_0($day), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => '', 'widget' => $widget), $site_url);
        ?>
','<?php 
        echo $many_sp_calendar;
        ?>
','<?php 
        echo $widget;
        ?>
')"><?php 
        echo __('All categories', 'sp_calendar');
        ?>
</p></li>
<?php 
        echo '</ul>';
    }
    die;
}
Example #4
0
    }
    return $t;
}
function getelementindexinarray($array, $element)
{
    $t = '';
    for ($i = 0; $i < count($array); $i++) {
        if ($element == $array[$i]) {
            $t .= $i . ',';
        }
    }
    return $t;
}
$cat_ids_array = explode(',', $cat_ids);
if ($cat_id != '') {
    if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
        $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
        $index_array = explode(',', $index_in_line);
        array_pop($index_array);
        for ($j = 0; $j < count($index_array); $j++) {
            unset($cat_ids_array[$index_array[$j]]);
        }
        $cat_ids = implode(',', $cat_ids_array);
    }
} else {
    $cat_ids = substr($cat_ids, 0, -1);
}
/*$module = &JModuleHelper::getModule('spidercalendar');

$moduleParams = new JParameter($module->params);
Example #5
0
function php_getdays_for_three_months($calendar, $date, $months, $theme_id, $widget)
{
    global $wpdb;
    $year = substr($date, 0, 4);
    $month = substr($date, 5, 2);
    $months_array = explode(',', $months);
    if ($widget) {
        $show_time = 0;
    } else {
        $theme = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . $wpdb->prefix . 'spidercalendar_theme WHERE id=%d', $theme_id));
        $show_time = $theme->show_time;
    }
    if (isset($_GET['cat_id'])) {
        $cat_id = $_GET['cat_id'];
    } else {
        $cat_id = "";
    }
    if (isset($_GET['cat_ids'])) {
        $cat_ids = $_GET['cat_ids'];
    } else {
        $cat_ids = "";
    }
    if ($cat_ids == '') {
        $cat_ids .= $cat_id . ',';
    } else {
        $cat_ids .= ',' . $cat_id . ',';
    }
    $cat_ids = substr($cat_ids, 0, -1);
    $cat_ids_array = explode(',', $cat_ids);
    if ($cat_id != '') {
        if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
            $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
            $index_array = explode(',', $index_in_line);
            array_pop($index_array);
            for ($j = 0; $j < count($index_array); $j++) {
                unset($cat_ids_array[$index_array[$j]]);
            }
            $cat_ids = implode(',', $cat_ids_array);
        }
    } else {
        $cat_ids = substr($cat_ids, 0, -1);
    }
    $row = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "spidercalendar_calendar where published=1 and id=%d", $calendar));
    if ($row->time_format == 0) {
        $order_by = "ORDER BY " . $wpdb->prefix . "spidercalendar_event.time ASC";
    } else {
        $order_by = " ORDER BY STR_TO_DATE( SUBSTRING( time, 1, 7 ) ,  '%h:%i%p' )";
    }
    if ($cat_ids != '' and preg_match("/^[0-9\\,]+\$/", $cat_ids)) {
        $query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercalendar_event.*,\t" . $wpdb->prefix . "spidercalendar_event_category.color  from " . $wpdb->prefix . "spidercalendar_event JOIN " . $wpdb->prefix . "spidercalendar_event_category ON " . $wpdb->prefix . "spidercalendar_event.category = " . $wpdb->prefix . "spidercalendar_event_category.id \twhere " . $wpdb->prefix . "spidercalendar_event_category.published=1 and " . $wpdb->prefix . "spidercalendar_event.category IN (" . $cat_ids . ") and " . $wpdb->prefix . "spidercalendar_event.published=1 and ( ( (date<=%s\tor date like %s) and  (date_end>=%s ) or date_end='0000-00-00'  ) or ( date_end is Null and date like %s ) ) and calendar=%d ", substr($date, 0, 7) . '-01', substr($date, 0, 7) . "%", substr($date, 0, 7) . '-01', substr($date, 0, 7) . "%", $calendar);
    } else {
        $query = $wpdb->prepare("SELECT * from " . $wpdb->prefix . "spidercalendar_event where published=1 and ((date_end>=%s) or (date_end=%s)) and calendar=%d", "" . substr($date, 0, 7) . "-01", "0000-00-00", $calendar);
    }
    $rows = $wpdb->get_results($query . " " . $order_by);
    $all_id_array = array();
    $all_array_days = array();
    $all_array_days1 = array();
    $all_title = array();
    $all_ev_ids = array();
    $s = count($rows);
    foreach ($months_array as $month) {
        $id_array = array();
        $array_days = array();
        $array_days1 = array();
        $title = array();
        $ev_ids = array();
        for ($i = 1; $i <= $s; $i++) {
            if ($rows[$i - 1]->repeat_method != 'no_repeat' and $rows[$i - 1]->date_end == '0000-00-00') {
                $d_end = (int) substr($rows[$i - 1]->date, 0, 4) + 40 . substr($rows[$i - 1]->date, 4, 6);
            } else {
                $d_end = $rows[$i - 1]->date_end;
            }
            $date_month = (int) substr($rows[$i - 1]->date, 5, 2);
            $date_end_month = (int) substr($d_end, 5, 2);
            $date_day = (int) substr($rows[$i - 1]->date, 8, 2);
            $date_end_day = (int) substr($d_end, 8, 2);
            $date_year_month = (int) (substr($rows[$i - 1]->date, 0, 4) . substr($rows[$i - 1]->date, 5, 2));
            $date_end_year_month = (int) (substr($d_end, 0, 4) . substr($d_end, 5, 2));
            $year_month = (int) ($year . $month);
            $repeat = $rows[$i - 1]->repeat;
            if ($repeat == "") {
                $repeat = 1;
            }
            $start_date = $rows[$i - 1]->date;
            $weekly = $rows[$i - 1]->week;
            $weekly_array = explode(',', $weekly);
            $date_days = array();
            $weekdays_start = array();
            $weekdays = array();
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ////////////////////////                NO Repeat                /////////////////////////////////////////////////////////////////////////////////////////////
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if ($rows[$i - 1]->repeat_method == 'no_repeat') {
                $date_days[] = $date_day;
            }
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ////////////////////////               Repeat   Daily             /////////////////////////////////////////////////////////////////////////////////////////////
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if ($rows[$i - 1]->repeat_method == 'daily') {
                $t = php_daysDifference($rows[$i - 1]->date, $d_end);
                for ($k = 1; $k <= $t / $repeat; $k++) {
                    $next_date = php_GetNextDate($start_date, $repeat);
                    $next_date_array = explode('/', $next_date);
                    if ((int) $month == $date_month && (int) substr($date_year_month, 0, 4) == (int) $year) {
                        $date_days[0] = $date_day;
                    }
                    if ((int) $month == $next_date_array[0] && (int) $year == $next_date_array[2]) {
                        $date_days[] = $next_date_array[1];
                    }
                    $start_date = date("Y-m-d", mktime(0, 0, 0, $next_date_array[0], $next_date_array[1], $next_date_array[2]));
                }
            }
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ////////////////////////               Repeat   Weekly             ///////////////////////////////////////////////////////////////////////////////////////////
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if ($rows[$i - 1]->repeat_method == 'weekly') {
                for ($j = 0; $j <= 6; $j++) {
                    if (in_array(date("D", mktime(0, 0, 0, $date_month, $date_day + $j, substr($rows[$i - 1]->date, 0, 4))), $weekly_array)) {
                        $weekdays_start[] = $date_day + $j;
                    }
                }
                for ($p = 0; $p < count($weekly_array) - 1; $p++) {
                    $start_date = substr($rows[$i - 1]->date, 0, 8) . $weekdays_start[$p];
                    $t = php_daysDifference($rows[$i - 1]->date, $d_end);
                    $q = php_daysDifference($rows[$i - 1]->date, $start_date);
                    $r = 0;
                    if ($t / ($repeat * 7) - 1 > 1) {
                        for ($k = 1; $k < $t / ($repeat * 7) - 1; $k++) {
                            $start_date_array[] = $start_date;
                            $next_date = php_GetNextDate($start_date, $repeat * 7);
                            $next_date_array = explode('/', $next_date);
                            if ((int) $month == $date_month && (int) substr($date_year_month, 0, 4) == (int) $year) {
                                $date_days[0] = $weekdays_start[$p];
                            }
                            if ((int) $month == $next_date_array[0] && (int) $year == $next_date_array[2]) {
                                if ((int) $year > (int) substr($date_year_month, 0, 4)) {
                                    $weekdays[] = $next_date_array[1];
                                } else {
                                    $weekdays[] = $next_date_array[1];
                                }
                            }
                            $start_date = date("Y-m-d", mktime(0, 0, 0, $next_date_array[0], $next_date_array[1], $next_date_array[2]));
                            if ($next_date_array[2] > (int) substr($d_end, 0, 4)) {
                                break;
                            }
                        }
                        $date_days = array_merge($weekdays, $date_days);
                    } else {
                        if ($t >= $q) {
                            $date_days[] = $weekdays_start[$p];
                        }
                    }
                }
                $repeat = $repeat * 7;
            }
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ////////////////////////               Repeat   Monthly            ///////////////////////////////////////////////////////////////////////////////////////////
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if ($rows[$i - 1]->repeat_method == 'monthly') {
                $month_days = date('t', mktime(0, 0, 0, $month, $date_day, $year));
                if ($date_month < (int) $month or (int) substr($date_year_month, 0, 4) < $year) {
                    $date_day = 1;
                }
                if ($year > (int) substr($date_year_month, 0, 4)) {
                    $date_year_month = $year . '00';
                }
                $p = (int) substr($date_year_month, 4, 2);
                if ((int) substr($date_year_month, 0, 4) != (int) substr($date_end_year_month, 0, 4)) {
                    $end = (int) substr($date_end_year_month, 4, 2) + 12;
                } else {
                    $end = (int) substr($date_end_year_month, 4, 2);
                }
                for ($k = 1; $k <= $end; $k++) {
                    if ((int) $month == $p and $rows[$i - 1]->month_type == 1) {
                        $date_days[0] = $rows[$i - 1]->month;
                    }
                    if ($p == (int) $month and $rows[$i - 1]->month_type == 2) {
                        if ($rows[$i - 1]->monthly_list != 'last') {
                            for ($j = $rows[$i - 1]->monthly_list; $j < $rows[$i - 1]->monthly_list + 7; $j++) {
                                if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows[$i - 1]->month_week) {
                                    if ($j >= $date_day) {
                                        $date_days[0] = $j;
                                    }
                                }
                            }
                        } else {
                            for ($j = 1; $j < $month_days; $j++) {
                                if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows[$i - 1]->month_week) {
                                    if ($j >= $date_day) {
                                        $date_days[0] = $j;
                                    }
                                }
                            }
                        }
                    }
                    if ($year > (int) substr($date_year_month, 0, 4)) {
                        $p = 1;
                    }
                    $p = $p + $repeat;
                }
                $repeat = 32;
            }
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ////////////////////////               Repeat   Yearly             ///////////////////////////////////////////////////////////////////////////////////////////
            //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if ($rows[$i - 1]->repeat_method == 'yearly') {
                $month_days = date('t', mktime(0, 0, 0, $month, $date_day, $year));
                $end = substr($date_end_year_month, 0, 4) - substr($date_year_month, 0, 4) + 1;
                if (substr($date_year_month, 0, 4) < $year) {
                    $date_day = 1;
                }
                for ($k = 0; $k <= $end; $k += $repeat) {
                    if ((int) $month == $rows[$i - 1]->year_month and $rows[$i - 1]->month_type == 1 and $year == substr($date_year_month, 0, 4) + $k) {
                        $date_days[0] = $rows[$i - 1]->month;
                    }
                }
                for ($k = 0; $k <= $end; $k += $repeat) {
                    if ((int) $month == $rows[$i - 1]->year_month and $rows[$i - 1]->month_type == 2 and $year == substr($date_year_month, 0, 4) + $k) {
                        if ($rows[$i - 1]->monthly_list != 'last') {
                            for ($j = $rows[$i - 1]->monthly_list; $j < $rows[$i - 1]->monthly_list + 7; $j++) {
                                if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows[$i - 1]->month_week) {
                                    $date_days[0] = $j;
                                }
                            }
                        } else {
                            for ($j = 1; $j <= $month_days; $j++) {
                                if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows[$i - 1]->month_week) {
                                    $date_days[0] = $j;
                                }
                            }
                        }
                    }
                }
                $repeat = 32;
            }
            $used = array();
            foreach ($date_days as $date_day) {
                if ($date_month == $month) {
                    if (in_array($date_day, $used)) {
                        continue;
                    } else {
                        array_push($used, $date_day);
                    }
                    if (in_array($date_day, $array_days)) {
                        $key = array_search($date_day, $array_days);
                        $title_num[$date_day]++;
                        if ($rows[$i - 1]->text_for_date != "") {
                            $array_days1[$key] = $date_day;
                        }
                        $c = $title_num[$date_day];
                        $list = '<p>&nbsp; ';
                        if ($rows[$i - 1]->time and $show_time != 0) {
                            $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                        } else {
                            $list .= $rows[$i - 1]->title . '</p>';
                        }
                        $title[$date_day] = $title[$date_day] . $list;
                        $ev_ids[$date_day] = $ev_ids[$date_day] . $rows[$i - 1]->id . '<br>';
                    } else {
                        $array_days[] = $date_day;
                        $key = array_search($date_day, $array_days);
                        if ($rows[$i - 1]->text_for_date != "") {
                            $array_days1[$key] = $date_day;
                        }
                        $title_num[$date_day] = 1;
                        $c = 1;
                        $list = '<p>&nbsp; ';
                        if ($rows[$i - 1]->time and $show_time != 0) {
                            $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                        } else {
                            $list .= $rows[$i - 1]->title . '</p>';
                        }
                        $title[$date_day] = $list;
                        $ev_ids[$date_day] = $rows[$i - 1]->id . '<br>';
                    }
                }
                if ($date_end_month > 0 and $date_year_month == $date_end_year_month and $date_end_year_month == $year_month) {
                    for ($j = $date_day; $j <= $date_end_day; $j = $j + $repeat) {
                        if (in_array($j, $used)) {
                            continue;
                        } else {
                            array_push($used, $j);
                        }
                        if (in_array($j, $array_days)) {
                            $key = array_search($j, $array_days);
                            $title_num[$j]++;
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $c = $title_num[$j];
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $title[$j] . $list;
                            $ev_ids[$j] = $ev_ids[$j] . $rows[$i - 1]->id . '<br>';
                        } else {
                            $array_days[] = $j;
                            $key = array_search($j, $array_days);
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $title_num[$j] = 1;
                            $c = 1;
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $list;
                            $ev_ids[$j] = $rows[$i - 1]->id . '<br>';
                        }
                    }
                }
                if ($date_end_month > 0 and $date_year_month < $date_end_year_month and $date_year_month == $year_month) {
                    for ($j = $date_day; $j <= 31; $j = $j + $repeat) {
                        if (in_array($j, $used)) {
                            continue;
                        } else {
                            array_push($used, $j);
                        }
                        if (in_array($j, $array_days)) {
                            $key = array_search($j, $array_days);
                            $title_num[$j]++;
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $c = $title_num[$j];
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $title[$j] . $list;
                            $ev_ids[$j] = $ev_ids[$j] . $rows[$i - 1]->id . '<br>';
                        } else {
                            $array_days[] = $j;
                            $key = array_search($j, $array_days);
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $title_num[$j] = 1;
                            $c = 1;
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $list;
                            $ev_ids[$j] = $rows[$i - 1]->id . '<br>';
                        }
                    }
                }
                if ($date_end_month > 0 and $date_year_month < $date_end_year_month and $date_end_year_month == $year_month) {
                    for ($j = $date_day; $j <= $date_end_day; $j = $j + $repeat) {
                        if (in_array($j, $used)) {
                            continue;
                        } else {
                            array_push($used, $j);
                        }
                        if (in_array($j, $array_days)) {
                            $key = array_search($j, $array_days);
                            $title_num[$j]++;
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $c = $title_num[$j];
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $title[$j] . $list;
                            $ev_ids[$j] = $ev_ids[$j] . $rows[$i - 1]->id . '<br>';
                        } else {
                            $array_days[] = $j;
                            $key = array_search($j, $array_days);
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $title_num[$j] = 1;
                            $c = 1;
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $list;
                            $ev_ids[$j] = $rows[$i - 1]->id . '<br>';
                        }
                    }
                }
                if ($date_end_month > 0 and $date_year_month < $date_end_year_month and $date_end_year_month > $year_month and $date_year_month < $year_month) {
                    for ($j = $date_day; $j <= 31; $j = $j + $repeat) {
                        if (in_array($j, $used)) {
                            continue;
                        } else {
                            array_push($used, $j);
                        }
                        if (in_array($j, $array_days)) {
                            $key = array_search($j, $array_days);
                            $title_num[$j]++;
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $c = $title_num[$j];
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $title[$j] . $list;
                            $ev_ids[$j] = $ev_ids[$j] . $rows[$i - 1]->id . '<br>';
                        } else {
                            $array_days[] = $j;
                            $key = array_search($j, $array_days);
                            if ($rows[$i - 1]->text_for_date != "") {
                                $array_days1[$key] = $j;
                            }
                            $title_num[$j] = 1;
                            $c = 1;
                            $list = '<p>&nbsp; ';
                            if ($rows[$i - 1]->time and $show_time != 0) {
                                $list .= $rows[$i - 1]->title . '<br>(' . $rows[$i - 1]->time . ')</p>';
                            } else {
                                $list .= $rows[$i - 1]->title . '</p>';
                            }
                            $title[$j] = $list;
                            $ev_ids[$j] = $rows[$i - 1]->id . '<br>';
                        }
                    }
                }
            }
        }
        $all_id_array[] = $id_array;
        $all_array_days[] = $array_days;
        $all_array_days1[] = $array_days1;
        $all_title[] = $title;
        $all_ev_ids[] = $ev_ids;
    }
    $all_calendar_files['all_array_days'] = $all_array_days;
    $all_calendar_files['all_array_days1'] = $all_array_days1;
    $all_calendar_files['all_title'] = $all_title;
    $all_calendar_files['all_ev_ids'] = $all_ev_ids;
    $all_calendar_files['all_calendar'] = $all_id_array;
    return array($all_calendar_files);
}
Example #6
0
function big_calendar_month()
{
    require_once "frontend_functions.php";
    global $wpdb;
    $widget = isset($_GET['widget']) && (int) $_GET['widget'] ? (int) $_GET['widget'] : 0;
    $many_sp_calendar = isset($_GET['many_sp_calendar']) && is_numeric(esc_html($_GET['many_sp_calendar'])) ? esc_html($_GET['many_sp_calendar']) : 1;
    $calendar_id = isset($_GET['calendar']) ? (int) $_GET['calendar'] : '';
    $theme_id = isset($_GET['theme_id']) ? (int) $_GET['theme_id'] : 13;
    $date = isset($_GET['date']) && IsDate_inputed(esc_html($_GET['date'])) ? esc_html($_GET['date']) : '';
    $view_select = isset($_GET['select']) ? esc_html($_GET['select']) : 'month,';
    $path_sp_cal = isset($_GET['cur_page_url']) ? esc_html($_GET['cur_page_url']) : '';
    $query = "SELECT * FROM " . $wpdb->prefix . "spidercalendar_calendar where id=" . $calendar_id . "";
    $calendar = $wpdb->query($query);
    $site_url = get_option("home", get_site_url()) . '/wp-admin/admin-ajax.php';
    ///////////////////////////////////////////////////////////////////////////////////
    if (isset($_GET['cat_id'])) {
        $cat_id = $_GET['cat_id'];
    } else {
        $cat_id = "";
    }
    if (isset($_GET['cat_ids'])) {
        $cat_ids = $_GET['cat_ids'];
    } else {
        $cat_ids = "";
    }
    if ($cat_ids == '') {
        $cat_ids .= $cat_id . ',';
    } else {
        $cat_ids .= ',' . $cat_id . ',';
    }
    $cat_ids = substr($cat_ids, 0, -1);
    function getelementcountinarray($array, $element)
    {
        $t = 0;
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t++;
            }
        }
        return $t;
    }
    function getelementindexinarray($array, $element)
    {
        $t = '';
        for ($i = 0; $i < count($array); $i++) {
            if ($element == $array[$i]) {
                $t .= $i . ',';
            }
        }
        return $t;
    }
    $cat_ids_array = explode(',', $cat_ids);
    if ($cat_id != '') {
        if (getelementcountinarray($cat_ids_array, $cat_id) % 2 == 0) {
            $index_in_line = getelementindexinarray($cat_ids_array, $cat_id);
            $index_array = explode(',', $index_in_line);
            array_pop($index_array);
            for ($j = 0; $j < count($index_array); $j++) {
                unset($cat_ids_array[$index_array[$j]]);
            }
            $cat_ids = implode(',', $cat_ids_array);
        }
    } else {
        $cat_ids = substr($cat_ids, 0, -1);
    }
    ///////////////////////////////////////////////////////////////////////////////////////////////////////
    $theme = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . $wpdb->prefix . 'spidercalendar_theme WHERE id=%d', $theme_id));
    $cal_width = $theme->width;
    $bg_top = '#' . str_replace('#', '', $theme->bg_top);
    $bg_bottom = '#' . str_replace('#', '', $theme->bg_bottom);
    $border_color = '#' . str_replace('#', '', $theme->border_color);
    $text_color_year = '#' . str_replace('#', '', $theme->text_color_year);
    $text_color_month = '#' . str_replace('#', '', $theme->text_color_month);
    $color_week_days = '#' . str_replace('#', '', $theme->text_color_week_days);
    $text_color_other_months = '#' . str_replace('#', '', $theme->text_color_other_months);
    $text_color_this_month_unevented = '#' . str_replace('#', '', $theme->text_color_this_month_unevented);
    $evented_color = '#' . str_replace('#', '', $theme->text_color_this_month_evented);
    $evented_color_bg = '#' . str_replace('#', '', $theme->bg_color_this_month_evented);
    $color_arrow_year = '#' . str_replace('#', '', $theme->arrow_color_year);
    $color_arrow_month = '#' . str_replace('#', '', $theme->arrow_color_month);
    $sun_days = '#' . str_replace('#', '', $theme->text_color_sun_days);
    $event_title_color = '#' . str_replace('#', '', $theme->event_title_color);
    $current_day_border_color = '#' . str_replace('#', '', $theme->current_day_border_color);
    $cell_border_color = '#' . str_replace('#', '', $theme->cell_border_color);
    $cell_height = $theme->cell_height;
    $popup_width = $theme->popup_width;
    $popup_height = $theme->popup_height;
    $number_of_shown_evetns = $theme->number_of_shown_evetns;
    $sundays_font_size = $theme->sundays_font_size;
    $other_days_font_size = $theme->other_days_font_size;
    $weekdays_font_size = $theme->weekdays_font_size;
    $border_width = $theme->border_width;
    $top_height = $theme->top_height;
    $bg_color_other_months = '#' . str_replace('#', '', $theme->bg_color_other_months);
    $sundays_bg_color = '#' . str_replace('#', '', $theme->sundays_bg_color);
    $weekdays_bg_color = '#' . str_replace('#', '', $theme->weekdays_bg_color);
    $weekstart = $theme->week_start_day;
    $weekday_sunday_bg_color = '#' . str_replace('#', '', $theme->weekday_sunday_bg_color);
    $border_radius = $theme->border_radius;
    $border_radius2 = $border_radius - $border_width;
    $week_days_cell_height = $theme->week_days_cell_height;
    $year_font_size = $theme->year_font_size;
    $month_font_size = $theme->month_font_size;
    $arrow_size = $theme->arrow_size;
    $arrow_size_hover = $arrow_size + 5;
    $next_month_text_color = '#' . str_replace('#', '', $theme->next_month_text_color);
    $prev_month_text_color = '#' . str_replace('#', '', $theme->prev_month_text_color);
    $next_month_arrow_color = '#' . str_replace('#', '', $theme->next_month_arrow_color);
    $prev_month_arrow_color = '#' . str_replace('#', '', $theme->prev_month_arrow_color);
    $next_month_font_size = $theme->next_month_font_size;
    $prev_month_font_size = $theme->prev_month_font_size;
    $month_type = $theme->month_type;
    $header_format = 'w/m/d/y';
    $ev_title_bg_color = '#' . str_replace('#', '', $theme->ev_title_bg_color);
    $date_bg_color = '#' . str_replace('#', '', $theme->date_bg_color);
    $event_bg_color1 = '#' . str_replace('#', '', $theme->event_bg_color1);
    $event_bg_color2 = '#' . str_replace('#', '', $theme->event_bg_color2);
    $event_num_bg_color1 = '#' . str_replace('#', '', $theme->event_num_bg_color1);
    $event_num_bg_color2 = '#' . str_replace('#', '', $theme->event_num_bg_color2);
    $event_num_color = '#' . str_replace('#', '', $theme->event_num_color);
    $date_font_size = $theme->date_font_size;
    $event_num_font_size = $theme->event_num_font_size;
    $event_table_height = $theme->event_table_height;
    $date_height = $theme->date_height;
    $day_month_font_size = $theme->day_month_font_size;
    $week_font_size = $theme->week_font_size;
    $day_month_font_color = '#' . str_replace('#', '', $theme->day_month_font_color);
    $week_font_color = '#' . str_replace('#', '', $theme->week_font_color);
    $views_tabs_bg_color = '#' . str_replace('#', '', $theme->views_tabs_bg_color);
    $views_tabs_text_color = '#' . str_replace('#', '', $theme->views_tabs_text_color);
    $views_tabs_font_size = $theme->views_tabs_font_size;
    $show_numbers_for_events = $theme->day_start;
    $show_cat = '1';
    $text_color_year = '#' . str_replace('#', '', $theme->text_color_year);
    $ev_color = $theme->event_title_color;
    $show_event_bgcolor = '#' . str_replace('#', '', $theme->show_event_bgcolor);
    __('January', 'sp_calendar');
    __('February', 'sp_calendar');
    __('March', 'sp_calendar');
    __('April', 'sp_calendar');
    __('May', 'sp_calendar');
    __('June', 'sp_calendar');
    __('July', 'sp_calendar');
    __('August', 'sp_calendar');
    __('September', 'sp_calendar');
    __('October', 'sp_calendar');
    __('November', 'sp_calendar');
    __('December', 'sp_calendar');
    if ($cell_height == '') {
        $cell_height = 70;
    }
    if ($cal_width == '') {
        $cal_width = 700;
    }
    if ($date != '') {
        $date_REFERER = $date;
    } else {
        $date_REFERER = date("Y-m");
        $date = date("Y") . '-' . php_Month_num(date("F")) . '-' . date("d");
    }
    $year_REFERER = substr($date_REFERER, 0, 4);
    $month_REFERER = Month_name(substr($date_REFERER, 5, 2));
    $day_REFERER = substr($date_REFERER, 8, 2);
    $year = substr($date, 0, 4);
    $month = Month_name(substr($date, 5, 2));
    $day = substr($date, 8, 2);
    $cell_width = $cal_width / 7;
    $cell_width = (int) $cell_width - 2;
    $this_month = substr($year . '-' . add_0(Month_num($month)), 5, 2);
    $prev_month = add_0((int) $this_month - 1);
    $next_month = add_0((int) $this_month + 1);
    $view = 'bigcalendarmonth';
    $views = explode(',', $view_select);
    $defaultview = 'month';
    array_pop($views);
    $display = '';
    if (count($views) == 0) {
        $display = "display:none";
        echo '<style>
@media only screen and (max-width : 640px) { 
 
#views_tabs_select
{
	display:none !important;
}
}

</style>';
    }
    if (count($views) == 1 and $views[0] == $defaultview) {
        $display = "display:none";
        echo '<style>
@media only screen and (max-width : 640px) { 
 
#views_tabs_select
{
	display:none !important;
}
}

</style>';
    }
    ?>
  <style type='text/css'> 
  #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table{
	border-collapse: inherit !important;
	background: transparent;
  }
  #TB_iframeContent{
		background-color: <?php 
    echo $show_event_bgcolor;
    ?>
;
	}
  
    #TB_window {
      z-index: 10000;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calyear_table td {
      vertical-align: middle !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table {
      border-collapse: initial;
      border:0px;
      max-width: none;
    }
    
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 table td {
      padding: 0px;
      vertical-align: none;
      border-top:none;
      line-height: none;
      text-align: none;
	  background: transparent;
    }
	
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 p, ol, ul, dl, address {
      margin-bottom:0;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 td,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 tr,
    #spiderCalendarTitlesList td,
    #spiderCalendarTitlesList tr {
      border:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .arrow-left {
		width: 0px;
		height: 0px;
		border-top: 15px solid transparent;
		border-bottom: 15px solid transparent;
		border-right: 20px solid;
		margin: 0 auto;	
	}
	
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .arrow-right {
		width: 0px;
		height: 0px;
		border-top: 15px solid transparent;
		border-bottom: 15px solid transparent;
		border-left: 20px solid;
		margin: 0 auto;
	}
	
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 #views_select .arrow-right{
		border-top: 5px solid transparent;
		border-bottom: 5px solid transparent;
		border-left: 8px solid;
		left: 5px;
		position: relative;
	}
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 #views_select .arrow-down{
		width: 0px;
		height: 0px;
		border-left: 5px solid transparent;
		border-right: 5px solid transparent;
		border-top: 8px solid;
	}
	
	#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .general_table {
      border-radius: <?php 
    echo $border_radius;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .top_table {
      border-top-left-radius: <?php 
    echo $border_radius2;
    ?>
px;
      border-top-right-radius: <?php 
    echo $border_radius2;
    ?>
px;
    }
	
	 #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .general_table table tr:last-child >td:first-child{
	border-bottom-left-radius: <?php 
    echo $border_radius2;
    ?>
px;
	}
	
	 #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .general_table table tr:last-child >td:last-child{
	border-bottom-right-radius: <?php 
    echo $border_radius2;
    ?>
px;
	}
	
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:link,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:visited {
      text-decoration:none;
      background:none;
      font-size: <?php 
    echo $arrow_size;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_arrow a:hover {
      text-decoration:none;
      background:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:link,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:visited {
      text-decoration:none;
      background:none;
      font-size:12px;
      color:red;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day a:hover {
      text-decoration:none;
      background:none;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .cala_day {
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      vertical-align:top;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .weekdays {
      border: 1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      vertical-align: middle;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .week_days {
      font-size:<?php 
    echo $weekdays_font_size;
    ?>
px;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calyear_table {
      border-spacing:0;
      width:100%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calmonth_table {	
      border-spacing:0;
      width:100%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calbg,
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calbg td {
      text-align:center;
      width:14%;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_other_months {
      color:<?php 
    echo $text_color_other_months;
    ?>
;
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      vertical-align:top;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .caltext_color_this_month_unevented {
      color:<?php 
    echo $text_color_this_month_unevented;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calfont_year {
      font-size:24px;
      font-weight:bold;
      color:<?php 
    echo $text_color_year;
    ?>
;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .calsun_days {
      color:<?php 
    echo $sun_days;
    ?>
;
      border:1px solid <?php 
    echo $cell_border_color;
    ?>
 !important;
      vertical-align:top;
      text-align:left;
      background-color: <?php 
    echo $sundays_bg_color;
    ?>
 !important;
    }
    #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views {
      float: right;
      background-color: <?php 
    echo $views_tabs_bg_color;
    ?>
 !important;
      min-height: 25px;
      min-width: 70px;
      margin-left: 2px;
      text-align: center;
      cursor:pointer;
      position: relative;
      top: 5px;
    }
	
	 #bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views span{
		padding: 7px;
	}
	
#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 .views_select ,
#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 #views_select
{
background-color: <?php 
    echo $views_tabs_bg_color;
    ?>
 !important;
width: 120px;
text-align: center;
cursor: pointer;
padding: 6px;
position: relative;
}

#bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
 #views_select
{
min-height: 30px;
}

#drop_down_views
{
	list-style-type:none !important;
	display:none;
	z-index: 4545;
	position: absolute;
	left: 0 !important;
    margin-left: 0;
}

#drop_down_views >li:hover .views_select, #drop_down_views >li.active .views_select
{
	background:<?php 
    echo $bg_top;
    ?>
 !important;
}

#drop_down_views >li
{
	border-bottom:1px solid #fff !important;
}


#views_tabs_select 
{
	display:none;
}
	#cal_event p{
	color:#<?php 
    echo $ev_color;
    ?>
}
  </style>
  <?php 
    $activedate = explode('/', $header_format);
    for ($i = 0; $i < count($activedate); $i++) {
        if ($activedate[$i] == 'w') {
            $activedate[$i] = 'l';
        }
        if ($activedate[$i] == 'm') {
            $activedate[$i] = 'F';
        }
        if ($activedate[$i] == 'y') {
            $activedate[$i] = 'Y';
        }
    }
    $activedatestr = "";
    for ($i = 0; $i < count($activedate); $i++) {
        $activedatestr .= $activedate[$i];
    }
    $dateformat_arrays = array("dFY", "dYF", "FYd", "FdY", "YdF", "YFd");
    $dates_formats = array(__($month, 'sp_calendar') . ' ' . $year, $year . ' ' . __($month, 'sp_calendar'), __($month, 'sp_calendar') . ' ' . $year, __($month, 'sp_calendar') . ' ' . $year, $year . ' ' . __($month, 'sp_calendar'), $year . ' ' . __($month, 'sp_calendar'));
    for ($i = 0; $i < count($dateformat_arrays); $i++) {
        if (strpos($activedatestr, $dateformat_arrays[$i]) !== false) {
            $name_year = $dates_formats[$i];
        }
    }
    ?>
  <div  id="afterbig<?php 
    echo $many_sp_calendar;
    ?>
" style="<?php 
    echo $display;
    ?>
">
  <div style="width:100%;">
    <table cellpadding="0" cellspacing="0" style="width:100%;">
      <tr>
        <td>		
          <div id="views_tabs" style="<?php 
    echo $display;
    ?>
;width: 100%;">
            <div class="views" style="<?php 
    if (!in_array('day', $views) and $defaultview != 'day') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarday') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Day', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('week', $views) and $defaultview != 'week') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarweek') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_week', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'months' => $prev_month . ',' . $this_month . ',' . $next_month, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Week', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('list', $views) and $defaultview != 'list') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarlist') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_list', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('List', 'sp_calendar');
    ?>
</span>
            </div>
            <div class="views" style="<?php 
    if (!in_array('month', $views) and $defaultview != 'month') {
        echo 'display:none;';
    }
    if ($view == 'bigcalendarmonth') {
        echo 'background-color:' . $bg_top . ' !important;top:0;';
    }
    ?>
"
              onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget, 'rand' => $many_sp_calendar), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" ><span style="color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px"><?php 
    echo __('Month', 'sp_calendar');
    ?>
</span>
            </div>
          </div>

<div id="views_tabs_select" style="display:none" >
<div  id="views_select" style="background-color:<?php 
    echo $bg_top;
    ?>
 !important;color:<?php 
    echo $views_tabs_text_color;
    ?>
 !important;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">
<?php 
    if ($view == 'bigcalendarday') {
        echo 'Day';
    }
    if ($view == 'bigcalendarmonth') {
        echo 'Month';
    }
    if ($view == 'bigcalendarweek') {
        echo 'Week';
    }
    if ($view == 'bigcalendarlist') {
        echo 'List';
    }
    ?>
<div class="arrow-right show_arrow"></div>
<div class="arrow-down"></div>
</div>
<ul id="drop_down_views" style="float: left;top: inherit;left: -20px;margin-top: 0px;">
<li <?php 
    if ($view == 'bigcalendarday') {
        ?>
 class="active" <?php 
    }
    ?>
  style="<?php 
    if (!in_array('day', $views) and $defaultview != 'day') {
        echo 'display:none;';
    }
    ?>
">
<div class="views_select"   
				onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_day', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"  >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Day</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarweek') {
        ?>
 class="active" <?php 
    }
    ?>
 style="<?php 
    if (!in_array('week', $views) and $defaultview != 'week') {
        echo 'display:none;';
    }
    ?>
" ><div class="views_select"  
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_week', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'months' => $prev_month . ',' . $this_month . ',' . $next_month, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . date('d'), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')">
	<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Week</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarlist') {
        ?>
 class="active" <?php 
    }
    ?>
 style="<?php 
    if (!in_array('list', $views) and $defaultview != 'list') {
        echo 'display:none;';
    }
    ?>
"><div class="views_select"   
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_list', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">List</span>
</div>
</li>

<li <?php 
    if ($view == 'bigcalendarmonth') {
        ?>
 class="active" <?php 
    }
    ?>
  style="<?php 
    if (!in_array('month', $views) and $defaultview != 'month') {
        echo 'display:none;';
    }
    ?>
"><div class="views_select"   
			onclick="showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
', '<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" >
<span style="position:relative;top:25%;color:<?php 
    echo $views_tabs_text_color;
    ?>
;font-size:<?php 
    echo $views_tabs_font_size;
    ?>
px">Month</span></div></li>

</ul>
</div>
        </td>
      </tr>
      <tr>
        <td>
          <table cellpadding="0" cellspacing="0" class="general_table"  style="border-spacing:0; width:100%;border:<?php 
    echo $border_color;
    ?>
 solid <?php 
    echo $border_width;
    ?>
px; margin:0; padding:0;background-color:<?php 
    echo $bg_bottom;
    ?>
 !important;">
            <tr>
              <td width="100%" style="padding:0; margin:0;">
                <table cellpadding="0" cellspacing="0" border="0" style="border-spacing:0; font-size:12px; margin:0; padding:0; width:100%;">
                  <tr style="height:40px; width:100%;">
                    <td class="top_table" align="center" colspan="7" style="z-index: 5;position: relative;background-image:url('<?php 
    echo plugins_url('/images/Stver.png', __FILE__);
    ?>
');padding:0; margin:0; background-color:<?php 
    echo $bg_top;
    ?>
;height:20px; background-repeat: no-repeat;background-size: 100% 100%;">
                      <table cellpadding="0" cellspacing="0" border="0" align="center" class="calyear_table" style="margin:0; padding:0; text-align:center; width:100%; height:<?php 
    echo $top_height;
    ?>
px;">
                        <tr>
                          <td width="15%">
                            <div onclick="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year - 1 . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="text-align:center; cursor:pointer; width:100%; background-color:#000000; filter:alpha(opacity=30); opacity:0.3;">
                              <span style="font-size:18px;color:#FFF"><?php 
    echo $year - 1;
    ?>
</span>
                            </div>
                          </td>
                          <td class="cala_arrow" width="15%" style="text-align:right;margin:0px;padding:0px">
                            <a style="text-shadow: 1px 1px 2px black;color:<?php 
    echo $color_arrow_month;
    ?>
;" href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    if (Month_num($month) == 1) {
        $needed_date = $year - 1 . '-12';
    } else {
        $needed_date = $year . '-' . add_0(Month_num($month) - 1);
    }
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><div class="arrow-left"></div>
                            </a>
                          </td>
                          <td style="text-align:center; margin:0;" width="40%">
                            <input type="hidden" name="month" readonly="" value="<?php 
    echo $month;
    ?>
"/>
                            <span style="line-height: 30px;font-family:arial; color:<?php 
    echo $text_color_month;
    ?>
; font-size:<?php 
    echo $month_font_size;
    ?>
px;text-shadow: 1px 1px  black;"><?php 
    echo $name_year;
    ?>
</span>
                          </td>
                          <td style="margin:0; padding:0;text-align:left" width="15%" class="cala_arrow">
                            <a style="text-shadow: 1px 1px 2px black;color:<?php 
    echo $color_arrow_month;
    ?>
" href="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    if (Month_num($month) == 12) {
        $needed_date = $year + 1 . '-01';
    } else {
        $needed_date = $year . '-' . add_0(Month_num($month) + 1);
    }
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $needed_date, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')"><div class="arrow-right"></div>
                            </a>
                          </td>
                          <td width="15%">
                            <div onclick="javascript:showbigcalendar('bigcalendar<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo add_query_arg(array('action' => 'spiderbigcalendar_' . $defaultview, 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year + 1 . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
    ?>
','<?php 
    echo $many_sp_calendar;
    ?>
','<?php 
    echo $widget;
    ?>
')" style="text-align:center; cursor:pointer; width:100%; background-color:#000000; filter:alpha(opacity=30); opacity:0.3;">
                              <span style="font-size:18px;color:#FFF"><?php 
    echo $year + 1;
    ?>
</span>
                            </div>
                          </td>
                        </tr>
                      </table>
                    </td>
                  </tr>
                  <tr align="center" height="<?php 
    echo $week_days_cell_height;
    ?>
" style="background-color:<?php 
    echo $weekdays_bg_color;
    ?>
 !important;">
                    <?php 
    if ($weekstart == "su") {
        ?>
                      <td class="weekdays" style="width:14.2857143%; color:<?php 
        echo $color_week_days;
        ?>
; margin:0; padding:0;background-color:<?php 
        echo $weekday_sunday_bg_color;
        ?>
 !important">
                        <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
        echo __('Su', 'sp_calendar');
        ?>
 </b></div>
                      </td>
                    <?php 
    }
    ?>
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
    echo __('Mo', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
    echo __('Tu', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
    echo __('We', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center;margin:0; padding:0;"><b class="week_days"><?php 
    echo __('Th', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center;margin:0; padding:0;"><b class="week_days"><?php 
    echo __('Fr', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <td class="weekdays" style="width:14.2857143%;	color:<?php 
    echo $color_week_days;
    ?>
; margin:0; padding:0">
                      <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
    echo __('Sa', 'sp_calendar');
    ?>
 </b></div>
                    </td>
                    <?php 
    if ($weekstart == "mo") {
        ?>
			 
                    <td class="weekdays" style="width:14.2857143%; color:<?php 
        echo $color_week_days;
        ?>
; margin:0; padding:0;background-color:<?php 
        echo $weekday_sunday_bg_color;
        ?>
 !important">
                      <div class="calbottom_border" style="text-align:center; margin:0; padding:0;"><b class="week_days"><?php 
        echo __('Su', 'sp_calendar');
        ?>
 </b></div>
                    </td>
                    <?php 
    }
    ?>
                  </tr>
  <?php 
    $month_first_weekday = date("N", mktime(0, 0, 0, Month_num($month), 1, $year));
    if ($weekstart == "su") {
        $month_first_weekday++;
        if ($month_first_weekday == 8) {
            $month_first_weekday = 1;
        }
    }
    $month_days = date("t", mktime(0, 0, 0, Month_num($month), 1, $year));
    $last_month_days = date("t", mktime(0, 0, 0, Month_num($month) - 1, 1, $year));
    $weekday_i = $month_first_weekday;
    $last_month_days = $last_month_days - $weekday_i + 2;
    $percent = 1;
    $sum = $month_days - 8 + $month_first_weekday;
    if ($sum % 7 != 0) {
        $percent = $percent + 1;
    }
    $sum = $sum - $sum % 7;
    $percent = $percent + $sum / 7;
    $percent = 107 / $percent;
    $all_calendar_files = php_getdays($show_numbers_for_events, $calendar_id, $date, $theme_id, $widget);
    $array_days = $all_calendar_files[0]['array_days'];
    $array_days1 = $all_calendar_files[0]['array_days1'];
    $title = $all_calendar_files[0]['title'];
    $ev_ids = $all_calendar_files[0]['ev_ids'];
    $categories = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercalendar_event_category WHERE published=1");
    $calendar = isset($_GET['calendar']) ? $_GET['calendar'] : '';
    echo '          <tr id="days"  height="' . $cell_height . '" style="line-height:15px;">';
    for ($i = 1; $i < $weekday_i; $i++) {
        echo '          <td class="caltext_color_other_months" style="background-color:' . $bg_color_other_months . ' !important">
                      <span style="font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family: tahoma;padding-left: 5px;">' . $last_month_days . '</span>
                    </td>';
        $last_month_days = $last_month_days + 1;
    }
    ///////////////////////////////////////////////////////////////////////
    function category_color($event_id)
    {
        global $wpdb;
        $calendar = isset($_GET['calendar']) ? $_GET['calendar'] : '';
        $query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercalendar_event_category.color AS color FROM " . $wpdb->prefix . "spidercalendar_event  JOIN " . $wpdb->prefix . "spidercalendar_event_category ON " . $wpdb->prefix . "spidercalendar_event.category=" . $wpdb->prefix . "spidercalendar_event_category.id WHERE " . $wpdb->prefix . "spidercalendar_event.calendar=%d AND  " . $wpdb->prefix . "spidercalendar_event.published='1' AND " . $wpdb->prefix . "spidercalendar_event_category.published='1' AND " . $wpdb->prefix . "spidercalendar_event.id=%d", $calendar, $event_id);
        $colors = $wpdb->get_results($query);
        if (!empty($colors)) {
            $color = $colors[0]->color;
        } else {
            $color = "";
        }
        $theme_id = isset($_GET['theme_id']) ? (int) $_GET['theme_id'] : '';
        return '#' . $color;
    }
    function style($title, $color)
    {
        $new_title = html_entity_decode(strip_tags($title));
        $number = $new_title[0];
        $first_letter = $new_title[1];
        $ev_title = $title;
        $color = str_replace('#', '', $color);
        $bg_color = 'rgba(' . HEXDEC(SUBSTR($color, 0, 2)) . ',' . HEXDEC(SUBSTR($color, 2, 2)) . ',' . HEXDEC(SUBSTR($color, 4, 2)) . ',0.3' . ')';
        $event = '<div id="cal_event"  style="background-color:' . $bg_color . ' !important;border-left:2px solid #' . $color . ' "><p class="ev_name">' . $ev_title . '</p></div>';
        return $event;
    }
    /////////////////////////////////////////////////////////////////////////////
    for ($i = 1; $i <= $month_days; $i++) {
        if (isset($title[$i])) {
            $ev_title = explode('</p>', $title[$i]);
            array_pop($ev_title);
            $k = count($ev_title);
            $ev_id = explode('<br>', $ev_ids[$i]);
            array_pop($ev_id);
            $ev_ids_inline = implode(',', $ev_id);
        } else {
            $k = 0;
        }
        $dayevent = '';
        if ($weekday_i % 7 == 0 and $weekstart == "mo" or $weekday_i % 7 == 1 and $weekstart == "su") {
            if ($i == $day_REFERER and $month == $month_REFERER and $year == $year_REFERER) {
                echo '      <td class="cala_day" style="padding:0; margin:0;line-height:15px;">
                      <div class="calborder_day" style=" margin:0; padding:0;">
                        <p style="font-size:' . $other_days_font_size . 'px;color:' . $evented_color . ';line-height:1.3;font-family: tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>';
                $r = 0;
                echo '          <div style="background-color:' . $ev_title_bg_color . ' !important;">';
                for ($j = 0; $j < $k; $j++) {
                    if (category_color($ev_id[$j]) == '#') {
                        $cat_color = $bg_top;
                    } else {
                        $cat_color = category_color($ev_id[$j]);
                    }
                    if ($r < $number_of_shown_evetns) {
                        echo '        <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="background:none;color:' . $event_title_color . ';"
                            href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height, 'cat_id' => $cat_ids), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                          </a>';
                    } else {
                        echo '       
                          <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px; background:none; color:' . $event_title_color . '; text-align:center;"
                            href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                          </a>';
                        break;
                    }
                    $r++;
                }
                echo '          </div>
                      </div>
                    </td>';
            } else {
                if ($i == date('j') and $month == date('F') and $year == date('Y')) {
                    if (!isset($border_day)) {
                        $border_day = "";
                    }
                    if ($i == date('j') and $month == date('F') and $year == date('Y')) {
                        $border_day = $current_day_border_color;
                    }
                    if (in_array($i, $array_days)) {
                        echo '      <td class="cala_day" style="background-color:' . $ev_title_bg_color . ' !important;padding:0; margin:0;line-height:15px; border: 3px solid ' . $current_day_border_color . ' !important">
                        <p style="background-color:' . $evented_color_bg . ' !important;color:' . $evented_color . ' !important;font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>';
                        $r = 0;
                        echo '        <div style="background-color:' . $ev_title_bg_color . ' !important">';
                        for ($j = 0; $j < $k; $j++) {
                            if (category_color($ev_id[$j]) == '#') {
                                $cat_color = $bg_top;
                            } else {
                                $cat_color = category_color($ev_id[$j]);
                            }
                            if ($r < $number_of_shown_evetns) {
                                echo '      <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="background:none;color:' . $event_title_color . ';"
                            href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                          </a>';
                            } else {
                                echo '      
                          <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px;background:none;color:' . $event_title_color . ';text-align:center;"
                            href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                          </a>';
                                break;
                            }
                            $r++;
                        }
                        echo '        </div>
                      </td>';
                    } else {
                        echo '      <td class="calsun_days" style="padding:0; font-size:' . $sundays_font_size . 'px; margin:0;line-height:1.3;font-family:tahoma;padding-left: 5px; border: 3px solid ' . $current_day_border_color . ' !important">
                        <b>' . $i . '</b>
                      </td>';
                    }
                } else {
                    if (in_array($i, $array_days)) {
                        echo '        <td class="cala_day" style="background-color:' . $ev_title_bg_color . ' !important;padding:0; margin:0;line-height:15px;">
                        <p style="background-color:' . $evented_color_bg . ' !important;color:' . $evented_color . ';font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>
                        <div style="background-color:' . $ev_title_bg_color . ' !important">';
                        $r = 0;
                        for ($j = 0; $j < $k; $j++) {
                            if (category_color($ev_id[$j]) == '#') {
                                $cat_color = $bg_top;
                            } else {
                                $cat_color = category_color($ev_id[$j]);
                            }
                            if ($r < $number_of_shown_evetns) {
                                echo '       <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="background:none; color:' . $event_title_color . ' !important;"
                            href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                          </a>';
                            } else {
                                echo '        
                          <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px; background:none; color:' . $event_title_color . ' !important;text-align:center;"
                            href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                          </a>';
                                break;
                            }
                            $r++;
                        }
                        echo '          </div>
                      </td>';
                    } else {
                        echo '        <td class="calsun_days" style="padding:0; margin:0;line-height:1.3;font-family: tahoma;padding-left: 5px;font-size:' . $sundays_font_size . 'px">
                        <b>' . $i . '</b>
                      </td>';
                    }
                }
            }
        } else {
            if ($i == $day_REFERER and $month == $month_REFERER and $year == $year_REFERER) {
                echo '          <td bgcolor="' . $ev_title_bg_color . '" class="cala_day" style="border: 3px solid ' . $current_day_border_color . ' !important;padding:0; margin:0;line-height:15px;">
                        <div class="calborder_day" style="margin:0; padding:0;">
                          <p style="background-color:' . $evented_color_bg . ' !important;color:' . $evented_color . ' !important;font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family: tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>
                          <div style="background-color:' . $ev_title_bg_color . ' !important">';
                $r = 0;
                for ($j = 0; $j < $k; $j++) {
                    if (category_color($ev_id[$j]) == '#') {
                        $cat_color = $bg_top;
                    } else {
                        $cat_color = category_color($ev_id[$j]);
                    }
                    if ($r < $number_of_shown_evetns) {
                        echo '            <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="background:none; color:' . $event_title_color . ' !important;"
                              href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                            </a>';
                    } else {
                        echo '       
                            <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px; background:none; color:' . $event_title_color . ';text-align:center;"
                              href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                            </a>';
                        break;
                    }
                    $r++;
                }
                echo '            </div>
                        </div>
                      </td>';
            } else {
                if ($i == date('j') and $month == date('F') and $year == date('Y')) {
                    if (in_array($i, $array_days)) {
                        echo '   <td class="cala_day" style="background-color:' . $ev_title_bg_color . ' !important;padding:0; margin:0;line-height:15px; border: 3px solid ' . $current_day_border_color . ' !important;">
                        <p style="background-color:' . $evented_color_bg . ' !important;color:' . $evented_color . ';font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>
                        <div style="background-color:' . $ev_title_bg_color . ' !important">';
                        $r = 0;
                        for ($j = 0; $j < $k; $j++) {
                            if (category_color($ev_id[$j]) == '#') {
                                $cat_color = $bg_top;
                            } else {
                                $cat_color = category_color($ev_id[$j]);
                            }
                            if ($r < $number_of_shown_evetns) {
                                echo '    <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="background:none; color:' . $event_title_color . ';"
                            href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                          </a>';
                            } else {
                                echo '    
                          <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px; background:none;color:' . $event_title_color . ';text-align:center;"
                            href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                          </a>';
                                break;
                            }
                            $r++;
                        }
                        echo '      </div>
                      </td>';
                    } else {
                        echo '    <td style="color:' . $text_color_this_month_unevented . ';padding:0; margin:0; line-height:15px; border: 3px solid ' . $current_day_border_color . ' !important; vertical-align:top;">
                        <p style="font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family: tahoma;padding-left: 5px;">' . $i . '</p>
                      </td>';
                    }
                } else {
                    if (in_array($i, $array_days)) {
                        echo '      <td class="cala_day" style="background-color:' . $ev_title_bg_color . ' !important;padding:0; margin:0;line-height:15px;">
                        <p style="background-color:' . $evented_color_bg . ' !important;background-color:' . $evented_color_bg . ' !important;color:' . $evented_color . ' !important;font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;text-shadow: 1px 1px white;">' . $i . '</p>';
                        $r = 0;
                        echo '        <div>';
                        for ($j = 0; $j < $k; $j++) {
                            if (category_color($ev_id[$j]) == '#') {
                                $cat_color = $bg_top;
                            } else {
                                $cat_color = category_color($ev_id[$j]);
                            }
                            if ($r < $number_of_shown_evetns) {
                                echo '      <a class="thickbox-previewbigcalendar' . $many_sp_calendar . '"  style="background:none; color:' . $event_title_color . ';"
                            href="' . add_query_arg(array('action' => 'spidercalendarbig', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'eventID' => $ev_id[$j], 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . style($ev_title[$j], $cat_color) . '</b>
                          </a>';
                            } else {
                                echo '      <p><a class="thickbox-previewbigcalendar' . $many_sp_calendar . '" style="font-size:11px; background:none; color:' . $event_title_color . ';text-align:center;"
                            href="' . add_query_arg(array('action' => 'spiderseemore', 'theme_id' => $theme_id, 'calendar_id' => $calendar_id, 'ev_ids' => $ev_ids_inline, 'date' => $year . '-' . add_0(Month_num($month)) . '-' . $i, 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'widget' => $widget, 'TB_iframe' => 1, 'tbWidth' => $popup_width, 'tbHeight' => $popup_height), $site_url) . '"><b>' . __('See more', 'sp_calendar') . '</b>
                          </a></p>';
                                break;
                            }
                            $r++;
                        }
                        echo '        </div>
                      </td>';
                    } else {
                        echo '        <td style=" color:' . $text_color_this_month_unevented . ';padding:0; margin:0; line-height:15px;border: 1px solid ' . $cell_border_color . ' !important;vertical-align:top;">
                        <p style="font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;">' . $i . '</p>
                      </td>';
                    }
                }
            }
        }
        if ($weekday_i % 7 == 0 && $i != $month_days) {
            echo '        </tr>
                    <tr height="' . $cell_height . '" style="line-height:15px">';
            $weekday_i = 0;
        }
        $weekday_i += 1;
    }
    $weekday_i;
    $next_i = 1;
    if ($weekday_i != 1) {
        for ($i = $weekday_i; $i <= 7; $i++) {
            if ($i != 7) {
                echo '        <td class="caltext_color_other_months" style="font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;background-color:' . $bg_color_other_months . ' !important;">' . $next_i . '</td>';
            } else {
                echo '        <td class="caltext_color_other_months" style="font-size:' . $other_days_font_size . 'px;line-height:1.3;font-family:tahoma;padding-left: 5px;background-color:' . $bg_color_other_months . ' !important;">' . $next_i . '</td>';
            }
            $next_i += 1;
        }
    }
    echo '            </tr>
                  </table>';
    ?>
            <input type="text" value="1" name="day" style="display:none" />
              </td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
  <style>  
  @media only screen and (max-width : 640px) { 
	#views_tabs ,#drop_down_views
	{
		display:none;
	}

	#views_tabs_select
	{
		display:block !important;
	}
	}

	@media only screen and (max-width : 968px) { 
		#cats >li
		{
			float:none;
		}
	}
   
    .spider_categories{
		display:inline-block;
		cursor:pointer;
	}
	
	.spider_categories p{
		color: #fff;
		padding: 2px 10px !important;
		margin: 2px 0 !important;
		font-size: 14px;
	}
  </style>
  <?php 
    //reindex cat_ids_array
    $re_cat_ids_array = array_values($cat_ids_array);
    for ($i = 0; $i < count($re_cat_ids_array); $i++) {
        echo '
<style>
#cats #category' . $re_cat_ids_array[$i] . '
{
	text-decoration:underline;
	cursor:pointer;

}

</style>';
    }
    if ($cat_ids == '') {
        $cat_ids = '';
    }
    if ($show_cat) {
        echo '<ul id="cats" style="list-style-type:none;">';
        foreach ($categories as $category) {
            ?>

<li class="spider_categories"><p id="category<?php 
            echo $category->id;
            ?>
" style="background-color:#<?php 
            echo str_replace('#', '', $category->color);
            ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
            echo $many_sp_calendar;
            ?>
', '<?php 
            echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => $category->id, 'cat_ids' => $cat_ids, 'widget' => $widget), $site_url);
            ?>
','<?php 
            echo $many_sp_calendar;
            ?>
','<?php 
            echo $widget;
            ?>
')"> <?php 
            echo $category->title;
            ?>
</p></li>


<?php 
        }
        if (!empty($categories)) {
            ?>
<li class="spider_categories"><p id="category0" style="background-color:#<?php 
            echo str_replace('#', '', $bg_top);
            ?>
 !important" onclick="showbigcalendar('bigcalendar<?php 
            echo $many_sp_calendar;
            ?>
', '<?php 
            echo add_query_arg(array('action' => 'spiderbigcalendar_month', 'theme_id' => $theme_id, 'calendar' => $calendar_id, 'select' => $view_select, 'date' => $year . '-' . add_0(Month_num($month)), 'many_sp_calendar' => $many_sp_calendar, 'cur_page_url' => $path_sp_cal, 'cat_id' => '', 'cat_ids' => '', 'widget' => $widget), $site_url);
            ?>
','<?php 
            echo $many_sp_calendar;
            ?>
','<?php 
            echo $widget;
            ?>
')"><?php 
            echo __('All categories', 'sp_calendar');
            ?>
</p></li>
<?php 
        }
        echo '</ul>';
    }
    die;
}