magnaromagna

Ok, done and works fine.

Thanks I understand. But since I have to change tons of cities, I’d like to know if instead using the merging tool I can massively change the
post_locations
and
post_region
fields, as described above. Be patient, I have to change more than 8,000 cities. Thanks again

Ok, thanks, I will update them into database. A quick question:
Need only to modify
post_locations
from [City],[Region],[Italy]
to [city],[region],[italy]

or also:

post_city
from City to city

post_region
from Region to region

?

Maybe this is extra support question:
– a global sql query to make all in lowercase, like

UPDATE mytable SET name = LOWER(name);

is it correct?

UPDATE geodir_gd_place_detail SET post_locations = LOWER(post_locations);

Thank you as usual

Restored the virtual page and now seems works fine, thanks.
Now I learned that virtual pages are not to be touched!

Thanks. I followed instructions, and inserted the code mentionned by adding at first place the review tab instead the profile tab. But opening a detail page is still show the Profile as default (even in 2nd tabs instead of 1st). My question is how can I force open the review tab instead the profile tab. Maybe through CSS? Thanks again

// begin change order tabs //

add_filter('geodir_detail_page_tab_list_extend', 'geodir_detail_page_tab_list_extend') ;

function geodir_detail_page_tab_list_extend($tab_array)
{
 // here u can modify this array, u can create a completely new one too.
     if(isset($tab_array['reviews'])){
         $new_tab_array['reviews'] = $tab_array['reviews'];// set in new array
		 unset($tab_array['reviews']);//unset in old one
	 }
     if(isset($tab_array['post_profile'])){
         $new_tab_array['post_profile'] = $tab_array['post_profile']; // set in new array
		 unset($tab_array['post_profile']);//unset in old one
	 }

     if(isset($tab_array['post_map'])){
         $new_tab_array['post_map'] = $tab_array['post_map'];// set in new array
		 unset($tab_array['post_map']);//unset in old one
	 }

    if(isset($tab_array['special_offers'])){
         $new_tab_array['special_offers'] = $tab_array['special_offers'];// set in new array
		 unset($tab_array['special_offers']);//unset in old one
	}

     if(isset($tab_array['post_info'])){
         $new_tab_array['post_info'] = $tab_array['post_info'];// set in new array
		 unset($tab_array['post_info']);//unset in old one
	 }

    if(isset($tab_array['post_images'])){
         $new_tab_array['post_images'] = $tab_array['post_images'];// set in new array
		 unset($tab_array['post_images']);//unset in old one
	}

    if(isset($tab_array['post_video'])){
         $new_tab_array['post_video'] = $tab_array['post_video'];// set in new array
		 unset($tab_array['post_video']);//unset in old one
	}

     if(isset($tab_array['special_offers'])){
         $new_tab_array['special_offers'] = $tab_array['special_offers'];// set in new array
		 unset($tab_array['special_offers']);//unset in old one
	 }

     

	// now we set any remaining tabs that have not been assigned an order
	foreach($tab_array as $key=>$tab){
	$new_tab_array[$key]=$tab;
	}

    return $new_tab_array ;
}

// end change order tabs //