public function getLatestCommentTime($listingId = 0) { $user = JFactory::getUser(); $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('created')->from('#__judirectory_comments')->order('id DESC'); if ($listingId > 0) { $query->where('listing_id = ' . $listingId); } if ($user->id > 0) { $query->where('user_id =' . $user->id); } else { $ipAddress = JUDirectoryFrontHelper::getIpAddress(); $query->where('ip_address = "' . $ipAddress . '"'); } $db->setQuery($query, 0, 1); $result = $db->loadResult(); return $result; }
public static function checkBlackListUserIP() { require_once JPATH_SITE . '/components/com_judirectory/libs/ipblocklist.class.php'; $params = JUDirectoryHelper::getParams(); $app = JFactory::getApplication(); $is_passed = true; if ($app->isSite() && $params->get('block_ip', 0)) { $ip_address = JUDirectoryFrontHelper::getIpAddress(); $ipWhiteList = $params->get('ip_whitelist', ''); $ipBlackList = $params->get('ip_blacklist', ''); $checkIp = new IpBlockList($ipWhiteList, $ipBlackList); $is_passed = $checkIp->ipPass($ip_address); } return $is_passed; }
protected function prepareTable($table) { $date = JFactory::getDate(); $user = JFactory::getUser(); if (empty($table->id)) { if (!$table->created) { $table->created = $date->toSql(); } if (!$table->guest_name || !$table->guest_email) { $table->user_id = $user->id; } if (!$table->ip_address) { $table->ip_address = JUDirectoryFrontHelper::getIpAddress(); } } else { $table->modified_by = $user->id; $table->modified = $date->toSql(); } }
public function addCommentSubscription($commentId) { $user = JFactory::getUser(); $subscriptionData = array(); $subscriptionData['user_id'] = $user->id; $subscriptionData['type'] = 'comment'; $subscriptionData['name'] = $user->username; $subscriptionData['email'] = $user->email; $subscriptionData['created'] = JHtml::date('now', 'Y-m-d H:i:s', true); $subscriptionData['item_id'] = $commentId; $subscriptionData['ip_address'] = JUDirectoryFrontHelper::getIpAddress(); $subscriptionData['published'] = 1; require_once JPATH_SITE . '/components/com_judirectory/models/subscribe.php'; JModelLegacy::addIncludePath(JPATH_SITE . '/components/com_judirectory/models'); $subcribeModel = JModelLegacy::getInstance('Subscribe', 'JUDirectoryModel'); if (!$subcribeModel->add($subscriptionData)) { return false; } return true; }