set up first';
die();
}
// include file functions and classes
include_once( $mosConfig_absolute_path . '/includes/functions.visohotlink.php');
// include HTML output class
include_once( $mosConfig_absolute_path . '/admin.visohotlink.html.php');
// Include language file
if (file_exists($mosConfig_absolute_path . '/language/' . $mosConfig_lang . '.php')) {
include($mosConfig_absolute_path . '/language/' . $mosConfig_lang . '.php');
} else {
include($mosConfig_absolute_path . '/language/english.php');
}
// get user identifying parameters
$user = mosGetParam( $_REQUEST, 'user', '' );
$pass = mosGetParam( $_REQUEST, 'pass', '' );
$msg = mosGetParam( $_REQUEST, 'mosmsg', '' );
$true = true;
// if user is already known, continue
if (/* ( $_SESSION['userok'] == '1') && ($sinceLast < $maxSessionTime) */$true) {
$database = new database($host, $login, $password, $base, $prefix_table);
$mainframe = new mosMainFrame ( $database, '', '.' );
// Look for links id parameters
$cid = mosGetParam( $_REQUEST, 'cid', array(0) );
if (!is_array( $cid )) {
$cid = array(0);
}
// look for some parameters
$task = mosGetParam( $_REQUEST, 'task', '' );
$id = mosGetParam( $_REQUEST, 'id', '0' );
//show page header
HTML_visohotlink::pageHeader($msg);
switch ($task) {
case 'showLinks':
showLinks();
break;
case 'editLink':
editLink($cid[0]);
break;
case 'editLinkA':
editLink($id);
break;
case 'saveLink':
saveLink();
break;
case 'removeLink':
removeLink($cid);
break;
case 'config':
config();
break;
case 'saveConfig':
saveConfig();
break;
case 'deconnect':
deconnect();
break;
case 'massAction':
massAction($cid);
break;
case 'massActionSave':
massActionSave($cid);
break;
case 'showSites':
showSites();
break;
case 'editSite':
editSite($cid[0]);
break;
case 'editSiteA':
editSite($id);
break;
case 'saveSite':
saveSite();
break;
case 'removeSite':
removeSite($cid);
break;
case 'showEngines':
showEngines();
break;
case 'showKeywords':
showKeywords();
break;
case 'showReferers':
showReferers();
break;
case 'showSitesRef':
showSitesRef();
break;
case 'showEnginesRef':
showEnginesRef();
break;
case 'showKeywordsRef':
showKeywordsRef();
break;
default:
showLinks();
break;
}
// show page end
HTML_visohotlink::pageEnd();
// in case of identifying parameters are correct, set the user as known in the session var
} elseif (($user == $visohotlinkUser) && ($pass == $visohotlinkPass)) {
$_SESSION['userok'] = '1';
mosRedirect( $mosConfig_live_site.'/index.php', '');
//in case of identifying parameters are wrong, come back to the form with an error message
} elseif ((!empty($user)) || (!empty($pass))) {
HTML_visohotlink::pageHeaderConnect(_VH_WRONG_IDENTIFY);
HTML_visohotlink::connect();
HTML_visohotlink::pageEnd();
//in case of identifying parameters are empty, go to the form with a message
} else {
HTML_visohotlink::pageHeaderConnect(_VH_IDENTIFY);
HTML_visohotlink::connect();
HTML_visohotlink::pageEnd();
}
// Query the MySQL Database with a lot of parameters in order to have a list of hotlinks
function showLinks () {
global $database, $mainframe, $entries_per_page;
// Look for parameters
$limit = mosGetParam( $_REQUEST, 'limit', $entries_per_page );
$limitstart = mosGetParam( $_REQUEST, 'limitstart', '0' );
$group_by_file = mosGetParam( $_REQUEST, 'group_by_file', '' );
$group_by_host = mosGetParam( $_REQUEST, 'group_by_host', '' );
$group_by_site_referer = mosGetParam( $_REQUEST, 'group_by_site_referer', '' );
$group_by_referer = mosGetParam( $_REQUEST, 'group_by_referer', '' );
$group_by_answer_type = mosGetParam( $_REQUEST, 'group_by_answer_type', '' );
$group_by_link_type = mosGetParam( $_REQUEST, 'group_by_link_type', '' );
$group_by_mime_type = mosGetParam( $_REQUEST, 'group_by_mime_type', '' );
$group_by_referer_type = mosGetParam( $_REQUEST, 'group_by_referer_type', '' );
$sort_by = mosGetParam( $_REQUEST, 'sort_by', 'date' );
$ascdesc = mosGetParam( $_REQUEST, 'ascdesc', 'DESC' );
// For each parameter, build the corresponding query part
$query_group_by_file = '';
if ($group_by_file!='') {
$query_group_by_file = "\n AND a.uri='$group_by_file '";
}
$query_group_by_host = '';
if ($group_by_host!='') {
$query_group_by_host = "\n AND a.host='$group_by_host'";
}
$query_group_by_site_referer = '';
if ($group_by_site_referer!='') {
$query_group_by_site_referer = "\n AND b.url='$group_by_site_referer'";
}
$query_group_by_referer = '';
if ($group_by_referer!='') {
$query_group_by_referer = "\n AND c.referer='$group_by_referer'";
}
$query_group_by_answer_type = '';
if ($group_by_answer_type!='') {
$query_group_by_answer_type = "\n AND a.answer_type='$group_by_answer_type'";
}
$query_group_by_link_type = '';
if ($group_by_link_type!='') {
$query_group_by_link_type = "\n AND a.link_type='$group_by_link_type'";
}
$query_group_by_mime_type = '';
if ($group_by_mime_type!='') {
$query_group_by_mime_type = "\n AND a.mime_type='$group_by_mime_type'";
}
$query_group_by_referer_type = '';
if ($group_by_referer_type!='') {
if ($group_by_referer_type=='normal') {
$query_group_by_referer_type = "\n AND b.referer_type='$group_by_referer_type' OR b.referer_type=''";
}
else {
$query_group_by_referer_type = "\n AND b.referer_type='$group_by_referer_type'";
}
}
switch ($sort_by) {
case 'site_referer':
$query_sort_by = "\n ORDER BY b.url ".$ascdesc;
break;
case 'host':
$query_sort_by = "\n ORDER BY a.host ".$ascdesc;
break;
case 'file':
$query_sort_by = "\n ORDER BY a.uri ".$ascdesc;
break;
case 'mime_type':
$query_sort_by = "\n ORDER BY a.mime_type ".$ascdesc;
break;
case 'referer_type':
$query_sort_by = "\n ORDER BY b.referer_type ".$ascdesc;
break;
case 'downloaded':
$query_sort_by = "\n ORDER BY a.downloaded ".$ascdesc;
break;
case 'size':
$query_sort_by = "\n ORDER BY a.size ".$ascdesc;
break;
case 'bandwidth':
$query_sort_by = "\n ORDER BY (a.size * a.downloaded) ".$ascdesc;
break;
case 'date':
$query_sort_by = "\n ORDER BY a.date ".$ascdesc;
break;
default;
$query_sort_by = '';
break;
}
// Compute global stats
$querycount = "SELECT COUNT(DISTINCT a.id) AS count, SUM(a.downloaded) AS downloaded, SUM(a.size*a.downloaded) AS bandwidth"
. "\n FROM #__visohotlink_link AS a"
. "\n INNER JOIN #__visohotlink_referer AS c"
. "\n ON c.id=a.id_referer"
. "\n INNER JOIN #__visohotlink_site AS b"
. "\n ON b.id=c.id_site"
. "\n WHERE b.id=b.id"
. $query_group_by_file
. $query_group_by_host
. $query_group_by_site_referer
. $query_group_by_answer_type
. $query_group_by_link_type
. $query_group_by_mime_type
. $query_group_by_referer_type
. $query_group_by_referer
;
// Set the query and load results
$database->setQuery( $querycount );
$result = $database->loadObjectList();
$total = $result[0]->count;
if ($result[0]->downloaded!=0) $stats->downloaded = $result[0]->downloaded; else $stats->downloaded = 0;
if ($result[0]->bandwidth!=0) $stats->bandwidth = $result[0]->bandwidth; else $stats->bandwidth = 0;
// An now is the query
$query = "SELECT a.id AS id, a.uri AS uri, a.size AS size, a.downloaded AS downloaded, a.host AS host, b.url AS site_referer, c.referer AS referer, b.referer_type AS referer_type"
. "\n FROM #__visohotlink_link AS a"
. "\n INNER JOIN #__visohotlink_referer AS c"
. "\n ON c.id=a.id_referer"
. "\n INNER JOIN #__visohotlink_site AS b"
. "\n ON b.id=c.id_site"
. "\n WHERE b.id=b.id"
. $query_group_by_file
. $query_group_by_host
. $query_group_by_site_referer
. $query_group_by_answer_type
. $query_group_by_link_type
. $query_group_by_mime_type
. $query_group_by_referer_type
. $query_group_by_referer
. $query_sort_by
. "\n LIMIT $limitstart, $limit";
;
// Set the query and load results
$database->setQuery( $query );
$rows = $database->loadObjectList();
// Ask for the class that build the page navigation system
$pageNav = new mosPageNav( $total, $limitstart, $limit );
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Build the select lists
$select_list = '';
$select_list .= '
';
$button = array();
$button[0]->type = 'edit';
$button[0]->task = 'editLink';
$button[1]->type = 'action';
$button[1]->task = 'massAction';
$button[2]->type = 'delete';
$button[2]->task = 'removeLink';
showButton ($button);
// Sow results
HTML_visohotlink::showLinks ($rows, $pageNav, $select_list, $stats , selection());
}
// Query the MySQL Database with a lot of parameters in order to have a list of sites
function showSites () {
global $database, $mainframe, $entries_per_page;
// Look for parameters
$limit = mosGetParam( $_REQUEST, 'limit', $entries_per_page );
$limitstart = mosGetParam( $_REQUEST, 'limitstart', '0' );
$group_by_answer_type = mosGetParam( $_REQUEST, 'group_by_answer_type', '' );
$group_by_link_type = mosGetParam( $_REQUEST, 'group_by_link_type', '' );
$sort_by = mosGetParam( $_REQUEST, 'sort_by', 'downloaded' );
$ascdesc = mosGetParam( $_REQUEST, 'ascdesc', 'DESC' );
$query_group_by_answer_type = '';
if ($group_by_answer_type!='') {
$query_group_by_answer_type = "\n AND b.answer_type='$group_by_answer_type'";
}
$query_group_by_link_type = '';
if ($group_by_link_type!='') {
$query_group_by_link_type = "\n AND b.link_type='$group_by_link_type'";
}
switch ($sort_by) {
case 'url':
$query_sort_by = "\n ORDER BY b.url ".$ascdesc;
break;
case 'downloaded':
$query_sort_by = "\n ORDER BY a.downloaded ".$ascdesc;
break;
case 'bandwidth':
$query_sort_by = "\n ORDER BY a.bandwidth ".$ascdesc;
break;
case 'date':
$query_sort_by = "\n ORDER BY b.date ".$ascdesc;
break;
case 'visits':
$query_sort_by = "\n ORDER BY visits ".$ascdesc;
break;
case 'performance_rate':
$query_sort_by = "\n ORDER BY performance_rate ".$ascdesc;
break;
case 'performance_bw_rate':
$query_sort_by = "\n ORDER BY performance_bw_rate ".$ascdesc;
break;
default;
$query_sort_by = '';
break;
}
// An now is the query
$query = "INSERT INTO #__visohotlink_temp2 SELECT DISTINCT b.id, SUM(a.downloaded), SUM(a.size*a.downloaded) FROM #__visohotlink_site AS b INNER JOIN #__visohotlink_referer AS c ON b.id=c.id_site INNER JOIN #__visohotlink_link AS a ON a.id_referer=c.id WHERE b.referer_type='normal' ".$query_group_by_answer_type.$query_group_by_link_type. " GROUP BY b.id";
$database->setQuery( $query );
$database->query();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Global stats
$querycount = "SELECT COUNT(DISTINCT b.id) AS count, SUM(d.visits) AS visits"
. "\n FROM #__visohotlink_site AS b"
. "\n LEFT JOIN #__visohotlink_referer AS c"
. "\n ON c.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON d.id_referer=c.id"
. "\n WHERE b.referer_type='normal'"
. $query_group_by_answer_type
. $query_group_by_link_type
;
$querycount2 = "SELECT SUM(a.downloaded) AS downloaded, SUM(a.bandwidth) AS bandwidth"
. "\n FROM #__visohotlink_temp2 AS a"
;
// Set the query and load results
$database->setQuery( $querycount );
$result = $database->loadObjectList();
$database->setQuery( $querycount2 );
$result2 = $database->loadObjectList();
$total = $result[0]->count;
if ($result[0]->visits!=0) $stats->visits = $result[0]->visits; else $stats->visits = 0;
if ($result2[0]->downloaded!=0) $stats->downloaded = $result2[0]->downloaded; else $stats->downloaded = 0;
if ($result2[0]->bandwidth!=0) $stats->bandwidth = $result2[0]->bandwidth; else $stats->bandwidth = 0;
$query = "SELECT DISTINCT b.*, a.downloaded AS downloaded, a.bandwidth AS bandwidth, SUM(d.visits) AS visits, TRUNCATE (SUM(d.visits) / a.downloaded * 100, 2) AS performance_rate, TRUNCATE (SUM(d.visits) / a.bandwidth * 1000000, 2) AS performance_bw_rate"
. "\n FROM #__visohotlink_site AS b"
. "\n LEFT JOIN #__visohotlink_temp2 AS a"
. "\n ON a.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_referer AS c"
. "\n ON c.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON d.id_referer=c.id"
. "\n WHERE b.referer_type='normal'"
. $query_group_by_answer_type
. $query_group_by_link_type
. "\n GROUP BY b.id"
. $query_sort_by
. "\n LIMIT $limitstart, $limit"
;
// Set the query and load results
$database->setQuery( $query );
$rows = $database->loadObjectList();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$query = "TRUNCATE TABLE #__visohotlink_temp2";
$database->setQuery( $query );
$database->query();
// Ask for the class that build the page navigation system
$pageNav = new mosPageNav( $total, $limitstart, $limit );
// Build the select lists
$select_list = '';
$select_list .= '
' . _VH_HOTLINK_TYPES . '
';
$select_list .= '
' . _VH_ANSWER_TYPES . '
';
$select_list .= '
' . _VH_SORTING . '
';
$button = array();
$button[0]->type = 'edit';
$button[0]->task = 'editSite';
$button[2]->type = 'delete';
$button[2]->task = 'removeSite';
showButton ($button);
// Sow results
HTML_visohotlink::showSites ($rows, $pageNav, $select_list, selection_site(), $stats, 'showSites');
}
// Computes stats for search engines
function showEngines () {
global $database, $mainframe, $entries_per_page;
// Look for parameters
$limit = mosGetParam( $_REQUEST, 'limit', $entries_per_page );
$limitstart = mosGetParam( $_REQUEST, 'limitstart', '0' );
$sort_by = mosGetParam( $_REQUEST, 'sort_by', 'downloaded' );
$ascdesc = mosGetParam( $_REQUEST, 'ascdesc', 'DESC' );
switch ($sort_by) {
case 'url':
$query_sort_by = "\n ORDER BY b.url ".$ascdesc;
break;
case 'downloaded':
$query_sort_by = "\n ORDER BY downloaded ".$ascdesc;
break;
case 'bandwidth':
$query_sort_by = "\n ORDER BY bandwidth ".$ascdesc;
break;
case 'date':
$query_sort_by = "\n ORDER BY b.date ".$ascdesc;
break;
case 'visits':
$query_sort_by = "\n ORDER BY visits ".$ascdesc;
break;
case 'performance_rate':
$query_sort_by = "\n ORDER BY performance_rate ".$ascdesc;
break;
case 'performance_bw_rate':
$query_sort_by = "\n ORDER BY performance_bw_rate ".$ascdesc;
break;
default;
$query_sort_by = '';
break;
}
// An now is the query
$query = "INSERT INTO #__visohotlink_temp2 SELECT DISTINCT b.id, SUM(a.downloaded), SUM(a.size*a.downloaded) FROM #__visohotlink_site AS b INNER JOIN #__visohotlink_referer AS c ON b.id=c.id_site INNER JOIN #__visohotlink_link AS a ON a.id_referer=c.id WHERE b.referer_type='engine' GROUP BY b.id";
$database->setQuery( $query );
$database->query();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Global stats
$querycount = "SELECT COUNT(DISTINCT b.id) AS count, SUM(d.visits) AS visits"
. "\n FROM #__visohotlink_site AS b"
. "\n LEFT JOIN #__visohotlink_referer AS c"
. "\n ON c.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON d.id_referer=c.id"
. "\n WHERE b.referer_type='engine'"
;
$querycount2 = "SELECT SUM(a.downloaded) AS downloaded, SUM(a.bandwidth) AS bandwidth"
. "\n FROM #__visohotlink_temp2 AS a"
;
// Set the query and load results
$database->setQuery( $querycount );
$result = $database->loadObjectList();
$database->setQuery( $querycount2 );
$result2 = $database->loadObjectList();
$total = $result[0]->count;
if ($result[0]->visits!=0) $stats->visits = $result[0]->visits; else $stats->visits = 0;
if ($result2[0]->downloaded!=0) $stats->downloaded = $result2[0]->downloaded; else $stats->downloaded = 0;
if ($result2[0]->bandwidth!=0) $stats->bandwidth = $result2[0]->bandwidth; else $stats->bandwidth = 0;
$query = "SELECT DISTINCT b.*, a.downloaded AS downloaded, a.bandwidth AS bandwidth, SUM(d.visits) AS visits, TRUNCATE (SUM(d.visits) / a.downloaded * 100, 2) AS performance_rate, TRUNCATE (SUM(d.visits) / a.bandwidth * 1000000, 2) AS performance_bw_rate"
. "\n FROM #__visohotlink_site AS b"
. "\n LEFT JOIN #__visohotlink_temp2 AS a"
. "\n ON a.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_referer AS c"
. "\n ON c.id_site=b.id"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON d.id_referer=c.id"
. "\n WHERE b.referer_type='engine'"
. "\n GROUP BY b.id"
. $query_sort_by
. "\n LIMIT $limitstart, $limit"
;
// Set the query and load results
$database->setQuery( $query );
$rows = $database->loadObjectList();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$query = "TRUNCATE TABLE #__visohotlink_temp2";
$database->setQuery( $query );
$database->query();
// Ask for the class that build the page navigation system
$pageNav = new mosPageNav( $total, $limitstart, $limit );
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Build the select lists
$select_list = '';
$select_list .= '
' . _VH_SORTING . '
';
// Sow results
HTML_visohotlink::showSites ($rows, $pageNav, $select_list, selection_site(), $stats, 'showEngines');
}
// Computes stats for keywords
function showKeywords () {
global $database, $mainframe, $entries_per_page;
// Look for parameters
$limit = mosGetParam( $_REQUEST, 'limit', $entries_per_page );
$limitstart = mosGetParam( $_REQUEST, 'limitstart', '0' );
$sort_by = mosGetParam( $_REQUEST, 'sort_by', 'downloaded' );
$ascdesc = mosGetParam( $_REQUEST, 'ascdesc', 'DESC' );
$group_by_site_referer = mosGetParam( $_REQUEST, 'group_by_site_referer', '' );
$query_group_by_site_referer = '';
if ($group_by_site_referer!='') {
$query_group_by_site_referer = "\n AND b.url='$group_by_site_referer'";
}
switch ($sort_by) {
case 'url':
$query_sort_by = "\n ORDER BY c.referer ".$ascdesc;
break;
case 'downloaded':
$query_sort_by = "\n ORDER BY a.downloaded ".$ascdesc;
break;
case 'bandwidth':
$query_sort_by = "\n ORDER BY a.bandwidth ".$ascdesc;
break;
case 'date':
$query_sort_by = "\n ORDER BY c.date ".$ascdesc;
break;
case 'visits':
$query_sort_by = "\n ORDER BY visits ".$ascdesc;
break;
case 'performance_rate':
$query_sort_by = "\n ORDER BY performance_rate ".$ascdesc;
break;
case 'performance_bw_rate':
$query_sort_by = "\n ORDER BY performance_bw_rate ".$ascdesc;
break;
default;
$query_sort_by = '';
break;
}
// An now is the query
$query = "INSERT INTO #__visohotlink_temp SELECT DISTINCT c.referer, c.id, SUM(a.downloaded), SUM(a.size*a.downloaded) FROM #__visohotlink_site AS b INNER JOIN #__visohotlink_referer AS c ON b.id=c.id_site INNER JOIN #__visohotlink_link AS a ON a.id_referer=c.id WHERE b.referer_type='engine' $query_group_by_site_referer GROUP BY c.referer";
$database->setQuery( $query );
$database->query();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Global stats
$querycount = "SELECT COUNT(DISTINCT c.referer) AS count, SUM(d.visits) AS visits"
. "\n FROM #__visohotlink_referer AS c"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON c.id=d.id_referer"
. "\n LEFT JOIN #__visohotlink_site AS b"
. "\n ON b.id=c.id_site"
. "\n WHERE b.referer_type='engine'"
. $query_group_by_site_referer
;
$querycount2 = "SELECT SUM(a.downloaded) AS downloaded, SUM(a.bandwidth) AS bandwidth"
. "\n FROM #__visohotlink_temp AS a"
;
// Set the query and load results
$database->setQuery( $querycount );
$result = $database->loadObjectList();
$database->setQuery( $querycount2 );
$result2 = $database->loadObjectList();
$total = $result[0]->count;
if ($result[0]->visits!=0) $stats->visits = $result[0]->visits; else $stats->visits = 0;
if ($result2[0]->downloaded!=0) $stats->downloaded = $result2[0]->downloaded; else $stats->downloaded = 0;
if ($result2[0]->bandwidth!=0) $stats->bandwidth = $result2[0]->bandwidth; else $stats->bandwidth = 0;
$query = "SELECT DISTINCT c.referer, c.id, c.date, a.downloaded AS downloaded, a.bandwidth AS bandwidth, SUM(d.visits) AS visits, TRUNCATE (SUM(d.visits) / a.downloaded * 100, 2) AS performance_rate, TRUNCATE (SUM(d.visits) / a.bandwidth * 1000000, 2) AS performance_bw_rate"
. "\n FROM #__visohotlink_referer AS c"
. "\n LEFT JOIN #__visohotlink_temp AS a"
. "\n ON a.referer=c.referer"
. "\n LEFT JOIN #__visohotlink_visits AS d"
. "\n ON c.id=d.id_referer"
. "\n INNER JOIN #__visohotlink_site AS b"
. "\n ON b.id=c.id_site"
. "\n WHERE b.referer_type='engine'"
. $query_group_by_site_referer
. "\n GROUP BY c.referer"
. $query_sort_by
. "\n LIMIT $limitstart, $limit"
;
// Set the query and load results
$database->setQuery( $query );
$rows = $database->loadObjectList();
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$query = "TRUNCATE TABLE #__visohotlink_temp";
$database->setQuery( $query );
$database->query();
// Ask for the class that build the page navigation system
$pageNav = new mosPageNav( $total, $limitstart, $limit );
// If database error, stop here
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// Build the select lists
$select_list = '';
$select_list .= '