Hi Moni,

you didn't mention whether the table "vendor_node" has a column for the user id, so I'm going to assume it does, and it's named "userid".

if ($user->id == 0) return BBB; // short circuit if not logged in
$query = "select publish from vendor_node where userid = " . (int)$user->id
  . " and publish = 1";
$db->setQuery( $query, 0, 1 );
$found = $db->loadResult();
if ($found) return AAA;
return BBB;
// Replace AAA with module id to use when user has published entry
// in the vendor_node table.
// Replace BBB with module id to use if user is not logged in, or
// user does not have published entry in vendor_node table.

ok, this might work. I'm using the exact column names you sent.


if ($user->id == 0) return BBB; // short circuit if not logged in
$query = "SELECT v.publish FROM vendor_node v, members_node m "
  . " WHERE v.UID = m.UID "
  . " AND m.ID = " . (int)$user->id
  . " AND v.publish = 1";
$db->setQuery( $query, 0, 1 );
$found = $db->loadResult();
if ($found) return AAA;
return BBB;
// Replace AAA with module id to use when user has published entry
// in the vendor_node table.
// Replace BBB with module id to use if user is not logged in, or
// user does not have published entry in vendor_node table.


Cheers,
Stephen

My apologies. The code you provided actually works. I neglected to add my database prefix to everything. Thank you very much!

Lastly, are you the developer of Metamod? Just wondering. I don't need the pro version but I plan to register it next week if only to support the software.

Thanks again!
-Moni

Well, didn't need the pro version on Metamod (as the free version did everything I needed) but I just licensed Chameleon. Saved me A LOT of work! Amazing software! Reviewing both on the Joomla Extensions Directory now.

Much appreciation!
-Moni