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); }