Link osszekapcsolas

name = PT bannerkezelés
description = PT bannerek megjelenítése
package = PT
version = 6.x-1.0
core = 6.x

<?php
 
/* hook_block() implementáció */
function ptbanner_block($op = 'list', $delta = 0, $edit = array())  {
  $cucc = theme('ptbanner_block_output');
  switch ($op) {
    case 'list':
      for ($i=0; $i<7; $i++)  {
        $block[$i]['info'] = 'PT banner '.$i;
        $block[$i]['cache'] = BLOCK_NO_CACHE;
      }
      return $block;
    case 'view':
      $banner_elem = theme('ptbanner_block_output');
      $block['content'] = '<a href="'.$banner_elem['banner_link_url'][$delta].'"><img src="/'.$banner_elem['banner_kep_url'][$delta].'"></a>';
      return $block;
  }
}
 
 
/* hook_theme() implementáció */
function ptbanner_theme($existing, $type, $theme, $path)  {
  return array(
    'ptbanner_block_output' => array(
      'arguments' => array()
    ),
  );
}
 
 
// TODO: elég csúnya megoldás, javítani kell!!!
function ptbanner_sql() {
  $result = db_query (db_rewrite_sql ("SELECT DISTINCT ctb.field_banner_kep_fid, ctb.field_banner_link_url FROM {node} n
              INNER JOIN {content_type_banner} ctb ON n.nid = ctb.nid WHERE n.type = '%s' AND n.status = 1 ORDER BY RAND() LIMIT 7"), 'banner');
  while ($banner = db_fetch_array($result)) {
    $output['banner_link_url'][] = $banner['field_banner_link_url'];
    $result2 = db_query (db_rewrite_sql ("SELECT filepath FROM {files} f WHERE f.fid = '%d'"), $banner['field_banner_kep_fid']);
    while ($banner_img = db_fetch_array($result2))
      $output['banner_kep_url'][] = $banner_img['filepath'];
  }
  return $output;
}
 
 
/* sminkfüggvény a megjelenítéshez */
function theme_ptbanner_block_output() {
  static $result;
  if (!$result)
    $result = ptbanner_sql();
  $output = $result;
  return $output;
}
?>