Wiki source code of DeleteSpamUsers

Last modified by JeromeVelociter on 2010/03/20 15:50

Show last authors
1 {{velocity}}
2 #foreach($result in $xwiki.search("select doc.fullName, prop.value from XWikiDocument as doc, BaseObject as obj, StringProperty as prop where obj.className='XWiki.XWikiUsers' and obj.name=doc.fullName and prop.id.id=obj.id and prop.name='first_name' and prop.value in (select prop.value from StringProperty as prop2 where prop2.id.id=obj.id and prop2.name='last_name' and prop2.value=prop.value)"))
3 #if ($request.confirm == "1")
4 #set ($userDoc = $xwiki.getDocument($result.get(0)))
5 $userDoc.delete()
6 #set ($extraText = "- Deleted!")
7 #end
8 * $result.get(0) - $result.get(1) $!extraText
9 #end
10 {{/velocity}}