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'"); } }