Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
        $self=basename($PHP_SELF);
        require_once "../Online-Shop/connect.php";

        if ($Modus == 0)
        {
                $referred = "Logins";
                $referrer = "Verteiler";
        }
        else
        {
                $referrer = "Logins";
                $referred = "Verteiler";
        }
        
        if ($action)
        {
                foreach(array_keys($current_view) as $elem)
                {
                        $current_view[$elem] = "(".$referred." = ".$current_view[$elem].")";
                }
                $query="delete from Logins_to_Verteiler where $referrer = $ref and (".implode(" or ",$current_view).")";
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());

                if ($checkbox)
                {
                        foreach($checkbox as $elem)
                        {
                                $query="insert into Logins_to_Verteiler ($referrer,$referred) values ($ref,$elem)";
                                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                        }
                }
        }
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel=stylesheet type="text/css" href="../buttons.css">
<style type="text/css"><? require_once "../buttons.css"; ?></style>
</head>

<body bgcolor="#<? echo $webs[bgcolor_seite] ?>" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#<? echo $webs[font_color_seite] ?>">
<?
        switch ($Modus)
        {
                case 0:
                        $query="select ID,E_Mail from Logins order by ID";
                        break;
                case 1:
                        $query="select ID,Name from Verteiler order by ID";
                        break;
        }
?>
<form method="post" action="<? echo $self ?>" name="formname">
<input type="hidden" name="ref" value="<? echo $ref ?>">
<input type="hidden" name="Modus" value="<? echo $Modus ?>">
<input type="hidden" name="action" value="true">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
        if ($query)
        {
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                while ($zeile=mysql_fetch_array($result))
                {
                        if ($ref)
                        {
                                $query_checked = "select * from Logins_to_Verteiler where $referred = $zeile[ID] and $referrer = $ref";
                                $result_checked = mysql_query ($query_checked) or die (mysql_errno().": ".mysql_error()."<hr>".$query_checked."<hr>");
                        }
?>
  <tr>
        <td>
        <? if ($ref) { ?>
        <input type="checkbox" name="checkbox[]" value="<? echo $zeile[0]; ?>" onClick="this.form.submit()"<? if (mysql_num_rows($result_checked) == 1) {echo " checked";} ?>>
        <input type="hidden" name="current_view[]" value="<? echo $zeile[0]; ?>">
        <? } else { ?>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <? } ?>
        </td>
    <td width="100%"><? echo $zeile[1]; ?></td>
  </tr>
<?
                }
        }
?>
</table>
</form>
</body>
</html>