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; }