| 1 |
lars |
1 |
<?
|
|
|
2 |
require_once '/web/apache/content-management/ebayphpat/Ebay_CategoryQuery.php';
|
|
|
3 |
$Version = "/web/apache/content-management/cronjobs/Categories.Version";
|
|
|
4 |
|
|
|
5 |
$mySession = new Ebay_Session();
|
|
|
6 |
$mySession->InitFromConfig("/web/apache/content-management/ebay.config");
|
|
|
7 |
|
|
|
8 |
$catQuery = new Ebay_CategoryQuery($mySession);
|
|
|
9 |
$catQuery->setCategorySiteId(0);
|
|
|
10 |
$catQuery->setCategoryParent(0);
|
|
|
11 |
$catQuery->setLevelLimit(255);
|
|
|
12 |
$catQuery->setViewAllNodes(true);
|
|
|
13 |
$res = $catQuery->Query(0);
|
|
|
14 |
|
|
|
15 |
// aktuelle Version von eBay ziehen
|
|
|
16 |
$info = $catQuery->getResultInfo();
|
|
|
17 |
$currentVersion=$info->getVersion();
|
|
|
18 |
|
|
|
19 |
// gespeicherte Version ziehen
|
|
|
20 |
$Categories = parse_ini_file($Version);
|
|
|
21 |
|
|
|
22 |
if ($Categories[Version] != $currentVersion)
|
|
|
23 |
{
|
|
|
24 |
// Version abspeichern
|
|
|
25 |
$handle = fopen($Version, "w");
|
|
|
26 |
fwrite($handle, "Version=$currentVersion");
|
|
|
27 |
fclose($handle);
|
|
|
28 |
|
|
|
29 |
$felder=array("CategoryId", "CategoryLevel", "CategoryName", "CategoryParentId", "IsExpired", "IsVirtual", "LeafCategory");
|
|
|
30 |
|
|
|
31 |
// Vorbereiten die ganze Liste zu ziehen
|
|
|
32 |
|
|
|
33 |
$res = $catQuery->Query(1);
|
|
|
34 |
|
|
|
35 |
if ($res->isGood())
|
|
|
36 |
{
|
|
|
37 |
mysql_connect("127.0.0.1:3306","content_managem","k-dp-u");
|
|
|
38 |
mysql_query("delete from eBay.Categories") or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
39 |
|
|
|
40 |
$catList = $catQuery->getResultList();
|
|
|
41 |
|
|
|
42 |
foreach ($catList as $cat)
|
|
|
43 |
{
|
|
|
44 |
$values=array();
|
|
|
45 |
foreach($felder as $elem)
|
|
|
46 |
{
|
|
|
47 |
$values[] = "'".addslashes($cat->{"get".$elem}())."'";
|
|
|
48 |
}
|
|
|
49 |
$sqlQuery="insert into eBay.Categories values (".implode(", ",$values).")";
|
|
|
50 |
mysql_query($sqlQuery) or die (mysql_errno().": ".mysql_error()."<hr>".$sqlQuery);
|
|
|
51 |
}
|
|
|
52 |
}
|
|
|
53 |
}
|
|
|
54 |
?>
|