News

Cover Story

How Rising Sports Fees Imperil TV’s Business Model 12/09/2012 8:20 PM Eastern

$field_issueno_value=$_GET['field_issueno_value'];
$field_coverdate_value=date("F d,Y", strtotime($_GET['field_coverdatae_value']));
//$newDate = date("d-m-Y", strtotime($originalDate));

$_GET['field_coverdatae_value'];

$value = $_GET['field_coverdatae_value'];

echo "

MCN -  $field_coverdate_value

";
//echo "

   Issue No:$field_issueno_value

";

$query1=mysql_query("select fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid, ht.field_head_text_value, f.filepath from content_field_issueno fs,term_node t,term_data td,
node n, files f, content_field_head_text ht, content_type_article cta where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and n.nid=ht.nid and n.nid = cta.nid
and cta.field_cover_story_image_fid = f.fid and fs.field_issueno_value=$field_issueno_value and td.tid='102' ORDER BY n.vid DESC limit 0,1");

$display1=mysql_fetch_object($query1);

$image=$display1->filepath;

if (!$image)
{
$query=mysql_query("select fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid, ht.field_head_text_value, f.filepath from content_field_issueno fs,term_node t,term_data td,
node n, files f, content_field_head_text ht, content_type_article cta where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and n.nid=ht.nid and n.nid = cta.nid
and cta.field_article_image_fid = f.fid and fs.field_issueno_value=$field_issueno_value and td.tid='102' ORDER BY n.vid DESC limit 0,1");
}else {

$query=mysql_query("select fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid, ht.field_head_text_value, f.filepath from content_field_issueno fs,term_node t,term_data td,
node n, files f, content_field_head_text ht, content_type_article cta where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and n.nid=ht.nid and n.nid = cta.nid
and cta.field_cover_story_image_fid = f.fid and fs.field_issueno_value=$field_issueno_value and td.tid='102' ORDER BY n.vid DESC limit 0,1");

}
$rows = mysql_num_rows($query);
if ($rows >=1){

echo "

Cover Story

";
$num=0;
while($display=mysql_fetch_object($query))
{
//echo $num;

$position=70;
$vid=$display->vid;
$nid=$display->nid;
$title=strip_tags($display->title);
$headtext=strip_tags($display->field_head_text_value);
$image=$display->filepath;

$val = "node/".$nid;
$result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
$row = db_fetch_object($result);
//echo "test1".$row->dst;

global $base_url;
echo "

";

echo "

";

echo "
";

echo "

" .$headtext. "

";

$mybody = substr($display->body, 0, $position);
echo $mybody;
echo "
";
$num++;

}

}

echo "
";
//echo "

$field_coverdate_value

";
//echo "

";
echo "

";

$query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
fs.field_issueno_value=$field_issueno_value and td.tid='93' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");
$rows = mysql_num_rows($query);
if ($rows){
echo "

";
//echo "

Magazine Content

";

$query=mysql_query("select cfgf.field_gated_field_value,fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf ,content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and cfgf.nid=n.nid and fs.vid=n.vid and
fs.field_issueno_value=$field_issueno_value and td.tid='95' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

if (mysql_num_rows($query)>0)
{
echo "

Content

";
while($display=mysql_fetch_object($query))
{

$vid=$display->vid;
$nid= $display->nid;
$title=strip_tags($display->title);
//echo $display->nid;
//echo $display->field_gated_field_value;
$gated = $display->field_gated_field_value;
$val = "node/".$nid;
$result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
$row = db_fetch_object($result);
//echo "test1".$row->dst;

if ($gated =="Yes")
{
echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }

    echo "
    ";
    }
    }

    //echo
    $monday = date("Y-m-d", strtotime( "previous monday"));

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n, content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='94' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");
    $rows = mysql_num_rows($query);
    if ($rows>=1)
    //if ($value != $monday){
    {
    echo "

    News

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;

    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;

    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }
    //}

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='97' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);
    if ($rows>=1)
    {
    echo "

    People

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";
    }
    }

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='99' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);

    if ($rows)
    {
    echo "

    Platform

    ";

    while($display=mysql_fetch_object($query))
    {
    //Print_r($display);
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }
    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='106' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows =mysql_num_rows($query);
    if ($rows>=1)
    {

    echo "

    Translation Please

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='98' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);

    if ($rows){

    echo "

    Rules

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }
    echo "

    ";
    echo "

    Finance

    ";
    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";
    }
    }
    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='100' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);

    if ($rows){
    echo "

    Special Report

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";
    }
    }
    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='101' and n.status=1 and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");
    $rows = mysql_num_rows($query);

    if ($rows){
    echo "

    Through the wire

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";
    }
    }

    $query=mysql_query("select fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and
    fs.field_issueno_value=$field_issueno_value and td.tid='102' and n.status=1 and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);
    if ($rows }else{
    echo "

    Top Stories

    ";
    $num=0;
    while($display=mysql_fetch_object($query))
    {

    //echo $num;
    if ($num==0)
    {
    }else{
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;

    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;

    echo "

  • ";
    echo "dst.">$display->title

    ";

    echo "

  • ";
    echo "
    ";
    }
    $num++;

    }
    }

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='103' and n.status=1 and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    $rows = mysql_num_rows($query);
    if ($rows>=1)
    {
    echo "

    Viewpoint

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='104' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");
    $rows = mysql_num_rows($query);
    if ($rows>=1)
    {
    echo "

    Viewpoint

    ";
    echo "

    Access

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";
    }
    }

    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='113' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    if (mysql_num_rows($query)>=1)
    {

    echo "

    Column

    ";
    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }

    }
    $query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid and
    fs.field_issueno_value=$field_issueno_value and td.tid='105' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

    if (mysql_num_rows($query)>=1)
    {
    echo "

    Picture This

    ";

    while($display=mysql_fetch_object($query))
    {
    $vid=$display->vid;
    $title=$display->title;
    //echo $display->nid;
    $nid = $display->nid;
    $gated = $display->field_gated_field_value;
    $val = "node/".$nid;
    $result = db_query("SELECT n.dst FROM url_alias n WHERE n.src='".$val."'");
    $row = db_fetch_object($result);
    //echo "test1".$row->dst;
    if ($gated =="Yes")
    {
    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";
    } else {

    echo "

  • ";
    echo "dst.">$display->title

    ";
    echo "

  • ";

    }
    echo "
    ";

    }
    }
    echo "

    ";

    ?>

    September
    October