* @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();