class sql
{
var $user="seodb_user";
var $pass="Seopwd56335633";
var $host="localhost";
var $base="seodb";
function sql() {
$link=mysql_connect($this->host, $this->user, $this->pass) or die ("Error conectando a la base de datos!".mysql_error());
mysql_select_db($this->base, $link) or die("Error seleccionando la base de datos!".mysql_error());
$this->link = $link;
}
function Update($consulta, $error) {
$this->query = mysql_query($consulta, $this->link)or die("".$error."
".mysql_error());
}
function lastID(){
$this->lastID = mysql_insert_id();
return $this->lastID;
}
function libreSQL($consulta, $error) {
$this->query = mysql_query($consulta, $this->link)or die("".$error."
$consulta
".mysql_error());
$this->consulta=$consulta;
}
function Fetch(){
if($this->query != NULL){
return(mysql_fetch_array($this->query));
}else{
return(NULL);
}
}
function FetchValue() {
if( $this->query == NULL ) return NULL;
$row = mysql_fetch_row($this->query);
return $row[0];
}
function cant(){
return(mysql_num_rows($this->query));
}
}
?>
if($_GET['log']=="OUT"){
session_destroy();
header("location: ".RAIZDIR."/index.php");
}
if( isset($_POST['usuarioSecc']) && isset($_POST['passSecc']) ) {
if( empty($_POST['usuarioSecc']) ) {
$error1[0]=($_SESSION['idioma']=="uk")?"e-mail required!":"ˇDebe indicar un e-mail!";
} else if(!ereg('^[a-z0-9]+([\.]?[a-z0-9_-]+)*@'.'[a-z0-9]+([\.-]+[a-z0-9]+)*\.[a-z]{2,}$', $_POST['usuarioSecc'])) {
$error1[0]=($_SESSION['idioma']=="uk")?"Invalid e-mail!":"ˇe-mail incorrecto!";
}
if(!isset($errorl)){
$email= "'".addslashes($_POST['usuarioSecc'])."'";
$clave= "'".addslashes($_POST['passSecc'])."'";
$sqlU= new sql;
$sqlU->libreSQL("SELECT * FROM usuario WHERE email= ".$email." AND clave=".$clave." AND estado=".USUARIO_ACTIVO,
'no se puedo logear');
$row=$sqlU->Fetch();
if($row){
$_SESSION['logon']="TRUE";
$_SESSION['logon_id']=$row['idUsuario'];
$_SESSION['logon_nombre']=$row['nombre'];
$_SESSION['logon_apellidos']=$row['apellidos'];
$_SESSION['logon_email']=$row['email'];
$_SESSION['logon_tratamiento']=$row['tratamiento'];
$_SESSION['logon_numeroSocioSEO']=$row['numeroSocioSEO'];
$_SESSION['logon_direccion']=$row['direccion'];
$_SESSION['logon_poblacion']=$row['poblacion'];
$_SESSION['logon_codigoPostal']=$row['codigoPostal'];
$_SESSION['logon_provincia']=$row['provincia'];
$_SESSION['logon_pais']=$row['pais'];
$_SESSION['logon_telefono']=$row['telefono'];
$_SESSION['logon_fax']=$row['fax'];
$_SESSION['logon_estado']=$row['estado'];
$_SESSION['logon_esAdmGeneral']=$row['esAdmGeneral'];
$_SESSION['logon_esRefeerer']=$row['esRefeerer'];
$_SESSION['logon_esRevisorNormas']=$row['esRevisorNormas'];
$_SESSION['logon_esArticulista']=$row['esArticulista'];
$_SESSION['logon_esControlador']=$row['esControlador'];
$_SESSION['logon_esPublicador']=$row['esPublicador'];
$_SESSION['logon_esMaquetador']=$row['esMaquetador'];
$_SESSION['logon_esSubdirector']=$row['esSubdirector'];
$_SESSION['logon_idioma']=$row['idioma'];
$_SESSION['idioma']=($row['idioma']=="uk")?"uk":"es";
header("location: privado/index.php");
}
}else{
$_SESSION['logon']="FALSE";
$errorl[0]="Usuario o contraseña incorrectos";
}
}
?> function mostrar_cabecera($tab="") { ?>