tom83

Hello stephan, I think you mean the first version I mentioned in the the thread, right? <div id="revive-responsive-top" style="display: block; text-align: center;"> <script type="text/javascript"> adUnit = document.getElementById("revive-responsive-top"); adWidth = adUnit.offsetWidth; if ( adWidth >= 800 ) { /* Billboard 800x250 */ adUnit.innerHTML = '<ins data-revive-zoneid="18" data-revive-target="_blank" data-revive-id="xxx"></ins>'; } else { /* Mobile Banner 320x50 */ adUnit.innerHTML = '<ins data-revive-zoneid="10" data-revive-target="_blank" data-revive-id="xxx"></"></ins>'; } </script> <script async src="//www.example.de/adserver/www/delivery/asyncjs.php"></script> </div> Can you explain where and what I have to do in the CSS in order to acomplish the show/hide? Do I also have to integrate more script into Revive than the one above? That would be of great help and I believe, not only for me. Thanks in advance. Best Tom

Hi stephan, thanks for your reply. It does not work and I have already applied the changes of the link to my script. It is somehow sad, because there is nowhere in the web a detailed instruction how to integrate the display of zones according to the size of the screen and how to make them work. I also tried a second alternative as follows, but here both zones/ads are just displayed next to each other: <div class="desktop_alternative"> <br> <ins data-revive-zoneid="1" data-revive-target="_blank" data-revive-id=""></ins> <script async src="//xxx/www/delivery/asyncjs.php"></script> </div> <div class="mobile_alternative"> <br> <ins data-revive-zoneid="2" data-revive-id=""></ins> <script async src="//xxx/www/delivery/asyncjs.php"></script> </div> Please help!!! I do not want to have large banners in my mobile screen anymore. Best Tom

Hi, i also wanted to place ads into my website depending on the available screen (mobile or desktop). Therefore I have created two zones (one with 320x50 and the other with 800x250). In my HTML I put the following code: <div id="revive-responsive-top" style="display: block; text-align: center;"> <script type="text/javascript"> adUnit = document.getElementById("revive-responsive-top"); adWidth = adUnit.offsetWidth; if ( adWidth >= 800 ) { /* Billboard 800x250 */ adUnit.innerHTML = '<ins data-revive-zoneid="18" data-revive-target="_blank" data-revive-id="xxx"></ins>'; } else { /* Mobile Banner 320x50 */ adUnit.innerHTML = '<ins data-revive-zoneid="10" data-revive-target="_blank" data-revive-id="xxx"></"></ins>'; } </script> <script async src="//www.example.de/adserver/www/delivery/asyncjs.php"></script> </div> After that I have the following result: Only the 320x50 ad is shown, even if there is a desktop > 800. What do I have to do in order that there is a selection between 320x50 and 800x250? Do I have to do further changes in the Revive Script and if so, please can you instruct what and where I have to modify something. Thanks in advance. Best Tom

...can you tell me how can I do that? Tom

Hi, I have one question concerning Revive maintenance, because it is mentioned that "regular maintenance" should be better than "automatic maintenance". Therefore I disabled the automatic maitenance via Configuration > Global Settings > Maintenance Settings. Instead of this I created each single hour one Cron Job via my server through http://www.example.com/revive_adsever/maintenance/maintenance.php I have now the following question on this: a) Is the set-up of the "regular mainteance" correct? b) Can I run both, enable "automatic maitenance" and also run the "regular maintenance" as mentioned above (or do I create a hick-up)? c) Is it still required to integrate <img scr='http://www.example.com/revive_adsever/maintenance/maintenance.php' width='0' height='0'> into the sourcecode of the website where the banners are displayed, because I can remember that this was required for OpenX in the past? Thanks in advance for your reply. Best regards Tom

Hi, thanks for the information. I also tried to find a logic. The issue is that banner-delete.php does not find the db file ox_ext_market_stats where it wants to delete the respective banner from. This means the banner information has to be in a different db file. Therefore my question would be in which db file the banners are stored regularly? My current banner-delete.php file looks like that: <?php /* +---------------------------------------------------------------------------+ | Revive Adserver | | http://www.revive-adserver.com | | | | Copyright: See the COPYRIGHT.txt file. | | License: GPLv2 or later, see the LICENSE.txt file. | +---------------------------------------------------------------------------+ */ // Require the initialisation file require_once '../../init.php'; // Required files require_once MAX_PATH . '/lib/OA/Dal.php'; require_once MAX_PATH . '/xxx/admin/config.php'; require_once MAX_PATH . '/xxx/admin/lib-storage.inc.php'; require_once MAX_PATH . '/xxx/admin/lib-zones.inc.php'; require_once MAX_PATH . '/xxx/admin/lib-statistics.inc.php'; require_once MAX_PATH . '/lib/OA/Maintenance/Priority.php'; // Register input variables phpAds_registerGlobal ('returnurl'); // Security check OA_Permission::enforceAccount(OA_ACCOUNT_MANAGER); OA_Permission::enforceAccessToObject('clients', $clientid); OA_Permission::enforceAccessToObject('campaigns', $campaignid); // CVE-2013-5954 - see OA_Permission::checkSessionToken() method for details OA_Permission::checkSessionToken(); /*-------------------------------------------------------*/ /* Main code */ /*-------------------------------------------------------*/ if (!empty($bannerid)) { $ids = explode(',', $bannerid); while (list(,$bannerid) = each($ids)) { $doBanners = OA_Dal::factoryDO('banners'); $doBanners->bannerid = $bannerid; if ($doBanners->get($bannerid)) { $aBanner = $doBanners->toArray(); } $doBanners->delete(); } // Queue confirmation message $translation = new OX_Translation (); if (count($ids) == 1) { $translated_message = $translation->translate ($GLOBALS['strBannerHasBeenDeleted'], array( htmlspecialchars($aBanner['description']) )); } else { $translated_message = $translation->translate ($GLOBALS['strBannersHaveBeenDeleted']); } OA_Admin_UI::queueMessage($translated_message, 'local', 'confirm', 0);} // Run the Maintenance Priority Engine process OA_Maintenance_Priority::scheduleRun(); // Rebuild cache // include_once MAX_PATH . '/lib/max/deliverycache/cache-'.$conf['delivery']['cache'].'.inc.php'; // phpAds_cacheDelete(); if (empty($returnurl)) { $returnurl = 'campaign-banners.php'; } header("Location: ".$returnurl."?clientid=".$clientid."&campaignid=".$campaignid); ?> Maybe we can bring this subject foward now by finding the logic between the php file and the correct db file. Thank you. Tom

