now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 AND doc_top = 1 ORDER BY child_order, doc_date DESC", $linkid);
}
elseif ($navdata['doc_childorder'] == 2) {
$navlistresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_childorder, doc_shorturl FROM documents, documentchildren WHERE child_related = doc_id AND child_document = '$navdata[doc_id]' AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 AND doc_top = 1 ORDER BY doc_title, doc_date DESC", $linkid);
}
elseif ($navdata['doc_childorder'] == 3) {
$navlistresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_childorder, doc_shorturl FROM documents, documentchildren WHERE child_related = doc_id AND child_document = '$navdata[doc_id]' AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 AND doc_top = 1 ORDER BY doc_date, doc_id", $linkid);
}
else {
$navlistresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_childorder, doc_shorturl FROM documents, documentchildren WHERE child_related = doc_id AND child_document = '$navdata[doc_id]' AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 AND doc_top = 1 ORDER BY doc_date DESC, doc_id", $linkid);
}
$menucount = 1;
if (mysql_num_rows($navlistresult) > 0) {
while ($navlistdata = mysql_fetch_array($navlistresult)) {
if ($navlistdata['doc_shorturl'] <> "") {
$link = $navlistdata['doc_shorturl'];
}
else {
$link = "main.php?p=$navlistdata[doc_id]&s=$site";
}
?>
11) {
echo "$title ";
}
?>
"0000-00-00" AND $data['doc_showdate'] == 1) {
echo $data['DATE'];
}
?>
0) {
$fileresult = mysql_query("SELECT * FROM files WHERE file_id = $file", $linkid);
$filedata = mysql_fetch_array($fileresult);
echo "
";
echo "";
if ($filedata['file_icon'] <> "") {
echo "";
}
echo "
";
}
echo $content;
if ($data['doc_script'] <> "") {
echo "
$data[doc_script]
";
}
if ($data['doc_id'] == 11) {
require_once("include/gallery.php");
}
elseif ($data['doc_id'] == 93 OR $data['doc_id'] == 38) {
require_once("include/subscribe.php");
}
elseif ($data['doc_id'] == 36) {
require_once("include/guest.php");
}
elseif ($data['doc_id'] == 72) {
?>
now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 ORDER BY child_order, doc_date DESC LIMIT $limit1, $limit2", $linkid);
$countresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0", $linkid);
}
elseif ($data['doc_childorder'] == 2) {
$result = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_shorturl, doc_link, doc_inchildlist FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 ORDER BY doc_title, doc_date DESC LIMIT $limit1, $limit2", $linkid);
$countresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0", $linkid);
}
elseif ($data['doc_childorder'] == 3) {
$result = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_shorturl, doc_link, doc_inchildlist FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 ORDER BY doc_date, doc_id LIMIT $limit1, $limit2", $linkid);
$countresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0", $linkid);
}
else {
$result = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate, doc_shorturl, doc_link, doc_inchildlist FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0 ORDER BY doc_date DESC, doc_id LIMIT $limit1, $limit2", $linkid);
$countresult = mysql_query("SELECT doc_title, doc_content, doc_preview, doc_link, doc_date, doc_file, doc_id, doc_source, date_format(doc_date, '%b %D, %Y') AS DATE, doc_showdate FROM documents, documentchildren WHERE child_related = doc_id AND child_document = $data[doc_id] AND doc_visible = 1 AND (doc_enddate > now() OR doc_enddate = '0000-00-00') AND (doc_startdate <= now()) AND doc_delete = 0 AND doc_tempid = 0", $linkid);
}
if ($data['doc_showgallery'] == 1) {
echo "
";
showGallery($data['doc_id']);
echo "
";
}
?>
";
showChildren($result, $pid, $countresult, 10, $data['doc_childtype']);
echo "";
}
?>