Booking Calendar - Version 4.0.2

Version Description

  • WordPress 3.5 compatibility.
Download this release

Release Info

Developer wpdevelop
Plugin Icon 128x128 Booking Calendar
Version 4.0.2
Comparing to
See all releases

Code changes from version 4.0.1 to 4.0.2

Files changed (8) hide show
  1. interface/bs/css/bs.css +2 -2
  2. interface/bs/css/bs.min.css +1 -1
  3. lib/wpdev-bk-lib.php +10 -5
  4. lib/wpdev-booking-ajax.php +8 -8
  5. lib/wpdev-booking-class.php +31 -28
  6. lib/wpdev-booking-functions.php +7 -7
  7. readme.txt +7 -4
  8. wpdev-booking.php +4 -2
interface/bs/css/bs.css CHANGED
@@ -3468,7 +3468,7 @@
3468
  }
3469
  }
3470
  @media (min-width: 768px) and (max-width: 980px) {
3471
- .row {
3472
  margin-left: -20px;
3473
  *zoom: 1;
3474
  }
@@ -3749,7 +3749,7 @@
3749
  }
3750
  }
3751
  @media (min-width: 1200px) {
3752
- .row {
3753
  margin-left: -30px;
3754
  *zoom: 1;
3755
  }
3468
  }
3469
  }
3470
  @media (min-width: 768px) and (max-width: 980px) {
3471
+ .wpdevbk .row {
3472
  margin-left: -20px;
3473
  *zoom: 1;
3474
  }
3749
  }
3750
  }
