function saveUserAppsParams($mode = '', $userId, $appId, $referId = 0, $param = null)
{
$db = EasyBlogHelper::db();
$result = true;
if (!empty($mode)) {
$command = array();
$todayDate = new JDate();
if ($mode == 'insert') {
$inserted = false;
$uApps = EasyBlogHelper::getTable('UserApps', 'Table');
$uApps->app_id = $appId;
$uApps->user_id = $userId;
$uApps->created = $todayDate->toMySql();
$uApps->modified = $todayDate->toMySql();
$uApps->published = true;
if ($uApps->store()) {
$inserted = true;
}
if ($inserted) {
$tmpId = $uApps->id;
foreach ($param as $key => $val) {
$query = 'INSERT INTO ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_params') . ' ' . ' ( ' . EasyBlogHelper::getHelper('SQL')->nameQuote('refer_id') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_name') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_value') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_value_type') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_type') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('created') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('modified') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('published') . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('ordering') . ' ' . ' ) ' . 'VALUES ' . ' ( ' . $db->quote($tmpId) . ', ' . $db->quote($key) . ', ' . $db->quote($val) . ', ' . $db->quote('string') . ', ' . $db->quote('userapp') . ', ' . $db->quote($todayDate->toMySql()) . ', ' . $db->quote($todayDate->toMySql()) . ', ' . $db->quote('1') . ', ' . $db->quote('1') . ' ' . ' ); ';
$command[] = $query;
}
}
} else {
foreach ($param as $key => $val) {
$query = 'UPDATE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_params') . ' ' . 'SET ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_value') . ' = ' . $db->quote($val) . ', ' . EasyBlogHelper::getHelper('SQL')->nameQuote('modified') . ' = ' . $db->Quote($todayDate->toMySql()) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('refer_id') . ' = ' . $db->quote($referId) . ' AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_name') . ' = ' . $db->quote($key) . ' AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('param_type') . ' = ' . $db->quote('userapp');
$command[] = $query;
}
}
// now we execute all the query
if (empty($command)) {
$result = false;
}
foreach ($command as $cmdQuery) {
$db->setQuery($cmdQuery);
if (!$db->Query()) {
$result = false;
}
if ($db->getErrorNum()) {
JError::raiseError(500, $db->stderr());
}
}
//process ended here.
} else {
$result = false;
}
return $result;
}
