source: trunk/event/eventy.php@ 563

Last change on this file since 563 was 563, checked in by barny, 16 years ago
  • na hlavní tránce se zobrazují probíhající eventy.
File size: 3.2 KB
Line 
1<?php
2$EventsLinks = array(
3 1 => array('event/1.jpg'),
4 2 => array('event/2.jpg'),
5 3 => array('event/3.jpg'),
6 4 => array('event/3.jpg'),
7 5 => array('event/3.jpg'),
8 6 => array('event/4.jpg'),
9 7 => array('event/5.jpg'),
10 8 => array('event/6.jpg'),
11 9 => array('event/7.jpg'),
12 10 => array('event/8.jpg'),
13 11 => array('event/9.jpg'),
14 12 => array('event/10.jpg'),
15 13 => array('event/11.jpg'),
16 14 => array('event/12.jpg'),
17 15 => array('event/12.jpg'),
18 16 => array('event/13.jpg'),
19 17 => array('event/18.jpg'),
20 18 => array('event/16.jpg'),
21 19 => array('event/16.jpg'),
22 20 => array('event/16.jpg'),
23 21 => array('event/16.jpg'),
24 22 => array('event/16.jpg'),
25 23 => array('event/15.jpg'),
26 24 => array('event/15.jpg'),
27 25 => array('event/16.jpg'),
28 26 => array('event/14.jpg'),
29 27 => array('event/15.jpg'),
30 28 => array('event/7.jpg'),
31 29 => array('event/17.jpg'),
32 30 => array('event/17.jpg'),
33 31 => array('event/17.jpg'),
34 32 => array('event/17.jpg'),
35 34 => array('event/18.jpg'),
36);
37
38function Events()
39{
40 global $Database, $EventsLinks;
41 $Events = array('Running' => array(), 'Planned' => array());
42 mysql_select_db("world");
43
44 // Add already started events
45 $DbResult =mysql_query('SELECT *, UNIX_TIMESTAMP(start_time) as start FROM game_event WHERE end_time > NOW() AND start_time < NOW()');
46 while($Row = mysql_fetch_array($DbResult))
47 {
48 if(!array_key_exists($Row['entry'], $EventsLinks)) $EventsLinks[$Row['entry']] = array('', '');
49 $Start = (floor((time() - $Row['start']) / ($Row['occurence'] * 60))) * $Row['occurence'] * 60 + $Row['start'];
50 $End = $Start + $Row['length'] * 60;
51 if((time() > $Start) and (time() < $End)) $EventState = 'Running';
52 else
53 {
54 $EventState = 'Planned';
55 $Start += $Row['occurence'] * 60;
56 $End += $Row['occurence'] * 60;
57 }
58 $Events[$EventState][$Row['start']] = array('StartTime' => $Start, 'EndTime' => $End, 'Title' => $Row['description'], 'WoWWiki' => $EventsLinks[$Row['entry']][0], 'Official' => $EventsLinks[$Row['entry']][1]);
59 }
60
61 // Add events not started so far
62 $DbResult = mysql_query('SELECT *, UNIX_TIMESTAMP(start_time) as start FROM game_event WHERE start_time > NOW()');
63 while($Row = mysql_fetch_array($DbResult))
64 {
65 if(!array_key_exists($Row['entry'], $EventsLinks)) $EventsLinks[$Row['entry']] = array('', '');
66 $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]);
67 }
68
69 sort($Events['Running']);
70 sort($Events['Planned']);
71
72 return($Events);
73}
74
75function ShowEventList($Events)
76{
77 foreach($Events as $Event)
78 {
79 echo('<tr>');
80 if($Event['WoWWiki'] != '') echo('<td><img src="'.$Event['WoWWiki'].'"></a></td>');
81echo('</tr>');
82 }
83}
84
85mysql_connect("$db_server", "$db_user", "$db_pass");
86mysql_select_db("$db_mangos");
87
88$Events = Events();
89echo('<table class="TableGuilda" border="0" cellpadding="0" cellspacing="0">');
90ShowEventList($Events['Running']);
91echo('</table>');
92?>
93
Note: See TracBrowser for help on using the repository browser.