prefix . "foxypress_transaction_status(foxy_transaction_status_description) values ('$NewDescription')"; $wpdb->query($sql); } header("location: " . foxypress_GetCurrentPageURL(false) . "?post_type=" . FOXYPRESS_CUSTOM_POST_TYPE . "&page=status-management"); } if($Action == "delete" && $StatusID != "" && $StatusID != "1") { //delete status $sql = "delete from " . $wpdb->prefix . "foxypress_transaction_status WHERE foxy_transaction_status = '$StatusID'"; $wpdb->query($sql); //update transactions in limbo to unprocessed $sql = "update " . $wpdb->prefix ."foxypress_transaction SET foxy_transaction_status = '1' WHERE foxy_transaction_status = '$StatusID'"; $wpdb->query($sql); header("location: " . foxypress_GetCurrentPageURL(false) . "?post_type=" . FOXYPRESS_CUSTOM_POST_TYPE . "&page=status-management"); } } } function status_management_page_load() { global $wpdb; $StatusID = foxypress_FixGetVar("status", ""); $Action = foxypress_FixGetVar("action", ""); $sm_error = ""; ?>

Description cannot be blank"; } else { //proceed with update $sql = "UPDATE " . $wpdb->prefix . "foxypress_transaction_status SET foxy_transaction_status_description='$status_description' ,foxy_transaction_status_email_flag='$status_email_flag' ,foxy_transaction_status_email_subject='$status_email_subject' ,foxy_transaction_status_email_body='$status_email_body' ,foxy_transaction_status_email_tracking = '$status_email_tracking' WHERE foxy_transaction_status = '$StatusID'"; $wpdb->query($sql); $sm_error = "*Successfully Saved"; } } //edit status $drStatus = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "foxypress_transaction_status WHERE foxy_transaction_status = '$StatusID'"); if(!empty($drStatus)) { ?>
Status ID   foxy_transaction_status) ?>
Status Description  
Email Customer foxy_transaction_status_email_flag == "1") ? "checked='checked'" : "") ?> id="foxy_sm_status_email_flag" name="foxy_sm_status_email_flag" /> If this is checked, the customer will be emailed when the status on their transaction is changed to this status
Email Subject
Email Body
Include Tracking foxy_transaction_status_email_tracking == "1") ? "checked='checked'" : "") ?> id="foxy_sm_status_email_tracking" name="foxy_sm_status_email_tracking" />
prefix . "foxypress_transaction_status"; $TransactionStatuses = $wpdb->get_results($sql); $Statuses = ""; if( !empty($TransactionStatuses) ) { foreach ( $TransactionStatuses as $ts ) { $Statuses .= " foxy_transaction_status . "\">" . stripslashes($ts->foxy_transaction_status_description) . " " . ($ts->foxy_transaction_status_email_flag == "1" ? "Y" : "N") . " " . ($ts->foxy_transaction_status_email_tracking == "1" ? "Y" : "N") . " " . (( $ts->foxy_transaction_status != "1" ) ? "foxy_transaction_status . "\" onclick=\"return confirm('Are you sure you want to delete this status? Any transaction tied to this status will be set back to Uncategorized.')\">Delete" : "") . " "; } } ?>
New Status:
 
Status Email Customer Include Tracking