Update of /var/cvs/contributions/didactor2/src/core/templates/scripts
In directory james.mmbase.org:/tmp/cvs-serv15240
Modified Files:
cleanMail.jspx index.jspx
Added Files:
cleanAttachments.jspx
Log Message:
a script to clean up pending attachments
See also:
http://cvs.mmbase.org/viewcvs/contributions/didactor2/src/core/templates/scripts
cleanAttachments.jspx is new
Index: cleanMail.jspx
===================================================================
RCS file:
/var/cvs/contributions/didactor2/src/core/templates/scripts/cleanMail.jspx,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- cleanMail.jspx 22 Jan 2008 11:13:25 -0000 1.2
+++ cleanMail.jspx 22 Jan 2008 12:12:04 -0000 1.3
@@ -16,6 +16,9 @@
<link rel="stylesheet" href="${mm:url('/mmbase/style/css/mmbase.css',
pageContext)}" type="text/css" />
</head>
<body>
+ <p>
+ <em>You may have to run this page several times, until nothing
happens. Because the query can be killed of by MMBase when it takes to
long.</em>
+ </p>
<mm:jdbc throwexception="true" mode="nodes" query="select e.number
from $PREFIX_emails e left join $PREFIX_insrel i on e.number = i.dnumber left
join $PREFIX_mailboxes b on i.snumber = b.number where b.number is null">
<p>
Index: index.jspx
===================================================================
RCS file:
/var/cvs/contributions/didactor2/src/core/templates/scripts/index.jspx,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- index.jspx 22 Jan 2008 11:07:55 -0000 1.2
+++ index.jspx 22 Jan 2008 12:12:04 -0000 1.3
@@ -69,6 +69,9 @@
<p>
<a href="cleanMail.jspx">Remove all mail not in mailboxes</a>
</p>
+ <p>
+ <a href="cleanAttachments.jspx">Remove all attachments not related
to anything</a>
+ </p>
</body>
</html>
</mm:content>
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
