Subversion-Projekte lars-tiefland.content-management

<?
require_once '/web/apache/content-management/ebayphpat/Ebay_CategoryQuery.php';
$Version = "/web/apache/content-management/cronjobs/Categories.Version";

$mySession = new Ebay_Session();
$mySession->InitFromConfig("/web/apache/content-management/ebay.config");

$catQuery = new Ebay_CategoryQuery($mySession);
$catQuery->setCategorySiteId(0);
$catQuery->setCategoryParent(0);
$catQuery->setLevelLimit(255);
$catQuery->setViewAllNodes(true);
$res = $catQuery->Query(0);

// aktuelle Version von eBay ziehen
$info = $catQuery->getResultInfo();
$currentVersion=$info->getVersion();

// gespeicherte Version ziehen
$Categories = parse_ini_file($Version);

if ($Categories[Version] != $currentVersion)
{
        // Version abspeichern
    $handle = fopen($Version, "w");
    fwrite($handle, "Version=$currentVersion");
    fclose($handle);

        $felder=array("CategoryId", "CategoryLevel", "CategoryName", "CategoryParentId", "IsExpired", "IsVirtual", "LeafCategory");

        // Vorbereiten die ganze Liste zu ziehen

        $res = $catQuery->Query(1);

        if ($res->isGood())
        {
                mysql_connect("127.0.0.1:3306","content_managem","k-dp-u");
                mysql_query("delete from eBay.Categories") or die (mysql_errno().": ".mysql_error()."<hr>".$query);

            $catList = $catQuery->getResultList();

                foreach ($catList as $cat)
                {
                        $values=array();
                        foreach($felder as $elem)
                        {
                                $values[] = "'".addslashes($cat->{"get".$elem}())."'";
                        }
                        $sqlQuery="insert into eBay.Categories values (".implode(", ",$values).")";
                        mysql_query($sqlQuery) or die (mysql_errno().": ".mysql_error()."<hr>".$sqlQuery);
            } 
        } 
}
?>