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:

SELECT bb1_users.username, bb1_user2groups.userid, bb1_userfields.field1
FROM ((bb1_users
INNER JOIN bb1_userfields ON bb1_users.userid = bb1_userfields.userid)
INNER JOIN bb1_user2groups ON bb1_users.userid = bb1_user2groups.userid)

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:

... WHERE bb1_bugtracker_open.titel LIKE '"."%".$suchebezeich."%"."' OR bb1_bugtracker_closed.titel LIKE '"."%".$suchebezeich."%"."' OR bb1_bugtracker_workon.titel LIKE '"."%".$suchebezeich."%"."' ";  

1:

WHERE workon != ""

1:

 <td width="17%" align="center">$in_work</td>

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

$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" ;
		} 
		eval ("\$bugtrackeropen .= "".$tpl->get("bugtracker_open")."";"); 
	}

1:

$in_work = echo "<input type="bugtracker.php" name="hidden" value="workon"><input type="hidden" name="Bearbeiten" value="workon">";

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")."";"); 
	}
...

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:

<table>
<form action = "bursch_edit.php" method ="post">
<table>
<input type="hidden" value="<?php echo $id_fragen ?>" name="id_fragen">
<tr>
<td span class="normalfont">Stufe:&nbsp;<?php echo $id_fragen ?></td>
</tr>
<tr>
<td><label for="desc_frage":</label></td>
<td>Frage&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input id="desc_frage" value="<?php echo $desc_frage ?>" name="desc_frage" size="200"></td>
</tr><tr>
<td><label for="desc_answer":</label></td>
<td>Antwort&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input id="desc_answer" value="<?php echo $desc_answer ?>" name="desc_answer" size="150"></td>

</tr>

</table>
<table align="center">
<tr >
<br><br><td><input type ="submit"></td>
<td><input type ="reset"></td>
</form>
</tr>
</table>

<table>
<tr>
<td span class="normalfont"><a href="bursch_anz.php">Zurück zur Liste!</a></td>
</tr>
</table>

</body>
</html>

1:

$worker = "UPDATE `bb1_bugtracker` SET in_work= '$wbbuserdata[username]' WHERE id = '$id' ";