/* Check if they're changing the user's assigned lesson and do the deed - RAM */
if ( isset ($_POST['whichclass']) ) {
	$newCurrentLesson = selectObject ('ccs_music_lessons', 'lesson_id='.intval($_POST['lesson_id']));
	$sql = "SELECT t1.lesson_number AS lesson_number, t2.class_number AS class_number FROM ccs_music_lessons AS t1 JOIN ccs_music_classes AS t2 ON t1.class_id = t2.class_id WHERE t1.lesson_id=".$newCurrentLesson->lesson_id;
	$result = mysql_query ( $sql, $ccs_con );
	$newlessnum = mysql_fetch_assoc ( $result );
	$sql = "SELECT t1.lesson_number AS lesson_number, t2.class_number AS class_number, t1.lesson_id AS lesson_id, t2.class_id AS class_id FROM ccs_music_lessons AS t1 JOIN ccs_music_classes AS t2 ON t1.class_id = t2.class_id WHERE (t2.class_number > ".$newlessnum['class_number'].") OR (t2.class_number = ".$newlessnum['class_number']." AND t1.lesson_number > ".$newlessnum['lesson_number'].") ORDER BY t2.class_number ASC, t1.lesson_number ASC";
	$result = mysql_query ( $sql, $ccs_con );
	if ( mysql_num_rows ($result) > 1 ) {
		while ( $row = mysql_fetch_assoc ($result) ) {
			$deletesql = "DELETE FROM ccs_opened_lessons WHERE customers_id=".intval($_GET['history_id']). " AND lesson_id = " . $row['lesson_id'];
			mysql_query ( $deletsql, $ccs_con );
			$updatesql = "UPDATE ccs_opened_classes SET date_opened = 0000-00-00 WHERE class_id=".$row['class_id']." AND customers_id=".intval($_GET['history_id']);
			mysql_query ( $updatesql, $ccs_con );
			
		}
	}
	$curdate = date("Y-m-d");
	$daysToSetBack = $newCurrentLesson->lesson_number * 7;
	$backDate = strtotime ("-$daysToSetBack days", $curdate);
	$sql = "SELECT t1.lesson_number AS lesson_number, t2.class_number AS class_number, t1.lesson_id AS lesson_id, t2.class_id AS class_id FROM ccs_music_lessons AS t1 JOIN ccs_music_classes AS t2 ON t1.class_id = t2.class_id WHERE (t2.class_number < ".$newlessnum['class_number'].") OR (t2.class_number = ".$newlessnum['class_number']." AND t1.lesson_number < ".$newlessnum['lesson_number'].") ORDER BY t2.class_number ASC, t1.lesson_number ASC";
	$result = mysql_query ( $sql, $ccs_con );
	if ( mysql_num_rows( $result ) ) {
		while ( $row = mysql_fetch_assoc ( $result ) ) {
			$resetsql = "UPDATE ccs_opened_lessons SET opening_date = $backDate WHERE customers_id=".intval($_GET['history_id'])." AND lesson_id=".$row['lesson_id'];
			mysql_query ( $resetsql, $ccs_con );
			$reset2sql = "UPDATE ccs_opened_classes SET date_opened = $backDate WHERE customers_id=".intval($_GET['history_id'])." AND class_id=".$row['class_id'];
			mysql_query ( $reset2sql, $ccs_con );
		}
	}
	// Reference query.
	//$sql = "SELECT t1.lesson_number AS lesson_number, t2.class_number AS class_number, t1.lesson_id AS lesson_id, t2.class_id AS class_id FROM ccs_opened_classes AS t JOIN ccs_music_lessons AS t1 ON t.class_id = t1.class_id JOIN ccs_music_classes AS t2 ON t1.class_id = t2.class_id WHERE t.customers_id=".intval($_GET['history_id'])." ORDER BY t2.class_number ASC, t1.lesson_number ASC";
	
}