//kell egy hook_block, amivel megasszongyuk drupalnak, hogy kell egy saját blokk
/**
 * Implementation of hook_block().
 *
 * @param $op What kind of information to retrieve about the block. Possible values: list, configure, save, view.
 * @param $delta Which block to return.
 * @param $edit Data from a configuration form, if submitted.
 */
function MODULKÁM_block($op = 'list', $delta = 0, $edit = array()) {
  switch($op) {
    case 'list':
      $blocks = array();
      $blocks['0'] = array(
        'info' => t('Egy english cím a blokk oldalra'),
      );
 
      return $blocks;
      break;
 
    case 'view':
      $blocks = array();
      switch($delta) {
        case '0':
          $block['subject'] = t('English cím, ami a blokk cím lesz');
          break;
      }
      $block['content'] = MODULKÁM_block_content($delta);
 
      return $block;
      break;
  }
}
 
/**
 * Generate block contents.
 *
 * @param $delta The block id.
 * @return The generated block content.
 */
function MODULKÁM_block_content($delta) {
  switch($delta) {
    case '0':  
      //Ezt a sminkfüggvényt lentebb fogjuk deklarálni
      return theme('MODULKÁM_db_counter_text');
      break;
  }
}
 
/**
 * Ez itt maga a számokat összegyűjtő, előállító függvény, mint látod, én is termekhez tartozó node-okat számolok vele össze, mégpedig egy adott node típust.
 *
 * @param $tid the term id to filter
 * @return the number of nodes
 */
function MODULKÁM_node_counter($tid = NULL) {
  if (!is_null($tid)) {
    $query = "SELECT COUNT(1) as count FROM {node} n INNER JOIN {term_node} t ON n.vid = t.vid WHERE ((t.tid = %d) & (n.type = '%s'))";
    $result = db_query($query, $tid, '[ez itt a nodetype]');
  }
  else {
    $query = "SELECT COUNT(1) as count FROM {node} WHERE type = '%s'";
    $result = db_query($query, '[ez itt a nodetype]');
  }
 
  $counter = db_fetch_array($result);
 
  return $counter['count'];
 
}
 
/**
 * Ez egy sminkfüggvény definíciója, hogy ne hányjuk tele a modul   működési logikáját divekkel + egyéb szemetekkel.
 * Implementation of hook_theme().
 */
function MODULKÁM_theme() {
  return array(
    'MODULKÁM_db_counter_text' => array(
      'arguments' => array(),
    ),
  );
}
 
/*
 * Ez meg itt maga a sminkfüggvény, ami tképpen nem is igazi sminkfüggvény, de ezt még nem lehet tudni, hogy később milyen html köret kell esetleg a cucchoz.
 * Simple theme function for database counter block.
 */
function theme_MODULKÁM_db_counter_text() {
  $output = t('We currently feature !count-all suppliers from Central Europe, including !count_russia suppliers from Russia, !count_czech suppliers from the Czech Republic, !count_hun suppliers from Hungary, !count_pol from Poland, !count_slovak from Slovakia, !count_sloven from Slovenia and more...'
    , array ('!count-all' => MODULKÁM_node_counter(), '!count_russia' => MODULKÁM_node_counter(2929), '!count_czech' => MODULKÁM_node_counter(2802), '!count_hun' => MODULKÁM_node_counter(2843), '!count_pol' => MODULKÁM_node_counter(2919), '!count_slovak' => MODULKÁM_node_counter(2940), '!count_sloven' => MODULKÁM_node_counter(2938)));
  return $output;
}

