{$cm_text["check-welcome"]}
\n"; echo "{$cm_text["check-chkcontent"]}
\n"; if ($cm_remoteroot) { $cm_indexpath = $cm_mainroot; } else { $cm_indexpath = str_replace (basename (__FILE__), "", __FILE__) . $cm_mainroot; } echo "\n";
$result1 = db_query("select cmdb_type, cmdb_directory, cmdb_parentdir, cmdb_author_user, cmdb_owner_user, cmdb_viewer_group, id from " . CM_DB_PREFIX . "content3 where cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
while ($row1 = db_fetch_row($result1)) {
$cm_chk_error = false;
echo "{$cm_text["check-record"]} $row1[6] $row1[1]
";
// Check existence of directory.
if (!file_exists ($cm_indexpath . $row1[1])) {
echo "{$cm_text["check-nodir"]}
";
$cm_chk_error = true;
}
// Check existence of parent directory.
$cm_apparent_parent = substr ($row1[1], 0, strrpos ($row1[1], "/"));
$cm_apparent_parent2 = $cm_apparent_parent;
if (!$cm_apparent_parent)
$cm_apparent_parent = "/";
if ($cm_apparent_parent = $row1[2]) {
if (!file_exists ($cm_indexpath . $cm_apparent_parent2)) {
echo "{$cm_text["check-noparentdir"]} " . $cm_indexpath . $cm_apparent_parent2 . "
";
$cm_chk_error = true;
}
}
else {
echo "{$cm_text["check-invalidparent"]} " . $cm_indexpath . $cm_apparent_parent2 . "
";
$cm_chk_error = true;
}
// Check existence of author.
$result2 = db_query("select kurz from " . CM_PP_PREFIX . "users where kurz = '$row1[3]'") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-noauthor"]} $row1[3]
";
$cm_chk_error = true;
}
// Check existence of owner.
$result2 = db_query("select kurz from " . CM_PP_PREFIX . "users where kurz = '$row1[4]'") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-noowner"]} $row1[4]
";
$cm_chk_error = true;
}
// Check existence of viewer group.
if ($groups) {
if ($row1[5]) {
$result2 = db_query("select kurz from " . CM_PP_PREFIX . "gruppen where kurz = '$row1[5]'") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-noviewer"]} $row1[5]
";
$cm_chk_error = true;
}
}
else {
echo "{$cm_text["check-noviewerdef"]} $row1[5]
";
$cm_chk_error = true;
}
if (!$cm_chk_error) {
echo "{$cm_text["check-ok"]}
";
}
}
}
echo "
{$cm_text["check-chkhits"]}
\n"; echo "\n";
$result1 = db_query("select cmdb_type, cmdb_directory, id from " . CM_DB_PREFIX . "cmhits3 where cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
while ($row1 = db_fetch_row($result1)) {
echo "{$cm_text["check-record"]} $row1[2] $row1[1]
";
$cm_chk_error = false;
// Check existence of referenced page.
$result2 = db_query("select cmdb_type, cmdb_directory from " . CM_DB_PREFIX . "content3 where cmdb_directory = '$row1[1]' and cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-nopage"]}
";
$cm_chk_error = true;
}
if (!$cm_chk_error) {
echo "{$cm_text["check-ok"]}
";
}
}
echo "
{$cm_text["check-chkcomments"]}
\n"; echo "\n";
$result1 = db_query("select cmdb_type, cmdb_directory, cmdb_author_user, id from " . CM_DB_PREFIX . "cmcomments3 where cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
while ($row1 = db_fetch_row($result1)) {
echo "{$cm_text["check-record"]} $row1[3] $row1[1]
";
$cm_chk_error = false;
// Check existence of referenced page.
$result2 = db_query("select cmdb_type, cmdb_directory from " . CM_DB_PREFIX . "content3 where cmdb_directory = '$row1[1]' and cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-nopage"]}
";
$cm_chk_error = true;
}
// Check existence of author.
$result2 = db_query("select kurz from " . CM_PP_PREFIX . "users where kurz = '$row1[2]'") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-noauthor"]} $row1[2]
";
$cm_chk_error = true;
}
if (!$cm_chk_error) {
echo "{$cm_text["check-ok"]}
";
}
}
echo "
{$cm_text["check-chkratings"]}
\n"; echo "\n";
$result1 = db_query("select cmdb_directory, cmdb_author_user, id from " . CM_DB_PREFIX . "cmrating3 order by cmdb_directory") or db_die();
while ($row1 = db_fetch_row($result1)) {
echo "{$cm_text["check-record"]} $row1[2] $row1[0]
";
$cm_chk_error = false;
// Check existence of referenced page.
$result2 = db_query("select cmdb_type, cmdb_directory from " . CM_DB_PREFIX . "content3 where cmdb_directory = '$row1[0]' and cmdb_type like '%" . CM_HITTYPE_PAGE . "%' order by cmdb_directory") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-nopage"]}
";
$cm_chk_error = true;
}
// Check existence of author.
$result2 = db_query("select kurz from " . CM_PP_PREFIX . "users where kurz = '$row1[1]'") or db_die();
$row2 = db_fetch_row($result2);
if (!$row2[0]) {
echo "{$cm_text["check-noauthor"]} $row1[1]
";
$cm_chk_error = true;
}
if (!$cm_chk_error) {
echo "{$cm_text["check-ok"]}
";
}
}
echo "
{$cm_text["check-welcome"]}
"; echo "{$cm_text["setup-currentuser"]} $user_kurz
";
echo "{$cm_text["setup-superuseris"]} $cm_superuser