FuelPHP Forums

peter vercauteren wrote on 02/09/11 3:21 pm:

I dont get why you have the same views for user in the modules and the main view folder.

Jelmer Schreuder wrote on Tuesday 5th of April 2011:

In Fuel we have "Output filtering" instead of input filtering by default (you can switch this if you want in app/config/config.php), this means that anything passed to the view gets pushed through htmlentities to prevent XSS. Dan explained both on his blog. Objects will either have all their properties filtered or are converted to strings to be filtered when they have a __toString method. (the exception to this are objects of class View, ViewModel or Closures - and any you might whitelist yourself) Because they want to have the validation object in their view, but not filtered or cast to a string they pass it using the View::set() method with false as its last param. That switches off the filtering for the variable they're setting, thus allowing them to pass the Validation object.

DROP TABLE IF EXISTS `sw_simpleusers`;

CREATE TABLE `sw_simpleusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(70) DEFAULT NULL,
  `profile_fields` text,
  `group` int(11) DEFAULT NULL,
  `last_login` bigint(20) DEFAULT NULL,
  `login_hash` tinytext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `sw_articles`;

CREATE TABLE `sw_articles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(140) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `published` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_time` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `sw_categories`;

CREATE TABLE `sw_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `name` varchar(140) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` tinytext COLLATE utf8_unicode_ci,
  `created_time` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Chris Arnold wrote on Tuesday 26th of July 2011:

I've downloaded and installed Stationwagon, however I couldn't find the database.sql file? I've used the SQL posted by PaulboCo but had to change the table names, now it's not recognising some of the fields... can anyone point me in the right direction of the database.sql file please? Thanks