Dobrý den,prosím někoho znalého o radu co s tím.Mám databázi nahranou na phmyadminu, stejnou pak na webu pres ftp. V DB jsem opravil tabulky kategorie, protoze tam byly zavedeny nektere o ktere jsem nestal. Vse se zobrazuje spravne. Pokud ale provedu aktualizaci importu zbozi (pres cron up), znovu se mi pak po aktualizaci webu objevi stare kategorie, ktere jsem vymazal (nove zustanou).Takze jde o skript importu, jenze ja vubec nevim, jak a kde jej upravit, aby se to nedelo a po aktualizaci importu zbozi byly na webu jen kategorie, ktere jsem sam udelal a nevracely se tam ty stare. Nize zasilam vypsany skript pro UP. Dekuji moc (moudremu napovez - hloupeho kopni - prosim o kopnuti :))if(empty($_GET['cron'])){ $_GET['cron']=0;}include('../inc/distributori.php');//include('Gregphoto_Image.php');$distributori=new Distributor('','view','');$distributori_data=$distributori->data;if(count($distributori_data)){ foreach($distributori_data as $distributor){$xml = simplexml_load_file("xml/".$distributor['id'].".xml");$typ=$distributor['id'];$p_cnt=count($xml);echo "<h2>Import pro Slevovy portal ".$distributor['nazev']."</h2>";for($i = 0; $i <= $p_cnt ; $i++) { $q0 = "SELECT id FROM polozka p1 where url='".$xml->DEAL[$i]->URL."' "; $r0 = mysql_query($q0); echo mysql_error(); $p=mysql_num_rows($r0);if(empty($xml->DEAL[$i]->CITY)){$xml->DEAL[$i]->CITY=$xml->DEAL[$i]->CITIES->CITY[0];}if(empty($xml->DEAL[$i]->IMAGE)){$xml->DEAL[$i]->IMAGE=$xml->DEAL[$i]->IMAGES->IMAGE[0];} if(!empty($xml->DEAL[$i]->CATEGORY)){ $id_kategorie=insertCategory($xml->DEAL[$i]->CATEGORY,"category"); } else{… $id_kategorie=insertCategory("Neznámá","category"); } if($p==0 and !empty($xml->DEAL[$i]->TITLE)){ echo "Pridana sleva.".$xml->DEAL[$i]->TITLE."<Br />"; $id_mesto=insertCategory($xml->DEAL[$i]->CITY,"city"); $detail=$xml->DEAL[$i]->IMAGE; $q = "INSERT INTO `polozka` (`distributor`, `zvyhodneni`, `id_kategorie` , `nazev` , `seo_url` , `url` , `detail` , `typ` , `schvaleno` , `text` , `price` , `original_price` , `discount` , `id_kraj` , `customers` , `max_customers` , `deal_start` , `deal_end` ,`cas`,`min_customers`,`address`) VALUES ('".$xml->DEAL[$i]->SERVER_NAME."','".$xml->DEAL[$i]->ORDER."','$id_kategorie', '".mysql_real_escape_string($xml->DEAL[$i]->TITLE)."', '', '".$xml->DEAL[$i]->URL."', '$detail', '$typ', '1', '".mysql_real_escape_string($xml->DEAL[$i]->TITLE)."', '".$xml->DEAL[$i]->FINAL_PRICE."', '".$xml->DEAL[$i]->ORIGINAL_PRICE."', '".$xml->DEAL[$i]->DISCOUNT."', '$id_mesto', '".$xml->DEAL[$i]->CUSTOMERS."', '".$xml->DEAL[$i]->MAX_CUSTOMERS."', '".$xml->DEAL[$i]->DEAL_START."', '".$xml->DEAL[$i]->DEAL_END."' ,'".time()."','".$xml->DEAL[$i]->MIN_CUSTOMERS."','".mysql_real_escape_string($xml->DEAL[$i]->ADDRESS)."');"; mysql_query($q); echo mysql_error(); $id=mysql_insert_id(); $q = "UPDATE `polozka` set seo_url='".$id."-".SEOurl($xml->DEAL[$i]->TITLE)."' where id=$id"; mysql_query($q);}elseif($z=mysql_fetch_array($r0)){ echo "Aktualizovan produktu ".$z['id']."<br />"; $id=$z['id']; if(!empty($xml->DEAL[$i]->CATEGORY)){ $id_kategorie=insertCategory($xml->DEAL[$i]->CATEGORY,"category"); } else{ $id_kategorie=insertCategory("Neznámá","category"); } $id_mesto=insertCategory($xml->DEAL[$i]->CITY,"city"); $detail=$xml->DEAL[$i]->IMAGE; if(empty($xml->DEAL[$i]->DISCOUNT)){ $xml->DEAL[$i]->DISCOUNT=100-(($xml->DEAL[$i]->FINAL_PRICE/$xml->DEAL[$i]->ORIGINAL_PRICE)*100); }$q = "UPDATE `polozka` set url='".$xml->DEAL[$i]->URL."',detail='".$detail."',zvyhodneni='".$xml->DEAL[$i]->ORDER."',nazev='".mysql_real_escape_string($xml->DEAL[$i]->TITLE)."',text='".mysql_real_escape_string($xml->DEAL[$i]->TITLE)."',discount='".$xml->DEAL[$i]->DISCOUNT."',`price`='".$xml->DEAL[$i]->FINAL_PRICE."' , `original_price`='".$xml->DEAL[$i]->ORIGINAL_PRICE."' ,`discount`='".$xml->DEAL[$i]->DISCOUNT."',`customers`='".$xml->DEAL[$i]->CUSTOMERS."' , `min_customers`='".$xml->DEAL[$i]->MIN_CUSTOMERS."' , `max_customers`='".$xml->DEAL[$i]->MAX_CUSTOMERS."' , `deal_start`='".$xml->DEAL[$i]->DEAL_START."' , `deal_end` ='".$xml->DEAL[$i]->DEAL_END."',id_kraj='".$id_mesto."',id_kategorie='".$id_kategorie."' where id=$id"; mysql_query($q); echo mysql_error();}}}}?> Ukázat celý příspěvek