/**
* Reads all titles into the static property, $all
*/
public static function load_all_from_db()
{
Title::$all = array();
$db = DB::get_db();
$rows = DB::fetchall(sprintf("SELECT * FROM titles ORDER BY LOWER(title)"));
foreach ($rows as $row) {
$title = Title::from_row($row);
array_push(Title::$all, $title);
}
}
public static function all()
{
$db = DB::get_db();
$users = array();
$rows = DB::fetchall(sprintf("SELECT id, login, roles FROM users"));
foreach ($rows as $row) {
$users[] = new User($row["login"], $row["roles"], $row["id"]);
}
return $users;
}
/**
* Returns textual error messages for anything which prevent this issue from
* being queued for review
*/
public function errors()
{
$err = array();
// Missing publication
if ($this->publication() == NULL) {
$err[] = "unable to infer publication due to missing LCCN or bad title list";
}
// Missing required metadata
if ($this->missing_metadata()) {
$err[] = "not all metadata has been filled in";
}
// Dupe of an already-ingested issue
$db = DB::get_db();
$rows = DB::fetchall(sprintf("SELECT * FROM issues_processed WHERE issue_key = '%s'", $db->real_escape_string($this->key())));
if (count($rows) > 0) {
$batch_name = $rows[0]["batch_name"];
$err[] = "an issue with the same lccn, date, and edition was ingested in '{$batch_name}'";
}
// Not all pages filled out
if (count($this->meta->page_labels) < count($this->pages())) {
$err[] = "the number of page labels doesn't match the number of pages";
}
foreach ($this->meta->page_labels as $label) {
if ($label == NULL || $label == "") {
$err[] = "not all pages have been labeled";
break;
}
}
return $err;
}
<?php
require_once __DIR__ . "/includes/root.php";
must_allow("list audit logs");
$db = DB::get_db();
$rows = DB::fetchall(sprintf("SELECT * FROM audit_logs order by `when` desc LIMIT 1000"));
$logs = array();
foreach ($rows as $row) {
array_push($logs, $row);
}
$renderer->variable("logs", $logs);
$renderer->variable("title", "Audit logs");
$renderer->render("audit-logs-list");
/**
* 获得数据表的序列化结构
*
* @param DB $db 数据库操作对象
* @param string $dbname 数据库名
* @return string $result 序列后的数据表结构
*
*/
function db_table_serialize($db, $dbname)
{
$tables = $db->fetchall('SHOW TABLES');
if (empty($tables)) {
return '';
}
$struct = array();
foreach ($tables as $value) {
$structs[] = db_table_schema($db, substr($value['Tables_in_' . $dbname], strpos($value['Tables_in_' . $dbname], '_') + 1));
}
return iserializer($structs);
}
/**
* Returns the MOC with the given id
*/
public static function find($id)
{
$db = DB::get_db();
$rows = DB::fetchall(sprintf("SELECT * FROM mocs WHERE id = %d", $id));
return MOC::from_row($rows[0]);
}
