Discussion Expiration (Testing only)

jeffk

This seems to be working perfectly for me and I am thinking of putting it on a "live" install. Has anyone one else had an issue/conflict with the current version?

jeffk

Hey Schizo, Are you going to release this as an official extension?

MySchizoBuddy

yeah once i make all mysql query to sqlbuilder query.
Dunno why i need to use sqlbuilder, other than that its provided and is supposed to be used ?

next version won't have category filtering for admins. So admins can expire any discussion in any category

jeffk

I dont exactly know what sqlbuilder is ;) but in its current form it does work! I like that next version option. That could totally come in handy.

Minisweeper

The idea behind the SQLbuilder is that if someone wanted to port vanilla do a different DB system then technically all they need to do is convert the database classes to use the correct syntax and everything which uses the sqlbuilder will automatically still work...

MySchizoBuddy

is that it
thats the only reason to use SqlBuilder.
Doesn't it do memory management or query optimizations for me.

Minisweeper

That I'm not sure about..

bjrn

As far as I know the SQL builder does just what it says on the tin, it builds SQL statements for you. You throw at it what you want, and at the end it spits out an SQL statement.

MySchizoBuddy

so how do i handle query optimizations. If a query has already been run it shouldn't run it again. How do I do that