-
Notifications
You must be signed in to change notification settings - Fork 0
/
mssql.php
76 lines (66 loc) · 2.27 KB
/
mssql.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
* mssql.php, MS SQL Server functions for ACCS plug-in
*
* Auto-Create Course Shell and MS SQL Server functions
* for such things as managing database connections
*
* 2010-04-28
* @package plug-in
* @subpackage RRU_ACCS
* @copyright 2010 Andrew Zoltay, Royal Roads University
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
defined('MOODLE_INTERNAL') || die();
require_once("accslib.php");
require_once("accs_config.php");
// This script is only available from within the Moodle environment.
defined('MOODLE_INTERNAL') || die();
/**
* Connect to MS SQL Server
*
* @author Andrew Zoltay
* date 2010-04-28
* @global $ACCS_CFG configuration settings for ACCS
* @return MS SQL Link identifier or false
*/
function accs_mssql_connect() {
global $ACCS_CFG;
accs_write_to_log('Connecting to ' . $ACCS_CFG->mssqlserver);
$mssqllink = mssql_connect($ACCS_CFG->mssqlserver, $ACCS_CFG->mssqluser, $ACCS_CFG->mssqlpwd) or die('Unable to connect to MS SQL Server');
if (mssql_select_db ($ACCS_CFG->mssqldb, $mssqllink)) {
return $mssqllink;
} else {
accs_write_to_log('ERROR - failed to select ' . $ACCS_CFG->mssqldb . ' database');
return false;
}
}
/**
* Close connection to MS SQL Server
*
* @author Andrew Zoltay
* date 2010-04-28
* @param MS SQL Link identifier $conn to be closed
* @return none
*/
function accs_mssql_close(&$conn) {
if (!mssql_close($conn)) {
accs_write_to_log('Failed to close MS SQL Server connection');
}
}
?>