Title: MattArch's Replies | WordPress.org

---

# MattArch

  [  ](https://wordpress.org/support/users/mattarch/)

 *   [Profile](https://wordpress.org/support/users/mattarch/)
 *   [Topics Started](https://wordpress.org/support/users/mattarch/topics/)
 *   [Replies Created](https://wordpress.org/support/users/mattarch/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/mattarch/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/mattarch/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/mattarch/engagements/)
 *   [Favorites](https://wordpress.org/support/users/mattarch/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Advanced Custom Fields: Image Crop Add-on] Editing the crop brings up blank, black (alpha=0.5) screen](https://wordpress.org/support/topic/editing-the-crop-brings-up-blank-black-alpha05-screen/)
 *  [MattArch](https://wordpress.org/support/users/mattarch/)
 * (@mattarch)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/editing-the-crop-brings-up-blank-black-alpha05-screen/#post-6304296)
 * I am also having this issue
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] Multiple Store Locators / Only show specific stores](https://wordpress.org/support/topic/multiple-store-locators-only-show-specific-stores/)
 *  Thread Starter [MattArch](https://wordpress.org/support/users/mattarch/)
 * (@mattarch)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/multiple-store-locators-only-show-specific-stores/#post-5834427)
 * I’m working on a solution. There seems to be a problem with it not reading the
   updated variable. Will update if fixed. This isn’t asking for help (just editing
   an overeager solution I posted)
 *     ```
       $onlyThis;
           $pageURL = $_SERVER[REQUEST_URI];
           if (strpos($pageURL, "URL_STORE_NAME")!==false){
               $onlyThis = "WHERE store LIKE 'STORE_NAME'";
           }
           else {
              $onlyThis = "WHERE store NOT LIKE 'STORE_NAME'";
           }
   
           $result = $wpdb->get_results(
                           $wpdb->prepare( "
                                           SELECT *, ( $distance_unit * acos( cos( radians( %s ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( %s ) ) + sin( radians( %s ) ) * sin( radians( lat ) ) ) )
                                           AS distance FROM $wpdb->wpsl_stores $onlyThis
                                           $sql_part
                                           ",
                                           $placeholders
                           )
                       );
       ```
   
 * As this is modifying the plugin, just remember you won’t be able to update.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] Multiple Store Locators / Only show specific stores](https://wordpress.org/support/topic/multiple-store-locators-only-show-specific-stores/)
 *  Thread Starter [MattArch](https://wordpress.org/support/users/mattarch/)
 * (@mattarch)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/multiple-store-locators-only-show-specific-stores/#post-5834417)
 * That’s what I thought. I’ll just have to tell them it’s more work that it’s worth.
 * Thanks Tijmen
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Owl Carousel] Change HTML structure](https://wordpress.org/support/topic/change-html-structure/)
 *  Thread Starter [MattArch](https://wordpress.org/support/users/mattarch/)
 * (@mattarch)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/change-html-structure/#post-5503890)
 * That’s perfect, thanks.

Viewing 4 replies - 1 through 4 (of 4 total)