Quellcode

 CREATE TABLE `yourdatabse`.`panoramas` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL ,
`pano` VARCHAR( 255 ) NOT NULL ,
`visits` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM 

Quellcode

<?php

//a function to connect to MySQL its a bit old, but works :)
function connect($SQL) {

$dbhost = 'localhost';
$dbname = 'yourdatabse';
$dbuser = 'youruser';
$dbpasswd = 'yourpassword';

// we select a the database and connect to it
$conex = mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("no se pudo conectar???");
mysql_select_db($dbname, $conex);

// this wil execute the query
  $resultado = mysql_query($SQL,$conex);
if (!mysql_errno()){
 return $resultado;
 } else {
echo "MySQL error ".mysql_errno().": ".mysql_error()."\n<br>When executing:<br>\n".$SQL."\n<br>";
die();
 }
 }

// I got this from the internet, sorry I don't remember where, but I modified to fit Krpano needs

function LoadJpeg($imgname)
{
    /* Attempt to open */
    $im = @imagecreatefromjpeg($imgname);
    
    /* See if it failed */
    if(!$im)
    {
        /* Create a black image */
        $im  = imagecreatetruecolor(150, 30);
        $bgc = imagecolorallocate($im, 255, 255, 255);
        $tc  = imagecolorallocate($im, 0, 0, 0);
        imagefilledrectangle($im, 0, 0, 150, 30, $bgc);

        /* Output an error message */
        imagestring($im, 1, 5, 5, 'Error loading panorama', $tc);
    }

    return $im;
} 
 
$sql = "SELECT * FROM panoramas where id = ".$_GET['id'];
$result = connect($sql);


 
header('Content-Type: image/jpeg');
$row = mysql_fetch_array($result);

//update the visits
$sql = "update panoramas set visits=visits+1 where id = ".$row['id'];
connect($sql);

$img = LoadJpeg($row['pano']);

imagejpeg($img);
imagedestroy($img);
?>

Quellcode

<action name="loadpano1">
loadpano(null,sphere=panoload.php?id=1,KEEPALL,BLEND(2));
</action>