LGToc: edit_section_db.php comparison

modify updating to sections_index table when deletion/recovery

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Fri, 20 Mar 2015 15:32:58 +0100
parents	bd46d26a7b18
children	373c8ecad8b4

comparison

equal deleted inserted replaced

-:bd46d26a7b18
+:5d0bfd909857
 		if ($section_id == 0) {
 			// set section_id from section_index if this is a new section
 			$section_id = mysql_insert_id();
 		}
+		if ($deleted == 1) {
+			// deleted section from sections_index where id = $section_id
+			$qry = "DELETE FROM sections_index WHERE id=".$section_id;
+			$rst = mysql_query($qry);
+			if (!$rst) {
+				break;	// handle to ROLLBACK
+			}
+		} else {
+			$qry = "SELECT * FROM sections_index WHERE id=".$section_id;
+			$rst = mysql_query($qry);
+			if (!$rst) {
+				break;	// handle to ROLLBACK
+			}
+			if (mysql_num_rows($rst) == 0) {
+				$qry = "INSERT INTO sections_index (id,name,books_id,section_after,start_page,end_page,level,split_from) VALUES
+				(".$section_id.",'".$name."','".$books_id."','".$section_after."',".$start_page.
+				",".$end_page.",".$level.",".$split_from.")";
+				// recover section in sections_index table where id = $section_id
+				$rst = mysql_query($qry);
+				if (!$rst) {
+					break;	// handle to ROLLBACK
+				}
+			}
+		}
+		// query for sections_revisions table
 		$str="(";
 		$str.="'".$name."',";
 		$str.="'".$books_id."',";
 		$str.="'".$section_after."',";
 		$str.=$start_page.",";

Mercurial > hg > LGToc