Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
    require_once "connect2.php";
3 
    session_start();
4 
    if ( !$_SESSION["language"] )
5 
    {
6 
        $_SESSION["language"] = DEFAULT_LANG;
7 
    }
8 
 
9 
    function delete_artikel( $ID )
10 
    {
11 
        /*
12 
        Löschen aus:
13 
        artikel
14 
        Feature_to_Ware
15 
        artikel_2_Aktionen
16 
        artikel_to_Preisagentur
17 
        shop_link_table
18 
        */
19 
 
20 
        echo "delete_artikel($ID)<br>";
21 
 
22 
        $queries[] = "DELETE FROM artikel					WHERE ID		=	$ID";
23 
        $queries[] = "DELETE FROM Feature_to_Ware			WHERE Ware		=	$ID";
24 
        $queries[] = "DELETE FROM artikel_2_Aktionen 		WHERE artikel	=	$ID";
25 
        $queries[] = "DELETE FROM artikel_to_Preisagentur	WHERE artikel	=	$ID";
26 
        $queries[] = "DELETE FROM shop_link_table			WHERE Father	=	$ID and Verwendung like '%2a'";
27 
        $queries[] = "DELETE FROM shop_link_table			WHERE ID		=	$ID and Verwendung like 'a2%'";
28 
 
29 
        foreach ( $queries as $query )
30 
        {
31 
            $result = mysql_query( $query );
32 
        }
33 
    }
34 
 
35 
    function delete_directory( $ID )
36 
    {
37 
        /*
38 
        Löschen aus:
39 
        directory
40 
        shop_link_table
41 
        */
42 
 
43 
        // Unterverzeichnisse im löschen
44 
        $result = mysql_query( "select ID from directory where Father = $ID" );
45 
        while ( $directory = mysql_fetch_array( $result ) )
46 
        {
47 
            delete_directory( $directory["ID"] );
48 
        }
49 
 
50 
        // Artikel im Verzeichnis löschen
51 
        $result = mysql_query( "select ID from artikel where Father = $ID" );
52 
        while ( $artikel = mysql_fetch_array( $result ) )
53 
        {
54 
            delete_artikel( $artikel[ID] );
55 
        }
56 
 
57 
        if ( $ID > 0 )
58 
        {
59 
            $queries[] = "
60 
                DELETE FROM
61 
                    directory
62 
                WHERE
63 
                    ID		=	$ID
64 
            ";
65 
        }
66 
        $queries[] = "
67 
            DELETE FROM
68 
                shop_link_table
69 
            WHERE
70 
                Father	=	$ID
71 
            AND
72 
                Verwendung LIKE '%2d'
73 
        ";
74 
        $queries[] = "
75 
            DELETE FROM
76 
                shop_link_table
77 
            WHERE
78 
                ID		=	$ID
79 
            AND
80 
                Verwendung LIKE 'd2%'
81 
        ";
82 
 
83 
        echo "delete_directory($ID)<br>";
84 
 
85 
        foreach ( $queries as $query )
86 
        {
87 
            $result = mysql_query( $query );
88 
        }
89 
    }
90 
 
91 
    delete_directory( -2 );
92 
?>
93 
<script language="javascript" type="text/javascript">
94 
	parent.tree.reload();
95 
	document.location='start.php';
96 
</script>