3751
  @media (min-width: 1200px) {
3752
+ .wpdevbk .row {
3753
  margin-left: -30px;
3754
  *zoom: 1;
3755
  }
interface/bs/css/bs.min.css CHANGED
@@ -14,4 +14,4 @@
14
  * http://www.apache.org/licenses/LICENSE-2.0
15
  *
16
  * Designed and built with all the love in the world @twitter by @mdo and @fat.
17
- */.hidden{display:none;visibility:hidden}@media(max-width:480px){.nav-collapse{-webkit-transform:translate3d(0,0,0)}.wpdevbk .page-header h1 small{display:block;line-height:18px}.wpdevbk input[class*="span"],.wpdevbk select[class*="span"],.wpdevbk textarea[class*="span"],.wpdevbk .uneditable-input{display:block;width:100%;height:28px;-webkit-box-sizing:border-box;-moz-box-sizing:border-box;-ms-box-sizing:border-box;box-sizing:border-box}.wpdevbk .input-prepend input[class*="span"],.wpdevbk .input-append input[class*="span"]{width:auto}.wpdevbk input[type="checkbox"],.wpdevbk input[type="radio"]{border:1px solid #ccc}.wpdevbk .form-horizontal .control-group>label{float:none;width:auto;padding-top:0;text-align:left}.wpdevbk .form-horizontal .controls{margin-left:0}.wpdevbk .form-horizontal .control-list{padding-top:0}.wpdevbk .form-horizontal .form-actions{padding-left:10px;padding-right:10px}.wpdevbk .modal{position:absolute;top:10px;left:10px;right:10px;width:auto;margin:0}.wpdevbk .modal.fade.in{top:auto}.wpdevbk .modal-header .close{padding:10px;margin:-10px}.wpdevbk .carousel-caption{position:static}}@media(max-width:768px){.container{width:auto;padding:0 20px}.wpdevbk .row-fluid{width:100%}.wpdevbk .row{margin-left:0}.wpdevbk .row>[class*="span"],.wpdevbk .row-fluid>[class*="span"]{float:none;display:block;width:auto;margin:0}}@media(min-width:768px) and (max-width:980px){.row{margin-left:-20px;*zoom:1}.wpdevbk .row:before,.wpdevbk .row:after{display:table;content:""}.wpdevbk .row:after{clear:both}.wpdevbk [class*="span"]{float:left;margin-left:20px}.wpdevbk .span1{width:42px}.wpdevbk .span2{width:104px}.wpdevbk .span3{width:166px}.wpdevbk .span4{width:228px}.wpdevbk .span5{width:290px}.wpdevbk .span6{width:352px}.wpdevbk .span7{width:414px}.wpdevbk .span8{width:476px}.wpdevbk .span9{width:538px}.wpdevbk .span10{width:600px}.wpdevbk .span11{width:662px}.wpdevbk .span12,.wpdevbk .container{width:724px}.wpdevbk .offset1{margin-left:82px}.wpdevbk .offset2{margin-left:144px}.wpdevbk .offset3{margin-left:206px}.wpdevbk .offset4{margin-left:268px}.wpdevbk .offset5{margin-left:330px}.wpdevbk .offset6{margin-left:392px}.wpdevbk .offset7{margin-left:454px}.wpdevbk .offset8{margin-left:516px}.wpdevbk .offset9{margin-left:578px}.wpdevbk .offset10{margin-left:640px}.wpdevbk .offset11{margin-left:702px}.wpdevbk .row-fluid{width:100%;*zoom:1}.wpdevbk .row-fluid:before,.wpdevbk .row-fluid:after{display:table;content:""}.wpdevbk .row-fluid:after{clear:both}.wpdevbk .row-fluid>[class*="span"]{float:left;margin-left:2.762430939%}.wpdevbk .row-fluid>[class*="span"]:first-child{margin-left:0}.wpdevbk .row-fluid .span1{width:5.801104972%}.wpdevbk .row-fluid .span2{width:14.364640883%}.wpdevbk .row-fluid .span3{width:22.928176794%}.wpdevbk .row-fluid .span4{width:31.491712705%}.wpdevbk .row-fluid .span5{width:40.055248616%}.wpdevbk .row-fluid .span6{width:48.618784527%}.wpdevbk .row-fluid .span7{width:57.182320438000005%}.wpdevbk .row-fluid .span8{width:65.74585634900001%}.wpdevbk .row-fluid .span9{width:74.30939226%}.wpdevbk .row-fluid .span10{width:82.87292817100001%}.wpdevbk .row-fluid .span11{width:91.436464082%}.wpdevbk .row-fluid .span12{width:99.999999993%}.wpdevbk input.span1,.wpdevbk textarea.span1,.wpdevbk .uneditable-input.span1{width:32px}.wpdevbk input.span2,.wpdevbk textarea.span2,.wpdevbk .uneditable-input.span2{width:94px}.wpdevbk input.span3,.wpdevbk textarea.span3,.wpdevbk .uneditable-input.span3{width:156px}.wpdevbk input.span4,.wpdevbk textarea.span4,.wpdevbk .uneditable-input.span4{width:218px}.wpdevbk input.span5,.wpdevbk textarea.span5,.wpdevbk .uneditable-input.span5{width:280px}.wpdevbk input.span6,.wpdevbk textarea.span6,.wpdevbk .uneditable-input.span6{width:342px}.wpdevbk input.span7,.wpdevbk textarea.span7,.wpdevbk .uneditable-input.span7{width:404px}.wpdevbk input.span8,.wpdevbk textarea.span8,.wpdevbk .uneditable-input.span8{width:466px}.wpdevbk input.span9,.wpdevbk textarea.span9,.wpdevbk .uneditable-input.span9{width:528px}.wpdevbk input.span10,.wpdevbk textarea.span10,.wpdevbk .uneditable-input.span10{width:590px}.wpdevbk input.span11,.wpdevbk textarea.span11,.wpdevbk .uneditable-input.span11{width:652px}.wpdevbk input.span12,.wpdevbk textarea.span12,.wpdevbk .uneditable-input.span12{width:714px}}@media(max-width:980px){body{padding-top:0}.wpdevbk .navbar-fixed-top{position:static;margin-bottom:18px}.wpdevbk .navbar-fixed-top .navbar-inner{padding:5px}.wpdevbk .navbar .container{width:auto;padding:0}.wpdevbk .navbar .brand{padding-left:10px;padding-right:10px;margin:0 0 0 -5px}.wpdevbk .navbar .nav-collapse{clear:left}.wpdevbk .navbar .nav{float:none;margin:0 0 9px}.wpdevbk .navbar .nav>li{float:none}.wpdevbk .navbar .nav>li>a{margin-bottom:2px}.wpdevbk .navbar .nav>.divider-vertical{display:none}.wpdevbk .navbar .nav>li>a,.wpdevbk .navbar .dropdown-menu a{padding:6px 15px;font-weight:bold;color:#999;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px}.wpdevbk .navbar .dropdown-menu li+li a{margin-bottom:2px}.wpdevbk .navbar .nav>li>a:hover,.wpdevbk .navbar .dropdown-menu a:hover{background-color:#222}.wpdevbk .navbar .dropdown-menu{position:static;top:auto;left:auto;float:none;display:block;max-width:none;margin:0 15px;padding:0;background-color:transparent;border:0;-webkit-border-radius:0;-moz-border-radius:0;border-radius:0;-webkit-box-shadow:none;-moz-box-shadow:none;box-shadow:none}.wpdevbk .navbar .dropdown-menu:before,.wpdevbk .navbar .dropdown-menu:after{display:none}.wpdevbk .navbar .dropdown-menu .divider{display:none}.wpdevbk .navbar-form,.wpdevbk .navbar-search{float:none;padding:9px 15px;margin:9px 0;border-top:1px solid #222;border-bottom:1px solid #222;-webkit-box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1);-moz-box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1);box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1)}.wpdevbk .navbar .nav.pull-right{float:none;margin-left:0}.wpdevbk .navbar-static .navbar-inner{padding-left:10px;padding-right:10px}.wpdevbk .btn-navbar{display:block}.wpdevbk .nav-collapse{overflow:hidden;height:0}}@media(min-width:980px){.nav-collapse.collapse{height:auto!important}}@media(min-width:1200px){.row{margin-left:-30px;*zoom:1}.wpdevbk .row:before,.wpdevbk .row:after{display:table;content:""}.wpdevbk .row:after{clear:both}.wpdevbk [class*="span"]{float:left;margin-left:30px}.wpdevbk .span1{width:70px}.wpdevbk .span2{width:170px}.wpdevbk .span3{width:270px}.wpdevbk .span4{width:370px}.wpdevbk .span5{width:470px}.wpdevbk .span6{width:570px}.wpdevbk .span7{width:670px}.wpdevbk .span8{width:770px}.wpdevbk .span9{width:870px}.wpdevbk .span10{width:970px}.wpdevbk .span11{width:1070px}.wpdevbk .span12,.wpdevbk .container{width:1170px}.wpdevbk .offset1{margin-left:130px}.wpdevbk .offset2{margin-left:230px}.wpdevbk .offset3{margin-left:330px}.wpdevbk .offset4{margin-left:430px}.wpdevbk .offset5{margin-left:530px}.wpdevbk .offset6{margin-left:630px}.wpdevbk .offset7{margin-left:730px}.wpdevbk .offset8{margin-left:830px}.wpdevbk .offset9{margin-left:930px}.wpdevbk .offset10{margin-left:1030px}.wpdevbk .offset11{margin-left:1130px}.wpdevbk .row-fluid{width:100%;*zoom:1}.wpdevbk .row-fluid:before,.wpdevbk .row-fluid:after{display:table;content:""}.wpdevbk .row-fluid:after{clear:both}.wpdevbk .row-fluid>[class*="span"]{float:left;margin-left:2.564102564%}.wpdevbk .row-fluid>[class*="span"]:first-child{margin-left:0}.wpdevbk .row-fluid .span1{width:5.982905983%}.wpdevbk .row-fluid .span2{width:14.529914530000001%}.wpdevbk .row-fluid .span3{width:23.076923077%}.wpdevbk .row-fluid .span4{width:31.623931624%}.wpdevbk .row-fluid .span5{width:40.170940171000005%}.wpdevbk .row-fluid .span6{width:48.717948718%}.wpdevbk .row-fluid .span7{width:57.264957265%}.wpdevbk .row-fluid .span8{width:65.81196581200001%}.wpdevbk .row-fluid .span9{width:74.358974359%}.wpdevbk .row-fluid .span10{width:82.905982906%}.wpdevbk .row-fluid .span11{width:91.45299145300001%}.wpdevbk .row-fluid .span12{width:100%}.wpdevbk input.span1,.wpdevbk textarea.span1,.wpdevbk .uneditable-input.span1{width:60px}.wpdevbk input.span2,.wpdevbk textarea.span2,.wpdevbk .uneditable-input.span2{width:160px}.wpdevbk input.span3,.wpdevbk textarea.span3,.wpdevbk .uneditable-input.span3{width:260px}.wpdevbk input.span4,.wpdevbk textarea.span4,.wpdevbk .uneditable-input.span4{width:360px}.wpdevbk input.span5,.wpdevbk textarea.span5,.wpdevbk .uneditable-input.span5{width:460px}.wpdevbk input.span6,.wpdevbk textarea.span6,.wpdevbk .uneditable-input.span6{width:560px}.wpdevbk input.span7,.wpdevbk textarea.span7,.wpdevbk .uneditable-input.span7{width:660px}.wpdevbk input.span8,.wpdevbk textarea.span8,.wpdevbk .uneditable-input.span8{width:760px}.wpdevbk input.span9,.wpdevbk textarea.span9,.wpdevbk .uneditable-input.span9{width:860px}.wpdevbk input.span10,.wpdevbk textarea.span10,.wpdevbk .uneditable-input.span10{width:960px}.wpdevbk input.span11,.wpdevbk textarea.span11,.wpdevbk .uneditable-input.span11{width:1060px}.wpdevbk input.span12,.wpdevbk textarea.span12,.wpdevbk .uneditable-input.span12{width:1160px}.wpdevbk .thumbnails{margin-left:-30px}.wpdevbk .thumbnails>li{margin-left:30px}}
14
  * http://www.apache.org/licenses/LICENSE-2.0
15
  *
16
  * Designed and built with all the love in the world @twitter by @mdo and @fat.
17
+ */.hidden{display:none;visibility:hidden}@media(max-width:480px){.nav-collapse{-webkit-transform:translate3d(0,0,0)}.wpdevbk .page-header h1 small{display:block;line-height:18px}.wpdevbk input[class*="span"],.wpdevbk select[class*="span"],.wpdevbk textarea[class*="span"],.wpdevbk .uneditable-input{display:block;width:100%;height:28px;-webkit-box-sizing:border-box;-moz-box-sizing:border-box;-ms-box-sizing:border-box;box-sizing:border-box}.wpdevbk .input-prepend input[class*="span"],.wpdevbk .input-append input[class*="span"]{width:auto}.wpdevbk input[type="checkbox"],.wpdevbk input[type="radio"]{border:1px solid #ccc}.wpdevbk .form-horizontal .control-group>label{float:none;width:auto;padding-top:0;text-align:left}.wpdevbk .form-horizontal .controls{margin-left:0}.wpdevbk .form-horizontal .control-list{padding-top:0}.wpdevbk .form-horizontal .form-actions{padding-left:10px;padding-right:10px}.wpdevbk .modal{position:absolute;top:10px;left:10px;right:10px;width:auto;margin:0}.wpdevbk .modal.fade.in{top:auto}.wpdevbk .modal-header .close{padding:10px;margin:-10px}.wpdevbk .carousel-caption{position:static}}@media(max-width:768px){.container{width:auto;padding:0 20px}.wpdevbk .row-fluid{width:100%}.wpdevbk .row{margin-left:0}.wpdevbk .row>[class*="span"],.wpdevbk .row-fluid>[class*="span"]{float:none;display:block;width:auto;margin:0}}@media(min-width:768px) and (max-width:980px){.wpdevbk .row{margin-left:-20px;*zoom:1}.wpdevbk .row:before,.wpdevbk .row:after{display:table;content:""}.wpdevbk .row:after{clear:both}.wpdevbk [class*="span"]{float:left;margin-left:20px}.wpdevbk .span1{width:42px}.wpdevbk .span2{width:104px}.wpdevbk .span3{width:166px}.wpdevbk .span4{width:228px}.wpdevbk .span5{width:290px}.wpdevbk .span6{width:352px}.wpdevbk .span7{width:414px}.wpdevbk .span8{width:476px}.wpdevbk .span9{width:538px}.wpdevbk .span10{width:600px}.wpdevbk .span11{width:662px}.wpdevbk .span12,.wpdevbk .container{width:724px}.wpdevbk .offset1{margin-left:82px}.wpdevbk .offset2{margin-left:144px}.wpdevbk .offset3{margin-left:206px}.wpdevbk .offset4{margin-left:268px}.wpdevbk .offset5{margin-left:330px}.wpdevbk .offset6{margin-left:392px}.wpdevbk .offset7{margin-left:454px}.wpdevbk .offset8{margin-left:516px}.wpdevbk .offset9{margin-left:578px}.wpdevbk .offset10{margin-left:640px}.wpdevbk .offset11{margin-left:702px}.wpdevbk .row-fluid{width:100%;*zoom:1}.wpdevbk .row-fluid:before,.wpdevbk .row-fluid:after{display:table;content:""}.wpdevbk .row-fluid:after{clear:both}.wpdevbk .row-fluid>[class*="span"]{float:left;margin-left:2.762430939%}.wpdevbk .row-fluid>[class*="span"]:first-child{margin-left:0}.wpdevbk .row-fluid .span1{width:5.801104972%}.wpdevbk .row-fluid .span2{width:14.364640883%}.wpdevbk .row-fluid .span3{width:22.928176794%}.wpdevbk .row-fluid .span4{width:31.491712705%}.wpdevbk .row-fluid .span5{width:40.055248616%}.wpdevbk .row-fluid .span6{width:48.618784527%}.wpdevbk .row-fluid .span7{width:57.182320438000005%}.wpdevbk .row-fluid .span8{width:65.74585634900001%}.wpdevbk .row-fluid .span9{width:74.30939226%}.wpdevbk .row-fluid .span10{width:82.87292817100001%}.wpdevbk .row-fluid .span11{width:91.436464082%}.wpdevbk .row-fluid .span12{width:99.999999993%}.wpdevbk input.span1,.wpdevbk textarea.span1,.wpdevbk .uneditable-input.span1{width:32px}.wpdevbk input.span2,.wpdevbk textarea.span2,.wpdevbk .uneditable-input.span2{width:94px}.wpdevbk input.span3,.wpdevbk textarea.span3,.wpdevbk .uneditable-input.span3{width:156px}.wpdevbk input.span4,.wpdevbk textarea.span4,.wpdevbk .uneditable-input.span4{width:218px}.wpdevbk input.span5,.wpdevbk textarea.span5,.wpdevbk .uneditable-input.span5{width:280px}.wpdevbk input.span6,.wpdevbk textarea.span6,.wpdevbk .uneditable-input.span6{width:342px}.wpdevbk input.span7,.wpdevbk textarea.span7,.wpdevbk .uneditable-input.span7{width:404px}.wpdevbk input.span8,.wpdevbk textarea.span8,.wpdevbk .uneditable-input.span8{width:466px}.wpdevbk input.span9,.wpdevbk textarea.span9,.wpdevbk .uneditable-input.span9{width:528px}.wpdevbk input.span10,.wpdevbk textarea.span10,.wpdevbk .uneditable-input.span10{width:590px}.wpdevbk input.span11,.wpdevbk textarea.span11,.wpdevbk .uneditable-input.span11{width:652px}.wpdevbk input.span12,.wpdevbk textarea.span12,.wpdevbk .uneditable-input.span12{width:714px}}@media(max-width:980px){body{padding-top:0}.wpdevbk .navbar-fixed-top{position:static;margin-bottom:18px}.wpdevbk .navbar-fixed-top .navbar-inner{padding:5px}.wpdevbk .navbar .container{width:auto;padding:0}.wpdevbk .navbar .brand{padding-left:10px;padding-right:10px;margin:0 0 0 -5px}.wpdevbk .navbar .nav-collapse{clear:left}.wpdevbk .navbar .nav{float:none;margin:0 0 9px}.wpdevbk .navbar .nav>li{float:none}.wpdevbk .navbar .nav>li>a{margin-bottom:2px}.wpdevbk .navbar .nav>.divider-vertical{display:none}.wpdevbk .navbar .nav>li>a,.wpdevbk .navbar .dropdown-menu a{padding:6px 15px;font-weight:bold;color:#999;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px}.wpdevbk .navbar .dropdown-menu li+li a{margin-bottom:2px}.wpdevbk .navbar .nav>li>a:hover,.wpdevbk .navbar .dropdown-menu a:hover{background-color:#222}.wpdevbk .navbar .dropdown-menu{position:static;top:auto;left:auto;float:none;display:block;max-width:none;margin:0 15px;padding:0;background-color:transparent;border:0;-webkit-border-radius:0;-moz-border-radius:0;border-radius:0;-webkit-box-shadow:none;-moz-box-shadow:none;box-shadow:none}.wpdevbk .navbar .dropdown-menu:before,.wpdevbk .navbar .dropdown-menu:after{display:none}.wpdevbk .navbar .dropdown-menu .divider{display:none}.wpdevbk .navbar-form,.wpdevbk .navbar-search{float:none;padding:9px 15px;margin:9px 0;border-top:1px solid #222;border-bottom:1px solid #222;-webkit-box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1);-moz-box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1);box-shadow:inset 0 1px 0 rgba(255,255,255,0.1),0 1px 0 rgba(255,255,255,0.1)}.wpdevbk .navbar .nav.pull-right{float:none;margin-left:0}.wpdevbk .navbar-static .navbar-inner{padding-left:10px;padding-right:10px}.wpdevbk .btn-navbar{display:block}.wpdevbk .nav-collapse{overflow:hidden;height:0}}@media(min-width:980px){.nav-collapse.collapse{height:auto!important}}@media(min-width:1200px){.wpdevbk .row{margin-left:-30px;*zoom:1}.wpdevbk .row:before,.wpdevbk .row:after{display:table;content:""}.wpdevbk .row:after{clear:both}.wpdevbk [class*="span"]{float:left;margin-left:30px}.wpdevbk .span1{width:70px}.wpdevbk .span2{width:170px}.wpdevbk .span3{width:270px}.wpdevbk .span4{width:370px}.wpdevbk .span5{width:470px}.wpdevbk .span6{width:570px}.wpdevbk .span7{width:670px}.wpdevbk .span8{width:770px}.wpdevbk .span9{width:870px}.wpdevbk .span10{width:970px}.wpdevbk .span11{width:1070px}.wpdevbk .span12,.wpdevbk .container{width:1170px}.wpdevbk .offset1{margin-left:130px}.wpdevbk .offset2{margin-left:230px}.wpdevbk .offset3{margin-left:330px}.wpdevbk .offset4{margin-left:430px}.wpdevbk .offset5{margin-left:530px}.wpdevbk .offset6{margin-left:630px}.wpdevbk .offset7{margin-left:730px}.wpdevbk .offset8{margin-left:830px}.wpdevbk .offset9{margin-left:930px}.wpdevbk .offset10{margin-left:1030px}.wpdevbk .offset11{margin-left:1130px}.wpdevbk .row-fluid{width:100%;*zoom:1}.wpdevbk .row-fluid:before,.wpdevbk .row-fluid:after{display:table;content:""}.wpdevbk .row-fluid:after{clear:both}.wpdevbk .row-fluid>[class*="span"]{float:left;margin-left:2.564102564%}.wpdevbk .row-fluid>[class*="span"]:first-child{margin-left:0}.wpdevbk .row-fluid .span1{width:5.982905983%}.wpdevbk .row-fluid .span2{width:14.529914530000001%}.wpdevbk .row-fluid .span3{width:23.076923077%}.wpdevbk .row-fluid .span4{width:31.623931624%}.wpdevbk .row-fluid .span5{width:40.170940171000005%}.wpdevbk .row-fluid .span6{width:48.717948718%}.wpdevbk .row-fluid .span7{width:57.264957265%}.wpdevbk .row-fluid .span8{width:65.81196581200001%}.wpdevbk .row-fluid .span9{width:74.358974359%}.wpdevbk .row-fluid .span10{width:82.905982906%}.wpdevbk .row-fluid .span11{width:91.45299145300001%}.wpdevbk .row-fluid .span12{width:100%}.wpdevbk input.span1,.wpdevbk textarea.span1,.wpdevbk .uneditable-input.span1{width:60px}.wpdevbk input.span2,.wpdevbk textarea.span2,.wpdevbk .uneditable-input.span2{width:160px}.wpdevbk input.span3,.wpdevbk textarea.span3,.wpdevbk .uneditable-input.span3{width:260px}.wpdevbk input.span4,.wpdevbk textarea.span4,.wpdevbk .uneditable-input.span4{width:360px}.wpdevbk input.span5,.wpdevbk textarea.span5,.wpdevbk .uneditable-input.span5{width:460px}.wpdevbk input.span6,.wpdevbk textarea.span6,.wpdevbk .uneditable-input.span6{width:560px}.wpdevbk input.span7,.wpdevbk textarea.span7,.wpdevbk .uneditable-input.span7{width:660px}.wpdevbk input.span8,.wpdevbk textarea.span8,.wpdevbk .uneditable-input.span8{width:760px}.wpdevbk input.span9,.wpdevbk textarea.span9,.wpdevbk .uneditable-input.span9{width:860px}.wpdevbk input.span10,.wpdevbk textarea.span10,.wpdevbk .uneditable-input.span10{width:960px}.wpdevbk input.span11,.wpdevbk textarea.span11,.wpdevbk .uneditable-input.span11{width:1060px}.wpdevbk input.span12,.wpdevbk textarea.span12,.wpdevbk .uneditable-input.span12{width:1160px}.wpdevbk .thumbnails{margin-left:-30px}.wpdevbk .thumbnails>li{margin-left:30px}}
lib/wpdev-bk-lib.php CHANGED
@@ -3,7 +3,12 @@
3
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
4
  // S u p p o r t f u n c t i o n s ///////////////////////////////////////////////////////////////////////////////////////////////////
5
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
6
-
 
 
 
 
 
7
  // Change date format
8
  function wpdevbk_get_date_in_correct_format( $dt ) {
9
 
@@ -1095,10 +1100,10 @@ if (empty( $num_per_page_check)) {
1095
  $page_start = ( $page_num - 1 ) * $page_items_count ;
1096
 
1097
  // Get Bookings Array
1098
- $bookings_res = $wpdb->get_results($wpdb->prepare( $sql_start_select . $sql . $sql_where . $sql_order . $sql_limit ));
1099
 
1100
  // Get Number of booking for the pages
1101
- $bookings_count = $wpdb->get_results($wpdb->prepare( $sql_start_count . $sql . $sql_where ));
1102
 
1103
  // Get NUMBER of Bookings
1104
  if (count($bookings_count)>0) $bookings_count = $bookings_count[0]->count ;
@@ -1142,7 +1147,7 @@ if (empty( $num_per_page_check)) {
1142
  else
1143
  $sql .= " ORDER BY booking_id, booking_date ";
1144
 
1145
- $booking_dates = $wpdb->get_results($wpdb->prepare( $sql ));
1146
  } else
1147
  $booking_dates = array();
1148
 
@@ -1593,7 +1598,7 @@ if (empty( $num_items_per_page)) {
1593
  }
1594
  );
1595
 
1596
- jQuery('# a.popover_here').popover( {
1597
  placement: 'bottom'
1598
  , delay: { show: 100, hide: 100 }
1599
  , content: ''
3
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
4
  // S u p p o r t f u n c t i o n s ///////////////////////////////////////////////////////////////////////////////////////////////////
5
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
6
+ function wpdevbk_db_prepare($sql_req){ // Compatibility with WordPress 3.5 function
7
+ global $wpdb;
8
+ return $wpdb->prepare( $sql_req, array() );
9
+ }
10
+
11
+
12
  // Change date format
13
  function wpdevbk_get_date_in_correct_format( $dt ) {
14
 
1100
  $page_start = ( $page_num - 1 ) * $page_items_count ;
1101
 
1102
  // Get Bookings Array
1103
+ $bookings_res = $wpdb->get_results(wpdevbk_db_prepare( $sql_start_select . $sql . $sql_where . $sql_order . $sql_limit ));
1104
 
1105
  // Get Number of booking for the pages
1106
+ $bookings_count = $wpdb->get_results(wpdevbk_db_prepare( $sql_start_count . $sql . $sql_where ));
1107
 
1108
  // Get NUMBER of Bookings
1109
  if (count($bookings_count)>0) $bookings_count = $bookings_count[0]->count ;
1147
  else
1148
  $sql .= " ORDER BY booking_id, booking_date ";
1149
 
1150
+ $booking_dates = $wpdb->get_results(wpdevbk_db_prepare( $sql ));
1151
  } else
1152
  $booking_dates = array();
1153
 
1598
  }
1599
  );
1600
 
1601
+ jQuery('#a.popover_here').popover( {
1602
  placement: 'bottom'
1603
  , delay: { show: 100, hide: 100 }
1604
  , content: ''
lib/wpdev-booking-ajax.php CHANGED
@@ -103,7 +103,7 @@ function wpdev_bk_ajax_responder() {
103
 
104
  $approved_id_str = join( ',', $approved_id);
105
 
106
- if ( false === $wpdb->query( $wpdb->prepare("UPDATE ".$wpdb->prefix ."bookingdates SET approved = '".$is_approve_or_pending."' WHERE booking_id IN ($approved_id_str)") ) ){
107
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating to DB' ,__FILE__,__LINE__); ?></div>'; </script> <?php
108
  die();
109
  }
@@ -144,12 +144,12 @@ function wpdev_bk_ajax_responder() {
144
  sendDeclineEmails($approved_id_str, $is_send_emeils,$denyreason);
145
 
146
 
147
- if ( false === $wpdb->query( $wpdb->prepare("DELETE FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($approved_id_str)") ) ){
148
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during deleting dates at DB' ,__FILE__,__LINE__); ?></div>'; </script> <?php
149
  die();
150
  }
151
 
152
- if ( false === $wpdb->query($wpdb->prepare( "DELETE FROM ".$wpdb->prefix ."booking WHERE booking_id IN ($approved_id_str)") ) ){
153
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during deleting reservation at DB',__FILE__,__LINE__ ); ?></div>'; </script> <?php
154
  die();
155
  }
@@ -360,20 +360,20 @@ function wpdev_bk_insert_new_booking(){
360
  </script> <?php
361
  }
362
  $update_sql = "UPDATE ".$wpdb->prefix ."booking AS bk SET bk.form='$formdata', bk.booking_type=$bktype , bk.modification_date=".$my_modification_date." WHERE bk.booking_id=$my_booking_id;";
363
- if ( false === $wpdb->query($wpdb->prepare( $update_sql ) ) ){
364
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating exist booking in BD',__FILE__,__LINE__); ?></div>'; </script> <?php
365
  die();
366
  }
367
 
368
  // Check if dates already aproved or no
369
  $slct_sql = "SELECT approved FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($my_booking_id) LIMIT 0,1";
370
- $slct_sql_results = $wpdb->get_results( $wpdb->prepare($slct_sql) );
371
  if ( count($slct_sql_results) > 0 ) {
372
  $is_approved_dates = $slct_sql_results[0]->approved;
373
  }
374
 
375
  $delete_sql = "DELETE FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($my_booking_id)";
376
- if ( false === $wpdb->query($wpdb->prepare( $delete_sql ) ) ){
377
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating exist booking for deleting dates in BD' ,__FILE__,__LINE__); ?></div>'; </script> <?php
378
  die();
379
  }
@@ -383,7 +383,7 @@ function wpdev_bk_insert_new_booking(){
383
 
384
  $sql_insertion = "INSERT INTO ".$wpdb->prefix ."booking (form, booking_type, modification_date) VALUES ('$formdata', $bktype, ".$my_modification_date." )" ;
385
  //debuge($formdata);
386
- if ( false === $wpdb->query($wpdb->prepare( $sql_insertion ) ) ){
387
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during inserting into BD',__FILE__,__LINE__); ?></div>'; </script> <?php
388
  die();
389
  }
@@ -480,7 +480,7 @@ function wpdev_bk_insert_new_booking(){
480
  /**/
481
 
482
  if ( !empty($insert) )
483
- if ( false === $wpdb->query($wpdb->prepare("INSERT INTO ".$wpdb->prefix ."bookingdates (booking_id, booking_date, approved) VALUES " . $insert) ) ){
484
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during inserting into BD - Dates',__FILE__,__LINE__); ?></div>'; </script> <?php
485
  die();
486
  }
103
 
104
  $approved_id_str = join( ',', $approved_id);
105
 
106
+ if ( false === $wpdb->query( wpdevbk_db_prepare("UPDATE ".$wpdb->prefix ."bookingdates SET approved = '".$is_approve_or_pending."' WHERE booking_id IN ($approved_id_str)") ) ){
107
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating to DB' ,__FILE__,__LINE__); ?></div>'; </script> <?php
108
  die();
109
  }
144
  sendDeclineEmails($approved_id_str, $is_send_emeils,$denyreason);
145
 
146
 
147
+ if ( false === $wpdb->query( wpdevbk_db_prepare("DELETE FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($approved_id_str)") ) ){
148
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during deleting dates at DB' ,__FILE__,__LINE__); ?></div>'; </script> <?php
149
  die();
150
  }
151
 
152
+ if ( false === $wpdb->query(wpdevbk_db_prepare( "DELETE FROM ".$wpdb->prefix ."booking WHERE booking_id IN ($approved_id_str)") ) ){
153
  ?> <script type="text/javascript"> document.getElementById('ajax_message').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during deleting reservation at DB',__FILE__,__LINE__ ); ?></div>'; </script> <?php
154
  die();
155
  }
360
  </script> <?php
361
  }
362
  $update_sql = "UPDATE ".$wpdb->prefix ."booking AS bk SET bk.form='$formdata', bk.booking_type=$bktype , bk.modification_date=".$my_modification_date." WHERE bk.booking_id=$my_booking_id;";
363
+ if ( false === $wpdb->query(wpdevbk_db_prepare( $update_sql ) ) ){
364
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating exist booking in BD',__FILE__,__LINE__); ?></div>'; </script> <?php
365
  die();
366
  }
367
 
368
  // Check if dates already aproved or no
369
  $slct_sql = "SELECT approved FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($my_booking_id) LIMIT 0,1";
370
+ $slct_sql_results = $wpdb->get_results( wpdevbk_db_prepare($slct_sql) );
371
  if ( count($slct_sql_results) > 0 ) {
372
  $is_approved_dates = $slct_sql_results[0]->approved;
373
  }
374
 
375
  $delete_sql = "DELETE FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($my_booking_id)";
376
+ if ( false === $wpdb->query(wpdevbk_db_prepare( $delete_sql ) ) ){
377
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during updating exist booking for deleting dates in BD' ,__FILE__,__LINE__); ?></div>'; </script> <?php
378
  die();
379
  }
383
 
384
  $sql_insertion = "INSERT INTO ".$wpdb->prefix ."booking (form, booking_type, modification_date) VALUES ('$formdata', $bktype, ".$my_modification_date." )" ;
385
  //debuge($formdata);
386
+ if ( false === $wpdb->query(wpdevbk_db_prepare( $sql_insertion ) ) ){
387
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during inserting into BD',__FILE__,__LINE__); ?></div>'; </script> <?php
388
  die();
389
  }
480
  /**/
481
 
482
  if ( !empty($insert) )
483
+ if ( false === $wpdb->query(wpdevbk_db_prepare("INSERT INTO ".$wpdb->prefix ."bookingdates (booking_id, booking_date, approved) VALUES " . $insert) ) ){
484
  ?> <script type="text/javascript"> document.getElementById('submiting<?php echo $bktype; ?>').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php bk_error('Error during inserting into BD - Dates',__FILE__,__LINE__); ?></div>'; </script> <?php
485
  die();
486
  }
lib/wpdev-booking-class.php CHANGED
@@ -211,7 +211,7 @@ if (!class_exists('wpdev_booking')) {
211
  if ($my_resources!='') $sql_req .= " WHERE bk.booking_type IN ($my_resources)";
212
  $sql_req .= "ORDER BY dt.booking_date" ;
213
 
214
- $sql_results = $wpdb->get_results( $wpdb->prepare($sql_req) ) ;
215
 
216
  $bk_array = array();
217
  if (! empty($sql_results))
@@ -885,7 +885,7 @@ if (!class_exists('wpdev_booking')) {
885
 
886
  // This function is run when a button is clicked. It creates a dialog box for the user to input the data.
887
  function booking_click( tag ) {
888
- wpdev_bk_DialogClose(); // Close any existing copies of the dialog
889
  wpdev_bk_DialogMaxHeight = wpdev_bk_DialogDefaultHeight + wpdev_bk_DialogDefaultExtraHeight;
890
 
891
 
@@ -946,9 +946,11 @@ if (!class_exists('wpdev_booking')) {
946
 
947
  // Close + reset
948
  function wpdev_bk_DialogClose() {
949
- jQuery(".ui-dialog").height(wpdev_bk_DialogDefaultHeight);
950
- jQuery(".ui-dialog").width(wpdev_bk_DialogDefaultWidth);
951
- jQuery("#wpdev_bk-dialog").dialog("close");
 
 
952
  }
953
 
954
  // Callback function for the "Okay" button
@@ -1171,6 +1173,7 @@ if (!class_exists('wpdev_booking')) {
1171
  width:16px;
1172
  height:16px;
1173
  }
 
1174
  #wpdev_bk-dialog .field {height:30px;
1175
  line-height:25px;
1176
  margin:0px 0px 5px;}
@@ -1238,7 +1241,7 @@ if (!class_exists('wpdev_booking')) {
1238
  WHERE table_schema = '". DB_NAME ."'
1239
  AND table_name = '" . $tablename . "'";
1240
 
1241
- $res = $wpdb->get_results($wpdb->prepare($sql_check_table));
1242
  return $res[0]->count;
1243
 
1244
  }
@@ -1249,7 +1252,7 @@ if (!class_exists('wpdev_booking')) {
1249
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
1250
  $sql_check_table = "SHOW COLUMNS FROM " . $tablename ;
1251
 
1252
- $res = $wpdb->get_results($wpdb->prepare($sql_check_table));
1253
 
1254
  foreach ($res as $fld) {
1255
  if ($fld->Field == $fieldname) return 1;
@@ -1263,7 +1266,7 @@ if (!class_exists('wpdev_booking')) {
1263
  global $wpdb;
1264
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
1265
  $sql_check_table = "SHOW INDEX FROM ". $tablename ." WHERE Key_name = '".$fieldindex."'; ";
1266
- $res = $wpdb->get_results($wpdb->prepare($sql_check_table));
1267
  if (count($res)>0) return 1;
1268
  else return 0;
1269
  }
@@ -1376,7 +1379,7 @@ if (!class_exists('wpdev_booking')) {
1376
 
1377
  ORDER BY dt.booking_date", $bk_type_additional, $approved );
1378
 
1379
- $dates_approve = apply_bk_filter('get_bk_dates', $wpdb->get_results($wpdb->prepare( $sql_req )), $approved, 0,$bk_type );
1380
  }
1381
 
1382
 
@@ -3629,25 +3632,25 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3629
  booking_type bigint(10) NOT NULL default 1,
3630
  PRIMARY KEY (booking_id)
3631
  ) $charset_collate;";
3632
- $wpdb->query($wpdb->prepare($simple_sql));
3633
  } elseif ($this->is_field_in_table_exists('booking','form') == 0) {
3634
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD form TEXT AFTER booking_id";
3635
- //$wpdb->query($wpdb->prepare($simple_sql));
3636
  }
3637
 
3638
  if ($this->is_field_in_table_exists('booking','modification_date') == 0) {
3639
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD modification_date datetime AFTER booking_id";
3640
- //$wpdb->query($wpdb->prepare($simple_sql));
3641
  }
3642
 
3643
  if ($this->is_field_in_table_exists('booking','status') == 0) {
3644
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD status varchar(200) NOT NULL default '' AFTER booking_id";
3645
- //$wpdb->query($wpdb->prepare($simple_sql));
3646
  }
3647
 
3648
  if ($this->is_field_in_table_exists('booking','is_new') == 0) {
3649
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD is_new bigint(10) NOT NULL default 1 AFTER booking_id";
3650
- //$wpdb->query($wpdb->prepare($simple_sql));
3651
  }
3652
 
3653
  if ( ! $this->is_table_exists('bookingdates') ) { // Cehck if tables not exist yet
@@ -3656,7 +3659,7 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3656
  booking_date datetime NOT NULL default '0000-00-00 00:00:00',
3657
  approved bigint(20) unsigned NOT NULL default 0
3658
  ) $charset_collate;";
3659
- $wpdb->query($wpdb->prepare($simple_sql));
3660
 
3661
  if( $this->wpdev_bk_personal == false ) {
3662
  $wp_queries[] = "INSERT INTO ".$wpdb->prefix ."booking ( form, modification_date ) VALUES (
@@ -3664,22 +3667,22 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3664
  }
3665
  }
3666
 
3667
- if (!class_exists('wpdev_bk_biz_l')) {
3668
  if ($this->is_index_in_table_exists('bookingdates','booking_id_dates') == 0) {
3669
  $simple_sql = "CREATE UNIQUE INDEX booking_id_dates ON ".$wpdb->prefix ."bookingdates (booking_id, booking_date);";
3670
- $wpdb->query($wpdb->prepare($simple_sql));
3671
  }
3672
  } else {
3673
  if ($this->is_index_in_table_exists('bookingdates','booking_id_dates') != 0) {
3674
  $simple_sql = "DROP INDEX booking_id_dates ON ".$wpdb->prefix ."bookingdates ;";
3675
- $wpdb->query($wpdb->prepare($simple_sql));
3676
  }
3677
- }
3678
 
3679
 
3680
  if (count($wp_queries)>0) {
3681
  foreach ($wp_queries as $wp_q)
3682
- $wpdb->query($wpdb->prepare($wp_q));
3683
 
3684
  if( $this->wpdev_bk_personal == false ) {
3685
  $temp_id = $wpdb->insert_id;
@@ -3690,7 +3693,7 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3690
  ( ". $temp_id .", CURDATE()+ INTERVAL 2 day ),
3691
  ( ". $temp_id .", CURDATE()+ INTERVAL 3 day ),
3692
  ( ". $temp_id .", CURDATE()+ INTERVAL 4 day );";
3693
- $wpdb->query($wpdb->prepare($wp_queries_sub));
3694
  }
3695
  }
3696
 
@@ -3784,17 +3787,17 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3784
  delete_bk_option( 'booking_widget_last_field');
3785
 
3786
  global $wpdb;
3787
- $wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'booking'));
3788
- $wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'bookingdates'));
3789
 
3790
- // Delete all users booking windows states //if ( false === $wpdb->query($wpdb->prepare( "DELETE FROM ". $wpdb->usermeta ." WHERE meta_key LIKE '%_booking_win_%'") ) ){ // Only WIN states
3791
- if ( false === $wpdb->query($wpdb->prepare( "DELETE FROM ". $wpdb->usermeta ) . " WHERE meta_key LIKE '%booking_%'" ) ){ // All users data
3792
  bk_error('Error during deleting user meta at DB',__FILE__,__LINE__);
3793
  die();
3794
  }
3795
  // Delete or Drafts and Pending from demo sites
3796
  if ( wpdev_bk_is_this_demo() ) { // Delete all temp posts at the demo sites: (post_status = pending || draft) && ( post_type = post ) && (post_author != 1)
3797
- $postss = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->posts WHERE ( post_status = 'pending' OR post_status = 'draft' OR post_status = 'auto-draft' OR post_status = 'trash' OR post_status = 'inherit' ) AND ( post_type='post' OR post_type='revision') AND post_author != 1"));
3798
  foreach ($postss as $pp) { wp_delete_post( $pp->ID , true ); }
3799
  }
3800
 
@@ -3840,7 +3843,7 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3840
 
3841
  $wp_bk_querie = "INSERT INTO ".$wpdb->prefix ."booking ( form, booking_type, cost, hash ) VALUES
3842
  ( '".$form."', ".$bk_type .", ".rand(0,1000).", MD5('". time() . '_' . rand(1000,1000000)."') ) ;";
3843
- $wpdb->query($wpdb->prepare($wp_bk_querie));
3844
 
3845
  $temp_id = $wpdb->insert_id;
3846
  $wp_queries_sub = "INSERT INTO ".$wpdb->prefix ."bookingdates (
@@ -3850,7 +3853,7 @@ add_bk_option( 'booking_is_not_load_bs_script_in_client' , 'Off' );
3850
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+2)." day ),
3851
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+3)." day ),
3852
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+4)." day );";
3853
- $wpdb->query($wpdb->prepare($wp_queries_sub));
3854
  }
3855
  }
3856
 
211
  if ($my_resources!='') $sql_req .= " WHERE bk.booking_type IN ($my_resources)";
212
  $sql_req .= "ORDER BY dt.booking_date" ;
213
 
214
+ $sql_results = $wpdb->get_results( wpdevbk_db_prepare($sql_req) ) ;
215
 
216
  $bk_array = array();
217
  if (! empty($sql_results))
885
 
886
  // This function is run when a button is clicked. It creates a dialog box for the user to input the data.
887
  function booking_click( tag ) {
888
+ // wpdev_bk_DialogClose(); // Close any existing copies of the dialog
889
  wpdev_bk_DialogMaxHeight = wpdev_bk_DialogDefaultHeight + wpdev_bk_DialogDefaultExtraHeight;
890
 
891
 
946
 
947
  // Close + reset
948
  function wpdev_bk_DialogClose() {
949
+
950
+ jQuery(".ui-dialog").height(wpdev_bk_DialogDefaultHeight);
951
+ jQuery(".ui-dialog").width(wpdev_bk_DialogDefaultWidth);
952
+ jQuery("#wpdev_bk-dialog").dialog("close");
953
+
954
  }
955
 
956
  // Callback function for the "Okay" button
1173
  width:16px;
1174
  height:16px;
1175
  }
1176
+ #wpdev_bk-dialog .button-secondary {margin-right:10px;}
1177
  #wpdev_bk-dialog .field {height:30px;
1178
  line-height:25px;
1179
  margin:0px 0px 5px;}
1241
  WHERE table_schema = '". DB_NAME ."'
1242
  AND table_name = '" . $tablename . "'";
1243
 
1244
+ $res = $wpdb->get_results(wpdevbk_db_prepare($sql_check_table));
1245
  return $res[0]->count;
1246
 
1247
  }
1252
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
1253
  $sql_check_table = "SHOW COLUMNS FROM " . $tablename ;
1254
 
1255
+ $res = $wpdb->get_results(wpdevbk_db_prepare($sql_check_table));
1256
 
1257
  foreach ($res as $fld) {
1258
  if ($fld->Field == $fieldname) return 1;
1266
  global $wpdb;
1267
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
1268
  $sql_check_table = "SHOW INDEX FROM ". $tablename ." WHERE Key_name = '".$fieldindex."'; ";
1269
+ $res = $wpdb->get_results(wpdevbk_db_prepare($sql_check_table));
1270
  if (count($res)>0) return 1;
1271
  else return 0;
1272
  }
1379
 
1380
  ORDER BY dt.booking_date", $bk_type_additional, $approved );
1381
 
1382
+ $dates_approve = apply_bk_filter('get_bk_dates', $wpdb->get_results(wpdevbk_db_prepare( $sql_req )), $approved, 0,$bk_type );
1383
  }
1384
 
1385
 
3632
  booking_type bigint(10) NOT NULL default 1,
3633
  PRIMARY KEY (booking_id)
3634
  ) $charset_collate;";
