5,531 thoughts on “Support”

1. Hi,
   I use a resource selection form in the WP Booking Calendar Business Large version. The order of the resources in the select menu is by ID. Can this be changed? I like my rooms in alphabetical order instead of this order by ID.
   thanks in advance,
   Bat

   Reply ↓

   • Hello.
     The booking resources are sorting by priority.
     Please open the Booking > Resources page and set the specific priority to each booking resource.

     Reply ↓

     • Thanks for the quick reply.
       I tried changing the priority numbers, but it doesn’t change a thing. See screenshots: ‘Suite: Palace’ has priority 11 and is in the first place, ‘Charme: Bloesem’ has priority 0 and is in the middle… What am I doing wrong?
       <img src=”http://www.exelmans.be//www/bug-reports/pachthof1.png” />
       <img src=”http://www.exelmans.be//www/bug-reports/pachthof2.png” />
        

       Reply ↓

       • I posted wrong screenshot links:
         http://www.exelmans.be/bug-reports/pachthof1.png
         http://www.exelmans.be/bug-reports/pachthof1.png

         Reply ↓

         • Yes, you are right. For fixing of that issue you are need to make this fix:

           Please open this file ../booking/inc/persoanl.php

           find this code:

                      // Select the booking resources
                      if ( ! empty($my_boook_type) ) $where = ' WHERE booking_type_id IN ('.$my_boook_type.') ' ;
                      else                           $where = ' ';
                      $types_list = $wpdb->get_results( "SELECT booking_type_id as id, title FROM ".$wpdb->prefix ."bookingtypes" . $where );
           

           and replace it to this code:

                      if ( ! empty($my_boook_type) ) $where = ' WHERE booking_type_id IN ('.$my_boook_type.') ' ;
                      else                           $where = ' ';
                      
                      $or_sort = 'title_asc';
                      if ( class_exists('wpdev_bk_biz_l')) $or_sort = 'prioritet';
                       
                      if (strpos($or_sort, '_asc') !== false) {                            // Order
                              $or_sort = str_replace('_asc', '', $or_sort);
                              $sql_order = " ORDER BY " .$or_sort ." ASC ";
                      } else $sql_order = " ORDER BY " .$or_sort ." DESC ";
                       
                      $types_list = $wpdb->get_results( "SELECT booking_type_id as id, title FROM ".$wpdb->prefix ."bookingtypes" . $where . $sql_order);
           

           Reply ↓