Re: [PHP-DOC] #28519 [NEW]: TASK: identify orphan user notes and mass assign

[Jakub Vrana]

First step is attached. I checked the notes distribution system and this
should not harm it.

Second step will be the mass processing - checking for orphans and
mass changing of IDs.

Jakub Vrana
Index: user-notes.php
===================================================================
RCS file: /repository/php-master-web/manage/user-notes.php,v
retrieving revision 1.38
diff -u -r1.38 user-notes.php
--- user-notes.php      9 Feb 2004 16:13:59 -0000       1.38
+++ user-notes.php      26 May 2004 09:44:56 -0000
@@ -211,11 +211,7 @@
         //$mailto .= get_emails_for_sect($row["sect"]);
         mail($mailto,"note $row[id] ".($action == "reject" ? "rejected" : 
"deleted")." from $row[sect] by $user","Note Submitter: 
$row[user]\n\n----\n\n".$row['note'],"From: [EMAIL PROTECTED]: <[EMAIL PROTECTED]>");
         if ($action == 'reject') {
-          $email = clean_antispam($row['user']);
-          if (is_emailable_address($email)) {
-            # use an envelope sender that lets us ignore bounces
-            mail($email,"note $row[id] rejected and deleted from $row[sect] by notes 
editor $user",$reject_text."\n\n----- Copy of your note below 
-----\n\n".$row['note'],"From: [EMAIL PROTECTED]", '[EMAIL PROTECTED]');
-          }
+          mail_user($row['user'], "note $row[id] rejected and deleted from $row[sect] 
by notes editor $user",$reject_text."\n\n----- Copy of your note below 
-----\n\n".$row['note']);
         }
       }
       
@@ -250,13 +246,17 @@
     }
 
     $email = isset($email) ? $email : addslashes($row['user']);
+    $sect = isset($sect) ? $sect : addslashes($row['sect']);
 
     if (isset($note) && $action == "edit") {
-      if (@mysql_query("UPDATE note SET note='$note',user='$email',updated=NOW() 
WHERE id=$id")) {
+      if (@mysql_query("UPDATE note SET 
note='$note',user='$email',sect='$sect',updated=NOW() WHERE id=$id")) {
 
         // ** alerts **
         //$mailto .= get_emails_for_sect($row["sect"]);
         mail($mailto,"note $row[id] modified in $row[sect] by 
$user",stripslashes($note)."\n\n--was--\n$row[note]\n\nhttp://www.php.net/manual/en/$row[sect].php","From:
 [EMAIL PROTECTED]: <[EMAIL PROTECTED]>");
+        if (addslashes($row["sect"]) != $sect) {
+          mail_user($email, "note $id moved from $row[sect] to $sect by notes editor 
$user", "----- Copy of your note below -----\n\n".stripslashes($note));
+        }
         header('Location: user-notes.php?id=' . $id . '&was=' . $action);
         exit;
       }
@@ -279,6 +279,10 @@
 <input type="hidden" name="id" value="<?php echo $id;?>" />
 <table>
  <tr>
+  <th align="right">Section:</th>
+  <td><input type="text" name="sect" value="<?php echo clean($sect);?>" size="30" 
maxlength="80" /></td>
+ </tr>
+ <tr>
   <th align="right">email:</th>
   <td><input type="text" name="email" value="<?php echo clean($email);?>" size="30" 
maxlength="80" /></td>
  </tr>
@@ -354,3 +358,12 @@
     if ($return) { return $highlighted; }
     else { echo $highlighted; }
 }
+
+function mail_user($email, $subject, $message)
+{
+  $email = clean_antispam($email);
+  if (is_emailable_address($email)) {
+    # use an envelope sender that lets us ignore bounces
+    mail($email,$subject,$message,"From: [EMAIL PROTECTED]", '[EMAIL PROTECTED]');
+  }
+}