aboutsummaryrefslogtreecommitdiffstats
path: root/doc/sql_conventions.bb
diff options
context:
space:
mode:
authorKlaus Weidenbach <Klaus.Weidenbach@gmx.net>2015-03-07 18:19:52 +0100
committerKlaus Weidenbach <Klaus.Weidenbach@gmx.net>2015-03-08 17:51:58 +0100
commit23ea974615cc8ffb3756769fe872affcee3d5c3a (patch)
treeee96cee0d1dd2181d2e049b34052c60b7d9757b9 /doc/sql_conventions.bb
parent9cd7546be5ad7f24534653f310c15362c3f2baa6 (diff)
downloadvolse-hubzilla-23ea974615cc8ffb3756769fe872affcee3d5c3a.tar.gz
volse-hubzilla-23ea974615cc8ffb3756769fe872affcee3d5c3a.tar.bz2
volse-hubzilla-23ea974615cc8ffb3756769fe872affcee3d5c3a.zip
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.
Diffstat (limited to 'doc/sql_conventions.bb')
-rw-r--r--doc/sql_conventions.bb6
1 files changed, 5 insertions, 1 deletions
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