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 |
|
---|
38 | function 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 |
|
---|
75 | function ShowEventList($Events)
|
---|
76 | {
|
---|
77 | foreach($Events as $Event)
|
---|
78 | {
|
---|
79 | echo('<tr>');
|
---|
80 | if($Event['WoWWiki'] != '') echo('<td><img src="'.$Event['WoWWiki'].'"></a></td>');
|
---|
81 | echo('</tr>');
|
---|
82 | }
|
---|
83 | }
|
---|
84 |
|
---|
85 | mysql_connect("$db_server", "$db_user", "$db_pass");
|
---|
86 | mysql_select_db("$db_mangos");
|
---|
87 |
|
---|
88 | $Events = Events();
|
---|
89 | echo('<table class="TableGuilda" border="0" cellpadding="0" cellspacing="0">');
|
---|
90 | ShowEventList($Events['Running']);
|
---|
91 | echo('</table>');
|
---|
92 | ?>
|
---|
93 |
|
---|