prepare( "SELECT COUNT(*) AS `count` FROM ".WP_FadeIn_TABLE." WHERE `FadeIn_id` = %d", array($did) ); $result = '0'; $result = $wpdb->get_var($sSql); if ($result != '1') { ?>prepare(" SELECT * FROM `".WP_FadeIn_TABLE."` WHERE `FadeIn_id` = %d LIMIT 1 ", array($did) ); $data = array(); $data = $wpdb->get_row($sSql, ARRAY_A); // Preset the form fields $form = array( 'FadeIn_text' => $data['FadeIn_text'], 'FadeIn_status' => $data['FadeIn_status'], 'FadeIn_group' => $data['FadeIn_group'], 'FadeIn_link' => $data['FadeIn_link'], 'FadeIn_order' => $data['FadeIn_order'] ); } // Form submitted, check the data if (isset($_POST['FadeIn_form_submit']) && $_POST['FadeIn_form_submit'] == 'yes') { // Just security thingy that wordpress offers us check_admin_referer('FadeIn_form_edit'); $form['FadeIn_text'] = isset($_POST['FadeIn_text']) ? $_POST['FadeIn_text'] : ''; if ($form['FadeIn_text'] == '') { $FadeIn_errors[] = __('Please enter the popup message.', WP_FadeIn_UNIQUE_NAME); $FadeIn_error_found = TRUE; } $form['FadeIn_link'] = isset($_POST['FadeIn_link']) ? $_POST['FadeIn_link'] : ''; $form['FadeIn_order'] = isset($_POST['FadeIn_order']) ? $_POST['FadeIn_order'] : ''; $form['FadeIn_status'] = isset($_POST['FadeIn_status']) ? $_POST['FadeIn_status'] : ''; $form['FadeIn_group'] = isset($_POST['FadeIn_group']) ? $_POST['FadeIn_group'] : ''; // No errors found, we can add this Group to the table if ($FadeIn_error_found == FALSE) { $sSql = $wpdb->prepare( "UPDATE `".WP_FadeIn_TABLE."` SET `FadeIn_text` = %s, `FadeIn_status` = %s, `FadeIn_link` = %s, `FadeIn_order` = %d, `FadeIn_group` = %s WHERE FadeIn_id = %d LIMIT 1", array($form['FadeIn_text'], $form['FadeIn_status'], $form['FadeIn_link'], $form['FadeIn_order'], $form['FadeIn_group'], $did) ); $wpdb->query($sSql); $FadeIn_success = 'Details was successfully updated.'; } } if ($FadeIn_error_found == TRUE && isset($FadeIn_errors[0]) == TRUE) { ?> 0) { ?>