Hi, I am not comfortable enough with this tool, but I checked the logic once again. In /revive/xxx/admin/banner-delete.php the script tries to delete something out of db11111.ox_ext_market_stats, but in my database there is this table missing, but a table ox_ext_market_web_stats is existing. I would imagine that there is a issue when updating openx to revive and having this Market Plugin installed. Is there somebody in the community who has an idea to fix that, because I believe this is a general openx/revive issue when upgrading. Furthermore there is still the following in the config.php: [oxMarket] marketHost="https://pc.openx.com" marketPcApiHost="https://api.pc.openx.com" fallbackPcApiHost="http://api.pc.openx.com" marketXmlRpcUrl="api/xml-rpc" marketPublicApiUrl="api/public/v1" marketCustomContentUrl="market/content" marketMenuUrl="market/index/menu" defaultFloorPrice="0.10" marketAccountIdParamName=pa marketWelcomeUrl="market/index/welcome" marketCaptchaUrl="https://pc.openx.com/api/captcha" marketTermsUrl="http://www.openx.org/market/terms" marketPrivacyUrl="http://www.openx.org/privacy" openXTermsUrl="http://www.openx.org/terms" publisherSupportEmail="[email protected]" openXPrivacyUrl="http://www.openx.org/privacy" splashAlreadyShown=1 dictionaryCacheLifeTime=86400 [oxMarketDelivery] brokerHost="bid.openx.net" Can I delete this as well? Maybe there is a routine to systematically remove all former openx Market Plugin leftovers? I believe this is important for all Revive users. Thanks in advance. Tom

Hi andrewatfornax, I have deleted oxMarket successfully without any further issues, but when I am trying to delete a banner the following error message comes again: Due to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible. Version: Revive Adserver v4.0.0 PHP/DB: PHP 5.6.25 / MySQL 5.6.35-1~dotdeb+7.1 Page: /revive/xxx/admin/banner-delete.php Error: Table 'db11111.ox_ext_market_stats' doesn't exist Query: SELECT * FROM ox_ext_market_stats WHERE ( ox_ext_market_stats.ad_id = 100 ) $_POST: Empty $_GET: Array ( [clientid] => 100 [campaignid] => 30 [token] => ccccccccccccccccccccccc [bannerid] => 40 ) Any further ideas (e.g. chache, config)? Thanks Tom

Hi andrewatfornax, do you mean that I should just delete the oxMarket folder in the plugins folder in order to fix it? Is there a chance to delete it via the backend of Revive as well in order to ensure consistency? Thanks Tom

Hi andrewatfornax, I checked both. There is just a oxMarket folder under admin/plugins, but nothing directly under plugins. The dedicated config section looks as follows: [plugins] openXBannerTypes=1 openXDeliveryLimitations=1 openX3rdPartyServers=1 openXReports=1 openXDeliveryCacheStore=1 openXMaxMindGeoIP=1 openXInvocationTags=1 openXDeliveryLog=1 openXMarket=0 openXVideoAds=0 Any further ideas? Tom

Hi andrewatfornax, thanks for the answer. You are right, I derived to Revive by an upgrade from OpenX. During the upgrade I also had to manually upgrade the plugins again, but which worked successfully. Concerning your question I have only the core plugins installed (as mentioned in your link). What can I do now in order to fix this issue? Thanks in advance for your support. Tom

...like this?: UPDATE ox_audit set details= " where details like "Check details filed in this table and placed the most occurring text in that field ,mostly frames"; Thanks Tom

Dear Revive Developer Team, no reply on this? Maybe I have posted it in the wrong category. I believe this is really a S/W bug, at least it was indicated like this by Revive itself (see above). How can this be solved or mitigated. Thanks Tom

Dear all, I tried to delete a banner in the backend of Revive 4.0.0 and I received the following error message: Due to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible. Version: Revive Adserver v4.0.0 PHP/DB: PHP 5.6.25 / MySQL 5.6.35-1~dot+7.1 Page: /revive/xxx/www/admin/banner-delete.php Error: Table 'db11111.ox_ext_market_stats' doesn't exist Query: SELECT * FROM ox_ext_market_stats WHERE ( ox_ext_market_stats.ad_id = 100 ) $_POST: Empty $_GET: Array ( [clientid] => 100 [campaignid] => 30 [token] => ccccccccccccccccccccccccccccc [bannerid] => 40 Is this a bug in Revive as indicated above, or what can be done in order to successfully perform the deletion process of banners? Thanks. Tom

I was just asking how the above mentioned source-code would look like in normal ASCII double quotes? Tom