/**
* Website: www.jtips.com.au
* @author Jeremy Roberts
* @copyright Copyright © 2009, jTips
* @license Commercial - See website for details
*
* @since 2.1.14 - 31/08/2009
* @version 1.0.0
* @package jTips
*
* Description: apply the changes and reload the configuration page
*/
global $database;
jTipsSpoofCheck();
require_once 'components/com_jtips/classes/juser.class.php';
jTipsLogger::_log('Cleaning users', 'info');
// find out which users are not in the #__users table
$query = "SELECT j.id FROM #__jtips_users j LEFT JOIN #__users u ON j.user_id = u.id WHERE u.id IS NULL";
$database->setQuery($query);
$database->query();
$total = $database->getNumRows();
jTipsLogger::_log('Found ' . $total . ' users to be removed');
if ($total > 1) {
$ids = (array) $database->loadResultArray();
foreach ($ids as $id) {
$jTipsUser = new jTipsUser($database);
$jTipsUser->destroy($id);
}
}
$message = sprintf($jLang['_COM_ADMIN_USERS_CLEANED_MESSAGE'], $total);
mosRedirect('index2.php?option=com_jtips&module=Users&task=list', $message);
}
}
jTipsLogger::_log('deleting rounds from season');
foreach ($jRounds as $jRound) {
array_push($destroyed, $jRound->destroy());
}
$jTipsUser = new jTipsUser($database);
$jTipsUsers = $jTipsUser->loadByParams($params);
if (!is_array($jTipsUsers)) {
if ($jTipsUser->exists()) {
$jTipsUsers = array($jTipsUser);
} else {
$jTipsUsers = array();
}
}
jTipsLogger::_log('deleting users from season');
foreach ($jTipsUsers as $jTipsUser) {
array_push($destroyed, $jTipsUser->destroy());
}
array_push($destroyed, $jSeason->destroy());
if (in_array(FALSE, $destroyed)) {
$message = 'Season(s) not cleanly removed!';
} else {
$message = 'Season(s) deleted!';
}
}
}
} else {
$message = 'Failed to delete season';
}
mosRedirect('index2.php?option=com_jtips&task=list&module=Seasons', $message);
* @copyright Copyright © 2009, jTips
* @license Commercial - See website for details
*
* @since 2.1 - 16/10/2008
* @version 2.1
* @package jTips
*
* Description:
*/
global $database, $jTips, $mainframe;
require_once $mosConfig_absolute_path . '/administrator/components/com_jtips/classes/juser.class.php';
$my =& $mainframe->getUser();
$season_id = getSeasonID();
if (!$season_id or empty($my->id)) {
jTipsRedirect('index.php?option=com_jtips&Itemid=' . jTipsGetParam($_REQUEST, 'Itemid'));
}
$jTipsUser = new jTipsUser($database);
$parameters = array('user_id' => $my->id, 'season_id' => $season_id);
$jTipsUser->loadByParams($parameters);
if ($jTipsUser->exists()) {
jTipsLogger::_log('removing user ' . $jTipsUser->id . ' from competition ' . $jTipsUser->season_id);
$jTipsUser->destroy();
}
$message = $jLang['_COM_UNSUBSCRIBE_SUCCESS'];
//do we need to stop any paypal subscriptions?
if ($jTips['Payments'] == 'paypal' and $jTips['PayPalIsSub'] and !empty($jTips['PayPalUnSub'])) {
//Yes! redirect to paypal cancel page
jTipsRedirect(stripslashes($jTips['PayPalUnSub']), $message);
} else {
jTipsRedirect('index.php?option=com_jtips&Itemid=' . jTipsGetParam($_REQUEST, 'Itemid') . '&season=' . $season_id, $message);
}
