* @package moodle
* @subpackage
* @author Dan Marsden <*****@*****.**>
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL
* @copyright (C) 1999 onwards Martin Dougiamas http://dougiamas.com
*
*
*/
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'taoimportlib.php';
require_once $CFG->dirroot . '/local/lib.php';
require_capability('moodle/local:canimportlegacytao', get_context_instance(CONTEXT_SYSTEM));
$confirm = optional_param('confirm', '', PARAM_INT);
$strheading = get_string('legacytaoimport', 'local');
print_header($strheading, $strheading, build_navigation($strheading));
$dbh = taoimport_dbconnect();
if (!$dbh) {
error("couldn't connect to db");
}
$strdbconfig = get_string('legacydbconfig', 'local');
$strdbusers = get_string('legacydbusers', 'local');
$strdblp = get_string('legacydblp', 'local');
$tabs[] = new tabobject('dbconfig', 'db_config.php', $strdbconfig, $strdbconfig, false);
$tabs[] = new tabobject('langfix', 'fixclassifylang.php', 'Fix Classification Lang', 'Fix Classification Lang', false);
$tabs[] = new tabobject('dbusers', 'db_users.php', $strdbusers, $strdbusers, false);
$tabs[] = new tabobject('dblp', 'db_lp.php', $strdblp, $strdblp, false);
print_tabs(array($tabs), 'dbusers');
$errors = "";
$count = 0;
$sql = "SELECT participant.*, school.id, school.url, school.name1, school.region_id, region.show_name " . "FROM participant, school, region WHERE participant.school_id=school.id AND region.id=school.region_id";
$rs = $dbh->Execute($sql);
function load_topics_from_legacy($dbh, $pres)
{
$dbh = taoimport_dbconnect();
$topics = array();
$sql = "SELECT p.no, p.title, CAST(p.text AS TEXT) as text, t.name\n FROM pres_topic p\n JOIN pres_topic_type t on t.id = p.type\n WHERE p_id = {$pres}";
$rs = $dbh->Execute($sql);
if (!empty($rs)) {
while ($res = $rs->FetchRow()) {
$topics[$res['name']] = $res['text'];
}
}
return $topics;
}
require_once 'db_config_form.php';
require_capability('moodle/local:canimportlegacytao', get_context_instance(CONTEXT_SYSTEM));
$strheading = get_string('legacytaoimport', 'local');
print_header($strheading, $strheading, build_navigation($strheading));
$strdbconfig = get_string('legacydbconfig', 'local');
$strdbusers = get_string('legacydbusers', 'local');
$strdblp = get_string('legacydblp', 'local');
$tabs[] = new tabobject('dbconfig', 'db_config.php', $strdbconfig, $strdbconfig, false);
$tabs[] = new tabobject('langfix', 'fixclassifylang.php', 'Fix Classification Lang', 'Fix Classification Lang', false);
$tabs[] = new tabobject('dbusers', 'db_users.php', $strdbusers, $strdbusers, false);
$tabs[] = new tabobject('dblp', 'db_lp.php', $strdblp, $strdblp, false);
print_tabs(array($tabs), 'dbconfig');
$mform = new taoimport_form();
if ($data = $mform->get_data()) {
set_config('legacydbtype', $data->dbtype, 'legacytao');
set_config('legacydbhost', $data->dbhost, 'legacytao');
set_config('legacydbname', $data->dbname, 'legacytao');
set_config('legacydbuser', $data->dbuser, 'legacytao');
set_config('legacydbpass', $data->dbpass, 'legacytao');
//now check to see if can access db!
require_once 'taoimportlib.php';
if (!($dbh = taoimport_dbconnect())) {
error("Could not connect to SQL Server");
} else {
echo '<p><b>Successfully connected to ' . $data->dbhost . ':' . $data->dbname . '</b></p>';
}
} else {
$mform->display();
}
$mform->display();
print_footer();
