#!/usr/bin/php5 -q
<?php
/***************************************************************************
- * Copyright (C) 2003-2010 Polytechnique.org *
+ * Copyright (C) 2003-2011 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
INNER JOIN profile_display AS pd ON (pm.pid = pd.pid)
INNER JOIN account_profiles AS ap ON (pm.pid = ap.pid AND FIND_IN_SET(\'owner\', ap.perms))
INNER JOIN aliases AS al ON (ap.uid = al.uid AND FIND_IN_SET(\'bestalias\', al.flags))
- ORDER BY pm.pid, pm.field');
+ WHERE pm.type = \'third_party\' AND pm.field != \'deathdate\'
+ ORDER BY pm.pid, pm.field, pm.timestamp');
if ($res->total() > 0) {
$date = time();
$mailer->assign('date', $date);
$mailer->send();
- XDB::execute('DELETE FROM profile_modifications');
+ XDB::execute('DELETE FROM profile_modifications
+ WHERE type = \'third_party\'');
}
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: