Seneste indlæg: [Andet] Ny Stationær - [16c]UdgaardsLoke (d. 27 April 2023) |
|
include 'dbconnect.php';
$id = $_GET['id'];
$angle = $_GET['rotate'];
$query="SELECT *, DATE_FORMAT(sentdate,'%W %d-%m-%Y kl. %H:%i') AS FormDate FROM mobilspo WHERE (id ='$id')";
$result=mysql_query($query);
$from=mysql_result($result,0,"from");
$filename=mysql_result($result,0,"filename");
if (strlen(substr($from, 0, strpos($from, '@'))) == 10) {
$checkfrom = substr(substr($from, 0, strpos($from, '@')), 2);
$querycheck="SELECT * FROM spobruger WHERE (mobile ='$checkfrom')";
$resultcheck=mysql_query($querycheck);
if (mysql_numrows($resultcheck) == 1) {
$brugerid=mysql_result($resultcheck,0,"brugerID");
if ($kageadminid == $brugerid) {
$query = "UPDATE mobilspo SET angle = '$angle', `date` = `date` WHERE (id ='$id')";
mysql_query($query) or die('Error, query failed');
// Vend!!
$fileName = 'emailattachments/'.$filename;
$fileout = 'emailattachments/rotated_'.$filename;
// if the resulting image is not rectangular..
// .. what colour will the uncovered bits be?
$bgColour = 0xFFFFFF; // red
// load the original image from the file
$original = imagecreatefromjpeg($fileName);
// rotate the image by $angle degrees
$rotated = imagerotate($original, $angle, $bgColour);
// print the appropriate header type
// this tells the browser we're displaying a jpeg image
//header('Content-type: image/jpeg');
// use the imagejpeg() method to display the rotated image
imagejpeg($rotated, $fileout, "90");
$output = 'Vi har nu drejet billedet! Hold godt fast!';
$output = $output.'
';
$output = $output.'
![](image.php?image=rotated_'.$filename.'&height=350&width=350)
';
} else {
$output = 'Du har ikke rettigheder til at vende dette billede!';
}
}
} else {
$findemail = substr($from, (strpos($from, '<') + 1));
$findemail = substr($findemail, 0, strpos($findemail, '>'));
$querycheck="SELECT * FROM spobruger WHERE (email ='$findemail')";
$resultcheck=mysql_query($querycheck);
if (mysql_numrows($resultcheck) == 1) {
$brugerid=mysql_result($resultcheck,0,"brugerID");
if ($kageadminid == $brugerid) {
$query = "UPDATE mobilspo SET angle = '$angle', `date` = `date` WHERE (id ='$id')";
mysql_query($query) or die('Error, query failed');
// Vend!!
$fileName = 'emailattachments/'.$filename;
$fileout = 'emailattachments/rotated_'.$filename;
// if the resulting image is not rectangular..
// .. what colour will the uncovered bits be?
$bgColour = 0xFFFFFF; // red
// load the original image from the file
$original = imagecreatefromjpeg($fileName);
// rotate the image by $angle degrees
$rotated = imagerotate($original, $angle, $bgColour);
// print the appropriate header type
// this tells the browser we're displaying a jpeg image
//header('Content-type: image/jpeg');
// use the imagejpeg() method to display the rotated image
imagejpeg($rotated, $fileout, "90");
$output = 'Vi har nu drejet billedet! Hold godt fast!';
$output = $output.'
';
$output = $output.'
![](image.php?image=rotated_'.$filename.'&height=350&width=350)
';
} else {
$output = 'Du har ikke rettigheder til at vende dette billede!';
}
}
}
mysql_close();
?>
Vend billede
echo $output; ?>
include 'bund.php'; ?>