/
index.php
154 lines (138 loc) · 4.74 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
<?php
// Event Guide Module for XOOPS
// $Id: index.php,v 1.23 2010/02/21 11:07:50 nobu Exp $
include 'header.php';
$prev = param( 'prev' );
$page = param( 'page' );
if ( $page < 0 ) {
$prev = - $page;
$page = 0;
} elseif ( $prev < 0 ) {
$page = - $prev;
$prev = 0;
}
set_next_event();
$now = time();
$max = $xoopsModuleConfig['max_event'];
$cond = 'status=' . STAT_NORMAL;
if ( empty( $prev ) ) {
// show upcomming event (constant is gurd value)
$cond .= " AND ((expire>=edate AND expire>$now) OR (expire<edate AND (IF(exdate,exdate,edate)+expire)>$now))";
//$cond .= " AND (exdate>$now OR exdate IS NULL)";
$start = ( empty( $page ) ? 0 : $page - 1 ) * $max;
$ord = 'ASC';
$ext = $xoopsModuleConfig['show_extents'] ? '' : 'AND ldate=exdate';
} else {
$cond .= " AND edate<$now"; // show passed event
$cond .= " AND (exdate<$now OR exdate IS NULL)";
$start = ( $prev - 1 ) * $max;
$ord = 'DESC';
$ext = $xoopsModuleConfig['show_extents'] ? '' : 'AND 0';
}
$catlist = get_eguide_category();
$catid = isset( $_GET['cat'] ) && preg_match( '/^(\d+,)*\d+$/', $_GET['cat'] ) ? $_GET['cat'] : 0;
if ( isset( $catlist[ $catid ] ) ) {
$vals = array( $catid );
if ( $catlist[ $catid ]['catpri'] == 0 ) { // also children categories
foreach ( $catlist as $data ) {
if ( $data['catpri'] == $catid ) {
$vals[] = $data['catid'];
}
}
}
$opt = ' AND topicid IN (' . join( ',', $vals ) . ')';
} else {
$opt = $catid ? ' AND topicid IN (' . $catid . ')' : '';
}
$fields = "e.eid, cdate, title, summary, closetime,
IF(expersons IS NULL,persons, expersons) persons,
IF(exdate,exdate,edate) edate,
IF(x.reserved,x.reserved,o.reserved) reserved,
reservation, uid, status, style, counter, topicid, exid, exdate";
$result = $xoopsDB->query( 'SELECT ' . $fields . ' FROM ' . EGTBL . ' e LEFT JOIN ' .
OPTBL . ' o ON e.eid=o.eid LEFT JOIN ' . EXTBL . " x ON e.eid=eidref $ext
WHERE $cond$opt ORDER BY edate $ord", $max, $start );
$events = array();
$isadmin = false;
$uid = 0;
if ( is_object( $xoopsUser ) ) {
$isadmin = $xoopsUser->isAdmin( $xoopsModule->getVar( 'mid' ) );
$uid = $xoopsUser->getVar( 'uid' );
}
while ( $event = $xoopsDB->fetchArray( $result ) ) {
$event['isadmin'] = ( $isadmin || $event['uid'] == $uid );
$event['link'] = true;
$event['expire'] = ( $event['edate'] - $event['closetime'] ) > $now;
$more = 'event.php?eid=' . $event['eid'];
$cid = $event['topicid'];
if ( isset( $catlist[ $cid ] ) ) {
$event['catid'] = $cid;
$event['catname'] = $catlist[ $cid ]['name'];
$event['catimg'] = $catlist[ $cid ]['image'];
}
if ( ! empty( $event['exid'] ) ) {
$event['extent'] = true; // also show editdate link
$more .= '&sub=' . $event['exid'];
}
$event['detail'] = $more;
edit_eventdata( $event );
$events[] = $event;
}
include XOOPS_ROOT_PATH . '/header.php';
$xoopsOption['template_main'] = EGPREFIX . '_index.html';
$xoopsTpl->assign( 'events', $events );
assign_module_css();
if ( count( $catlist ) > 1 ) {
foreach ( $catlist as $id => $cat ) {
if ( $cat['catpri'] ) {
$catlist[ $id ]['name'] = '-- ' . $cat['name'];
}
}
$xoopsTpl->assign( 'categories',
array(
'options' => $catlist,
'action' => 'index.php',
'dirname' => basename( dirname( __FILE__ ) )
) );
}
if ( empty( $prev ) ) {
if ( $page < 2 ) {
$result = $xoopsDB->query( 'SELECT eid FROM ' . EGTBL . ' e LEFT JOIN ' . EXTBL . " ON e.eid=eidref $ext WHERE (edate<$now OR exdate<$now) AND status=" . STAT_NORMAL . $opt, 1 );
$p = $xoopsDB->getRowsNum( $result );
} else {
$p = true;
}
$result = $xoopsDB->query( 'SELECT eid FROM ' . EGTBL . ' e LEFT JOIN ' . EXTBL . " ON e.eid=eidref $ext WHERE " . $cond . $opt, 1, $start + $max );
$q = $xoopsDB->getRowsNum( $result ); // there is next page
if ( empty( $page ) || $page == 1 ) {
$prev = "?prev=1";
$page = "?page=2";
} else {
$prev = "?page=" . ( $page - 1 );
$page = "?page=" . ( $page + 1 );
}
} else {
$result = $xoopsDB->query( 'SELECT eid FROM ' . EGTBL . ' e LEFT JOIN ' . EXTBL . " ON e.eid=eidref $ext WHERE " . $cond . $opt, 1, $start + $max );
$p = $xoopsDB->getRowsNum( $result ); // there is more prev page?
$q = true; // always next page exists.
if ( $prev == 1 ) {
$prev = "?prev=" . ( $prev + 1 );
$page = "?page=1";
} else {
$page = "?prev=" . ( $prev - 1 );
$prev = "?prev=" . ( $prev + 1 );
}
}
set_eguide_breadcrumbs( is_numeric( $catid ) ? $catid : 0 );
$opt = $catid ? "&cat=" . $catid : '';
if ( $p ) {
$xoopsTpl->assign( 'page_prev', $prev . $opt );
}
if ( $q ) {
$xoopsTpl->assign( 'page_next', $page . $opt );
}
if ( count( $events ) == 0 && ! $p ) {
unset( $xoopsOption['template_main'] );
echo _MD_NODATA;
}
include XOOPS_ROOT_PATH . '/footer.php';