function cp_custom_fields() { global $options_new_field, $wpdb, $current_user; $current_user = wp_get_current_user(); ?> <!-- show/hide the dropdown field values tr --> <script type="text/javascript"> /* <![CDATA[ */ jQuery(document).ready(function() { jQuery("#mainform").validate({errorClass: "invalid"}); }); function show(o){ if(o){switch(o.value){ case 'drop-down': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'radio': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'checkbox': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'text box': jQuery('#field_min_length_row').show(); jQuery('#field_values_row').hide(); break; default: jQuery('#field_values_row').hide();jQuery('#field_min_length_row').hide(); }} } //show/hide immediately on document load jQuery(document).ready(function() { show(jQuery('#field_type').get(0)); }); //hide unwanted options for cp_currency field jQuery(document).ready(function() { var field_name = jQuery('#field_name').val(); if(field_name == 'cp_currency'){ jQuery("#field_type option[value='text box']").attr("disabled","disabled"); jQuery("#field_type option[value='text area']").attr("disabled","disabled"); jQuery("#field_type option[value='checkbox']").attr("disabled","disabled"); } }); /* ]]> */ </script> <?php // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['action'])) { $theswitch = $_GET['action']; } else { $theswitch = ''; } switch ($theswitch) { // Adds a new AV form filed to DB case 'addfield': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('New Custom Field', 'appthemes'); ?> </h2> <?php cp_admin_info_box(); ?> <?php // check and make sure the form was submitted if (isset($_POST['submitted'])) { $_POST['field_search'] = ''; // we aren't using this field so set it to blank for now to prevent notice $insert = "INSERT INTO {$wpdb->cp_ad_fields} ( field_name, field_label, field_desc, field_tooltip, field_type, field_values, field_search, field_owner, field_max_value, field_min_value, field_created, field_modified ) VALUES ( '" . $wpdb->escape(appthemes_clean(cp_make_custom_name($_POST['field_label']))) . "','" . $wpdb->escape(appthemes_clean($_POST['field_label'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_desc'])) . "','" . $wpdb->escape(esc_attr(appthemes_clean($_POST['field_tooltip']))) . "','" . $wpdb->escape(appthemes_clean($_POST['field_type'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_values'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_search'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_owner'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_max_value'])) . "','" . $wpdb->escape(appthemes_clean($_POST['field_min_value'])) . "','" . current_time('mysql') . "','" . current_time('mysql') . "' )"; $results = $wpdb->query($insert); if ($results) { //$lastid = $wpdb->insert_id; //echo $lastid; ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Creating your field.....', 'appthemes'); ?> <br /><br /><img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php } die; } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_fields($options_new_field); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Create New Field', 'appthemes'); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=fields'" value="<?php _e('Cancel', 'appthemes'); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } ?> </div><!-- end wrap --> <?php break; // Updates an existing AV form filed from DB // Updates an existing AV form filed from DB case 'editfield': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2>Genel Alanlari Duzenle</h2> <?php cp_admin_info_box(); ?> <?php if (isset($_POST['submitted']) && $_POST['submitted'] == 'yes') { // @todo Change to Update $update = $wpdb->prepare("UPDATE {$wpdb->cp_ad_fields} SET" . " field_name = %s," . " field_label = %s," . " field_desc = %s," . " field_tooltip = %s," . " field_type = %s," . " field_values = %s," . " field_min_length = %s," . " field_owner = %s," . " field_max_value = %s," . " field_min_value = %s," . " field_modified = %s" . " WHERE field_id = %s", appthemes_clean($_POST['field_name']), appthemes_clean($_POST['field_label']), appthemes_clean($_POST['field_desc']), esc_attr(appthemes_clean($_POST['field_tooltip'])), appthemes_clean($_POST['field_type']), appthemes_clean($_POST['field_values']), appthemes_clean($_POST['field_min_length']), appthemes_clean($_POST['field_owner']), appthemes_clean($_POST['field_max_value']), appthemes_clean($_POST['field_min_value']), current_time('mysql'), $_GET['id']); $results = $wpdb->query($update); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"> <?php _e('Saving your changes.....', 'appthemes'); ?> <br /><br /> <img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /> </p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_db_fields($options_new_field, 'cp_ad_fields', 'field_id'); ?> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="Degisiklikleri Kaydet" /> <input name="cancel" type="button" onClick="location.href='?page=fields'" value="Degisiklikleri iptal et" /> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </p> </form> <?php } ?> </div><!-- end wrap --> <?php break; // Deletes an existing AV form filed from DB // Deletes an existing AV form filed from DB case 'delete': // check and make sure this fields perms allow deletion $sql = "SELECT field_perm " . "FROM {$wpdb->cp_ad_fields} " . "WHERE field_id = '" . $_GET['id'] . "' LIMIT 1"; $results = $wpdb->get_row($sql); // if it's not greater than zero, then delete it if (!$results->field_perm > 0) { $delete = "DELETE FROM {$wpdb->cp_ad_fields} WHERE field_id = '" . $_GET['id'] . "'"; $wpdb->query($delete); } ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Deleting custom field.....', 'appthemes'); ?> <br /><br /><img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php break; // cp_custom_fields() show the table of all custom fields // cp_custom_fields() show the table of all custom fields default: $sql = "SELECT field_id, field_name, field_label, field_desc, field_tooltip, field_type, field_perm, field_owner, field_modified " . "FROM {$wpdb->cp_ad_fields} " . "ORDER BY field_name desc"; $results = $wpdb->get_results($sql); ?> <div class="wrap"> <div class="icon32" id="icon-tools"><br /></div> <h2>Genel Alanlar <a class="button add-new-h2" href="?page=fields&action=addfield">Yeni Alan Ekle</a></h2> <?php cp_admin_info_box(); ?> <p class="admin-msg"><?php _e('Genel Alanlar Erisim Engeli Formlarinda kullanicilarin doldurduklari Erisim Engellerine bagli alanlari olusturmaktadir. Asagidaki tabloda tum Erisim Engeli Alanlari listelenmektedir. Yeni bir alan ekleyebilir ve var olan alanlari degistirebilirsiniz.', 'appthemes'); ?> </p> <table id="tblspacer" class="widefat fixed"> <thead> <tr> <th scope="col" style="width:35px;"> </th> <th scope="col"><?php _e('Alan Ismi', 'appthemes'); ?> </th> <th scope="col" style="width:100px;"><?php _e('Alan Tipi', 'appthemes'); ?> </th> <th scope="col"><?php _e('Alan Aciklamasi', 'appthemes'); ?> </th> <th scope="col" style="width:150px;"><?php _e('Degistiren', 'appthemes'); ?> </th> <th scope="col" style="text-align:center;width:100px;"><?php _e('Aksiyonlar', 'appthemes'); ?> </th> </tr> </thead> <?php if ($results) { ?> <tbody id="list"> <?php $rowclass = ''; $i = 1; foreach ($results as $result) { $rowclass = 'even' == $rowclass ? 'alt' : 'even'; ?> <tr class="<?php echo $rowclass; ?> "> <td style="padding-left:10px;"><?php echo $i; ?> .</td> <td><a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><strong><?php echo esc_html(translate($result->field_label, 'appthemes')); ?> </strong></a></td> <td><?php echo $result->field_type; ?> </td> <td><?php echo esc_html(translate($result->field_desc, 'appthemes')); ?> </td> <td><?php echo mysql2date(get_option('date_format') . ' ' . get_option('time_format'), $result->field_modified); ?> <?php _e('by', 'appthemes'); ?> <?php echo $result->field_owner; ?> </td> <td style="text-align:center"> <?php // show the correct edit options based on perms switch ($result->field_perm) { case '1': // core fields no editing ?> <a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><img src="<?php echo bloginfo('template_directory'); ?> /images/edit.png" alt="" /></a> <img src="<?php echo bloginfo('template_directory'); ?> /images/cross-grey.png" alt="" /> <?php break; case '2': // core fields some editing ?> <a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><img src="<?php echo bloginfo('template_directory'); ?> /images/edit.png" alt="" /></a> <img src="<?php echo bloginfo('template_directory'); ?> /images/cross-grey.png" alt="" /> <?php break; default: // regular fields full editing // don't change these two lines to plain html/php. Get t_else error msg echo '<a href="?page=fields&action=editfield&id=' . $result->field_id . '"><img src="' . get_bloginfo('template_directory') . '/images/edit.png" alt="" /></a> '; echo '<a onclick="return confirmBeforeDelete();" href="?page=fields&action=delete&id=' . $result->field_id . '"><img src="' . get_bloginfo('template_directory') . '/images/cross.png" alt="" /></a>'; } // endswitch ?> </td> </tr> <?php $i++; } //end foreach; //} // mystery bracket which makes it work ?> </tbody> <?php } else { ?> <tr> <td colspan="5"><?php _e('No custom fields found. This usually means your install script did not run correctly. Go back and try reactivating the theme again.', 'appthemes'); ?> </td> </tr> <?php } // end $results ?> </table> </div><!-- end wrap --> <?php } // endswitch ?> <script type="text/javascript"> /* <![CDATA[ */ function confirmBeforeDelete() { return confirm("<?php _e('WARNING: Deleting this field will prevent any existing ads currently using this field from displaying the field value. Deleting fields is NOT recommended unless you do not have any existing ads using this field. Are you sure you want to delete this field?? (This cannot be undone)', 'appthemes'); ?> "); } /* ]]> */ </script> <?php }
function cp_custom_fields() { global $options_new_field, $wpdb, $current_user; $current_user = wp_get_current_user(); ?> <!-- show/hide the dropdown field values tr --> <script type="text/javascript"> /* <![CDATA[ */ jQuery(document).ready(function() { jQuery("#mainform").validate({errorClass: "invalid"}); }); function show(o){ if(o){switch(o.value){ case 'drop-down': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'radio': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'checkbox': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'text box': jQuery('#field_min_length_row').show(); jQuery('#field_values_row').hide(); break; default: jQuery('#field_values_row').hide(); jQuery('#field_min_length_row').hide(); }} } //show/hide immediately on document load jQuery(document).ready(function() { show(jQuery('#field_type').get(0)); }); //hide unwanted options for cp_currency field jQuery(document).ready(function() { var field_name = jQuery('#field_name').val(); if(field_name == 'cp_currency'){ jQuery("#field_type option[value='text box']").attr("disabled", "disabled"); jQuery("#field_type option[value='text area']").attr("disabled", "disabled"); jQuery("#field_type option[value='checkbox']").attr("disabled", "disabled"); } }); /* ]]> */ </script> <?php // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['action'])) { $theswitch = $_GET['action']; } else { $theswitch = ''; } switch ($theswitch) { case 'addfield': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('New Custom Field', APP_TD); ?> </h2> <?php cp_admin_info_box(); ?> <?php // check and make sure the form was submitted if (isset($_POST['submitted'])) { $_POST['field_search'] = ''; // we aren't using this field so set it to blank for now to prevent notice $data = array('field_name' => appthemes_clean(cp_make_custom_name($_POST['field_label'])), 'field_label' => appthemes_clean($_POST['field_label']), 'field_desc' => appthemes_clean($_POST['field_desc']), 'field_tooltip' => esc_attr(appthemes_clean($_POST['field_tooltip'])), 'field_type' => appthemes_clean($_POST['field_type']), 'field_values' => appthemes_clean($_POST['field_values']), 'field_search' => appthemes_clean($_POST['field_search']), 'field_owner' => appthemes_clean($_POST['field_owner']), 'field_created' => current_time('mysql'), 'field_modified' => current_time('mysql')); $insert = $wpdb->insert($wpdb->cp_ad_fields, $data); if ($insert) { ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Creating your field.....', APP_TD); ?> <br /><br /><img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php } die; } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_fields($options_new_field); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Create New Field', APP_TD); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=fields'" value="<?php _e('Cancel', APP_TD); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } ?> </div><!-- end wrap --> <?php break; case 'editfield': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('Edit Custom Field', APP_TD); ?> </h2> <?php cp_admin_info_box(); ?> <?php if (isset($_POST['submitted']) && $_POST['submitted'] == 'yes') { $data = array('field_name' => appthemes_clean($_POST['field_name']), 'field_label' => appthemes_clean($_POST['field_label']), 'field_desc' => appthemes_clean($_POST['field_desc']), 'field_tooltip' => esc_attr(appthemes_clean($_POST['field_tooltip'])), 'field_type' => appthemes_clean($_POST['field_type']), 'field_values' => appthemes_clean($_POST['field_values']), 'field_min_length' => appthemes_clean($_POST['field_min_length']), 'field_owner' => appthemes_clean($_POST['field_owner']), 'field_modified' => current_time('mysql')); $wpdb->update($wpdb->cp_ad_fields, $data, array('field_id' => $_GET['id'])); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"> <?php _e('Saving your changes.....', APP_TD); ?> <br /><br /> <img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /> </p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_db_fields($options_new_field, 'cp_ad_fields', 'field_id'); ?> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="<?php _e('Save changes', APP_TD); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=fields'" value="<?php _e('Cancel', APP_TD); ?> " /> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </p> </form> <?php } ?> </div><!-- end wrap --> <?php break; case 'delete': // check and make sure this fields perms allow deletion $sql = $wpdb->prepare("SELECT field_perm FROM {$wpdb->cp_ad_fields} WHERE field_id = %d LIMIT 1", $_GET['id']); $results = $wpdb->get_row($sql); // if it's not greater than zero, then delete it if (!$results->field_perm > 0) { $delete = $wpdb->prepare("DELETE FROM {$wpdb->cp_ad_fields} WHERE field_id = %d", $_GET['id']); $wpdb->query($delete); } ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Deleting custom field.....', APP_TD); ?> <br /><br /><img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=fields"> <?php break; // cp_custom_fields() show the table of all custom fields // cp_custom_fields() show the table of all custom fields default: $sql = "SELECT field_id, field_name, field_label, field_desc, field_tooltip, field_type, field_perm, field_owner, field_modified " . "FROM {$wpdb->cp_ad_fields} " . "ORDER BY field_name desc"; $results = $wpdb->get_results($sql); ?> <div class="wrap"> <div class="icon32" id="icon-tools"><br /></div> <h2><?php _e('Custom Fields', APP_TD); ?> <a class="button add-new-h2" href="?page=fields&action=addfield"><?php _e('Add New', APP_TD); ?> </a></h2> <?php cp_admin_info_box(); ?> <p class="admin-msg"><?php _e('Custom fields allow you to customize your ad submission forms and collect more information. Each custom field needs to be added to a form layout in order to be visible on your website. You can create unlimited custom fields and each one can be used across multiple form layouts. It is highly recommended to NOT delete a custom field once it is being used on your ads because it could cause ad editing problems for your customers.', APP_TD); ?> </p> <table id="tblspacer" class="widefat fixed"> <thead> <tr> <th scope="col" style="width:35px;"> </th> <th scope="col"><?php _e('Name', APP_TD); ?> </th> <th scope="col" style="width:100px;"><?php _e('Type', APP_TD); ?> </th> <th scope="col"><?php _e('Description', APP_TD); ?> </th> <th scope="col" style="width:150px;"><?php _e('Modified', APP_TD); ?> </th> <th scope="col" style="text-align:center;width:100px;"><?php _e('Actions', APP_TD); ?> </th> </tr> </thead> <?php if ($results) { ?> <tbody id="list"> <?php $rowclass = ''; $i = 1; foreach ($results as $result) { $rowclass = 'even' == $rowclass ? 'alt' : 'even'; ?> <tr class="<?php echo $rowclass; ?> "> <td style="padding-left:10px;"><?php echo $i; ?> .</td> <td><a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><strong><?php echo esc_html(translate($result->field_label, APP_TD)); ?> </strong></a></td> <td><?php echo $result->field_type; ?> </td> <td><?php echo esc_html(translate($result->field_desc, APP_TD)); ?> </td> <td><?php echo mysql2date(get_option('date_format') . ' ' . get_option('time_format'), $result->field_modified); ?> <?php _e('by', APP_TD); ?> <?php echo $result->field_owner; ?> </td> <td style="text-align:center"> <?php // show the correct edit options based on perms switch ($result->field_perm) { case '1': // core fields no editing ?> <a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><img src="<?php bloginfo('template_directory'); ?> /images/edit.png" alt="" /></a> <img src="<?php bloginfo('template_directory'); ?> /images/cross-grey.png" alt="" /> <?php break; case '2': // core fields some editing ?> <a href="?page=fields&action=editfield&id=<?php echo $result->field_id; ?> "><img src="<?php bloginfo('template_directory'); ?> /images/edit.png" alt="" /></a> <img src="<?php bloginfo('template_directory'); ?> /images/cross-grey.png" alt="" /> <?php break; default: // regular fields full editing // don't change these two lines to plain html/php. Get t_else error msg echo '<a href="?page=fields&action=editfield&id=' . $result->field_id . '"><img src="' . get_bloginfo('template_directory') . '/images/edit.png" alt="" /></a> '; echo '<a onclick="return confirmBeforeDelete();" href="?page=fields&action=delete&id=' . $result->field_id . '"><img src="' . get_bloginfo('template_directory') . '/images/cross.png" alt="" /></a>'; } // endswitch ?> </td> </tr> <?php $i++; } //end foreach; //} // mystery bracket which makes it work ?> </tbody> <?php } else { ?> <tr> <td colspan="5"><?php _e('No custom fields found. This usually means your install script did not run correctly. Go back and try reactivating the theme again.', APP_TD); ?> </td> </tr> <?php } // end $results ?> </table> </div><!-- end wrap --> <?php } // endswitch ?> <script type="text/javascript"> /* <![CDATA[ */ function confirmBeforeDelete() { return confirm("<?php _e('WARNING: Deleting this field will prevent any existing ads currently using this field from displaying the field value. Deleting fields is NOT recommended unless you do not have any existing ads using this field. Are you sure you want to delete this field?? (This cannot be undone)', APP_TD); ?> "); } /* ]]> */ </script> <?php }
/** * Handles form fields admin page. * * @return void */ function cp_custom_fields() { global $options_new_field, $wpdb, $current_user; $current_user = wp_get_current_user(); ?> <!-- show/hide the dropdown field values tr --> <script type="text/javascript"> /* <![CDATA[ */ jQuery(document).ready(function() { jQuery("#mainform").validate({errorClass: "invalid"}); }); function show(o){ if(o){switch(o.value){ case 'drop-down': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'radio': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'checkbox': jQuery('#field_values_row').show(); jQuery('#field_min_length_row').hide(); break; case 'text box': jQuery('#field_min_length_row').show(); jQuery('#field_values_row').hide(); break; default: jQuery('#field_values_row').hide(); jQuery('#field_min_length_row').hide(); }} } //show/hide immediately on document load jQuery(document).ready(function() { show(jQuery('#field_type').get(0)); }); //hide unwanted options for cp_currency field jQuery(document).ready(function() { var field_name = jQuery('#field_name').val(); if(field_name == 'cp_currency'){ jQuery("#field_type option[value='text box']").attr("disabled", "disabled"); jQuery("#field_type option[value='text area']").attr("disabled", "disabled"); jQuery("#field_type option[value='checkbox']").attr("disabled", "disabled"); } }); /* ]]> */ </script> <?php $theswitch = isset($_GET['action']) ? $_GET['action'] : ''; $admin_fields_url = get_admin_url('', 'edit.php?post_type=' . APP_POST_TYPE . '&page=fields'); switch ($theswitch) { case 'addfield': ?> <div class="wrap"> <h2><?php _e('New Custom Field', APP_TD); ?> </h2> <?php // check and make sure the form was submitted if (isset($_POST['submitted'])) { $_POST['field_search'] = ''; // we aren't using this field so set it to blank for now to prevent notice $data = array('field_name' => cp_make_custom_name($_POST['field_label'], 'fields'), 'field_label' => appthemes_clean($_POST['field_label']), 'field_desc' => appthemes_clean($_POST['field_desc']), 'field_tooltip' => appthemes_clean($_POST['field_tooltip']), 'field_type' => appthemes_clean($_POST['field_type']), 'field_values' => appthemes_clean($_POST['field_values']), 'field_search' => appthemes_clean($_POST['field_search']), 'field_owner' => appthemes_clean($_POST['field_owner']), 'field_created' => current_time('mysql'), 'field_modified' => current_time('mysql')); $insert = $wpdb->insert($wpdb->cp_ad_fields, $data); if ($insert) { do_action('cp_custom_fields', 'addfield', $wpdb->insert_id); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Creating your field.....', APP_TD); ?> <br/><br/><img src="<?php echo get_template_directory_uri(); ?> /images/loader.gif" alt="" /> </p> <meta http-equiv="refresh" content="0; URL=<?php echo $admin_fields_url; ?> " > <?php } die; } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_db_fields($options_new_field); ?> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="<?php esc_attr_e('Create New Field', APP_TD); ?> " /> <input class="btn button-secondary" name="cancel" type="button" onClick="location.href='<?php echo $admin_fields_url; ?> '" value="<?php _e('Cancel', APP_TD); ?> " /> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo esc_attr($current_user->user_login); ?> " /> </p> </form> <?php } ?> </div><!-- end wrap --> <?php break; case 'editfield': ?> <div class="wrap"> <h2><?php _e('Edit Custom Field', APP_TD); ?> </h2> <?php if (isset($_POST['submitted']) && $_POST['submitted'] == 'yes') { $data = array('field_name' => appthemes_clean($_POST['field_name']), 'field_label' => appthemes_clean($_POST['field_label']), 'field_desc' => appthemes_clean($_POST['field_desc']), 'field_tooltip' => esc_attr(appthemes_clean($_POST['field_tooltip'])), 'field_type' => appthemes_clean($_POST['field_type']), 'field_values' => appthemes_clean($_POST['field_values']), 'field_min_length' => appthemes_clean($_POST['field_min_length']), 'field_owner' => appthemes_clean($_POST['field_owner']), 'field_modified' => current_time('mysql')); $wpdb->update($wpdb->cp_ad_fields, $data, array('field_id' => $_GET['id'])); do_action('cp_custom_fields', 'editfield', $_GET['id']); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"> <?php _e('Saving your changes.....', APP_TD); ?> <br /><br /> <img src="<?php echo get_template_directory_uri(); ?> /images/loader.gif" alt="" /> </p> <meta http-equiv="refresh" content="0; URL=<?php echo $admin_fields_url; ?> "> <?php } else { ?> <form method="post" id="mainform" action=""> <?php cp_admin_db_fields($options_new_field, 'cp_ad_fields', 'field_id'); ?> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="<?php _e('Save changes', APP_TD); ?> " /> <input class="btn button-secondary" name="cancel" type="button" onClick="location.href='<?php echo $admin_fields_url; ?> '" value="<?php _e('Cancel', APP_TD); ?> " /> <input name="submitted" type="hidden" value="yes" /> <input name="field_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </p> </form> <?php } ?> </div><!-- end wrap --> <?php break; case 'delete': // check and make sure this fields perms allow deletion $sql = $wpdb->prepare("SELECT field_perm FROM {$wpdb->cp_ad_fields} WHERE field_id = %d LIMIT 1", $_GET['id']); $results = $wpdb->get_row($sql); // if it's not greater than zero, then delete it if (!($results->field_perm > 0)) { do_action('cp_custom_fields', 'delete', $_GET['id']); $delete = $wpdb->prepare("DELETE FROM {$wpdb->cp_ad_fields} WHERE field_id = %d", $_GET['id']); $wpdb->query($delete); } ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Deleting custom field.....', APP_TD); ?> <br /><br /><img src="<?php echo get_template_directory_uri(); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=<?php echo $admin_fields_url; ?> "> <?php break; // show the table of all custom fields // show the table of all custom fields default: $sql = "SELECT * FROM {$wpdb->cp_ad_fields} ORDER BY field_name desc"; $results = $wpdb->get_results($sql); ?> <div class="wrap"> <h2><?php _e('Custom Fields', APP_TD); ?> <a class="add-new-h2" href="<?php echo esc_url(add_query_arg('action', 'addfield', $admin_fields_url)); ?> "><?php _e('Add New', APP_TD); ?> </a></h2> <p class="admin-msg"><?php _e('Custom fields allow you to customize your ad submission forms and collect more information. Each custom field needs to be added to a form layout in order to be visible on your website. You can create unlimited custom fields and each one can be used across multiple form layouts. It is highly recommended to NOT delete a custom field once it is being used on your ads because it could cause ad editing problems for your customers.', APP_TD); ?> </p> <table id="tblspacer" class="wp-list-table widefat fixed striped"> <thead> <tr> <th scope="col" class="manage-columns column-cfield-number">#</th> <th scope="col" class="manage-columns column-cfield-name"><?php _e('Name', APP_TD); ?> </th> <th scope="col" class="manage-columns column-cfield-type"><?php _e('Type', APP_TD); ?> </th> <th scope="col" class="manage-columns column-cfield-description"><?php _e('Description', APP_TD); ?> </th> <th scope="col" class="manage-columns column-cfield-modified"><?php _e('Modified', APP_TD); ?> </th> <th scope="col" class="manage-columns column-cfield-actions" style="text-align: center;"><?php _e('Actions', APP_TD); ?> </th> </tr> </thead> <?php if ($results) { ?> <tbody id="list"> <?php $rowclass = ''; $i = 1; foreach ($results as $result) { $rowclass = 'even' == $rowclass ? 'alt' : 'even'; ?> <tr class="<?php echo $rowclass; ?> "> <td class="column-cfield-number" style="padding-left:10px;"><?php echo $i; ?> .</td> <td class="column-cfield-name"><a href="<?php echo esc_url(add_query_arg(array('action' => 'editfield', 'id' => $result->field_id), $admin_fields_url)); ?> "><strong><?php echo esc_html(translate($result->field_label, APP_TD)); ?> </strong></a></td> <td class="column-cfield-type"><?php echo $result->field_type; ?> </td> <td class="column-cfield-description"><?php echo esc_html(translate($result->field_desc, APP_TD)); ?> </td> <td class="column-cfield-modified"><?php echo appthemes_display_date($result->field_modified); ?> <?php _e('by', APP_TD); ?> <?php echo $result->field_owner; ?> </td> <td class="column-cfield-actions" style="text-align:center"> <?php // show the correct edit options based on perms switch ($result->field_perm) { case '1': // core fields no editing // core fields no editing case '2': // core fields some editing ?> <a href="<?php echo esc_url(add_query_arg(array('action' => 'editfield', 'id' => $result->field_id), $admin_fields_url)); ?> "><i class="dashicons-before custom-forms-ico edit-properties wp-ui-text-highlight" title="<?php _e('Edit', APP_TD); ?> "></i></a> <i class="dashicons-before custom-forms-ico remove remove-disabled wp-ui-text-highlight" title="<?php _e('Delete', APP_TD); ?> "></i> <?php break; default: // regular fields full editing ?> <a href="<?php echo esc_url(add_query_arg(array('action' => 'editfield', 'id' => $result->field_id), $admin_fields_url)); ?> "><i class="dashicons-before custom-forms-ico edit-properties wp-ui-text-highlight" title="<?php _e('Edit', APP_TD); ?> "></i></a> <a onclick="return confirmBeforeDelete();" href="<?php echo esc_url(add_query_arg(array('action' => 'delete', 'id' => $result->field_id), $admin_fields_url)); ?> "><i class="dashicons-before custom-forms-ico remove wp-ui-text-highlight" title="<?php _e('Delete', APP_TD); ?> "></i></a> <?php break; } // endswitch ?> </td> </tr> <?php $i++; } // endforeach; ?> </tbody> <?php } else { ?> <tr> <td colspan="5"><?php _e('No custom fields found. This usually means your install script did not run correctly. Go back and try reactivating the theme again.', APP_TD); ?> </td> </tr> <?php } ?> </table> </div><!-- end wrap --> <?php } ?> <script type="text/javascript"> /* <![CDATA[ */ function confirmBeforeDelete() { return confirm("<?php _e('WARNING: Deleting this field will prevent any existing ads currently using this field from displaying the field value. Deleting fields is NOT recommended unless you do not have any existing ads using this field. Are you sure you want to delete this field?? (This cannot be undone)', APP_TD); ?> "); } /* ]]> */ </script> <?php }