an
groups-icon

8.9 Mapdata Query (thumbs not showing in marker details)

Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    Peter Snelders
    0 points
    Beginner

    I found an error in the Mapdata SQL Query which prevented to show the marker thumbnail in the popup. Just REMOVE the “LIMIT 1” in:

    $gg[0] = str_replace(“WHERE 1=1”,
    “INNER JOIN “.$wpdb->postmeta.” pm0 ON (“.$wpdb->posts.”.ID = pm0.post_id AND pm0.meta_key =’map-lat’ AND pm0.meta_value !=” )
    INNER JOIN “.$wpdb->postmeta.” pm1 ON (“.$wpdb->posts.”.ID = pm1.post_id AND pm1.meta_key =’map-log’ AND pm1.meta_value !=” )
    LEFT JOIN “.$wpdb->postmeta.” pm2 ON (“.$wpdb->posts.”.ID = pm2.post_id AND pm2.meta_key =’_thumbnail_id’ )
    LEFT JOIN (SELECT t1.* FROM “.$wpdb->posts.” AS t1 WHERE t1.post_type=’attachment’ LIMIT 1 ) AS b ON b.ID = pm2.meta_value
    WHERE 1=1″, $gg[0]);

    January 19, 2016 at 9:39 am
  • Mark Fail
    11,845 points
    Platinum User
    Bronze User Silver User Gold User Platinum User Helpful Award Fast Responder Thank You Coffee Villian Award Video Testimonial
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    January 19, 2016 at 10:09 am
  • Peter Snelders
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    January 19, 2016 at 10:13 am
  • Mark Fail
    11,845 points
    Platinum User
    Bronze User Silver User Gold User Platinum User Helpful Award Fast Responder Thank You Coffee Villian Award Video Testimonial
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    January 19, 2016 at 11:16 am

337

Views

3

Replies