예제 #1
0
    header('Location: ./');
    die;
}
$TITLE = 'CMS - Perfil';
$PAGE_CSS = true;
$GLOBAL = true;
$BOOTSTRAP = true;
$JQUERY = true;
$INCL = array('myconnection.php');
include "include/essentials.php";
$conex = new myconnection('cmsuser', 'pass', 'cms');
if ($conex->conx_err) {
    $msg = 'Hubo un error a la hora de realizar la conexion con la Base de Datos.';
} else {
    #Cargar la informacion del usuario
    $conex->execute('select * from info where id_acc=' . $_GET['id']);
    if ($conex->q_err) {
        $msg = 'No se pudo cargar la informacion de la Base de Datos.';
    } else {
        $info = $conex->getArray();
    }
    #Cargar las publicaciones
    if (isset($info)) {
        #4 -> act_rec1
        $conex->execute("select * from post where id={$info['4']}");
        if (!$conex->q_err && ($temp = $conex->getArray()) !== null) {
            $act_rec = array($temp);
        }
        #5 -> act_rec2
        $conex->execute("select * from post where id={$info['5']}");
        if (!$conex->q_err && ($temp = $conex->getArray()) !== null) {
예제 #2
0
if (!isset($_SESSION['usr'])) {
    header('Location: ' . Root());
    die;
}
$TITLE = 'CMS - Tablero';
$PAGE_CSS = true;
$GLOBAL = true;
$BOOTSTRAP = true;
$JQUERY = true;
$INCL = array('myconnection.php');
include "../include/essentials.php";
$conex = new myconnection('cmsuser', 'pass', 'cms');
if ($conex->conx_err) {
    $msg = 'Hubo un error a la hora de realizar la conexion con la Base de Datos';
} else {
    $conex->execute('select * from post');
    if ($conex->q_err) {
        $msg = 'No se pudo cargar la informacion de la Base de Datos';
    } else {
        $table = $conex->getTable();
    }
    $conex->close();
}
unset($conex);
?>

<link rel="stylesheet" type="text/css" href="<?php 
Root('css/dashboard.css');
?>
">
예제 #3
0
<?php

session_start();
$TITLE = 'CMS - Crear usuario';
$PAGE_CSS = true;
$GLOBAL = true;
$BOOTSTRAP = true;
$JQUERY = true;
$INCL = array('myconnection.php');
include "../include/essentials.php";
if (isset($_POST['usuario'])) {
    $conex = new myconnection("cmsuser", "pass", "cms");
    if ($conex->conx_err) {
        $msg = "error al conectar a la base de datos";
    } else {
        $conex->execute("call CreateUsers('" . $_POST['usuario'] . "," . $_POST['clave'] . "," . $_POST['email'] . "')");
    }
}
/*if (isset($_POST)) {
		echo "debe llenar los campos";
	}
	elseif ($_POST['clave']==$_POST['conclave']) {
		# code...
		$conex = new myconnection("cmsuser","pass","cms");
	if ($conex->conx_err)
		$msg="error al conectar a la base de datos";
	else{
		$conex->execute("call CreateUsers('" . $_POST['usuario'] . "," . $_POST['clave'] . "," . $_POST['email'] . "')");
	}

	}*/
예제 #4
0
                break;
            case 'editor':
                $query .= "account.user like '%{$_GET['srch']}%' order by post.post_date asc";
                break;
            case 'categoria':
                $query .= "post.category like '%{$_GET['srch']}%' order by post.post_date asc";
                break;
            case 'fecha':
                $query .= "post.post_date like '%{$_GET['srch']}%' order by post.post_date asc";
                break;
        }
    } else {
        $query = "select post.*,account.user from post inner join account " . "on account.id = post.id_acc order by post_date asc";
    }
    #Cargar los posts
    $conex->execute($query);
    if ($conex->q_err) {
        //$msg = $conex->q_err;
        $msg = 'No se pudo cargar la informacion de la Base de Datos.';
    }
}
?>

<link rel="stylesheet" href="css/indexRoot.css">

<script type="text/javascript" src="<?php 
Root('js/scriptMain.js');
?>
"></script>
<script type="text/javascript" src="js/indexRootScript.js"></script>
예제 #5
0
$TITLE = 'CMS - Login';
$PAGE_CSS = true;
$GLOBAL = true;
$BOOTSTRAP = true;
$JQUERY = true;
$INCL = array('myconnection.php');
include "../include/essentials.php";
//Verificar si se envio una solicitud de inicio de sesion
if (isset($_POST['usuario']) && isset($_POST['clave'])) {
    $_POST['usuario'] = strtolower($_POST['usuario']);
    $usr = strtolower(trim($_POST['usuario']));
    $conex = new myconnection('cmsuser', 'pass', 'cms');
    if ($conex->conx_err) {
        $msg = 'Hubo un error a la hora de realizar la conexion con la Base de Datos.';
    } else {
        $conex->execute("call Autenticate('{$usr}','{$_POST['clave']}')");
        if ($conex->q_err) {
            $msg = 'No se pudo cargar la informacion de la Base de Datos.';
        } else {
            $resp = $conex->getValue();
            if ($resp == -1) {
                $msg = 'Usuario/clave incorrecta';
            } else {
                $_SESSION['usr'] = $usr;
                $_SESSION['id'] = $resp;
                $_SESSION['name'] = ucfirst($user);
                header('Location: dashboard.php');
            }
        }
    }
    $conex->close();