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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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 7 Years, 2 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 7 Years, 2 Months ago Karma: 667
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