{"id":12451,"date":"2024-04-08T03:08:37","date_gmt":"2024-04-08T03:08:37","guid":{"rendered":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/?p=12451"},"modified":"2024-05-02T01:22:47","modified_gmt":"2024-05-02T01:22:47","slug":"%e4%bd%9c%e6%a5%ad%e3%83%a1%e3%83%a2-20240408-%e3%83%9d%e3%83%bc%e3%82%bf%e3%83%ab%e3%82%b5%e3%82%a4%e3%83%88%e3%81%ae%e3%82%b3%e3%83%b3%e3%83%86%e3%83%b3%e3%83%84%e3%82%92%e7%a7%bb%e5%8b%95","status":"publish","type":"post","link":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/?p=12451","title":{"rendered":"(\u4f5c\u696d\u30e1\u30e2 20240408) \u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u79fb\u52d5\u3059\u308b"},"content":{"rendered":"

\"\"<\/a><\/p>\n

\u6559\u6750\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092 5.10 \u306b\u3042\u3052\u305f\u306e\u3067\uff0c\u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u79fb\u52d5\u3057\u307e\u3059\u3002\u305d\u3046\u306f\u8a00\u3063\u3066\u3082\uff0cCollege_Physics \u306e\u5206\u3060\u3051\u3092\u79fb\u52d5\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u305d\u306e\u30b3\u30fc\u30c9\u3092\u6b8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u3053\u308c\u306f\u76f4\u63a5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u64cd\u4f5c\u3059\u308b\u3082\u306e\u3067\u3059\u3002<\/p>\n

<?php\r\n\r\n\/\/ College Physics \u306e\u30c7\u30fc\u30bf\u3092\u3001NLportal4.11 \u304b\u3089 NLportal5.1\u7528\u306b\u4fee\u6b63\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\r\n\r\n  \/\/ \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\r\n  $DB = mysqli_connect( 'localhost', 'username', 'password', 'NLportal41') or die(mysqli_connect_error()); \r\n  \r\n  mysqli_set_charset($DB, 'utf8');\r\n\r\n  $DB2 = mysqli_connect( 'localhost', 'username', 'password', 'NLportal510') or die(mysqli_connect_error());\r\n  \r\n  mysqli_set_charset($DB2, 'utf8');\r\n\r\n\r\n\/\/ \u30b3\u30d4\u30fc\u5148($DB2)\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5185\u5bb9\u3092\u524a\u9664\u3059\u308b\r\n\r\n$sql = "DROP TABLE `table_College_Physics`;";\r\n\r\nmysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\necho "DROP table_College_Physics\\n";\r\n\r\n\r\n\/\/  \u30b3\u30d4\u30fc\u3059\u308b\r\n\r\n$sql = "CREATE TABLE NLportal510.table_College_Physics LIKE NLportal41.table_College_Physics";\r\n\r\nmysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\n$sql = "INSERT INTO NLportal510.table_College_Physics SELECT * FROM NLportal41.table_College_Physics";\r\n\r\nmysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\necho "copy table_College_Physics\\n";\r\n\r\n\r\n\r\n\/\/ \u4f5c\u696d\u30d5\u30a9\u30eb\u30c0\u30fc\u3092\u7528\u610f\u3059\u308b\r\n\r\n$timestamp = timestamp( );\r\n\r\n$head = "tmp".$timestamp;\r\n\r\n$foldername = mb_convert_encoding($head, "UTF-8", "auto");\r\n\r\npassthru("mkdir -p \/var\/www\/html\/temporary\/$foldername\/tmp\/");\r\n\r\necho "\u4f5c\u696d\u30d5\u30a9\u30eb\u30c0\u30fc $foldername \u3092\u4f5c\u6210\\n";\r\n\r\n\r\n\r\n\/\/ key \u306e\u7528\u610f\r\n\r\n$file = '\/xxxx\/xxxx\/xxxx\/key.txt';\r\n\r\n$keyxml = simplexml_load_string(file_get_contents($file));\r\n\r\n\r\n\r\n\/\/ \u4ee5\u524d\u3001\u305d\u308c\u305e\u308c\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u6b63\u89e3\u3092\u5fa9\u53f7\u3059\u308b\u3000\u30b3\u30fc\u30c9\u304c\u3000\u6b64\u51e6\u306b\u3042\u3063\u305f\u3002\u73fe\u5728\u306f\u6697\u53f7\u5316\u3055\u308c\u3066\u3044\u306a\u3044\r\n\r\n\r\n\r\n$a_table_name = \"`table_College_Physics`\";\r\n\r\n$sql = \"SELECT id, title, zip FROM $a_table_name;\";\r\n\r\n$result = mysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\n$rows = mysqli_num_rows($result);\r\n\r\necho \"table_College_Physics has \".$rows.\" rows.\\n\";\r\n\r\n\r\nfor ($j = 0; $j < $rows; $j = $j + 1){\r\n\r\n	$row = mysqli_fetch_array($result);\r\n\r\n	$id = $row['id'];\r\n\r\n	$a_file = fopen(\"\/var\/www\/html\/temporary\/$foldername\/tmp.zip\",\"w\");\r\n\r\n	fwrite($a_file, $row['zip']);\r\n\r\n	fclose($a_file);\r\n\r\n	passthru(\"cd \/var\/www\/html\/temporary\/$foldername\/; unzip -q \/var\/www\/html\/temporary\/$foldername\/tmp.zip -d \/var\/www\/html\/temporary\/$foldername\/tmp\/\");\r\n\r\n\r\n\r\n\r\n\r\n\r\n	\/\/ 画像や動画などの media ファイルをリストアップする\r\n\r\n	$fullpath=\"\/var\/www\/html\/temporary\/$foldername\/tmp\/html\/\";\r\n\r\n	$mediaFileArray = array();\r\n\r\n	if ($handle = opendir($fullpath)) {\r\n\r\n		\/\/    echo \"Directory handle: $handle\\n\";\r\n		\/\/    echo \"Entries:\\n\";\r\n\r\n		\/* ディレクトリをループする際の正しい方法です *\/\r\n		\r\n		while (false !== ($entry = readdir($handle))) {\r\n\r\n			if (preg_match('\/gif\/i',$entry) || preg_match('\/jpg\/i',$entry) || preg_match('\/png\/i',$entry) || preg_match('\/svg\/i',$entry) || preg_match('\/mp3\/i',$entry) || preg_match('\/mp4\/i',$entry)) {\r\n\r\n				$mediaFileArray[] = $entry;\r\n			}\r\n\r\n		}\r\n\r\n		closedir($handle);\r\n	}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n	\/\/ htmlフォルダー内の index.html を更新する\r\n\r\n	passthru(\"cp -f .\/simple_question\/html\/index.html \/var\/www\/html\/temporary\/$foldername\/tmp\/html\/\");\r\n	\r\n\r\n\r\n\r\n	$config_text = file_get_contents(\"\/var\/www\/html\/temporary\/$foldername\/tmp\/configfile.xml\");\r\n\r\n	$config_xml = simplexml_load_string($config_text);\r\n\r\n\r\n\r\n	$xmlstr = reConfig($config_xml, $mediaFileArray);\r\n	\r\n\r\n\r\n	\/\/ configfile.xml を置き換える\r\n\r\n	$configfile = fopen(\"\/var\/www\/html\/temporary\/$foldername\/tmp\/configfile.xml\",\"w\");\r\n\r\n	fputs($configfile,$xmlstr);\r\n\r\n	fclose($configfile);\r\n\r\n\r\n	passthru(\"cd \/var\/www\/html\/temporary\/$foldername\/tmp ; zip -q -r \/var\/www\/html\/temporary\/$foldername\/new.zip .\/configfile.xml .\/html\");\r\n\r\n	$zipbinary = file_get_contents(\"\/var\/www\/html\/temporary\/$foldername\/new.zip\");\r\n\r\n	$zipbinary = mysqli_real_escape_string($DB2, $zipbinary);\r\n\r\n\r\n	$sql = \"UPDATE $a_table_name SET zip='$zipbinary' WHERE id='$id'\";\r\n\r\n	$result_UPDATE = mysqli_query($DB2, $sql) or die(mysqli_error($DB));\r\n\r\n	echo \"changed \".$row['title'].\"\\n\";\r\n\r\n\r\n	\/\/ 作業ファイルを消す\r\n\r\n	passthru(\"rm -r \/var\/www\/html\/temporary\/$foldername\/*\");\r\n\r\n}\r\n\r\n\/\/ 以下、関数\r\n\r\nfunction timestamp() {\r\n\r\n	$stamp =  microtime();\r\n\r\n	list($msec, $sec) = explode(\" \", $stamp);\r\n\r\n	$msec = $msec + 1;\r\n\r\n	$msec = (string)$msec*1000000;\r\n\r\n	$msec = substr($msec,1);\r\n\r\n	$timestamp = $sec.$msec;\r\n\r\n	return $timestamp;\r\n\r\n}\r\n\r\nfunction makePhpseclibKey($timestamp) {\r\n\r\n	global $keyxml;\r\n\r\n	$keynum = intval(substr($timestamp,-2,2));\r\n	\r\n	$keytxt = (string) $keyxml->key[$keynum]->public;\r\n\r\n	return $keytxt;\r\n\r\n}\r\n\r\n\r\nfunction reConfig($xml, $mediaFileArray) {\r\n\r\n	$timestamp = timestamp( );\r\n	\r\n	$xml_title = $xml->title;\r\n	\r\n	$xml_keyword = $xml->keyword;	\r\n	\r\n	$xml_edit_where = \"kanaike.susi.oita-u.ac.jp\";\r\n		\r\n	$xml_edit_when = $timestamp;	\r\n	\r\n	$keytxt = makePhpseclibKey($timestamp);\r\n		\r\n	$xml_TextHeight = $xml->TextHeight;\r\n\r\n\r\n\r\n	$examinationSentenceStr = \"\";\r\n\r\n	$examinationSentenceStr = $examinationSentenceStr . \"<texmain><\/texmain>\\n\";\r\n	\r\n	$examinationSentenceStr = $examinationSentenceStr . \"<addFile>\\n\";\r\n	\r\n\r\n	foreach ($mediaFileArray as $node) {\r\n	\r\n		$examinationSentenceStr = $examinationSentenceStr . \"<node><label>\" . htmlspecialchars($node) . \"<\/label><base64><\/base64><\/node>\\n\";\r\n			\r\n	}\r\n\r\n	$examinationSentenceStr = $examinationSentenceStr . \"<\/addFile>\\n\\n\";\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n$configstr = <<< end_of_quote\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n\r\n<root>\r\n\r\n<version>5.10<\/version>\r\n\r\n<server>\r\n<url>https:\/\/kanaike.susi.oita-u.ac.jp<\/url>\r\n<\/server>\r\n\r\n<scriptFolder>\/phpSimpleQuestionNL5.10<\/scriptFolder>\r\n\r\n<cgi>\r\n<url>\/phpSimpleQuestionNL5.10\/answertest_for_NL.php<\/url>\r\n<\/cgi>\r\n\r\n<tex>\r\n<url>\/phpSimpleQuestionNL5.10\/fortex_xml_space.php<\/url>\r\n<\/tex>\r\n\r\n<refer>\r\n<url>\/phpSimpleQuestionNL5.10\/refer_status.php<\/url>\r\n<\/refer>\r\n\r\n<LMSserver><\/LMSserver>\r\n\r\n<UserID><\/UserID>\r\n\r\n<realName><\/realName>\r\n\r\n<record><\/record>\r\n\r\n\r\n<q_ID>$timestamp<\/q_ID>\r\n<q_ID_e><\/q_ID_e>\r\n\r\n<author_name>College_Physics<\/author_name>\r\n\r\n<title>$xml_title<\/title>\r\n\r\n<keyword>$xml_keyword<\/keyword>\r\n\r\n<edit>\r\n<where>$xml_edit_where<\/where>\r\n<when>$xml_edit_when<\/when>\r\n<\/edit>\r\n\r\n<phpseclibKey>$keytxt<\/phpseclibKey>\r\n\r\n<TextHeight>$xml_TextHeight<\/TextHeight>\r\n\r\n<examinationSentence>\r\n$examinationSentenceStr\r\n<\/examinationSentence>\r\n\r\n<common>\r\n<random>\r\n<state>off<\/state>\r\n<\/random>\r\n<languageType>python<\/languageType>\r\n<src><\/src>\r\n<\/common>\r\n\r\n\r\nend_of_quote;\r\n\r\n\r\n\r\n$operation = <<< end_of_quote\r\n# You can use base64, np and sympy.\r\nrawmark = 'null'\r\nfeedback = 'null'\r\ntips = []\r\n#tips.append('Hello!')\r\nstatus = {}\r\n#status['statistics'] = 'no'\r\nif tans == sans:\r\n    status['coincide'] = 'yes'\r\nend_of_quote;\r\n\r\n\r\n	$i = 0;\r\n	$str = '';\r\n\r\n\r\n	foreach ($xml->question as $q) {\r\n\r\n\r\n		$i = $i + 1;\r\n\r\n		$str = $str.\"<question>\\n\\n<num>\".$i.\"<\/num>\\n\";		\r\n		$str = $str.\"<server>http:\/\/egret.susi.oita-u.ac.jp<\/server>\\n\";\r\n		$str = $str.\"<AnswerTest>\".$q->AnswerTest.\"<\/AnswerTest>\\n\";\r\n		$str = $str.\"<searchForPastAnswers>yes<\/searchForPastAnswers>\\n\";		\r\n		$str = $str.\"<Allotment>\".$q->Allotment.\"<\/Allotment>\\n\";\r\n		$str = $str.'<size>'.$q->size.\"<\/size>\\n\";\r\n		$str = $str.\"<verticalSize>\".$q->verticalSize.\"<\/verticalSize>\\n\";\r\n		$str = $str.'<x>'.$q->x.\"<\/x>\\n\";\r\n		$str = $str.'<y>'.$q->y.\"<\/y>\\n\";\r\n		$str = $str.\"<SAns><\/SAns>\\n\";\r\n		$str = $str.'<TAns>'.htmlentities((string)$q->TAns).\"<\/TAns>\\n\";\r\n		$str = $str.'<AnsTestOpt>'.$q->AnsTestOpt.\"<\/AnsTestOpt>\\n\";\r\n		$str = $str.'<operation><text>' . htmlentities($operation) . \"<\/text><\/operation>\\n\";\r\n		$str = $str.\"<\/question>\\n\\n\";\r\n\r\n	}\r\n\r\n	$configstr = $configstr.$str.\"<\/root>\";\r\n\r\n	return $configstr;\r\n}\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u6559\u6750\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092 5.10 \u306b\u3042\u3052\u305f\u306e\u3067\uff0c\u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u79fb\u52d5\u3057\u307e … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-12451","post","type-post","status-publish","format-standard","hentry","category-column"],"_links":{"self":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12451"}],"version-history":[{"count":9,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12451\/revisions"}],"predecessor-version":[{"id":12708,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12451\/revisions\/12708"}],"wp:attachment":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12451"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}