·grüne Landschaften
· 14.12.2008 · 20Uhr43 · ShopCat
Aufräumer: ShopCat ohne Shop löschen
Wenn noch ShopCat's in der DB sind, zu Shops die nicht mehr vorhanden sind.
----------if ( $_GET['cc'] )
{
if ( $_GET['cc']==-1 )
{
$query = " SELECT * FROM CSVAffiliateShopinfo";
$query .= " ORDER BY shopid 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['shopid']; else $_GET['cc']=0;
}
if ( $_GET['cc'] )
{
$query = " SELECT * FROM CSVAffiliateShopinfo";
$query .= " WHERE shopid=".(int)$_GET['cc'];
$result = mysql_query($query) or die("<hr>$query<hr>".mysql_error());
if ( $line = mysql_fetch_array($result, MYSQL_ASSOC) )
echo('··········');
else
{
echo('##NULL##');
$query = " DELETE FROM CSVAffiliateShopCat";
$query .= " WHERE shopid=".(int)$_GET['cc'];
mysql_query($query) or die("<hr>$query<hr>".mysql_error());
echo($dels=mysql_affected_rows());flush();
if ( $dels ) sleep(8);
}
}
else
{
echo('READY'); exit();
}
$wait=0;
$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();
}
CSV/Affiliate
1·2·3·Die Lösung
