From ad6ba256efd1a65fb1bb3951ae6b17b1593205b7 Mon Sep 17 00:00:00 2001 From: jhunkeler Date: Tue, 29 Dec 2009 05:36:23 +0000 Subject: (OC) Fixed includes/functions::GetBlocks() so that left and right are 0 and 1. Also fixed the query so that it doesnt get every block, just the active blocks for the defined side. Re-did some display on the admin side for blocks. git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@408 c5b2fb0a-d05d-0410-98c8-828840a80ff6 --- admin/calendar/functions.php | 881 +++++++++++++++++++++---------------------- 1 file changed, 439 insertions(+), 442 deletions(-) (limited to 'admin/calendar/functions.php') diff --git a/admin/calendar/functions.php b/admin/calendar/functions.php index 9983870..351e5d7 100644 --- a/admin/calendar/functions.php +++ b/admin/calendar/functions.php @@ -1,443 +1,440 @@ -. - */ - -/** - * Note to anyone feeling the need to edit this file... - * You MUST declare $db as global inside your functions in order access MySQL from here. - */ - - /** - * SelectDate($date) - * Function for outputing an html form for selecting a month day and year - * @param date - formatted date string yyyy-mm-dd (optional) - */ - function SelectDate($date = NULL){ - - //function for adding to the db in sql 'datetime' format - //$date = date("Y-m-d h:i:s", mktime(8, 30, 0, 10, 26, 2009)); - //$date = "2009-11-2"; - //echo $date."
"; - //function for parsing our date format into an array - //echo "
";
-	$date_arr = date_parse($date); //returns an associative array $array['year']
-	//print_r($date_arr);
-	//echo "
"; - //echo $date_arr['year']." ".$date_arr['month']." ".$date_arr['day']."
";; - - //List Months - echo '"; - - //List Days - echo '"; - - //List Years [CurYear, CurYear+5] - echo '"; - - } - - function ListEvents($date){ - - global $db; - -?> -
-

Events for:

- 		- Add New Event -
-"; - - $result = $db->Query("SELECT * FROM bayonet_events WHERE `date` = '$date' ORDER BY `time`"); - $row = $db->Fetch($result); - foreach($row as $event) - { - $tmp = true; - - $datetime = date_create($date.' '.$event['time']); - $time = date_format($datetime, 'g:ia'); //gets time in hour:minutes am|pm -?> - - - -      - - Edit -  |  - Delete - - - -

- - - -
- -There are no events posted for this day."; - - echo ""; - - } - - function EditEvent($event_id){ - - //function for adding to the db in sql 'datetime' format - //$date = date("Y-m-d h:i:s", mktime(8, 30, 0, 10, 26, 2009)); - /* - echo $date."
"; - - //function for parsing our date format into an array - echo "
";
-	$date_arr = date_parse($date); //returns an associative array $array['year']
-	print_r($date_arr);
-	echo "
"; - - echo $date_arr['year']; */ - - global $db; - - if(isset($_POST['processed'])){ - $title = addslashes($_POST['title']); - $text = addslashes($_POST['text']); - $year = addslashes($_POST['year']); - $month = addslashes($_POST['month']); - $day = addslashes($_POST['day']); - $time = addslashes($_POST['time']); - $color = addslashes($_POST['color']); - - $date = date("Y-m-d", mktime(0, 0, 0, $month, $day, $year)); - -$db->Query("UPDATE `bayonet_events` SET `title` = '$title', `text` = '$text', `color` = '$color', `date` = '$date', `time` = '$time' WHERE `event_id` ='$event_id' LIMIT 1"); - - } - - $result = $db->Query("SELECT * FROM `bayonet_events` WHERE `event_id` = $event_id LIMIT 1"); - while(($row = $db->Fetch($result))!=false) - { - $event = $row; - } - ?> -

Edit Event

-
- - - - - - - -
Title
Color
Date
Time
Text
-
- Query("INSERT INTO `bayonet_events` (`event_id` ,`date` ,`time` ,`title` ,`text` ,`color`)VALUES (NULL , '$date', '$time', '$title', '$text', '$color')"); - - //echo ''; - } - - - echo "New event, '$title', has been added.\n"; - PageRedirect(2,"?op=calendar"); - //die, because we have completed what we wanted to do. - return; - } - - ?> -

Add New Event

-
- - - - - - - -
Title
Color
Date
Time
Text
-
- Query("SELECT title FROM bayonet_events WHERE event_id = '$event_id'"); - $event = $db->Fetch($result); - - if(isset($_POST['proceed'])) - { - echo "Event '{$event['title']}', was deleted."; - $db->Query("DELETE FROM bayonet_events WHERE event_id = '$event_id' LIMIT 1"); - return; - } - if(isset($_POST['cancel'])) - { - echo "User cancelled deletion of event: '{$event['title']}'"; - return; - } - if($event_id <= 0 || !is_numeric($event_id)) { - echo "Invalid request to delete this event."; - return; - } - ?> - -
- - - -
Are you SURE you want to delete the event titled: ''?
   
-
- 0 && $month < 13 && $year > 1990){ - $useCurDate = false; - } - //check to see if the get variables are for todays month - if($month == date('n', $date) && $year == date('Y', $date)){ - $useCurDate = true; - } - - //use current date unless GET values are set - if($useCurDate) - { - $day = date('d', $date); - $today = date('j', $date); - $month = date('m', $date); - $monthNum = date('n', $date); - $year = date('Y', $date); - } - else - { - $monthNum = $month; - //if GET values are equal to curdate, set $today - if($year == date('Y', $date) && $monthNum == date('n', $date)) - $today = date('j', $date); - else - $today = 0; - } - - /* Accounts for the last couple days from the previous months */ - $first_day = mktime(0,0,0,$monthNum, 1, $year); - - $title = date('F', $first_day); - - $day_of_week = date('D', $first_day); - - switch($day_of_week){ - case "Sun": $blank = 0; break; - case "Mon": $blank = 1; break; - case "Tue": $blank = 2; break; - case "Wed": $blank = 3; break; - case "Thu": $blank = 4; break; - case "Fri": $blank = 5; break; - case "Sat": $blank = 6; break; - } - - /* calculates the days in the current month */ - $days_in_month = cal_days_in_month(0, $monthNum, $year); - - //makes sure that previous year is not year 0 - if($monthNum == 1){ - $previous_month = 12; - $previous_year = $year-1; - }else{ - $previous_month = $monthNum-1; - $previous_year = $year; - } - //makes sure the next year is not year 13 - if($monthNum == 12){ - $next_month = 1; - $next_year = $year+1; - }else{ - $next_month = $monthNum+1; - $next_year = $year; - } - ?> -
- - - - - - - - - - - - 0){ - $blank = $blank-1; - $days_before = $days_monthbefore-$blank; - echo ''; //'.$days_before.''; - $day_count++; - } - - //loop printing each day of the CURRENT month ONLY - while($day_num <= $days_in_month){ - - if($day_count==1 || $day_count==7){ - echo ''; - - $day_num++; - $day_count++; - - if($day_count > 7){ - echo ''; - $day_count = 1; - } - } - - $days_after = 1; - //loop for printing the days for the next month - while($day_count > 1 && $day_count <=7){ - echo ''; //'.$days_after.''; - $days_after++; - $day_count++; - } - - ?> - - -
- << - -      - >> -
SunMonTueWedThuFriSat
'.$days_before.''; //weekends - }else{ - echo ''; //weekdays - } - - $sqlDate = $year.'-'.$monthNum.'-'.$day_num; //old way NOT unix - - //checks to see if the current day has events - $isEvent=false; - /* $get_events = mysql_query("SELECT * FROM `mybb_events` WHERE `starttime` = $checkUnixTime "); - while($echo_events = mysql_fetch_array($get_events)){ - $isEvent=true; - } */ - global $db; - $result = $db->Query("SELECT title,color FROM bayonet_events WHERE `date` = '$sqlDate' LIMIT 1"); - $events = $db->Fetch($result); - $isEvent = empty($events) ? false : true; - - if($useCurDate) - echo ""; - else - echo ""; - - if($day_num == $today && $isEvent==true){ - echo '
'.$day_num.'
'; - }else if($day_num == $today && $isEvent==false){ - echo '
'.$day_num.'
'; - }else if($day_num != $today && $isEvent==true){ - echo '
'; - echo $day_num; - echo '
'; - }else{ - echo $day_num; - } - echo ""; - - echo '
'.$days_after.'
-
-. + */ + +/** + * Note to anyone feeling the need to edit this file... + * You MUST declare $db as global inside your functions in order access MySQL from here. + */ + + /** + * SelectDate($date) + * Function for outputing an html form for selecting a month day and year + * @param date - formatted date string yyyy-mm-dd (optional) + */ + function SelectDate($date = NULL){ + + //function for adding to the db in sql 'datetime' format + //$date = date("Y-m-d h:i:s", mktime(8, 30, 0, 10, 26, 2009)); + //$date = "2009-11-2"; + //echo $date."
"; + //function for parsing our date format into an array + //echo "
";
+	$date_arr = date_parse($date); //returns an associative array $array['year']
+	//print_r($date_arr);
+	//echo "
"; + //echo $date_arr['year']." ".$date_arr['month']." ".$date_arr['day']."
";; + + //List Months + echo '"; + + //List Days + echo '"; + + //List Years [CurYear, CurYear+5] + echo '"; + + } + + function ListEvents($date){ + + global $db; + +?> +
+

Events for:

+ 		+ Add New Event +
+"; + + $result = $db->Query("SELECT * FROM bayonet_events WHERE `date` = '$date' ORDER BY `time`"); + $row = $db->Fetch($result); + foreach($row as $event) + { + $tmp = true; + + $datetime = date_create($date.' '.$event['time']); + $time = date_format($datetime, 'g:ia'); //gets time in hour:minutes am|pm +?> + + + +      + + Edit +  |  + Delete + + + +

+ + + +
+ +There are no events posted for this day."; + + echo ""; + + } + + function EditEvent($event_id){ + + //function for adding to the db in sql 'datetime' format + //$date = date("Y-m-d h:i:s", mktime(8, 30, 0, 10, 26, 2009)); + /* + echo $date."
"; + + //function for parsing our date format into an array + echo "
";
+	$date_arr = date_parse($date); //returns an associative array $array['year']
+	print_r($date_arr);
+	echo "
"; + + echo $date_arr['year']; */ + + global $db; + + if(isset($_POST['processed'])){ + $title = addslashes($_POST['title']); + $text = addslashes($_POST['text']); + $year = addslashes($_POST['year']); + $month = addslashes($_POST['month']); + $day = addslashes($_POST['day']); + $time = addslashes($_POST['time']); + $color = addslashes($_POST['color']); + + $date = date("Y-m-d", mktime(0, 0, 0, $month, $day, $year)); + +$db->Query("UPDATE `bayonet_events` SET `title` = '$title', `text` = '$text', `color` = '$color', `date` = '$date', `time` = '$time' WHERE `event_id` ='$event_id' LIMIT 1"); + + } + + $result = $db->Query("SELECT * FROM `bayonet_events` WHERE `event_id` = $event_id LIMIT 1"); + $event = $db->FetchRow($result); + ?> +

Edit Event

+
+ + + + + + + +
Title
Color
Date
Time
Text
+
+ Query("INSERT INTO `bayonet_events` (`event_id` ,`date` ,`time` ,`title` ,`text` ,`color`)VALUES (NULL , '$date', '$time', '$title', '$text', '$color')"); + + //echo ''; + } + + + echo "New event, '$title', has been added.\n"; + PageRedirect(2,"?op=calendar"); + //die, because we have completed what we wanted to do. + return; + } + + ?> +

Add New Event

+
+ + + + + + + +
Title
Color
Date
Time
Text
+
+ Query("SELECT title FROM bayonet_events WHERE event_id = '$event_id'"); + $event = $db->Fetch($result); + + if(isset($_POST['proceed'])) + { + echo "Event '{$event['title']}', was deleted."; + $db->Query("DELETE FROM bayonet_events WHERE event_id = '$event_id' LIMIT 1"); + return; + } + if(isset($_POST['cancel'])) + { + echo "User cancelled deletion of event: '{$event['title']}'"; + return; + } + if($event_id <= 0 || !is_numeric($event_id)) { + echo "Invalid request to delete this event."; + return; + } + ?> + +
+ + + +
Are you SURE you want to delete the event titled: ''?
   
+
+ 0 && $month < 13 && $year > 1990){ + $useCurDate = false; + } + //check to see if the get variables are for todays month + if($month == date('n', $date) && $year == date('Y', $date)){ + $useCurDate = true; + } + + //use current date unless GET values are set + if($useCurDate) + { + $day = date('d', $date); + $today = date('j', $date); + $month = date('m', $date); + $monthNum = date('n', $date); + $year = date('Y', $date); + } + else + { + $monthNum = $month; + //if GET values are equal to curdate, set $today + if($year == date('Y', $date) && $monthNum == date('n', $date)) + $today = date('j', $date); + else + $today = 0; + } + + /* Accounts for the last couple days from the previous months */ + $first_day = mktime(0,0,0,$monthNum, 1, $year); + + $title = date('F', $first_day); + + $day_of_week = date('D', $first_day); + + switch($day_of_week){ + case "Sun": $blank = 0; break; + case "Mon": $blank = 1; break; + case "Tue": $blank = 2; break; + case "Wed": $blank = 3; break; + case "Thu": $blank = 4; break; + case "Fri": $blank = 5; break; + case "Sat": $blank = 6; break; + } + + /* calculates the days in the current month */ + $days_in_month = cal_days_in_month(0, $monthNum, $year); + + //makes sure that previous year is not year 0 + if($monthNum == 1){ + $previous_month = 12; + $previous_year = $year-1; + }else{ + $previous_month = $monthNum-1; + $previous_year = $year; + } + //makes sure the next year is not year 13 + if($monthNum == 12){ + $next_month = 1; + $next_year = $year+1; + }else{ + $next_month = $monthNum+1; + $next_year = $year; + } + ?> +
+ + + + + + + + + + + + 0){ + $blank = $blank-1; + $days_before = $days_monthbefore-$blank; + echo ''; //'.$days_before.''; + $day_count++; + } + + //loop printing each day of the CURRENT month ONLY + while($day_num <= $days_in_month){ + + if($day_count==1 || $day_count==7){ + echo ''; + + $day_num++; + $day_count++; + + if($day_count > 7){ + echo ''; + $day_count = 1; + } + } + + $days_after = 1; + //loop for printing the days for the next month + while($day_count > 1 && $day_count <=7){ + echo ''; //'.$days_after.''; + $days_after++; + $day_count++; + } + + ?> + + +
+ << + +      + >> +
SunMonTueWedThuFriSat
'.$days_before.''; //weekends + }else{ + echo ''; //weekdays + } + + $sqlDate = $year.'-'.$monthNum.'-'.$day_num; //old way NOT unix + + //checks to see if the current day has events + $isEvent=false; + /* $get_events = mysql_query("SELECT * FROM `mybb_events` WHERE `starttime` = $checkUnixTime "); + while($echo_events = mysql_fetch_array($get_events)){ + $isEvent=true; + } */ + global $db; + $result = $db->Query("SELECT title,color FROM bayonet_events WHERE `date` = '$sqlDate' LIMIT 1"); + $events = $db->Fetch($result); + $isEvent = empty($events) ? false : true; + + if($useCurDate) + echo ""; + else + echo ""; + + if($day_num == $today && $isEvent==true){ + echo '
'.$day_num.'
'; + }else if($day_num == $today && $isEvent==false){ + echo '
'.$day_num.'
'; + }else if($day_num != $today && $isEvent==true){ + echo '
'; + echo $day_num; + echo '
'; + }else{ + echo $day_num; + } + echo ""; + + echo '
'.$days_after.'
+
+ \ No newline at end of file -- cgit