$direction = jTipsGetParam($_REQUEST, 'filter_order_Dir', 'asc');
if (empty($direction)) {
$direction = 'asc';
}
$orderby = jTipsGetParam($_REQUEST, 'filter_order', 'name');
if (empty($orderby)) {
$orderby = 'name';
}
$params = array('order' => array('type' => 'order', 'direction' => $direction, 'by' => $orderby), 'join_users' => array('type' => 'join', 'join_table' => '#__users', 'lhs_table' => '#__jtips_users', 'lhs_key' => 'user_id', 'rhs_table' => '#__users', 'rhs_key' => 'id'));
if ($season_id = jTipsGetParam($_REQUEST, 'season_id', false)) {
$params['season_id'] = $season_id;
}
$jTipsUsers = forceArray($jTipsUser->loadByParams($params, $limit, $limitstart));
$pageNav = new mosPageNav($jTipsUser->getCount(), $limitstart, $limit);
$data = array();
$i = 0;
foreach ($jTipsUsers as $jTipsUserItem) {
$scores = $jTipsUserItem->getSummaryScores();
$data[$jTipsUserItem->id] = array("<label for='cb{$i}'>" . $jTipsUserItem->getUserField('name') . "</label>", $jTipsUserItem->getUserField('username'), $jTipsUserItem->getSeasonName(), $jTipsUserItem->doubleup, number_format($scores[$jTipsUserItem->season_id]['average'], 2), $scores[$jTipsUserItem->season_id]['total_points'], '<div style="text-align:center;"><a href="javascript:toggleBoolean(\'' . $jTipsUserItem->id . '\', \'paid\');"><img src="images/' . ($jTipsUserItem->paid ? "tick" : "publish_x") . '.png" id="paid_' . $jTipsUserItem->id . '" border="0" /></div>', '<div style="text-align:center;"><a href="javascript:toggleBoolean(\'' . $jTipsUserItem->id . '\', \'status\');"><img src="images/' . ($jTipsUserItem->status == 1 ? "tick" : "publish_x") . '.png" border="0" id="status_' . $jTipsUserItem->id . '" /></a></div>');
$i++;
}
$jSeason = new jSeason($database);
$jSeasons = forceArray($jSeason->loadByParams());
$options = array(jTipsHTML::makeOption('', $jLang['_ADMIN_USERS_SELECT_SEASON']));
foreach ($jSeasons as $season) {
$options[] = jTipsHTML::makeOption($season->id, $season->name);
}
$filters = array($jLang['_ADMIN_SEASON_SELECT'] => jTipsHTML::selectList($options, 'season_id', "id='season_id' class='inputbox' onChange='this.form.submit();'", 'value', 'text', jTipsGetParam($_REQUEST, 'season_id', '')));
//BUG 217 - 5th arg was teamEdit, changed to list - this is the TASK form field value
jTipsAdminDisplay::ListView($formData, $header, $data, $pageNav, 'list', $filters, $jLang['_ADMIN_USERS_INFO'], true);
if ($status === 1) {
$status = $jLang['_ADMIN_ROUND_STATUS_C'];
//black - Complete
$colour = "#000000";
} else {
if ($status === -1) {
$status = $jLang['_ADMIN_ROUND_STATUS_P'];
//red - Pending Results
$colour = "#DF0009";
}
}
}
}
$data[$round->id] = array(makeListLink($jLang['_ADMIN_ROUND_ROUND'] . " " . $round->round, $i++), $round->getSeasonName(), TimeDate::toDisplayDateTime($round->start_time), TimeDate::toDisplayDateTime($round->end_time), "<div style='text-align:center;color:{$colour};font-weight:bold;'>" . $status . "</div>");
}
$jSeason = new jSeason($database);
$jSeasons = forceArray($jSeason->loadByParams());
$options = array(jTipsHTML::makeOption('', $jLang['_ADMIN_USERS_SELECT_SEASON']));
foreach ($jSeasons as $season) {
$options[] = jTipsHTML::makeOption($season->id, $season->name);
}
//$statusOptions = array(
// jTipsHTML::makeOption('', $jLang['_ADMIN_ROUND_STATUS_SELECT']),
// jTipsHTML::makeOption('false', $jLang['_ADMIN_ROUND_STATUS_NS']),
// jTipsHTML::makeOption('0', $jLang['_ADMIN_ROUND_STATUS_IP']),
// jTipsHTML::makeOption('1', $jLang['_ADMIN_ROUND_STATUS_C']),
// jTipsHTML::makeOption('-1', $jLang['_ADMIN_ROUND_STATUS_P'])
//);
$filters = array($jLang['_ADMIN_SEASON_SELECT'] => jTipsHTML::selectList($options, 'season_id', "id='season_id' class='inputbox' onChange='this.form.submit();'", 'value', 'text', jTipsGetParam($_REQUEST, 'season_id', '')));
jTipsAdminDisplay::ListView($formData, $header, $data, $pageNav, 'list', $filters, null, true);
* @since 2.0.14
* @version 2.1
* @package jTips
*
* Description: list jTips files and directories that cannot be written to
*/
global $database, $jTips, $mosConfig_absolute_path;
$header = array($jLang['_ADMIN_UPGRADER_TYPE'], $jLang['_ADMIN_UPGRADER_LOCATION'], $jLang['_ADMIN_UPGRADER_PERMISSIONS'], $jLang['_ADMIN_UPGRADER_OCTAL'], $jLang['_ADMIN_UPGRADER_OWNER']);
$formData = array('title' => $jLang['_ADMIN_UPGRADER_TITLE'], 'editTask' => '', 'module' => 'Upgrade', 'icon' => 'install');
$files = filesWritable(true);
$data = array();
$index = 0;
if (is_array($files) and !empty($files)) {
foreach ($files as $f) {
$file = $mosConfig_absolute_path . '/' . $f;
$owner = posix_getpwuid(fileowner($file));
if (is_dir($file)) {
$img = 'sections.png';
$title = $jLang['_ADMIN_UPGRADER_DIR_TITLE'];
$tip = $jLang['_ADMIN_UPGRADER_DIR_INFO'];
} else {
$img = 'document.png';
$title = $jLang['_ADMIN_UPGRADER_FILE_TITLE'];
$tip = $jLang['_ADMIN_UPGRADER_FILE_INFO'];
}
$data[$index] = array(jTipsToolTip($tip, $title, '', $img), $f, getFilePermissions($file), substr(sprintf('%o', fileperms($file)), -3), $owner['name']);
$index++;
}
}
jTipsAdminDisplay::ListView($formData, $header, $data, null, '', null, $jLang['_ADMIN_UPGRADER_LIST_INFO']);
$tpl->css = jTipsStripslashes($css);
$tpl->display();
*/
global $jLang;
$formData = array('title' => $jLang['_ADMIN_CSS_TITLE'], 'editTask' => 'edit', 'module' => 'Styles', 'icon' => 'css');
$header = array('', 'Filename', 'Date Modified', $jLang['_ADMIN_UPGRADER_PERMISSIONS']);
global $mosConfig_absolute_path;
if (isJoomla15()) {
$dir = $mosConfig_absolute_path . DS . 'components' . DS . 'com_jtips' . DS . 'css' . DS;
jimport('joomla.filesystem.folder');
$files = JFolder::files($dir);
} else {
$dir = $mosConfig_absolute_path . '/components/com_jtips/css/';
$files = findAllFiles($dir);
}
// get the key of the index.html file
$flipped = array_flip($files);
unset($files[$flipped['index.html']]);
sort($files);
$data = array();
$index = 0;
if (is_array($files) and !empty($files)) {
foreach ($files as $f) {
$file = $mosConfig_absolute_path . $f;
$data[$index] = array(makeListLink($f, $index), date('Y-m-d H:i:s', filemtime($dir . $f)), getFilePermissions($dir . $f));
$index++;
}
}
jTipsAdminDisplay::ListView($formData, $header, $data, null);
require_once 'components/com_jtips/classes/jbadword.class.php';
$formData = array('title' => $jLang['_ADMIN_BW_HEADER'], 'editTask' => 'edit', 'module' => 'BadWords', 'icon' => 'badwords');
$currentDir = jTipsGetParam($_REQUEST, 'filter_order_Dir', 'asc');
if ($currentDir == 'asc') {
$dir = 'desc';
} else {
$dir = 'asc';
}
//The header row
$header = array('', "<a href='javascript:tableOrdering(\"badword\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_BAD_WORD'] . "</a>", "<a href='javascript:tableOrdering(\"match_case\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_CASE_SENSITIVE'] . "</a>", "<a href='javascript:tableOrdering(\"action\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_ACTION'] . "</a>", "<a href='javascript:tableOrdering(\"replace\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_REPLACEMENT'] . "</a>", "<a href='javascript:tableOrdering(\"hits\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_HITS'] . "</a>", "<a href='javascript:tableOrdering(\"updated\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_BW_UPDATED'] . "</a>");
$jBadWord = new jBadWord($database);
$limitstart = jTipsGetParam($_REQUEST, 'limitstart', 0);
$limit = jTipsGetParam($_REQUEST, 'limit', 25);
$direction = jTipsGetParam($_REQUEST, 'filter_order_Dir', 'asc');
if (empty($direction)) {
$direction = 'asc';
}
$orderby = jTipsGetParam($_REQUEST, 'filter_order', 'badword');
if (empty($orderby)) {
$orderby = 'badword';
}
$params = array('order' => array('type' => 'order', 'direction' => $direction, 'by' => $orderby));
$jBadWords = forceArray($jBadWord->loadByParams($params, $limit, $limitstart));
$pageNav = new mosPageNav($jBadWord->getCount(), $limitstart, $limit);
$data = array();
$i = 0;
foreach ($jBadWords as $badword) {
$data[$badword->id] = array(makeListLink($badword->badword, $i++), "<div style='text-align:center;'><img src='images/" . ($badword->match_case ? 'tick' : 'publish_x') . ".png' border='0' alt='{$badword->match_case}' /></div>", ucwords($badword->action), $badword->replace, $badword->hits, TimeDate::toDisplayDateTime($badword->updated));
}
jTipsAdminDisplay::ListView($formData, $header, $data, $pageNav, 'edit');
* @license Commercial - See website for details
*
* @since 2.1 - 02/10/2008
* @version 2.1
* @package jTips
*
* Description: build a paginated list of customisation files
*/
global $jLang, $database, $mosConfig_absolute_path, $mainframe;
$mainframe->addCustomHeadTag("<script type='text/javascript' src='components/com_jtips/modules/Customisations/List.js'></script>");
$formData = array('title' => $jLang['_ADMIN_DASH_CUSTOMISATION_LIST'], 'editTask' => 'edit', 'module' => 'Customisations', 'icon' => 'customisations');
$currentDir = jTipsGetParam($_REQUEST, 'filter_order_Dir', 'asc');
if ($currentDir == 'asc') {
$dir = 'desc';
} else {
$dir = 'asc';
}
//The header row
$header = array('', 'File Path', 'Permissions', 'Owner');
$path = $mosConfig_absolute_path . '/components/com_jtips/custom/';
$data = $files = array();
if (file_exists($path)) {
$fileList = findAllFiles($path, $files);
$index = 0;
foreach ($fileList as $file) {
$owner = posix_getpwuid(fileowner($file));
$data[] = array(makeListLink(str_replace($path, '', $file), $index++), getFilePermissions($file), $owner['name']);
}
}
jTipsAdminDisplay::ListView($formData, $header, $data, null, '', null, $jLang['_ADMIN_CUSTOMISATIONS_INFO']);
//has the season select been used?
if ($season_id = jTipsGetParam($_REQUEST, 'season_id', false)) {
$params['season_id'] = array('type' => 'join', 'join_table' => '#__jtips_rounds', 'lhs_table' => '#__jtips_comments', 'lhs_key' => 'round_id', 'rhs_table' => '#__jtips_rounds', 'rhs_key' => 'id', 'supplement' => 'AND #__jtips_rounds.season_id = ' . $jComment->_db->Quote($season_id));
}
$jComments = forceArray($jComment->loadByParams($params, $limit, $limitstart));
$pageNav = new mosPageNav($jComment->getCount($params), $limitstart, $limit);
$data = array();
$i = 0;
foreach ($jComments as $comment) {
//get the comment poster details
$jTipsUser = new jTipsUser($database);
$jTipsUser->load($comment->user_id);
//Which round is it for
$jRound = new jRound($database);
$jRound->load($comment->round_id);
if (strlen($comment->comment) > 100) {
$suffix = '...';
} else {
$suffix = '';
}
$data[$comment->id] = array(makeListLink(substr(jTipsStripslashes($comment->comment), 0, 100) . $suffix, $i++), $jTipsUser->getUserField('name'), $jTipsUser->getUserField('username'), $comment->getSeasonName(), $jRound->round, TimeDate::toDisplayDateTime($comment->updated));
}
$jSeason = new jSeason($database);
$jSeasons = forceArray($jSeason->loadByParams());
$options = array(jTipsHTML::makeOption('', $jLang['_ADMIN_USERS_SELECT_SEASON']));
foreach ($jSeasons as $season) {
$options[] = jTipsHTML::makeOption($season->id, $season->name);
}
$filters = array($jLang['_ADMIN_SEASON_SELECT'] => jTipsHTML::selectList($options, 'season_id', "id='season_id' class='inputbox' onChange='this.form.submit();'", 'value', 'text', jTipsGetParam($_REQUEST, 'season_id', '')));
jTipsAdminDisplay::ListView($formData, $header, $data, $pageNav, 'list', $filters, $jLang['_ADMIN_COMMENTS_INFO']);
if ($find = jTipsGetParam($_REQUEST, 'lang_val', false) and !jTipsGetParam($_REQUEST, 'clear', false)) {
$theLanguage = array();
foreach ($jLang as $key => $val) {
if (preg_match('/' . $find . '/i', $val)) {
$theLanguage[$key] = $val;
}
}
} else {
$_REQUEST['lang_val'] = '';
$theLanguage = $jLang;
}
ksort($theLanguage);
$data = array();
$limitstart = jTipsGetParam($_REQUEST, 'limitstart', 0);
$limit = jTipsGetParam($_REQUEST, 'limit', 25);
if ($limit == 0) {
$limit = count($jLang);
}
$langKeys = array_keys($theLanguage);
$langDefs = array_values($theLanguage);
$index = 0;
for ($i = $limitstart; $i < $limitstart + $limit and $i < count($theLanguage); $i++) {
$data[$langKeys[$i]] = array(makeListLink($langKeys[$i], $index), htmlentities($langDefs[$i], ENT_QUOTES, 'UTF-8'));
$index++;
}
$filters = array('Search' => "<input type='text' name='lang_val' class='text_area' value='" . jTipsGetParam($_REQUEST, 'lang_val') . "' />");
$filters[] = " <input type='submit' name='search' value='Find' class='button' />";
$filters[] = " <input type='submit' name='clear' value='Reset' class='button' />";
$pageNav = new mosPageNav(count($theLanguage), $limitstart, $limit);
jTipsAdminDisplay::ListView($formData, $header, $data, $pageNav, '', $filters, $jLang['_ADMIN_LANGUAGE_LIST_INFO']);
