-- Account Pages
-- (
--   276 /* Account */,
--   277 /* My Account */,
--   278 /* Edit Profile */,
--   279 /* Order History */,
--   553 /* My Event History */,
--   281 /* Login */,
--   552 /* Member Directory */,
--   280 /* Logout */,
--   282 /* Forgot Password */,
--   283 /* Forgot Password :: Thank You! */,
--   294 /* Enter New Password */
-- )

UPDATE `qs_Page` SET `handler` = 'user' WHERE `id` = 276;
UPDATE `qs_DraftPage` SET `handler` = 'user' WHERE `id` = 276;

UPDATE `qs_Page` AS `p`
LEFT JOIN `qs_PageOption` AS `po`
  ON  `po`.`idPage` = `p`.`id` AND `po`.`name` IN('showInMenu', 'isIndexing', 'showInSiteMap', 'showInFooter', 'enabled')
SET
  `p`.`showInMenu` = 'n',
  `p`.`isIndexing` = 'n',
  `p`.`showInSiteMap` = 'n',
  `p`.`showInFooter` = 'n',
  `po`.`value` = IF(`po`.`name` = 'enabled', 'y', 'n'),
  `po`.`show` = IF(`po`.`name` = 'enabled', 'y', 'n')
WHERE `p`.`id` IN (
  276 /* Account */,
  277 /* My Account */,
  278 /* Edit Profile */,
  279 /* Order History */,
  553 /* My Event History */,
  281 /* Login */,
  552 /* Member Directory */,
  280 /* Logout */,
  282 /* Forgot Password */,
  283 /* Forgot Password :: Thank You! */,
  294 /* Enter New Password */
);

UPDATE `qs_PageOption` AS `po`
SET
  `po`.`value` = 'y',
  `po`.`show` = 'y'
WHERE `po`.`name` = 'isAccountNavigation'
  AND `po`.`idPage` IN (
    276 /* Account */,
    277 /* My Account */,
    278 /* Edit Profile */,
    279 /* Order History */,
    553 /* My Event History */,
    552 /* Member Directory */,
    280 /* Logout */
  );

-- D R A F T

UPDATE `qs_DraftPage` AS `p`
LEFT JOIN `qs_DraftPageOption` AS `po`
  ON  `po`.`idPage` = `p`.`id` AND `po`.`name` IN('showInMenu', 'isIndexing', 'showInSiteMap', 'showInFooter', 'enabled')
SET
  `p`.`showInMenu` = 'n',
  `p`.`isIndexing` = 'n',
  `p`.`showInSiteMap` = 'n',
  `p`.`showInFooter` = 'n',
  `po`.`value` = IF(`po`.`name` = 'enabled', 'y', 'n'),
  `po`.`show` = IF(`po`.`name` = 'enabled', 'y', 'n')
WHERE `p`.`id` IN (
  276 /* Account */,
  277 /* My Account */,
  278 /* Edit Profile */,
  279 /* Order History */,
  553 /* My Event History */,
  281 /* Login */,
  552 /* Member Directory */,
  280 /* Logout */,
  282 /* Forgot Password */,
  283 /* Forgot Password :: Thank You! */,
  294 /* Enter New Password */
);


UPDATE `qs_DraftPageOption` AS `po`
SET
  `po`.`value` = 'y',
  `po`.`show` = 'y'
WHERE `po`.`name` = 'isAccountNavigation'
  AND `po`.`idPage` IN (
    276 /* Account */,
    277 /* My Account */,
    278 /* Edit Profile */,
    279 /* Order History */,
    553 /* My Event History */,
    552 /* Member Directory */,
    280 /* Logout */
  );

-- ---------------------------------------------------------------------------------------------------------------------
-- SELECT `p`.`id`, `po`.`value`, `po`.`show`
-- FROM `qs_Page` AS `p`
-- LEFT JOIN `qs_PageOption` AS `po`
--   ON  `po`.`idPage` = `p`.`id` AND `po`.`name` = 'showInMenu'
-- WHERE `p`.`id` IN (
--   276 /* Account */,
--   277 /* My Account */,
--   278 /* Edit Profile */,
--   279 /* Order History */,
--   553 /* My Event History */,
--   281 /* Login */,
--   552 /* Member Directory */,
--   280 /* Logout */,
--   282 /* Forgot Password */,
--   283 /* Forgot Password :: Thank You! */,
--   294 /* Enter New Password */
-- );

-- SELECT * FROM `qs_PageOption` AS `po` WHERE `po`.`name` = 'isAccountNavigation'
--   AND `po`.`idPage` IN (
--     276 /* Account */,
--     277 /* My Account */,
--     278 /* Edit Profile */,
--     279 /* Order History */,
--     553 /* My Event History */,
--     552 /* Member Directory */,
--     280 /* Logout */
--   );
-- ---------------------------------------------------------------------------------------------------------------------