source: trunk/event/eventy.php@ 563

<?php
$EventsLinks = array(
  1 => array('event/1.jpg'),
  2 => array('event/2.jpg'),
  3 => array('event/3.jpg'),
  4 => array('event/3.jpg'),
  5 => array('event/3.jpg'),
  6 => array('event/4.jpg'),
  7 => array('event/5.jpg'),
  8 => array('event/6.jpg'),
  9 => array('event/7.jpg'),
  10 => array('event/8.jpg'),
  11 => array('event/9.jpg'),
  12 => array('event/10.jpg'),
  13 => array('event/11.jpg'),
  14 => array('event/12.jpg'),
  15 => array('event/12.jpg'),
  16 => array('event/13.jpg'),
  17 => array('event/18.jpg'),
  18 => array('event/16.jpg'),
  19 => array('event/16.jpg'),
  20 => array('event/16.jpg'),
  21 => array('event/16.jpg'),
  22 => array('event/16.jpg'),
  23 => array('event/15.jpg'),
  24 => array('event/15.jpg'),
  25 => array('event/16.jpg'),
  26 => array('event/14.jpg'),
  27 => array('event/15.jpg'),
  28 => array('event/7.jpg'),
  29 => array('event/17.jpg'),
  30 => array('event/17.jpg'),
  31 => array('event/17.jpg'),
  32 => array('event/17.jpg'),
  34 => array('event/18.jpg'),
);

function Events()
{
  global $Database, $EventsLinks;
  $Events = array('Running' => array(), 'Planned' => array());
  mysql_select_db("world");
  
  // Add already started events
  $DbResult =mysql_query('SELECT *, UNIX_TIMESTAMP(start_time) as start FROM game_event WHERE end_time > NOW() AND start_time < NOW()');
   while($Row = mysql_fetch_array($DbResult))
  { 
    if(!array_key_exists($Row['entry'], $EventsLinks)) $EventsLinks[$Row['entry']] = array('', '');
    $Start = (floor((time() - $Row['start']) / ($Row['occurence'] * 60))) * $Row['occurence'] * 60 + $Row['start'];
    $End = $Start + $Row['length'] * 60;
    if((time() > $Start) and (time() < $End)) $EventState = 'Running';
    else 
    {
      $EventState = 'Planned'; 
      $Start += $Row['occurence'] * 60;
      $End += $Row['occurence'] * 60;
    }
    $Events[$EventState][$Row['start']] = array('StartTime' => $Start, 'EndTime' => $End, 'Title' => $Row['description'], 'WoWWiki' => $EventsLinks[$Row['entry']][0], 'Official' => $EventsLinks[$Row['entry']][1]);
  }

  // Add events not started so far
  $DbResult = mysql_query('SELECT *, UNIX_TIMESTAMP(start_time) as start FROM game_event WHERE start_time > NOW()');
  while($Row = mysql_fetch_array($DbResult))
  { 
    if(!array_key_exists($Row['entry'], $EventsLinks)) $EventsLinks[$Row['entry']] = array('', '');
    $Events['Planned'][$Row['start']] = array('StartTime' => $Row['start'], 'EndTime' => ($Row['start'] + $Row['length'] * 60), 'Title' => $Row['description'], 'WoWWiki' => $EventsLinks[$Row['entry']][0], 'Official' => $EventsLinks[$Row['entry']][1]);
  }

  sort($Events['Running']);
  sort($Events['Planned']);

  return($Events);
}

function ShowEventList($Events)
{
  foreach($Events as $Event)
  {
    echo('<tr>');
    if($Event['WoWWiki'] != '') echo('<td><img src="'.$Event['WoWWiki'].'"></a></td>'); 
echo('</tr>');
  }
}

mysql_connect("$db_server", "$db_user", "$db_pass");
mysql_select_db("$db_mangos");

$Events = Events();
echo('<table class="TableGuilda" border="0" cellpadding="0" cellspacing="0">');
ShowEventList($Events['Running']);
echo('</table>');
?>