Lower level frontend users cant choose location

  • Jono
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #61141 by Jono
Hi,
On our web site, we are experiencing that lower level users who have permissions to submit events in the frontend are unable to choose from the list of available locations for the event.
On their screens, the dropdown list of available locations is empty - whereas for higher level users, the dropdown list is populated correctly with the available locations?
We are using version 1.6.3 - but are not in a hurry to upgrade as you have helped us make some customisations.

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61157 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
You can upload the file components/com_eventbooking/views/event/view.html.php on your site here. I will help modifying the code for you to make it is possible

Tuan

Please Log in or Create an account to join the conversation.

  • Jono
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #61202 by Jono
Thanks so much Tuan,
I have attached the file

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61203 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
You can get the modified file here, upload it to your site and it should work well

Tuan

Please Log in or Create an account to join the conversation.

  • Jono
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #61213 by Jono
Thanks for your help so far Tuan.
I tested it and for some reason, the same issue remains.
The site does not use cache - so it is not a cache issue.
I logged out and logged in again after uploading the file, but the issue is still the same with no 'location' being selectable when submitting an event as a lowerlevel user.

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61218 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
That's strange. You can submit a support ticket sending us super admin account of your site so that I can check and edit the code directly on your site for you.

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61470 by CCC
Was this solved?

I am having the same problem. My front end users did not have any locations to choose from. Even though locations were created in the back end, the drop down for the location says "Select Location". But there are none available.

But I figured out what is happening. The user can only see the locations that they created. This won't work for us as we will have more than one user adding events and would like them to share locations.

Can we get a fix?

Thanks!

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61481 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
Hi

Yes. You can edit the code abit to make it work:

1. Open the file components/com_eventbooking/views/event/view.html.php

2. Find these lines of code:
Code:
if ($user->authorise('core.admin', 'com_eventbooking')) { $sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 ORDER BY name'; } else { $sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 AND user_id=' . $user->id . ' ORDER BY name '; }

3. Change it to
Code:
$sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 ORDER BY name';

Then all published locations will be displayed for users to choose for their events

Tuan
The following user(s) said Thank You: CCC

Please Log in or Create an account to join the conversation.

  • Jono
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #61521 by Jono
Thanks Tuan - I have now got it working. The edited file you provided me with still had "AND user_id=' . $user->id . '" in the sql query - but by following your steps below I got it resolved.
Excellent service - thanks Tuan!

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #61562 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
Oh, OK. Don't know why I could make that mistake :D.

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc