· 15.12.2008 · 10:20:47 ·· CSVAndy
Aufräumer: ShopCat reCount
ShopCat IDs der Reihe nach in den Artikeldaten suchen und den 'count' neu setzen.Wenn keine Daten gefunden, ShopCat löschen
ShopCat =via= mcatid
if ( $_GET['cc'] )
{
if ( $_GET['cc']==-1 )
{
$query = " SELECT * FROM CSVAffiliateShopCat";
$query .= " ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die("<hr>$query<hr>".mysql_error());
if ( $line = mysql_fetch_array($result, MYSQL_ASSOC) )
$_GET['cc']=$line['id']; else $_GET['cc']=0;
}
if ( $_GET['cc'] )
{
$query = " SELECT * FROM CSVAffiliateShopCat";
$query .= " WHERE id<=".(int)$_GET['cc'];
$query .= " ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die("<hr>$query<hr>".mysql_error());
if ( $line = mysql_fetch_array($result, MYSQL_ASSOC) )
{
$_GET['cc']=$line['id'];
$query = " SELECT COUNT(id)AS counting FROM CSVArtikeldaten";
$query .= " WHERE shopid=".(int)$line['shopid'];
$query .= " AND mcatid=".(int)$line['cid'];
echo('<hr> '.$query.'<hr> ');flush();
$result = mysql_query($query) or die("<hr>$query<hr>".mysql_error());
if ( $line = mysql_fetch_array($result, MYSQL_ASSOC) )
{
echo('## '.$line['counting']);flush();
if ( $line['counting'] )
{
$query = " UPDATE CSVAffiliateShopCat";
$query .= " SET `count`=".(int)$line['counting'];
$query .= " WHERE id=".(int)$_GET['cc'];
mysql_query($query) or die("<hr>$query<hr>".mysql_error());
echo('## '.$c=mysql_affected_rows());flush();
//if ( $c ) sleep(5);
}
else
{
$query = " DELETE FROM CSVAffiliateShopCat";
$query .= " WHERE id=".(int)$_GET['cc'];
mysql_query($query) or die("<hr>$query<hr>".mysql_error());
echo(' ## delete');flush();//sleep(23);
}
}
else
{
echo(' ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete ## delete');flush();sleep(123);
}
}
else $_GET['cc']=0;
}
$wait=0;
if ( $_GET['cc'] )
{
$http='http://'.$_SERVER['HTTP_HOST'].strtok($_SERVER['REQUEST_URI'],'?').'?cc='.(--$_GET['cc']);
echo ("<hr>REF@$wait sec $http <head> <meta http-equiv='refresh' content='$wait;$http'> </head>");
}
exit();
}
