From 23ea974615cc8ffb3756769fe872affcee3d5c3a Mon Sep 17 00:00:00 2001 From: Klaus Weidenbach Date: Sat, 7 Mar 2015 18:19:52 +0100 Subject: Add alert to admin page about old PHP version. Add an alert message to admin summary page when a PHP version < 5.4 was detected as this has reached EOL and will not be supported with the new SabreDAV library. Some styleguide optimisation. Add NULL_DATE example to doc/sql_conventions.bb. Display a "0" when no plugins active in summary page. Added some more numbers to summary admin page, expired accounts, channels. Hope I interpreted them right. I have no idea how to get blocked accounts. --- doc/sql_conventions.bb | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'doc/sql_conventions.bb') diff --git a/doc/sql_conventions.bb b/doc/sql_conventions.bb index 2deb3cff6..f6a4e251f 100644 --- a/doc/sql_conventions.bb +++ b/doc/sql_conventions.bb @@ -56,7 +56,11 @@ $r = q("SELECT * FROM mail WHERE uid=%d AND $sql_extra ORDER BY created DESC LIM [b]NULL dates[/b] [li]To be written -[code]Example[/code][/li] +[code]// Example +$r = q("DELETE FROM mail WHERE expires != '%s' AND expires < %s ", + dbesc(NULL_DATE), + db_utcnow() +);[/code][/li] [b]Storing binary data[/b] [li]To be written -- cgit v1.2.3