Mercurial > hg > extraction-interface
annotate interface/check_sections.php @ 7:0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
| author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
|---|---|
| date | Fri, 06 Feb 2015 09:44:17 +0100 |
| parents | 883ad980a43b |
| children | da10158c6d0a |
| 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 include_once('edit_section_db.php'); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
5 set_time_limit(0); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
6 ini_set('memory_limit', '-1'); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
7 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
8 $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
|
9 mysql_query("SET NAMES utf8"); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
10 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
11 if (!$link_mysql) { |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
12 die('Could not connect: ' . mysql_error()); |
|
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 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
15 $db_selected = mysql_select_db($mysql_database, $link_mysql); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
16 if (!$db_selected) { |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
17 die ('Can\'t use foo : ' . mysql_error()); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
18 } |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
19 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
20 function checkSections($count){ |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
21 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
22 /* $query="SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
23 FROM sections |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
24 JOIN books ON sections.books_id = books.id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
25 WHERE NOT EXISTS |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
26 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id) |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
27 GROUP BY books_id, start_page, end_page |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
28 HAVING COUNT( * ) >=".$count." |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
29 ORDER BY COUNT( * ) DESC ";*/ |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
30 $query="(SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
31 FROM sections |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
32 JOIN books ON sections.books_id = books.id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
33 WHERE NOT EXISTS |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
34 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id) |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
35 GROUP BY books_id, start_page, end_page |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
36 HAVING COUNT( * ) >=".$count.") |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
37 UNION |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
38 (SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections_revisions.name, start_page, end_page, COUNT( * ) AS count |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
39 FROM sections_revisions |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
40 JOIN books ON sections_revisions.books_id = books.id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
41 JOIN ( |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
42 SELECT sections_versions.id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
43 FROM sections_versions WHERE sections_versions.version=(SELECT MAX(version) FROM sections_versions) |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
44 GROUP BY books_id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
45 ) AS t ON t.id=sections_revisions.versions_id |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
46 WHERE deleted=0 |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
47 GROUP BY books_id, versions_id,start_page, end_page |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
48 HAVING COUNT( * ) >=".$count.") |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
49 ORDER BY count DESC "; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
50 $result = mysql_query($query); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
51 echo mysql_num_rows($result)." result(s)<br><br>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
52 echo "<table>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
53 echo "<tr>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
54 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='sectionName'>section name<td class='sectionName'>page<td class='page'>count"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
55 while ($row = mysql_fetch_assoc($result)) { |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
56 $str="<tr>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
57 $str.="<td>".$row['book_name']; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
58 $str.="<td>".$row['level1']; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
59 $str.="<td>".$row['level2']; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
60 $str.="<td>".$row['period']; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
61 $str.="<td><a href='tagging_text.php?id=".$row['id']."' target='_blank'>".$row['name']."</a>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
62 $str.="<td>p".$row['start_page']."-".$row['end_page']; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
63 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=".$count."' target='_blank'>".$row['count']."</a>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
64 echo $str; |
|
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 echo "</table>"; |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
67 } |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
68 |
|
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
|
69 |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
70 // sorting by the $sort_by parameter |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
71 function checkSections_sort_by($sort_by){ |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
72 switch ($sort_by) { |
|
7
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
73 case '_time': |
|
4
883ad980a43b
add dynasty column to table books
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
1
diff
changeset
|
74 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)"; |
|
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
|
75 $result = mysql_query($query); |
|
7
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
76 if (!$result){ |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
77 echo ("Failed during selecting books table."); |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
78 } |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
79 |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
80 |
|
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
|
81 echo mysql_num_rows($result)." result(s)<br><br>"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
82 echo "<table>"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
83 echo "<tr>"; |
|
4
883ad980a43b
add dynasty column to table books
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
1
diff
changeset
|
84 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year"; |
|
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
|
85 while ($row = mysql_fetch_assoc($result)) { |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
86 $str="<tr>"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
87 $str.="<td>".$row['book_name']; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
88 $str.="<td>".$row['level1']; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
89 $str.="<td>".$row['level2']; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
90 $str.="<td>".$row['period']; |
|
4
883ad980a43b
add dynasty column to table books
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
1
diff
changeset
|
91 $str.="<td>".$row['dynasty']; |
|
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
|
92 $str.="<td>".$row['start_year']; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
93 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
94 echo $str; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
95 } |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
96 echo "</table>"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
97 break; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
98 |
|
7
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
99 case 'time': |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
100 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
101 $result = mysql_query($query); |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
102 if (!$result){ |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
103 echo ("Failed during selecting books table."); |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
104 } |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
105 |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
106 |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
107 echo mysql_num_rows($result)." result(s)<br><br>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
108 echo "<table>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
109 echo "<tr>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
110 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2 <td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year<td class='last_editor'>last_editor<td class='edit_time'>edit_time"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
111 while ($row = mysql_fetch_assoc($result)) { |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
112 $str="<tr>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
113 $str.="<td>".$row['book_name']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
114 $str.="<td>".$row['level1']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
115 $str.="<td>".$row['level2']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
116 $str.="<td>".$row['period']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
117 $str.="<td>".$row['dynasty']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
118 $str.="<td>".$row['start_year']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
119 |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
120 // query last_editor and last_edit_time |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
121 $query_editor = "(SELECT editor, date from sections_versions WHERE books_id='".$row['id']."' ORDER BY version DESC)"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
122 $row_sections_versions = mysql_fetch_assoc(mysql_query($query_editor)); // the first one |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
123 $last_editor = $row_sections_versions['editor']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
124 $last_edit_time = $row_sections_versions['date']; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
125 $str.="<td>".$last_editor; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
126 $str.="<td>".$last_edit_time; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
127 |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
128 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
129 echo $str; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
130 } |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
131 echo "</table>"; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
132 break; |
|
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
133 |
|
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
|
134 default: |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
135 # code... |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
136 echo "no sorting parameter set"; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
137 break; |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
138 } |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
139 } |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
140 |
|
7
0e9a7c69f22c
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
141 |
|
0
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
142 ?> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
143 |
|
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
|
144 |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
145 |
|
0
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
146 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
147 <html> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
148 <head> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
149 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
150 <link href="css/search.css" type="text/css" rel="stylesheet"/> |
|
4
883ad980a43b
add dynasty column to table books
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
1
diff
changeset
|
151 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script> |
|
0
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
152 <!--<script src="js/check_sections.js" charset="utf-8"></script>!--> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
153 </head> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
154 <body> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
155 <form action='check_sections.php' method='GET'> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
156 find sections overlapping more than <input type="text" name="count"> other sections |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
157 <input type="submit" name="find" value="find"> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
158 </form> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
159 <br> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
160 <div id="search_result"> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
161 <?php |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
162 if(isset($_GET['find']) && $_GET['count']!='' && is_numeric($_GET['count'])){ |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
163 checkSections($_GET['count']); |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
164 } |
|
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
|
165 else if(isset($_GET['sort_by'])){ |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
166 checkSections_sort_by($_GET['sort_by']); |
|
ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
167 } |
|
0
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
168 ?> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
169 </div> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
170 </body> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
171 </html> |
|
b12c99b7c3f0
commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
172 |