function migrate2utf8_netpublish_name($recordid)
{
global $CFG, $globallang;
/// Some trivial checks
if (empty($recordid)) {
log_the_problem_somewhere();
return false;
}
if (!($netpublish = get_record('netpublish', 'id', $recordid))) {
log_the_problem_somewhere();
return false;
}
if ($globallang) {
$fromenc = $globallang;
} else {
$sitelang = $CFG->lang;
$courselang = get_course_lang($netpublish->course);
//Non existing!
$userlang = get_main_teacher_lang($netpublish->course);
//N.E.!!
$fromenc = get_original_encoding($sitelang, $courselang, $userlang);
}
/// We are going to use textlib facilities
/// Convert the text
if ($fromenc != 'utf-8' && $fromenc != 'UTF-8') {
$result = utfconvert($netpublish->name, $fromenc);
$newpublish = new object();
$newpublish->id = $recordid;
$newpublish->name = $result;
migrate2utf8_update_record('netpublish', $newpublish);
}
/// And finally, just return the converted field
return $result;
}
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < count($aColumns); $i++) {
if ($aColumns[$i] == "version") {
/* Special output formatting for 'version' column */
$row[] = $aRow[$aColumns[$i]] == "0" ? '-' : $aRow[$aColumns[$i]];
}
if ($aColumns[$i] == "msg") {
// cdukes: #338 - added htmlentities();
/* #339 - Force utf-8 for msg column on foreign languages*/
/* #362 - PHP's utf8_convert caused proiblems with IE9.
As a result, I had to write a special function to check for utf-8, then convert if not */
$msg = htmlentities($aRow[$aColumns[$i]]);
$row[] = utfconvert($msg);
} else {
if ($aColumns[$i] != ' ') {
/* General output */
$row[] = htmlentities($aRow[$aColumns[$i]]);
}
}
}
$output['aaData'][] = $row;
}
// set the start time and end time
if (!isset($_GET['startTime']) && !isset($_GET['endTime'])) {
$start_time_formatted = NULL;
$sql = 'SELECT lo FROM ' . $sTable . ' ORDER BY lo ASC LIMIT 1';
$result = mysql_query($sql, $gaSql['link']) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
function migrate2utf8_questionnaire_response_other_response($recordid)
{
global $CFG, $globallang;
/// Some trivial checks
if (empty($recordid)) {
log_the_problem_somewhere();
return false;
}
if (!($rother = get_record('questionnaire_response_other', 'id', $recordid))) {
log_the_problem_somewhere();
return false;
}
if (!($courseid = get_field('questionnaire_survey', 'owner', 'id', get_field('questionnaire_question', 'survey_id', 'id', $rother->question_id)))) {
log_the_problem_somewhere();
return false;
}
if ($globallang) {
$fromenc = $globallang;
} else {
$sitelang = $CFG->lang;
$courselang = get_course_lang($courseid);
//Non existing!
$userid = get_field('questionnaire_response', 'username', 'id', $rother->response_id);
if (is_numeric($userid)) {
$userlang = get_user_lang($userid);
} else {
$userlang = false;
}
$fromenc = get_original_encoding($sitelang, $courselang, $userlang);
}
/// We are going to use textlib facilities
/// Convert the text
if ($fromenc != 'utf-8' && $fromenc != 'UTF-8') {
$result = utfconvert($rother->response, $fromenc);
$newrother = new object();
$newrother->id = $recordid;
$newrother->response = $result;
migrate2utf8_update_record('questionnaire_response_other', $newrother);
}
/// And finally, just return the converted field
return $result;
}
function migrate2utf8_wiki_votes_username($recordid)
{
global $CFG, $globallang;
/// Some trivial checks
if (empty($recordid)) {
log_the_problem_somewhere();
return false;
}
$SQL = "SELECT w.course\n FROM {$CFG->prefix}wiki w,\n {$CFG->prefix}wiki_votes ws\n WHERE w.id = ws.dfwiki\n AND ws.id = {$recordid}";
if (!($wiki = get_record_sql($SQL))) {
log_the_problem_somewhere();
return false;
}
if (!($wikivotes = get_record('wiki_votes', 'id', $recordid))) {
log_the_problem_somewhere();
return false;
}
if ($globallang) {
$fromenc = $globallang;
} else {
$sitelang = $CFG->lang;
$courselang = get_course_lang($wiki->course);
//Non existing!
$userlang = get_main_teacher_lang($wiki->course);
//N.E.!!
$fromenc = get_original_encoding($sitelang, $courselang, $userlang);
}
/// We are going to use textlib facilities
/// Convert the text
if ($fromenc != 'utf-8' && $fromenc != 'UTF-8') {
$result = utfconvert($wikivotes->username, $fromenc);
$newwikiwikivotes = new object();
$newwikiwikivotes->id = $recordid;
$newwikiwikivotes->username = $result;
migrate2utf8_update_record('wiki_votes', $newwikiwikivotes);
}
/// And finally, just return the converted field
return $result;
}
