/** * return the id number of the current gallery * * @param string $gallery_name (optional) - the name of the gallery, use URI segment 1, if not set * @return integer - the id number of the gallery * @author Andy Bennett */ public static function get_gallery_id($gallery_name = 'media') { $db = new SteamDatabase(); $sql = 'SELECT id FROM galleries WHERE LOWER(title)="' . strtolower($gallery_name) . '"'; $r = $db->get_row_query($sql); return $r == false ? false : $r->id; }
/** * get page plugins * * @param string $pid * @return array * @author Andy Bennett */ public static function get_page_plugins($pid, $plugin_name = NULL) { $plug_table = Kohana::config('appconf.page_plugins_table'); if (is_null($plug_table)) { $plug_table = 'page_plugins'; } $db = new SteamDatabase(); $db->select('*')->from($plug_table)->where(array('pid' => $pid)); if (isset($plugin_name)) { $db->orwhere(array('plugin_name' => $plugin_name)); } $db->orderby('order'); $c = $db->get_result(); $col = array(); foreach ($c as $p) { $name = $p->plugin_name; $settings = array(); // $settings['column'] = $p->column; $settings['order'] = $p->order; $settings['template'] = $p->template; try { $col[] = PluginManager::getPlugin($name)->setSettings($settings); } catch (Exception $e) { Kohana::log('debug', $e->getMessage()); } } return $col; }
public static function get_containers() { $db = new SteamDatabase(); return $db->select_list('container', array('cms' => 1)); }