require_once(dirname(__FILE__)."/wpBlog.php");
require_once(dirname(__FILE__)."/../users/DBClassBlog.php");
class wpBlogDAO{
function wpBlogDAO(){
// $fileDef = parse_ini_file(dirname(__FILE__)."/../../../scielo.def.php");
// $DBparams["password"] = $fileDef["DB_USER_BLOG_PASSWORD"];
// $DBparams["db"] = $fileDef["DB_BLOG"];
// $DBparams["user"] = $fileDef["DB_USER_BLOG"];
// $DBparams["host"] = $fileDef["DB_HOST_BLOG"];
// $this->_db = new DBClass($DBparams);
$this->_db = new DBClassBlog();
}
function getBlogIdByName($acron){
$acron = "/".$acron."/";
$strsql = "SELECT blog_id from wp_blogs where path='".$acron."'";
$arr = $this->_db->databaseQuery($strsql);
$blogId = $arr[0]["blog_id"];
return $blogId;
}
function getBlogByName($acron){
$acron = "/".$acron."/";
$strsql = "SELECT blog_id from wp_blogs where path='".$acron."'";
$arr = $this->_db->databaseQuery($strsql);
if($arr){
return true;
}else{
return false;
}
}
function getCountCommentByPid($PID,$acron){
$reacron = $this->getBlogIdByName($acron);
if($reacron!=0){
$strsql = "SELECT comment_count FROM wp_".$reacron."_posts WHERE post_name='".$PID."'";
$arr = $this->_db->databaseQuery($strsql);
if(!isset($arr[0]["comment_count"])){
return '0';
}else{
return $arr[0]["comment_count"];
}
}else{
return '0';
}
}
function fechaConexao(){
$this->_db->fechaConexao();
}
}
?>
//consulta a instancia para pegar o COOKIE se jah logado
//ini_set("display_errors","1");
//error_reporting(E_ALL);
session_start();
$dir = dirname(__FILE__);
$defi = parse_ini_file($dir."/../../../scielo.def.php",true);
$robotsUserAgents = parse_ini_file($dir."/../../../robotsUserAgents.def",true);
$isaRobot = false;
foreach($robotsUserAgents["ROBOTS_AGENT"] as $key => $value){
$userAgent = strtolower($HTTP_USER_AGENT);
$agent = strtolower($value);
if (strstr($userAgent,$agent)){
$isaRobot = true;
break;
}
}
if (!$isaRobot){
if($defi['services']['show_login'] != "0"){
$loginURL = "http://".$defi['SCIELO_REGIONAL']['SCIELO_REGIONAL_DOMAIN']. $defi['SCIELO_REGIONAL']['check_login_url'];
if(isset($_GET['userID']))
{
if (strpos($_SERVER["REQUEST_URI"],"lng"))
{
$self_url = str_replace("lng=en","lng=".$_GET['lng'],"http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]);
}else{
$self_url = "http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]."&lng=".$_GET['lng'];
}
$inicio = strpos($self_url,"userID") -1 ;
$self_url = substr($self_url, 0, $inicio);
header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"');
setcookie("userID",$_GET['userID'],time()+3600,"/");
setcookie("userToken",$_GET['userToken'],time()+3600,"/");
setcookie("tokenVisit",$_GET['tokenVisit'],time()+3600,"/");
setcookie("firstName",$_GET['firstName'],time()+3600,"/");
setcookie("lastName",$_GET['lastName'],time()+3600,"/");
setcookie("userToken",$_GET['userToken'],time()+3600,"/");
setcookie("email",$_GET['email'],time()+3600,"/");
session_write_close();
Header("Location: ".$self_url);
exit;
}
/*
se nao verificou no Regional o Login do usuario vai verificar
*/
/*
if(!isset($_SESSION['checkedLogin']))
{
if(!isset($_REQUEST['skpa'])=="on"){
$self_url = "http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
$inicio = strpos($self_url,"userID") -1 ;
if($inicio > 0){
$self_url = substr($self_url, 0, $inicio);
}
$_SESSION['checkedLogin'] = "true";
session_write_close();
$self_url = '?origem='.str_replace('?','&',$self_url);
header("Location: ".$loginURL.$self_url);
}
}
*/
}
}
?>
Ambient. soc.
vol.4 special edition;
Abstract:
S1414-753X2008000100002 Ambiente & sociedade On-line version ISSN
1809-4422Abstract CARMO, Roberto Luiz do ; OJIMA, Andréa Leda Ramos de Oliveira ; OJIMA, Ricardo
and
NASCIMENTO, Thais Tartalha do . Virtual water, scarcity and management : Brazil as a large water exporter .Translated byElizabeth Abdanur,
Leonardo Brito.
Ambient. soc. [online].
2008,
vol.4Selected edition, pp. 0-0.
ISSN 1809-4422.
The economic valuation of water has recently been discussed in the Brazilian political scenario. Part of the proposed discussion is the incorporation of water in trade and commerce, especially in commodities, using the virtual water' concept. In this article we search for the impact that the utilization of the virtual water' concept may have on the Brazilian scenario and discuss, at the same time, the consequences of this exportation.
Keywords
:
Virtual water; Water resources; Commodities.