<?php

class Rant
{
	public $id;
	public $published;
	public $status;
	public $side;
	public $author;
	public $title;
	public $body;
	public $link;
	public $imagetype;
	public $imagetext;
}

function saverant($rant)
{
	if ($rant->id)
		return updaterant($rant);
	else
		return insertrant($rant);
}

function insertrant($rant)
{
	global $dbConnection;

	$sql = 'INSERT INTO rant (published, status, side, author, title, body, link, imagetype, imagetext) VALUES ' .
		'(FROM_UNIXTIME(:published), :status, :side, :author, :title, :body, :link, :imagetype, :imagetext)';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('published', (int)$rant->published);
	$stmt->bindValue('status', $rant->status);
	$stmt->bindValue('side', $rant->side);
	$stmt->bindValue('author', (int)$rant->author);
	$stmt->bindValue('title', trim($rant->title));
	$stmt->bindValue('body', trim($rant->body));
	$stmt->bindValue('link', trim($rant->link));
	$stmt->bindValue('imagetype', $rant->imagetype);
	$stmt->bindValue('imagetext', trim($rant->imagetext));

	if ($stmt->execute())
	{
		//logthis( 'Saved changes to rant ' . $rant->id );
		$rant->id = $dbConnection->lastInsertId();

		adminlog("Rant " . $rant->id . " saved.", MTS_RANT, MTA_ADD);

		if ($rant->status == "published")
		{
			adminlog("Rant " . $rant->id . " published.", MTS_RANT, MTA_ADD);

			/*
			$poster = get_userdatabyid($rant->author);
			twitterpost("New rant posted by ".$poster->name.": ".SITE_HOST.SITE_PATH."/rant/".$rant->id);

			if($rant->author === 1) {
				tumblrpost($rant->title, $rant->body);
			}
			*/
		}

		return $rant->id;
	}

	return false;
}

function updaterant($rant)
{
	if ( !(int)$rant->id ) return false;
	global $dbConnection;

	# First, check if it's published already
	$sql = 'SELECT status FROM rant WHERE id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, $rant->id);

	$stmt->execute();
	$status = $stmt->fetchColumn();

	adminlog("Rant " . $rant->id . " updated.", MTS_RANT, MTA_UPDATE);

	$sql = 'UPDATE rant SET published = FROM_UNIXTIME(:published), status = :status, side = :side, author = :author, ' .
		'title = :title, body = :body, link = :link, imagetype = :imagetype, imagetext = :imagetext WHERE id = :id';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('id', (int)$rant->id);
	$stmt->bindValue('published', (int)$rant->published);
	$stmt->bindValue('status', $rant->status);
	$stmt->bindValue('side', $rant->side);
	$stmt->bindValue('author', (int)$rant->author);
	$stmt->bindValue('title', trim($rant->title));
	$stmt->bindValue('body', trim($rant->body));
	$stmt->bindValue('link', trim($rant->link));
	$stmt->bindValue('imagetype', (int)$rant->imagetype);
	$stmt->bindValue('imagetext', trim($rant->imagetext));

	if ($status == "draft" && $rant->status == "published")
	{
		adminlog("Rant " . $rant->id . " published.", MTS_RANT, MTA_UPDATE);

		/*
		$poster = get_userdatabyid($rant->author);
		twitterpost("New rant posted by ".$poster->name.": ".SITE_HOST.SITE_PATH."/rant/".$rant->id);

		if($rant->author === 1) {
			tumblrpost($rant->title, $rant->body);
		}
		*/
	}

	return $stmt->execute();
}

function deleterant($rantid)
{
	if ( !(int)$rantid ) return false;
	global $dbConnection;

	$sql = 'DELETE FROM rant WHERE id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, $rantid);

	adminlog("Rant " . $rantid . " deleted.", MTS_RANT, MTA_DELETE);
	return $stmt->execute();
}

function deleteattachment($id)
{
	global $dbConnection;

	// Remove attachment from filesystem
	$file = SITE_PATH_ABS . '/' . get_rantattachment_filename($id);
	unlink($file) or adminlog("Could not delete $file", MTS_RANT, MTA_DELETE, E_USER_WARNING);

	// Remove from database
	$sql = 'DELETE FROM rant_attachment WHERE id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, $id);

	$stmt->execute();
	adminlog("Deleted attachment $id", MTS_RANT, MTA_DELETE);
}

function getrant($id)
{
	global $dbConnection;

	$sql = 'SELECT id, UNIX_TIMESTAMP(published) as published, status, side, author, title, body, link, imagetype, imagetext FROM rant WHERE id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, (int)$id);

	$stmt->execute();
	return $stmt->fetch();
}

function get_rantimage_filename($rant)
{
	global $dbConnection;

	$sql = 'SELECT extension FROM media_t WHERE id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, (int)$rant->imagetype);

	$stmt->execute();
	$ext = $stmt->fetchColumn(); // filename extension

	return sprintf('%s/%04d.%s', SITE_RANT, (int)$rant->id, $ext);
}

function get_rantattachment_filename($id)
{
	global $dbConnection;

	$sql = 'SELECT extension FROM media_t JOIN rant_attachment ra ON ra.media = media_t.id WHERE ra.id = ?';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue(1, (int)$id);

	$stmt->execute();
	$ext = $stmt->fetchColumn(); // filename extension

	return sprintf('%s/%d.%s', SITE_RANT_ATTACHMENT, (int)$id, $ext );
}

?>