1:
2:
3:
4:

$suchebezeich = $_POST[Suche];

$search = "SELECT * FROM (`bb1_bugtracker_open`,`bb1_bugtracker_closed`,`bb1_bugtracker_workon`) WHERE bb1_bugtracker_open.titel LIKE '"."%".$suchebezeich."%"."' OR `bb1_bugtracker_closed`.titel LIKE '"."%".$suchebezeich."%"."' OR `bb1_bugtracker_workon`.titel LIKE '"."%".$suchebezeich."%"."' "; 

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

//Suchfunktion

if(isset($_POST['action']) == "search" && ($_POST['action']) != "neu" && ($_POST['action']) != "workon"){
$suchebezeich = $_POST[Suche];

$bugsearch = "SELECT bb1_bugtracker_open.titel, bb1_bugtracker_close.titel, bb1_bugtracker_workon.titel
FROM ((bb1_bugtracker_open
INNER JOIN bb1_bugtracker_closed ON bb1_bugtracker_open.titel = bb1_bugtracker_close.titel)
INNER JOIN bb1_bugtracker_workon ON bb1_bugtracker_closed.titel = bb1_bugtracker_workon.titel)
WHERE titel LIKE '"."%".$suchebezeich."%"."' "; 

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:

...
//Tabellenlistung Bugs
//Offen
	$auszg = "SELECT * FROM `bb1_bugtracker` ORDER BY time DESC";
	$ausz = mysql_query($auszg);
	while ($ds = mysql_fetch_object($ausz)) {
		$id = $ds->id;
		$user = $ds->melder;
		$titel = $ds->titel;
		$text = $ds->bugtext;
		$zeit = $ds->time;
		$timestamp = date("H:i:s - d.m.Y",$zeit);
		$work = $ds->in_work;
		If($work != ""){
			$in_work = $work;			
		}else{
			$in_work = "<button id='_bwork_on' type='button' value='$ds->id'>Bearbeiten</button>";
		} 
		eval ("\$bugtrackeropen .= "".$tpl->get("bugtracker_open")."";"); 
	}
...

1:
2:
3:
4:
5:
6:

if(isset($_POST['action']) == "workon" && ($_POST['action']) != "neu" && ($_POST['action']) != "search"){
$worker = "INSERT INTO `bb1_bugtracker` SET in_work= '$wbbuser [nickname]' WHERE id = '$id' ";
$worker_in= mysql_query($worker);
}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:

...
//Tabellenlistung Bugs
//Offen
	$auszg = "SELECT * FROM `bb1_bugtracker` ORDER BY time DESC";
	$ausz = mysql_query($auszg);
	while ($ds = mysql_fetch_object($ausz)) {
		$id = $ds->id;
		$user = $ds->melder;
		$titel = $ds->titel;
		$text = $ds->bugtext;
		$zeit = $ds->time;
		$timestamp = date("H:i:s - d.m.Y",$zeit);
		$work = $ds->in_work;
		If($work != ""){
			$in_work = $work;			
		}else{
			$in_work = "<button id='bwork_on' type='button' value='$ds->id'>Bearbeiten</button>";
		}
		If($fixed == "" && $work != ""){
			$fixed = "<button id='bwork_on_fixed' type='button' value='$ds->id'>fixxed!</button>";
		}else{
			$fixed = $ds->fixed;
		}
		eval ("\$bugtrackeropen .= "".$tpl->get("bugtracker_open")."";"); 
	}

//Bearbeitung durch
	if(isset($_POST['action']) == "bwork_on" && ($_POST['action']) != "neu" && ($_POST['action']) != "search"){
		$worker = "UPDATE `bb1_bugtracker` SET in_work= 'In Bearbeitung durch $wbbuser [nickname]' WHERE id = '$id' ";
		$worker_in= mysql_query($worker);
	}

//fix durch
		if(isset($_POST['action']) == "bwork_on_fixed" && ($_POST['action']) != "neu" && ($_POST['action']) != "search"){
		$fixxer = "UPDATE `bb1_bugtracker` SET fixed= '$wbbuser [nickname]' WHERE id = '$id' ";
		$fixxer_in= mysql_query($fixxer);
	}

//on Work
	$anzg = "SELECT * FROM `bb1_bugtracker` ORDER BY time ASC";
	$anz = mysql_query($anzg);
	while ($ds = mysql_fetch_object($anz)) {
		$id = $ds->id;
		$user = $ds->melder;
		$titel = $ds->titel;
		$text = $ds->bugtext;
		$zeit = $ds->time;
		$timestamp = date("H:i:s - d.m.Y",$zeit);
		$workon = $ds->in_work;
		$fixed = $ds->fixed;
		eval ("\$bugtrackerworkon .= "".$tpl->get("bugtracker_workon")."";"); 
	}
...