Subversion-Projekte lars-tiefland.content-management

<?
    require_once "connect2.php";
    session_start();
    if ( !$_SESSION["language"] )
    {
        $_SESSION["language"] = DEFAULT_LANG;
    }

    function delete_artikel( $ID )
    {
        /*
        Löschen aus:
        artikel
        Feature_to_Ware
        artikel_2_Aktionen
        artikel_to_Preisagentur
        shop_link_table
        */

        echo "delete_artikel($ID)<br>";

        $queries[] = "DELETE FROM artikel                                       WHERE ID                =       $ID";
        $queries[] = "DELETE FROM Feature_to_Ware                       WHERE Ware              =       $ID";
        $queries[] = "DELETE FROM artikel_2_Aktionen            WHERE artikel   =       $ID";
        $queries[] = "DELETE FROM artikel_to_Preisagentur       WHERE artikel   =       $ID";
        $queries[] = "DELETE FROM shop_link_table                       WHERE Father    =       $ID and Verwendung like '%2a'";
        $queries[] = "DELETE FROM shop_link_table                       WHERE ID                =       $ID and Verwendung like 'a2%'";

        foreach ( $queries as $query )
        {
            $result = mysql_query( $query );
        }
    }

    function delete_directory( $ID )
    {
        /*
        Löschen aus:
        directory
        shop_link_table
        */

        // Unterverzeichnisse im löschen
        $result = mysql_query( "select ID from directory where Father = $ID" );
        while ( $directory = mysql_fetch_array( $result ) )
        {
            delete_directory( $directory["ID"] );
        }

        // Artikel im Verzeichnis löschen
        $result = mysql_query( "select ID from artikel where Father = $ID" );
        while ( $artikel = mysql_fetch_array( $result ) )
        {
            delete_artikel( $artikel[ID] );
        }

        if ( $ID > 0 )
        {
            $queries[] = "
                DELETE FROM
                    directory
                WHERE
                    ID          =       $ID
            ";
        }
        $queries[] = "
            DELETE FROM
                shop_link_table
            WHERE
                Father  =       $ID
            AND
                Verwendung LIKE '%2d'
        ";
        $queries[] = "
            DELETE FROM
                shop_link_table
            WHERE
                ID              =       $ID
            AND
                Verwendung LIKE 'd2%'
        ";

        echo "delete_directory($ID)<br>";

        foreach ( $queries as $query )
        {
            $result = mysql_query( $query );
        }
    }

    delete_directory( -2 );
?>
<script language="javascript" type="text/javascript">
        parent.tree.reload();
        document.location='start.php';
</script>