Home Forum
Qivva Forum
Welcome, Guest
Please Login or Register.    Lost Password?
EventCalendar for Citys Problem
(1 viewing) 1 Guest
Go to bottom
TOPIC: EventCalendar for Citys Problem
#2914
T_H_O_M_A_S
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:EventCalendar for Citys Problem 7 Years, 12 Months ago Karma: 0
The change the URL so that only events from one city are shown i have change line 198 (helper.php) in:

Code:

$evlink = 'index.php?option=com_eventlist&view=day&id='. $tdate.'&filter='.$city.'&filter_type=city&Itemid='.$FixItemID;


Now every thing work fine for me (in the calender i have select "id overwrite" to work).

At the moment I must disable ajax, because with the new version of sh404sef it doesn´t work. (I start a new topic for this)

Greets Thomas
 
Logged Logged
  The administrator has disabled public write access.
#2912
T_H_O_M_A_S
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:EventCalendar for Citys Problem 7 Years, 12 Months ago Karma: 0
Hallo,

first, thanks for your Mail Toni. Maybee I need a new monitor to see that this is a "l" and not a "1"

This query now work for me:

Code:

$query = 'SELECT a.*, city, l.venue, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,c.id AS mcatid,c.catname,l.id AS mlocid,l.venue,'
.' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug'
. ' FROM #__eventlist_events AS a'
. ' LEFT JOIN #__eventlist_categories AS c ON c.id = a.catsid'
. ' LEFT JOIN #__eventlist_venues AS l ON l.id = a.locid'
. $wherestr
. " AND city = '{$city}'"
. ' AND c.access <= '.(int)$user->aid
.($catid ? $categories : '')
.($venid ? $venues : '')
;



Now I put in the default themplate this line again:
Code:

$city = $params->get( 'city', 'Berlin' );


and changed line 265 in:
Code:

$tipTitle = count( $title ) . ' ' . JText::_($CalTooltipsTitlePl) . ' in ' . $city;

and line 268 in:
Code:

$tipTitle = '1 ' . JText::_($CalTooltipsTitle) . ' in ' . $city;


Now in the Top of the Tooltips stand something like this:
"11 Events in Berlin" for Example.

The last problem ist to change the links in the default.php so that they don´t only call the "day-fiew" of all events.
I know I have to put into the URL something like this:
Code:

filter=Berlin&filter_type=city


Now I begin to search the line i have to change and then I post it here. If you have a tip for me i will be very happy:-)

Greets Thomas
 
Logged Logged
  The administrator has disabled public write access.
#2908
T_H_O_M_A_S
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
EventCalendar for Citys Problem 7 Years, 12 Months ago Karma: 0
Hello,

first thanks a lot for this great calendar. My Problem ist, to make the calendar work with citys. So that only Events from one city are shown.
So I try to modify the calendar:

First in the xml file a make a new param:
Code:

<param name="city" type="text" default="Berlin" label="CITY" description="CITY - Display a calendar only for the city chosen" />


Then in the helper.php I ad this:
Code:

$city = $params->get( 'city', 'Berlin' );


Now I try to modify the SQL-call so that only events are coming from the database from the city. My Problem is that I´m not a programmer or so and my code doesn´t work:-( Here is my last try:
Code:

$query = 'SELECT a.*, 1.city, l.venue, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,c.id AS mcatid,c.catname,l.id AS mlocid,l.venue,1.city,'
.' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug'
. ' FROM #__eventlist_events AS a'
. ' LEFT JOIN #__eventlist_categories AS c ON c.id = a.catsid'
. ' LEFT JOIN #__eventlist_venues AS l ON l.id = a.locid'
. $wherestr
. ' WHERE 1.city = '.$city
. ' AND c.access <= '.(int)$user->aid
.($catid ? $categories : '')
.($venid ? $venues : '')
;


Maybe someone can give me a tip?

Greets Thomas

P.S. Sorry for my bad "german-english"
 
Logged Logged
  The administrator has disabled public write access.
Go to top
Drug Amoxil Online (Amoxicillin) is used to treat many different types of infections caused by bacteria, such as ear infections, bladder infections, pneumonia, gonorrhea, and E. coli or salmonella infection. Sleeping pills: l-tryptophan, Phenergan, Unisom, Sominex - currently the most popular are the following hypnotic drugs. Click to see full text here:
Italian online pharmacy. Cialis, Viagra and other generic drugs. The best price and free shipping.
Sponsored by: sominex online shop.