[Twilkey]

Here is the problem. I have asked many people and noone can figure out the problem.

I am storing embed code in a database table. I have a variable that is put in the src part and some variables in the width and height. Now this was working when I had the embed code just in the php file, but once I started storing the code in a database table and trying to pull the code from the table, it stopped working.

Here is what one embed code looks like when it goes into the database.

<OBJECT ID="MediaPlayer" width=600 height=500
classid="CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95"

codebase="http://activex.microsoft.com/activex/
    controls/mplayer/en/nsmp2inf.cab#Version=6,0,02,902"

standby="Loading Microsoft Windows Media Player components..."

type="application/x-oleobject">

<PARAM NAME="FileName"
VALUE="http://location.to.media/file.wmv">

<PARAM NAME="animationatStart" VALUE="true">

<PARAM NAME="transparentatStart" VALUE="true">

<PARAM NAME="autoStart" VALUE="true">

<PARAM NAME="showControls" VALUE="true">

<EMBED type="application/x-mplayer2"

pluginspage = "http://www.microsoft.com/Windows/MediaPlayer/"

SRC="$movielink"

name="MediaPlayer"

width="$playerwidth";

height="... {$vbulletin->options['player_height']} ...";

AutoStart=true>

</EMBED>

</OBJECT>

Now the problem is that the variables arnt replaced with what they are supposed to when the embed code is pulled from the database.

Here is the code I use to display the embed code.

if ($_REQUEST['do'] == 'showmovie')
{
    $movieid = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
    $movie_query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "psmedia_movie WHERE movieid=$movieid");
    $movie = $vbulletin->db->fetch_array($movie_query);
    
    $formatid = htmlspecialchars_uni($movie['formatid']);
    $format_query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "psmedia_format WHERE id=$formatid");
    $format = $vbulletin->db->fetch_array($format_query);
    
    $formattitle = htmlspecialchars_uni($format['title']);
    $movietitle = htmlspecialchars_uni($movie['title']);
    $moviedescription = htmlspecialchars_uni($movie['description']);
    $movieotherinfo = htmlspecialchars_uni($movie['otherinfo']);
    $movieauthor = htmlspecialchars_uni($movie['author']);
    if ($movieauthor == '') {$movieauthor = "Unknown";}
    $moviestream = $format['code'];
    $movielink = htmlspecialchars_uni($movie['link']);
    
    ($hook = vBulletinHook::fetch_hook('psmedia_showmovie')) ? eval($hook) : false; 
    
    eval('$psmedia_showmovie_rightbar = "' . fetch_template('psmedia_showmovie_rightbar') . '";');
    eval('$psmedia_content = "' . fetch_template('psmedia_showmovie') . '";');
}