Subversion-Projekte lars-tiefland.content-management

<?php
    // forget about any script timeouts
    //set_time_limit(0);

    define( "modul_name", "Warenwirtschaft" );
    define( "tool_name", "in_export" );

    require_once "../toolbox/common.php";

    $GLOBALS["ui"]->compile_id = "Warenwirtschaft|in_export";

    session_start();
    $query = "SELECT
            *
        FROM
            shops
        WHERE
            importtool != ''
    ";
    $result = mysql_query( $query );
    while ( $zeile = mysql_fetch_assoc( $result ) )
    {
        $tools[] = $zeile;
    }

    $sql = "SELECT
            engine
        FROM
            information_schema.TABLES
        WHERE
            table_name='schnittstellen'
    ";
    $res = mysql_query( $sql );
    echo mysql_error();
    if ( mysql_num_rows( $res ) )
    {
        $sql = "SELECT
                s.*,
                l.name aS l_name
            FROM
                schnittstellen s
            JOIN
                lieferanten l
            ON
                l.id=s.lieferanten_id
            WHERE
                nutzungsart IN ('manuell','dual')
            AND
                art IN ('bestellimport', 'bestellexport')
        ";
        $res = mysql_query( $sql );
        while ( $row = mysql_fetch_assoc( $res ) )
        {
            $tools2[] = $row;
        }
    }
    $GLOBALS["ui"]->assign( "tools", $tools );
    $GLOBALS["ui"]->assign( "tools2", $tools2 );
    $GLOBALS["ui"]->display( "in_exporttool.tpl" )
?>