Titles for Attending Users Lists
From this page you can add new titles for Attending Users Lists, or delete existing
';
// view for form for adding new titles
echo '
Add Title
'
;
// view listing titles and giving option to delete them
echo '
Titles
';
$titles = $wpdb->get_results("
SELECT att_title
FROM ".$wpdb->prefix."att_list_titles
");
foreach ( $titles as $title ) {
$titles_listed = $title->att_title;
echo '
'.$titles_listed.' X
';
}
echo '
';
/* the folloring statements check if there are comming new values for the supported options
* name of subscribe button
* name of unsubscribe button
* name of message for not logged in users
* name of new content type */
if ($_POST['att_btn_sub'] != null) {
$att_global_settings['att_btn_sub'] = $_POST['att_btn_sub'];
}
if ($_POST['att_btn_unsub'] != null ) {
$att_global_settings['att_btn_unsub'] = $_POST['att_btn_unsub'];
}
if ($_POST['att_msg_not_logged'] != null) {
$att_global_settings['att_msg_not_logged'] = $_POST['att_msg_not_logged'];
}
if ($_POST['att_post_types'] != null) {
$att_global_settings['att_post_types'][] = $_POST['att_post_types'];
}
update_option('att_reg_settings', $att_global_settings);
// view of form for adding new post types
?>
Add Post Type Support
Post Types
$key ) {
echo '
'.$key.' X
';
}
?>
ID);
$att_add_title = $custom["att_add_title"][0];
if ($att_add_title) {
// establish database connection between the post and the selected title
$wpdb->query ("
INSERT INTO ".$wpdb->prefix."att_titles (att_title, att_post_id)
VALUES ('".$att_add_title."', '".$post->ID."')
");
// update the title - no matter if changed or not
$wpdb->query ("
UPDATE ".$wpdb->prefix."att_titles
SET att_title='".$att_add_title."'
WHERE att_post_id='".$post->ID."'
");
}
// if $att_add_title == null - delete all users from the list and the title reference
// ps. may be I should change that code, because it adds extra queries to the system
else {
$wpdb->query ("
DELETE
FROM ".$wpdb->prefix."att_users
WHERE att_post_id = ".$post->ID."
");
$wpdb->query ("
DELETE
FROM ".$wpdb->prefix."att_titles
WHERE att_post_id = ".$post->ID."
");
}
// get all titles from the database
$titles = $wpdb->get_results("
SELECT *
FROM ".$wpdb->prefix."att_list_titles
");
echo '