public static function NewsUpdate(Ab_Database $db, $d)
{
$info = NewsQuery::NewsInfo($db, $d->id);
Ab_CoreQuery::ContentUpdate($db, $info['ctid'], $d->body);
$sql = "\n\t\t\tUPDATE " . $db->prefix . "ns_news\n\t\t\tSET \n\t\t\t\tdateedit=" . TIMENOW . ",\n\t\t\t\tpublished=" . bkint($d->dp) . ",\n\t\t\t\ttitle='" . bkstr($d->tl) . "',\n\t\t\t\tintro='" . bkstr($d->intro) . "',\n\t\t\t\timageid='" . bkstr($d->img) . "',\n\t\t\t\tsource_name='" . bkstr($d->srcnm) . "',\n\t\t\t\tsource_link='" . bkstr($d->srclnk) . "'\n\t\t\tWHERE newsid=" . bkint($d->id) . "\n\t\t";
$db->query_write($sql);
}
public function NewsPublish($id)
{
if (!$this->IsNewsWriteAccess($id)) {
return;
}
NewsQuery::NewsPublish($this->db, $id, $this->userid);
}
* @author Alexander Kuzmin (roosit@abricos.org)
*/
$charset = "CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'";
$updateManager = Ab_UpdateManager::$current;
$db = Abricos::$db;
$pfx = $db->prefix;
if ($updateManager->isInstall()) {
$db->query_write("\n\t\tCREATE TABLE IF NOT EXISTS " . $pfx . "ns_cat (\n\t\t `catid` int(10) unsigned NOT NULL auto_increment,\n\t\t `parentcatid` int(10) unsigned NOT NULL,\n\t\t `name` varchar(250) NOT NULL,\n\t\t `phrase` varchar(250) NOT NULL,\n\t\t PRIMARY KEY (`catid`)\n\t\t)" . $charset);
$db->query_write("\n\t\tCREATE TABLE IF NOT EXISTS " . $pfx . "ns_news (\n\t\t `newsid` int(10) unsigned NOT NULL auto_increment,\n\t\t `language` CHAR(2) NOT NULL DEFAULT '' COMMENT 'Язык',\n\t\t `userid` int(10) unsigned NOT NULL,\n\t\t `dateline` int(10) unsigned NOT NULL default '0',\n\t\t `dateedit` int(10) unsigned NOT NULL default '0',\n\t\t `deldate` int(10) unsigned NOT NULL default '0',\n\t\t `contentid` int(10) unsigned NOT NULL,\n\t\t `title` varchar(200) NOT NULL,\n\t\t `intro` text NOT NULL,\n\t\t `imageid` varchar(8) default NULL,\n\t\t `published` int(10) unsigned NOT NULL default '0',\n\t\t `source_name` varchar(200) default NULL,\n\t\t `source_link` varchar(200) default NULL,\n\t\t PRIMARY KEY (`newsid`)\n\t\t)" . $charset);
if (Ab_UpdateManager::$isCoreInstall) {
// Идет инсталляция платформа
$d = new stdClass();
if (Abricos::$LNG == 'ru') {
$d->tl = "Рождение сайта";
$d->intro = "\n\t\t\t\t<p>Уважаемые посетители!</p>\n\t\t\t\t<p>\n\t\t\t\t\tМы рады сообщить Вам о запуске нашего сайта.\n\t\t\t\t</p>\n\t\t\t\t<p>\n\t\t\t\t\tДля работы сайта мы используем платформу\n\t\t\t\t\t<a href='http://abricos.org' title='Платформа Абрикос - система управления сайтом'>Абрикос</a>,\n\t\t\t\t\tпотому что именно на этой платформе мы сможем реализовать для Вас\n\t\t\t\t\tпрактически безграничные возможности.\n\t\t\t\t</p>\n\t\t\t";
} else {
$d->tl = "Birth site";
$d->intro = "\n\t\t\t\t<p>Dear visitors!</p>\n\t\t\t\t<p>\n\t\t\t\t\tWe are pleased to announce the launch of our website.\n\t\t\t\t</p>\n\t\t\t\t<p>\n\t\t\t\t\tFor site work, we use <a href='http://abricos.org' title='Abricos Platform - content managment system, WebOS'>Abricos Platrofm</a>,\n\t\t\t\t\tbecause it was on this platform, we can realize for you virtually limitless possibilities.\n\t\t\t\t</p>\n\t\t\t";
}
$d->dp = TIMENOW;
require_once 'dbquery.php';
NewsQuery::NewsAppend($db, 1, $d);
}
}
if ($updateManager->isUpdate('0.2.2')) {
Abricos::GetModule('news')->permission->Install();
}
if ($updateManager->isUpdate('0.2.6') && !$updateManager->isInstall()) {
$db->query_write("\n\t\tALTER TABLE " . $pfx . "ns_news\n\t\tADD `language` CHAR(2) NOT NULL DEFAULT '' COMMENT 'Язык'\n\t");
$db->query_write("UPDATE " . $pfx . "ns_news SET language='ru'");
}
</div>
<?php
}
?>
<?php
$i++;
?>
<?php
}
?>
</div>
<div class="col-md-4">
<h1>Anouncements</h1>
<ul class="media-lists">
<?php
$newses = NewsQuery::create()->orderByDatetime("DESC")->limit(4)->find();
?>
<?php
foreach ($newses as $news) {
?>
<li class="media">
<div class="media-body">
<h4 class="media-heading">
<?php
echo $news->getTitle();
?>
</h4>
<p>
<?php
echo $news->getContent();
?>
