public static function getCategorias()
{
$stmt = DBConn::getInstance()->prepare("SELECT * FROM categoria");
$stmt->execute();
$lista = array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$u = new CadastroCategoria();
foreach ($row as $k => $v) {
$u->{$k} = $v;
}
$lista[] = $u;
}
return $lista;
}
public static function getFotosAlbum($album)
{
$stmt = DBConn::getInstance()->prepare("SELECT * FROM imagens WHERE id_album = {$album}");
$stmt->execute();
$lista = array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$u = new CadastroAlbum();
foreach ($row as $k => $v) {
$u->{$k} = $v;
}
$lista[] = $u;
}
return $lista;
}
/**
* Връща модел за текущия потребител
*
* Ако има $_SESSION['user_id'] се връща модел,
* с това което е успял да зареди, в противен случай
* се връща false
*
* @return mixed: User|boolean
*/
static function loadCurrentUser()
{
if (empty($_SESSION['user_id'])) {
return false;
}
if ($_SESSION['user_serialized']) {
$_SESSION['user'] = unserialize($_SESSION['user_serialized']);
$_SESSION['user']->dbconn = DBConn::getInstance()->conn;
} else {
$model_user = new User(DBConn::getInstance()->conn, $_SESSION['user_id']);
$model_user->fetch();
$_SESSION['user'] = $model_user;
$_SESSION['user_serialized'] = serialize($model_user);
}
return $_SESSION['user'];
}
public static function delete($id)
{
$cont = 0;
$stmt = DBConn::getInstance()->prepare("DELETE FROM imagens WHERE id_album = {$id}");
if (!$stmt->execute()) {
$cont++;
}
$stmt = DBConn::getInstance()->prepare("DELETE FROM album WHERE id = {$id}");
if (!$stmt->execute()) {
$cont++;
}
if ($cont == 0) {
return true;
} else {
return false;
}
}
/**
* Função para buscar se existe o email cadastrado
* @access static
* @param $id, id para pesquisa de usuario
* @return instancia do usuario
*/
public function findEmailUsuario($email)
{
$st = DBConn::getInstance()->prepare("SELECT * FROM usuario WHERE email = :email");
$st->bindParam(":email", $email, PDO::PARAM_INT);
$st->execute();
//Obtém o registro encontrado
$row = $st->fetch(PDO::FETCH_ASSOC);
return $row;
}
function __construct()
{
$this->dbconn = DBConn::getInstance()->conn;
$this->smarty = SmartyInstance::getInstance()->smarty;
$this->system = system::getInstance($this->dbconn);
}
// HTTP/1.0
header("Pragma: no-cache");
//error_reporting(-1);
//ini_set('display_errors', 1);
//path properties
define('MAIN_PATH', $mainPath);
define('ROOT_PATH', $rootPath);
define('MAIN_DIR', $mainDir);
//DB config
define('DB_HOST', "10.10.10.120");
define('DB_NAME', "tree_editor");
define('DB_USER', "root");
define('DB_PASS', "`12345';';");
//DB config ENSEMBL
define('DB_HOST_ENSEMBL', "gramenedb.gramene.org");
define('DB_NAME_ENSEMBL', "ensembl_compara_plants_40_74");
define('DB_USER_ENSEMBL', "anonymous");
define('DB_PASS_ENSEMBL', "gramene");
//includes
require_once $libDir . 'smarty/SmartyBC.class.php';
require_once $libDir . 'smarty/SmartyInstance.class.php';
// create object
$smarty = SmartyInstance::getInstance()->smarty;
require_once $libDir . "adodb/adodb.inc.php";
require_once $libDir . "adodb/DBConn.class.php";
require_once $libDir . "classes/all_classes.inc.php";
require_once $rootPath . "php/all_controllers.inc.php";
//database connect
$dbconn = DBConn::getInstance()->conn;
$system = system::getInstance($dbconn);
$smarty->assign('mainDir', $mainDir);
public function del($archive = 0)
{
$q = "DELETE FROM " . $this->dbdata_table . " WHERE id=? ";
$st = $this->dbconn->Prepare($q);
$r = $this->dbconn->Execute($st, array($this->id));
if (!$r) {
$_SESSION['hidden_error'] = "Could not fetch the " . get_class($this) . " record! " . $this->dbconn->ErrorMsg();
return false;
}
//generate log
if ($this->dbdata_table == 'profiles' || $this->dbdata_table == 'contents' and $archive == 1) {
$cols_update = array();
$vars_update = array();
$cols_update[] = 'event';
$vars_update[] = 'delete';
$cols_update[] = 'event_id';
$vars_update[] = $this->id;
$cols_update[] = 'event_profile_id';
$vars_update[] = $_SESSION['profile_id'];
$cols_update[] = 'event_date';
$vars_update[] = date("Y-m-d H:i:s");
$dbconn_archive = DBConn::connectArchive();
$q_archive = "INSERT INTO " . $this->dbdata_table . "(" . implode(",", $cols_update) . ") VALUES (" . str_repeat("?,", count($vars_update) - 1) . "?)";
$st_archive = $dbconn_archive->Prepare($q_archive);
$r_archive = $dbconn_archive->Execute($st_archive, $vars_update);
}
$dbconn = DBConn::getInstance()->conn;
$this->dbconn = $dbconn;
return true;
}
