More reminder_subscriptions fixes

2 files changed, 20 insertions, 12 deletions

diff --git a/reminder.install b/reminder.install
index 395838a..2c7df59 100644
--- a/reminder.install
+++ b/reminder.install
@@ -94,7 +94,7 @@ function reminder_schema() {
       ),
       'unsubscribe_url' => array(
         'type' => 'varchar',
-        'length' => 25,
+        'length' => 30,
         'not null' => TRUE,
         'default' => ''
       ),
@@ -207,3 +207,17 @@ function reminder_update_7002(&$sandbox) {
     )
   );
 }
+
+/**
+ * Increase unsubscribe_url size.
+ */
+function reminder_update_7003(&$sandbox) {
+  db_change_field('reminder_subscriptions', 'unsubscribe_url', 'unsubscribe_url',
+      array(
+        'type'     => 'varchar',
+        'length'   => 30,
+        'not null' => TRUE,
+        'default'  => ''
+        )
+      );
+}
diff --git a/reminder.module b/reminder.module
index 4a22a21..b3a550a 100644
--- a/reminder.module
+++ b/reminder.module
@@ -263,6 +263,7 @@ function reminder_validate($node, $form, &$form_state) {
  *   Date, remind and subscribe widgets.
  *   Update subscribers, removing old ones.
  *   Optionally send unsubscription email for removed users.
+ *   Redirect to reminder page.
  */
 function reminder_node_submit($node, $form, &$form_state) {
   global $user;
@@ -318,9 +319,9 @@ function reminder_node_submit($node, $form, &$form_state) {
         'reminder_id'     => $node->nid,
         'unsubscribe_url' => $unsubscribe_url,
       );
-    }
 
-    $query = db_insert('reminder_subscriptions')->fields($values);
+      $query = db_insert('reminder_subscriptions')->fields($values)->execute();
+    }
   }
   else {
     // Fetch existing options.
@@ -410,15 +411,8 @@ function reminder_node_submit($node, $form, &$form_state) {
  * @todo
  */
 function reminder_mail($key, &$message, $params) {
-   $account   = $params['account'];
-   $context   = $params['context'];
-   $variables = array(
-     '%site_name' => variable_get('site_name', 'Drupal'),
-     '%username'  => format_username($account),
-   );
-
-   $subject             = strtr($context['subject'], $variables);
-   $body                = strtr($context['message'], $variables);
+   $subject             = t('Reminder information');
+   $body                = t('Reminder URL: @url', array('@url' => $params['reminder_url']));
    $message['subject'] .= str_replace(array("\r", "\n"), '', $subject);
    $message['body'][]   = drupal_html_to_text($body);