Home

Fix for is_online handler for Views 2 - generated SQL

June 30, 2009 - 4:20pm — Anonymous
  1. SELECT DISTINCT(uid), users.name AS users_name, users.uid AS users_uid, IF((1246392120 - MAX(sessions.timestamp)) < 900, 1, 0) AS sessions_is_online FROM users users INNER JOIN sessions sessions ON users.uid = sessions.uid GROUP BY uid, users_name, users_uid LIMIT 10 OFFSET 0
See Also: 
Fix for is_online handler for Views 2

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.