/** * returns instance of the class (Singleton Design Pattern) * @return <type> */ public static function get_instance() { if (!isset(self::$instance)) { self::$instance = new ErrorLog(); } return self::$instance; }
/** * 初始化操作 * @return ErrorLog */ public static function init() { if (!isset(self::$selfObject)) { self::$selfObject = new ErrorLog(); } return self::$selfObject; }
public function loadModel($id) { $model = ErrorLog::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
function testErrorLog() { $this->startCodeCoverage(); $errorlog = new ErrorLog(); $errorlog->Clean(7); $errorlog->BuildId = "foo"; if ($errorlog->Insert()) { $this->fail("Insert() should return false when BuildId is non-numeric"); return 1; } $errorlog->BuildId = 1; $errorlog->Description = "example error description"; $errorlog->Insert(); $this->pass("Passed"); $this->stopCodeCoverage(); return 0; }
/** * @return boolean */ public function undelete() { try { $this->deleted = 0; self::db()->update($this->table, array('deleted' => 0), $this->getPrimaryKey()); } catch (Exception $e) { ErrorLog::append($e); return false; } return true; }
/** * Creates new record in Errors log * @param $error_category * @param $msg * @param $errLevel */ public static function createLogRecord($error_category, $msg, $errLevel) { $errorLog = new ErrorLog(); $errorLog->Error_DateTime = date("Y-m-d H:i:s"); if (session_id()) { $errorLog->Session_ID = session_id(); } if (isset(Yii::app()->user->userID)) { $errorLog->User_Login = Yii::app()->user->userID; } $errorLog->Application = $_SERVER['HTTP_USER_AGENT']; $errorLog->Error_Category = $error_category; $errorLog->Error_Msg = $msg; $errorLog->LogLevel_Severity = $errLevel; $errorLog->save(); }
/** @return InvoiceLog */ function getInvoiceLog() { if (!$this->log) { $this->log = $this->plugin->getDi()->invoiceLogRecord; if ($this->invoice) { $this->log->invoice_id = $this->invoice->invoice_id; $this->log->user_id = $this->invoice->user_id; } $this->log->paysys_id = $this->getPlugin()->getId(); $this->log->remote_addr = $_SERVER['REMOTE_ADDR']; foreach ($this->plugin->getConfig() as $k => $v) { if (is_scalar($v) && strlen($v) > 4) { $this->log->mask($v); } } } return $this->log; }
/** * @return string * @param string $action */ public function run($action) { $class = new ReflectionClass($this); $method = Nano_Dispatcher::formatName($action, false); $result = null; $this->runInit(); if (false !== $this->runBefore()) { try { $result = $this->{$method}(); } catch (Exception $e) { ErrorLog::append($e); throw $e; } } $this->runAfter(); if (false === $this->rendered) { return $this->render(null, null); } return $result; }
if ($ret) { $targetProject = $db->fetchAllDatabase(); } else { $targetProject = FALSE; ErrorLog::message("DBエラー(対象プロジェクトの取得に失敗しました。)"); } if (!preg_match('/^[1-9][0-9]*$/', $projectId) || $targetProject === FALSE) { echo "不正なアクセスです。"; exit; } $ret = $db->executeSql($taskSelect, $selectParams); if ($ret) { $taskList = $db->fetchAllDatabase(); } else { $error[] = 'DBエラー(タスク一覧の取得に失敗しました。)'; ErrorLog::message("DBエラー(タスク一覧の取得に失敗しました。)"); } } else { } //-----------------------------------------------smarty $smarty->template_dir = '../smarty/templates/'; $smarty->compile_dir = '../smarty/templates_c/'; $smarty->config_dir = '../smarty/configs/'; $smarty->cache_dir = '../smarty/cache/'; $smarty->escape_html = true; // キャッシュ機能の有効化 // $smarty->caching = true; // エラー if (count($error) > 0) { $smarty->assign('error', $error); } else {
//--------------------------------------------------------------- // get patient information using information passed. limit 5 //--------------------------------------------------------------- $sql = "SELECT \n\tPDT.id as projectdailytimeid, \n\tprojectid,\n\tDATE_FORMAT(enterdate,'%m/%d/%y') as fenterdate,\n\tPT.name as projectname, CT.name as clientname,\n\tFORMAT(SUM(timeinterval),2) as finterval,\n\tintervaldescription\n\tFROM projectdailytimetbl PDT \n\tLEFT JOIN projecttbl PT ON PT.id = PDT.projectid\n\tLEFT JOIN clienttbl CT ON CT.id = PT.clientid\n\tWHERE enterdate >= '{$fromdateTS}' AND enterdate <= '{$todateTS}'"; if ($clientid != "0") { $sql .= "AND clientid = '{$clientid}' "; } if ($projectid != "0") { $sql .= "AND projectid = '{$projectid}' "; } $sql .= "GROUP BY PT.name, enterdate ORDER BY PT.name"; // print $sql; // die(); $sql_result = @mysql_query($sql, $dbConn); if (!$sql_result) { $log = new ErrorLog("logs/"); $sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing get time entry daily project review list select"); $log->writeLog("SQL: {$sql}"); $rv = ""; exit($rv); } $count = mysql_num_rows($sql_result); if ($count > 0) { $rows = array(); while ($row = mysql_fetch_assoc($sql_result)) { $results[] = $row; } } // // close db connection
if (isset($_COOKIE['loginId'])) { setcookie("loginId", '', time() - 1800, '/sonar_todo_app/html/login.php/'); setcookie("loginPw", '', time() - 1800, '/sonar_todo_app/html/login.php/'); } if ($kiokuFlag == 1) { setcookie("loginId", $userId, time() + 60 * 60 * 24 * 14, '/sonar_todo_app/html/login.php/'); setcookie("loginPw", $userId, time() + 60 * 60 * 24 * 14, '/sonar_todo_app/html/login.php/'); } header('Location: ' . SITE_URL); exit; } else { $error[] = 'IDまたはパスワードが間違っています。'; } } else { $error[] = 'DBエラー(ユーザの取得に失敗しました。)'; ErrorLog::message("DBエラー(ユーザの取得に失敗しました。)"); } } } //-----------------------------------------------function //-----------------------------------------------smarty $smarty->template_dir = '../smarty/templates/'; $smarty->compile_dir = '../smarty/templates_c/'; $smarty->config_dir = '../smarty/configs/'; $smarty->cache_dir = '../smarty/cache/'; $smarty->escape_html = true; // キャッシュ機能の有効化 // $smarty->caching = true; // エラー if (count($error) > 0) { $smarty->assign('error', $error);
exit($rv); } if (!mysql_select_db($DBschema, $dbConn)) { $log = new ErrorLog("logs/"); $dberr = mysql_error(); $log->writeLog("DB error: {$dberr} - Error selecting db Unable to get client project list."); $rv = ""; exit($rv); } //--------------------------------------------------------------- // get patient information using information passed. limit 5 //--------------------------------------------------------------- $sql = "SELECT P.id as projectid, \nP.clientid as clientid, \nP.name as projectname,\nC.name as contactname,\ndeskphone as contactdeskphone,\nmobilephone as contactmobilephone,\nemail as contactemail\nFROM projecttbl P\nLEFT JOIN contactstbl C ON C.id = P.contactid\nWHERE P.clientid = {$clientid}"; $sql_result = @mysql_query($sql, $dbConn); if (!$sql_result) { $log = new ErrorLog("logs/"); $sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing get client project list select"); $log->writeLog("SQL: {$sql}"); $rv = ""; exit($rv); } $count = mysql_num_rows($sql_result); if ($count > 0) { $rows = array(); while ($row = mysql_fetch_assoc($sql_result)) { $results[] = $row; } } // // close db connection
/** * Save category in database. * @return ErrorLog containing errors if any. */ function saveCategory() { // Initialize ErrorLog object $errors = new ErrorLog(); // Check if user has edit permission if ($this->hasEditPermission()) { global $dbi, $log; global $lCategoryEdit; // Check if data is submitted from the form checkSubmitter(scriptUrl); // Save values $this->title = getValue("title"); $this->description = getValue("description"); // Validate data if (empty($this->title)) { $errors->addError("title", $lCategoryEdit["MissingTitle"]); } else { if (empty($this->id)) { $category = new Category("", $this->title); if (!empty($category->id)) { $errors->addError("title", $lCategoryEdit["CategoryExists"]); } } } if (!$errors->hasErrors()) { if (!empty($this->id)) { // Update category in database $dbi->query("UPDATE " . categoryTableName . " SET title=" . $dbi->quote($this->title) . ",description=" . $dbi->quote($this->description) . " WHERE (id=" . $dbi->quote($this->id) . ")"); } else { // Insert category into database $dbi->query("INSERT INTO " . categoryTableName . "(title,description) VALUES(" . $dbi->quote($this->title) . "," . $dbi->quote($this->description) . ")"); // Get insert id $this->id = $dbi->getInsertId(); } // Log transaction $log->logTransaction(categoryContentTypeId, $this->id); } } return $errors; }
protected function usersToObjectRate($dbQuery) { $database = ComponentDatabase::get_instance(); $qr = $database->executeQuery($dbQuery); $eventsList = $qr->getResponseList(); //rating objects if (!$eventsList) { //wrong query $errLog = ErrorLog::get_instance(); $errLog->logError("No events of the specified type found, no prediction made", "Standard"); return false; } else { while ($record = $database->getNextRow($eventsList)) { if (array_key_exists($record["objectID"], $this->objectToScoreArray)) { $objectRating = $this->objectToScoreArray[$record["objectID"]]; } else { $objectRating = 0; } if (is_array($this->users) and array_key_exists($record["userID"], $this->users)) { $userImportance = $this->users[$record["userID"]]; } else { $userImportance = 0; } $objectRating = $this->ratingAggregation($objectRating, $record["eventValue"], $record["eventType"], $this->eventImportance, $userImportance); $this->objectToScoreArray[$record["objectID"]] = $objectRating; } } }
<?php chdir('../'); require 'errorlog.php'; $config = array('writers' => array('syslog' => array('formatter' => array('ALL' => "%timestamp% %errorName% (%errorLevel%): %message%\n"))), 'dump_session_data' => false, 'logLevel' => ErrorLog::DEBUG); $error = ErrorLog::getInstance($config); $error->registerExceptionHandler(); $error->warn('This is an informal message', ErrorLog::INFO); $error->warn('This is a critical message', ErrorLog::CRIT); function test() { throw new Exception('This is an exception'); } test();
/** * Save blog in database. * @param $readPost Read values from post. * @return ErrorLog if there were errors. */ function saveBlog($readPost = true) { // Create ErrorLog object $errorLog = new ErrorLog(); if ($this->hasAdministerPermission()) { global $dbi, $log, $login, $module; // Check if data is submitted from the form checkSubmitter(); // Include language include scriptPath . "/include/language/" . pageLanguage . "/general.php"; include scriptPath . "/" . folderBlog . "/include/language/" . $this->language . "/general.php"; // Save values from post if ($readPost) { $this->category = parseHtml(getPostValue("category"), 0); $this->description = parseHtml(getPostValue("description"), 1); $this->language = getPostValue("language"); $this->postLimit = getPostValue("postLimit"); $this->showRSSLink = getPostValue("showRSSLink"); $this->showRSSCommentsLink = getPostValue("showRSSCommentsLink"); $this->subscribers = parseHtml(getPostValue("subscribers"), 0); $this->title = parseHtml(getPostValue("title"), 0); } // Validate data if (empty($this->language)) { $this->language = pageDefaultLanguage; } if (empty($this->title)) { $errorLog->addError("title", $lBlogEdit["MissingTitle"]); } else { if (empty($this->id)) { $blog = new Blog("", $this->title); if (!empty($blog->id)) { $errorLog->addError("title", $lBlogEdit["BlogExists"]); } } } // If there were no errors update database if (!$errorLog->hasErrors()) { if (empty($this->id)) { // Get max position $result = $dbi->query("SELECT MAX(position) FROM " . blogTableName); if ($result->rows()) { list($position) = $result->fetchrow_array(); $position++; } else { $position = 0; } // Insert blog into database $dbi->query("INSERT INTO " . blogTableName . "(title,category,description,subscribers,language,postLimit,showRSSLink,showRSSCommentsLink,position) VALUES(" . $dbi->quote($this->title) . "," . $dbi->quote($this->category) . "," . $dbi->quote($this->description) . "," . $dbi->quote($this->subscribers) . "," . $dbi->quote($this->language) . "," . $dbi->quote($this->postLimit) . "," . $dbi->quote($this->showRSSLink) . "," . $dbi->quote($this->showRSSCommentsLink) . "," . $dbi->quote($position) . ")"); // Get new blog id $this->id = $dbi->getInsertId(); // Set default permissions $login->setModuleContentPermissions(blogContentId, $this->id, "Visitors", 0, 0, 1, 0, 0, 0, 0, 1); $login->setModuleContentPermissions(blogContentId, $this->id, "Users", 0, 0, 1, 0, 0, 0, 0, 1); } else { // Update blog in database $dbi->query("UPDATE " . blogTableName . " SET title=" . $dbi->quote($this->title) . ",category=" . $dbi->quote($this->category) . ",description=" . $dbi->quote($this->description) . ",subscribers=" . $dbi->quote($this->subscribers) . ",language=" . $dbi->quote($this->language) . ",postLimit=" . $dbi->quote($this->postLimit) . ",showRSSLink=" . $dbi->quote($this->showRSSLink) . ",showRSSCommentsLink=" . $dbi->quote($this->showRSSCommentsLink) . " WHERE id=" . $dbi->quote($this->id)); } // Upload index picture if (!empty($_FILES["img_0"])) { uploadFile($_FILES["img_0"], "blog_" . $this->id, array("image/jpeg", "image/pjpeg", "image/gif"), 0, 50, 50); } // Log transaction $log->logTransaction(blogContentId, $this->id); } else { if (!empty($_FILES["img_0"]["tmp_name"])) { $errorLog->addError("upload", $lErrors["ReUploadImages"]); } } } return $errorLog; }
public function fail() { $this->setStatus('failure'); $this->save(); $job = $this->getJob(); $job->set('downloaded_time', date("Y-m-d H:i:s")); $job->set('finished_time', date("Y-m-d H:i:s")); $job->set('verified_time', date("Y-m-d H:i:s")); $job->setStatus('failure'); $job->save(); $bot = $this->getBot(); $bot->reset(); $log = new ErrorLog(); $log->set('user_id', User::$me->id); $log->set('job_id', $job->id); $log->set('bot_id', $bot->id); $log->set('queue_id', $job->get('queue_id')); $log->set('reason', "Model slicing failed."); $log->set('error_date', date("Y-m-d H:i:s")); $log->save(); }
public static function handle() { if (!isset(self::$_instance)) { $c = __CLASS__; self::$_instance = new $c(); } return self::$_instance; }
<?php //-----------------------------------------------define require_once '../conf/config.php'; require_once './class/utility.php'; require_once './class/db.php'; require_once './class/sql.php'; require_once './class/log.php'; $utl = new Utility(); $db = new DbPdo(); //-----------------------------------------------session session_name(SESSION_NAME); session_start(); //-----------------------------------------------login check if (!isset($_SESSION['loginInfo']) || isset($_SESSION['loginInfo']) && empty($_SESSION['loginInfo'])) { header('Location: ' . SITE_URL . 'login.php'); } //-----------------------------------------------valiables $projectId = (int) $_POST['projectId']; $projectMei = $_POST['projectMei']; //-----------------------------------------------logic // プロジェクトstatus変更 $db->beginTransaction(); $updateParams = array(array(':project_id', $projectId, PDO::PARAM_INT), array(':project_mei', $projectMei, PDO::PARAM_STR)); $ret = $db->executeSql($projectMeiUpdate, $updateParams); if ($ret) { $db->commit(); } else { $db->rollback(); ErrorLog::message("DBエラー(プロジェクト名変更に失敗しました。)"); }
$Project = new Project(); $role = 0; if ($projectid) { $project = pdo_query("SELECT name FROM project WHERE id='{$projectid}'"); if (pdo_num_rows($project) > 0) { $project_array = pdo_fetch_array($project); $projectname = $project_array["name"]; } $Project->Id = $projectid; $role = $Project->GetUserRole($userid); } else { $projectname = 'Global'; } // If we should delete the log if (($User->IsAdmin() || $role > 1) && isset($_POST["deletelogs"])) { $ErrorLog = new ErrorLog(); $ErrorLog->Clean(0, $projectid); } else { if (isset($_POST["deletelogs"])) { echo "You don't have the privileges to delete these logs."; exit; } } $xml = begin_XML_for_XSLT(); $xml .= "<title>Error Log - " . $projectname . "</title>"; if ($buildid) { $xml .= get_cdash_dashboard_xml(get_project_name($projectid), $date); // Get the errors $query = pdo_query("SELECT resourcetype,date,resourceid,description,type,buildid,projectid\n FROM errorlog WHERE projectid=" . qnum($projectid) . " AND buildid=" . qnum($buildid) . " ORDER BY date DESC"); } else { if ($projectid) {
$sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing insert client for add/update client details"); $log->writeLog("SQL: {$sql}"); $rv = ""; exit($rv); } $clientid = mysql_insert_id($dbConn); } else { //-------------------------------------- // we are an update //-------------------------------------- $sql = "UPDATE clienttbl\n\t\t\tSET name = '{$clientname}', \n\t\t\taddress1 = '{$clientaddress1}', \n\t\t\taddress2 = '{$clientaddress2}',\n\t\t\tcity = '{$clientcity}',\n\t\t\tstate = '{$clientstate}',\n\t\t\tzip = '{$clientzip}',\n\t\t\tstatus = '{$clientstatus}', \n\t\t\trate = '{$clientrate}'\n\t\t\tWHERE id = '{$clientid}'\n\t\t\t"; // print $sql; $sql_result = @mysql_query($sql, $dbConn); if (!$sql_result) { $log = new ErrorLog("logs/"); $sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing update client for add/update client details"); $log->writeLog("SQL: {$sql}"); $rv = ""; exit($rv); } } // // close db connection // mysql_close($dbConn); // // logging // // $returnArrayLog->writeLog("Patient List request ended.");
<?php require_once './common.php'; class ErrorLog extends Common { public function index() { $this->check(); $errorLog = isset($_POST['error_log']) ? isset($_POST['error_log']) : ''; if (!$errorLog) { return Response::json(401, "日志为空"); } $sql = "insert into \n\t\t\t\t\terror_log(\n\t\t\t\t\t\t`app_id`,\n\t\t\t\t\t\t`did`,\n\t\t\t\t\t\t`version_id`,\n\t\t\t\t\t\t`version_mini`,\n\t\t\t\t\t\t`error_log`,\n\t\t\t\t\t\t`create_time`)\n\t\t\t\t\tvalues(\n\t\t\t\t\t\t" . $this->params['app_id'] . ",\n\t\t\t\t\t\t'" . $this->params['did'] . "',\n\t\t\t\t\t\t" . $this->params['version_id'] . ",\n\t\t\t\t\t\t" . $this->params['version_mini'] . ",\n\t\t\t\t\t\t'" . $errorLog . "',\n\t\t\t\t\t\t" . time() . "\n\t\t\t\t\t)"; $connect = Db::getInstance()->connect(); if (mysql_query($sql, $connect)) { return Response::json(200, '错误信息插入成功'); } else { return Response::json(400, '错误信息插入失败'); } } } $error = new ErrorLog(); $error->index();
<?php //-----------------------------------------------define require_once '../conf/config.php'; require_once './class/utility.php'; require_once './class/db.php'; require_once './class/sql.php'; require_once './class/log.php'; $utl = new Utility(); $db = new DbPdo(); //-----------------------------------------------session session_name(SESSION_NAME); session_start(); //-----------------------------------------------login check if (!isset($_SESSION['loginInfo']) || isset($_SESSION['loginInfo']) && empty($_SESSION['loginInfo'])) { header('Location: ' . SITE_URL . 'login.php'); } //-----------------------------------------------valiables $status = $_POST['status']; $taskId = $_POST['taskId']; $projectId = $_POST['projectId']; //-----------------------------------------------logic $db->beginTransaction(); $updateParams = array(array(':status', $status, PDO::PARAM_STR), array(':task_id', $taskId, PDO::PARAM_INT), array(':project_id', $projectId, PDO::PARAM_INT)); $ret = $db->executeSql($taskStatusUpdate, $updateParams); if ($ret) { $db->commit(); } else { $db->rollback(); ErrorLog::message("DBエラー(タスク並び順変更に失敗しました。)"); }
$log = new ErrorLog("logs/"); $dberr = mysql_error(); $log->writeLog("DB error: {$dberr} - Error selecting db Unable to delete daily time entry."); $rv = ""; exit($rv); } //--------------------------------------------------------------- // delete daily time entered using information passed. //--------------------------------------------------------------- $sql = "DELETE FROM projectdailytimetbl\nWHERE id = {$projectdailytimeid}"; // print $sql; // die(); $rv = ""; $sql_result = @mysql_query($sql, $dbConn); if (!$sql_result) { $log = new ErrorLog("logs/"); $sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing delete to daily time"); $log->writeLog("SQL: {$sql}"); exit($rv); } // // close db connection // mysql_close($dbConn); // // logging // // $returnArrayLog->writeLog("Patient List request ended."); // // pass back info
/** * returns $noOfObjects of the best objects for users in $usersArray * method just pick randomly demanded number of the objects from the allowed ones * @param <type> $usersArray array of (userID => similarity) of the selected users * @param <type> $noOfObjects number of objects, we search for * @param <type> $objectList list of allowed objects * @return <type> array( objectID => similarity: 1 ) ) */ public function getBestObjectForUsers($usersArray, $noOfObjects, $objectList = "") { $table = Config::$objectTableName; $objectIDName = Config::$objectIDColumnName; if (is_array($objectList) and sizeof($objectList) != 0) { $objectQuery = " `" . $objectIDName . "` in ("; $first = 1; foreach ($objectList as $obj) { if ($first) { $first = 0; $objectQuery .= "" . $obj . ""; } else { $objectQuery .= ", " . $obj . ""; } } $objectQuery .= ")"; } else { $objectQuery = " 1 "; } $query = "select distinct `" . $objectIDName . "` from `" . $table . "` where " . $objectQuery . " order by RAND() limit " . $noOfObjects . " "; //echo $query; $database = ComponentDatabase::get_instance(); $qr = $database->executeQuery($query); $objectsList = $qr->getResponseList(); //packing answer into the array if (!$objectsList) { //wrong query $errLog = ErrorLog::get_instance(); $errLog->logError("Wrong SQL query, no prediction made", "Dummy"); return false; } else { $returnlist = array(); while ($record = $database->getNextRow($objectsList)) { $returnlist[$record[$objectIDName]] = 1; } return $returnlist; } }
/** Add daily changes if necessary */ function addDailyChanges($projectid) { include "cdash/config.php"; include_once "cdash/common.php"; include_once "cdash/sendemail.php"; $db = pdo_connect("{$CDASH_DB_HOST}", "{$CDASH_DB_LOGIN}", "{$CDASH_DB_PASS}"); pdo_select_db("{$CDASH_DB_NAME}", $db); $project_array = pdo_fetch_array(pdo_query("SELECT nightlytime,name,autoremovetimeframe,autoremovemaxbuilds,emailadministrator\n FROM project WHERE id='{$projectid}'")); $date = ""; // now list($previousdate, $currentstarttime, $nextdate) = get_dates($date, $project_array["nightlytime"]); $date = gmdate(FMT_DATE, $currentstarttime); // Check if we already have it somwhere $query = pdo_query("SELECT id FROM dailyupdate WHERE projectid='{$projectid}' AND date='{$date}'"); if (pdo_num_rows($query) == 0) { $cvsauthors = array(); pdo_query("INSERT INTO dailyupdate (projectid,date,command,type,status)\n VALUES ({$projectid},'{$date}','NA','NA','0')"); $updateid = pdo_insert_id("dailyupdate"); $dates = get_related_dates($project_array["nightlytime"], $date); $commits = get_repository_commits($projectid, $dates); // Insert the commits foreach ($commits as $commit) { $filename = $commit['directory'] . "/" . $commit['filename']; $checkindate = $commit['time']; $author = addslashes($commit['author']); $email = ''; if (isset($commit['email'])) { $email = addslashes($commit['email']); } $log = addslashes($commit['comment']); $revision = $commit['revision']; $priorrevision = $commit['priorrevision']; // Check if we have a robot file for this build $robot = pdo_query("SELECT authorregex FROM projectrobot\n WHERE projectid=" . qnum($projectid) . " AND robotname='" . $author . "'"); if (pdo_num_rows($robot) > 0) { $robot_array = pdo_fetch_array($robot); $regex = $robot_array['authorregex']; preg_match($regex, $commit['comment'], $matches); if (isset($matches[1])) { $author = addslashes($matches[1]); } } if (!in_array(stripslashes($author), $cvsauthors)) { $cvsauthors[] = stripslashes($author); } pdo_query("INSERT INTO dailyupdatefile (dailyupdateid,filename,checkindate,author,email,log,revision,priorrevision)\n VALUES ({$updateid},'{$filename}','{$checkindate}','{$author}','{$email}','{$log}','{$revision}','{$priorrevision}')"); add_last_sql_error("addDailyChanges", $projectid); } // end foreach commit // If the project has the option to send an email to the author if ($project_array['emailadministrator']) { sendEmailUnregisteredUsers($projectid, $cvsauthors); } // Send an email if some expected builds have not been submitting sendEmailExpectedBuilds($projectid, $currentstarttime); // cleanBuildEmail cleanBuildEmail(); cleanUserTemp(); // If the status of daily update is set to 2 that means we should send an email $query = pdo_query("SELECT status FROM dailyupdate WHERE projectid='{$projectid}' AND date='{$date}'"); $dailyupdate_array = pdo_fetch_array($query); $dailyupdate_status = $dailyupdate_array["status"]; if ($dailyupdate_status == 2) { // Find the groupid $group_query = pdo_query("SELECT buildid,groupid FROM summaryemail WHERE date='{$date}'"); while ($group_array = pdo_fetch_array($group_query)) { $groupid = $group_array["groupid"]; $buildid = $group_array["buildid"]; // Find if the build has any errors $builderror = pdo_query("SELECT count(buildid) FROM builderror WHERE buildid='{$buildid}' AND type='0'"); $builderror_array = pdo_fetch_array($builderror); $nbuilderrors = $builderror_array[0]; // Find if the build has any warnings $buildwarning = pdo_query("SELECT count(buildid) FROM builderror WHERE buildid='{$buildid}' AND type='1'"); $buildwarning_array = pdo_fetch_array($buildwarning); $nbuildwarnings = $buildwarning_array[0]; // Find if the build has any test failings if ($project_emailtesttimingchanged) { $sql = "SELECT count(testid) FROM build2test WHERE buildid='{$buildid}' AND (status='failed' OR timestatus>" . qnum($project_testtimemaxstatus) . ")"; } else { $sql = "SELECT count(testid) FROM build2test WHERE buildid='{$buildid}' AND status='failed'"; } $nfail_array = pdo_fetch_array(pdo_query($sql)); $nfailingtests = $nfail_array[0]; sendsummaryemail($projectid, $groupid, $nbuildwarnings, $nbuilderrors, $nfailingtests); } } pdo_query("UPDATE dailyupdate SET status='1' WHERE projectid='{$projectid}' AND date='{$date}'"); // Remove the old logs include_once "models/errorlog.php"; $ErrorLog = new ErrorLog(); $ErrorLog->Clean(10); // 10 days // Clean the backup directory clean_backup_directory(); // Remove the first builds of the project include_once "cdash/autoremove.php"; removeFirstBuilds($projectid, $project_array["autoremovetimeframe"], $project_array["autoremovemaxbuilds"]); removeBuildsGroupwise($projectid, $project_array["autoremovemaxbuilds"]); } }
session_name(SESSION_NAME); session_start(); //-----------------------------------------------login check if (!isset($_SESSION['loginInfo']) || isset($_SESSION['loginInfo']) && empty($_SESSION['loginInfo'])) { header('Location: ' . SITE_URL . 'login.php'); } //-----------------------------------------------valiables $projectMei = $_POST['projectMei']; //-----------------------------------------------logic // プロジェクトの並び順の最後の値を取得 $ret = $db->executeSql($projectMaxSeqSelect); if ($ret) { $projectMaxSeq = $db->fetchAllDatabase(); if ($projectMaxSeq[0]['maxSeq'] != NULL) { $seq = $projectMaxSeq[0]['maxSeq']; } else { $seq = 0; } $db->beginTransaction(); $insertParams = array(array(':project_mei', $projectMei, PDO::PARAM_STR), array(':seq', $seq, PDO::PARAM_INT)); $ret = $db->executeSql($projectInsert, $insertParams); if ($ret) { echo $db->getLastInsertId(); $db->commit(); } else { $db->rollback(); ErrorLog::message("DBエラー(プロジェクト追加に失敗しました。)"); } } else { ErrorLog::message("DBエラー(プロジェクトの並び順の最後の値の取得に失敗しました。)"); }
if ($stoptime != "") { $stoptimeTS = date("Y-m-d H:i:s", strtotime($entrydate . " " . $stoptime)); } //--------------------------------------------------------------- // add daily time entered using information passed. //--------------------------------------------------------------- $sql = "UPDATE projectdailytimetbl \n\tSET projectid = {$projectid},\t\n\tenterdate ='{$entrydateTS}',\n\tstarttime = '{$starttimeTS}',"; if ($stoptimeTS != "") { $sql = $sql . "stoptime = '{$stoptimeTS}',"; } $sql = $sql . "timeinterval = {$interval},\n\tintervaldescription = '{$comment}'\n\tWHERE id = {$projectdailytimeid}"; // print $sql; $rv = ""; $sql_result = @mysql_query($sql, $dbConn); if (!$sql_result) { $log = new ErrorLog("logs/"); $sqlerr = mysql_error(); $log->writeLog("SQL error: {$sqlerr} - Error doing insert to add daily time"); $log->writeLog("SQL: {$sql}"); exit($rv); } // // close db connection // mysql_close($dbConn); // // logging // // $returnArrayLog->writeLog("Patient List request ended."); // // pass back info
function vars2globals_wrapper($varlist) { $retval = true; if ($varlist != '') { $vars = explode(',', $varlist); foreach ($vars as $var) { if (isset($GLOBALS[$var])) { ErrorLog::write('variabe $' . $var . ' already defined in global space!!', __FILE__, __FUNCTION__, __LINE__); $retval = false; } else { global ${$var}; } } } return $retval; }
<?php //-----------------------------------------------define require_once '../conf/config.php'; require_once './class/utility.php'; require_once './class/db.php'; require_once './class/sql.php'; require_once './class/log.php'; $utl = new Utility(); $db = new DbPdo(); //-----------------------------------------------session session_name(SESSION_NAME); session_start(); //-----------------------------------------------login check if (!isset($_SESSION['loginInfo']) || isset($_SESSION['loginInfo']) && empty($_SESSION['loginInfo'])) { header('Location: ' . SITE_URL . 'login.php'); } //-----------------------------------------------valiables $taskId = (int) $_POST['taskId']; $projectId = (int) $_POST['projectId']; //-----------------------------------------------logic // タスク削除 $db->beginTransaction(); $deleteParams = array(array(':task_id', $taskId, PDO::PARAM_INT), array(':project_id', $projectId, PDO::PARAM_INT)); $ret = $db->executeSql($taskDelete, $deleteParams); if ($ret) { $db->commit(); } else { $db->rollback(); ErrorLog::message("DBエラー(タスク削除に失敗しました。)"); }