/**
*
*/
function get($name)
{
$result = xanth_db_query("SELECT * FROM entry_type WHERE name = '%s'", $name);
if ($row = xanth_db_fetch_object($result)) {
return new xEntryType($row->name, $row->view_mode_id);
}
return NULL;
}
/**
*
*/
function exists($access_rule)
{
$result = xanth_db_query("SELECT * FROM access_rule WHERE name = '%s'", $access_rule);
if ($row = xanth_db_fetch_object($result)) {
return TRUE;
}
return FALSE;
}
/**
*
*/
function find_all()
{
$elems = array();
$result = xanth_db_query("SELECT * FROM visual_element");
while ($row = xanth_db_fetch_object($result)) {
$elems[] = new xVisualElement($row->name);
}
return $elems;
}
/**
*
*/
function get($area_name)
{
$elems = array();
$result = xanth_db_query("SELECT * FROM theme_area WHERE name = '%s'", $area_name);
if ($row = xanth_db_fetch_object($result)) {
return new xThemeArea($row->name, $row->view_mode);
}
return NULL;
}
/**
* Return a new xContentFormat object or NULL
*/
function load($name)
{
$result = xanth_db_query("SELECT * FROM content_format WHERE name = '%s'", $name);
if ($row = xanth_db_fetch_object($result)) {
$format = new xContentFormat($row->name, $row->description);
return $format;
}
return NULL;
}
/**
*
*/
function get_default_for_element($visual_element)
{
$modes = array();
$result = xanth_db_query("SELECT * FROM view_mode WHERE relative_visual_element = '%s' AND default_for_element = %d", $visual_element, TRUE);
if ($row = xanth_db_fetch_object($result)) {
return new xViewMode($row->id, $row->name, $row->relative_visual_element, $row->default_for_element, $row->display_procedure);
}
return NULL;
}
/**
*
*/
function get_view_mode_procedure($element)
{
if (isset($this->themed_elements[$element])) {
$result = xanth_db_query("SELECT * FROM view_mode WHERE id = %d", $this->themed_elements[$element]);
if ($row = xanth_db_fetch_object($result)) {
return $row->display_procedure;
}
return NULL;
} else {
//return the default view mode for element
$result = xanth_db_query("SELECT * FROM view_mode WHERE relative_visual_element = '%s' AND default_for_element = %d", $element, TRUE);
if ($row = xanth_db_fetch_object($result)) {
return $row->display_procedure;
}
xanth_log(LOG_LEVEL_FATAL_ERROR, 'Default view mode for visual element ' . $element . ' not found', __CLASS__ . '::' . __FUNCTION__);
return NULL;
}
}
/**
*
*/
function has_access_rule($access_rule)
{
$result = xanth_db_query("SELECT * FROM role_access_rule WHERE roleName = '%s' AND access_rule = '%s'", $this->name, $access_rule);
if (xanth_db_fetch_object($result)) {
return TRUE;
}
return FALSE;
}
/**
*
*/
function find_all()
{
xanth_db_start_transaction();
$entries = array();
$result = xanth_db_query("SELECT * FROM entry");
for ($i = 0; $row = xanth_db_fetch_object($result); $i++) {
$entries[$i] = new xEntry($row->id, $row->title, $row->type, $row->author, $row->content, $row->content_format, $row->published, $row->description, $row->keywords, array(), xanth_db_decode_timestamp($row->creation_time));
$result2 = xanth_db_query("SELECT * FROM categorytoentry,category WHERE entryId = %d AND category.id = catId", $row->id);
$categories = array();
while ($row = xanth_db_fetch_object($result2)) {
$categories[] = new xCategory($row->id, $row->title, $row->parent_id);
}
$entry[$i]->categories = $categories;
}
xanth_db_commit();
return $entries;
}
/**
*
*/
function find_by_entry_type($entry_type)
{
$categories = array();
$result = xanth_db_query("SELECT * FROM category_to_entry_type WHERE entry_type = '%s'", $entry_type);
while ($row = xanth_db_fetch_object($result)) {
$categories[] = get($row->cat_id);
}
return $categories;
}
/**
*
*/
function check_persistent_login()
{
if (isset($_COOKIE['xanth_login'])) {
list($username, $cookie_token) = @unserialize($_COOKIE['xanth_login']);
if (!empty($username) && !empty($cookie_token)) {
$result = xanth_db_query("SELECT cookie_token,id FROM user WHERE username = '******'", $username);
if ($row = xanth_db_fetch_object($result)) {
if ($row->cookie_token === $cookie_token) {
//ok regenerate token for additional security
xUser::_update_persistent_login($username);
//set new session
xUser::_set_session($username, $row->id);
return TRUE;
}
}
}
}
return FALSE;
}
