break;
case 'txt':
$final['filename'] = '';
$final['imageurl'] = '';
$final['alt'] = '';
$final['width'] = 0;
$final['height'] = 0;
$final['bannertext'] = phpAds_htmlQuotes($bannertext);
$final['url'] = $url;
$final['target'] = $target;
$final['status'] = $status;
$final['contenttype'] = 'txt';
$final['storagetype'] = $storagetype;
if (!isset($bannerid) || $bannerid == '0' || $bannerid == '') {
// New banner set html template
$final['htmltemplate'] = phpAds_getBannerTemplate($final['contenttype']);
} else {
// Use existing html template
$final['htmltemplate'] = stripslashes($current['htmltemplate']);
}
// Update bannercache
$final['htmlcache'] = addslashes(phpAds_getBannerCache($final));
$final['htmltemplate'] = addslashes($final['htmltemplate']);
break;
case 'network':
$final['filename'] = '';
$final['imageurl'] = '';
$final['alt'] = '';
$final['bannertext'] = '';
$final['url'] = '';
$final['target'] = '';
function phpAds_upgradeSplitBanners()
{
global $phpAds_config;
// Check if splitting is needed
if (!isset($phpAds_config['config_version']) || $phpAds_config['config_version'] < 200.07) {
$banners = array();
// Fetch all banners
$res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_banners']);
while ($row = phpAds_dbFetchArray($res)) {
$banners[] = $row;
}
for ($i = 0; $i < count($banners); $i++) {
// Requote fields
$banners[$i]['alt'] = phpAds_htmlQuotes(stripslashes($banners[$i]['alt']));
$banners[$i]['bannertext'] = phpAds_htmlQuotes(stripslashes($banners[$i]['bannertext']));
// Resplit keywords
if (isset($banners[$i]['keyword']) && $banners[$i]['keyword'] != '') {
$keywordArray = split('[ ,]+', trim($banners[$i]['keyword']));
$banners[$i]['keyword'] = implode(' ', $keywordArray);
}
// Determine storagetype
switch ($banners[$i]['format']) {
case 'url':
$banners[$i]['storagetype'] = 'url';
break;
case 'html':
$banners[$i]['storagetype'] = 'html';
break;
case 'web':
$banners[$i]['storagetype'] = 'web';
break;
default:
$banners[$i]['storagetype'] = 'sql';
break;
}
switch ($banners[$i]['storagetype']) {
case 'sql':
// Determine contenttype
$banners[$i]['contenttype'] = $banners[$i]['format'];
// Store the file
$banners[$i]['filename'] = 'banner_' . $banners[$i]['bannerid'] . '.' . $banners[$i]['contenttype'];
$banners[$i]['filename'] = phpAds_ImageStore($banners[$i]['storagetype'], $banners[$i]['filename'], $banners[$i]['banner']);
$banners[$i]['imageurl'] = $phpAds_config['url_prefix'] . '/adimage.php?filename=' . $banners[$i]['filename'] . "&contenttype=" . $banners[$i]['contenttype'];
$banners[$i]['htmltemplate'] = phpAds_getBannerTemplate($banners[$i]['contenttype']);
$banners[$i]['htmlcache'] = addslashes(phpAds_getBannerCache($banners[$i]));
$banners[$i]['htmltemplate'] = addslashes($banners[$i]['htmltemplate']);
$banners[$i]['banner'] = '';
break;
case 'web':
// Get the contenttype
$ext = substr($banners[$i]['banner'], strrpos($banners[$i]['banner'], ".") + 1);
switch (strtolower($ext)) {
case 'jpeg':
$banners[$i]['contenttype'] = 'jpeg';
break;
case 'jpg':
$banners[$i]['contenttype'] = 'jpeg';
break;
case 'html':
$banners[$i]['contenttype'] = 'html';
break;
case 'png':
$banners[$i]['contenttype'] = 'png';
break;
case 'gif':
$banners[$i]['contenttype'] = 'gif';
break;
case 'swf':
$banners[$i]['contenttype'] = 'swf';
break;
}
// Store the file
$banners[$i]['filename'] = basename($banners[$i]['banner']);
$banners[$i]['imageurl'] = $banners[$i]['banner'];
$banners[$i]['htmltemplate'] = phpAds_getBannerTemplate($banners[$i]['contenttype']);
$banners[$i]['htmlcache'] = addslashes(phpAds_getBannerCache($banners[$i]));
$banners[$i]['htmltemplate'] = addslashes($banners[$i]['htmltemplate']);
$banners[$i]['banner'] = '';
break;
case 'url':
// Get the contenttype
$ext = parse_url($banners[$i]['banner']);
$ext = $ext['path'];
$ext = substr($ext, strrpos($ext, ".") + 1);
switch (strtolower($ext)) {
case 'jpeg':
$banners[$i]['contenttype'] = 'jpeg';
break;
case 'jpg':
$banners[$i]['contenttype'] = 'jpeg';
break;
case 'html':
$banners[$i]['contenttype'] = 'html';
break;
case 'png':
$banners[$i]['contenttype'] = 'png';
break;
case 'gif':
$banners[$i]['contenttype'] = 'gif';
break;
case 'swf':
$banners[$i]['contenttype'] = 'swf';
break;
}
$banners[$i]['imageurl'] = $banners[$i]['banner'];
$banners[$i]['htmltemplate'] = phpAds_getBannerTemplate($banners[$i]['contenttype']);
$banners[$i]['htmlcache'] = addslashes(phpAds_getBannerCache($banners[$i]));
$banners[$i]['htmltemplate'] = addslashes($banners[$i]['htmltemplate']);
$banners[$i]['filename'] = '';
$banners[$i]['banner'] = '';
break;
case 'html':
// Get the contenttype
$banners[$i]['contenttype'] = 'html';
$banners[$i]['htmltemplate'] = stripslashes($banners[$i]['banner']);
$banners[$i]['htmlcache'] = addslashes(phpAds_getBannerCache($banners[$i]));
$banners[$i]['htmltemplate'] = addslashes($banners[$i]['htmltemplate']);
$banners[$i]['imageurl'] = '';
$banners[$i]['filename'] = '';
$banners[$i]['banner'] = '';
break;
}
// Update the banner
$res = phpAds_dbQuery("\n\t\t\t\tUPDATE\n\t\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\tSET\n\t\t\t\t\tstoragetype = '" . $banners[$i]['storagetype'] . "',\n\t\t\t\t\tcontenttype = '" . $banners[$i]['contenttype'] . "',\n\t\t\t\t\tfilename = '" . $banners[$i]['filename'] . "',\n\t\t\t\t\timageurl = '" . $banners[$i]['imageurl'] . "',\n\t\t\t\t\tbanner = '" . $banners[$i]['banner'] . "',\n\t\t\t\t\thtmltemplate = '" . $banners[$i]['htmltemplate'] . "',\n\t\t\t\t\thtmlcache = '" . $banners[$i]['htmlcache'] . "',\n\t\t\t\t\talt = '" . $banners[$i]['alt'] . "',\n\t\t\t\t\tstatus = '" . $banners[$i]['status'] . "',\n\t\t\t\t\tbannertext = '" . $banners[$i]['bannertext'] . "',\n\t\t\t\t\tkeyword = '" . $banners[$i]['keyword'] . "'\n\t\t\t\tWHERE\n\t\t\t\t\tbannerid = " . $banners[$i]['bannerid'] . "\n\t\t\t");
}
// Delete unneeded columns
$res = phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_banners'] . " DROP COLUMN banner");
$res = phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_banners'] . " DROP COLUMN format");
}
}
$compress = true;
} else {
// Compress the converted file
if (isset($compress)) {
$compress = true;
} else {
$compress = false;
}
}
if (!isset($convert_links)) {
$convert_links = array();
}
list($result, $parameters) = phpAds_SWFConvert($swf_file, $compress, $convert_links);
if ($result != $swf_file) {
// Reload template to be sure it can be updated
$row['htmltemplate'] = phpAds_getBannerTemplate('swf');
if (count($parameters) > 0) {
// Set default link
$row['url'] = $overwrite_link[$chosen_link];
$row['target'] = $overwrite_target[$chosen_link];
// Prepare the parameters
$parameters_complete = array();
while (list($key, $val) = each($parameters)) {
if (isset($overwrite_source) && $overwrite_source[$val] != '') {
$overwrite_link[$val] .= '|source:' . $overwrite_source[$val];
}
$parameters_complete[] = 'alink' . $key . '={targeturl:' . $overwrite_link[$val] . '}&atar' . $key . '=' . $overwrite_target[$val];
}
$parameter = implode('&', $parameters_complete);
$row['htmltemplate'] = str_replace('{swf_param}', $parameter, $row['htmltemplate']);
}
function phpAds_upgradeTransparentSWF()
{
global $phpAds_config;
if (!isset($phpAds_config['config_version']) || $phpAds_config['config_version'] < 200.248) {
// Update custom SWF templates which have wmode=transparent
phpAds_dbQuery("UPDATE " . $phpAds_config['tbl_banners'] . " SET transparent = 't' WHERE contenttype = 'swf' AND htmltemplate LIKE '%wmode%'");
// Update HTML tenplate for SWF banners
phpAds_dbQuery("UPDATE " . $phpAds_config['tbl_banners'] . " SET htmltemplate = '" . addslashes(phpAds_getBannerTemplate('swf')) . "' WHERE contenttype = 'swf'");
}
}
