Having Problem with Date

[christalix]

l have  a submit buttom where user have the possibility to add a date to specify when his  message should be made reachable online.

 

I have seen a bug which l am not having a clue to solve and l need help.

 

Any time  a user tries to edit his text, the edit formular opens with a given dateon 1999.11.30 and a dateof of 1999.11.30

 

For God sake l got no clue where these date digits are coming from.

This outdated problem doesn´t allow ediiting to save well.

 

Enclosed is my code.

 

MAybe one could figure out where l am going wrong.

 

 

Thanks in advance

 

if(isset($_POST['save'])) {
	// Saving Edited Formular

		$message = "";
		$maintext = htmlentities($_POST['maintext']);
		$shorttext = $_POST['shorttext'];
		$title = htmlentities($_POST['title']);
		$linked = $_POST['linked'];
		$dateon = ($_POST['startdate']);
		$dateoff = ($_POST['enddate']);

		if($lang == "ger") {
			if(! empty($dateon)) {
				$on = explode(".", $dateon);
				if(count($on) == 3 && checkdate($on[1], $on[0], $on[2]))
					$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[0], $on[2]));
				else
					$status = 5;
			}
			if(! empty($dateoff)) {
			$off = explode(".", $dateoff);
			if(count($off) == 3 && checkdate($off[1], $off[0], $off[2]))
				$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[0], $off[2]));
			else
				$status = 5;

			}
		}
		else if ($lang != "ger") {
			if(!empty($dateon)) {
				$on = explode(".", $dateon);
				if(count($on) == 3 && checkdate($on[1], $on[2], $on[0]))
					$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
				else
					$status = 5;
			}

			if(!empty($dateoff)) {
				$off = explode(".", $dateoff);
				if(count($off) == 3 && checkdate($off[1], $off[2], $off[0]))
					$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
				else
					$status = 5;
			}
		}
		if(empty($status)) {
			if(isset($parent)) {
				$resDate = my_sql_query("SELECT date_on, date_off FROM navi WHERE nid=$parent", "");
				if(isset($resDate[0]))
					$status = 2;
				$catDateOn = $resDate[1][0]['date_on'];
				$catDateOff = $resDate[1][0]['date_off'];
			}
			if(!empty($catDateOn) && !empty($dateon) && $catDateOn > $dateon) {
				$status = 7;
			}
			else if(!empty($catDateOff) && !empty($dateoff) && $catDateOff < $dateoff) {
				$status = 8;
			}
			else if($dateon != "" && $dateoff != "" && $dateon > $dateoff) {
				$status = 9;
			}

 

The Html Formular

 

$result = my_sql_query("SELECT date_on, date_off FROM navi WHERE nid=$sel AND is_campaign IS NOT NULL","");
		if(!isset($result[0])) {
			#$dateon = $result[1][0]["date_on"];
			#$dateoff = $result[1][0]['date_off'];
			if($lang == "ger") {
				if($dateon != "") {
					$on = explode("-", $dateon);
					if(count($on) == 3)
						$dateon = date("d.m.Y", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
				}
				if($dateoff != "") {
					$off = explode("-", $dateoff);
					if(count($off) == 3)
						$dateoff = date("d.m.Y", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
				}
			} else {
				if($dateon != "") {
					$on = explode("-", $dateon);
					if(count($on) == 3)
						$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
				}
				if($dateoff != "") {
					$off = explode("-", $dateoff);
					if(count($off) == 3)
						$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
				}
			}
		}

		echo "<tr>\n"
			."<td width='10%'></td>\n"
			."<td width='800px' align='center' colspan='3'><br />"._FROM."&nbsp<input name='startdate' type='text' value='$dateon' size='15' maxlength='10'>  "._TO."&nbsp<input name='enddate' type='text' value='$dateoff' size='15' maxlength='10'</td>\n"
			."<td width='10%'></td>\n"
			."</tr>\n"
			."<tr>\n"
			."<td width='10%'></td>\n"
			."<td width='800px' align='center' colspan='3'><br /><input type='submit' name='save' value='"._SAVE."' id='button'>  <input type='submit' name='reset3' value='"._RESET."' id='button'></td>\n"
			#."<td width='10%'></td>\n"
			."</tr>\n";

		echo "</table><br /></td></tr></table><br /><br /><br />\n"
			."</div>\n"
			."</form>\n";
		echo "<script>document.form1.title.focus();</script>\n";
		echo "<script>textCounter(document.form1.shorttext, document.form1.countChars, $numberChars);</script>";