Subversion-Projekte lars-tiefland.content-management

<?
    require_once  "../connect.php";

    $query = "SELECT DISTINCT
            webs.datenbank,
            webs.db_server,
            webs.db_username,
            webs.db_password
        FROM
                   webs_properties,
                   webs
        WHERE
            webs_properties.properties BETWEEN 220 AND 225
        AND
            webs.ID = webs_properties.webs
        AND
            webs.domain='$site'
        ";
    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>" . $query );

    while ( $zeile = mysql_fetch_assoc( $result ) )
    {
        $conn = mysql_connect( $zeile["db_server"], $zeile["db_username"], $zeile["db_password"], true );
        for ( $i = 1; $i <= 8; $i++ )
        {
            $condition = "(autoupdate" . $i . " < NOW()) and (autoupdate" .
                $i . " > '0000-00-00 00:00:00')";

            $update_query = "update " . $zeile["datenbank"] .
                ".artikel set letzte_Aenderung_von = concat(letzte_Aenderung_von,' (autoupdate)') where (letzte_Aenderung_von not like '%(autoupdate)') and " .
                $condition;
            mysql_query( $update_query, $conn );

            $update_query = "update " . $zeile["datenbank"] .
                ".artikel set preis" . $i . "=preis_neu" . $i .
                ", preis_neu" . $i . "='NULL', autoupdate" . $i .
                " = '0000-00-00 00:00:00' where " . $condition;
            mysql_query( $update_query, $conn );
        }
    }
?>