29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
| $pagename = preg_replace("/[^a-zA-Z0-9_]/i", '', $pagename);
$pageRID = $db->QueryRow('SELECT `redirectID` FROM `' . $dbtable['page'] . '` WHERE `name`=\'' . $pagename. '\' and `active`=1 AND `lang`=\'' . $lang . '\' LIMIT 1');
$redirectID = '';
if (($redirectID != '') and ($redirectID != '0')) $pagename = $pageRID['redirectID'];
}
$content['page'] = $pagename;
$page = $db->QueryRow('SELECT * FROM `' . $dbtable['page'] . '` WHERE `name`=\'' . $pagename . '\' AND `active`=1 AND `lang`=\'' . $lang . '\' LIMIT 1');
$lng = $db->QueryRow('SELECT * FROM `' . $dbtable['languages'] . '` WHERE `iso`=\'' . $lang . '\' AND `active`=1');
if (!$page['ID'] || !$lng['ID']) {
header("HTTP/1.0 404 Not Found");
exit();
}
$content['Title'] = $page['title'];
list($tplname) = $db->QueryRow('SELECT `name` FROM `' . $dbtable['tpl'] . '` WHERE `ID`=\'' . $page['tplID'] . '\' AND `opt`=0');
if ($page['ptplID'] == 0)
list($ptplname) = $db->QueryRow('SELECT `name` FROM `' . $dbtable['tpl'] . '` WHERE `name`=\'' . $tplname . '\' AND `opt`=2');
else
list($ptplname) = $db->QueryRow('SELECT `name` FROM `' . $dbtable['tpl'] . '` WHERE `ID`=\'' . $page['ptplID'] . '\' AND `opt`=2');
|