DrupalBin
Submit Code
About
Recent Posts
Code
Fix for Fix for Code
Fix for Code
Code
Node type whitelist
an axe coach accessories
coach purses married
Fix for de las ghd alturas
de las ghd alturas
Code
more
User login
Log in using OpenID:
What is OpenID?
Username:
*
Password:
*
Log in using OpenID
Cancel OpenID login
Create new account
Request new password
Tags
CCK
drupal
fapi
jquery
menu
module
php
simpletest
taxonomy
test
theme
views
more tags
Home
Fix for is_online handler for Views 2 - generated SQL MySQL
View
Fix
June 30, 2009 - 6:51pm — Anonymous
SELECT DISTINCT
(
users.uid
)
AS
uid,
IF
(
(
1246401677 -
MAX
(
sessions.timestamp
)
)
<
900, 1, 0
)
AS
users_is_online,
users.name
AS
users_name
FROM users users
INNER
JOIN
sessions sessions ON users.uid = sessions.uid
GROUP BY uid, users_name
See Also:
is_online handler for Views 2 - generated SQL
views 2
Submit Fix
Summary:
Tags:
Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Show summary in full view
SELECT DISTINCT(users.uid) AS uid, IF((1246401677 - MAX(sessions.timestamp)) < 900, 1, 0) AS users_is_online, users.name AS users_name FROM users users INNER JOIN sessions sessions ON users.uid = sessions.uid GROUP BY uid, users_name
Syntax highlighting mode:
ActionScript
ColdFusion
Diff
Drupal 5
Drupal 6
HTML
INI
Javascript
MySQL
PHP
Python
robots.txt
SQL
Text
Select the syntax highlighting mode to use.
See Also:
Order
Title:
URL:
-1
0
1
Title:
URL:
-1
0
1
Any links you'd like to have associated with the post (Drupal.org issue, Wikipedia article, etc).
File attachments
Changes made to the attachments are not permanent until you save this post. The first "listed" file will be included in RSS feeds.
Attach new file:
The maximum upload size is
1 MB
. Only files with the following extensions may be uploaded:
jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp phps
.
