function DBQuery($sql)
{
global $DatabaseType, $_CENTRE;
$connection = db_start();
switch ($DatabaseType) {
case 'oracle':
$result = @ociparse($connection, $sql);
if ($result === false) {
$errors = OCIError($connection);
db_show_error($sql, "DB Parse Failed.", $errors['message']);
}
if (!@OciExecute($result)) {
$errors = OCIError($result);
db_show_error($sql, "DB Execute Failed.", $errors['message']);
}
OciCommit($connection);
OciLogoff($connection);
break;
case 'postgres':
$sql = ereg_replace("([,\\(=])[\r\n\t ]*''", '\\1NULL', $sql);
$result = @pg_exec($connection, $sql);
if ($result === false) {
echo $sql;
$errstring = pg_last_error($connection);
db_show_error($sql, "DB Execute Failed.", $errstring);
}
break;
case 'mysql':
$sql = ereg_replace("([,\\(=])[\r\n\t ]*''", '\\1NULL', $sql);
if (preg_match_all("/'(\\d\\d-[A-Za-z]{3}-\\d{2,4})'/", $sql, $matches)) {
foreach ($matches[1] as $match) {
$dt = date('Y-m-d', strtotime($match));
$sql = preg_replace("/'{$match}'/", "'{$dt}'", $sql);
}
}
if (substr($sql, 0, 6) == "BEGIN;") {
$array = explode(";", $sql);
foreach ($array as $value) {
if ($value != "") {
$result = mysql_query($value);
if (!$result) {
mysql_query("ROLLBACK");
die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
}
}
} else {
$result = mysql_query($sql) or die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
break;
}
return $result;
}
function DBQuery($sql)
{
$connection = db_start();
// TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
$sql = preg_replace("/([,\\(=])[\r\n\t ]*''[\r\n\t]*(?!')/", '\\1NULL', $sql);
$result = @pg_exec($connection, $sql);
if ($result === false) {
$errstring = pg_last_error($connection);
db_show_error($sql, "DB Execute Failed.", $errstring);
}
return $result;
}
function load_libraries()
{
$libs = array('error', 'module', 'security', 'url', 'asset', 'session');
$libs = array_unique(array_merge($libs, get_config('autoload', array())));
$conn = get_config('database')->load;
foreach ($libs as $lib) {
if (load_library($lib)) {
if ($lib == 'database' && $conn) {
db_start();
}
}
}
}
function DBQuery($sql)
{
global $DatabaseType;
$connection = db_start();
switch ($DatabaseType) {
case 'oracle':
$result = @ociparse($connection, $sql);
// TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
if ($result === false) {
$errors = OCIError($connection);
db_show_error($sql, "DB Parse Failed.", $errors['message']);
}
if (!@OciExecute($result)) {
$errors = OCIError($result);
db_show_error($sql, "DB Execute Failed.", $errors['message']);
}
OciCommit($connection);
OciLogoff($connection);
break;
case 'postgres':
// TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
$sql = preg_replace("/([,\\(=])[\r\n\t ]*''/", '\\1NULL', $sql);
$result = @pg_exec($connection, $sql);
if ($result === false) {
$errstring = pg_last_error($connection);
db_show_error($sql, "DB Execute Failed.", $errstring);
}
break;
case 'mysql':
// TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
mysql_query("SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE");
mysql_query("SET SESSION SQL_MODE='ANSI'");
$sql = preg_replace("/([,\\(=])[\r\n\t ]*''/", '\\1NULL', $sql);
$result = mysql_query($sql);
if ($result === false) {
$errstring = mysql_error();
db_show_error($sql, "DB Execute Failed.", $errstring);
}
break;
}
return $result;
}
function DBQuery($sql)
{
global $DatabaseType, $_openSIS;
$connection = db_start();
switch ($DatabaseType) {
case 'mysql':
$sql = str_replace('&', "", $sql);
$sql = str_replace('"', "", $sql);
$sql = str_replace(''', "", $sql);
$sql = str_replace('<', "", $sql);
$sql = str_replace('>', "", $sql);
$sql = ereg_replace("([,\\(=])[\r\n\t ]*''", '\\1NULL', $sql);
if (preg_match_all("/'(\\d\\d-[A-Za-z]{3}-\\d{2,4})'/", $sql, $matches)) {
foreach ($matches[1] as $match) {
$dt = date('Y-m-d', strtotime($match));
$sql = preg_replace("/'{$match}'/", "'{$dt}'", $sql);
}
}
if (substr($sql, 0, 6) == "BEGIN;") {
$array = explode(";", $sql);
foreach ($array as $value) {
if ($value != "") {
$result = mysql_query($value);
if (!$result) {
mysql_query("ROLLBACK");
die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
}
}
} else {
$result = mysql_query($sql) or die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
break;
}
return $result;
}
session_destroy();
}
if (optional_param('register', '', PARAM_NOTAGS)) {
if (optional_param('R1', '', PARAM_ALPHA) == 'register') {
header("Location:register.php");
}
}
$_REQUEST['USERNAME'] = preg_replace('/[^A-Za-z0-9\\-]/', '', $_REQUEST['USERNAME']);
if (isset($_POST['USERNAME'])) {
$_POST['USERNAME'] = preg_replace('/[^A-Za-z0-9\\-]/', '', $_POST['USERNAME']);
}
if (isset($_GET['USERNAME'])) {
$_GET['USERNAME'] = preg_replace('/[^A-Za-z0-9\\-]/', '', $_GET['USERNAME']);
}
if (optional_param('USERNAME', '', PARAM_RAW) && optional_param('PASSWORD', '', PARAM_RAW)) {
db_start();
$_REQUEST['USERNAME'] = mysqli_real_escape_string($connection, $_REQUEST['USERNAME']);
$_REQUEST['PASSWORD'] = mysqli_real_escape_string($connection, $_REQUEST['PASSWORD']);
# --------------------------- Seat Count Update Start ------------------------------------------ #
$course_name = DBGet(DBQuery("SELECT DISTINCT(COURSE_PERIOD_ID)FROM schedule WHERE END_DATE <'" . mysqli_real_escape_string($connection, date("Y-m-d")) . "' AND DROPPED = '" . mysqli_real_escape_string($connection, 'N') . "' "));
foreach ($course_name as $column => $value) {
$course_count = DBGet(DBQuery("SELECT * FROM schedule WHERE COURSE_PERIOD_ID='" . $value[COURSE_PERIOD_ID] . "' AND END_DATE <'" . date("Y-m-d") . "'AND DROPPED = 'N' "));
for ($i = 1; $i <= count($course_count); $i++) {
DBQuery("CALL SEAT_FILL()");
DBQuery("UPDATE course_periods SET filled_seats=filled_seats-1 WHERE COURSE_PERIOD_ID IN (SELECT COURSE_PERIOD_ID FROM schedule WHERE end_date IS NOT NULL AND END_DATE <'" . date("Y-m-d") . "' AND DROPPED='N' AND COURSE_PERIOD_ID='" . $value[COURSE_PERIOD_ID] . "')");
DBQuery(" UPDATE schedule SET DROPPED='Y' WHERE END_DATE IS NOT NULL AND COURSE_PERIOD_ID='" . $value[COURSE_PERIOD_ID] . "' AND END_DATE <'" . date("Y-m-d") . "'AND DROPPED = 'N' AND STUDENT_ID='" . $course_count[$i][STUDENT_ID] . "'");
}
}
# ---------------------------- Seat Count Update End ------------------------------------------- #
$username = optional_param('USERNAME', '', PARAM_RAW);
if ($_REQUEST['remember']) {
foreach ($courses as $course_id => $count) {
$courses_list[++$i] = array('COURSE' => _getCourse(substr($course_id, 0, strpos($course_id, '-'))) . substr($course_id, strpos($course_id, '-')), 'COUNT' => $count);
}
ListOutput($courses_list, array('COURSE' => 'Course', 'COUNT' => '#'), 'Course with Unscheduled Requests', 'Courses with Unscheduled Requests', '', '', array('sort' => false, 'search' => false));
$i = 0;
$courses_list = array();
if (count($course_seats)) {
foreach ($course_seats as $course_id => $count) {
$courses_list[++$i] = array('COURSE' => _getCourse(substr($course_id, 0, strpos($course_id, '-'))) . substr($course_id, strpos($course_id, '-')), 'COUNT' => $count);
}
}
ListOutput($courses_list, array('COURSE' => 'Course', 'COUNT' => '#'), 'Course with No Seats', 'Courses with No Seats', '', '', array('sort' => false, 'search' => false));
echo '</TD></TR></TABLE>';
}
if (!$_SCHEDULER['dont_run']) {
$connection = db_start();
db_trans_start($connection);
unset($_SESSION['SCHEDULE']);
if (count($insert)) {
foreach ($insert as $student_id => $requests) {
foreach ($requests as $request) {
$sql = "INSERT INTO SCHEDULE (SYEAR,SCHOOL_ID,STUDENT_ID,START_DATE,MODIFIED_DATE,COURSE_ID,COURSE_WEIGHT,COURSE_PERIOD_ID,MP,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . $request['STUDENT_ID'] . "','" . DBDate() . "','" . DBDate() . "','" . $request['COURSE_ID'] . "','" . $request['COURSE_WEIGHT'] . "','" . $request['COURSE_PERIOD_ID'] . "','" . $request['MP'] . "','" . $request['MARKING_PERIOD_ID'] . "')";
db_trans_query($connection, $sql);
}
}
}
foreach ($periods_RET as $course_id => $weights) {
foreach ($weights as $weight => $periods) {
foreach ($periods as $course_period_id => $period) {
$sql = "UPDATE COURSE_PERIODS SET FILLED_SEATS=COALESCE(TOTAL_SEATS,0)-'" . $period[1]['AVAILABLE_SEATS'] . "' WHERE COURSE_PERIOD_ID='{$course_period_id}'";
db_trans_query($connection, $sql);
function db_del($key, $subkey = '_')
{
$id = db_start($key);
if ($subkey == '*') {
$res = $_SESSION;
session_destroy();
} else {
$res = nvl($_SESSION, $subkey);
unset($_SESSION[$subkey]);
if (empty($_SESSION)) {
session_destroy();
}
}
db_end($id);
return $res;
}
function DBQueryMod($sql)
{
global $DatabaseType, $_openSIS;
$connection = db_start();
switch ($DatabaseType) {
case 'mysqli':
$sql = str_replace('&', "", $sql);
$sql = str_replace('"', "", $sql);
$sql = str_replace(''', "", $sql);
$sql = str_replace('<', "", $sql);
$sql = str_replace('>', "", $sql);
if (preg_match_all("/'(\\d\\d-[A-Za-z]{3}-\\d{2,4})'/", $sql, $matches)) {
foreach ($matches[1] as $match) {
$dt = date('Y-m-d', strtotime($match));
$sql = preg_replace("/'{$match}'/", "'{$dt}'", $sql);
}
}
if (substr($sql, 0, 6) == "BEGIN;") {
$array = explode(";", $sql);
foreach ($array as $value) {
if ($value != "") {
$user_agent = explode('/', $_SERVER['HTTP_USER_AGENT']);
if ($user_agent[0] == 'Mozilla') {
$result = $connection->query($value);
}
if (!$result) {
$user_agent = explode('/', $_SERVER['HTTP_USER_AGENT']);
if ($user_agent[0] == 'Mozilla') {
$connection->query("ROLLBACK");
die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
}
}
}
} else {
$user_agent = explode('/', $_SERVER['HTTP_USER_AGENT']);
if ($user_agent[0] == 'Mozilla') {
$result = $connection->query($sql) or die(db_show_error($sql, "DB Execute Failed.", mysql_error()));
}
}
break;
}
return $result;
}
function sidebar()
{
$num = 3;
//人気記事の表示したい件数を入力
$sql = "SELECT * FROM news,img,category,click_count where show_flg = 1 AND news.news_id = img.news_id AND news.category_id = category.category_id AND news.news_id = click_count.news_id GROUP BY click_count.news_id ORDER BY COUNT(click_count.news_id) DESC LIMIT {$num}";
db_start($sql);
$pdo = null;
}