ahsesino

I manage to solve the issues with the categories Just dont put the shorcode in sub-pages of another one.

Thanks for the reply Allen, if you want to translate the plugin to Spanish (Mexican) let me know since I all ready translated the frontend of it to display in that language.

Hi Allen thanks for this amazing plugin,

I was wondering if you could add Mexican currency since I’m using this plugin for a Mexican quadriplegic foundation

Thanks in advance.

I forgot to mention that address’s in mexico are the same as the US (street name, #, city, state and zip) are used and the currency symbol is the same but the currency code is MXN peso.

Below is a list with all Mexican states and abbreviations for each

Aguascalientes = AG
Morelos = MO
Baja California Norte = BC
Nayarit = NA
Baja California Sur = BS
Nuevo Leon = NL
Campeche = CM
Oaxaca = OA
Chiapas = CS
Puebla = PU
Chihuahua = CH
Queretaro = QT
Coahuila = CO
Quintana Roo = QR
Colima = CL
San Luis Potosi = SL
Distrito Federal = DF
Sinaloa = SI
Durango = DG
Sonora = SO
Guanajuato = GT
Tabasco = TB
Guerrero = GR
Tamaulipas = TM
Hidalgo = HG
Tlaxcala = TL
Jalisco = JA
Veracruz = VE
Mexico = MX
Yucatan = YU
Michoacán = MI
Zacatecas = ZA

Hi Allen thanks for this amazing plugin,

I was wondering if you could add Mexican currency since I’m using this plugin for a Mexican quadriplegic foundation

Thanks in advance.

Wow your a genius, it worked like a charm. On my defense its the 2nd wp site I build so I’m still learning.

Thanks a lot.

Best regards;

Omar

Hello Jose thanks for the reply and for trying to help me with this issue, the code you posted above breaks the plugin but thats not an issue. I manage to come up with a solution that retrieves the info but it’s about 90% complete since it retrieves all data from each table instead of retrieving the info that corresponds to that specific post. the code is below also.

global $wpdb;
 $prefix = $wpdb->prefix;//get current site table prefix
 $table_listings = 'rex_listings'; // name to attach to prefix
 $tablename = $prefix.''.$table_listings; // combine prefix and name
 $table_posts = 'posts';
 $table = $prefix.''.$table_posts;
 //start the query and echo results
 $result = $wpdb->get_results("SELECT listing_id, price, bedrooms, baths, floor_space FROM $tablename, $table WHERE $tablename.listing_id =     $table.id");
foreach($result as $row ){
 echo "<div class='info'> Listing ID: <span> $row->listing_id</span>  Price: <span>$ $row->price</span>  Bedrooms: <span>$row->bedrooms</span>  Baths: <span>$row->baths</span>  Floor Space: <span>$row->floor_space sqm</span> </div>";
 }

this is where I’m currently stuck.
You can see this bit of code in action at the following link: apit.gruposanoja.com/inmuebles

the only issue right now is possibly a join that is not working correctly and I cant figure it out if my life depended on it.

Thanks again for the reply.

Based on my last post this is what I came up with to retrieve the data:

// Get all blog ids
$blogids = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs");
  foreach ($blogids as $blog_id)
  {
    $query = ('SELECT price, bedrooms, bath, floor_space, address FROM $wpdb->%rex_listing%');
    if($listing = ($query)) //run query
    {
     //retrieve and echo every record
     while ($row = mysql_fetch_array($listing))
     {
	echo "<p>{$row['price']}<br />
		 {$row['bedrooms']}<br />
		 {$row['bath']}<br />
		 {$row['floor_space']}<br />
		 {$row['address']}</p>\n";
     }
     } else {
	mysql_close();
     }
   }

Now I’m just trying to figure out where to place it nad crossing my fingers the syntax is correct since I’m fairly new to WordPress.

Thanks for the fast reply Jose, the answer to your question about the plugin storing blog IDs well it doesn’t, this plugin is not a multisite plugin so it creates a new table for each blog ID within the DB; giving the following name per blog ID : wp_#_rex_listings.
I added the realors code right below

switch_to_blog($all_blogkeys[$field->guid]);

     esc_html_e('Price: ', 'realtor-express');
     echo esc_html( $listing->getPrice() ); 

     esc_html_e('Bedrooms: ', 'realtor-express');
     echo esc_html( $listing->bedrooms ); 

     esc_html_e('Baths: ', 'realtor-express');
     echo esc_html( $listing->baths ); 

     esc_html_e('Floor Space: ', 'realtor-express');
     echo esc_html( $listing->floor_space ) . " " . $floor_space_units;

and all it did was remove the post and display:

Price:

well the logic in my head tells me I need to add a query in your code per post to select table “wp_#_rex_listings” and display Price, Bedrooms, Baths, Floor space and address for every post. I’m guessing it would have to go right below line 716 since I want to display the info there.

Sorry just got my answer; 5.3 Users need to use ver. 1.8

Hello All,
I have the same problem, I know the server I’m using has php 5.3 and this plugin requires 5.4. Is there a way around it since the engineers with my hosting provider are taking their sweet ass time to figure out how to install php 5.4 on their server farm

Fixed the issue by changing the permalinks needs to be on post name hope that helps everyone that may have issues with this version.