$uid)); $telli = $puser->profile_tellisyndmused; } if($telli==1){ $address = $_SERVER['SERVER_NAME']; $block_content .= '
'; $block_content .= 'Viimased sündmused
'; $eventKuupaevParing = db_query("SELECT e.nid, event_start FROM {event} e ORDER BY event_start DESC LIMIT %d", 3); while ($eventId = db_fetch_object($eventKuupaevParing)){ $eventParing = db_query("SELECT n.title, n.nid FROM {node} n WHERE n.nid = ".$eventId->nid." AND status=1 LIMIT %d", 1); $event = db_fetch_object($eventParing); $nameAlone = $event->title; $nameLength = strlen($nameAlone); if($nameLength<=25){ $newName=$nameAlone; } else { $newName = substr($nameAlone, 0, 25); $newName .= '...'; } $block_content .= '
'.$newName.'
'; list($date, $time) = explode(' ', $eventId->event_start); list($year, $month, $day) = explode('-', $date); list($hour, $minute, $second) = explode(':', $time); $timestamp = mktime($hour, $minute, $second, $month, $day, $year); $block_content .= '
[ '.date('d.m.Y', $timestamp).' ]
'; } $block_content .= '
'; } if ($block_content == '') { $block['subject'] = ''; $block['content'] = ''; return $block; } $block['subject'] = ''; $block['content'] = $block_content; return $block; } }