public static function GetSeqNextValue(DataAccess $dataaccess, $table_name, $col_name, $count = 1) { if ($count == 1) { $ds = $dataaccess->GetData("seq", "call p_seq_nextvalue(?, ?, 0, @nextvalue)", array((string) $table_name, (string) $col_name)); return $ds["seq"]["rows"][0]["nextvalue"]; } else { $ds = $dataaccess->GetData("seq", "call p_seq_batchvalue(?, ?, ?, 0, @nextvalue)", array((string) $table_name, (string) $col_name, (int) $count)); return $ds["seq"]["rows"][0]["nextvalue"]; } }
public static function userExist($user) { $dataAccess = new DataAccess(); $data = $dataAccess->getUser($user); if (count($data) == 0) { return false; } else { return $data[0]; } }
/** * execute and get the last insert id * * @param string $sql statement (INSERT INTO ...) * * @return int the last insert id or false if there is an error */ protected function updateAndGetLastId($sql) { if ($inserted = $this->update($sql)) { $inserted = $this->da->lastInsertId(); } return $inserted; }
public function GetCategories() { if (!$this->Categories) { $this->Categories = DataAccess::GetCategoriesByUserID($this->ID); } return $this->Categories; }
public function Execute() { $viewData = array(); $errors = array(); if (Helper::IsLoggedInAdmin() && isset($_GET["loginAsUser"])) { // login as a certain user and redirect to his page if (Helper::LoginUserByUsername($_GET["loginAsUser"])) { Helper::Redirect("index.php?" . Helper::CreateQuerystring(getCurrentUser())); } } $viewData["Users"] = DataAccess::GetAllUsers(!Helper::IsLoggedInAdmin()); $viewData["LastMapForEachUser"] = DataAccess::GetLastMapsForUsers("date"); // last x maps $numberOfMaps = isset($_GET["lastMaps"]) && is_numeric($_GET["lastMaps"]) ? (int) $_GET["lastMaps"] : (isset($_GET["lastMaps"]) && $_GET["lastMaps"] == "all" ? 999999 : 10); $viewData["LastMaps"] = DataAccess::GetMaps(0, 0, 0, 0, null, $numberOfMaps, "createdTime", Helper::GetLoggedInUserID()); // last x comments $numberOfComments = isset($_GET["lastComments"]) && is_numeric($_GET["lastComments"]) ? (int) $_GET["lastComments"] : (isset($_GET["lastComments"]) && $_GET["lastComments"] == "all" ? 999999 : 10); $viewData["LastComments"] = DataAccess::GetLastComments($numberOfComments, Helper::GetLoggedInUserID()); $viewData["OverviewMapData"] = null; $categories = DataAccess::GetCategoriesByUserID(); foreach ($viewData["LastMaps"] as $map) { $data = Helper::GetOverviewMapData($map, false, true, true, $categories); if ($data != null) { $viewData["OverviewMapData"][] = $data; } } if (isset($_GET["error"]) && $_GET["error"] == "email") { $errors[] = sprintf(__("ADMIN_EMAIL_ERROR"), ADMIN_EMAIL); } $viewData["Errors"] = $errors; return $viewData; }
public function GetUser() { if (!$this->User) { $this->User = DataAccess::GetUserByID($this->UserID); } return $this->User; }
public function GetCategory() { if (!$this->Category) { $this->Category = DataAccess::GetCategoryByID($this->CategoryID); } return $this->Category; }
function executeDatabaseScripts() { $allScripts = getScripts(); $errors = array(); foreach ($allScripts as $s) { // check whether scripts should be run if (isset($s["conditionFunction"])) { $f = $s["conditionFunction"]; $runScripts = $f($s["conditionData"]); } else { $runScripts = true; } if ($runScripts) { foreach ($s["scripts"] as $script) { mysql_query($script); Helper::WriteToLog($script); $error = getMySQLErrorIfAny(); if ($error) { Helper::WriteToLog($error); $errors[] = $error; } } } } if (count($errors) == 0) { DataAccess::SetSetting("DATABASE_VERSION", DOMA_VERSION); } return array("errors" => $errors); }
/** * Get's a singleton instance of this object. * * @return object (PDO) singleton instance of this object. */ public static function getInstance() { if (!self::$instance) { self::$instance = new PDO(DB_CONNECTION, DB_USER, DB_PASSWORD); self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } return self::$instance; }
function getMapCornerPositionsAndRouteCoordinates($id) { $map = new Map(); $map->Load($id); $user = DataAccess::GetUserByID($map->UserID); $categories = DataAccess::GetCategoriesByUserID($user->ID); return Helper::GetOverviewMapData($map, true, false, false, $categories); }
public function Execute() { $viewData = array(); // no user specified - redirect to user list page if (!getCurrentUser()) { Helper::Redirect("users.php"); } // user is hidden - redirect to user list page if (!getCurrentUser()->Visible) { Helper::Redirect("users.php"); } // the requested map $map = new Map(); $map->Load($_GET["map"]); if (!$map->ID) { die("The map has been removed."); } DataAccess::UnprotectMapIfNeeded($map); if (Helper::MapIsProtected($map)) { die("The map is protected until " . date("Y-m-d H:i:s", Helper::StringToTime($map->ProtectedUntil, true)) . "."); } if ($map->UserID != getCurrentUser()->ID) { die; } $viewData["Comments"] = DataAccess::GetCommentsByMapId($map->ID); $viewData["Name"] = $map->Name . ' (' . date(__("DATE_FORMAT"), Helper::StringToTime($map->Date, true)) . ')'; // previous map in archive $previous = DataAccess::GetPreviousMap(getCurrentUser()->ID, $map->ID, Helper::GetLoggedInUserID()); $viewData["PreviousName"] = $previous == null ? null : $previous->Name . ' (' . date(__("DATE_FORMAT"), Helper::StringToTime($previous->Date, true)) . ')'; // next map in archive $next = DataAccess::GetNextMap(getCurrentUser()->ID, $map->ID, Helper::GetLoggedInUserID()); $viewData["NextName"] = $next == null ? null : $next->Name . ' (' . date(__("DATE_FORMAT"), Helper::StringToTime($next->Date, true)) . ')'; $size = $map->GetMapImageSize(); $viewData["ImageWidth"] = $size["Width"]; $viewData["ImageHeight"] = $size["Height"]; DataAccess::IncreaseMapViews($map); $viewData["Map"] = $map; $viewData["BackUrl"] = isset($_SERVER["HTTP_REFERER"]) && basename($_SERVER["HTTP_REFERER"]) == "users.php" ? "users.php" : "index.php?" . Helper::CreateQuerystring(getCurrentUser()); $viewData["Previous"] = $previous; $viewData["Next"] = $next; $viewData["ShowComments"] = isset($_GET["showComments"]) && ($_GET["showComments"] = true) || !__("COLLAPSE_VISITOR_COMMENTS"); $viewData["FirstMapImageName"] = Helper::GetMapImage($map); if ($map->BlankMapImage) { $viewData["SecondMapImageName"] = Helper::GetBlankMapImage($map); } $viewData["QuickRouteJpegExtensionData"] = $map->GetQuickRouteJpegExtensionData(); if (isset($viewData["QuickRouteJpegExtensionData"]) && $viewData["QuickRouteJpegExtensionData"]->IsValid) { $categories = DataAccess::GetCategoriesByUserID(getCurrentUser()->ID); $viewData["OverviewMapData"][] = Helper::GetOverviewMapData($map, true, false, false, $categories); $viewData["GoogleMapsUrl"] = "http://maps.google.com/maps" . "?q=" . urlencode(Helper::GlobalPath("export_kml.php?id=" . $map->ID . "&format=kml")) . "&language=" . Session::GetLanguageCode(); } if (USE_3DRERUN == '1' && DataAccess::GetSetting("LAST_WORLDOFO_CHECK_DOMA_TIME", "0") + RERUN_FREQUENCY * 3600 < time()) { $viewData["RerunMaps"] = Helper::GetMapsForRerunRequest(); $viewData["TotalRerunMaps"] = count(explode(",", $viewData["RerunMaps"])); $viewData["ProcessRerun"] = true; } return $viewData; }
private function getRoles() { $rolesUsuario = new Rol(); $roles = DataAccess::selectWhere($rolesUsuario, $usuario->idUsuario); $count = count($roles); for ($i = 0; $i < $count; $i++) { $rolname = NameRoles::getName($roles['id_rol_roles']); $rolUsuario = new Rol($roles); $rolesSession[$rolname] = $rolUsuario; $menuSession[$rolname] = $rolname; } }
function canuse($pid) { $p = new DataAccess(); $sql = "select pid from problem where pid = {$pid} and submitable = 1"; $cnt = $p->dosql($sql); if ($cnt == 0) { return false; } if ($_SESSION['ID']) { $sql = "SELECT * FROM submit WHERE pid = {$pid} AND uid ={$_SESSION['ID']} order by accepted desc limit 1"; $ac = $p->dosql($sql); if ($ac) { $e = $p->rtnrlt(0); if ($e['accepted']) { return false; } else { true; } } } return true; }
protected final function getDependencias($allData = false) { $dependencia = new Dependencia(); $dependencias = DataAccess::selectWhere($dependencia); if ($allData) { return $dependencias; } $count = count($dependencias); for ($index = 0; $index < $count; $index++) { //array asociativo idempresa-nombre $id_Dependencia[$dependencias[$index]['iddependencia']] = $dependencias[$index]['nombre']; } return $id_Dependencia; }
protected final function getLineas($allData = false) { $linea = new Linea(); $lineas = DataAccess::selectWhere($linea); if ($allData) { return $lineas; } $count = count($lineas); for ($index = 0; $index < $count; $index++) { //array asociativo idempresa-nombre $id_Linea[$lineas[$index]['idlinea']] = $lineas[$index]['nombre']; } return $id_Linea; }
protected final function getEmpresas($allData = false) { $empresa = new Empresa(); $empresas = DataAccess::selectWhere($empresa); if ($allData) { return $empresas; } $count = count($empresas); for ($index = 0; $index < $count; $index++) { //array asociativo idempresa-nombre $id_Empresa[$empresas[$index]['idempresa']] = $empresas[$index]['nombre']; } return $id_Empresa; }
public function Execute() { $viewData = array(); // load session session_start(); Helper::SetUser(null); $errors = array(); // load strings Session::SetLanguageStrings(Helper::GetLanguageStrings()); // check php version if (version_compare(phpversion(), "5.0.0") < 0) { $errors[] = sprintf(__("TOO_OLD_PHP_VERSION"), phpversion()); } if (count($errors) == 0) { if (Helper::DatabaseVersionIsValid()) { $errors[] = __("SITE_ALREADY_CREATED"); } if (count($errors) == 0) { $previousDatabaseVersion = DataAccess::GetSetting("DATABASE_VERSION", "0.0"); // create or update database $result = executeDatabaseScripts(); $errors = $result["errors"]; // chmod only has effect on linux/unix systems @mkdir(Helper::LocalPath(MAP_IMAGE_PATH)); @chmod(Helper::LocalPath(MAP_IMAGE_PATH), 0777); @mkdir(Helper::LocalPath(TEMP_FILE_PATH)); @chmod(Helper::LocalPath(TEMP_FILE_PATH), 0777); if (count($errors) == 0) { if ($previousDatabaseVersion == "0.0") { // created databse Helper::LogUsage("createSite", "version=" . DOMA_VERSION); Helper::LoginAdmin(ADMIN_USERNAME, ADMIN_PASSWORD); } else { // updated database Helper::LogUsage("updateSite", "oldVersion={$previousDatabaseVersion}&newVersion=" . DOMA_VERSION); // redirect to originally requested page $redirectUrl = $_GET["redirectUrl"]; if (!isset($redirectUrl)) { $redirectUrl = "users.php"; } Helper::Redirect($redirectUrl); } } } } $viewData["Errors"] = $errors; return $viewData; }
public function Execute() { $viewData = array(); $errors = array(); $comment = new Comment(); // no user specified - redirect to user list page if (isset($_POST["comment_text"])) { $comment->Comment = stripslashes(strip_tags(urldecode($_POST["comment_text"]))); } else { die("No comment text"); } if (isset($_POST["user_name"])) { $comment->Name = stripslashes(strip_tags(urldecode($_POST["user_name"]))); } else { die("No user name"); } if (isset($_POST["map_id"]) && is_numeric($_POST["map_id"])) { $comment->MapID = $_POST["map_id"]; } else { die("No valid map ID"); } if (isset($_POST["user_email"])) { $comment->Email = stripslashes(strip_tags($_POST["user_email"])); } $comment->UserIP = $_SERVER['REMOTE_ADDR']; $comment->DateCreated = date("Y-m-d H:i:s"); $comment->Save(); $map = new Map(); $map->Load($comment->MapID); if (__("EMAIL_VISITOR_COMMENTS") && $map->UserID != Helper::GetLoggedInUser()->ID) { $user = DataAccess::GetUserByID($map->UserID); $fromName = __("DOMA_ADMIN_EMAIL_NAME"); $subject = __("NEW_COMMENT_EMAIL_SUBJECT"); $mapAddress = Helper::GlobalPath("show_map.php?user="******"&map=" . $map->ID . "&showComments=true"); $body = sprintf(__("NEW_COMMENT_EMAIL_BODY"), $map->Name, $mapAddress, $comment->Name, $comment->Email, $comment->Comment); $emailSentSuccessfully = Helper::SendEmail($fromName, $user->Email, $subject, $body); if (!$emailSentSuccessfully) { $errors[] = __("EMAIL_ERROR"); } } $viewData["Errors"] = $errors; $viewData["Comment"] = $comment; $viewData["Map"] = $map; return $viewData; }
protected function PrepareAndExecuteQuery($query, $params) { $stmt = parent::PrepareAndExecuteQuery($query, $params); if (!$stmt) { // If this was a general error, attempt to reconnect and retry the query // UPDATED: Only care about specific general errors if ($this->errno == 'HY000' && strpos($this->errorMsg, 'General error: 2006 MySQL server has gone away') !== false) { echo "Database Error. Waiting 1 minute before attempting to Reconnect.\n"; sleep(60); echo "Attempting to reconnect...\n"; $this->conn = null; $this->connect($this->host, $this->user, $this->pass, $this->dbname); if (!$this->hasError()) { return parent::PrepareAndExecuteQuery($query, $params); } echo "Reconnect Failed\n"; return false; } } return $stmt; }
protected final function consultarMarcas() { return DataAccess::selectWhere($this->marca, " "); }
<?php error_reporting(E_ALL & ~E_NOTICE); include_once dirname(__FILE__) . "/../config.php"; include_once dirname(__FILE__) . "/definitions.php"; // set character encoding header('Content-Type: text/html; charset=utf-8'); // load session session_start(); // create database if it does not exist if (!Helper::DatabaseVersionIsValid()) { Helper::Redirect("create.php?redirectUrl=" . urlencode($_SERVER["REQUEST_URI"])); } // extract current user from querystring if (isset($_GET["user"])) { $currentUser = getCurrentUser(); if (!$currentUser || $currentUser->Username != $_GET["user"] || !Session::GetLanguageStrings() || isset($_GET["lang"]) && Session::GetLanguageCode() != $_GET["lang"]) { Helper::SetUser(DataAccess::GetUserByUsername($_GET["user"])); } } else { Helper::SetUser(null); }
public static function setConexion(Conexion $conexion) { self::$dbcon = $conexion->getConexion(); }
<?php require_once "../include/header.php"; $uid = (int) $_SESSION['ID']; $pid = (int) $_GET['pid']; $p = new DataAccess(); $sql = "select problem.*,groups.* from problem,groups where pid=" . (int) $_GET[pid] . " and groups.gid=problem.group limit 1"; $cnt = $p->dosql($sql); $d = $p->rtnrlt(0); $title = $d['probname']; gethead(1, "", $pid . ". " . $title); $LIB->hlighter(); $LIB->mathjax(); $q = new DataAccess(); $r = new DataAccess(); if ($cnt) { if ($d[readforce] > $_SESSION[readforce]) { 异常("没有阅读权限!", 取路径("problem/index.php")); } if (!$d[submitable] && !有此权限('查看题目') && $d['addid'] != $uid) { 异常("该题目不可提交!", 取路径("problem/index.php")); } $subgroup = $LIB->getsubgroup($q, $d['gid']); $subgroup[0] = $d['gid']; $promise = false; if ($uid == $d['addid']) { $promise = true; } foreach ($subgroup as $value) { if ($value == (int) $_SESSION['group']) { $promise = true;
<?php header('Content-Type:text/html;charset=utf-8'); /* * 抽象工厂模式【多类型数据库】 * Author: Kaysen */ $dirList = 'User' . DIRECTORY_SEPARATOR . '; '; $dirList .= 'Department' . DIRECTORY_SEPARATOR; define('__AUTOLOAD_DIR__', $dirList); define('ROOT_PATH', dirname(__FILE__)); require_once ROOT_PATH . '/../../Loader.php'; $user = new User(); $dept = new Department(); $IUser = DataAccess::createUser(); $IUser->insert($user); $IUser->getUser(1); $IDepar = DataAccess::createDepartment(); $IDepar->insert($dept); $IDepar->getDepartment(2);
<?php require_once "../include/header.php"; gethead(1, "sess", "评测"); if (!$_POST['pid']) { 异常("你来错地方了!"); } $LIB->hlighter(); $LIB->func_socket(); $p = new DataAccess(); $sql = "select * from problem where pid={$_POST['pid']}"; $p->dosql($sql); $d = $p->rtnrlt(0); if (!$d['submitable'] && !有此权限('查看题目')) { 异常("不可提交!", 取路径("problem/index.php")); } $lang = langstrtonum($_POST['lang']); $info = array(); $info['pid'] = $_POST['pid']; $info['sid'] = $_POST['sid']; $info['uid'] = $_SESSION['ID']; $info['language'] = $lang; $info['pname'] = $d['filename']; $info['datacnt'] = $d['datacnt']; $info['timelimit'] = $d['timelimit']; $ptitle = $d['probname']; $info['memorylimit'] = $d['memorylimit']; $info['plugin'] = $d['plugin']; $info['compiledir'] = $SET['dir_source']; $info['mode'] = "normal"; if ($_POST['testmode'] == '1' && 有此权限('测试题目')) {
<?php require_once "../include/header.php"; gethead(1, "sess", "邮件列表"); $uid = $_SESSION['ID']; $p = new DataAccess(); $q = new DataAccess(); if ($_GET['toid']) { $_POST['title'] = "给" . $_GET['toid'] . "的邮件"; } ?> <div class='center'> <a class='btn btn-success' href="#sendmail" data-toggle='modal'><i class='icon-envelope icon-white'></i>发送信件</a> </div> <div id='sendmail' class='modal hide fade in'> <form method="post" action="send.php" class='form-horizontal'> <fieldset> <div class='modal-header'> <button class='close' data-dismiss='modal'>×</button> <h3>发送信件</h3> </div> <div class='modal-body'> <input name="fromid" type="hidden" value="<?php echo $uid; ?> " /> <div class='control-group'> <label class='control-label' for='title'>邮件主题</label> <div class='controls'><input type='text' id='title' name="title" value="<?php echo $_POST['title']; ?>
protected final function consultarEstadoArticulo() { return DataAccess::selectWhere($this->estadoArticulo, " "); }
$pwd = $_REQUEST['pwdhash']; if (!$usr) { $usr = $_COOKIE['cogs_usr']; } if (!$pwd) { $pwd = $_COOKIE['cogs_pwd_hash']; } $sql = "select * from userinfo where usr='******'"; $cnt = $p->dosql($sql); if ($cnt == 0) { i异常("用户不存在!", 取路径("user/login.php")); } else { $d = $p->rtnrlt(0); if ($pwd == $d['pwdhash'] || encode($_REQUEST['password']) == $d['pwdhash']) { $LIB->get_userinfo($d['uid']); $q = new DataAccess(); $sql = "UPDATE `userinfo` SET `lastip` = '{$_SERVER['REMOTE_ADDR']}' WHERE `uid` ={$d['uid']}"; $q->dosql($sql); $sql = "insert into login(uid,ua,ip,ltime,version) values({$d['uid']},'" . mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']) . "','{$_SERVER['REMOTE_ADDR']}',NOW(),'" . mysql_real_escape_string($cfg['dir_root']) . "')"; if ($SET['login_log']) { $q->dosql($sql); } if ($_REQUEST['savepwd']) { $tm = time() + 7776000; setcookie("cogs_usr", $usr, $tm, "/"); setcookie("cogs_pwd_hash", $d['pwdhash'], $tm, "/"); } if (!$_REQUEST['from']) { $_REQUEST['from'] = base64_encode("/" . $SET['global_root']); } i提示("用户 {$d['nickname']} 登录成功!{$_REQUEST['savepwd']}", $_REQUEST['from']);
<?php require_once 'DataAccess.php'; require_once 'includes/functions.php'; $name = $_POST['name']; //user info $id = 1; $userName = "******"; $email = "*****@*****.**"; $description = $_POST['description']; $stars = $_POST['stars']; $latitude = $_POST['latitude']; $longitude = $_POST['longitude']; $now = getCurrentDateTime(); $sql = "INSERT INTO problems VALUES (null,'{$name}', '{$id}', '{$userName}', '{$email}','{$description}',null, 'fn','{$now}', 0, '{$now}', 'Active','{$stars}','{$latitude}','{$longitude}')"; $data = new DataAccess('photo'); $result = $data->executeQuery($sql); $pid = mysql_insert_id(); if (!$result) { echo mysql_error(); return; } $data->dispose(); return $pid;
?> <div class="page-container" data-bind="if: currentView() === 'high-scores'"> <div class="well"> <h2>High Scores</h2> <table class="table table-border"> <thead> <tr> <th></th> <th>Level</th> <th>Score</th> <th>Date</th> </tr> </thead> <tbody> <?php $data_access = new DataAccess(); $highscores_array = $data_access->get_highscores(); foreach ($highscores_array as $row) { $date = date_create($row['end']); $dateScore = date_format($date, 'l, F jS, Y \\a\\t g:ia'); echo '<tr>'; echo '<td><img src="pics/Robot_Character1_Blue.png" height="60"/></td>'; echo '<td>' . $row['level_id'] . '</td>'; echo '<td>' . $row['highscore'] . '</td>'; echo '<td>' . $dateScore . '</td>'; echo '</tr>'; } ?> </tbody> </table> </div>