acl_check('administration', 'edit', 'users', $my->usertype, 'components', 'all')
| $acl->acl_check('administration', 'edit', 'users', $my->usertype, 'components', 'com_sef'))) {
mosRedirect('index2.php', _NOT_AUTH);
}
// Setup paths.
$sef_config_class = $GLOBALS['mosConfig_absolute_path']."/administrator/components/com_sef/sh404sef.class.php";
$sef_config_file = $GLOBALS['mosConfig_absolute_path']."/administrator/components/com_sef/config/config.sef.php";
// shumisha 2007-03-13 added URL and iso code caching
require_once($GLOBALS['mosConfig_absolute_path'].'/components/com_sef/shCache.php');
require_once($mainframe->getPath('admin_html'));
// Make sure class was loaded.
if (!class_exists('SEFConfig')) { // V 1.2.4.T was wrong variable name $SEFConfig_class instead of $sef_config_class
if (is_readable($sef_config_class)) require_once($sef_config_class);
else die(_COM_SEF_NOREAD."( $sef_config_class )ERROR UPLOADING FILE
';
exit();
}
else{
import_custom_CSV($userfile, $ViewModeId);
break;
}
}
case 'setStandardAdmin':
$sefConfig->shAdminInterfaceType = SH404SEF_STANDARD_ADMIN;
saveConfig($eraseCache);
break;
case 'setAdvancedAdmin':
$sefConfig->shAdminInterfaceType = SH404SEF_ADVANCED_ADMIN;
saveConfig($eraseCache);
break;
case 'updateSecStats':
updateSecStats();
break;
case 'importOpenSEF': {
$userfile = mosGetParam($_FILES, 'userfile', null);
if (!$userfile) {
echo 'ERROR UPLOADING FILE
';
exit();
}
else{
import_custom_CSV_OPEN_SEF($userfile, $ViewModeId);
break;
}
}
case 'import_meta': {
$userfile = mosGetParam($_FILES, 'userfile', null);
if (!$userfile) {
echo 'ERROR UPLOADING FILE
';
exit();
}
else{
import_custom_CSV_meta($userfile);
break;
}
}
case 'export': {
export_custom_CSV('sh404SEF_sef_urls.csv', $ViewModeId);
break;
}
case 'export_meta': {
export_custom_CSV('sh404SEF_meta.csv', 4);
break;
}
case 'dwnld': {
$returnData = 1;
$data = $sefConfig->saveConfig($returnData);
$trans_tbl = get_html_translation_table(HTML_ENTITIES);
$trans_tbl = array_flip($trans_tbl);
$data =strtr($data, $trans_tbl);
output_attachment('config.sef.php',$data);
exit();
}
default: {
include_once('components/com_sef/404SEF_cpanel.php');
displayCPanel();
break;
}
}
// V 1.2.4.q
function displayCPanel() {
global $database, $sefConfig;
$sql = 'SELECT count(*) FROM #__redirection WHERE ';
$database->setQuery($sql. "`dateadd` > '0000-00-00' and `newurl` = '' "); // 404
$Count404 = $database->loadResult();
$database->setQuery($sql. "`dateadd` > '0000-00-00' and `newurl` != '' " ); // custom
$customCount = $database->loadResult();
$database->setQuery($sql. "`dateadd` = '0000-00-00'"); // regular
$sefCount = $database->loadResult();
// calculate security stats
$default = empty($sefConfig->shSecLastUpdated) ? '- -' : '0';
$shSecStats['curMonth'] = empty($sefConfig->shSecCurMonth) ? $default : $sefConfig->shSecCurMonth;
if (empty($sefConfig->shSecLastUpdated))
$shSecStats['lastUpdated'] = $default;
else $shSecStats['lastUpdated'] = date('Y-m-d H:i:s', $sefConfig->shSecLastUpdated);
$monthStart = mktime(0,0,0,
empty($sefConfig->shSecLastUpdated) ? 0: intval(date('m', $sefConfig->shSecLastUpdated)),
1,
empty($sefConfig->shSecLastUpdated) ? 0 : intval(date('Y', $sefConfig->shSecLastUpdated)) );
$hours = $sefConfig->shSecLastUpdated == $monthStart ? 0.0001 : ($sefConfig->shSecLastUpdated - $monthStart)/3600;
$shSecStats['totalAttacks'] = empty($sefConfig->shSecTotalAttacks) ? $default : $sefConfig->shSecTotalAttacks;
$shSecStats['totalAttacksHrs'] = $shSecStats['totalAttacks']/$hours;
$shSecStats['totalConfigVars'] = empty($sefConfig->shSecTotalConfigVars) ? $default : $sefConfig->shSecTotalConfigVars;
$shSecStats['totalConfigVarsHrs'] = $shSecStats['totalConfigVars']/$hours;
$shSecStats['totalBase64'] = empty($sefConfig->shSecTotalBase64) ? $default : $sefConfig->shSecTotalBase64;
$shSecStats['totalBase64Hrs'] = $shSecStats['totalBase64']/$hours;
$shSecStats['totalScripts'] = empty($sefConfig->shSecTotalScripts) ? $default : $sefConfig->shSecTotalScripts;
$shSecStats['totalScriptsHrs'] = $shSecStats['totalScripts']/$hours;
$shSecStats['totalStandardVars'] = empty($sefConfig->shSecTotalStandardVars) ? $default : $sefConfig->shSecTotalStandardVars;
$shSecStats['totalStandardVarsHrs'] = $shSecStats['totalStandardVars']/$hours;
$shSecStats['totalImgTxtCmd'] = empty($sefConfig->shSecTotalImgTxtCmd) ? $default : $sefConfig->shSecTotalImgTxtCmd;
$shSecStats['totalImgTxtCmdHrs'] = $shSecStats['totalImgTxtCmd']/$hours;
$shSecStats['totalIPDenied'] = empty($sefConfig->shSecTotalIPDenied) ? $default : $sefConfig->shSecTotalIPDenied;
$shSecStats['totalIPDeniedHrs'] = $shSecStats['totalIPDenied']/$hours;
$shSecStats['totalUserAgentDenied'] = empty($sefConfig->shSecTotalUserAgentDenied) ? $default : $sefConfig->shSecTotalUserAgentDenied;
$shSecStats['totalUserAgentDeniedHrs'] = $shSecStats['totalUserAgentDenied']/$hours;
$shSecStats['totalFlooding'] = empty($sefConfig->shSecTotalFlooding) ? $default : $sefConfig->shSecTotalFlooding;
$shSecStats['totalFloodingHrs'] = $shSecStats['totalFlooding']/$hours;
$shSecStats['totalPHP'] = empty($sefConfig->shSecTotalPHP) ? $default : $sefConfig->shSecTotalPHP;
$shSecStats['totalPHPHrs'] = $shSecStats['totalPHP']/$hours;
$shSecStats['totalPHPUserClicked'] = empty($sefConfig->shSecTotalPHPUserClicked) ? $default : $sefConfig->shSecTotalPHPUserClicked;
$shSecStats['totalPHPUserClickedHrs'] = $shSecStats['totalPHPUserClicked']/$hours;
if (!empty($sefConfig->shSecTotalAttacks)) {
$shSecStats['totalConfigVarsPct'] = round($sefConfig->shSecTotalConfigVars/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalBase64Pct'] = round($sefConfig->shSecTotalBase64/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalScriptsPct'] = round($sefConfig->shSecTotalScripts/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalStandardVarsPct'] = round($sefConfig->shSecTotalStandardVars/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalImgTxtCmdPct'] = round($sefConfig->shSecTotalImgTxtCmd/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalIPDeniedPct'] = round($sefConfig->shSecTotalIPDenied/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalUserAgentDeniedPct'] = round($sefConfig->shSecTotalUserAgentDenied/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalFloodingPct'] = round($sefConfig->shSecTotalFlooding/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalPHPPct'] = round($sefConfig->shSecTotalPHP/$sefConfig->shSecTotalAttacks*100,1);
$shSecStats['totalPHPUserClickedPct'] = round($sefConfig->shSecTotalPHPUserClicked/$sefConfig->shSecTotalAttacks*100,1);
} else {
$shSecStats['totalConfigVarsPct'] = 0;
$shSecStats['totalBase64Pct'] = 0;
$shSecStats['totalScriptsPct'] = 0;
$shSecStats['totalStandardVarsPct'] = 0;
$shSecStats['totalImgTxtCmdPct'] = 0;
$shSecStats['totalIPDeniedPct'] = 0;
$shSecStats['totalUserAgentDeniedPct'] = 0;
$shSecStats['totalFloodingPct'] = 0;
$shSecStats['totalPHPPct'] = 0;
$shSecStats['totalPHPUserClickedPct'] = 0;
}
displayCPanelHTML( $sefCount, $Count404, $customCount, $shSecStats);
}
/**
* List the records
* @param string The current GET/POST option
* @param int The mode of view 0=
*/
function viewSEF($option, $ViewModeId = 0)
{
global $database, $mainframe, $mosConfig_list_limit;
$catid = $mainframe->getUserStateFromRequest( "catid{$option}", 'catid', 0 );
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 );
$ViewModeId = $mainframe->getUserStateFromRequest( "viewmode{$option}", 'viewmode', 0 );
$SortById = $mainframe->getUserStateFromRequest( "SortBy{$option}", 'sortby', 0 );
// V 1.2.4.q added search URL feature, taken from Joomla content page
//$search = $mainframe->getUserStateFromRequest( "search{$option}{$sectionid}", 'search', '' );
$search = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
if (get_magic_quotes_gpc()) {
$search = stripslashes( $search );
}
//echo 'Recherche de : '.$search.'";
// print_r($undefined_components);
// print_r($lists);
// echo " ";
HTML_sef::configuration($lists, $txt404);
}
function shSetArrayParam($value, &$param) {
if (!empty($value)) {
$param = explode("\n", $value);
foreach ($param as $k=>$v) {
$param[$k] = trim($v);
}
} else
$param = array();
if (!empty($param))
$param = array_filter($param);
}
function advancedConfig($key,$value){
GLOBAL $sefConfig;
$quoteGPC = get_magic_quotes_gpc();
if ((strpos($key,"com_")) !== false) {
// V 1.2.4.m
$key = str_replace('com_','',$key);
$param = explode('___',$key);
switch ($param[1]) {
case 'manageURL' :
switch ($value) {
case 1 :
array_push($sefConfig->nocache,$param[0]);
break;
case 2 :
array_push($sefConfig->skip,$param[0]);
break;
}
break;
case 'translateURL':
if ($value == 1)
array_push($sefConfig->notTranslateURLList,$param[0]);
break;
case 'insertIsoCode':
if ($value == 1)
array_push($sefConfig->notInsertIsoCodeList,$param[0]);
break;
case 'shDoNotOverrideOwnSef':
if ($value == 1)
array_push($sefConfig->shDoNotOverrideOwnSef,$param[0]);
break;
case 'defaultComponentString':
$cleanedUpValue = empty($value) ? '': titleToLocation($value);
$cleanedUpValue = trim( $cleanedUpValue, $sefConfig->friendlytrim);
$sefConfig->defaultComponentStringList[$param[0]] = $cleanedUpValue;
break;
case 'defaultComponentItemid':
$cleanedUpValue = empty($value) ? '': intval($value);
$sefConfig->defaultComponentItemidList[$param[0]] = $cleanedUpValue;
break;
}
} else {
switch ($key){
case 'shSecOnlyNumVars':
shSetArrayParam($value, $sefConfig->shSecOnlyNumVars);
break;
case 'shSecAlphaNumVars':
shSetArrayParam($value, $sefConfig->shSecAlphaNumVars);
break;
case 'shSecNoProtocolVars':
shSetArrayParam($value, $sefConfig->shSecNoProtocolVars);
break;
}
if (preg_match('/languages_([a-zA-Z]*)_translateURL/U', $key, $matches)) {
$sefConfig->shLangTranslateList[$matches[1]] = $value;
}
if (preg_match('/languages_([a-zA-Z]*)_insertCode/U', $key, $matches)) {
$sefConfig->shLangInsertCodeList[$matches[1]] = $value;
}
if (preg_match('/languages_([a-zA-Z]*)_pageText/U', $key, $matches)) {
$sefConfig->pageTexts[$matches[1]] = $value;
}
}
}
function saveConfig($eraseCache) {
global $database,$sefConfig,$sef_config_file;
//set skip and nocache arrays, unless POST is empty, meaning this is first attempt to save config
if (!empty($_POST)) {
$sefConfig->skip = array();
$sefConfig->nocache = array();
$sefConfig->notTranslateURLList = array();
$sefConfig->notInsertIsoCodeList = array();
$sefConfig->shDoNotOverrideOwnSef = array();
$sefConfig->shSecOnlyNumVars = array();
$sefConfig->shSecAlphaNumVars = array();
$sefConfig->shSecNoProtocolVars = array();
$sefConfig->ipWhiteList = array();
$sefConfig->ipBlackList = array();
$sefConfig->uAgentWhiteList = array();
$sefConfig->uAgentBlackList = array();
$sefConfig->shLangTranslateList = array();
$sefConfig->shLangInsertCodeList = array();
$sefConfig->defaultComponentStringList = array();
$sefConfig->defaultComponentItemidList = array();
}
if (empty($_POST['debugToLogFile'])) {
$sefConfig->debugStartedAt = 0;
} else {
$sefConfig->debugStartedAt = empty($sefConfig->debugStartedAt) ? time() : $sefConfig->debugStartedAt;
}
if (!empty($_POST)) {
foreach($_POST as $key => $value) {
$sefConfig->set($key, $value);
advancedConfig($key, $value);
}
}
$shIntroText = empty($_POST) ? '' : $_POST['introtext'];
$sql='SELECT id FROM #__content WHERE `title`="404"';
$database->setQuery( $sql );
if ($id = $database->loadResult()){
$sql = 'UPDATE #__content SET introtext="'.$shIntroText.'", modified ="'.date("Y-m-d H:i:s").'" WHERE `id` = "'.$id.'";';
}else{
$sql='SELECT MAX(id) FROM #__content';
$database->setQuery( $sql );
if ($max = $database->loadResult()){
$max++;
$sql = 'INSERT INTO #__content VALUES( "'.$max.'", "404", "404", "'.$shIntroText.'", "", "1", "0", "0", "0", "2004-11-11 12:44:38", "62", "", "'.date("Y-m-d H:i:s").'", "0", "62", "2004-11-11 12:45:09", "2004-10-17 00:00:00", "0000-00-00 00:00:00", "", "", "menu_image=-1\nitem_title=0\npageclass_sfx=\nback_button=\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0", "1", "0", "0", "", "", "0", "750");';
}
}
$database->setQuery( $sql );
if (!$database->query()) {
echo "\n";
}
$config_written = $sefConfig->saveConfig(0);
if($config_written != 0) {
// V 1.2.4.t 20/08/2007 16:14:37 added another confirm from user
if ($eraseCache)
mosRedirect( $GLOBALS['mosConfig_live_site']
.'/administrator/index2.php?option=com_sef&task=purge&viewmode=0&confirmed=0');
else mosRedirect( "index2.php?option=com_sef", _COM_SEF_CONFIG_UPDATED );
}else mosRedirect( "index2.php?option=com_sef", _COM_SEF_WRITE_ERROR);
}
function purge($option, $ViewModeId=0 ) {
GLOBAL $database, $mainframe,
// shumisha 2007-03-14 URL caching : we must clear URL cache as well
$mosConfig_absolute_path;
$ViewModeId = $mainframe->getUserStateFromRequest( "viewmode{$option}", 'viewmode', 0 );
$SortById = $mainframe->getUserStateFromRequest( "SortBy{$option}", 'sortby', 0 );
$confirmed = mosGetParam( $_REQUEST, 'confirmed', '' ); // mambo checks default value type, must be '' instead of 0
switch ($ViewModeId) {
case '1': // 404
$where = "`dateadd` > '0000-00-00' and `newurl` = '' ";
break;
case '2': // custom
$where = "`dateadd` > '0000-00-00' and `newurl` != '' ";
break;
default: // automatic
$where = "`dateadd` = '0000-00-00'";
break;
}
if ( !empty($confirmed)){
$query = "DELETE FROM #__redirection WHERE ".$where;
// shumisha 2007-03-14 URL caching : we must clear URL cache as well
if (file_exists($mosConfig_absolute_path.'/components/com_sef/cache/shCacheContent.php'))
unlink($mosConfig_absolute_path.'/components/com_sef/cache/shCacheContent.php');
// shumisha end of addition
$database->setQuery( $query );
if (!$database->query()) {
echo "\n";
}else{
$message = _COM_SEF_SUCCESSPURGE;
}
mosRedirect('index2.php?option=com_sef', $message);
}else{
// get the total number of records
$query = "SELECT count(*) FROM #__redirection WHERE ".$where;
$database->setQuery( $query );
$total = $database->loadResult();
if (!$database->query()) {
echo "\n";
}
switch ($total) {
case '0';
$message = _COM_SEF_NORECORDS;
mosRedirect('index2.php?option=com_sef', $message);
break;
case '1';
$message = _COM_SEF_WARNDELETE.$total._COM_SEF_RECORD;
break;
default:
$message = _COM_SEF_WARNDELETE.$total._COM_SEF_RECORDS;
}
HTML_sef::purge($option, $message, $confirmed);
}
}
function purgeMeta($option ) { // V 1.2.4.s
GLOBAL $database, $mainframe;
$confirmed = mosGetParam( $_REQUEST, 'confirmed', 0 );
if ( !empty($confirmed)){
$query = "DELETE FROM #__sh404SEF_meta WHERE 1";
$database->setQuery( $query );
if (!$database->query()) {
echo "\n";
}else{
$message = _COM_SEF_META_SUCCESS_PURGE;
}
mosRedirect('index2.php?option=com_sef', $message);
}else{
// get the total number of records
$query = "SELECT count(*) FROM #__sh404SEF_meta WHERE 1";
$database->setQuery( $query );
$total = $database->loadResult();
if (!$database->query()) {
echo "\n";
}
switch ($total) {
case '0';
$message = _COM_SEF_NORECORDS;
mosRedirect('index2.php?option=com_sef', $message);
break;
case '1';
$message = _COM_SEF_WARNDELETE.$total._COM_SEF_RECORD;
break;
default:
$message = _COM_SEF_WARNDELETE.$total._COM_SEF_RECORDS;
}
HTML_sef::purgeMeta($option, $message, $confirmed);
}
}
function backup_custom(){
GLOBAL $database;
$SQL = array();
$table = $GLOBALS['mosConfig_dbprefix']."redirection";
$query ="SELECT * FROM `$table` WHERE `dateadd` > '0000-00-00' and `newurl` != '' ";
$database->setQuery( $query );
if ($rows = $database->loadRowList()) {
foreach ($rows as $row) {
$SQL[] = "INSERT INTO `$table` VALUES('','".$row[1]."','".$row[2]."','".$row[3]."','".$row[4]."');\n";
}
}else{
die(_COM_SEF_NOACCESS.$table);
}
return $SQL;
}
function shNonEmpty($string) { // V 1.2.4.s
if (empty($string))
return ' ';
else return $string;
}
function shUnEmpty($string) { // V 1.2.4.s
if ($string == ' ')
return '';
else return $string;
}
function backup_custom_CSV( $which = 0){ // which = 0:all, 2 = custom redirect, 1 = 404)
GLOBAL $database;
$CSV = array();
switch ($which) {
case 1: // 404
$where = "WHERE `dateadd` > '0000-00-00' and `newurl` == '' ";
break; // Custom
case 2:
$where = "WHERE `dateadd` > '0000-00-00' and `newurl` != '' ";
break;
default: // default
$where = '';
break;
}
$CSV[] = "\"id\",\"Count\",\"Rank\",\"SEF URL\",\"non-SEF URL\",\"Date added\"\n"; // V 1.2.4.s
$query ='SELECT * FROM #__redirection '.$where;
$database->setQuery( $query );
$rows = $database->loadRowList();
if (!empty($rows)) {
foreach ($rows as $row) {
$CSV[] = "\"$row[0]\",\"$row[1]\",\"$row[2]\",\"$row[3]\",\"$row[4]\",\"$row[5]\"\n"; // V 1.2.4.s
}
}else{
mosRedirect('index2.php?option=com_sef',_COM_SEF_NOACCESS);
}
return $CSV;
}
function output_attachment($filename,&$data){
if (!headers_sent()) {
header ('Expires: 0');
header ('Last-Modified: '.gmdate ('D, d M Y H:i:s', time()) . ' GMT');
header ('Pragma: public');
header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Accept-Ranges: bytes');
header ('Content-Length: ' . strlen($data));
header ('Content-Type: Application/octet-stream');
header ('Content-Disposition: attachment; filename="' . $filename . '"');
header ('Connection: close');
ob_end_clean(); //flush the mambo stuff from the ouput buffer
print $data; // and send the sql
die();
}else{
mosRedirect('index2.php?option=com_sef',_COM_SEF_FATAL_ERROR_HEADERS);
}
}
function export_custom($filename){
GLOBAL $database;
$sql_data = backup_custom();
$sql_data = implode("\r", $sql_data);
if (!headers_sent()) {
while (ob_get_level() > 0) {
ob_end_clean(); //flush the mambo stuff from the ouput buffer
}
// Determine Browser
if (ereg( 'MSIE ([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='IE';
} elseif (ereg( 'Opera ([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='OPERA';
} elseif (ereg( 'Mozilla/([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='MOZILLA';
} else {
$BROWSER_VER=0;
$BROWSER_AGENT='OTHER';
}
ob_start();
header ('Expires: 0');
header ('Last-Modified: '.gmdate ('D, d M Y H:i:s', time()) . ' GMT');
header ('Pragma: public');
header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Accept-Ranges: bytes');
header ('Content-Length: ' . strlen($sql_data));
header ('Content-Type: Application/octet-stream');
header ('Content-Disposition: attachment; filename="' . $filename . '"');
header ('Connection: close');
/*
if ($BROWSER_AGENT == 'IE') {
header('Content-Disposition: inline; filename="'.$filename.'";');
header('Pragma: cache');
header('Cache-Control: public, must-revalidate, max-age=0');
header('Connection: close');
header("Expires: ".gmdate("D, d M Y H:i:s", time()+60)." GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s", time())." GMT");
}else{
$header="Content-Disposition: attachment; filename=".$filename.";";
header($header );
header("Content-Length: ".strlen($sql_data));
}
*/
echo($sql_data);
ob_end_flush();
die();
}else{
echo "Error! Not Good!";
mosRedirect('index2.php?option=com_sef', COM_SEF_FATAL_ERROR_HEADERS);
}
}
function import_custom($userfile){
GLOBAL $database;
$uploaddir = $GLOBALS['mosConfig_absolute_path'].'/media/';
$uploadfile = $uploaddir . basename($userfile['name']);
if (move_uploaded_file($userfile['tmp_name'], $uploadfile)) {
echo ''._COM_SEF_UPLOAD_OK.'
';
$results = true;
$lines = file($uploadfile);
// echo "";
// print_r($lines);
// echo " ";
foreach ($lines as $line){
$line = trim($line);
if( substr($line,0,40) == "INSERT INTO `".$GLOBALS['mosConfig_dbprefix']."redirection` VALUES('',"){
$database->setQuery( $line );
if (! $database->query()){
echo ""._COM_SEF_ERROR_IMPORT."
$line ";
$results = false;
}
}else{
mosRedirect('index2.php?option=com_sef',_COM_SEF_INVALID_SQL.substr($line,0,40));
}
}
unlink($uploadfile) OR mosRedirect('index2.php?option=com_sef',_COM_SEF_NO_UNLINK);
if ($results) echo ''._COM_SEF_IMPORT_OK.'
';
?>
"._COM_SEF_WRITE_FAILED."";
$results = false;
}
return $result;
}
function export_custom_CSV($filename, $which = 0){ // which = 0:all, 1 = custom redirect, 2 = 404
// which = 4 V 1.2.4.
GLOBAL $database;
$csv_data = ($which == 4 )? backup_custom_CSV_meta() : backup_custom_CSV( $which); // 1.2.4.t bug #166
$csv_data = implode("\r", $csv_data);
if (!headers_sent()) {
while (ob_get_level() > 0) {
ob_end_clean(); //flush the mambo stuff from the ouput buffer
}
// Determine Browser
if (ereg( 'MSIE ([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='IE';
} elseif (ereg( 'Opera ([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='OPERA';
} elseif (ereg( 'Mozilla/([0-9].[0-9]{1,2})',$_SERVER["HTTP_USER_AGENT"],$log_version)) {
$BROWSER_VER=$log_version[1];
$BROWSER_AGENT='MOZILLA';
} else {
$BROWSER_VER=0;
$BROWSER_AGENT='OTHER';
}
ob_start();
header ('Expires: 0');
header ('Last-Modified: '.gmdate ('D, d M Y H:i:s', time()) . ' GMT');
header ('Pragma: public');
header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Accept-Ranges: bytes');
header ('Content-Length: ' . strlen($csv_data));
header ('Content-Type: Application/octet-stream');
header ('Content-Disposition: attachment; filename="' . $filename . '"');
header ('Connection: close');
echo($csv_data);
ob_end_flush();
die();
}else{
echo "Error! Not Good!";
mosRedirect('index2.php?option=com_sef',_COM_SEF_FATAL_ERROR_HEADERS);
}
}
function import_custom_CSV($userfile, $ViewModeId=0) {
GLOBAL $database;
$uploaddir = $GLOBALS['mosConfig_absolute_path'].'/media/';
$uploadfile = $uploaddir . basename($userfile['name']);
if (move_uploaded_file($userfile['tmp_name'], $uploadfile)) {
echo ''._COM_SEF_UPLOAD_OK.'
';
$results = true;
$lines = file($uploadfile);
array_shift($lines); // remove header line
foreach ($lines as $line){
$line = trim($line);
$line = trim($line, '"');
$lineBits = explode('","', $line);
// V 1.2.4.s : previous version handling
switch (count($lineBits)) {
case 6 :
$q = 'INSERT INTO `#__redirection` VALUES(\'\',"'.$lineBits[1].'", "'.$lineBits[2]
.'", "'.$lineBits[3].'", "'.$lineBits[4].'", "'.$lineBits[5].'")';
break;
case 5 : // prior to version 1.2.4.q, no rank field : bug fixed in V t
$q = 'INSERT INTO `#__redirection` VALUES(\'\',"'.$lineBits[1].'", \'10\', "'.$lineBits[2].'", "'
.$lineBits[3].'", "'.$lineBits[4].'" )';
break;
}
$database->setQuery( $q );
if (! $database->query()){
echo $database->stderr();
echo ""._COM_SEF_ERROR_IMPORT."
$line ";
$results = false;
}
}
unlink($uploadfile) OR mosRedirect('index2.php?option=com_sef',_COM_SEF_NO_UNLINK);
if ($results) echo ''._COM_SEF_IMPORT_OK.'
';
?>
"._COM_SEF_WRITE_FAILED."";
$results = false;
}
return $results;
}
function import_custom_CSV_OPEN_SEF($userfile) { // V 1.2.4.t
GLOBAL $database;
$uploaddir = $GLOBALS['mosConfig_absolute_path'].'/media/';
$uploadfile = $uploaddir . basename($userfile['name']);
if (move_uploaded_file($userfile['tmp_name'], $uploadfile)) {
echo ''._COM_SEF_UPLOAD_OK.'
';
$results = true;
$fileContent = file($uploadfile);
for ($i=1; $i<6;$i++) // remove header
array_shift($fileContent);
$lines = explode('" "', $fileContent[0]); // only way I could find to split lines
$shCount = 0;
foreach ($lines as $line){
$line = trim($line);
$lineBits = explode(';', $line);
$sefUrl = ltrim(trim($lineBits[2],'"'), '/');
$nonSef = trim($lineBits[3], '"');
if ($sefUrl != 'NULL' && $nonSsef != 'NULL') { // don't import records without SEF or non-SEF URL
$dateAdd = date('Y-m-d');
if (!preg_match( '/(&|\?)lang=[a-zA-Z]{2,3}/iU', $nonSef)) { // no lang string, let's add default
$shTemp = explode( '_', $GLOBALS['mosConfig_locale']);
$shLangTemp = $shTemp[0] ? $shTemp[0] : 'en';
$nonSef .= '&lang='.$shLangTemp;
}
$nonSef = shSortUrl($nonSef); // and sort URl so that we always find it
// Link priority works opposed to rank. The highest LP wins, whereas the lowest ranks win
// not so simple though, the OSEF system may have several links with same LP, whereas I don't want to have that
// So let's do rank = 1000-LP. If there is one link with LP =99, it will be used, as it will have lowest rank;
// if there are several, the first one will be used (just as in OpenSEF), but user is still able
// to select the URL he wants touse, as doing so in sh404SEF cPanel will set rank=0
$q = 'INSERT INTO `#__redirection` VALUES(\'\',"0", "'.(1000-(int)$lineBits[17])
.'", "'.$sefUrl.'", "'.$nonSef.'", "'.$dateAdd.'")';
$database->setQuery( $q );
if (! $database->query()){
echo $database->stderr();
echo ""._COM_SEF_ERROR_IMPORT."
$line ";
$results = false;
}
$shCount++;
}
}
unlink($uploadfile) OR mosRedirect('index2.php?option=com_sef',_COM_SEF_NO_UNLINK);
if ($results) echo ''._COM_SEF_IMPORT_OK.' ('.$shCount.')
';
?>
"._COM_SEF_WRITE_FAILED."";
$results = false;
}
return $results;
}
function import_custom_CSV_meta($userfile) { // V 1.2.4.s
GLOBAL $database;
$uploaddir = $GLOBALS['mosConfig_absolute_path'].'/media/';
$uploadfile = $uploaddir . basename($userfile['name']);
if (move_uploaded_file($userfile['tmp_name'], $uploadfile)) {
echo ''._COM_SEF_UPLOAD_OK.'
';
$results = true;
$lines = file($uploadfile);
array_shift($lines); // remove header line
foreach ($lines as $line){
$line = trim($line);
$line = trim($line, '"');
$lineBits = explode('","', $line);
//var_dump($lineBits);
$q = 'INSERT INTO `#__sh404SEF_meta` VALUES(\'\',"'.shUnEmpty($lineBits[1]).'", "'.shUnEmpty($lineBits[2]).'", "'.shUnEmpty($lineBits[3]).'", "'.shUnEmpty($lineBits[4]).'", "'.shUnEmpty($lineBits[5]).'", "'.shUnEmpty($lineBits[6]).'")';
$database->setQuery( $q );
if (! $database->query()){
echo ""._COM_SEF_ERROR_IMPORT."
$line ";
$results = false;
}
}
unlink($uploadfile) OR mosRedirect('index2.php?option=com_sef',_COM_SEF_NO_UNLINK);
if ($results) echo ''._COM_SEF_IMPORT_META_OK.'
';
?>
"._COM_SEF_WRITE_FAILED."";
$results = false;
}
return $results;
}
function backup_custom_CSV_meta(){ // 1.2.4.s
GLOBAL $database;
$CSV = array();
$CSV[] = "\"id\",\"newurl\",\"metadesc\",\"metakey\",\"metatitle\",\"metalang\",\"metarobots\" \n"; // V 1.2.4.s
$query ='SELECT * FROM #__sh404SEF_meta WHERE 1';
$database->setQuery( $query );
$rows = $database->loadRowList();
if (!empty($rows)) {
foreach ($rows as $row) {
$CSV[] = "\"".shNonEmpty($row[0])."\",\"".shNonEmpty($row[1])."\",\"".shNonEmpty($row[2])."\",\"".shNonEmpty($row[3])."\",\"".shNonEmpty($row[4])."\",\"".shNonEmpty($row[5])."\",\"".shNonEmpty($row[6])."\" \n"; // V 1.2.4.s
}
}else{
mosRedirect('index2.php?option=com_sef',_COM_SEF_NOACCESS);
}
return $CSV;
}
function shResetSecStats() {
global $sefConfig;
$sefConfig->shSecCurMonth = '';
$sefConfig->shSecLastUpdated = '';
$sefConfig->shSecTotalAttacks = 0;
$sefConfig->shSecTotalConfigVars = 0;
$sefConfig->shSecTotalBase64 = 0;
$sefConfig->shSecTotalScripts = 0;
$sefConfig->shSecTotalStandardVars = 0;
$sefConfig->shSecTotalImgTxtCmd = 0;
$sefConfig->shSecTotalIPDenied = 0;
$sefConfig->shSecTotalUserAgentDenied = 0;
$sefConfig->shSecTotalFlooding = 0;
$sefConfig->shSecTotalPHP = 0;
$sefConfig->shSecTotalPHPUserClicked = 0;
}
function shDecodeSecLogLine( $line) {
global $sefConfig;
if (preg_match( '/[0-9]{2}\-[0-9]{2}\-[0-9]{2}/', $line)) { // this is not header or comment line
$sefConfig->shSecTotalAttacks++;
$bits = explode("\t", $line);
switch (substr($bits[2],0, 15)) {
case 'Flooding':
$sefConfig->shSecTotalFlooding++;
break;
case 'Caught by Honey':
$sefConfig->shSecTotalPHP++;
break;
case 'Honey Pot but u':
$sefConfig->shSecTotalPHPUserClicked++;
break;
case 'Var not numeric':
case 'Var not alpha-n':
case 'Var contains ou':
$sefConfig->shSecTotalStandardVars++;
break;
case 'Image file name':
$sefConfig->shSecTotalImgTxtCmd++;
break;
case '