Would be nice if users clicked the PunBB in the footer if the link was opened in a new window so they are not forced to leave the current board.
27 2005-04-05 13:08
Topic: Disable logout for admin when in maintenance mode (9 replies, posted in Feature requests)
Stupidly, I wondered what the message would look like when board was in maintenance mode. So i logged out which was a big mistake, to re-enable the board again I had to manually change the o_maintenance flag to 0 both in the database and /cache. 
28 2005-04-04 19:39
Re: Support for Firebird SQL (24 replies, posted in Feature requests)
I posted a duff script last time (sorry) the real one can be obtained from http://www.tectsoft.net/download/punbb.firebird.zip
rgds
29 2005-04-04 15:28
Re: Support for Firebird SQL (24 replies, posted in Feature requests)
Rickard wrote:
keldar wrote:~ message is a reserved word so have changed all column names from message to msg
Hmm, that I don't like. I was hoping it would be possible to do this without affecting the already existing database support. Bummer.
You can get around this by adding dbl quotes to the column when defining, however it is then case sensitive and the case must be preserved in all selects, updates etc.
Rickard wrote:
keldar wrote:~ Where date has been added I have changed data type to TIMESTAMP and default (where applicable) to 'NOW'
But isn't a timestamp updated whenever you update the row?
No, its just a datatype, it *could* be updated easily via the triggers if needed.
Rickard wrote:
keldar wrote:~ Have added Foreign keys
Not really needed, but still cool.
This is done at the very end of the script, if its not necessary it can be easily omitted
Rickard wrote:
keldar wrote:~ Prefix for all objects (Tables, Generators, Index's, Triggers etc) have been set to PUNBB_
Why not use the prefix that is used for tables?
I used that prefix when I created a db, you should be able to do a search/replace on PUNBB_ and all will be ok
30 2005-04-04 14:56
Re: Support for Firebird SQL (24 replies, posted in Feature requests)
If your interested I have converted the database to Firebird (1.5 Dialect 3), there are a couple of changes you need to know about:
~ message is a reserved word so have changed all column names from message to msg
~ TEXT is not a valid FB datatype, have changed to VARCHAR (nnn) took best guess at size. This could have been a BLOB (sub_type TEXT).
~ Where date has been added I have changed data type to TIMESTAMP and default (where applicable) to 'NOW'
~ have re-added all index's and added triggers for Generators (AUTOINCREMENT)
~ Have added Foreign keys
~ Prefix for all objects (Tables, Generators, Index's, Triggers etc) have been set to PUNBB_
The script can be downloaded from http://www.tectsoft.net/download/punbb_fb.zip
rgds
31 2005-03-31 19:20
Re: Support for Firebird SQL (24 replies, posted in Feature requests)
Not sure what LIMIT/OFFSET is, if its to return a subset of records then you can use
SELECT FIRST n SKIP n blah blah
Otherwise let me know and I will find an equivalent. I would be more than happy to convert the database for you as well
rgds
Si
32 2005-03-31 18:51
Re: Support for Firebird SQL (24 replies, posted in Feature requests)
Thanks for the quick response, I would love to add support but my PHP knowledge is very flaky
rgds
Si
33 2005-03-31 18:42
Topic: Support for Firebird SQL (24 replies, posted in Feature requests)
Hi,
I was after a forum that supports Firebird SQL so as I can integrate with my website. I was told that PunBB had support for this, however, I have not been able to find it. Is this a planned feature for future versions or is there a mod by a 3rd party that supports Firebird.
rgds
Si