$this->name = $n;
$this->data_size = $d;
$this->index_size = $i;
$this->total_size = $t;
$this->rows = $r;
$this->size_per_row = $s;
}
function __destruct()
{
}
}
$db_name = parse_config($config, "<db_name>");
db_init();
admin_page_head("BOINC Database Info");
// if you have other db's just add more get_db_info lines
$db_rec = get_db_info($db_name);
// show_db_info($db_name, $db_rec);
sort_db_info($db_name, $db_rec);
admin_page_tail();
// returns formatted data size
function size_format($size)
{
$retval = 0;
$KB = 1024;
$MB = 1024 * 1024;
$GB = 1024 * 1024 * 1024;
$TB = 1024 * 1024 * 1024 * 1024;
if ($size < $KB) {
$retval = $size;
} elseif ($size > $KB && $size < $MB) {
$retval = sprintf("%.0fK", $size / $KB);
/**
* Attempts to insert a course into the moodle database
*
* @param type $course
* @return string
*/
function up_insert_course($course)
{
global $DB;
$courserequestnumber = $course->idnumber;
$category = $course->category;
$dbinfo = get_db_info();
$oc = new stdClass();
try {
$oc = oci_connect($dbinfo->username, $dbinfo->password, $dbinfo->db);
} catch (exception $e) {
print $e->getMessage();
}
// Check if the course exists
if (up_course_exists($courserequestnumber, $category)) {
add_to_log('1', 'course', 'error', '', "Course already exists: BannerID: {$courserequestnumber}", '', '4');
// Mark course as added in banner
$totalrows = 0;
$query = "INSERT INTO UP_MOODLE.TBL_UPM_COURSE_SYNC VALUES ('{$courserequestnumber}','{$course->termcode}','Y')";
$sql = oci_parse($oc, $query);
oci_execute($sql);
$results = array();
$rows = oci_fetch_all($sql, $results, 0, $totalrows, OCI_FETCHSTATEMENT_BY_ROW);
if ($rows = false) {
print 'Insert to TBL_UPM_COURSE_SYNC failed. Sync may be broken.';
exit;
}
return COURSE_ALREADY_EXISTS;
} else {
if ($newcourseid = $DB->insert_record('course', $course)) {
if (UP_DEBUG) {
print "New Course ID is: " . $newcourseid . "<br />\n";
}
//get the newly inserted course so we can add the default blocks
$newMoodleCourse = $DB->get_record('course', array('id' => $newcourseid));
$data = $course;
$course = course_get_format($newcourseid)->get_course();
// Setup the blocks
blocks_add_default_course_blocks($newMoodleCourse);
//set section information and insert into the section database
$section = new stdClass();
$section->course = $newcourseid;
// Create a default section.
$section->section = 0;
$section->summaryformat = FORMAT_HTML;
try {
$DB->insert_record('course_sections', $section);
} catch (coding_exception $e) {
print $e->getMessage();
}
fix_course_sortorder();
up_add_enrol_plugin('manual', true, $course, $data);
// Mark course as added in banner
$totalrows = 0;
$query = "INSERT INTO UP_MOODLE.TBL_UPM_COURSE_SYNC VALUES ('{$courserequestnumber}','{$data->termcode}','Y')";
$sql = oci_parse($oc, $query);
oci_execute($sql);
$results = array();
$rows = oci_fetch_all($sql, $results, 0, $totalrows, OCI_FETCHSTATEMENT_BY_ROW);
if ($rows = false) {
print 'Insert to TBL_UPM_COURSE_SYNC failed. Sync may be broken.';
exit;
}
$event = \core\event\course_created::create(array('objectid' => $course->id, 'context' => context_course::instance($course->id), 'other' => array('shortname' => $course->shortname, 'fullname' => $course->fullname)));
$event->trigger();
return COURSE_CREATION_SUCCEEDED;
} else {
add_to_log('1', 'course', 'error', '', "Creating: {$shortname} (BANID {$courserequestnumber})", '', '4');
return COURSE_CREATION_FAILED;
}
}
// end of else on if ( $newcourseid = $DB->insert_record('course', $form) )
}
<p><?php
echo translate('confirmintro');
?>
</p>
<p><?php
echo translate('installdetails');
?>
</p>
<table border="0">
<tr>
<td><?php
echo translate('dbtype');
?>
</td>
<td><?php
echo get_db_info(get_cookie_data('dbtype'));
?>
</td>
</tr>
<tr>
<td><?php
echo translate('dbhost');
?>
</td>
<td><?php
echo get_cookie_data('dbhost');
?>
</td>
</tr>
<tr>
<td><?php
<script src="../js/treeview/jquery.treeview.js" type="text/javascript"></script>
<?php
$hostname = $_POST["host"];
$port = $_POST["port"];
$username = $_POST["username"];
$password = $_POST["password"];
function get_db_info($hostname, $port, $username, $password, &$output)
{
$cmd = "./python/get_db_info.py '{$hostname}' '{$port}' '{$username}' '{$password}'";
exec($cmd, $output, $ret);
return $ret;
}
$output = array();
//data format: dbnamecollection1collection2dbname2collection1collection2...
$ret = get_db_info($hostname, $port, $username, $password, $output);
if ($ret != 0) {
echo "<font color='red'>错误：数据库连接错误，请确保输入的数据正确！</font><a href='../index.php'>重新输入</a>";
exit($ret);
}
file_put_contents("../data/login.txt", "{$hostname}{$port}{$username}\n", FILE_APPEND);
// $output = "db1table1table2table3db2table1table2";
?>
<script>
<?php
echo "var _hostname = '{$hostname}';\n";
echo "var _port = '{$port}';\n";
echo "var _user = '******';\n";
echo "var _password= '******';\n";
?>
