class frontendConfiguration extends sfApplicationConfiguration {
  public function configure()  {
  $this->dispatcher->connect('routing.load_configuration', array('registerRoutes', 'listenToRoutingLoadConfigurationEvent'));
  }
}
 
 
class registerRoutes {
  static public function listenToRoutingLoadConfigurationEvent(sfEvent $event) {
  $routing = $event->getSubject();
 
  $criteria = new Criteria();
  $criteria->clearSelectColumns();
  $criteria->addSelectColumn(StaticPagesPeer::LINK_NAME);
  $pages = StaticPagesPeer::doSelectStmt($criteria);
 
  foreach ($pages->fetch() as $link) {
    $routing->prependRoute(
      'static_'.$link,
      new sfRoute(
       '/'.$link,
      array(
          'module' => 'main', 
          'action' => 'static', 
          'page' => $link)
    ));
    //with slash
     $routing->prependRoute(
        'static_'.$link.'_with_slash',
        new sfRoute(
        '/'.$link.'/',
          array('module' => 'main', 
          'action' => 'static', 
          'page' => $link)
     ));
}
}
}