diff options
author | Dries Buytaert <dries@buytaert.net> | 2003-06-10 17:33:43 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2003-06-10 17:33:43 +0000 |
commit | 222e1e55832831cfee9ef2f6abcfef1514afc6e0 (patch) | |
tree | 27bc4c4247993455a11aeb537a33168b8966b6b6 /modules/user.module | |
parent | b0081e5ac9275ffdf9b7042f305e17315fa77682 (diff) | |
download | brdo-222e1e55832831cfee9ef2f6abcfef1514afc6e0.tar.gz brdo-222e1e55832831cfee9ef2f6abcfef1514afc6e0.tar.bz2 |
- Documentation improvements: improved and updated the block module documentation. Patch #44 by Al. We should add some real-life path examples!
- Fixed the "blog it" image size. Patch #49 by Al.
- Some SQL performance improvements to the forum module. This should also be more PostgreSQL safe. Patch by me.
mysql> SELECT n.nid, n.created AS timestamp, u.name AS name, u.uid AS uid FROM forum f, node n LEFT JOIN users u ON n.uid = u.uid WHERE f.tid = 2 AND n.nid = f.nid AND n.type = 'forum' AND n.status = 1 ORDER BY timestamp DESC LIMIT 1, 0;
==> 0.63 sec
changed to:
mysql> SELECT n.nid, n.created AS timestamp, u.name AS name, u.uid AS uid FROM forum f LEFT JOIN node n ON n.nid = f.nid LEFT JOIN users u ON n.uid = u.uid WHERE f.tid = 2 AND n.nid = f.nid AND n.type = 'forum' AND n.status = 1 ORDER BY timestamp DESC LIMIT 1, 0;
==> 0.00 sec
Diffstat (limited to 'modules/user.module')
0 files changed, 0 insertions, 0 deletions