Bans worden niet verwijdert?

[Martijn31]

Hallo,

Ik zat laatst even in mijn database en daar zag ik dat de mensen die van de site zijn verbannen voor een bepaalde reden niet meer worden unbanned als de verbannings tijd is verlopen. Weet iemand hoe ik ervoor zorg dat het wel werkt? ik heb hier een plaatje

http://img534.imageshack.us/img534/9731/verbanning.png

Alvast bedankt.
Mvg Martijn

 

[Frats]

Nee. En zonder code gaat ook niemand iets kunnen zien want dit alleen een display van data, geen functionaliteit.

 

[JP Romijn]

Misschien moet je, om te kunnen rekenen met de datum, het datatype date gebruiken? Misschien is je datum nu niet de juiste notatie. Deze kan verschillen met je script taal.

 

[Martijn31]

Ik heb hier de code die de ban uitdeelt. Mischien moet daarin wat aangepast worden?

case "savebans":
	$length = $_POST['length'];
	$ip = $_POST['ip'];
	$userid = $_POST['user'];
	$reason = $_POST['reason'];
	$date = Date(); $date = $date['date_full'];
	$date = explode(" ", $date);
	$time = explode(":", $date[1]);
	$date = explode("-", $date[0]);
	if(empty($userid) && !empty($ip)){ $userid = $id; }
	if(isset($_POST['unban'])){
		$data->delete3($userid,$ip);
		$message = $lang->loc['message.user.unbanned'];
		break;
	}
	switch($length){
	case "2h": $time[0] = $time[0] + 2; break;
	case "4h": $time[0] = $time[0] + 4; break;
	case "12h": $time[0] = $time[0] + 12; break;
	case "1d": $date[0] = $date[0] + 1; break;
	case "2d": $date[0] = $date[0] + 2; break;
	case "7d": $date[0] = $date[0] + 7; break;
	case "2w": $date[0] = $date[0] + 14; break;
	case "1m": $date[1] = $date[1] + 1; break;
	case "6m": $date[1] = $date[1] + 6; break;
	case "1y": $date[2] = $date[2] + 1; break;
	case "perm": $date[2] = $date[2] + 25; break;
	default: $error = $lang->loc['error.invalid.ban']; break 2;
	}
				 
	if($time[0] > 23){
		$diff = $time[0] - 24;
		$time[0] = $diff + 1;
		$date[0] = $date[0] + 1;
	}
		
	if($input->IsEven($month)){
		if($date[0] > 30){
			$diff = $date[0] - 30;
			$date[0] = $diff;
			$date[1] = $date[1] + 1;
			}
	} else {
		if($date[0] > 31){
			$diff = $date[0] - 31;
			$date[0] = $diff;
			   $date[1] = $date[1] + 1;
		}
	}
		
	if($date[1] > 11){
		$diff = 12 - $date[1];
		$date[1] = $diff;
		$date[2] + 1;
	}
	
	if($date[0] < 10 && strrpos($date[0], "0") === false){ $date[0] = "0" . $date[0]; }
	if($date[1] < 10 && strrpos($date[1], "0") === false){ $date[1] = "0" . $date[1]; }
	if($time[0] < 10 && strrpos($time[0], "0") === false){ $time[0] = "0" . $time[0]; }
		
	$ban_date = $date[0] . "-" . $date[1] . "-" . $date[2] . " " . $time[0] . ":" . $time[1] . ":" . $time[2];
	
	$row = $db->fetch_row($core->select3($id));
	if($id == $user->id || $row[3] == "7"){
		$error = $lang->loc['error.cannot.ban'];
	}elseif(empty($userid) && empty($ip)){
		$error = $lang->loc['error.empty.ban'];
	}else{
		$data->delete3($userid,$ip);
		$data->update4($userid,$ip,$ban_date,$reason);
		$message = $lang->loc['message.saved.ban'];
		@SendMUSData('HKSB' . $id . chr(2) . $input->HoloText($reason));
	}
break;