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);
}
}
*/
}
}
?>
T'inkazos
vol.4 edición especial;
Resumen:
S1990-74512008000100002 T'inkazos versión impresa ISSN
1990-7451Resumen OSTRIA, Gustavo Rodríguez ; SERRANO, Humberto Solares
y
CANEDO, María Lourdes Zabala . Youth, fear and urban space in Cochabamba .Traducido porGustavo Rodríguez Ostria.
T'inkazos [online].
2008,
vol.4Selected edition, pp. 0-0.
ISSN 1990-7451.
For upper-middle-class young people in the city of Cochabamba, the limits of the habitable world are reached a few blocks away from the Plaza Colón, in the heart of the old city centre. Just metres further on begins an invisible wall that separates two worlds, two cultures and two aesthetics, where fear and insecurity play an important role. In this article, the authors share some of the findings from their research on young people and the decline of the public space in Cochabamba.