Assembla home | Assembla project page
 

root/tags/com_mls_events/0.1.4/mls_events.php

Revision 37, 19.4 kB (checked in by moensch, 3 years ago)

Importing com_mls_events 0.1.4 into trunk

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