views 2

is_online handler for Views 2 - generated SQL MySQL

  1. SELECT DISTINCT(users.uid) AS uid,
  2. IF((1246401677 - MAX(sessions.timestamp)) < 900, 1, 0) AS users_is_online,
  3. users.name AS users_name
  4. FROM users users
  5. INNER JOIN sessions sessions ON users.ui

Fix for is_online handler for Views 2

  1. <?php
  2. /**
  3.  * Is user online handler.
  4.  */
  5. class views_handler_field_is_online extends views_handler_field_boolean {
  6.   function construct() {
  7.     parent::construct();
  8.     $this->additional_fields

is_online handler for Views 2 - is online part of hook_views_data()

  1.   // Is user online boolean (virtual field).
  2.   $data['users']['is_online'] = array(
  3.     'title' => t('Is online'),
  4.     'help' => t('Shows whether the user is online'),
  5.     'field' => array(
  6.      

is_online handler for Views 2 - generated SQL

  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 us

is_online handler for Views 2

  1. /**
  2.  * Is user online handler.
  3.  */
  4. class views_handler_field_is_online extends views_handler_field_boolean {
  5.   function construct() {
  6.     parent::construct();
  7.     $this->additional_fields['uid']

facebook_status.views.inc

  1. <?php
  2. //$Id$
  3.  
  4. /**
  5.  * @file
  6.  *   Views integration.
  7.  */
  8.  
  9. /**
  10.  * Implementation of hook_views_data().
  11.  */
  12. function facebook_status_hook_views_data() {
  13.   $data = array(

Loading views in hook_menu()

  1. /**
  2.  * Implementation of hook_menu().
  3.  */
  4. function cck_gallery_menu() {
  5.   $items['cck-gallery'] = array(
  6.     'title' => 'My galleries',

Problem with views, block and nodequeue

  1. SELECT COUNT(*) FROM (
  2.         SELECT node.nid AS nid
  3.         FROM node node
  4.         INNER JOIN nodequeue_nodes nodequeue_nodes_node
  5.                 ON node.nid = nodequeue_nodes_node.nid
  6.                 AND nodequeue_nodes_node.qid = 1

Views 2 get all field names

  1. // Put this inside a views-view-fields--VIEWNAME.tpl.php file to show the names of all the fields. Remember to set your view's row style to fields.
  2. $field_keys = array();
Syndicate content