Create($db,$user,$host2,$pass); $cdc = new MySQL_class; $cdc->Create($cdc_db,$cdc_user,$cdc_host_2,$cdc_pass); $crm = new MySQL_class; $crm->Create($crm_db,$crm_user,$crm_host2,$crm_pass); $gc_sql=$crm; // foil hackers unset($u_type,$u_id,$session_email); // start session start_session($php_sessid); if(page_auth(3,$u_type,$cdc) == "yes") { $staging=yes; } unset($u_id); start_session($sessid); lock_down("publisher",$u_id,$code,$array); // log it app_log('publisher',$PHP_SELF,$search_word,$category_id,'view',$code,$array); $conf = get_conf2(3); if($staging=='yes' && $code=='NCU') { $conf[custom]='N'; } // start template engine $tpl = new rFastTemplate("."); $tpl->no_strict(); $tpl->quiet(); if($u_id) { $user = get_cdc($u_id,$code,$cdc); $tpl->assign(array( COMPANY_ID => $company_id, HLO1 => "", HLO2 => "", HLI1 => "", USER => "You are logged in as: $user[first_name] $user[last_name]
Logout - Manage Email " )); } else { $tpl->assign(array( HLI1 => "", HLI2 => "", HLO1 => "" )); } // getting the header and other needed pages if($conf[custom]=='Y') { $main = get_template('4',$TEMPLATE,$brnd,$code,$staging); } else { $main = get_template('10',$TEMPLATE,$brnd,$code,$staging); $body = get_template('4',$TEMPLATE,$brnd,$code,$staging); } //$tpl = $ms[tpl]; $tpl->define_raw( array( main => $main, body => $body )); $tpl = show_login($u_id,$tpl); if($code == "CALITODAY") { $conf_cali = get_conf2(1); $tpl = most_popular($conf_cali,$code,$tpl); for($a=1;$a<=20;$a++) { $tpl = section_display($a,$brnd,$conf_cali); } } $tpl->assign( array( SELF => $PHP_SELF )); $query = "select category_name, image_2, image_3, image_4, order_by from $C_CATEGORY where category_id = '$category_id' and brand = '$code' "; $data = $brnd->mydata($query); // validate category id if(!$data[category_name][0]) { echo"Invalid ID"; exit(); } $cat_name = $data[category_name][0]; $image_2 = $data[image_2][0]; $image_3 = $data[image_3][0]; $image_4 = $data[image_4][0]; $order_by = $data[order_by][0]; // lets get the issue info .... $query = "select name, image, issue_id from $ISSUE where brand = '$code' and date <= '".date("Y-m-d")."' order by date desc limit 0,1"; //$data = $brnd->mydata($query); //$tpl->assign(array( ISSUE_NAME => stripslashes($data[name][0]), // ISSUE_IMAGE => stripslashes($data[image][0]), // ISSUE_ID => $data[issue_id][0] )); // lets get the articles // *************** display all of todays or the top 20 articles for this category $today = date("YmdHi00"); // this will break the total into a number of different pages ... if($first=="") { $first = "0"; $last = $conf[number_display]; $query = "select o.article_id as count from $ORGANIZE o, $TITLE t where o.category_id = '$category_id' and t.article_id = o.article_id and t.disable = 'T' and o.brand = '$code' and o.time_stamp <= '$today' "; $count_data=$brnd->mydata($query); $count = $data[count][0]; } // lets make the counting pages foo $query = "select o.article_id as count from $ORGANIZE o, $TITLE t where o.category_id = '$category_id' and t.article_id = o.article_id and t.disable = 'T' and o.brand = '$code' and o.time_stamp <= '$today' "; $count_data=$brnd->mydata($query); $count = $count_data[count][0]; $number_of_pages = $count / $conf[number_display]; $foo = explode(".", $number_of_pages); // decide if we need to add an extra page $base = $foo[0]; if($base < $number_of_pages) { $base = $base + 1; } $remainder = $foo[1]; if($page!=1) { $a_pages = "> $cat_name "; } else { $a_pages = "> $cat_name "; } for($a=0;$a<$base;$a++) { if($page>=5) { // ***************** takes care of moving after ten // the goal is to keep the page selected in the middle of the category pages // but not put in the in middle if there is going to be less than ten displayed .. if(!$loop_one) { // inside loop one we make sure there are more than ten page if($base>=11) { $a = $page - 5; $greater=yes; $b = $a + 1; } $loop_one='yes'; } if(greater) { if($num_1=="") { $num_1 = $a * $conf[number_display]; } else { $num_1 = $num_1 + $conf[number_display]; } $less = $conf[number_display] - 1; $num_2 = $less + $num_1; $b = $a + 1; // so lets make our pages like google if($b!=1) { if($b!=$page) { $pages .= " > $b "; } else { $pages .= " > $b "; } } $c++; if($c==9) { break; } if($base==$b) { break; } } else { if($num_1=="") { $num_1 = "0"; } else { $num_1 = $num_1 + $conf[number_display]; } $less = $conf[number_display] - 1; $num_2 = $less + $num_1; $b = $a + 1; if($b!=1) { if($b!=$page) { $pages .= " > $b "; } else { $pages .= " > $b "; } } if($a==9) { break; } } } else { // ******************* first ten stories if($num_1=="") { $num_1 = "0"; } else { $num_1 = $num_1 + $conf[number_display]; } $less = $conf[number_display] - 1; $num_2 = $less + $num_1; $b = $a + 1; if($b!=1) { if($b!=$page) { $pages .= " > $b "; } else { $pages .= " > $b "; } } if($a==9) { break; } } } $tpl->assign( array( PAGES => "$a_pages $pages", O_PAGES => $pages )); $tpl->assign( array( PAGE_TITLE => "$cat_name" )); $tpl->assign( array( IMAGE_2 => stripslashes($image_2), IMAGE_3 => stripslashes($image_3), IMAGE_4 => stripslashes($image_4), THIS_CATEGORY_ID => $category_id )); if($page!=1) { $tpl->assign( array( PAGE_NUMBER => $page )); } // get a list of articles based on the cat ID if($order_by=='DATE') { /*$query = "select article_id from $ORGANIZE where category_id = '$category_id' and brand = '$code' and time_stamp <= '$today' order by time_stamp desc limit ".abs($first).", $conf[number_display]";*/ $query = "select o.article_id from $ORGANIZE o, $TITLE t where o.category_id = '$category_id' and t.article_id = o.article_id and t.disable = 'T' and o.brand = '$code' and o.time_stamp <= '$today' order by o.time_stamp desc limit ".abs((int)$first).", $conf[number_display]"; $cat_data = $brnd->mydata($query); } else { $query = "select $ORGANIZE.article_id from $ORGANIZE, $TITLE where category_id = '$category_id' and $ORGANIZE.brand = '$code' and $ORGANIZE.article_id = $TITLE.article_id and $ORGANIZE.time_stamp <= '$today' order by article_title limit ".abs((int)$first).", $conf[number_display] "; $cat_data = $brnd->mydata($query); } // number of page // loop through and print // will get the block to loop through // no strict $tpl->no_strict(); // will put the dates in long format $long_date=yes; // the actual loop for($a=0;$amydata($query); date_time($data[timestamp][0]); $tpl->assign( array( TITLE => stripslashes($data[article_title][0]), ARTICLE_ID => $data[article_id][0], TIME => $ts_time, DATE => $ts_date )); if($a==0) { $tpl->assign( array( SPECIAL_TAG_1 => '', SPECIAL_TAG_2 => '' )); } else { $tpl->assign( array( SPECIAL_TAG_1 => '' )); } if($data[story_type][0]!='') { $tpl->assign( array( STORY_TYPE => stripslashes($data[story_type][0]).", " )); } else { $tpl->assign( array( STORY_TYPE => "" )); } if($data[article_publisher][0]!="") { $tpl->assign( array( PUBLISHER => stripslashes($data[article_publisher][0]).",")); } else { $tpl->assign( array( PUBLISHER => "" )); } if($data[article_sub_title][0]!="") { $tpl->assign( array( SUB_BR => "
", SUB_TITLE => stripslashes($data[article_sub_title][0]) )); } else { $tpl->assign( array( SUB_BR => "", SUB_TITLE => "" )); } if($a==0) { if($data[article_large_image][0]) { $tpl->assign( array( LARGE_IMAGE => stripslashes($data[article_large_image][0]) )); $tpl->assign( array( SMALL_IMAGE => "" )); } else { $tpl->assign( array( SMALL_IMAGE => stripslashes($data[article_small_image][0]) )); $tpl->assign( array( LARGE_IMAGE => "" )); } } else { $tpl->assign( array( LARGE_IMAGE => "" )); $tpl->assign( array( SMALL_IMAGE => stripslashes($data[article_small_image][0]) )); } if($data[article_author][0]!="") { $tpl->assign( array( BY => $conf[by] )); $tpl->assign( array( AUTHOR => stripslashes($data[article_author][0]) )); } else { $tpl->assign( array( BY => "" )); $tpl->assign( array( AUTHOR => "" )); } // this is for not showing the description if($conf[description]=='Y') { $description_foo = stripslashes($data[article_description][0])."
"; } else { if($first=="0") { if($a < $conf[number_description]) { $description_foo = stripslashes($data[article_description][0])."
"; } else { unset($description_foo); } $tpl->assign( array( DESCRIPTION => $description_foo )); } } // if no content hide something .... $query = "select section_id from $CONTENT where article_id = '".$cat_data[article_id][$a]."' and brand = '$code' "; $cdata = $brnd->mydata($query); if(!$cdata[section_id][0]) { $tpl->assign(array( HID1 => '' )); } else { $tpl->assign(array( HID1 => '', HID2 => '' )); } $tpl->assign( array( DESCRIPTION => $description_foo )); $tpl->parse("ARTICLE_LIST",".article_list"); } // **************************** display categories $tpl = publisher_auto_category($tpl,$code,$brnd); $tpl = publisher_auto_alt_category($tpl,$code,$brnd); // *************** display all of todays or the top 20 articles $now = date("YmdHi00"); $query = "select * from $TITLE where brand = '$code' and front_page = '1' and disable = 'T' and timestamp <= '$now' order by timestamp desc limit 0, $conf[num_head_lines]"; $data=$brnd->mydata($query); // loop through and print // will get the block to loop through // will put the dates in long format $long_date=yes; // the actual loop for($a=0;$aassign( array( LS_TITLE => stripslashes($data[article_title][$a]), LS_ARTICLE_ID => $data[article_id][$a], LS_DATE => $ts_date )); if($data[article_publisher][$a]!="") { $tpl->assign( array( LS_PUBLISHER => stripslashes($data[article_publisher][$a]).",")); } else { $tpl->assign( array( LS_PUBLISHER => "" )); } if($data[article_author][$a]!="") { $tpl->assign( array( BY => $conf[by] )); $tpl->assign( array( LS_AUTHOR => stripslashes($data[article_author][$a])."," )); } else { $tpl->assign( array( BY => "" )); $tpl->assign( array( LS_AUTHOR => "" )); } $tpl->parse("LEAD_STORY",".lead_story"); } // **************************** focus group $query = "select image, category_name from $C_FOCUS_CATEGORY where brand = '$code' and category_id = '$conf[focus_group_to_display]' "; $data_i=$brnd->mydata($query); $tpl->assign( array( F_IMAGE => stripslashes($data_i[image][0]), F_CATEGORY_NAME => stripslashes($data_i[category_name][0]), F_CATEGORY_ID => $conf[focus_group_to_display] )); $now = date("YmdHi00"); $query = "select article_id from $FOCUS_ORGANIZE where brand = '$code' and category_id = '$conf[focus_group_to_display]' and time_stamp <= '$now' order by time_stamp desc limit 0, $conf[num_focus_group_items]"; $data_c=$brnd->mydata($query); for($a=0;$amydata($query); date_time($data[timestamp][0]); $tpl->assign( array( F_ARTICLE_ID => $data[article_id][0], F_TITLE => stripslashes($data[article_title][0]), F_AUTHOR => stripslashes($data[article_author][0]), F_DATE => $ts_date )); if($data[article_publisher][0]!="") { $tpl->assign( array( F_PUBLISHER => stripslashes($data[article_publisher][0]).",")); } else { $tpl->assign( array( F_PUBLISHER => "" )); } $tpl->parse("FOCUS_GROUP",".focus_group"); } $tpl = html_chunks($staging,$tpl,$code,$brnd); if($conf[custom]=='Y') { $tpl->parse( MAIN, main ); } else { $tpl->parse( MAIN, array( "body", "main" )); } // cache start if(!$no_cache&&$category_id) { $file_data = $tpl->Fetch(); $fp = fopen("../cache_news/$category_id$dirh", 'w'); fwrite($fp, $file_data); fclose($fp); } // cache end $tpl->FastPrint(); exit(); ?>