Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
<?
2
	$self=basename($PHP_SELF);
3
	require_once "../Online-Shop/connect.php";
4
 
5
	if ($Modus == 0)
6
	{
7
		$referred = "Logins";
8
		$referrer = "Verteiler";
9
	}
10
	else
11
	{
12
		$referrer = "Logins";
13
		$referred = "Verteiler";
14
	}
15
 
16
	if ($action)
17
	{
18
		foreach(array_keys($current_view) as $elem)
19
		{
20
			$current_view[$elem] = "(".$referred." = ".$current_view[$elem].")";
21
		}
22
		$query="delete from Logins_to_Verteiler where $referrer = $ref and (".implode(" or ",$current_view).")";
23
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
24
 
25
		if ($checkbox)
26
		{
27
			foreach($checkbox as $elem)
28
			{
29
				$query="insert into Logins_to_Verteiler ($referrer,$referred) values ($ref,$elem)";
30
				$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
31
			}
32
		}
33
	}
34
?>
35
<html>
36
<head>
37
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
38
<link rel=stylesheet type="text/css" href="../buttons.css">
39
<style type="text/css"><? require_once "../buttons.css"; ?></style>
40
</head>
41
 
42
<body bgcolor="#<? echo $webs[bgcolor_seite] ?>" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#<? echo $webs[font_color_seite] ?>">
43
<?
44
	switch ($Modus)
45
	{
46
		case 0:
47
			$query="select ID,E_Mail from Logins order by ID";
48
			break;
49
		case 1:
50
			$query="select ID,Name from Verteiler order by ID";
51
			break;
52
	}
53
?>
54
<form method="post" action="<? echo $self ?>" name="formname">
55
<input type="hidden" name="ref" value="<? echo $ref ?>">
56
<input type="hidden" name="Modus" value="<? echo $Modus ?>">
57
<input type="hidden" name="action" value="true">
58
<table width="100%" border="0" cellspacing="0" cellpadding="0">
59
<?
60
	if ($query)
61
	{
62
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
63
		while ($zeile=mysql_fetch_array($result))
64
		{
65
			if ($ref)
66
			{
67
				$query_checked = "select * from Logins_to_Verteiler where $referred = $zeile[ID] and $referrer = $ref";
68
				$result_checked = mysql_query ($query_checked) or die (mysql_errno().": ".mysql_error()."<hr>".$query_checked."<hr>");
69
			}
70
?>
71
  <tr>
72
	<td>
73
	<? if ($ref) { ?>
74
	<input type="checkbox" name="checkbox[]" value="<? echo $zeile[0]; ?>" onClick="this.form.submit()"<? if (mysql_num_rows($result_checked) == 1) {echo " checked";} ?>>
75
	<input type="hidden" name="current_view[]" value="<? echo $zeile[0]; ?>">
76
	<? } else { ?>
77
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
78
	<? } ?>
79
	</td>
80
    <td width="100%"><? echo $zeile[1]; ?></td>
81
  </tr>
82
<?
83
		}
84
	}
85
?>
86
</table>
87
</form>
88
</body>
89
</html>