/** * Returns the node based on an alias and a table * * @param string $alias Nodes alias to search for * @param string $table Nodes table_name to search for * @param string $section If table is categories, the section to search in * @return object The row object */ public function findById($id, $table, $section = '') { //We need to add #__ as the prefix to allow translating of the query $query = $this->getDBO()->getQuery()->where('id', '=', $id); //Exception for categories if ($table == 'categories') { if (!empty($section)) { $query->where('section', '=', $section); } else { $query->where('section', '>', 0); } } $table = new KDatabaseTableDefault(array('table_name' => $table)); $result = $table->fetchRow($query); return $result; }