/* ======== Connect to the SQL DB======== */

require('system/database.'.$cfg['sqldb'].'.php');
sed_sql_connect($cfg['mysqlhost'], $cfg['mysqluser'], $cfg['mysqlpassword'], $cfg['mysqldb']);
unset($cfg['mysqlhost'], $cfg['mysqluser'], $cfg['mysqlpassword']);

/*Hadnling incoming requests*///////////////////////////////////////////////////
if(@$_SERVER['HTTP_REFERER']){
	$urlinfo = parse_url($_SERVER['HTTP_REFERER']);
    if($urlinfo["host"] != $_SERVER['SERVER_NAME']
    	&& !strstr($_SERVER['QUERY_STRING'], "add_ingoing_click")){
      
        $SQL = "SELECT * FROM sed_link_items WHERE sl_url LIKE '%".$urlinfo["host"]."%'";
        $r = sed_sql_query($SQL);
        if($row = sed_sql_fetcharray($r)){
            sed_sql_query("INSERT
            		INTO sed_link_clicks_ingoing
                	SET
                    sl_id   = '".$row['sl_id']."',
                    slc_time = '".mktime()."'");
        }
    }
}
////////////////////////////////////////////////////////////////////////////////


/* ======== Configuration settings (from the DB) ======== */