Assembla home | Assembla project page
 

root/trunk/com_mls_events/mls_events.php

Revision 188, 19.6 kB (checked in by moensch, 2 years ago)

FMR 1019: Add ability to view past Events

Line 
1 <?php
2 defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
3
4 // load language files
5 require_once( $mainframe->getPath( 'class', 'com_mls_lang' ) );
6 $l = new MLS_lang();
7 if(!$l->loadData()) {
8     echo $l->_error;
9 }
10
11
12 require_once( $mainframe->getPath( 'front_html' ) );
13 require_once( $mainframe->getPath( 'class' ) );
14 if(file_exists($mainframe->getPath( 'class', 'com_mls_paypal' ))) {
15     require_once( $mosConfig_absolute_path."/components/com_mls_paypal/mls_paypal.config.php" );
16 }
17 require_once( $mosConfig_absolute_path."/components/com_mls_events/mls_events.config.php" );
18 $limit = mosGetParam($_REQUEST, 'limit', '');
19 $limitstart = mosGetParam($_REQUEST, 'limitstart', '');
20 $search = mosGetParam($_REQUEST, 'search', '');
21 $eventid = mosGetParam($_REQUEST,'eventid');
22 $id = mosGetParam($_REQUEST,'id');
23 $couponcode = mosGetParam($_REQUEST,'couponcode');
24
25 $database->setQuery( "SELECT `id` FROM `#__mls_events` WHERE `active`='1' LIMIT 1" );
26 $eventid = $eventid != 0 ? $eventid : $database->loadResult();
27 switch( $task ) {
28     case "details":
29         showDetails( $eventid, $option, $Itemid );
30         break;
31         
32     case "show_participants":
33         showParticipants( $eventid, $option, $Itemid,$limit,$limitstart,$search );
34         break;
35         
36     case "enrol":
37         enrolCouponForm( $eventid, $my->id, $option, $Itemid ) ;
38         break;
39     
40     case "enrol_coupon":
41         enrolCoupon( $eventid, $couponcode, $my->id, $option, $Itemid ) ;
42         break;
43     
44     case "deenrol":
45         deEnrol( $eventid, $my->id, $option, $Itemid ) ;
46         break;
47         
48     case "list_comments":
49         listComments( $eventid, $option, $Itemid );
50         break;
51     
52     case "read_review":
53         readReview( $id, $option, $Itemid );
54         break;
55         
56     case "list_reviews":
57         listReviews( $eventid, $option, $Itemid );
58         break;
59     
60     case "write_review":
61         editReview( '0', $eventid, $option, $Itemid );
62         break;
63     
64     case "edit_review":
65         editReview( $reviewid, $eventid, $option, $Itemid );
66         break;
67     
68     case "save_review":
69         saveReview( $option, $Itemid );
70         break;
71     
72     case "pay":
73         payEvent( $eventid, $option, $Itemid );
74         break;
75         
76     default:
77         listEvents( $option, $Itemid );
78         break;
79 }
80
81 function listEvents( $option, $Itemid) {
82     global $database,$my;
83     $row = new mosMLS_events($database);
84     if($_REQUEST["showpast"]) {
85         $cond = '';
86     } else {
87         $cond = ' AND e.end > NOW()';
88     }
89     $query = "SELECT e.*, COUNT(p.id) AS `usercount`, COUNT(IF(p.userid=".$my->id.",1,NULL)) AS `enrolled` FROM `#__mls_events` AS `e`"
90             ."\n LEFT JOIN `#__mls_events_participants` AS `p` ON e.id=p.eventid"
91             ."\n WHERE e.published='1'".$cond
92             ."\n GROUP BY e.id"
93             ."\n ORDER BY e.start ASC";
94     $database->setQuery($query);
95     $rows = $database->loadObjectList();
96     
97     $database->setQuery( "SELECT `eventid` FROM `#__mls_events_participants` WHERE `paid`='1' AND `userid`='".$my->id."'" );
98     $temp = $database->loadObjectList();
99     $paid = array();
100     foreach($temp as $tmp) {
101         $paid[$tmp->eventid] = $tmp->eventid;
102     }
103     
104     HTML_MLS_events::listEvents($rows, $paid, $option, $Itemid);
105 };
106
107 function showDetails($eventid, $option, $Itemid) {
108     global $database,$my,$l, $cnf_mls_pp;
109     $l->setBlock("general");
110     $query = "SELECT e.*, COUNT(p.id) AS `usercount`, COUNT(IF(p.userid=".$my->id.",1,NULL)) AS `enrolled` FROM `#__mls_events` AS `e`"
111             ."\n LEFT JOIN `#__mls_events_participants` AS `p` ON e.id=p.eventid"
112             ."\n WHERE e.id='".$eventid."'"
113             ."\n GROUP BY e.id"
114             ."\n ORDER BY e.start ASC";
115     $database->setQuery($query);
116     
117     $row = $database->loadObjectList();
118     $row = $row[0];
119     $row->usercount = $row->usercount ? $row->usercount : "0";
120     $database->setQuery("SELECT COUNT(*) FROM `#__mls_events_participants` WHERE `eventid`='".$eventid."' AND `paid`='1' GROUP BY `eventid`");
121     $row->usercount_paid = $database->loadResult() ? $database->loadResult() : "0";
122     $row->usercount_unpaid = $row->usercount - $row->usercount_paid;
123     $database->setQuery("SELECT COUNT(*) FROM `#__mls_events_comments` WHERE `eventid`='".$eventid."' AND `published`='1' GROUP BY `eventid`");
124     $row->commentcount = $database->loadResult() ? $database->loadResult() : "0";
125     $database->setQuery("SELECT COUNT(*) FROM `#__mls_events_reviews` WHERE `eventid`='".$eventid."' AND `published`='1' GROUP BY `eventid`");
126     $row->reviewcount = $database->loadResult() ? $database->loadResult() : "0";
127     $database->setQuery("SELECT `paid` FROM `#__mls_events_participants` WHERE `eventid`='".$eventid."' AND `userid`='".$my->id."'" );
128     $row->paid = $database->loadResult();
129     if(!$row->published) {
130         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_event_not_published")));
131     }
132     
133     $row->price_payment_instructions = nl2br($row->price_payment_instructions);
134     if($cnf_mls_pp["enabled"] && $cnf_mls_pp["enabled_events"] && $my->id) {
135         $tmp = "";
136         $tmp .= "<br />".
137         $tmp .= "<form action=\"https://".$cnf_mls_pp["validation_url"]."/cgi-bin/webscr\" method=\"POST\">\n";
138         $tmp .= "<input type=\"hidden\" name=\"cmd\" value=\"_xclick\">\n";
139         $tmp .= "<input type=\"hidden\" name=\"business\" value=\"".$cnf_mls_pp["recipient_email"]."\">\n";
140         $tmp .= "<input type=\"hidden\" name=\"item_name\" value=\"".$row->name."\">\n";
141         $tmp .= "<input type=\"hidden\" name=\"item_number\" value=\"event_".$row->id."_".$my->id."\">\n";
142         $tmp .= "<input type=\"hidden\" name=\"amount\" value=\"".$row->price_advance_sale."\">\n";
143         $tmp .= "<input type=\"hidden\" name=\"no_note\" value=\"1\">\n";
144         $tmp .= "<input type=\"hidden\" name=\"currency_code\" value=\"".$row->price_currency."\">\n";
145         $tmp .= "<input type=\"hidden\" name=\"lc\" value=\"".$row->loc_country."\">\n";
146         $tmp .= "<input type=\"image\" src=\"https://".$cnf_mls_pp["validation_url"]."/en_US/i/btn/x-click-but23.gif\" border=\"0\" name=\"submit\" alt=\"Make payments with PayPal - it's fast, free and secure!\">\n";
147         $tmp .= "</form>\n";
148         
149         $row->price_payment_instructions .= $tmp;
150     }
151     HTML_MLS_events::showEvent($row,$option, $Itemid);
152 };
153
154 function showParticipants($eventid, $option, $Itemid, $limit = "20", $limitstart = "0", $search = "") {
155     global $database,$my,$mainframe, $mosConfig_dbprefix, $cnf_mls_events;
156     if(!$limitstart) $limitstart = "0";
157     if(!$limit) $limit = "20";
158     $where = "";
159     $words = explode(" ",$search);
160     foreach($words as $word) {
161         if($word) {
162             $op = $where ? "AND" : "WHERE";
163             $where .= " $op (p.userid LIKE '%$word%' OR u.name LIKE '%$word%' OR u.username LIKE '%$word%')";
164         }
165     }
166     $op = $where ? "AND" : "WHERE";
167     $where .= $eventid ? " $op p.eventid = '$eventid'" : "";
168     
169     
170     // get the total number of records
171     $query = "SELECT COUNT(*) FROM `#__mls_events_participants` AS `p`"
172         ."\n INNER JOIN `#__mls_events` AS `e` ON e.id = p.eventid"
173         ."\n LEFT JOIN `#__users` AS u ON u.id = p.userid $where";
174     $database->setQuery( $query );
175     $total = $database->loadResult();
176     
177     //enable pagenav
178     require_once( "includes/pageNavigation.php" );
179     $link = "?option=".$option."&task=show_participants&eventid=".$eventid."&Itemid=".$Itemid;
180     $pageNav = new mosPageNav( $total, $limitstart, $limit  );
181     
182     //check if CommunityBuilder is installed
183     $database->setQuery( "SELECT COUNT(*) FROM `#__components` WHERE `option`='com_comprofiler'" );
184     $cbinstalled = $database->loadResult();
185     if($cbinstalled) {
186         $cbfields = array();
187         $cbsql1 = "";
188         $database->setQuery( "SELECT * FROM `#__comprofiler` LIMIT 1" );
189         $database->query();
190         $i = 0;
191         while ($i < mysql_num_fields($database->_cursor)) {
192             $field = mysql_fetch_field($database->_cursor,$i);
193             if(substr($field->name,0,3) == "cb_") {
194                 $cbfields[] = $field->name;
195                 $cbsql1 .= "cb.".$field->name." AS `communitybuilder_".$field->name."`,";
196             }
197             $i++;
198         }
199         if(count($cbfields)) {
200             $cbsql1 = "\n,".substr($cbsql1,0,strlen($cbsql1) - 1)."\n";
201             $cbsql2 = "\n INNER JOIN `#__comprofiler` AS `cb` ON cb.id=u.id";
202         } else {
203             $cbsql1 = "";
204             $cbsql2 = "";
205         }
206     } else {
207         $cbsql1 = "";
208         $cbsql2 = "";
209     }
210     
211     //** Get the MySQL Version as I am doing some nasty stuff now which is unsupported on MySQL < 4.1.12 */
212     $database->setQuery( "SELECT VERSION()" );
213     $mysqlVersion = $database->loadResult();
214     $mysqlVersion = ereg_replace("[[:alpha:]+]","", substr($mysqlVersion,0,strpos($mysqlVersion, '-')));
215     if(version_compare($mysqlVersion,"4.1.12", "<")) {
216         $seatSql = "\n'' AS `mylansite_seat`,";
217     } else {
218         $seatSql = "\n(SELECT CONCAT(room.name, ' &raquo; ', seat.name) FROM `#__mls_seatmap_room_elements` AS `seat` INNER JOIN `#__mls_seatmap_rooms` AS `room` ON room.id=seat.roomid WHERE seat.status='1' AND seat.userid=p.userid AND room.eventid=e.id LIMIT 1) AS `mylansite_seat`,";
219     }
220     
221     //Select records
222     $query = "SELECT p.*,"
223         .$seatSql
224         ."\n u.name AS `joomla_name`,u.username AS `joomla_username`,u.email AS `joomla_email`,u.id AS `joomla_userid`,"
225         ."\n p.subscribed_time AS `mylansite_subscribed`,p.checkin AS `mylansite_checked_in`,p.checkout AS `mylansite_checked_out`,p.paid AS `mylansite_paid`,"
226         ."\n e.name AS `eventname`"
227         .$cbsql1
228         ."\n FROM `#__mls_events_participants` AS `p`"
229         ."\n INNER JOIN `#__mls_events` AS `e` ON e.id = p.eventid"
230         ."\n INNER JOIN `#__users` AS u ON u.id = p.userid"
231         .$cbsql2
232         ."\n" . $where
233         ."\n ORDER BY p.subscribed_time"
234         ."\n LIMIT $pageNav->limitstart, $pageNav->limit";
235     $database->setQuery($query);
236     //echo "<pre>".$database->_sql."</pre>";
237     $rows = $database->loadObjectList();
238     /** Fields **/
239     $fields = array();
240     $fields["fields"] = array();
241     $fields["titles"] = array();
242     foreach($cnf_mls_events["frontend_fields"] AS $field) {
243         $value = str_replace(".","_",$field->value);
244         $text = $field->text;
245         $fields["fields"][] = $value;
246         $fields["titles"][$value] = $field->text;
247     }
248     $event = new mosMLS_events($database);
249     $event->load($eventid);
250     for($i = 0; $i < count($rows); $i++) {
251         $rows[$i]->mylansite_subscribed = date("D, d.m.Y H:i", strtotime($rows[$i]->mylansite_subscribed));
252         $rows[$i]->mylansite_seat = "<a href=\"index.php?option=com_mls_seatmap&eventid=".$rows[$i]->eventid."&search=".$rows[$i]->joomla_username."\">".$rows[$i]->mylansite_seat."</a>";
253     }
254     
255     HTML_MLS_events::showParticipants($rows,$fields, $event,$link,$pageNav,$search,$option,$Itemid);
256 };
257
258 function enrolCouponForm($eventid, $userid, $option, $Itemid) {
259     global $database, $my, $l, $mosConfig_offset;
260     $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
261     $nullDate = $database->getNullDate();
262     $database->setQuery( "SELECT COUNT(*) FROM `#__mls_events_coupons` WHERE"
263                                             ."\n`eventid` = '".$eventid."' AND `published`='1' AND `used`='0'"
264                                             ."\n AND ((`valid_from` = '".$nullDate."' AND `valid_until` = '".$nullDate."')"
265                                             ."\n   OR"
266                                             ."\n   ('".$now."' >= `valid_from` AND (`valid_until` = '".$nullDate."' OR `valid_until` >= '".$now."'))"
267                                             ."\n )" );
268     
269     
270     $count = $database->loadResult();
271     
272     if($count == 0) {
273         //No valid coupons
274         enrol($eventid, 0, $userid, $option, $Itemid);
275     } else {
276         //show the coupon form
277         $event = new mosMLS_events($database);
278         $event->load($eventid);
279         HTML_MLS_events::showCouponForm( $event, $option, $Itemid );
280     }
281 }
282
283 function enrolCoupon( $eventid, $couponcode, $userid, $option, $Itemid ) {
284     global $database, $l;
285     $coupon = new mosMLS_events_coupon( $database );
286     if($couponcode != '') {
287         $verify = $coupon->verify($couponcode, $userid);
288     } else {
289         $verify = 'valid';
290     }
291     switch($verify) {
292     case 'expired':
293         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".$l->m("err_coupon_expired","general"));
294         break;
295     case 'pending':
296         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".$l->m("err_coupon_pending","general"));
297         break;
298     case 'valid':
299         enrol($eventid, $coupon->id, $userid, $option, $Itemid);
300         break;
301     case 'invalid':
302         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".$l->m("err_coupon_invalid","general"));
303         break;
304     }
305 }
306
307 function enrol($eventid, $couponid = 0, $userid, $option, $Itemid) {
308     global $database,$my,$l, $mosConfig_offset;
309     if(!$my->id) {
310         mosNotAuth();
311         return;
312     }
313     $l->setBlock("general");
314     $query = "SELECT e.*, COUNT(p.id) AS `usercount`, COUNT(IF(p.userid=".$userid.",1,NULL)) AS `enrolled`,COUNT(IF(p.paid=1,1,NULL)) AS `paid` FROM `#__mls_events` AS `e`"
315             ."\n LEFT JOIN `#__mls_events_participants` AS `p` ON e.id=p.eventid"
316             ."\n WHERE e.id='".$eventid."'"
317             ."\n GROUP BY e.id"
318             ."\n ORDER BY e.start ASC";
319     $database->setQuery($query);
320     $row = $database->loadObjectList();
321     $row = $row[0];
322     $free = $row->participants_number - $row->paid;
323     if($free <= 0) {
324         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_event_booked_up")));
325     }
326     if($row->enrolled) {
327         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_already_enrolled")));
328     }
329     if(!$row->published) {
330         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_event_not_published")));
331     }
332     if(!$row->enrol) {
333         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_not_open")));
334     }
335     $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
336     $database->setQuery("INSERT INTO `#__mls_events_participants` (`eventid`,`userid`,`subscribed`,`subscribed_time`) VALUES ('".$eventid."','".$userid."','1','".$now."')");
337     if($database->query()) {
338         //enrolled, set coupon to used if any
339         if($couponid) {
340             $coupon = new mosMLS_events_coupon( $database );
341             $coupon->load( $couponid );
342             $coupon->useIt( $userid );
343             $database->setQuery( "UPDATE `#__mls_events_participants` SET `paid`='1' WHERE `eventid`='".$eventid."' AND `userid`='".$userid."'" );
344             $database->query();
345         }
346         //enrolled, now check if we have a membership package
347         $database->setQuery( "SELECT u.*,p.type,p.eventamount"
348                         ."\n FROM `#__mls_paypal_packages_users` AS `u`"
349                         ."\n INNER JOIN `#__mls_paypal_packages` AS `p` ON u.packageid=p.id"
350                         ."\n WHERE u.userid='".$my->id."'" );
351         $packages = $database->loadObjectList();
352         $paid = 0;
353         foreach($packages AS $pkg) {
354             if($pkg->type == 1 AND $pkg->num_events > 0 AND $paid == 0) {
355                 //package for X amount of events
356                 $database->setQuery( "UPDATE `#__mls_events_participants` SET `paid`='1', `paid_time`='".$now."' WHERE `eventid`='".$eventid."' AND `userid`='".$userid."'" );
357                 if($database->query()) {
358                     $database->setQuery( "UPDATE `#__mls_paypal_packages_users` SET `num_events` = `num_events` - 1 WHERE `id`='".$pkg->id."'" );
359                     $database->query();
360                     $paid = 1;
361                 }
362             } elseif($pkg->type == 2 AND $pkg->expiration_time > $now AND $paid == 0) {
363                 //we have a valid membership
364                 $database->setQuery( "UPDATE `#__mls_events_participants` SET `paid`='1', `paid_time`='".$now."' WHERE `eventid`='".$eventid."' AND `userid`='".$userid."'" );
365                 $database->query();
366             }
367         }
368         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("msg_just_enrolled_for").$row->name."!"));
369     } else {
370         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("err_enrolling_for").$row->name."!"));
371     }
372 };
373
374 function deEnrol($eventid, $userid, $option, $Itemid) {
375     global $database,$my,$l;
376     $l->setBlock("general");
377     $event = new mosMLS_events( $database );
378     $event->load($eventid);
379     $database->setQuery("DELETE FROM `#__mls_events_participants` WHERE `eventid`='".$eventid."' AND `userid`='".$userid."'");
380     if($database->query()) {
381         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("msg_enrolment_deleted").$event->name));
382     } else {
383         mosRedirect("?option=$option&Itemid=$Itemid&mosmsg=".urlencode($l->m("msg_delete_enrolment").$event->name));
384     }
385 };
386
387 function listComments($eventid, $option, $Itemid) {
388     global $database,$my, $mosConfig_offset;
389     if($_POST) {
390         $c = new mosMLS_events_comment( $database );
391         $c->bind( $_POST );
392         $c->published = 1;
393         $c->time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
394         $c->store();
395     }
396     $e = new mosMLS_events( $database );
397     $e->load( $eventid );
398     
399     $database->setQuery( "SELECT c.*,u.username"
400                     ."\n FROM `#__mls_events_comments` AS `c`"
401                     ."\n INNER JOIN `#__users` AS `u` ON u.id=c.userid"
402                     ."\n WHERE c.eventid='".$e->id."' AND `published`='1'"
403                     ."\n ORDER BY c.time DESC" );
404     $rows = $database->loadObjectList();
405     
406     HTML_MLS_events::listComments($rows, $e, $option, $Itemid);
407 };
408
409
410 function listReviews($eventid, $option, $Itemid) {
411     global $database,$my;
412     $query = "SELECT r.*,u.username as `username` FROM `#__mls_events_reviews` AS `r`"
413             ."\n INNER JOIN `#__users` AS `u` ON u.id=r.userid"
414             ."\n WHERE r.eventid='".$eventid."'"
415             ."\n ORDER BY r.time DESC";
416     $database->setQuery($query);
417     $rows = $database->loadObjectList();
418     
419     $database->setQuery( "SELECT COUNT(*) FROM `#__mls_events_reviews` WHERE `eventid`='".$eventid."' AND `published`='0'" );
420     $unpub = $database->loadResult();
421         
422     $event = new mosMLS_events($database);
423     $event->load($eventid);
424     
425     HTML_MLS_events::listReviews($rows,$event,$unpub, $option,$Itemid);
426 };
427
428 function readReview( $id, $option, $Itemid ) {
429     global $database,$my;
430     $query = "SELECT r.*,u.username as `username`,u.name as `realname` FROM `#__mls_events_reviews` AS `r`"
431             ."\n INNER JOIN `#__users` AS `u` ON u.id=r.userid"
432             ."\n WHERE r.id='".$id."'";
433     $database->setQuery($query);
434     $database->loadObject($row);
435     
436     $event = new mosMLS_events($database);
437     $event->load($row->eventid);
438     
439     HTML_MLS_events::readReview($row,$event,$option,$Itemid);
440 };
441     
442
443 function editReview($id, $eventid, $option, $Itemid) {
444     global $database,$my,$l, $mosConfig_offset;
445     if(!$my->id) {
446         mosNotAuth();
447         return;
448     }
449     
450     $row = new mosMLS_events_review( $database );
451     $row->load($id);
452     if($id) {
453         //things for editing
454         if($my->id != $row->userid) {
455             mosRedirect( "index.php?option=$option&task=list_reviews&eventid=$eventid&mosmsg=".urlencode($l->m("err_not_authorized","general")) );
456         }
457     } else {
458         $row->time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
459         $row->userid = $my->id;
460         $row->eventid = $eventid;
461         $row->published = 0;
462     }
463     $event = new mosMLS_events($database);
464     $event->load($eventid);
465     
466     HTML_MLS_events::editReview($row, $event, $option, $Itemid);
467 };
468
469 function saveReview( $option, $Itemid) {
470     global $database,$my, $mosConfig_offset;
471     if(!$my->id) {
472         mosNotAuth();
473         return;
474     }
475     $row = new mosMLS_events_review( $database );
476     
477     if (!$row->bind( $_POST )) {
478         echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
479         exit();
480     }
481     if (!$row->check()) {
482         echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
483         exit();
484     }
485     if (!$row->store()) {
486         echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
487         exit();
488     }
489     
490     mosRedirect( "index.php?option=$option&task=list_reviews&Itemid=$Itemid&eventid=".$row->eventid );
491 };
492
493 function payEvent( $eventid, $option, $Itemid ) {
494     global $database, $my, $cnf_mls_pp;
495     if(!$my->id) {
496         mosNotAuth();
497         return;
498     }
499     
500     $event = new mosMLS_events( $database );
501     $event->load($eventid);
502     $database->setQuery( "SELECT p.*,t.name AS `timename`, t.start, t.end, CONCAT('package_',p.id,'_','".$my->id."') AS `code`"
503                     ."\n FROM `#__mls_paypal_packages` AS `p`"
504                     ."\n LEFT JOIN `#__mls_events_times` AS `t` ON t.id = p.timeid"
505                     ."\n WHERE p.eventid='".$event->id."' AND p.published='1'"
506                     ."\n ORDER BY p.price ASC" );
507     $packages_event = $database->loadObjectList();
508     
509     $database->setQuery( "SELECT p.*, CONCAT('package_',p.id,'_','".$my->id."') AS `code`"
510                     ."\n FROM `#__mls_paypal_packages` AS `p`"
511                     ."\n WHERE p.type < '3' AND p.published='1'"
512                     ."\n ORDER BY p.price ASC" );
513     $packages_general = $database->loadObjectList();
514     
515     HTML_MLS_events::payEvent($event, $packages_event, $packages_general, $option, $Itemid);
516 }
517
518 ?>
Note: See TracBrowser for help on using the browser.