public function editPageAction() { $id = $this->_getParam('id'); $this->view->user_id = $id; $model1 = new Application_Model_Page(); $model = $model1->find($id); if (false === $model) { $this->_flashMessenger->addMessage(array('error' => 'Invalid request! Please try again.')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/hr/employees')); } $options = array('title' => $model->getTitle(), 'identifire' => $model->getIdentifire(), 'content' => $model->getContent(), 'metaTitle' => $model->getMetaTitle(), 'metaDescription' => $model->getMetaDescription(), 'metaKeyword' => $model->getMetaKeyword(), 'status' => $model->getStatus()); $request = $this->getRequest(); $form = new Application_Form_Page(); $form->populate($options); $options = $request->getPost(); if ($request->isPost()) { if ($form->isValid($options)) { $sanitize = new Base_Sanitize(); if (trim($options['identifire']) == "") { $options['identifire'] = $options['title']; } if (trim($options['identifire']) != "") { $options['identifire'] = $sanitize->clearInputs($options['identifire']); $options['identifire'] = $sanitize->sanitize($options['identifire']); //update seo url table $seo_url_title = $options['identifire']; $actual_url = "/index/contact"; $seo_url = "/contact"; $actual_url = "/employee/page/identifire/{$model->getIdentifire()}"; $new_actual_url = "/employee/page/identifire/{$seo_url_title}"; $seo_url = "/{$seo_url_title}"; $seoUrlM = new Application_Model_SeoUrl(); $soeUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'"); if (false !== $soeUrl) { if ($seo_url != "") { $soeUrl->setActualUrl($new_actual_url); $soeUrl->setSeoUrl($seo_url); $soeUrl->save(); } } else { if ($seo_url != "") { $seoUrl = new Application_Model_SeoUrl(); $seoUrl->setActualUrl($new_actual_url); $seoUrl->setSeoUrl($seo_url); $seoUrl->save(); } } } $model->setOptions($options); $model->save(); $this->_flashMessenger->addMessage(array('success' => 'Page has been updated successfully!')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/cms/edit-page/id/' . $id)); } else { $this->_flashMessenger->addMessage(array('error' => 'Unable to save the data. Please provide valid inputs and try again.')); $form->reset(); $form->populate($options); } } $this->view->form = $form; }
public function editAction() { $id = $this->_getParam('id'); $preview = false; $preview = $this->_getParam('preview'); //echo "diana==>".base64_encode(85); $this->view->id = $id; $this->view->preview = $preview; $page = new Application_Model_Advice(); $page = $page->find($id); $options = array('categoryId' => $page->getCategoryId(), 'title' => $page->getTitle(), 'identifire' => $page->getIdentifire(), 'name' => $page->getName(), 'content' => $page->getContent(), 'synopsis' => $page->getSynopsis(), 'metaTitle' => $page->getMetaTitle(), 'metaDescription' => $page->getMetaDescription(), 'metaKeyword' => $page->getMetaKeyword(), 'status' => $page->getStatus(), 'name' => $page->getName(), 'userId' => $page->getUserId()); $request = $this->getRequest(); $form = new Admin_Form_Advice(); //clear form element decorators $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); $element->removeDecorator('td'); $element->removeDecorator('tr'); $element->removeDecorator('row'); $element->removeDecorator('HtmlTag'); $element->removeDecorator('class'); $element->removeDecorator('placement'); $element->removeDecorator('data'); } //$this->view->type = $page->getType(); $this->view->imgName = $page->getName(); $form->populate($options); if ($request->isPost()) { $options = $request->getPost(); if (trim($options['identifire']) == "") { $sanitize = new Base_Sanitize(); $options['identifire'] = $options['title']; } if (trim($options['identifire']) != "") { $sanitize = new Base_Sanitize(); $options['identifire'] = $sanitize->clearInputs($options['identifire']); $options['identifire'] = $sanitize->sanitize($options['identifire']); //update seo url table $seo_url_title = $options['identifire']; $adviceM = new Application_Model_Advice(); $advice = $adviceM->find($id); $seo_url = ""; $actual_url = "/advice/detail/id/{$id}"; if (false !== $advice) { $sanitizeM = new Base_Sanitize(); //$category_id = $advice->getCategoryId(); $category_id = $options['categoryId']; $categoryM = new Application_Model_Category(); $category = $categoryM->find($category_id); if (false !== $category) { $seo_url = "/advice/" . $sanitizeM->sanitize($category->getName()) . "/" . $seo_url_title; } } $seoUrlM = new Application_Model_SeoUrl(); $soeUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'"); if (false !== $soeUrl) { if ($seo_url != "") { $soeUrl->setSeoUrl($seo_url); $soeUrl->save(); } } else { if ($seo_url != "") { $seoUrl = new Application_Model_SeoUrl(); $seoUrl->setActualUrl($actual_url); $seoUrl->setSeoUrl($seo_url); $seoUrl->save(); } } } //save data if ($form->isValid($options)) { //set previous image name if not uploaded new one $options['name'] = $page->getName(); /*------------------------------ Image Upload START ---------------------------*/ $upload = new Zend_File_Transfer_Adapter_Http(); if ($upload->isValid()) { $upload->setDestination("images/advice/"); try { $upload->receive(); } catch (Zend_File_Transfer_Exception $e) { $msg = $e->getMessage(); } //unlink previous uploaded image files unlink("images/advice/" . $page->getName()); unlink("images/advice/thumb_" . $page->getName()); $upload->setOptions(array('useByteString' => false)); $file_name = $upload->getFileName('name'); $cardImageTypeArr = explode(".", $file_name); $ext = strtolower($cardImageTypeArr[count($cardImageTypeArr) - 1]); $target_file_name = "advice_" . time() . ".{$ext}"; $targetPath = 'images/advice/' . $target_file_name; $targetPathThumb = 'images/advice/thumb_' . $target_file_name; $filterFileRename = new Zend_Filter_File_Rename(array('target' => $targetPath, 'overwrite' => true)); $filterFileRename->filter($file_name); $thumb = Base_Image_PhpThumbFactory::create($targetPath); $thumb->resize(128, 84); $thumb->save($targetPathThumb); // file name $options['name'] = $target_file_name; } /*------------------------------ Image Upload END ---------------------------*/ $options['status'] = $page->getStatus(); if ($options["saveUnpublish"] == "Save and Unpublish") { $options['status'] = 0; } if ($options["savePublish"] == "Save and Publish") { $options['status'] = 1; } $page->setOptions($options); $page->save(); //return $this->_helper->redirector('index','advice',"admin",Array('msg'=>base64_encode("'{$page->getTitle()}' has been updated successfully!"))); if ($options["savePublish"] == "Save and Publish") { $_SESSION['errorMsg'] = "Article has been saved & published successfully."; $this->_helper->redirector('index', 'advice', 'admin'); } else { if ($options["saveUnpublish"] == "Save and Unpublish") { $_SESSION['errorMsg'] = "Article has been saved successfully."; $this->_helper->redirector('index', 'advice', 'admin'); } else { $this->_helper->redirector('edit', 'advice', 'admin', array('id' => $id, 'preview' => 'true')); } } } else { $form->reset(); $form->populate($options); } } $this->view->form = $form; }
public function addAction() { $request = $this->getRequest(); $form = new Admin_Form_Page(); //clear form element decorators $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); $element->removeDecorator('td'); $element->removeDecorator('tr'); $element->removeDecorator('row'); $element->removeDecorator('HtmlTag'); $element->removeDecorator('class'); $element->removeDecorator('placement'); $element->removeDecorator('data'); } $model = new Application_Model_Page(); $page_id = $this->_getParam('id'); $this->view->msg = ""; if ($this->_getParam('m') == 's') { $this->view->msg = "Page saved successfully"; } else { if ($this->_getParam('m') == 'e') { $this->view->msg = "Page identifire already exist"; } } //submit form if ($this->getRequest()->isPost()) { if ($form->isValid($request->getPost())) { $params = $form->getValues(); $params['status'] = 1; if ($options["savePublish"] != "Save and Publish") { $params['status'] = 0; } $usersNs = new Zend_Session_Namespace("members"); $params['userId'] = $usersNs->userId; //Set SEO page URL START, added by Mahipal on 23-Feb-2011 $sanitize = new Base_Sanitize(); if (trim($params['identifire']) == "") { $params['identifire'] = $params['title']; } if (trim($params['identifire']) != "") { $params['identifire'] = $sanitize->clearInputs($params['identifire']); $params['identifire'] = $sanitize->sanitize($params['identifire']); $seo_url_title = $params['identifire']; $actual_url = "/index/page/identifire/{$seo_url_title}"; $seo_url = "/{$seo_url_title}"; if ($seo_url != "") { $seoUrl = new Application_Model_SeoUrl(); $seoUrl->setActualUrl($actual_url); $seoUrl->setSeoUrl($seo_url); $seoUrl->save(); } } //Set SEO page URL END $model = new Application_Model_Page($params); try { $page_id = $model->save(); //$this->_helper->redirector('add','page','admin',array('id'=>$page_id,'m'=>'s')); if ($options["savePublish"] == "Save and Publish") { $_SESSION['errorMsg'] = "Page has been saved & published successfully."; $this->_helper->redirector('index', 'page', 'admin'); } else { if ($options["saveUnpublish"] == "Save and Unpublish") { $_SESSION['errorMsg'] = "Page has been saved successfully."; $this->_helper->redirector('index', 'page', 'admin'); } else { //$this->_helper->redirector('edit','page','admin',array('id'=>$page_id,'preview'=>'true')); $identifire = $params['identifire']; $this->_helper->redirector('edit', 'page', 'admin', array('id' => $page_id, 'identifire' => $identifire, 'preview' => 'true')); } } } catch (Exception $e) { $this->_helper->redirector('add', 'page', 'admin', array('id' => $page_id, 'm' => 'e')); } } } $this->view->form = $form; }
public function addAction() { $request = $this->getRequest(); $form = new Admin_Form_Articles(); //clear form element decorators $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); $element->removeDecorator('td'); $element->removeDecorator('tr'); $element->removeDecorator('row'); $element->removeDecorator('HtmlTag'); $element->removeDecorator('class'); $element->removeDecorator('placement'); $element->removeDecorator('data'); } $model = new Application_Model_Articles(); $page_id = $this->_getParam('id'); $this->view->msg = ""; if ($this->_getParam('m') == 's') { $this->view->msg = "Article has been saved successfully."; } //select logged in user as default seleted for Author $usersNs = new Zend_Session_Namespace("members"); $author = array('userId' => $usersNs->userId); $form->populate($author); /*-----------------------------------------*/ if ($this->getRequest()->isPost()) { $options = $request->getPost(); if (trim($options['identifire']) == "") { $options['identifire'] = $options['title']; } if (trim($options['identifire']) != "") { $sanitize = new Base_Sanitize(); $options['identifire'] = $sanitize->clearInputs($options['identifire']); $options['identifire'] = $sanitize->sanitize($options['identifire']); } if ($form->isValid($options)) { /*------------------------------Image Upload ---------------------------*/ $upload = new Zend_File_Transfer_Adapter_Http(); $target_file_name = ""; if ($upload->isValid()) { $upload->setDestination("images/articles/"); try { $upload->receive(); } catch (Zend_File_Transfer_Exception $e) { $msg = $e->getMessage(); } $upload->setOptions(array('useByteString' => false)); $file_name = $upload->getFileName('image'); $cardImageTypeArr = explode(".", $file_name); $ext = strtolower($cardImageTypeArr[count($cardImageTypeArr) - 1]); $target_file_name = "art_" . time() . ".{$ext}"; $targetPath = 'images/articles/' . $target_file_name; $targetPathThumb = 'images/articles/thumb_' . $target_file_name; $filterFileRename = new Zend_Filter_File_Rename(array('target' => $targetPath, 'overwrite' => true)); $filterFileRename->filter($file_name); $thumb = Base_Image_PhpThumbFactory::create($targetPath); $thumb->resize(100, 64); $thumb->save($targetPathThumb); } //end if /*------------------------------Image Upload ---------------------------*/ $params = $options; $params['status'] = 1; if ($options["savePublish"] != "Save and Publish") { $params['status'] = 0; } //commented by mahipal on 29-dec-2010 and replaced with user dropdown list //$usersNs = new Zend_Session_Namespace("members"); //$params['userId'] = $usersNs->userId; $params['image'] = $target_file_name; // file name $model = new Application_Model_Articles($params); $id = $page_id = $model->save(); $seo_url_title = $options['identifire']; $articleM = new Application_Model_Articles(); $article = $articleM->find($id); $seo_url = ""; $actual_url = "/work-study-volunteer/article-detail/id/{$id}"; if (false !== $article) { $sanitizeM = new Base_Sanitize(); $category_id = $article->getCategoryId(); $categoryM = new Application_Model_Category(); $category = $categoryM->find($category_id); if (false !== $category) { //$seo_url="/work-study-volunteer/".$category->getType()."/".$sanitizeM->sanitize($category->getName())."/".$seo_url_title; $seo_url = "/work-study-volunteer/" . $sanitizeM->sanitize($category->getName()) . "/" . $seo_url_title; } } $seoUrlM = new Application_Model_SeoUrl(); $seoUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'"); if (false !== $seoUrl) { if ($seo_url != "") { $seoUrl->setSeoUrl($seo_url); $seoUrl->save(); } } else { if ($seo_url != "") { $seoUrl = new Application_Model_SeoUrl(); $seoUrl->setActualUrl($actual_url); $seoUrl->setSeoUrl($seo_url); $seoUrl->save(); } } //$this->_helper->redirector('add','articles','admin',array('id'=>$page_id,'m'=>'s')); if ($options["savePublish"] == "Save and Publish") { $_SESSION['errorMsg'] = "Article has been saved & published successfully."; $this->_helper->redirector('index', 'articles', 'admin'); } else { if ($options["saveUnpublish"] == "Save and Unpublish") { $_SESSION['errorMsg'] = "Article has been saved successfully."; $this->_helper->redirector('index', 'articles', 'admin'); } else { $this->_helper->redirector('edit', 'articles', 'admin', array('id' => $page_id, 'preview' => 'true')); } } } //end if } //end if $this->view->form = $form; }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 2-Dec-2010 * @Description : Used to parse Lonely Planet Country XML and save data to database table */ public function lonelyXmlAction() { //disable layout and view $this->view->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); //create Db and Sanitize class objects $db = Zend_Registry::get("db"); $sanitizeM = new Base_Sanitize(); //Truncate or Empty table first $db->query("TRUNCATE TABLE lonely_planet_country"); //$directory="data/1615/xml/20110119/"; $directory = "data/1615/xml/20110304/"; //$directory="data/1615/xml/test/"; if (!($dp = opendir($directory))) { die("Cannot open {$directory}."); } $countFiles = 1; while ($filename = readdir($dp)) { $file_path = ""; if (is_dir($filename)) { continue; } else { if ($filename != '.' && $filename != '..') { $fileExtension = explode(".", $filename); $fileExtension = strtolower($fileExtension[count($fileExtension) - 1]); if ($fileExtension == "xml") { $file_path = $directory . $filename; //open and replace HTMl tags from XML file and rewrite $fileContent = ""; $fh = ""; $fileContent = file_get_contents($file_path); $fileContent = $this->replaceText($fileContent); $fh = fopen($file_path, 'w+') or die("can't open file"); fwrite($fh, $fileContent); fclose($fh); //now load XML files and parse XMLs $data = array(); echo "<br><br>Strart processing file==><b>" . $file_path . "</b> counter=>" . $countFiles; $destination = simplexml_load_file($file_path); $data["node_id"] = (string) $destination["node_id"]; $data["destination_name"] = (string) $sanitizeM->clearInputs($destination->destination_name); $data["full_destination_name"] = (string) $destination->general->full_destination_name; $data["intro_mini"] = (string) $this->replaceText($destination->general->intro_mini, true); $data["intro_short"] = (string) $this->replaceText($destination->general->intro_short, true); $data["warning_title"] = (string) $destination->general->warning_title; $data["warning_text"] = (string) $this->replaceText($destination->general->warning_text, true); $data["warning_position"] = (string) $destination->general->warning_position; $data["warning_severity"] = (string) $destination->general->warning_severity; //timezones if ($destination->general->timezones) { $tz = 0; $arrayTimezone = array(); foreach ($destination->general->timezones->children() as $timezone) { $arrayTimezone[$tz]['gmt_utc'] = (string) $timezone->gmt_utc; $tz++; } $data["timezones"] = serialize($arrayTimezone); } $data["weights_measures_system"] = (string) $destination->general->weights_measures_system; $data["capital_city"] = (string) $destination->general->capital_city; //government leaders if ($destination->government->leaders) { $ld = 0; $arrayLeaders = array(); foreach ($destination->government->leaders->children() as $leader) { $arrayLeaders[$ld]['leader_name'] = (string) $leader->leader_name; $arrayLeaders[$ld]['leader_type'] = (string) $leader->leader_type; $arrayLeaders[$ld]['leader_title'] = (string) $leader->leader_title; $ld++; } $data["leaders"] = serialize($arrayLeaders); } $data["government_type"] = (string) $destination->government->government_type; $data["area_sqkm"] = (string) $destination->environment->area_sqkm; $data["population"] = (string) $destination->environment->population; //languages $i = 0; if ($destination->society->language_spokens) { $arrayLanguage = array(); foreach ($destination->society->language_spokens->children() as $language_spoken) { $arrayLanguage[$i]['language_spoken_type'] = (string) $language_spoken->language_spoken_type; $arrayLanguage[$i]['language_spoken_name'] = (string) $language_spoken->language_spoken_name; if ($language_spoken->language_spoken_description) { $arrayLanguage[$i]['language_spoken_description'] = (string) $this->replaceText($language_spoken->language_spoken_description, true); } $i++; } $data["language_spokens"] = serialize($arrayLanguage); } $data["religion"] = (string) $this->replaceText($destination->society->religion, true); $data["currency_code"] = (string) $destination->economy->currency_code; $data["currency_name"] = (string) $destination->economy->currency_name; $data["currency_symbol"] = (string) $destination->economy->currency_symbol; $data["currency_unit"] = (string) $destination->economy->currency_unit; //$data["relative_cost_rooms"]=serialize($destination->money->relative_cost_rooms); //$data["relative_cost_meals"]=serialize($destination->money->relative_cost_meals); $pre = 'pre-departure'; $when_to_go = $destination->{$pre}->when_to_go; $data["when_to_go"] = (string) $this->replaceText($destination->{$pre}->when_to_go, true); $data["visas_overview"] = (string) $this->replaceText($destination->{$pre}->visas_overview, true); //electrical plugs if ($destination->{$pre}->electrical_plugs) { $ep = 0; $arrayElectricalPlugs = array(); foreach ($destination->{$pre}->electrical_plugs->children() as $electrical_plugs) { $arrayElectricalPlugs[$ep]['image_filename'] = (string) $electrical_plugs->image_filename; $arrayElectricalPlugs[$ep]['electrical_plug_description'] = (string) $this->replaceText($electrical_plugs->electrical_plug_description, true); $ep++; } $data["electrical_plugs"] = serialize($arrayElectricalPlugs); } $data["electricity_voltage"] = (string) $destination->{$pre}->electricity_voltage; $data["electricity_hz"] = (string) $destination->{$pre}->electricity_hz; $data["dangers_and_annoyances"] = (string) $this->replaceText($destination->health->dangers_and_annoyances, true); //health conditions if ($destination->health->health_conditions) { $arrHealthCondition = array(); foreach ($destination->health->health_conditions->children() as $healthCondition) { $type = ""; $type = (string) $healthCondition->health_condition_type; $arrHealthCondition[$type] = (string) $this->replaceText($healthCondition->health_condition_description, true); } $data["health_conditions"] = serialize($arrHealthCondition); } $data["weather_overview"] = (string) $this->replaceText($destination->weather->weather_overview, true); $data["country_dialling_code"] = (string) $destination->communication->country_dialling_code; //transports if ($destination->transport) { $arrTransport = array(); foreach ($destination->transport->destination_transport_topics->children() as $transport) { $transport_type = ""; $transport_type = (string) $transport->transport_type; $arrTransport[$transport_type] = (string) $this->replaceText($transport->transport_description, true); } $data["transport"] = serialize($arrTransport); } $data["history_pre_20c"] = (string) $this->replaceText($destination->culture->history_pre_20c, true); $data["history_modern"] = (string) $this->replaceText($destination->culture->history_modern, true); $data["history_recent"] = (string) $this->replaceText($destination->culture->history_recent, true); //$data["product_info"]=serialize($destination->product_info); //get images if ($destination->images) { $img = 0; $arrayImages = array(); foreach ($destination->images->children() as $image) { $arrayImages[$img]['image_caption'] = (string) $image->image_caption; $arrayImages[$img]['image_photographer'] = (string) $image->image_photographer; $arrayImages[$img]['image_filename'] = (string) $image->image_filename; $arrayImages[$img]['image_thumbnail_filename'] = (string) $image->image_thumbnail_filename; $img++; } $data["images"] = serialize($arrayImages); } //get maps if ($destination->map) { $arrayMaps = array(); $arrayMaps['map_name'] = (string) $destination->map->map_name; $arrayMaps['map_filename'] = (string) $destination->map->map_filename; $arrayMaps['map_thumbnail_filename'] = (string) $destination->map->map_thumbnail_filename; $data["map"] = serialize($arrayMaps); } $i = 0; foreach ($destination->pois->children() as $poi) { $arrayPoi[$i]['poi_name'] = (string) $poi->poi_name; $address_parts = (array) $poi->address_parts; $addressPart = array(); if (isset($address_parts['address_part']) && count($address_parts['address_part']) > 0) { foreach ($address_parts['address_part'] as $address_part) { $addressPart[] = (array) $address_part; } $arrayPoi[$i]['address_parts'] = $addressPart; } $arrayPoi[$i]['address_postcode'] = (string) $poi->address_postcode; $arrayPoi[$i]['poi_web'] = (string) $poi->poi_web; $arrayPoi[$i]['review_summary'] = (string) $this->replaceText($poi->review_summary, true); $arrayPoi[$i]['review_full'] = (string) $this->replaceText($poi->review_full, true); $arrayPoi[$i]['keywords'] = (array) $poi->keywords; $i++; } $data["pois"] = serialize($arrayPoi); //attrations if ($destination->attractions) { $attr = 0; $arrayAttr = array(); foreach ($destination->attractions->children() as $attraction) { $arrayAttr[$attr]['destination_name'] = (string) $attraction->destination_name; $arrayAttr[$attr]['full_destination_name'] = (string) $attraction->general->full_destination_name; $arrayAttr[$attr]['intro_short'] = (string) $this->replaceText($attraction->general->intro_short, true); $arrayAttr[$attr]['intro_medium'] = (string) $this->replaceText($attraction->general->intro_medium, true); $attr++; } $data["attractions"] = serialize($arrayAttr); } $data["copyright"] = (string) $destination->copyright; $data["addedon"] = time(); /*----Country Info----*/ $countryM = new Application_Model_Country(); $countryName = $sanitizeM->clearInputs($data["destination_name"]); if (!get_magic_quotes_gpc()) { $countryName = addslashes($countryName); } //$countryName=@mb_convert_encoding($countryName, 'UTssssF8', 'auto'); $country = $countryM->fetchRow("name like '{$countryName}'"); if (false === $country) { //get country continent $continent_id = ""; $continent_id = $countryM->countryContinent($countryName); $countryName = $sanitizeM->clearInputs($data["destination_name"]); //if doesn't exists if (!$this->duplicateCountries($countryName)) { $countryM->setName($countryName); $countryM->setContinentId($continent_id); $country_id = $countryM->save(); } } else { $country_id = $country->getId(); } $data['country_id'] = $country_id; /*---------------*/ //check existing country record in lonely_planet_country table $lonelyM = new Application_Model_LonelyPlanetCountry(); $lonelyM = $lonelyM->fetchRow("country_id={$country_id}"); if (false !== $lonelyM) { $res = $db->update("lonely_planet_country", $data, "country_id={$country_id}"); } else { $res = $db->insert("lonely_planet_country", $data); } echo "<br>END File==><b>" . $file_path . "</b> has been processed, counter=>" . $countFiles; $countFiles++; } //end of if } } //end of else if } //end of while closedir($dp); //rename countries name $db->query("UPDATE country SET name='Bosnia and Herzogovina' WHERE name='Bosnia-Hercegovina'"); $db->query("UPDATE country SET name='Vatican City' WHERE name='Holy See'"); $db->query("UPDATE country SET name='Ivory Coast' WHERE name='Cote dIvoire'"); //delete countries for which no planet feeds data available //$sSQlQuery = "DELETE FROM country WHERE id IN(select t.id FROM (SELECT id FROM `country` WHERE id NOT IN (SELECT country_id FROM lonely_planet_country WHERE country_id IS NOT NULL)) AS t)"; //$db->query($sSQlQuery); }