CMS Made Simple Forums

Posted: **Tue Aug 18, 2009 6:33 pm**

Hello, I getting an odd error from a plugin I need to make...

Warning: include_once(/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodbSQL_drivers//_datadict.inc) [function.include-once]: failed to open stream: No such file or directory in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 159

Warning: include_once() [function.include]: Failed opening '/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodbSQL_drivers//_datadict.inc' for inclusion (include_path='/usr/share/pear:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/admin:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/modules:.') in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 159

Fatal error: Class 'ADODB2_' not found in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 162

I thought that I had it all right but don't know where I went wrong.. Now this is tested on the lasted version 1.6.4 and I can't test on anything else today ... would anyone be able to spot the issue? Thanks for the help...

Code: Select all

<?php

global $gCms;
$db =& $gCms->GetDb();
$table=cms_db_prefix()."_CUSTOM_fishCounts";

$yesterday2 = date('m-d-y', mktime(0, 0, 0, date("m") , date("d") - 2, date("Y")));
$YearNU = date('Y', mktime(date("Y")));  
$today = date('d', mktime(0, 0, 0, date("m") , date("d"), date("Y")));


function table_exists($table) {
	global $gCms;
	$db =& $gCms->GetDb();
    $query = "SELECT * FROM ".$table;
    $result = &$db->Execute($query);
    if ($result && !$result->EOF){
        return true;
    }else{
        return false;
    }
}


function table_Make() {
    $taboptarray = array('mysql' => 'TYPE=MyISAM');
    $dict = NewDataDictionary($db);
    $flds = "
            ID I KEY AUTO,
            data X,
            dateTime C(10)
            ";
    // create it.
    $sqlarray = $dict->CreateTableSQL($table,
            $flds, $taboptarray);
    $dict->ExecuteSQLArray($sqlarray);
}


//function insertData() {
//	$obj = SimpleXML_Load_File("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");
//    $query = "INSERT INTO ".$table." SET data='".$obj."'";
//    $result = &$db->Execute($query);
//    if(!$result) {
//        //echo 'Error: '.mysql_error();
//        $params['message'] = mysql_error();
//    }else{
//        $params['message'] = $this->Lang('prefsupdated');
//    }
//}


function insertData($table, $date='2 days ago'){
global $gCms;
$db =& $gCms->GetDb();
// PROCESS THE DATE INTO THE CORRECT FORMAT
    $date = date('Y-m-d', strtotime($date));
    
// READ THE EXTERNAL FILE
    $txt = file_get_contents("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$date."&fmt=xml");
    if (!$txt) return FALSE;
    
// PREPARE FOR USE IN A QUERY - MAY REQUIRE THE DB CONNECTION TO BE IN THE SCOPE OF THIS FUNCTION!
    $txt = mysql_real_escape_string($txt);
 
// RUN THE QUERY AND ESTABLISH THE SUCCESS OR FAILURE
    $query = "INSERT INTO " . $table . " SET dateTime = '" . $date . "', data='" . $txt . "'";
    $res = &$db->Execute($query);
    if(!$res){
        $params['message'] = mysql_error();
    }else{
        $params['message'] = $this->Lang('prefsupdated');
    }
 
// DID THE QUERY WORK
    if (!$res) return FALSE;
    return TRUE;
}





function GetData($time){
global $gCms;
$db =& $gCms->GetDb();
	$query = 'SELECT * FROM '.$table.' WHERE date='.$time.'';
	$result = &$db->Execute($query);
	while ($result && !$result->EOF){
		$results= $result->fields['amount'];
	}
	return $retresult;
} 


function returnData() {
    if(table_exists($table)==false){
    	table_Make();
        returnData();
    }else{
		///find time may-be select limit 1 orderby decs
		$time = '';
		/// do checks on data and return data
		if($time){
			insertData($table);
			return GetData($time);
		}else{
			return GetData($time);
		}
    }
}






// MAKE AN OBJECT OUT OF XML
//$obj = SimpleXML_Load_File("https://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");

$obj=returnData(); 


// VISUALIZE THE OBJECT
// var_dump($obj);
 
// OUR OBJECTIVE
$location = "Lower Granite";
$counter = 0; 
// ITERATE OVER THE OBJECT
foreach ($obj->countdata->project as $project)
{

   if ($project->location == $location)
   {$counter = $counter+1;
// THIS IS THE ONE WE WANT
     // echo "\n$location";
	 
	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";

if( $location != null){
echo "<ul class=\"fishCount\" >";
	 
      foreach ($project->fishcounts->fish as $fish)
      {

         $fishcount = $fish["count"];
         $fishname  = (string)$fish;
        // echo "\n$fishcount $fishname";
		 
		  echo "<li style=\"display:none;\">
<p class=\"fishK\">$fishname</p>
<p class=\"fishKS\">$fishname</p>
<p class=\"fishV\">$fishcount</p>
<p class=\"fishVS\">$fishcount</p>
</li>";
		 
		 
      }
	echo "</ul>";
} else {
echo "<br/><h3 style=\"color:#fff;\">  No Fish Today</h3><br/><br/>";
}  
	  
      echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

   }else{

}
}if($counter==0){

	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";
echo "<p style=\"padding-top:50px;padding-left:60px; color: #CCCCCC; font-weight:900;\">USACE Down</p>";

echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

$counter = $counter+1;
}



?>

Posted: **Tue Aug 18, 2009 6:59 pm**

I tryed adding

global $gCms;
$db =& $gCms->GetDb();

to

Code: Select all


function table_Make() {
	global $gCms;
	$db =& $gCms->GetDb();
    $taboptarray = array('mysql' => 'TYPE=MyISAM');
    $dict = NewDataDictionary($db);
    $flds = "
            ID I KEY AUTO,
            data X,
            dateTime C(10)
            ";
    // create it.
    $sqlarray = $dict->CreateTableSQL($table,
            $flds, $taboptarray);
    $dict->ExecuteSQLArray($sqlarray);
}

but that made the page never show... no errors thou

lol...

Posted: **Wed Aug 19, 2009 2:59 am**

aimming to put all in a function was one suggestion.. but that lead to the same error... I think it's the adodbSQL_drivers//_datadict.inc in the

Warning: include_once(/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodbSQL_drivers//_datadict.inc) [function.include-once]: failed to open stream: No such file or directory in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 159

Warning: include_once() [function.include]: Failed opening '/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodbSQL_drivers//_datadict.inc' for inclusion (include_path='/usr/share/pear:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/admin:/var/www/vhosts/hellscanyonsportfishing.com/httpdocs/modules:.') in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 159

Fatal error: Class 'ADODB2_' not found in /var/www/vhosts/hellscanyonsportfishing.com/httpdocs/lib/adodb_lite/adodb.inc.php on line 162

Code: Select all

<?php

global $gCms;
$db =& $gCms->GetDb();
$table=cms_db_prefix()."_CUSTOM_fishCounts";

$yesterday2 = date('m-d-y', mktime(0, 0, 0, date("m") , date("d") - 2, date("Y")));
$YearNU = date('Y', mktime(date("Y")));  
$today = date('d', mktime(0, 0, 0, date("m") , date("d"), date("Y")));


function table_exists($table) {
	global $gCms;
	$db =& $gCms->GetDb();
    $query = "SELECT * FROM ".$table;
    $result = &$db->Execute($query);
    if ($result && !$result->EOF){
        return true;
    }else{
        return false;
    }
}


function table_Make() {
	global $gCms;
	//$db =& $gCms->GetDb();
    $taboptarray = array('mysql' => 'TYPE=MyISAM');
    $dict = NewDataDictionary($db);
    $flds = "
            ID I KEY AUTO,
            data X,
            dateTime C(10)
            ";
    // create it.
    $sqlarray = $dict->CreateTableSQL($table,
            $flds, $taboptarray);
    $dict->ExecuteSQLArray($sqlarray);
}


//function insertData() {
//	$obj = SimpleXML_Load_File("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");
//    $query = "INSERT INTO ".$table." SET data='".$obj."'";
//    $result = &$db->Execute($query);
//    if(!$result) {
//        //echo 'Error: '.mysql_error();
//        $params['message'] = mysql_error();
//    }else{
//        $params['message'] = $this->Lang('prefsupdated');
//    }
//}


function insertData($table, $date='2 days ago'){
global $gCms;
$db =& $gCms->GetDb();
// PROCESS THE DATE INTO THE CORRECT FORMAT
    $date = date('Y-m-d', strtotime($date));
    
// READ THE EXTERNAL FILE
    $txt = file_get_contents("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$date."&fmt=xml");
    if (!$txt) return FALSE;
    
// PREPARE FOR USE IN A QUERY - MAY REQUIRE THE DB CONNECTION TO BE IN THE SCOPE OF THIS FUNCTION!
    $txt = mysql_real_escape_string($txt);
 
// RUN THE QUERY AND ESTABLISH THE SUCCESS OR FAILURE
    $query = "INSERT INTO " . $table . " SET dateTime = '" . $date . "', data='" . $txt . "'";
    $res = &$db->Execute($query);
    if(!$res){
        $params['message'] = mysql_error();
    }else{
        $params['message'] = $this->Lang('prefsupdated');
    }
 
// DID THE QUERY WORK
    if (!$res) return FALSE;
    return TRUE;
}





function GetData($time){
global $gCms;
$db =& $gCms->GetDb();
	$query = 'SELECT * FROM '.$table.' WHERE date='.$time.'';
	$result = &$db->Execute($query);
	while ($result && !$result->EOF){
		$results= $result->fields['amount'];
	}
	return $retresult;
} 


function returnData() {
    if(table_exists($table)==false){
    	table_Make();
        returnData();
    }else{
		///find time may-be select limit 1 orderby decs
		$time = '';
		/// do checks on data and return data
		if($time){
			insertData($table);
			return GetData($time);
		}else{
			return GetData($time);
		}
    }
}




function smarty_function_fishCache() {

// MAKE AN OBJECT OUT OF XML
//$obj = SimpleXML_Load_File("https://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");

$obj=returnData(); 


// VISUALIZE THE OBJECT
// var_dump($obj);
 
// OUR OBJECTIVE
$location = "Lower Granite";
$counter = 0; 
// ITERATE OVER THE OBJECT
foreach ($obj->countdata->project as $project)
{

   if ($project->location == $location)
   {$counter = $counter+1;
// THIS IS THE ONE WE WANT
     // echo "\n$location";
	 
	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";

if( $location != null){
echo "<ul class=\"fishCount\" >";
	 
      foreach ($project->fishcounts->fish as $fish)
      {

         $fishcount = $fish["count"];
         $fishname  = (string)$fish;
        // echo "\n$fishcount $fishname";
		 
		  echo "<li style=\"display:none;\">
<p class=\"fishK\">$fishname</p>
<p class=\"fishKS\">$fishname</p>
<p class=\"fishV\">$fishcount</p>
<p class=\"fishVS\">$fishcount</p>
</li>";
		 
		 
      }
	echo "</ul>";
} else {
echo "<br/><h3 style=\"color:#fff;\">  No Fish Today</h3><br/><br/>";
}  
	  
      echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

   }else{

}
}if($counter==0){

	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";
echo "<p style=\"padding-top:50px;padding-left:60px; color: #CCCCCC; font-weight:900;\">USACE Down</p>";

echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

$counter = $counter+1;
}

}

?>

Posted: **Wed Aug 19, 2009 4:28 am**

ok.. so this tells me that "Table 'cms__CUSTOM_fishCounts' already exists" so ... no $db at all in a plug in?

Code: Select all

<?php

//global $gCms;
//$db =& $gCms->GetDb();
function ConDB(){
	global $gCms;
	mysql_connect($gCms->config['db_hostname'], $gCms->config['db_username'], $gCms->config['db_password']) or die(mysql_error());
	mysql_select_db($gCms->config['db_name']) or die(mysql_error());

}

function table_exists($table) {
	global $gCms;
	$db =& $gCms->GetDb();
    $query = "SELECT * FROM ".$table;
    $result = &$db->Execute($query);
    if ($result && !$result->EOF){
        return true;
    }else{
        return false;
    }
}


function table_Make($table) {
ConDB();
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE ".$table."(
ID INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(ID),
data LONGBLOB,
 dateTime VARCHAR(10)
 )")
 or die(mysql_error());  
//
//
//	//$db =& $gCms->GetDb();
//    $taboptarray = array('mysql' => 'TYPE=MyISAM');
//    $dict = NewDataDictionary($db);
//    $flds = "
//            ID I KEY AUTO,
//            data X,
//            dateTime C(10)
//            ";
//    // create it.
//    $sqlarray = $dict->CreateTableSQL($table,
//            $flds, $taboptarray);
//    $dict->ExecuteSQLArray($sqlarray);
}


//function insertData() {
//	$obj = SimpleXML_Load_File("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");
//    $query = "INSERT INTO ".$table." SET data='".$obj."'";
//    $result = &$db->Execute($query);
//    if(!$result) {
//        //echo 'Error: '.mysql_error();
//        $params['message'] = mysql_error();
//    }else{
//        $params['message'] = $this->Lang('prefsupdated');
//    }
//}


function insertData($table, $date='2 days ago'){
global $gCms;
$db =& $gCms->GetDb();
// PROCESS THE DATE INTO THE CORRECT FORMAT
    $date = date('Y-m-d', strtotime($date));
    
// READ THE EXTERNAL FILE
    $txt = file_get_contents("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$date."&fmt=xml");
    if (!$txt) return FALSE;
    
// PREPARE FOR USE IN A QUERY - MAY REQUIRE THE DB CONNECTION TO BE IN THE SCOPE OF THIS FUNCTION!
    $txt = mysql_real_escape_string($txt);
 
// RUN THE QUERY AND ESTABLISH THE SUCCESS OR FAILURE
    $query = "INSERT INTO " . $table . " SET dateTime = '" . $date . "', data='" . $txt . "'";
    $res = &$db->Execute($query);
    if(!$res){
        $params['message'] = mysql_error();
    }else{
        $params['message'] = $this->Lang('prefsupdated');
    }
 
// DID THE QUERY WORK
    if (!$res) return FALSE;
    return TRUE;
}





function GetData($table,$time){
global $gCms;
$db =& $gCms->GetDb();
	$query = 'SELECT * FROM '.$table.' WHERE date='.$time.'';
	$result = &$db->Execute($query);
	while ($result && !$result->EOF){
		$results= $result->fields['amount'];
	}
	return $retresult;
} 


function returnData() {
	$table=cms_db_prefix()."_CUSTOM_fishCounts";

$yesterday2 = date('m-d-y', mktime(0, 0, 0, date("m") , date("d") - 2, date("Y")));
$YearNU = date('Y', mktime(date("Y")));  
$today = date('d', mktime(0, 0, 0, date("m") , date("d"), date("Y")));

	
	
    if(table_exists($table)==false){
    	table_Make($table);
        returnData();
    }else{
		///find time may-be select limit 1 orderby decs
		$time = '';
		/// do checks on data and return data
		if($time){
			insertData($table);
			return GetData($table,$time);
		}else{
			return GetData($table,$time);
		}
    }
}




function smarty_function_fishCache() {

// MAKE AN OBJECT OUT OF XML
//$obj = SimpleXML_Load_File("https://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");

$obj=returnData(); 


// VISUALIZE THE OBJECT
// var_dump($obj);
 
// OUR OBJECTIVE
$location = "Lower Granite";
$counter = 0; 
// ITERATE OVER THE OBJECT
foreach ($obj->countdata->project as $project)
{

   if ($project->location == $location)
   {$counter = $counter+1;
// THIS IS THE ONE WE WANT
     // echo "\n$location";
	 
	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";

if( $location != null){
echo "<ul class=\"fishCount\" >";
	 
      foreach ($project->fishcounts->fish as $fish)
      {

         $fishcount = $fish["count"];
         $fishname  = (string)$fish;
        // echo "\n$fishcount $fishname";
		 
		  echo "<li style=\"display:none;\">
<p class=\"fishK\">$fishname</p>
<p class=\"fishKS\">$fishname</p>
<p class=\"fishV\">$fishcount</p>
<p class=\"fishVS\">$fishcount</p>
</li>";
		 
		 
      }
	echo "</ul>";
} else {
echo "<br/><h3 style=\"color:#fff;\">  No Fish Today</h3><br/><br/>";
}  
	  
      echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

   }else{

}
}if($counter==0){

	 echo "
<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";
echo "<p style=\"padding-top:50px;padding-left:60px; color: #CCCCCC; font-weight:900;\">USACE Down</p>";

echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
</div>";

$counter = $counter+1;
}

}

?>

Posted: **Wed Aug 19, 2009 6:21 pm**

well.. I have to bypass and do a tarditional db connect and what not... but any one on how to fix the other way?

Code: Select all

<?php

//global $gCms;
//$db =& $gCms->GetDb();
function ConDB(){
	global $gCms;
	mysql_connect($gCms->config['db_hostname'], $gCms->config['db_username'], $gCms->config['db_password']) or die(mysql_error());
	mysql_select_db($gCms->config['db_name']) or die(mysql_error());

}

function table_exists($table) {
	ConDB();
	$result = mysql_query("SELECT * FROM ".$table)
	or die(mysql_error());  
    if (isset($result)&&$result!=''){
        return true;
    }else{
        return false;
    }
}


function table_Make($table) {
ConDB();
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE ".$table."(
	ID INT NOT NULL AUTO_INCREMENT, 
	PRIMARY KEY(ID),
	data LONGTEXT,
 	dateTime VARCHAR(10)
 )")  or die(mysql_error());  

 
//
//
//	//$db =& $gCms->GetDb();
//    $taboptarray = array('mysql' => 'TYPE=MyISAM');
//    $dict = NewDataDictionary($db);
//    $flds = "
//            ID I KEY AUTO,
//            data X,
//            dateTime C(10)
//            ";
//    // create it.
//    $sqlarray = $dict->CreateTableSQL($table,
//            $flds, $taboptarray);
//    $dict->ExecuteSQLArray($sqlarray);
}


//function insertData() {
//	$obj = SimpleXML_Load_File("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$yesterday2."&fmt=xml");
//    $query = "INSERT INTO ".$table." SET data='".$obj."'";
//    $result = &$db->Execute($query);
//    if(!$result) {
//        //echo 'Error: '.mysql_error();
//        $params['message'] = mysql_error();
//    }else{
//        $params['message'] = $this->Lang('prefsupdated');
//    }
//}


function insertData($table, $date='-2 day'){
	ConDB();
	// PROCESS THE DATE INTO THE CORRECT FORMAT
	$date = date('Y-m-d', strtotime($date));
		
	// READ THE EXTERNAL FILE
	$txt = file_get_contents("http://www.nwp.usace.army.mil/op/fishdata/report.asp?op=daily&cd=".$date."&fmt=xml");
	if (!$txt) return FALSE;
		
	// PREPARE FOR USE IN A QUERY - MAY REQUIRE THE DB CONNECTION TO BE IN THE SCOPE OF THIS FUNCTION!
	$txt = mysql_real_escape_string($txt);
	 
	// RUN THE QUERY AND ESTABLISH THE SUCCESS OR FAILURE
	
	$res=mysql_query("INSERT INTO " . $table . " 
		(dateTime, data) VALUES('" . $date . "', '" . $txt . "') ") 
		or die(mysql_error());  
	

	
	// DID THE QUERY WORK
    if (!$res) return FALSE;
    return TRUE;
}





function GetData($table,$date){
	ConDB();
	
	$result = mysql_query("SELECT * FROM ".$table." WHERE dateTime='".$date."'")
	or die(mysql_error());  
	
	// store the record of the "example" table into $row
	$row = mysql_fetch_array( $result );
	// Print out the contents of the entry 
	$data=$row['data'];
	
	if($data!=''){
		return $data;
	}else{
		return false;
	}
} 


function returnData($table,$time) {
	$date = date('Y-m-d', strtotime($time.' day'));
    if(table_exists($table)==false){
    	table_Make($table);
        returnData($table,$time);
    }else{
		/// do checks on data and return data
		$TheData=GetData($table,$date);
		echo $date."<br/>";
		if($TheData==false){
			//insertData($table);
			$time =$time-1;
			echo "failed<br/>";
			returnData($table,$time);
		}else{
		echo "<br/><br/><br/>".$TheData."<br/><br/><br/>";
			return $TheData;
		}
    }
}




function smarty_function_fishCache() {
	global $gCms;
	$time = -1;
	$table=cms_db_prefix()."_CUSTOM_fishCounts";

	$YearNU = date('Y', mktime(date("Y")));  
	
	// MAKE AN OBJECT OUT OF XML
	$xml=returnData($table,0);
	echo "<br/><br/><br/>".$xml."<br/><br/><br/>";
	$obj = simplexml_load_string($xml);
	
	//$obj=returnData($table,$time);
	
	// VISUALIZE THE OBJECT
	// var_dump($obj);
	 
	// OUR OBJECTIVE
	$location = "Lower Granite";
	$counter = 0; 
	// ITERATE OVER THE OBJECT
	foreach ($obj->countdata->project as $project)
	{
	
	   if ($project->location == $location)
	   {$counter = $counter+1;
	// THIS IS THE ONE WE WANT
		 // echo "\n$location";
		 
		 echo "
	<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";
	
	if( $location != null){
	echo "<ul class=\"fishCount\" >";
		 
		  foreach ($project->fishcounts->fish as $fish)
		  {
	
			 $fishcount = $fish["count"];
			 $fishname  = (string)$fish;
			// echo "\n$fishcount $fishname";
			 
			  echo "<li style=\"display:none;\">
	<p class=\"fishK\">$fishname</p>
	<p class=\"fishKS\">$fishname</p>
	<p class=\"fishV\">$fishcount</p>
	<p class=\"fishVS\">$fishcount</p>
	</li>";
			 
			 
		  }
		echo "</ul>";
	} else {
	echo "<br/><h3 style=\"color:#fff;\">  No Fish Today</h3><br/><br/>";
	}  
		  
		  echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
	</div>";
	
	   }else{
	
	}
	}if($counter==0){
	
		 echo "
	<div class=\"fishTAG\"><a href=\"http://www.cbr.washington.edu/cgi-bin/dart/dart?report=adult&format=standard&year=$YearNU&dam=LWG&startdate=1%2F1&enddate=12%2F31\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink\">Lower Granite Dam </a>";
	echo "<p style=\"padding-top:50px;padding-left:60px; color: #CCCCCC; font-weight:900;\">USACE Down</p>";
	
	echo "<a href=\"http://www.cbr.washington.edu/dart/adult.html\" title=\"Columbia River DART (Data Access in Real Time) Adult Passage All Species Composite Report\" target=\"_blank\" class=\"DartLink2\">Visit Columbia River DART</a>
	</div>";
	
	$counter = $counter+1;
	}

}

?>

CMS Made Simple Forums

Class 'ADODB2_' not found ???

Class 'ADODB2_' not found ???

Re: Class 'ADODB2_' not found ???

Re: Class 'ADODB2_' not found ???

Re: Class 'ADODB2_' not found ???

Re: Class 'ADODB2_' not found ???