Can't seem to find any docs on this, so here goes:

The ubercool block system includes a feature to let you add custom blocks, and it has a PHP toggle for using custom PHP code.

I have a piece of standalone code that works anywhere on my site. However when I add these lines to the block, no results appear on the page. I see the header for my custom block, but no content. Am I missing some magic lube?

///////////////////
/* Grab most recent movie */
$DBhost = "localhost";
$DBuser = "**********";
$DBpass = "**********";

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");

$DBName = "videodb";
$table = "videodata";

@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "SELECT * FROM $table ORDER BY created DESC LIMIT 1";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

$i = 0;
while ($number > $i) {
$thetitle = mysql_result($result,$i,"title");
$thedir = mysql_result($result,$i,"director");
$theid = mysql_result($result,$i,"id");
$theimg = mysql_result($result,$i,"imgurl");

preg_match("/\.(jpe?g|gif|png)$/i", $theimg, $matches);
$newmd5 = md5($theimg);
$ext = $matches[0];
$thumb = "http://www.richmcninch.com/videodb/cache/img/$newmd5$ext";

print "

Title: $thetitle
Director:
$thedir

";
$i++;
}
?>
/////////////////

Thanks for any help you can offer.

my understanding is, you leave off the , and all the///////'s before and after them too I guess. Then it should work.

OMG YOU ROCK

Thanks man...So simple, I was overdoing it. Works great and a whole new level of functionality has just opened up to me. Thank you.

Are you using another database than the XOOPS one for this block?

If not, you can just skip the entire connectivity and just declare $xoopsDB global.

Ok after reading this post i got my includes to work. However I have a problem when I use this script.



It bassicly breaks the page and stops it from loading.

If you know what SAM2 Broadcaster is then that is what I am trying to integrate into xoops.

Oh and I noticed XOOPS is rather slow even on my extremely fast servers.