3635
+ $wpdb->query(wpdevbk_db_prepare($simple_sql));
3636
  } elseif ($this->is_field_in_table_exists('booking','form') == 0) {
3637
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD form TEXT AFTER booking_id";
3638
+ //$wpdb->query(wpdevbk_db_prepare($simple_sql));
3639
  }
3640
 
3641
  if ($this->is_field_in_table_exists('booking','modification_date') == 0) {
3642
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD modification_date datetime AFTER booking_id";
3643
+ //$wpdb->query(wpdevbk_db_prepare($simple_sql));
3644
  }
3645
 
3646
  if ($this->is_field_in_table_exists('booking','status') == 0) {
3647
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD status varchar(200) NOT NULL default '' AFTER booking_id";
3648
+ //$wpdb->query(wpdevbk_db_prepare($simple_sql));
3649
  }
3650
 
3651
  if ($this->is_field_in_table_exists('booking','is_new') == 0) {
3652
  $wp_queries[] = "ALTER TABLE ".$wpdb->prefix ."booking ADD is_new bigint(10) NOT NULL default 1 AFTER booking_id";
3653
+ //$wpdb->query(wpdevbk_db_prepare($simple_sql));
3654
  }
3655
 
3656
  if ( ! $this->is_table_exists('bookingdates') ) { // Cehck if tables not exist yet
3659
  booking_date datetime NOT NULL default '0000-00-00 00:00:00',
3660
  approved bigint(20) unsigned NOT NULL default 0
3661
  ) $charset_collate;";
