Welcome to the MetaMod and Chameleon Support Forums.

Before posting, please check out the FAQs.

helpme

 

Need extra help with your Joomla site? Consider paid Joomla support by the developer of Chameleon and MetaMod.

 

Metamod w/ Jbusinesslisting

Metamod w/ Jbusinesslisting

Greetings,
I'm using Joomla 3.3 w/ a modified Shape5 template and trying to see if it's possible to dynamically show a module based on the category selected from a database search (jbusinesslisting extension)?

If so, I'm trying to get the PHP syntax to query the database, then depending on the  category selected activate a module.

Thoughts?

Thanks in advance!

Piranha
Beginner Modder
ranks
useravatar
Offline
4 Posts
Administrator has disabled public posting

Re: Metamod w/ Jbusinesslisting

Hi Piranha,

Yes it should be possible to do this. The basic syntax for doing a database call is pretty simple, but the tricky bit is knowing how jbusinesslisting structures its database entries.

In fact there are 2 things you need to be able to work out:

1 - info from the URL about what item and/or category you are viewing. You almost certainly need to be able to extract a category id or item id from this. To help with this, try turning on MetaMod's Advanced Debug mode which gives you some example PHP code which is likely to help.

2 - the database tables used by jbusinesslisting

If you know a bit about databases already, would it be possible for you to take a look at the database tables used for jdatabaselisting's items and categories, and give some information about what the tables are called, and any relevant columns? You'll likely need at least these:

1 - name of category table
2 - name of item table
3 - names of columns for the ids on both tables (perhaps category_id and item_id or something similar, but you need to find the exact name)
4 - name of column in the item table that refers to the category table (e.g. category_id)

Together with the info from advanced debug mode (make a note of the output when you are viewing a category page and when you are viewing an item page) that may be enough to write some code for you.

Thanks,
Stephen

Stephen Brandon
MetaMod / Chameleon developer
If you use MetaMod or Chameleon, please post a rating and a review at the Joomla! Extensions Directory: Chameleon | MetaMod

metamodguy
useravatar
Offline
3329 Posts
User info in posts
Administrator has disabled public posting

Board Info

Board Stats:
 
Total Topics:
1696
Total Polls:
6
Total Posts:
5941
Posts this week:
8
User Info:
 
Total Users:
5378
Newest User:
gary9131
Members Online:
0
Guests Online:
130

Online: 
There are no members online

Forum Legend:

 Topic
 New
 Locked
 Sticky
 Active
 New/Active
 New/Locked
 New Sticky
 Locked/Active
 Active/Sticky
 Sticky/Locked
 Sticky/Active/Locked