Advertisement
Guest User

BookingWizz - change single day to multi day

a guest
Jun 8th, 2013
357
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.68 KB | None | 0 0
  1. # first execute this sql query in phpmyadmin. Where last '1' - is the ID of the calendar which you want to convert to # multi day. Also adjust FIRST '1'  if you want to change not DEFAULT calendar to multiday calendar..
  2. UPDATE `bs_services` SET `id` = '1', `type` = 'd' WHERE `id` = '1';
  3.  
  4. # second query which has to be run in phpmyadmin:
  5. INSERT INTO `bs_service_days_settings` (
  6. `idService` ,
  7. `spots` ,
  8. `description` ,
  9. `img` ,
  10. `maxDays` ,
  11. `daysBefore` ,
  12. `startDay` ,
  13. `payment_method` ,
  14. `coupon`
  15. )
  16. VALUES (
  17. '1', '10', '', '', '10', '10', '0', 'invoice', '0'
  18. );
  19. # the first '1' in VALUES row is the ID of the calendar, it is the same ID which you used in first statement as LAST '1'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement