|
|
<?php
|
|
|
|
|
|
class Rant {
|
|
|
var $id, $published, $status, $side, $author, $title, $body, $link, $imagetype, $imagetext;
|
|
|
}
|
|
|
|
|
|
function saverant($rant) {
|
|
|
if($rant->id)
|
|
|
return updaterant($rant);
|
|
|
else
|
|
|
return insertrant($rant);
|
|
|
}
|
|
|
|
|
|
function insertrant($rant) {
|
|
|
global $mtdb;
|
|
|
$sql = 'INSERT INTO rant ( published, status, side, author, title, body, link, imagetype, imagetext ) VALUES ( FROM_UNIXTIME('
|
|
|
. (int)$rant->published
|
|
|
. '), "' . mysqli_real_escape_string($mtdb->link, $rant->status)
|
|
|
. '", "' . mysqli_real_escape_string($mtdb->link, $rant->side)
|
|
|
. '", "' . (int)$rant->author
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $rant->title) )
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $rant->body ) )
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $rant->link ) )
|
|
|
. '", ' . mysqli_real_escape_string($mtdb->link, $rant->imagetype)
|
|
|
. ', "' . mysqli_real_escape_string( $mtdb->link, trim( $rant->imagetext ) )
|
|
|
. '")';
|
|
|
|
|
|
if( $mtdb->query( $sql ) ) {
|
|
|
//logthis( 'Saved changes to rant ' . $rant->id );
|
|
|
$rant->id = mysqli_insert_id( $mtdb->link );
|
|
|
|
|
|
adminlog("Rant ".$rant->id." saved.", MTS_RANT, MTA_ADD);
|
|
|
|
|
|
if($rant->status == "published")
|
|
|
{
|
|
|
$poster = get_userdatabyid($rant->author);
|
|
|
adminlog("Rant ".$rant->id." published.", MTS_RANT, MTA_ADD);
|
|
|
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 $mtdb;
|
|
|
|
|
|
#first, check if it's published already
|
|
|
$qr = $mtdb->query("SELECT status FROM rant WHERE id = ".$rant->id);
|
|
|
$row = mysqli_fetch_row($qr);
|
|
|
$status = $row[0];
|
|
|
|
|
|
adminlog("Rant ".$rant->id." updated.", MTS_RANT, MTA_UPDATE);
|
|
|
|
|
|
$sql = 'UPDATE rant SET published=FROM_UNIXTIME(' . (int)$rant->published
|
|
|
. '), status = "' . mysqli_real_escape_string($mtdb->link, $rant->status)
|
|
|
. '", side = "' . mysqli_real_escape_string($mtdb->link, $rant->side)
|
|
|
. '", author = ' . (int)$rant->author
|
|
|
. ', title = "' . mysqli_real_escape_string( $mtdb->link, trim($rant->title) )
|
|
|
. '", body = "' . mysqli_real_escape_string( $mtdb->link, trim($rant->body ) )
|
|
|
. '", link = "' . mysqli_real_escape_string( $mtdb->link, trim($rant->link ) )
|
|
|
. '", imagetype = ' . (int)$rant->imagetype
|
|
|
. ', imagetext = "' . mysqli_real_escape_string( $mtdb->link, trim($rant->imagetext) )
|
|
|
. '" WHERE id=' . (int)$rant->id;
|
|
|
|
|
|
if($status == "draft" && $rant->status == "published")
|
|
|
{
|
|
|
$poster = get_userdatabyid($rant->author);
|
|
|
adminlog("Rant ".$rant->id." published.", MTS_RANT, MTA_UPDATE);
|
|
|
twitterpost("New rant posted by ".$poster->name.": ".SITE_HOST.SITE_PATH."/rant/".$rant->id);
|
|
|
|
|
|
if($rant->author === 1) {
|
|
|
tumblrpost($rant->title, $rant->body);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return $mtdb->query( $sql );
|
|
|
}
|
|
|
|
|
|
function deleterant($rantid) {
|
|
|
if ( !(int)$rantid ) return false;
|
|
|
global $mtdb;
|
|
|
adminlog("Rant ".$rantid." deleted.", MTS_RANT, MTA_DELETE);
|
|
|
return $mtdb->query( 'DELETE FROM rant WHERE id=' . $rantid );
|
|
|
}
|
|
|
|
|
|
function deleteattachment($id)
|
|
|
{
|
|
|
global $mtdb;
|
|
|
$file = SITE_PATH_ABS.'/'.get_rantattachment_filename($id);
|
|
|
unlink( $file ) or adminlog("Could not delete $file", MTS_RANT, MTA_DELETE, E_USER_WARNING);
|
|
|
$mtdb->query( 'DELETE FROM rant_attachment WHERE id = ' . $id );
|
|
|
adminlog("Deleted attachment $id", MTS_RANT, MTA_DELETE);
|
|
|
}
|
|
|
|
|
|
function getrant($id) {
|
|
|
global $mtdb;
|
|
|
return $mtdb->getRow( 'SELECT id, UNIX_TIMESTAMP(published) as published, status, side, author, title, body, link, imagetype, imagetext FROM rant WHERE id = '. (int)$id );
|
|
|
}
|
|
|
|
|
|
function get_rantimage_filename( $rant ) {
|
|
|
global $mtdb;
|
|
|
$ext = $mtdb->getOne( 'SELECT extension FROM media_t WHERE id=' . (int)$rant->imagetype ); // filename extension
|
|
|
return sprintf( '%s/%04d.%s',SITE_RANT, (int)$rant->id, $ext );
|
|
|
}
|
|
|
|
|
|
function get_rantattachment_filename( $id ) {
|
|
|
global $mtdb;
|
|
|
$ext = $mtdb->getOne( 'SELECT extension FROM media_t JOIN rant_attachment ra ON ra.media = media_t.id WHERE ra.id=' . (int)$id ); // filename extension
|
|
|
return sprintf( '%s/%d.%s',SITE_RANT_ATTACHMENT, (int)$id, $ext );
|
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
