[JS - Dynamic display of a zone in the page.]

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

[JS - Dynamic display of a zone in the page.]

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

 

[JS - Dynamic display of a zone in the page.]

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

[Error Message when trying to delete banner]

On 28.6.2017 at 7:54 AM, andrewatfornax said:

If I search my code base of Revive Adserver, there are no hits at all for the string "ext_market_stats".

If you grep your code base for the string "ext_market_stats", do you have any files that show up with this text in them?

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

Tom

[Regular Maintenance vs. Automatic Maintenance]

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

 

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Kaspersky Issue at Revive Backend]

...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

[Error Message when trying to delete banner]

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

[Error Message when trying to delete banner]

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

[Kaspersky Issue at Revive Backend]

On 5.5.2017 at 3:06 AM, andrewatfornax said:

Looks like the copy & paste has just turned the double quotes into non-ASCII double quotes. Try changing them to normal ASCII double quotes?

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

Tom

[Kaspersky Issue at Revive Backend]

..and how would this look like?

I have the description from: http://www.adserveropenx.com/how-to-remove-malware-or-injection-from-openx/

Thanks.

Tom

[Kaspersky Issue at Revive Backend]

Dear all,

I would like to come back to this issue.

Is there anybody else using Revive 4.0.0 with Kaspersky who ist getting this alert?

Once again, the Kaspersky alert is always the following:

- Object Name: HEUR.Trojan.Script.Generic

- Object: http://www.example.com/favicon.ico

It only occurs in the Administration-Backend when opening a preview of any banner in any zone.

Maybe this is also related to a script within the Revive source code, which is interpreted by the virus protection wrongly?

Thanks for your feedback.

Tom

[Kaspersky Issue at Revive Backend]

Hi andrew,

first of all I did something wrong yesterday and Step 4 of the manual was not working:

Step – 4:

Some times  malware was attacked in “details” in “ox_audit” tables in your Data Base .You can remove this one by this MySQL query.

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%”;

I am receiving the following error message:

SQL Error (1064): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near '%Check details filed in this
table and placed the most occurring text in that fi' at line 1 */

Secondly the Kaspersky alert shows up in all zones and banners when I try to open the preview banner in the backend and is always linked to favicon.ico.

Thanks again for your support.

Tom

[Kaspersky Issue at Revive Backend]

Hi andrew,

thanks for the reply.

Proposed Option 2 seems a little bit to heavy at this point of time, because prior to the update to Revive I was regularly in the backend of my old openx version and I never received such a Kaspersky alarm by showing a banner in the backend. There is also no Kaspersky warning when I run the ads on the frontend.

I also checked carfully all options under http://www.adserveropenx.com/how-to-remove-malware-or-injection-from-openx/ and found nothing. Only

Step – 5:

Some times hacker was created fake Administrator user via  backdoor in our files.You should check this one ,if you found any fake user you should remove from your database.Check this one by below mentioned Query.

SELECT u.user_id, u.contact_name, u.email_address, u.username FROM ox_users AS u, ox_account_user_assoc AS aua WHERE u.user_id=aua.user_id AND aua.account_id = (SELECT value FROM ox_application_variable WHERE name='admin_account_id');

was not working (maybe this is due to the new Revive version).

Are there no other possibilities? Why is there an alert in the context of the favicon.ico?

Thanks in advance again.

Tom

[Kaspersky Issue at Revive Backend]

Hi,

I am using Revive 4.0.0 (which I upgraded from OpenX a couple of weeks ago).

If I enter the admin backend of Revive and trying to display a banner in one of the zones there (with show banner function) then Kaspersky puts an alarm with HEUR:Trojan.Script.Generic for http://www.example.com/favicon.ico

Might it possible that this a Revive bug?

In terms of a potential security vulnerability I also checked the ox_banner and ox_zone for prepend/append modifications, but everything is normal there (no changes at all).

What can be the reason for that?

Tom