MySQL queries to update conference descriptions
Here are MySQL queries for my records with use of a subquery to update empty conference descriptions.
UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'uploaded files are added here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_files` FROM `configuration`);
UPDATE `message` SET `content_markup` = IF( `content_markup` = '', "put the topic here if it doesn't fit elsewhere", `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_general` FROM `configuration`);
UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'uploaded images are added here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_images` FROM `configuration`);
UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'optionally add webpages here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_webpages` FROM `configuration`);
Entering Relative Url Change
The steps for entering a relative url for a message have changed. The relative url is now entered in the Add/Edit Message forms.
Captcha Links
Some time ago I did some research on the use of Captchas for my previous hosting service. Just capturing some links here for future reference.
Email Discussion Message Replies
Users of your website can now receive replies to discussion messages via email.
Email Added/Changed Messages
Superusers of your website can now set a permission for users to be emailed added/changed discussion messages. Check out the how tos < How To Email Added Messages > and < How To Email Changed Messages.