Failed to get sponsor banner information - phpnuke 7.5

Newbie Joined: Mar 16, 2007 Posts: 1

Friend if I click in create newletter I have this information :

Failed to get sponsor banner information

Do you can help me - I not need to show banners in newsletter ...
what file I need to edit for not show more this information and create a newsl. ?

Thanks

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 308

Which newsleter template are you using?
The banner data is held in the tag

Code:

{BANNER}

which you can find in the template.php file of the newsletter template you are using.

When you are configuring the newletter there should also be the option to NOT use a sponsor banner.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

Sounds like you may have a different banner system installed than what comes with PHP-Nuke.

Open file modules/HTML_Newsletter/admin/admin_make_nls.php and comment out this section of code:

Code:

/************************************************************************
* Build the Banner Link - to replace {BANNER} tag
************************************************************************/

if ( $_POST['msnl_banner'] != "" && $msnl_sTemplateNm != "notemplate" ) {

$sql = "SELECT `imageurl`, `clickurl`, `alttext` FROM `"
         . $prefix."_banner` WHERE `bid` = '". $_POST['msnl_banner'] ."'";

$result16 = msnl_fSQLCall( $sql );

if ( !$result16 ) { //Bad SQL call

   msnl_fRaiseAppError( _MSNL_ADM_MAKE_ERR_DBGETBANNER );

} else { //Successful SQL call

   $row = $db->sql_fetchrow( $result16 );

   $msnl_sImageURL    = stripslashes( $row['imageurl'] );
   $msnl_sClickURL    = stripslashes( $row['clickurl'] );
   $msnl_sAltText    = stripslashes( $row['alttext'] );

   $msnl_sBanner = "<a href=\"$msnl_sClickURL\" title=\"\">"
                        . "<img src=\"$msnl_sImageURL\" alt=\"$msnl_sAltText\">"
                        . "</a>\n";

} //End IF DB call successful

} else {

$msnl_sBanner = "";

} //End IF Banner link