blob: cdff070a345db130ac6cbe721e9488fe4f5de98f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
<?php
require_once('db-connect.php');
$query = "select id from textbook_companion_chapter where cloud_chapter_err_status=0 and preference_id in (select id from textbook_companion_preference where approval_status=1 and proposal_id in (select id from textbook_companion_proposal where proposal_status=3))";
$result = mysql_query($query);
while($row = mysql_fetch_object($result)) {
$query = "select count(id) as cid from textbook_companion_example where chapter_id=".$row->id." and cloud_err_status=0";
$res = mysql_query($query);
$rec = mysql_fetch_object($res);
$cid = (int)($rec->cid);
if($cid == 0) {
$query = "update textbook_companion_chapter set cloud_chapter_err_status=1 where id=".$row->id;
mysql_query($query);
}
}
$query = "select id from textbook_companion_preference where approval_status=1 and proposal_id in (select id from textbook_companion_proposal where proposal_status=3)";
$result = mysql_query($query);
while($row = mysql_fetch_object($result)) {
$query = "select count(id) as cid from textbook_companion_chapter where cloud_chapter_err_status=0 and preference_id=".$row->id;
$res = mysql_query($query);
$rec = mysql_fetch_object($res);
$cid = (int)($rec->cid);
if($cid == 0) {
$query = "update textbook_companion_preference set cloud_pref_err_status=1 where id=".$row->id;
mysql_query($query);
}
}
?>
|
