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);
}
}
*/
}
}
?>
Sur - vol.4 edição especial Sur - Revista Internacional de Direitos Humanos versão impressa ISSN
1806-6445 Sumário Sur v.4 n.se São Paulo 2008
Perpetrating good : Unintended consequences of International Human Rights Advocacy Bukovská, Barbora Prisons in Africa : An evaluation from a human rights perspective Sarkin, Jeremy Lost in translation : Expressions of human suffering, the language of human rights, and the South African Truth and reconciliation commission Saunders, Rebecca Sixty years after the universal declaration : Navigating the contradictions Pinheiro, Paulo Sérgio Poverty and human rights : From rhetoric to legal obligations a critical account of conceptual frameworks Costa, Fernanda Doz A new frontier in economic and social rights advocacy? Turning quantitative data into a tool for human rights accountability Felner, Eitan From commission to council : Has the United Nations succeeded in creating a credible human rights body? Short, Katherine Interview with Anthony Romero, executive director of the American Civil Liberties Union (ACLU) Romero, Anthony Very wicked children : "indian torture" and the madras torture commission report of 1855 Bhuwania, Anuj Rape characterised as genocide Vito, Daniela de ; Gill, Aisha ; Short, Damien Notes on the implementation by Latin American countries of the ILO Convention 169 in indigenous peoples Courtis, Christian Intercountry adoption as a measure of last resort in Africa: advancing the rights of a child rather than a right to a child Mezmur, Benyam D. Responding to "mixed" migration flows: a humanitarian perspective Derderian, Katharine ; Schockaert, Liesbeth The legitimate security interests of the State and international refugee protection Murillo, Juan Carlos International Cooperation and Internal displacement in Colombia : facing the challenges of the largest humanitarian crisis in South America Viana, Manuela Trindade Access to antiretroviral treatment for migrant populations in the Global South Amon, Joseph ; Todrys, Katherine European migration control in the African territory : the omission of the extraterritorial character of human rights obligations Cernadas, Pablo Ceriani