3662
+ $wpdb->query(wpdevbk_db_prepare($simple_sql));
3663
 
3664
  if( $this->wpdev_bk_personal == false ) {
3665
  $wp_queries[] = "INSERT INTO ".$wpdb->prefix ."booking ( form, modification_date ) VALUES (
3667
  }
3668
  }
3669
 
3670
+ /*if (!class_exists('wpdev_bk_biz_l')) {
3671
  if ($this->is_index_in_table_exists('bookingdates','booking_id_dates') == 0) {
3672
  $simple_sql = "CREATE UNIQUE INDEX booking_id_dates ON ".$wpdb->prefix ."bookingdates (booking_id, booking_date);";
3673
+ $wpdb->query(wpdevbk_db_prepare($simple_sql));
3674
  }
3675
  } else {
3676
  if ($this->is_index_in_table_exists('bookingdates','booking_id_dates') != 0) {
3677
  $simple_sql = "DROP INDEX booking_id_dates ON ".$wpdb->prefix ."bookingdates ;";
3678
+ $wpdb->query(wpdevbk_db_prepare($simple_sql));
3679
  }
3680
+ }/**/
3681
 
3682
 
3683
  if (count($wp_queries)>0) {
3684
  foreach ($wp_queries as $wp_q)
3685
+ $wpdb->query(wpdevbk_db_prepare($wp_q));
3686
 
3687
  if( $this->wpdev_bk_personal == false ) {
3688
  $temp_id = $wpdb->insert_id;
3693
  ( ". $temp_id .", CURDATE()+ INTERVAL 2 day ),
3694
  ( ". $temp_id .", CURDATE()+ INTERVAL 3 day ),
3695
  ( ". $temp_id .", CURDATE()+ INTERVAL 4 day );";
3696
+ $wpdb->query(wpdevbk_db_prepare($wp_queries_sub));
3697
  }
3698
  }
