Welcome Guest, Not a member yet? Register   Sign In
PyroCMS v0.9.7.4 - an open-source modular general purpose CMS
#34

[eluser]ElToro[/eluser]
This looks interesting and I wanted to try... but as almost always I found out that this is not for postgres.

Anyway I started to hack and changed tables and datas to go with PG, but there were few places which could be more closer to standard SQL, if they were done a bit differently.

In setting table you have "type" row:
Code:
`type` set('text','textarea','select','select-multiple','radio','checkbox') NOT NULL,

Which is queried in function get and getSettings
Code:
$this->db->select('slug, type, IF(`value` = "", `default`, `value`) as `value`', FALSE);

This IF in Query is not standard SQL and it is needing porting... could that 'default' value be used in that "type" field so that those IFs would not be even needed?

Other than that code is looking good, even tought I didn't manage to get it running yet... not running in web root, so there is something in my setup still.
--


Messages In This Thread
PyroCMS v0.9.7.4 - an open-source modular general purpose CMS - by El Forum - 04-10-2009, 04:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB