public static function getElements($zoneName, $parent, $language, $currentElement, $selectedElement, $order = 'asc', $startFrom = 0, $limit = null, $includeHidden = false)
{
$answer = array();
if ($parent == null) {
$parent = DbFrontend::getRootElementId($zoneName, $language);
}
$sql = "select * from `" . DB_PREF . "content_element` where `parent` = " . (int) $parent . "";
if (!$includeHidden) {
$sql .= " and `visible` ";
}
$sql .= " order by `row_number` " . $order . " ";
if ($limit !== null) {
$sql .= " limit " . (int) $startFrom . ", " . (int) $limit;
}
$rs = mysql_query($sql);
if ($rs) {
while ($lock = mysql_fetch_assoc($rs)) {
$answer[] = $lock;
}
} else {
trigger_error($sql . " " . mysql_error());
}
return $answer;
}