$view = new view;
$view->name = 'newcontent';
$view->description = 'Shows all new activity on system.';
$view->tag = 'default';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'type' => array(
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'label' => 'Type',
  ),
  'title' => array(
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'label' => 'Title',
    'link_to_node' => TRUE,
  ),
  'name' => array(
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'label' => 'Author',
    'link_to_user' => TRUE,
  ),
  'comment_count' => array(
    'id' => 'comment_count',
    'table' => 'node_comment_statistics',
    'field' => 'comment_count',
    'label' => 'Replies',
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => ',',
    'prefix' => '',
    'suffix' => '',
  ),
  'last_comment_timestamp' => array(
    'id' => 'last_comment_timestamp',
    'table' => 'node_comment_statistics',
    'field' => 'last_comment_timestamp',
    'label' => 'Last Post',
    'date_format' => 'small',
    'custom_date_format' => '',
  ),
  'timestamp' => array(
    'id' => 'timestamp',
    'table' => 'history_user',
    'field' => 'timestamp',
    'label' => '',
    'comments' => 1,
    'relationship' => 'none',
    'link_to_node' => 0,
    'comment' => 1,
  ),
  'new_comments' => array(
    'id' => 'new_comments',
    'table' => 'node',
    'field' => 'new_comments',
    'label' => '',
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => ',',
    'prefix' => '',
    'suffix' => ' new',
    'link_to_comment' => 1,
    'no_empty' => 1,
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'last_comment_timestamp' => array(
    'id' => 'last_comment_timestamp',
    'table' => 'node_comment_statistics',
    'field' => 'last_comment_timestamp',
    'order' => 'ASC',
    'granularity' => 'second',
  ),
));
$handler->override_option('arguments', array(
  'uid_touch' => array(
    'default_action' => 'default',
    'style_plugin' => 'default_summary',
    'style_options' => array(
      'count' => TRUE,
      'override' => FALSE,
      'items_per_page' => 25,
    ),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'breadcrumb' => '',
    'default_argument_type' => 'current_user',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'id' => 'uid_touch',
    'table' => 'node',
    'field' => 'uid_touch',
    'relationship' => 'none',
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'page' => 0,
      'story' => 0,
    ),
    'validate_argument_php' => '',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
    ),
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
  ),
));
$handler->override_option('filters', array(
  'status' => array(
    'id' => 'status',
    'table' => 'node',
    'field' => 'status',
    'operator' => '=',
    'value' => '1',
    'group' => 0,
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'status' => array(
      'id' => 'status',
      'table' => 'comments',
      'field' => 'status',
      'operator' => '=',
      'value' => 0,
      'group' => 0,
      'exposed' => FALSE,
      'expose' => array(
        'operator' => FALSE,
        'label' => '',
      ),
      'relationship' => 'none',
    ),
  ),
  'timestamp' => array(
    'operator' => '=',
    'value' => '',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'timestamp',
    'table' => 'history_user',
    'field' => 'timestamp',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'role',
  'role' => array(
    '2' => 2,
  ),
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('title', 'New content since your last login');
$handler->override_option('items_per_page', '25');
$handler->override_option('use_pager', TRUE);
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
  'override' => 1,
  'order' => 'desc',
  'columns' => array(
    'type' => 'type',
    'title' => 'title',
    'name' => 'name',
    'comment_count' => 'comment_count',
    'last_comment_timestamp' => 'last_comment_timestamp',
    'timestamp' => 'title',
    'new_comments' => 'comment_count',
  ),
  'info' => array(
    'type' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'title' => array(
      'sortable' => 1,
      'separator' => ' ',
    ),
    'name' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'comment_count' => array(
      'sortable' => 1,
      'separator' => '<br />',
    ),
    'last_comment_timestamp' => array(
      'sortable' => 1,
      'separator' => '&nbsp;',
    ),
    'timestamp' => array(
      'separator' => '',
    ),
    'new_comments' => array(
      'separator' => '',
    ),
  ),
  'default' => 'last_comment_timestamp',
));
$handler = $view->new_display('page', 'Page', 'page');
$handler->override_option('path', 'new-content');
$handler->override_option('menu', array(
  'type' => 'normal',
  'title' => 'New Content',
  'description' => '',
  'weight' => '0',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => NULL,
  'description' => '',
  'weight' => NULL,
  'name' => 'navigation',
));