Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Modifying the SQL Query to add another requirement
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Modifying the SQL Query to add another requirement
#6285
Modifying the SQL Query to add another requirement 13 Years, 7 Months ago Karma: 0
basically we have modified our version of joomla so we can put multiple sub menu items but only show them if we want them shown..

Basically i may have

Music
--Bands
--Concerts
--Resources

so in the params of each menu iteam we have a field

To Show On Submenu it would be this
noc_sub_menu_display=1

Do Not Show on Submenu it would be this
noc_sub_menu_display=0

and my previous custom menu we had the query include that

ex. SELECT id, name, link, type, sublevel FROM jos_menu
WHERE published = 1 AND params like \"%noc_sub_menu_display=1%\"
AND parent = '$parent_id' ORDER BY ordering LIMIT 0, $item_limit"

it works great right now but we really want to use this menu now we like the style and functionality of it we really just need to get what is bolded added to the query i did some punking around and found in the class.MenuHelper.php file that there is a query i tried to at params like \%noc_sub_menu_display=1%\ to line 27 of the code " ' WHERE menutype = %s AND published = 1 AND access < %d%s' ." but it would it would just break the menu.. does anyone have any clue how i can get this to work?

Thanks,
Leigh
The administrator has disabled public write access.
 
#6547
Re:Modifying the SQL Query to add another requirement 13 Years, 7 Months ago Karma: 746
Hello,

Send you modified class.MenuHelper.php file by email, please.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1