function parse($args, $page)
{
global $pagestore, $LkTbl, $PgTbl;
$text = '';
$first = 1;
$q1 = $pagestore->dbh->query("SELECT link, SUM(count) AS ct FROM {$LkTbl} " . "GROUP BY link ORDER BY ct DESC, link");
while ($result = $pagestore->dbh->result($q1)) {
$q2 = $pagestore->dbh->query("SELECT lastversion FROM {$PgTbl} " . "WHERE title='{$result['0']}'");
if (!($r2 = $pagestore->dbh->result($q2)) || empty($r2[0])) {
if (!$first) {
$text = $text . "\n";
} else {
$first = 0;
}
$text = $text . '(' . html_url(findURL($result[0]), $result[1]) . ') ' . html_ref($result[0], $result[0]);
}
}
return html_code($text);
}
function view_macro_refs()
{
global $pagestore, $LkTbl, $PgTbl;
$text = '';
$first = 1;
// It's not quite as straightforward as one would imagine to turn the
// following code into a JOIN, since we want to avoid multiplying the
// number of links to a page by the number of versions of that page that
// exist. If anyone has some efficient suggestions, I'd be welcome to
// entertain them. -- ScottMoonen
$q1 = $pagestore->dbh->query("SELECT link, SUM(count) AS ct FROM {$LkTbl} " . "GROUP BY link ORDER BY ct DESC, link");
while ($result = $pagestore->dbh->result($q1)) {
$esc_page = addslashes($result[0]);
$q2 = $pagestore->dbh->query("SELECT MAX(version) FROM {$PgTbl} " . "WHERE title='{$esc_page}'");
if (($r2 = $pagestore->dbh->result($q2)) && !empty($r2[0])) {
if (!$first) {
$text = $text . "\n";
} else {
$first = 0;
}
$text = $text . '(' . html_url(findURL($result[0]), $result[1]) . ') ' . html_ref($result[0], $result[0]);
}
}
return html_code($text);
}
$pagestore->unlock();
header('Location: ' . $AdminScript);
}
} else {
if ($blocking) {
if (empty($Block) && empty($Unblock)) {
$html = '';
if ($RatePeriod == 0) {
$html = $html . html_bold_start() . ACTION_RateControlIpBlocking . html_bold_end() . html_newline();
}
$html = $html . html_rate_start();
$blocklist = rateBlockList($pagestore->dbh);
foreach ($blocklist as $block) {
$html = $html . html_rate_entry($block);
}
$html = $html . html_rate_end();
template_admin(array('html' => $html));
} else {
if (!empty($Block)) {
rateBlockAdd($pagestore->dbh, $address);
} else {
if (!empty($Unblock)) {
rateBlockRemove($pagestore->dbh, $address);
}
}
header('Location: ' . $AdminScript);
}
} else {
template_admin(array('html' => html_url($AdminScript . '?locking=1', ACTION_LockUnlockPages) . html_newline() . html_url($AdminScript . '?blocking=1', ACTION_BLockUnblockHosts) . html_newline()));
}
}
}
} else {
if ($blocking) {
if (empty($Block) && empty($Unblock)) {
$GLOBALS['phpgw']->common->phpgw_header();
$html = '';
if ($RatePeriod == 0) {
$html = $html . html_bold_start() . lang('Rate control / IP blocking disabled') . html_bold_end() . html_newline();
}
$html = $html . html_rate_start();
$blocklist = $pagestore->rateBlockList();
foreach ($blocklist as $block) {
$html = $html . html_rate_entry($block);
}
$html = $html . html_rate_end();
template_admin(array('html' => $html));
} else {
if (!empty($Block)) {
$pagestore->rateBlockAdd($address);
} else {
if (!empty($Unblock)) {
$pagestore->rateBlockRemove($address);
}
}
header('Location: ' . $AdminScript);
}
} else {
$GLOBALS['phpgw']->common->phpgw_header();
template_admin(array('html' => html_url($AdminScript . '&locking=1', lang('Lock / unlock pages')) . html_newline() . html_url($AdminScript . '&blocking=1', lang('Block / unblock hosts')) . html_newline()));
}
}
