protected function doInsert(Content $content)
{
$now = time();
$query = "INSERT INTO albums " . "(slug, title, datecreated, datemodified, status, datedisplayed, newsid, eventid, featuredimageid) " . "VALUES " . "('{$content->getSlug()}','{$content->getTitle()}','{$now}','{$now}','{$content->getStatus()}','{$content->getDateDisplayed()}','{$content->getNewsId()}','{$content->getEventId()}','{$content->getFeaturedImageId()}')";
self::$mysqli->query($query);
$content->setId(self::$mysqli->insert_id);
}
protected function doInsert(Content $object)
{
$now = time();
$query = "INSERT INTO newsevents " . "(status, slug, title, datecreated, datemodified, text, description, keywords, datedisplayed, type) " . "VALUES " . "('{$object->getStatus()}', '{$object->getSlug()}','{$object->getTitle()}', '{$now}','{$now}','{$object->getText()}','{$object->getDescription()}','{$object->getKeywords()}','{$object->getDateDisplayed()}','{$object->getContentType()}')";
//echo $query;
self::$mysqli->query($query);
$object->setId(self::$mysqli->insert_id);
}
/**
* Returns the title of the current page.
*
* @package Theme
* @return string The title.
*/
function title()
{
return Content::getTitle();
}
public function update(Content $image)
{
$now = time();
$query = "UPDATE images SET " . "slug='{$image->getSlug()}', " . "title='{$image->getTitle()}', " . "datemodified='{$now}', " . "albumid='{$image->getAlbumId()}', " . "filename='{$image->getFileName()}', " . "status='" . Content::STATUS_LIVE . "', " . "prospective='{$image->getProspective()}', " . "current='{$image->getCurrent()}', " . "staff='{$image->getStaff()}' " . "WHERE id={$image->getId()}";
self::$mysqli->query($query);
}
function setContent($content_body)
{
$this->content_body = htmlentities("{$content_body}");
}
function getContent()
{
return $this->content_body;
}
}
/* Test Id */
$content = new Content();
$content->setID();
$content->setID();
$content->setID();
$content->setID();
$content->setID();
$content->setID() . '<br/>';
$content->setAuthor('Guillermina', 'Gonjon') . '<br/>';
$content->setTitle("this is my title") . '<br/>';
$content->setContent("This is an example of what this page can do. This is my content for this page.");
echo $content->getAuthor() . '<br/>';
echo $content->getDate() . '<br/>';
echo $content->getTitle() . '<br/>';
echo $content->getContent() . '<br/>';
$theid = $content->content_id;
echo $content->formatID($theid) . '<br/>';
var_dump($content);
//echo $content->formatted_id.'<br/>';
$output = shell_exec('cal 2016 | grep 2016') . '<br/>';
//echo "<pre>$output</pre>";
//echo "<br>".phpversion().'<br/>';
/**
* Double checks a content slug after a potential title change
*
* If the title hasn't changed then return. Else generate a new slug
* This requires requires n runs to the database, where n is the number of duplicate slugs
* TODO: Optimize this so we need at most one trip to the database, hint: use LIKE '$newSlug%;
*
* @param $content Content the content object who's slug we need to update
*/
protected function updateSlug(Content $content)
{
$oldSlug = $content->getSlug();
$newSlug = $this->generateSlug($content->getTitle());
if ($oldSlug == $newSlug) {
return;
}
$suffix = '';
while ($this->findBySlug($newSlug . $suffix) !== null) {
if ($suffix == '') {
$suffix = 1;
}
$suffix++;
}
$content->setSlug($newSlug . $suffix);
}