3699
 
3787
  delete_bk_option( 'booking_widget_last_field');
3788
 
3789
  global $wpdb;
3790
+ $wpdb->query(wpdevbk_db_prepare('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'booking'));
3791
+ $wpdb->query(wpdevbk_db_prepare('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'bookingdates'));
3792
 
3793
+ // Delete all users booking windows states //if ( false === $wpdb->query(wpdevbk_db_prepare( "DELETE FROM ". $wpdb->usermeta ." WHERE meta_key LIKE '%_booking_win_%'") ) ){ // Only WIN states
3794
+ if ( false === $wpdb->query(wpdevbk_db_prepare( "DELETE FROM ". $wpdb->usermeta ) . " WHERE meta_key LIKE '%booking_%'" ) ){ // All users data
3795
  bk_error('Error during deleting user meta at DB',__FILE__,__LINE__);
3796
  die();
3797
  }
3798
  // Delete or Drafts and Pending from demo sites
3799
  if ( wpdev_bk_is_this_demo() ) { // Delete all temp posts at the demo sites: (post_status = pending || draft) && ( post_type = post ) && (post_author != 1)
3800
+ $postss = $wpdb->get_results(wpdevbk_db_prepare("SELECT * FROM $wpdb->posts WHERE ( post_status = 'pending' OR post_status = 'draft' OR post_status = 'auto-draft' OR post_status = 'trash' OR post_status = 'inherit' ) AND ( post_type='post' OR post_type='revision') AND post_author != 1"));
3801
  foreach ($postss as $pp) { wp_delete_post( $pp->ID , true ); }
3802
  }
3803
 
3843
 
3844
  $wp_bk_querie = "INSERT INTO ".$wpdb->prefix ."booking ( form, booking_type, cost, hash ) VALUES
3845
  ( '".$form."', ".$bk_type .", ".rand(0,1000).", MD5('". time() . '_' . rand(1000,1000000)."') ) ;";
3846
+ $wpdb->query(wpdevbk_db_prepare($wp_bk_querie));
3847
 
3848
  $temp_id = $wpdb->insert_id;
3849
  $wp_queries_sub = "INSERT INTO ".$wpdb->prefix ."bookingdates (
3853
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+2)." day ),
3854
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+3)." day ),
3855
  ( ". $temp_id .", CURDATE()+ INTERVAL ".(2*$i*$evry_one+4)." day );";
3856
+ $wpdb->query(wpdevbk_db_prepare($wp_queries_sub));
3857
  }
3858
  }
