<?php
ini_set("display_errors",1);
error_reporting(E_ALL);

// Copyright (c) 2003-2010 DataMystic.com, All Rights Reserved 
// This file is copyrighted content


  session_start();
  require_once("core.php");
  require_once "mostpopular.php";
  
  if (!isset($link_id))
  {
    $link_id = mysql_connect($dbservername,$userid, $userpassword) or die ("Server overloaded. Please try again in 60 seconds");
    mysql_select_db($dbname) or die("Server overloaded. Please try again in 60 seconds");
  }

  $result = mysql_query( "select text from pretext where name='sitestats' " , $link_id );
  $smarty->assign( 'sitestats', mysql_result($result,0,"text") );


  //
  // Category and OS Counters
  //
  $smarty->assign( 'windows', generate_category_data( $link_id, "and (os like '%Win%') and (category not like 'games%') and (category not like 'drivers%') and not($is_free)", "category ASC", "category") );
  $smarty->assign( 'freesoftware', generate_category_data( $link_id, " and $is_free ", "os ASC", "os") );
  $smarty->assign( 'games', generate_category_data( $link_id, " and (category like '%Games%') and not($is_free) ", "os ASC", "os") );
  $smarty->assign( 'mac', generate_category_data( $link_id, "and (os like '%Mac%') and (os not like '%Win%') and not($is_free)", "category ASC", "category") );
  $smarty->assign( 'linux', generate_category_data( $link_id, "and ((os like '%Linux%') or (os like '%Unix%')) and (os not like '%Win%') and not($is_free)", "category ASC", "category") );
  $smarty->assign( 'mobile', generate_category_data( $link_id, "and ((os like '%mobile%')) and not($is_free)", "category ASC", "category") );
  $smarty->assign( 'pda', generate_category_data( $link_id, "and ((os like '%Palm%') or (os like '%handheld%') or (os like '%pocket%') or (os like '%windows ce%')) and not($is_free)", "category ASC", "category") );
	  
  //$smarty->assign( 'new_overall', category_subset( $link_id, 'new_all', "", "and (category not like 'games%') and (category not like 'drivers%') ", "pdate DESC", "", 20 ) );

  $smarty->assign( 'top', get_cache( $link_id, "pop", "-12 hour", $needs_update, $last_updated ) );
  $smarty->assign( 'editor', get_cache( $link_id, "recommended", "-12 hour", $needs_update, $last_updated ) );

  $smarty->assign( 'rss_win', rss_feed( "rss/windows.xml", "Newest Windows Software", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_free', rss_feed( "rss/free.xml", "Newest Free Software", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_games', rss_feed( "rss/games.xml", "Newest Games", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_mac', rss_feed( "rss/mac.xml", "Newest Mac Software", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_linux', rss_feed( "rss/linux.xml", "Newest Linux Software", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_palm', rss_feed( "rss/palm.xml", "Newest PDA Software", "align=\"absmiddle\" hspace=\"4\"" ) );
  $smarty->assign( 'rss_mobile', rss_feed( "rss/mobile.xml", "Newest Mobile Software", "align=\"absmiddle\" hspace=\"4\"" ) );

  mysql_close($link_id);

 $smarty->display( 'homepage.tpl' );
?>