/** * Возвращает XML со всеми комментариями по всем описанным в конфиге модулям * @param \DOMElement $node */ public function getAllCommentsXML($node) { $modules = \Difra\Config::getInstance()->get('comments'); if (empty($modules)) { $node->appendChild($node->ownerDocument->createElement('empty')); return; } $db = \Difra\MySQL::getInstance(); foreach ($modules['modules'] as $module) { $moduleXML = $node->appendChild($node->ownerDocument->createElement($module . '_comments')); $moduleXML->setAttribute('module', $module); // забираем комментарии по модулю $query = ''; switch ($module) { case 'albums': $query = "SELECT c.`id`, c.`text`, c.`reply_id`, DATE_FORMAT( c.`date`, '%T %d-%m-%Y' ) as `date`,\n\t\t\t\t\t\t\t\tuf.`value` AS `nickname`, bp.`link` AS `post_link`, bp.`name` AS `title`, g.`domain`,\n\t\t\t\t\t\t\t\tbp.`id` AS `post_id`\n\t\t\t\t\t\t\tFROM `albums_comments` c\n\t\t\t\t\t\t\tLEFT JOIN `users_fields` AS `uf` ON uf.`id`=c.`user` AND uf.`name`='nickname'\n\t\t\t\t\t\t\tLEFT JOIN `albums` AS `bp` ON bp.`id`=c.`parent_id`\n\t\t\t\t\t\t\tLEFT JOIN `groups` AS `g` ON g.`id`=bp.`group_id`\n\t\t\t\t\t\t\tORDER BY c.`date` DESC"; break; case 'blogs': $query = "SELECT c.`id`, c.`user`, c.`text`, c.`reply_id`, bp.`title`, b.`user` `post_owner`, b.`group`,\n\t\t\t\t\t\t\t\tg.`domain`, of.`value` AS `owner_nickname`, bp.`link` AS `post_link`, bp.`id` AS `post_id`,\n\t\t\t\t\t\t\t\tDATE_FORMAT( c.`date`, '%T %d-%m-%Y' ) as `date`, uf.`value` AS `nickname`\n\t\t\t\t\t\t\tFROM `blogs_comments` `c`\n\t\t\t\t\t\t\tLEFT JOIN `users_fields` AS `uf` ON uf.`id`=c.`user` AND uf.`name`='nickname'\n\t\t\t\t\t\t\tLEFT JOIN `blogs_posts` AS `bp` ON bp.`id`=c.`parent_id`\n\t\t\t\t\t\t\tLEFT JOIN `blogs` AS `b` ON b.`id`=bp.`blog`\n\t\t\t\t\t\t\tLEFT JOIN `groups` AS `g` ON g.`id`=b.`group`\n\t\t\t\t\t\t\tLEFT JOIN `users_fields` AS `of` ON of.`id`=b.`user` AND of.`name`='nickname'\n\t\t\t\t\t\t\tORDER BY c.`date` DESC"; break; case 'catalog': $query = "SELECT c.`id`, c.`text`, c.`reply_id`, DATE_FORMAT( c.`date`, '%T %d-%m-%Y' ) as `date`,\n\t\t\t\t\t\t\t\tuf.`value` AS `nickname`, bp.`name` AS `title`\n\t\t\t\t\t\t\tFROM `catalog_comments` c\n\t\t\t\t\t\t\tLEFT JOIN `users_fields` AS `uf` ON uf.`id`=c.`user` AND uf.`name`='nickname'\n\t\t\t\t\t\t\tLEFT JOIN `catalog_items` AS `bp` ON bp.`id`=c.`parent_id`\n\t\t\t\t\t\t\tORDER BY c.`date` DESC"; break; } $res = $db->fetch($query); foreach ($res as $data) { /** @var $itemNode \DOMElement */ $itemNode = $moduleXML->appendChild($node->ownerDocument->createElement('item')); $itemNode->setAttribute('id', $data['id']); $itemNode->setAttribute('nickname', $data['nickname']); $itemNode->setAttribute('date', $data['date']); $itemNode->setAttribute('text', $data['text']); $itemNode->setAttribute('reply_id', $data['reply_id']); $itemNode->setAttribute('title', $data['title']); $link = 'http://'; switch ($module) { case 'blogs': if ($data['domain'] != '') { // ссылка на блог группы $link .= $data['domain'] . '.' . \Difra\Site::getInstance()->getMainhost() . '/' . $data['post_id'] . '/' . rawurlencode($data['post_link']) . '/#comment' . $data['id']; } else { // ссылка на блог юзера $link .= \Difra\Site::getInstance()->getMainhost() . '/blogs/' . $data['owner_nickname'] . '/' . $data['post_id'] . '/' . rawurldecode($data['post_link']) . '/#comment' . $data['id']; } break; case 'albums': $link = 'http://' . $data['domain'] . '.' . \Difra\Site::getInstance()->getMainhost() . '/album/' . rawurldecode($data['post_link']) . '/#comment' . $data['id']; break; case 'catalog': $link = 'http://' . \Difra\Site::getInstance()->getMainhost() . '/c/'; break; } $itemNode->setAttribute('parentLink', $link); } } }
/** * Возвращает полную ссылку на новость */ public function getTrueLink() { return 'http://' . \Difra\Site::getInstance()->getHostname() . '/news/' . $this->id . '-' . $this->link; }
/** * Возвращает массив с новостями для карты сайта */ public function getSiteMapArray() { $db = \Difra\MySQL::getInstance(); $where = " WHERE `visible`=1 AND `viewDate`<=NOW() AND (( NOT(`stopDate`='0000-00-00 00:00:00') AND `stopDate`>=NOW() ) " . "OR `stopDate`='0000-00-00 00:00:00') "; $query = "SELECT `id`, `link`, `modified` FROM `news` " . $where; $res = $db->fetch($query); if (!empty($res)) { $returnArray = null; $mainLink = 'http://' . \Difra\Site::getInstance()->getHostname() . '/news/'; foreach ($res as $k => $data) { $returnArray[] = ['loc' => $mainLink . $data['id'] . '-' . $data['link'], 'lastmod' => date('Y-m-d', strtotime($data['modified']))]; } return $returnArray; } return false; }
public static function getByDomain($domain) { $mainHost = Difra\Site::getInstance()->getMainhost(); if ($mainHost == $domain) { return null; } if (substr($domain, strlen($domain) - strlen($mainHost)) != $mainHost) { return null; } $domain = substr($domain, 0, strlen($domain) - strlen($mainHost) - 1); $db = Difra\MySQL::getInstance(); $groupData = $db->fetchRow('SELECT * FROM `groups` WHERE `domain`=\'' . $db->escape($domain) . "'"); return self::makeGroup($groupData); }
/** * Возвращает XML с добавленными в базу видео * @param \DOMNOde $node */ public function getAddedVideosXML($node) { if (!is_dir($this->dirOut)) { $errorNode = $node->appendChild($node->ownerDocument->createElement('error')); $errorNode->setAttribute('type', 'badOutDir'); return; } $db = \Difra\MySQL::getInstance(); $query = "SELECT `id`, `video`, `status`, `name`, `date`, `thumbs`, `length`, `hasPoster`, `original_file` FROM `videos`\n\t\t\t\tWHERE `site`='" . Site::getInstance()->getHost() . "' ORDER BY `date` ASC"; $db->fetchXML($node, $query); }
private function sendMail() { $db = \Difra\MySQL::getInstance(); // определяем кто владелец родительского элемента switch ($this->module) { case 'albums': $query = "SELECT a.`name` AS `title`, a.`link`, a.`group_id`, g.`domain`, g.`owner`\n\t\t\t\t\t\tFROM `albums` a\n\t\t\t\t\t\tLEFT JOIN `groups` AS `g` ON g.`id`=a.`group_id`\n\t\t\t\t\t\tWHERE a.`id`='" . $this->moduleId . "'"; break; case 'catalog': // TODO: замутить отправку письма если это ответ на коммент юзера // XXX: есть ведь уже? //nap return; case 'blogs': default: $query = "SELECT b.`user`, g.`owner`, bp.`title`, g.`domain`, bp.`link`\n\t\t\t\t\tFROM `blogs_posts` bp\n\t\t\t\t\tLEFT JOIN `blogs` AS `b` ON b.`id`=bp.`blog`\n\t\t\t\t\tLEFT JOIN `groups` AS `g` ON g.`id`=b.`group`\n\t\t\t\t\tWHERE bp.`id`='" . $this->moduleId . "'"; break; } $res = $db->fetchRow($query); if (empty($res)) { return; } if (isset($res['user']) && $res['user'] != '') { $elementOwner = $res['user']; } else { $elementOwner = $res['owner']; } // смотрим можно ли юзеру отправить email $userAdditionals = \Difra\Additionals::getAdditionals('users', $elementOwner); if (!isset($userAdditionals['unsubscribe']) || $userAdditionals['unsubscribe'] == 0) { // отправляем письмо владельцу родительского элемента $query = "SELECT `email`, `activation` FROM `users` WHERE `id`='" . intval($elementOwner) . "' AND `banned`=0 AND `active`=1"; $replyText = []; if ($this->replyId) { // это ответ на чужой коммент. // забираем данные об ответе $query = "SELECT c.`text`, c.`user` FROM `" . $this->module . "_comments` c WHERE c.`id`='" . $this->replyId . "'"; $replyText = $db->fetchRow($query); $query = "SELECT `email`, `activation` FROM `users` WHERE `id`='" . intval($replyText['user']) . "' AND `banned`=0 AND `active`=1"; } $userData = $db->fetchRow($query); if (!empty($userData)) { // получаем никнейм отправителя: $replyUser = \Difra\Additionals::getAdditionalValue('users', $this->user, 'nickname'); // ссылка на родительский элемент $elementLink = ''; if ($this->module == 'albums') { // если альбом $elementLink = 'http://' . $res['domain'] . '.' . \Difra\Site::getInstance()->getMainhost() . '/album/' . rawurlencode($res['link']) . '/'; } elseif ($this->module == 'blogs') { if (isset($res['domain']) && $res['domain'] != '') { // если пост в блоге группы $elementLink = 'http://' . $res['domain'] . '.' . \Difra\Site::getInstance()->getMainhost() . '/' . $this->moduleId . '/' . rawurlencode($res['link']) . '/'; } else { // если пост в личном блоге юзера $ownerNickname = \Difra\Additionals::getAdditionalValue('users', $elementOwner, 'nickname'); $elementLink = 'http://' . \Difra\Site::getInstance()->getMainhost() . '/blogs/' . $ownerNickname . '/' . $this->moduleId . '/' . rawurlencode($res['link']) . '/'; } } $unsubscribeLink = 'http://' . \Difra\Site::getInstance()->getMainhost() . '/unsubscribe/' . $userData['activation'] . '/'; $sendData = ['unsubscribe' => $unsubscribeLink, 'message' => $this->text, 'module' => $this->module, 'link' => $elementLink, 'reply_nickname' => $replyUser, 'mainHost' => \Difra\Site::getInstance()->getMainhost(), 'title' => $res['title']]; if ($this->replyId) { $sendData['replay'] = 1; $sendData['original'] = $replyText['text']; } \Difra\Mailer::getInstance()->CreateMail($userData['email'], 'mail_newcomment', $sendData); } } }