3859
 
lib/wpdev-booking-functions.php CHANGED
@@ -16,7 +16,7 @@
16
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
17
  $sql_check_table = "SHOW COLUMNS FROM " . $tablename ;
18
 
19
- $res = $wpdb->get_results($wpdb->prepare($sql_check_table));
20
 
21
  foreach ($res as $fld) {
22
  if ($fld->Field == $fieldname) return 1;
@@ -31,7 +31,7 @@
31
  global $wpdb;
32
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
33
  $sql_check_table = "SHOW INDEX FROM ". $tablename ." WHERE Key_name = '".$fieldindex."'; ";
34
- $res = $wpdb->get_results($wpdb->prepare($sql_check_table));
35
  if (count($res)>0) return 1;
36
  else return 0;
37
  }
@@ -242,7 +242,7 @@
242
  // Get dates 4 emeil
243
  function get_dates_str ($approved_id_str) {
244
  global $wpdb;
245
- $dates_approve = $wpdb->get_results( $wpdb->prepare(
246
  "SELECT DISTINCT booking_date FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($approved_id_str) ORDER BY booking_date" ));
247
  $dates_str = '';
248
  // loop with all dates which is selected by someone
@@ -505,7 +505,7 @@
505
  //debuge($approved_id_str, $is_send_emeils);
506
  global $wpdb;
507
  $sql = "SELECT * FROM ".$wpdb->prefix ."booking as bk WHERE bk.booking_id IN ($approved_id_str)";
508
- $result = $wpdb->get_results( $wpdb->prepare($sql ) );
509
  //debuge($result);
510
  $mail_sender = htmlspecialchars_decode( get_bk_option( 'booking_email_approval_adress') ) ; //'"'. 'Booking sender' . '" <' . $booking_form_show['email'].'>';
511
  $mail_subject = htmlspecialchars_decode( get_bk_option( 'booking_email_approval_subject') );
@@ -583,7 +583,7 @@
583
  $sql = "SELECT * FROM ".$wpdb->prefix ."booking as bk
584
  WHERE bk.booking_id IN ($approved_id_str)";
585
 
586
- $result = $wpdb->get_results( $wpdb->prepare($sql) );
587
 
588
  $mail_sender = htmlspecialchars_decode( get_bk_option( 'booking_email_deny_adress') ) ;
589
  $mail_subject = htmlspecialchars_decode( get_bk_option( 'booking_email_deny_subject') );
@@ -1035,7 +1035,7 @@
1035
  $sql_req = apply_bk_filter('get_sql_for_checking_new_bookings', $sql_req );
1036
  $sql_req = apply_bk_filter('get_sql_for_checking_new_bookings_multiuser', $sql_req );
1037
 
1038
- $bookings = $wpdb->get_results( $wpdb->prepare($sql_req) );
1039
 
1040
  return count($bookings) ;
1041
 
@@ -1054,7 +1054,7 @@
1054
 
1055
  $update_sql = "UPDATE ".$wpdb->prefix ."booking AS bk SET bk.is_new = ".$is_new." WHERE bk.booking_id IN ( ".$id_of_new_bookings." ) ";
1056
 
1057
- if ( false === $wpdb->query( $wpdb->prepare($update_sql) ) ) {
1058
  bk_error('Error during updating status of bookings at DB',__FILE__,__LINE__);
1059
  die();
1060
  }
16
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
17
  $sql_check_table = "SHOW COLUMNS FROM " . $tablename ;
18
 
19
+ $res = $wpdb->get_results(wpdevbk_db_prepare($sql_check_table));
20
 
21
  foreach ($res as $fld) {
22
  if ($fld->Field == $fieldname) return 1;
31
  global $wpdb;
32
  if (strpos($tablename, $wpdb->prefix) ===false) $tablename = $wpdb->prefix . $tablename ;
33
  $sql_check_table = "SHOW INDEX FROM ". $tablename ." WHERE Key_name = '".$fieldindex."'; ";
34
+ $res = $wpdb->get_results(wpdevbk_db_prepare($sql_check_table));
35
  if (count($res)>0) return 1;
36
  else return 0;
37
  }
242
  // Get dates 4 emeil
243
  function get_dates_str ($approved_id_str) {
244
  global $wpdb;
245
+ $dates_approve = $wpdb->get_results( wpdevbk_db_prepare(
246
  "SELECT DISTINCT booking_date FROM ".$wpdb->prefix ."bookingdates WHERE booking_id IN ($approved_id_str) ORDER BY booking_date" ));
247
  $dates_str = '';
248
  // loop with all dates which is selected by someone
505
  //debuge($approved_id_str, $is_send_emeils);
506
  global $wpdb;
507
  $sql = "SELECT * FROM ".$wpdb->prefix ."booking as bk WHERE bk.booking_id IN ($approved_id_str)";
508
+ $result = $wpdb->get_results( wpdevbk_db_prepare($sql ) );
509
  //debuge($result);
510
  $mail_sender = htmlspecialchars_decode( get_bk_option( 'booking_email_approval_adress') ) ; //'"'. 'Booking sender' . '" <' . $booking_form_show['email'].'>';
511
  $mail_subject = htmlspecialchars_decode( get_bk_option( 'booking_email_approval_subject') );
583
  $sql = "SELECT * FROM ".$wpdb->prefix ."booking as bk
584
  WHERE bk.booking_id IN ($approved_id_str)";
585
 
586
+ $result = $wpdb->get_results( wpdevbk_db_prepare($sql) );
587
 
588
  $mail_sender = htmlspecialchars_decode( get_bk_option( 'booking_email_deny_adress') ) ;
589
  $mail_subject = htmlspecialchars_decode( get_bk_option( 'booking_email_deny_subject') );
1035
  $sql_req = apply_bk_filter('get_sql_for_checking_new_bookings', $sql_req );
1036
  $sql_req = apply_bk_filter('get_sql_for_checking_new_bookings_multiuser', $sql_req );
1037
 
1038
+ $bookings = $wpdb->get_results( wpdevbk_db_prepare($sql_req) );
1039
 
1040
  return count($bookings) ;
1041
 
1054
 
1055
  $update_sql = "UPDATE ".$wpdb->prefix ."booking AS bk SET bk.is_new = ".$is_new." WHERE bk.booking_id IN ( ".$id_of_new_bookings." ) ";
1056
 
1057
+ if ( false === $wpdb->query( wpdevbk_db_prepare($update_sql) ) ) {
1058
  bk_error('Error during updating status of bookings at DB',__FILE__,__LINE__);
1059
  die();
1060
  }
readme.txt CHANGED
@@ -2,9 +2,9 @@
2
  Contributors: wpdevelop
3
  Donate link: http://wpbookingcalendar.com/buy/
4
  Tags: Booking calendar, Booking, Book, to book, calendar, Reservation, Calendar, hotel, rooms, rent, appointment, scheduling, availability, availability calendar, event, events, event calendar, resource scheduling, Rental, Meeting scheduling, reservation plugin, accommodations, bookable, bookable events
5
- Requires at least: 2.7
6
- Tested up to: 3.4
7
- Stable tag: 4.0.1
8
  License: GPLv2 or later
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
@@ -65,7 +65,8 @@ If you have any further questions, please fill free to <a href="mailto:info@wpbo
65
  9. General Booking Settings page.
66
 
67
  == Changelog ==
68
-
 
69
  = 4.0.1 =
70
  * Fix issue of not posbility to make the reservation, when using only the booking form, without calendar.
71
  * Load the jQuery 1.7.1, if the theme is loaded older version by default
@@ -92,6 +93,8 @@ If you have any further questions, please fill free to <a href="mailto:info@wpbo
92
  * Many new features in other versions of Booking Calendar, please check the full list <a href="http://wpbookingcalendar.com/changelog/" title="changelog">here</a>. <br /><br />See full change logs at this <a href="http://wpbookingcalendar.com/changelog/" title="changelog">page</a>.
93
 
94
  == Upgrade Notice ==
 
 
95
  = 4.0.1 =
96
  Fix some issues raltive to the loading of the old jquery library by theme and as result the calendar was invisible.
97
  = 4.0 =
2
  Contributors: wpdevelop
3
  Donate link: http://wpbookingcalendar.com/buy/
4
  Tags: Booking calendar, Booking, Book, to book, calendar, Reservation, Calendar, hotel, rooms, rent, appointment, scheduling, availability, availability calendar, event, events, event calendar, resource scheduling, Rental, Meeting scheduling, reservation plugin, accommodations, bookable, bookable events
5
+ Requires at least: 3.4
6
+ Tested up to: 3.5
7
+ Stable tag: 4.0.2
8
  License: GPLv2 or later
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
65
  9. General Booking Settings page.
66
 
67
  == Changelog ==
68
+ = 4.0.2 =
69
+ * WordPress 3.5 compatibility.
70
  = 4.0.1 =
71
  * Fix issue of not posbility to make the reservation, when using only the booking form, without calendar.
72
  * Load the jQuery 1.7.1, if the theme is loaded older version by default
93
  * Many new features in other versions of Booking Calendar, please check the full list <a href="http://wpbookingcalendar.com/changelog/" title="changelog">here</a>. <br /><br />See full change logs at this <a href="http://wpbookingcalendar.com/changelog/" title="changelog">page</a>.
94
 
95
  == Upgrade Notice ==
96
+ = 4.0.2 =
97
+ WordPress 3.5 compatibility.
98
  = 4.0.1 =
99
  Fix some issues raltive to the loading of the old jquery library by theme and as result the calendar was invisible.
100
  = 4.0 =
wpdev-booking.php CHANGED
@@ -3,10 +3,10 @@
3
  Plugin Name: Booking Calendar
4
  Plugin URI: http://wpbookingcalendar.com/demo/
5
  Description: Online reservation and availability checking service for your site.
6
- Version: 4.0.1
7
  Author: wpdevelop
8
  Author URI: http://wpbookingcalendar.com/
9
- Tested WordPress Versions: 2.8.3 - 3.4
10
  */
11
 
12
  /* Copyright 2009 - 2012 www.wpbookingcalendar.com (email: info@wpbookingcalendar.com),
@@ -219,6 +219,8 @@ M i n o r T O D O List:
219
  -----------------------------------------------
220
  Change Log and Features for Future Releases :
221
  -----------------------------------------------
 
 
222
  = 4.0.1 =
223
  * Personal / Business Small / Business Medium / Business Large / MultiUser versions features:
224
  *
3
  Plugin Name: Booking Calendar
4
  Plugin URI: http://wpbookingcalendar.com/demo/
5
  Description: Online reservation and availability checking service for your site.
6
+ Version: 4.0.2
7
  Author: wpdevelop
8
  Author URI: http://wpbookingcalendar.com/
9
+ Tested WordPress Versions: 3.5
10
  */
11
 
12
  /* Copyright 2009 - 2012 www.wpbookingcalendar.com (email: info@wpbookingcalendar.com),
219
  -----------------------------------------------
220
  Change Log and Features for Future Releases :
221
  -----------------------------------------------
222
+ = 4.0.2 =
223
+ * WordPress 3.5 compatibility.
224
  = 4.0.1 =
225
  * Personal / Business Small / Business Medium / Business Large / MultiUser versions features:
226
  *