Mercurial > hg > extraction-interface

annotate interface/edit_section_db.php @ 3:f196939ccc03

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
error handle and alert feedback to user. If error occurs, user'll not be halted by the loading page and sections_revisions will recovery to previous version.
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Mon, 26 Jan 2015 12:19:39 +0100
parents da5309d54083
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
1 <?php
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
2 include_once('Lib_mb_utf8.php');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
3 include_once('config.php');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
4 set_time_limit(0);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
5 ini_set('memory_limit', '-1');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
6
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
7 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
8 mysql_query("SET NAMES utf8");
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
9
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
10 if (!$link_mysql) {
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
11 die('Could not connect: ' . mysql_error());
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
12 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
13
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
14 $db_selected = mysql_select_db($mysql_database, $link_mysql);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
15 if (!$db_selected) {
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
16 die ('Can\'t use foo : ' . mysql_error());
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
17 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
18 function checkSectionInfo($bookId){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
19 $query="SELECT * FROM sections_versions WHERE books_id=".$bookId." ORDER BY version DESC";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
20 $result=mysql_query($query);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
21 if(mysql_num_rows($result)==0){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
22 $row['version']=0;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
23 $row['editor']="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
24 $row['date']="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
25 return $row;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
26 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
27 $row=mysql_fetch_assoc($result);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
28 return $row;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
29 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
30 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
31 function checkMissingPage($bookInfo,$versionInfo){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
32 $bookId=$bookInfo['id'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
33 $bookPage=$bookInfo['line'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
34 if($versionInfo['version']!=0){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
35 $table="sections_revisions";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
36 $condition=" AND versions_id=".$versionInfo['id']." AND deleted=0 ";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
37 $versionId=$versionInfo['id'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
38 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
39 $table="sections";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
40 $condition="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
41 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
42 $query="SELECT *
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
43 FROM ".$table."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
44 WHERE books_id=".$bookId." ".$condition."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
45 GROUP BY books_id,start_page,end_page
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
46 ORDER BY books_id,start_page,level,end_page";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
47 $result=mysql_query($query);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
48 $lastPage=1;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
49 $i=0;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
50 $pageArray=array();
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
51 while($row=mysql_fetch_assoc($result)){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
52 if($row['start_page']-1>$lastPage){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
53 $pageArray[$i]['start_page']=$lastPage;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
54 $pageArray[$i]['end_page']=$row['start_page'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
55 //echo $pageArray[$i]['start_page']." ".$pageArray[$i]['end_page']."<br>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
56 $i++;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
57 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
58 $lastPage=$row['end_page'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
59 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
60 if($bookPage>$lastPage){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
61 $pageArray[$i]['start_page']=$lastPage;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
62 $pageArray[$i]['end_page']=$bookPage;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
63 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
64 return $pageArray;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
65 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
66 function getSectionArray($bookId,$count,$versionInfo){
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
67
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
68 $str="";
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
69 if($versionInfo['version']!=0){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
70 $table="sections_revisions";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
71 $condition="AND deleted=0 ";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
72 $condition=" AND versions_id=".$versionInfo['id']." AND deleted=0 ";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
73 }else{
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
74 $table="sections";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
75 $condition="";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
76 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
77
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
78 // echo "select from ".$table."\n";
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
79
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
80
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
81 $query="SELECT *
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
82 FROM ".$table."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
83 WHERE books_id=".$bookId." ".$condition."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
84 GROUP BY books_id, start_page, end_page
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
85 HAVING COUNT( * ) >=".$count."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
86 ORDER BY id ASC";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
87 /*ORDER BY start_page ASC, level ASC, id ASC,end_page DESC";*/
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
88 $result=mysql_query($query);
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
89
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
90 $i=0;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
91 $pageArray=array();
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
92 while($row=mysql_fetch_assoc($result)){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
93 $pageArray[$i]['start_page']=$row['start_page'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
94 $pageArray[$i]['end_page']=$row['end_page'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
95 $i++;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
96 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
97 if($versionInfo['version']!=0){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
98 $query="SELECT id AS revisions_id, name,books_id,section_after,start_page,end_page,level,split_from,sections_id AS id, deleted FROM sections_revisions WHERE versions_id=".$versionInfo['id']." ORDER BY revisions_id ASC";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
99 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
100 $query="SELECT * FROM sections WHERE books_id=".$bookId." ORDER BY id ASC";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
101 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
102 $result=mysql_query($query);
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
103
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
104 $i=0;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
105 $sectionArray=array();
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
106 while($row=mysql_fetch_assoc($result)){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
107 $flag="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
108 if($i!=sizeof($pageArray) && $pageArray[$i]['start_page']==$row['start_page'] && $pageArray[$i]['end_page']==$row['end_page']){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
109 $flag="overlapper";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
110 $i++;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
111 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
112 if($i!=0 && $pageArray[$i-1]['start_page']==$row['start_page'] && $pageArray[$i-1]['end_page']==$row['end_page']){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
113 $flag="overlapper";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
114 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
115 $row['flag']=$flag;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
116 if(!isset($row['deleted'])){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
117 $row['deleted']="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
118 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
119 if($row['deleted']==0){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
120 $row['deleted']="";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
121 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
122 $row['deleted']="deleted";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
123 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
124 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
125 $sectionArray[]=$row;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
126 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
127 return $sectionArray;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
128 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
129 function updateSectionArray($bookId,$sectionArray,$version,$editor){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
130 $query="INSERT INTO sections_versions (version,editor,date,books_id) VALUES (".($version+1).",'".$editor."',NOW(),'".$bookId."')";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
131 $result=mysql_query($query);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
132 if(!$result){
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
133 echo json_encode("Failed during inserting sections_version records."); // .mysql_error();
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
134 return;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
135 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
136 $versionId=mysql_insert_id();
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
137 $query="INSERT INTO sections_revisions (name,books_id,section_after,start_page,end_page,level,split_from,sections_id,versions_id,deleted) VALUES ";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
138 foreach($sectionArray as $idx=>$row){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
139 $str="(";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
140 $str.="'".$row['name']."',";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
141 $str.="'".sprintf("%05d",$row['booksId'])."',";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
142 $str.="'".$row['sectionAfter']."',";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
143 $str.=$row['startPage'].",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
144 $str.=$row['endPage'].",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
145 $str.=$row['level'].",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
146 $str.=$row['splitFrom'].",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
147 $str.=$row['id'].",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
148 $str.=$versionId.",";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
149 $str.=$row['deleted'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
150 $str.=")";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
151 if($idx!=sizeof($sectionArray)-1){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
152 $str.=", ";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
153 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
154 $query.=$str;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
155 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
156 $result=mysql_query($query);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
157 if(!$result){
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
158 echo json_encode("Failed during inserting sections_revisions records."); // .mysql_error();
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
159
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
160 // Delete the sections_versions for this user
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
161 // delete $versionId in table sections_versions
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
162 $query="DELETE FROM sections_versions WHERE id=".$versionId;
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
163 $result_deleting=mysql_query($query);
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
164 if(!$result_deleting){
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
165 echo json_encode("Failed during deleting wrongly inserted sections_version record.");
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
166 }
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
167 return;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
168 }else{
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
169 echo json_encode("Succeeded.");
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
170 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
171 }
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
172
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
173
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
174 function _select_distinct(){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
175 /*
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
176 $query="SELECT DISTINCT (books_id) FROM sections";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
177
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
178 $result=mysql_query($query);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
179 if(!$result){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
180 echo json_encode("Failed during inserting section records.");
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
181 return;
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
182 }else{
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
183 echo json_encode("Succeeded.");
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
184 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
185
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
186 while($row=mysql_fetch_assoc($result)){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
187 // echo $row['books_id'], ", ";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
188 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
189
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
190 echo "section num: ".mysql_num_rows($result);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
191 echo '\n';
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
192 */
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
193
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
194
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
195 //$query="SELECT id FROM books WHERE id NOT IN (SELECT DISTINCT (books_id) FROM sections)";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
196 $query="SELECT books.id, books.name FROM books LEFT JOIN sections ON books.id=sections.books_id WHERE sections.books_id IS NULL";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
197
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
198 $result=mysql_query($query);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
199 if(!$result){
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
200 echo json_encode("Failed during querying records.");
2
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
201 return;
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
202 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
203
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
204 echo "missing books num: ".mysql_num_rows($result);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
205 echo '\n';
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
206
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
207
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
208
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
209
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
210 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
211
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
212
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
213
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
214 function add_missing_books_to_sections(){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
215 // find missing books
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
216 // Run the following line/mysql to find out what books are missing in sections table
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
217 // _select_distinct();
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
218 // Or load missing_books_id.csv
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
219 if (($missing_books = fopen("intermediate_results/missing_books.csv", "r")) !== FALSE) {
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
220 while (($data = fgetcsv($missing_books, ",")) !== FALSE) {
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
221
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
222 $bookId = $data[0];
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
223 $name = $data[1];
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
224
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
225 _add_book_to_sections($name, $bookId);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
226
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
227 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
228 fclose($missing_books);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
229 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
230
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
231 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
232
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
233
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
234 function _add_book_to_sections($name, $bookId){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
235
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
236 /*
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
237 // get Auto_increment
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
238 $query = mysql_query("SHOW TABLE STATUS WHERE name='sections'");
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
239 if (mysql_num_rows($query)) {
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
240 $result = mysql_fetch_assoc($query);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
241 echo $result['Auto_increment'];
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
242 } else {//error
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
243 //error control here
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
244 echo "error in getting Auto_increment";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
245 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
246 */
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
247
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
248 // id should be autoincremated
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
249 $query="INSERT INTO sections (name,books_id,section_after) VALUES ";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
250
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
251 $str="(";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
252 $str.="'".$name."','";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
253 $str.=$bookId."',";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
254 $str.="''";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
255 $str.=")";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
256 $query.=$str;
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
257
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
258 // echo $name.", ".$bookId."\n";
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
259
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
260 $result=mysql_query($query);
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
261 if(!$result){
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
262 echo json_encode("Failed during inserting section records.");
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
263 return;
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
264 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
265 // echo mysql_insert_id();
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
266
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
267 }
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
268
da5309d54083 add missing books to sections as dummy entries for further modification.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
269
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
270 if(isset($_POST['command']) && $_POST['command']!=''){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
271 $command=$_POST['command'];
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
272 if($command=="write"){
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
273
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
274 if(isset($_POST['bookId'])&&isset($_POST['sectionArray'])&&isset($_POST['version'])&&isset($_POST['editor'])&&\
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
275 is_numeric($_POST['bookId']) && sizeof($_POST['sectionArray'])!=0 && is_numeric($_POST['version']) && $_POST['editor']!=""){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
276 $bookId=$_POST['bookId'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
277 $sectionArray=$_POST['sectionArray'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
278 $version=$_POST['version'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
279 $editor=$_POST['editor'];
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
280
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
281 updateSectionArray($bookId,$sectionArray,$version,$editor);
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
282 }
3
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
283 else{
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
284 echo json_encode("Editing info not correct.");
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
285
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
286 }
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
287 }
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
288 else{
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
289 echo json_encode("Wrong command.");
f196939ccc03 error handle and alert feedback to user.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 2
diff changeset
290 return;
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
291 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
292 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
293
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
294 ?>