56 lines
4.0 KiB
PHP
56 lines
4.0 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
|
|
db_query("UPDATE invoice_header SET include_school_names = 'N' WHERE include_school_names != 'Y'");
|
|
db_query("UPDATE invoice_header SET charge_gst = 'Y' WHERE charge_gst != 'N'");
|
|
|
|
db_query("UPDATE hotlunch_menu_dates SET display_group_colors = 'Y' WHERE display_group_colors != 'N'");
|
|
db_query("UPDATE hotlunch_menu_dates SET display_group_letters = 'Y' WHERE display_group_letters != 'N'");
|
|
db_query("UPDATE hotlunch_menu_dates SET active = 'Y' WHERE active != 'N'");
|
|
db_query("UPDATE hotlunch_menu_dates SET available = 'Y' WHERE available != 'N'");
|
|
|
|
db_query("UPDATE hotlunch_menu_items SET item_type = 'Item' WHERE item_type NOT IN ('Item','Heading','PageBreak')");
|
|
db_query("UPDATE hotlunch_menu_items SET menu_item_format = 'D' WHERE item_type NOT IN ('Q','C','D')");
|
|
db_query("UPDATE hotlunch_menu_items SET active = 'Y' WHERE active != 'N'");
|
|
db_query("UPDATE hotlunch_menu_items SET display_price = 'Y' WHERE display_price != 'N'");
|
|
db_query("UPDATE hotlunch_menu_items SET taxable_item = 'N' WHERE taxable_item != 'Y'");
|
|
db_query("UPDATE hotlunch_menu_items SET bc_guideline_rating = '' WHERE bc_guideline_rating NOT IN ('N/A','Sometimes','Most')");
|
|
db_query("UPDATE hotlunch_menu_items SET hot_cold_food = 'Hot' WHERE hot_cold_food != 'Cold'");
|
|
db_query("UPDATE hotlunch_menu_items SET heading_visibility = 'visible' WHERE heading_visibility != 'hidden'");
|
|
db_query("UPDATE hotlunch_menu_items SET heading_page_break = 'N' WHERE heading_page_break != 'Y'");
|
|
db_query("UPDATE hotlunch_menu_items SET max_quantity_by = 'Order' WHERE max_quantity_by NOT IN ('Order','Family')");
|
|
|
|
db_query("UPDATE hotlunch_order_header SET added_date = '2001-01-01' WHERE added_date < '2001-01-01'");
|
|
db_query("UPDATE hotlunch_order_header SET ordered_by_type = 'Student' WHERE ordered_by_type NOT IN ('Concession','Staff','Customer')");
|
|
db_query("UPDATE hotlunch_order_header SET status = 'Unpaid' WHERE status = ''");
|
|
db_query("UPDATE hotlunch_order_header SET source = 'On-Line' WHERE source = ''");
|
|
db_query("UPDATE hotlunch_order_header SET price_category = 'Regular' WHERE price_category = ''");
|
|
db_query("UPDATE hotlunch_order_header SET delivered = 'N' WHERE delivered = ''");
|
|
|
|
db_query("UPDATE hotlunch_order_log SET ordered_by_type = 'Student' WHERE ordered_by_type NOT IN ('Student','Staff','Concession','Participant','Customer')");
|
|
db_query("UPDATE hotlunch_order_log SET payment_method = 'Unpaid' WHERE payment_method NOT IN ('Unpaid','Cash','Check','Visa','Mastercard','PayPal','Bambora')");
|
|
db_query("UPDATE hotlunch_order_log SET status = 'Unpaid' WHERE status NOT IN ('Inactive','Paid','Unpaid')");
|
|
db_query("UPDATE hotlunch_order_log SET source = 'On-Line' WHERE source NOT IN ('On-Line','Paper')");
|
|
db_query("UPDATE hotlunch_order_log SET price_category = 'Regular' WHERE price_category NOT IN ('Regular','Special 1','Special 2','Special 3')");
|
|
|
|
db_query("UPDATE user_account SET deleted = 'N' WHERE deleted != 'Y'");
|
|
db_query("UPDATE user_account SET transaction_status = 'Open' WHERE transaction_status != 'Closed'");
|
|
|
|
db_query("UPDATE users SET email1_verified = 'N' WHERE email1_verified != 'Y'");
|
|
db_query("UPDATE users SET email2_verified = 'N' WHERE email2_verified != 'Y'");
|
|
db_query("UPDATE users SET email3_verified = 'N' WHERE email3_verified != 'Y'");
|
|
db_query("UPDATE users SET source = 'On-Line' WHERE source != 'Paper'");
|
|
db_query("UPDATE users SET available_to_volunteer = 'N' WHERE available_to_volunteer != 'Y'");
|
|
db_query("UPDATE users SET school_directory = 'N' WHERE school_directory != 'Y'");
|
|
db_query("UPDATE users SET receive_emails = 'Y'");
|
|
db_query("UPDATE users SET email_list = 'Y' WHERE email_list != 'N'");
|
|
db_query("UPDATE users SET enable_translation = 'Y' WHERE enable_translation != 'N'");
|
|
db_query("UPDATE users SET email_reminders = 'Y' WHERE email_reminders != 'N'");
|
|
db_query("UPDATE users SET linked_to_type = 'Student' WHERE linked_to_type NOT IN ('Staff','Participant')");
|
|
|
|
db_query("UPDATE user_balance_save SET posted_method = 'Unposted' WHERE posted_method NOT IN ('Automatic','Post','Manual')");
|
|
|
|
?>
|