function getModule($modId = 0)
{
$query = new XiptQuery();
$query->select('*');
$query->from('#__modules');
$query->where("`id` = {$modId}");
$module = $query->dbLoadQuery("", "")->loadObject();
return $module;
}
function getAllModules($published = '')
{
$query = new XiptQuery();
$query->select('*');
$query->from('#__modules');
$query->where("`published` = {$published}");
$query->order('ordering');
$modules = $query->dbLoadQuery("", "")->loadObjectList();
return $modules;
}
function getJomsocialProfileFields($filter = '', $join = 'AND')
{
$query = new XiptQuery();
$query->select('*');
$query->from('#__community_fields');
//setting up the search condition is there is any
if (!empty($filter)) {
foreach ($filter as $column => $value) {
$query->where(" `{$column}` = '{$value}' ", $join);
}
}
$query->order('ordering');
$fields = $query->dbLoadQuery("", "")->loadObjectList();
return $fields;
}
