Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Select detail article link from weblink or banner category?

Select detail article link from weblink or banner category? 11 years 10 months ago #19569

  • nfj-admin
  • nfj-admin's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 17
  • Thank you received: 0
Hi all,

if i create a new event or edit a existing event either from backend and also from frontend event management i have the following problem:

If I select the category for the detail article link for the event, not only the categorys for my articles are shown, but also the categorys for my
weblinks, banners, contacts, newsfeeds and so on.

Is this expected? I don't see any sense in selecting a detail article from a category other than from my content categorys.

I would like to hear, if anyone else has experienced this and has suggestions. Hope, that my database is not corrupt...

(Joomla 2.5.8; DTRegister 2.8.3; PHP 5.4.10 on my site)

Regards,
Stefan

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

Select detail article link from weblink or banner category? 11 years 10 months ago #19575

  • nfj-admin
  • nfj-admin's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 17
  • Thank you received: 0
Oh!
I'm replying to my own post. This is weird. :evil:
But I found a solution for my problem...

In add_tab.general.php there's a query for the database:

$query = "Select c.* from #__categories c where published <> 0 and parent_id > 0 ".$con." order by lft asc ";

This query will return all categorys from the ***** _categorys table of the database - which are published and parent_id > 0.

Better would be perhaps:

$query = "Select c.* from #__categories c where published <> 0 and extension = 'com_content' and parent_id > 0 ".$con." order by lft asc ";

Seems to work for me - but I'm not a SQL expert and I'm unsure about the side effects my changes will have, so i would like to hear what dth_development says to this change.

Regards,
Stefan

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

  • Page:
  • 1
Time to create page: 0.445 seconds