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