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;
}
?>
lol...