--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/interface/add_dynasty.php	Tue Jan 27 16:40:30 2015 +0100
@@ -0,0 +1,99 @@
+<?php
+
+include_once('Lib_mb_utf8.php');
+include_once('config.php');
+set_time_limit(0);
+ini_set('memory_limit', '-1');
+
+$link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
+mysql_query("SET NAMES utf8");
+
+if (!$link_mysql) {
+    die('Could not connect: ' . mysql_error());
+}
+
+$db_selected = mysql_select_db($mysql_database, $link_mysql);
+if (!$db_selected) {
+    die ('Can\'t use foo : ' . mysql_error());
+}
+
+
+function add_dynasty($dynasty_info){
+	$dynasty = $dynasty_info[0];
+	$start_year = $dynasty_info[1];
+	$end_year = $dynasty_info[2];
+
+	$dir_path = "dynasty_period_list/";
+	$myfile = fopen($dir_path.$dynasty.".txt", "r") or die("Unable to open file!");
+	
+	// Output one line until end-of-file
+	while(!feof($myfile)) {
+		$line = fgets($myfile);
+		$splited_line = preg_split('/\r\n|\r|\n/', $line);
+		$matched_period = $splited_line[0];
+
+		$query="SELECT id, period, start_year FROM books WHERE period='".$matched_period."'";
+
+		$result=mysql_query($query);
+	
+		if(!$result){
+			echo json_encode("Failed during querying records.");
+			return;
+		}
+		while($row=mysql_fetch_assoc($result)){
+			echo $row['id']." ".$row['period']."<br>";
+			if ($row['start_year'] > ($start_year-10) && $row['start_year'] < ($end_year+10)) {
+				// write $dynasty into record
+				$query="UPDATE books SET dynasty='".$dynasty."' WHERE id='".$row['id']."'";
+				$res=mysql_query($query);
+				if(!$res){
+					echo json_encode("Failed during querying records.");
+					return;
+				}
+			}
+			
+		}
+		echo "----------".$matched_period." books number: ".mysql_num_rows($result)."<br>";
+	}
+
+	fclose($myfile);
+
+}
+
+
+
+$dynasty = array("漢",-140,200);
+add_dynasty($dynasty);
+$dynasty = array("三國",220,280);
+add_dynasty($dynasty);
+$dynasty = array("晉",265,420);
+add_dynasty($dynasty);
+$dynasty = array("南北朝",386,589);
+add_dynasty($dynasty);
+$dynasty = array("隋",581,618);
+add_dynasty($dynasty);
+$dynasty = array("唐",618,907);
+add_dynasty($dynasty);
+$dynasty = array("五代",907,959);
+add_dynasty($dynasty);
+$dynasty = array("宋",960,1279);
+add_dynasty($dynasty);
+$dynasty = array("遼",916,1125);
+add_dynasty($dynasty);
+$dynasty = array("金",1115,1234);
+add_dynasty($dynasty);
+$dynasty = array("元",1260,1367);
+add_dynasty($dynasty);
+$dynasty = array("西夏",1032,1227);
+add_dynasty($dynasty);
+$dynasty = array("明",1368,1644);
+add_dynasty($dynasty);
+$dynasty = array("清",1616,1911);
+add_dynasty($dynasty);
+$dynasty = array("民國",1911,9999);
+add_dynasty($dynasty);
+
+
+// dynasty list ref: http://dict.revised.moe.edu.tw/htm/fulu/nh.htm
+
+?>
\ No newline at end of file