public function __construct()
{
if (SessionManager::getInstance()->isAdmin()) {
$aid = SessionManager::getInstance()->getAdminID();
$admin = DBManager::getInstance()->getAdmin($aid);
$this->isGlobalAdmin = $admin['isGlobalAdmin'];
$this->adminGroups = DBManager::getInstance()->getAdminGroupsByAdminID($aid);
$this->servers = DBManager::getInstance()->getAdminGroupServersByAdminId($aid);
$this->perms = array();
foreach ($this->adminGroups as $group) {
foreach ($group['adminOnServers'] as $serverId) {
foreach ($group['perms'] as $perm => $value) {
if ($perm != 'serverID' && $perm != 'groupID') {
if (!isset($this->perms[$serverId])) {
$this->perms[$serverId] = array();
}
$this->perms[$serverId][$perm] = $value;
}
}
}
}
} else {
$this->isGlobalAdmin = false;
$this->perms = DBManager::$defaultAdminGroupPerms;
$this->servers = array();
}
}
public function renderTableGestion()
{
$this->man = DBManager::getInstance();
//crea instancia
$this->man->connect();
//conectate a la bbdd
}
public function __construct($plugin_file = __FILE__)
{
$manager = DBManager::getInstance();
$manager->bootEloquent();
if (method_exists($this, 'up')) {
register_activation_hook($plugin_file, [$this, 'up']);
}
if (method_exists($this, 'down')) {
register_uninstall_hook($plugin_file, [$this, 'down']);
}
}
public function Cancerbero($Pagename)
{
if (!($this->man = DBManager::getInstance())) {
die("No se puede crear un DBManager");
} else {
if (!$this->man->connect()) {
die("No se puede conectar a la bd");
}
}
$this->page = $Pagename;
}
/**
*
* @param string $name
* @param string $pw
* @return void
* @throws Exception on failed login
*/
public function loginAsAdmin($name, $pw)
{
if (DBManager::getInstance()->checkAdminLogin($_POST['username'], $_POST['password'])) {
$_SESSION['adminLoggedIn'] = true;
$admin = DBManager::getInstance()->getAdminByName($name);
$_SESSION['adminLoggedInAs'] = $admin['id'];
} else {
Logger::log("[{$_SERVER['REMOTE_ADDR']}] failed to log in as admin {$name}.", Logger::LEVEL_SECURITY);
throw new Exception('Login failed');
}
}
function renderNavBar()
{
//Conexion a la BD
$db = DBManager::getInstance();
$db->connect();
$dbm = Driver::getInstance();
$navBar = new TemplateEngine();
//---x---x--- Por defecto ---x---x---
$navBar->log = 0;
//el usuario NO está logeado
$navBar->admin = 0;
//por lo tanto no puede ser administrador
$navBar->materia = 0;
//ni administrador de materia
$navBar->user_id = null;
//y no hay ID de usuario
//Se ha hecho login?
if (isset($_SESSION["name"])) {
//---x---x--- Si se ha hecho... ---x---x---
$navBar->log = 1;
//el usuario está logeado
$usuario = new Usuario($dbm);
$usuario = $usuario->findBy('user_name', $_SESSION['name']);
//CAMBIAME
$navBar->user_id = $usuario[0]->getUser_id();
//El usuario es un administrador?
if ($db->existUserRol($_SESSION["name"], "AdminApuntorium")) {
$navBar->admin = 1;
//el usuario es administrador
} else {
//El usuario es administrador de materia?
$administra = new Administra($dbm);
if ($administra->findBy('user_id', $usuario[0]->getUser_id()) != null) {
$navBar->materia = 1;
//el usuario administra una materia
}
}
} else {
}
return $navBar->render('navbar_v.php');
}
<?php
require "DBManager.inc";
require "viewer.inc";
getView("HeaderView.inc", null);
$host = "mysql.hostinger.com.ua";
$dbName = "u825515718_bbrat";
$user = "******";
$password = "******";
DBManager::getInstance()->connect($host, $dbName, $user, $password);
echo "<html><body><div id='feed' style='margin-left: 300px;'><div style='text-align:left'>";
$res = SQL("Select Name from Players order by Name DESC")->getAll();
foreach ($res as $player) {
echo "<p>" . $player['Name'] . "</p>";
}
echo "</div></div></body></html>";
/**
* Shortcut static method to retrieve the database connection for a given
* key.
*
* Example usage:
* @code
* // instead of
* $db = DBManager::getInstance()->getConnection("studip");
*
* // this can be shortened to
* $db = DBManager::get("studip");
*
* // or in this case (as "studip" is the default key)
* $db = DBManager::get();
* @endcode
*
* @param string the key
*
* @return StudipPDO the database connection
*/
public static function get($database = 'studip')
{
$manager = DBManager::getInstance();
return $manager->getConnection($database);
}
<?php
// Controlador de login hecho por FVieira.
session_start();
// se inicia el manejo de sesiones
require_once '../views/templateEngine.php';
// se carga la clase TemplateEngine
require_once '../cancerbero/php/DBManager.php';
// se carga el driver de cancerbero
require_once 'modal.php';
$db = DBManager::getInstance();
$db->connect();
$renderMain = new TemplateEngine();
$renderlogin = new TemplateEngine();
//instancias de TemplateEngine
$renderlogin->status = null;
//por defecto no hay ningun error (en la plantilla login_v la variable $status valdrá <br/>)
if (isset($_POST['name']) && isset($_POST['pass'])) {
// si ya se hizo algun post
if ($db->tryLogin($_POST['name'], $_POST['pass'])) {
//comprueba los datos nombre de Usuario y contrseña
$_SESSION["name"] = $_POST['name'];
header("location: home.php");
}
$status = "Usuario y/o contraseña invalido";
$contenido = "Por favor, compruebe sus datos de acceso y compruebe si no tiene la tecla bloq mayus activada";
$renderlogin->status = renderModalError($status, $contenido);
}
$renderMain->title = "Login";
$renderMain->navbar = null;
//el login no tiene navbar
public static function log_registration($uname)
{
DBManager::getInstance()->append('log_register.log', time() . ';' . $_SERVER['REMOTE_ADDR'] . ';' . $_SERVER['HTTP_REFERER'] . ';uname:' . $uname);
}
public function renderComboboxUsuario()
{
$this->man = DBManager::getInstance();
$this->man->connect();
}
///////////////////////////////////////////////////////////////////////////////
//// SETTING DEFAULT VAR VALUES
// Track the number of SQL queiries
$sql_queries = 0;
$GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
$error_notice = '';
$use_current_user_login = false;
// Allow for the session information to be passed via the URL for printing.
if (isset($_GET['PHPSESSID'])) {
if (!empty($_COOKIE['PHPSESSID']) && strcmp($_GET['PHPSESSID'], $_COOKIE['PHPSESSID']) == 0) {
session_id($_REQUEST['PHPSESSID']);
} else {
unset($_GET['PHPSESSID']);
}
}
if (!empty($sugar_config['session_dir'])) {
session_save_path($sugar_config['session_dir']);
}
$db =& DBManager::getInstance();
$dbmann = DBManager::getInstance();
$timedate = new TimeDate();
$locale = new Localization();
// Emails uses the REQUEST_URI later to construct dynamic URLs.
// IIS does not pass this field to prevent an error, if it is not set, we will assign it to ''.
if (!isset($_SERVER['REQUEST_URI'])) {
$_SERVER['REQUEST_URI'] = '';
}
$current_user = new User();
$current_entity = null;
//// END SETTING DEFAULT VAR VALUES
///////////////////////////////////////////////////////////////////////////////
function renderNavBar()
{
//Conexion a la BD
$db = DBManager::getInstance();
$db->connect();
$dbm = Driver::getInstance();
$navBar = new TemplateEngine();
//---x---x--- Por defecto ---x---x---
$navBar->log = 0;
//el usuario NO está logeado
$navBar->admin = 0;
//por lo tanto no puede ser administrador
$navBar->materia = 0;
//ni administrador de materia
$navBar->user_id = null;
//y no hay ID de usuario
//Se ha hecho login?
if (isset($_SESSION["name"])) {
//---x---x--- Si se ha hecho... ---x---x---
$navBar->log = 1;
//el usuario está logeado
$usuario = new Usuario($dbm);
$usuario = $usuario->findBy('user_name', $_SESSION['name']);
//CAMBIAME
$navBar->user_id = $usuario[0]->getUser_id();
//El usuario es un administrador?
if ($db->existUserRol($_SESSION["name"], "AdminApuntorium")) {
$navBar->admin = 1;
//el usuario es administrador
} else {
//El usuario es administrador de materia?
$administra = new Administra($dbm);
if ($administra->findBy('user_id', $usuario[0]->getUser_id()) != null) {
$navBar->materia = 1;
//el usuario administra una materia
}
}
//Gestión de notificaciones
$notificaciones = new Notificacion($dbm);
$notificaciones = $notificaciones->findBy("user_id", $navBar->user_id);
$navBar->nuevasNotificaciones = 0;
$navBar->nuevosApuntes = 0;
$navBar->displayNotificaciones = array();
$displayNotificaciones = array();
foreach ($notificaciones as $key) {
$navBar->nuevasNotificaciones = $navBar->nuevasNotificaciones + 1;
$tipo = preg_split("/[\\s,]+/", $key->getContenido(), null);
if ($tipo[0] == "Nuevos") {
$navBar->nuevosApuntes = $navBar->nuevosApuntes + 1;
} else {
if ($tipo[0] == "Ahora") {
$displayNotificaciones[$navBar->nuevasNotificaciones - $navBar->nuevosApuntes] = $key->getContenido();
//'</a>'REDIRECCIÓN PENDIENTE
} else {
$displayNotificaciones[$navBar->nuevasNotificaciones - $navBar->nuevosApuntes] = '<a href="misNotas.php">' . $key->getContenido() . '</a>';
}
}
}
if ($navBar->nuevosApuntes > 0) {
$displayNotificaciones[$navBar->nuevasNotificaciones - $navBar->nuevosApuntes] = '<a href="apuntesComunidad.php">' . $navBar->nuevosApuntes . ' nuevos apuntes en tus materias</a>';
}
$navBar->displayNotificaciones = $displayNotificaciones;
}
return $navBar->render('navbar_v.php');
}
} else {
if (isset($_GET['action']) && $_GET['action'] == 'dologin') {
// parse and handle login form data
try {
SessionManager::getInstance()->loginAsAdmin($_POST['username'], $_POST['password']);
$isLoggedIn = true;
echo '<script type="text/javascript">location.replace("?page=meta")</script>';
echo 'Login successfull.<br/>
Go on to the <a href="?page=meta">Meta Page</a>.';
} catch (Exception $exc) {
echo '<div class="infobox infobox_error">Login failed.</div>';
}
}
if (!$isLoggedIn) {
// display login form
if (!DBManager::getInstance()->doesAdminExist()) {
echo '<div class="infobox infobox_info">';
echo 'No admin Account exists yet.<br/>';
echo 'To create an account, <b>just log in with your desired login-credentials</b>. The account will automatically created for you!<br/><br/>';
echo 'If you experience problems and the account is not created for you, please check that your webserver has write permissions to the data folder.';
echo '</div>';
}
?>
<form class="mpi_login_form" action="?page=login&action=dologin" method="post" onsubmit="
if (jQuery('#mpi_login_username').attr('value').length == 0) {alert('You did not enter a username!'); return false;}
if (jQuery('#mpi_login_password').attr('value').length == 0) {alert('You did not enter a password!'); return false;}">
<label for="mpi_login_username">Username</label>
<input type="text" name="username" id="mpi_login_username" />
<label for="mpi_login_password">Password</label>
<input type="password" name="password" id="mpi_login_password" />
<input type="submit" value="Login" />
function &getInstance($instanceName = '')
{
$instance = DBManager::getInstance($instanceName);
return $instance;
}
function getSystemInfo($send_usage_info = true)
{
global $sugar_config;
global $db, $authLevel;
$info = array();
include 'sugar_version.php';
$info['sugar_version'] = $sugar_version;
$info['sugar_flavor'] = $sugar_flavor;
if ($send_usage_info) {
$info['sugar_db_version'] = $sugar_db_version;
if ($authLevel > 0) {
if (isset($_SERVER['SERVER_ADDR'])) {
$info['ip_address'] = $_SERVER['SERVER_ADDR'];
} else {
$info['ip_address'] = '127.0.0.1';
}
}
$info['application_key'] = $sugar_config['unique_key'];
$info['php_version'] = phpversion();
$info['server_software'] = $_SERVER['SERVER_SOFTWARE'];
//get user count.
$user_list = get_user_array(false);
$info['users'] = count($user_list);
$query = "select count(*) count from users where status='Active' and deleted=0 and is_admin='1'";
$result = $db->query($query, 'fetching admin count', false);
$row = $db->fetchByAssoc($result);
if (!empty($row)) {
$info['admin_users'] = $row['count'];
}
if (empty($authLevel)) {
$authLevel = 0;
}
$query = "select count(*) count from users";
$result = $db->query($query, 'fetching all users count', false);
$row = $db->fetchByAssoc($result);
if (!empty($row)) {
$info['registered_users'] = $row['count'];
}
$lastMonth = db_convert("'" . date('Y-m-d H:i:s', strtotime('-1 month')) . "'", 'datetime');
if (!$send_usage_info) {
$info['users_active_30_days'] = -1;
} else {
$query = "SELECT count( DISTINCT users.id ) user_count FROM tracker, users WHERE users.id = tracker.user_id AND tracker.date_modified >= {$lastMonth}";
$result = $db->query($query, 'fetching last 30 users count', false);
$row = $db->fetchByAssoc($result);
$info['users_active_30_days'] = $row['user_count'];
}
if (!$send_usage_info) {
$info['latest_tracker_id'] = -1;
} else {
$query = "select id from tracker order by date_modified desc";
$result = $db->query($query, 'fetching most recent tracker entry', false);
$row = $db->fetchByAssoc($result);
if (!empty($row)) {
$info['latest_tracker_id'] = $row['id'];
}
}
$dbManager =& DBManager::getInstance();
$info['db_type'] = $sugar_config['dbconfig']['db_type'];
$info['db_version'] = $dbManager->version();
}
$info['auth_level'] = $authLevel;
return $info;
}
/**
* cleans up temp tables created during schema test phase
*/
function testCleanUp($dbType)
{
logThis('Cleaning up temporary tables...');
global $db;
if (empty($db)) {
$db = DBManager::getInstance();
}
$error = '';
switch ($dbType) {
case 'mysql':
$q = 'SHOW TABLES LIKE "%__uw_temp"';
$r = $db->query($q, false, "Preflight Failed for: {$q}");
// using raw mysql_command to use integer index
while ($a = mysql_fetch_row($r)) {
logThis('Dropping table: ' . $a[0]);
$qClean = "DROP TABLE {$a[0]}";
$rClean = $db->query($qClean);
}
break;
case 'mssql':
break;
case 'oci8':
break;
}
logThis('Done cleaning up temp tables.');
return $error;
}
public function renderTable()
{
$this->man = DBManager::getInstance();
$this->man->connect();
}
/** This function returns the correct instance of the manager
* depending on the database type
*/
function &getInstance($instanceName = '')
{
global $sugar_config;
$temp_var =& DBManager::getInstance($instanceName);
return $temp_var;
}
/**
* Constructor
*/
public function __construct()
{
$this->dbmanager = DBManager::getInstance();
}
include "../views/header.php";
RenderBanner("Gestión de Usuarios");
cerberus("CER_ModificarUsuario");
$Idioma = getIdioma();
?>
<div id="contenido" class="container">
<div class="row">
<?php
include "../views/lateral.php";
RenderLateral(0);
?>
<?php
require_once "../php/DBManager.php";
$man = DBManager::getInstance();
$man->connect();
if (!($redirect = $man->getMinIDUser())) {
header('Location: ../views/error.php?ID=e18');
} else {
if (!isset($_GET["id"])) {
//cambiar por funcion que devuelva la primera id ocupada
header('Location: ModificarUsuario.php?id=' . $redirect["user_id"] . '');
} else {
echo '<div class="col-md-9 col-sm-12">';
echo '<form action="../php/GestionUsuarios/process_modificarUsuario.php?="' . $_GET["id"] . ' method="post" ' . 'id="formulario">';
require_once "../views/renderTable.php";
require_once "../views/renderCombobox.php";
$table_maker = new RenderTable();
$combo_maker = new renderCombobox();
echo '<h1>' . $Idioma['Modificar usuario'];
DBManager::getInstance()->addAwaitingAccount($_POST['serverid'], $_POST['name'], $_POST['password'], $_POST['email']);
echo tr('register_success_toActivate');
Logger::log_registration($_POST['name']);
} else {
// Server does not exist, add warning
MessageManager::addWarning(tr('unknownserver'));
}
} else {
// non-auth-by-mail, just add registration
ServerInterface::getInstance()->addUser($_POST['serverid'], $_POST['name'], $_POST['password'], $_POST['email']);
echo tr('register_success');
Logger::log_registration($_POST['name']);
}
} elseif ($_GET['action'] == 'activate' && isset($_GET['key'])) {
// Activate account
DBManager::getInstance()->activateAccount($_GET['key']);
echo tr('register_activate_success');
}
} else {
// no form data received -> display registration form
?>
<div id="content">
<h1><?php
echo tr('register_title');
?>
</h1>
<form action="./?page=register&action=doregister" method="post" style="width:400px;">
<table class="fullwidth">
<tr>
<td class="formitemname"><?php
/**
* requires group id 'aid' as _POST
*/
public static function db_admin_addToGroup_display()
{
if (!PermissionManager::getInstance()->serverCanEditAdmins()) {
return;
}
$aid = intval($_POST['aid']);
$admin = DBManager::getInstance()->getAdmin($aid);
$groups = DBManager::getInstance()->getAdminGroups();
echo 'Add ' . $admin['name'] . ' to group:<br/>';
echo '<ul>';
foreach ($groups as $group) {
echo '<li><a class="jqlink" onclick="jq_admin_addToGroup(' . $aid . ', ' . $group['id'] . ');">' . $group['name'] . '</a></li>';
}
echo '</ul>';
}
// command line or http request?
if (isset($_SERVER['REQUEST_METHOD'])) {
set_exception_handler('studip_default_exception_handler');
}
// set default pdo connection
DBManager::getInstance()->setConnection('studip', 'mysql:host=' . $GLOBALS['DB_STUDIP_HOST'] . ';dbname=' . $GLOBALS['DB_STUDIP_DATABASE'], $GLOBALS['DB_STUDIP_USER'], $GLOBALS['DB_STUDIP_PASSWORD']);
// set slave connection
if (isset($GLOBALS['DB_STUDIP_SLAVE_HOST'])) {
try {
DBManager::getInstance()->setConnection('studip-slave', 'mysql:host=' . $GLOBALS['DB_STUDIP_SLAVE_HOST'] . ';dbname=' . $GLOBALS['DB_STUDIP_SLAVE_DATABASE'], $GLOBALS['DB_STUDIP_SLAVE_USER'], $GLOBALS['DB_STUDIP_SLAVE_PASSWORD']);
} catch (PDOException $exception) {
// if connection to slave fails, fall back to master instead
DBManager::getInstance()->aliasConnection('studip', 'studip-slave');
}
} else {
DBManager::getInstance()->aliasConnection('studip', 'studip-slave');
}
//include 'tools/debug/StudipDebugPDO.class.php';
/**
* @deprecated
*/
class DB_Seminar extends DB_Sql
{
function DB_Seminar($query = false)
{
$this->Host = $GLOBALS['DB_STUDIP_HOST'];
$this->Database = $GLOBALS['DB_STUDIP_DATABASE'];
$this->User = $GLOBALS['DB_STUDIP_USER'];
$this->Password = $GLOBALS['DB_STUDIP_PASSWORD'];
parent::DB_Sql($query);
}
