checkad

An other accepted alternative would be to hack the alocal.php file by : - making a copy of alocal.php - use this copy when i need it and modify one line in it, to force not to take into account any priority ? like commenting one line ? I've seen many function like _adSelectCommon and _adSelect and i've tried many modifications without being able to make it work. any clue ? Thank you

I found that it is also possible to use avw with the number of the banner (so not using the invocation tag) to display the image only /www/delivery/avw.php?bannerid=11 but it is still using any delivery rule related to the banner.

Hello, What is the use of part of the tag in the delivery of banners (/delivery/lg.php?) like &referer= & loc= ? I mean there are filled with the url of the current page and the page from where people are coming. But is there any use within Revive ? And can we remove it without any issue ? Thank you

Hello, I'm using the Local Mode Invocation Tag to display all banners. I want to display only one specific banner on a specific page. It's easy, by putting the id of the banner in invocation code and it is working. BUT i don't want this specific banner to be displayed anywhere else on the site. To make sure a banner is not displayed, you can either set up the campaign to 0, the priority to 0 or not having a zone defined for that banner. But then, even by putting the number of the id of the banner directly in the invocation code, there is no banner displayed. In other words, is there a way to FORCE a banner to display using the invocation code, even if the campaign or priority is set to 0 ? Thank you

Hello, When the adserver is pushing the code in local mode, it is creating for the pixel tracking either a loc= or a referer= that are the current page and the referer page. Are they useful for counting ? Why i am asking is that i've been bumped with XSS and if the url is wrong like containing <script> or kind of code, it is used wihtin the page. So, I want to clean it to keep only the path and filename without any argument after it. Thank you for confirmation

Thank you for the clarification

Hello, i noticed the cache is in : \revive\var\cache as there are old files, I guess this folder is not cleaned by maintenance. 1. Is it worth to clean it manually ? then, can we do it from the command line (rm) or should it be done through the admin only ? Thank you

sorry, yes, one banner is listed but no percentage is indicated. but by changing "override" by "remnant" again, then the icon is yellow again and the 100% probability is indicated again. diffusion, meaning distribution (bad translation done) thanks for helping

Thanks. For the 2 normal zones, i have the probabilities percentage and the weight but for this 3rd zone, I have neither probabilities neither weight shown. could it be the issue ? i've checked the config of my zone, but its exactly set like the 2 others. the only different thing is that the icon of the zone (under the name column) is red instead of yellow like the 2 others.

yes, i'm certain i understand the 3 different campaigns types correctly (and working 8 years with phpadsnew has been no problem even if overide was not existing on that one). let's try to make it simpler. i have 100.000 pages viewed per day. If i set up 1 zone (identical on all pages) with only one banner to display, this zone should be able to display 100.000 banners (no limitation, no capping), right ? but instead of 100.000 banners, this zone is only displaying 40.000 banners. i've tried to set that campaign as overide without more success (no other overide campaign than this one). --- more details as in reality i have 2 other zones per page (3 zones in total per page). the 2 other zones are displaying 100.000 banners per zone, per day, each. so, what is expected, fine. So, the 3rd zone should do the same (but in fact is only displaying half of what it should be possible). the only difference is that the other 2 zones do have a mix of different banners from different campaigns when the 3rd zone has only one banner from one campaign only.

by the way, i did the test for this 3rd zone, that only has 1 specific banner to deliver (no capping nor delivery limitation for that banner) by using on day 1 : remnant, but set to 10 for the banner day 2 : contract, the only one contract (all other being remnant) day 3 : override the number per day is nearly the same every day, whatever the kind of campaign like a roof. note that it is a new reviveadserver set up with only new campaigns, with 3 months of history (taking into account that the daily delivery is very stable).

Hello, I have 3 zones on a webpage. 2 zones should display all campaigns randomly (using remnant = working). 1 zone should only display one campaign but none of the other campaigns, taking all impressions possible (either using contract or override = not working). Here is an exemple. I have 100.000 pages displayed per day. So, i should be able to display my specific campaign to my 3rd zone with 100.000 banners (taking into account that i have one specific format for that particular zone not used anywhere else). But, in fact, there is only 1/3 or 1/4 of banners what could be possible displayed that are displayed, so 20.000 per day are displayed instead of the 100.000 possible (no capping, no restriction of time or anything, they should just displayed on every page). Any idea why this is not working ? (because it was working fine with phpadsnew and this is only since revive that it is not working anymore correctly) Thank you

if most of bots and crawler are identifying themselves as crawlers or bots, some of them are not. then you have only one IP that is generating sometimes thousands of clicks by itself. these are 2 IPs that were massively clicking everywhere. using the code above, i can add either a specific bot not listed as a bot (like xenu recently) or a specific ip that is definitely not human. i'm thinking about creating a plugin to do this, but I'm missing some infos, especially as i'm hacking the code (definitely not a good way)

you can by using phpmyadmin on the database (at your own risks) views and clicks of banners are stored in the xx_ pub_data_summary_ad_hourly table banners are stored in the xx_banners table campaigns are stored in the xx_campaigns table then, it's a question of join request on these 3 tables

Hi, I'm building my own script to be able to fully desactivate one campaign in one click, without having to go inside every campaign, banners and zone to set it up to 0 or desactivate. I've tested it and it works. But could you please confirm that the 3 following mysql requests are taking "everything" into account to do it properly ? where $campaignid is the id of the campaign UPDATE revive_banners SET weight=0,status=1 WHERE revive_banners.campaignid='$campaignid' UPDATE revive_campaigns SET views=0,clicks=0,priority=0,target_impression=0,expire_time=NOW() WHERE campaignid='$campaignid' DELETE a.* FROM revive_ad_zone_assoc a LEFT JOIN revive_banners b ON b.bannerid = a.ad_id WHERE a.zone_id > 0 AND b.campaignid='$campaignid' Thank you

After 3 weeks, I did authenticate 22 different bots and crawlers and the number is not changing anymore now. Note that some of tem do say that they are bot or crawler (most of them) but sometimes it's only an IP with no info. So the only way to check is to find that one ips is making a large number of clicks. Once found, I disable the call to the db but keep the filter on bots and ips and now, figures and numbers are fine and logical.

Hello, Migrating from PhpAdsNew toRevive, I did notice a BIG increase in clicks : 5 times nearly ! Same banners, same campaigns, same number of impressions for the same banners, but the clicks has been multiplied by 5. I've read all replies saying it was bots in such cases, but not understanding why Revive is more sensible with bots compared to PhpAdsNew. But to track bots, it did some hack. Here is the code; if it can help anybody to check which bots are making crazy numbers. Note : the code can be enhanced of course. STEP1 - CREATE 2 TABLES in the same db CREATE TABLE IF NOT EXISTS `pub_log_bots` ( `bot` varchar(14) collate utf8_bin NOT NULL, `detail` varchar(200) collate utf8_bin NOT NULL, `tot` smallint(6) unsigned NOT NULL, `lastupdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`detail`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE IF NOT EXISTS `pub_tmp` ( `logdate` datetime NOT NULL, `clicks` smallint(6) NOT NULL, `adid` tinyint(3) unsigned NOT NULL, `bot` tinyint(3) unsigned NOT NULL, `ip` varchar(16) collate utf8_bin NOT NULL, `dns` varchar(100) collate utf8_bin NOT NULL, `ref` varchar(200) collate utf8_bin NOT NULL, PRIMARY KEY (`logdate`,`adid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; STEP2 hack the code of the ck.php file (but save the ck.php file first). go to the line of the MAX_Delivery_log_logAdClick() function. it should be 2146 for the latest release 3.2.4. then i create 3 arrays to check against user_agent of the browser (good bots have 'bot' in their signature), ips and hosts. FINAL CODE I then log in one table, the clicks done by different bots and in the other table, the non-bots clicks (I can then iterate to find other bots or repeating ip address and check them against blacklist in spamhaus) Final code is here (connection to the db must be changed with your credentials; using the credentials of revive would be better if somebody want to add the correct line for doing it). function MAX_Delivery_log_logAdClick($adId, $zoneId) { if (empty($GLOBALS['_MAX']['CONF']['logging']['adClicks'])) { return true; } $date=date("Y-m-d H:i:s",time()); $bots= array('mediatoolkitbot','trendiction','google','slurp','crawler','bot','http'); $ips= array('217.113.43.215','195.81.226.146'); $hosts= array('pressrelations.de'); $bot=0; foreach($bots as $botid) { if (stripos($_SERVER["HTTP_USER_AGENT"],$botid)) { $bot=1;break;} } if ($bot==0) {foreach($hosts as $botid) { if (stripos(gethostbyaddr($_SERVER['REMOTE_ADDR']),$botid)) { $bot=1;break;} } } if ($bot==0) {foreach($ips as $botid) { if (stripos($_SERVER['REMOTE_ADDR'],$botid)) { $bot=1;break; } } } if ($bot==1) { $query = "INSERT INTO pub_log_bots (bot,tot,detail) VALUES ('$botid','1','".$_SERVER["HTTP_USER_AGENT"]."') ON DUPLICATE KEY UPDATE tot=tot+1"; } else { $query = "INSERT INTO pub_tmp (logdate,adid,clicks,bot,ip,dns,ref) VALUES ('$date','$adId',1,'$bot','".$_SERVER['REMOTE_ADDR']."','".gethostbyaddr($_SERVER['REMOTE_ADDR'])."','".$_SERVER["HTTP_USER_AGENT"]."') "; OX_Delivery_Common_hook('logClick', array($adId, $zoneId, _viewersHostOkayToLog($adId, $zoneId))); } $dbc = @mysqli_connect ('localhost', 'user', 'password', 'dbname'); $result= mysqli_query($dbc,$query); } of course, when you have checked which bots, you can go back to the original version of the ck.php file AND use the built in functionnality in the admin to exclude ips, agents on that page /revivedirectory/www/admin/account-settings-banner-logging.php Regards,

The issue is not coming from bots but from the code itself, related to the underlying platform. I explain. I did installed Revive under PHP 5.4 on our website, code being installed on the same server within the same domain name (CentOS5), trying to use both javascript invocating code or direct php, and get this stupid amount of clicks higher even than the number of impressions. I did installed Revive under PHP 5.4 on our website, but code on an other server with PHP 5.4 and same realease of MySql (but different linux) and with javascript invocating code then everything is working fine. So, the issue is really coming from a "kind of bug" related to the OS itself. Until now, i did'nt find any solution. i'm only trying to move to CentOS7 and test it to check if it is working better. but moving to CentOS7 means MariaDB and PHP 5.6, and some code to check before.

It's possible to upgrade the Cent07 release with php 5.5 and/or php 5.6 without problem. I've done it. Yes, it's true, not on the default package. but not yet test Revive on that release (trying to understand why i have irrelevant statistics with revive adserver on my system = more clics than display of banners so impossible, when before phpadsnews on the same server was working just fine) New version 5.6.8-1.el7.remi

This project is not maintained as it has be, and it's a pity. But i do understand that a lot of people involved in that peoject were doing it on their freetime. So, I want to thank them for all the work done during all these years. I have been able to make the same code work on a server, and on an other server having crazy results. despite the fact that the php release (5.5), Apache and Mysql being on the same numer of releases. I do suspect now that it's coming from the underlayer Linus; the CentOs release having an issue. note that the phpadnews on CentOs had no problem in the past, meaning phpadsnew having no problem to run on the designed server. But as soon as we try to install, ReviveAdserver, then we had the issue. but phpadnew is not supported anymore for years and has several issues/security flaws. So, I would not recommand to run it anywhere as it could compromise the whole system.

New install, from scratch, with no campaign, no banner, after an upgrade to php5.5. Install worked fine. But issue is still the same. There are more clicks than banners delivered on some campaigns, a little bit less on some others. And delivery, double check with smart adserver, is showing that the delivery count is underestimated : meaning smart is counting a higher number in delivery with a right number of clicks. How do I know that it is under counting delivery ? Having one banner on every page, set to display every time, I have the same number of banners than the displayed page with smart compared to googleanalytics... When revive is under counting. I guess it's a server issue with specific library conflict or anything... If someone has an idea where I should look at... Thank you

Hello, I have 2 zones delivering banners fine but an other 3rd zone not delivering banners (nearly not delivering). The 3rd zone is exclusive, so it should deliver the same banner all the time (zone 1 and 2 are delivering rotating banners). But I have let's say one banner every 10 minutes, instead of one banner on every refresh of the page (banner is correctly linked to the zone, so it appears sometimes). Weight of the banner is 10. there is NO limitation neither on the banner or on the campaign. probability of the banner is : 100.00% I tried several : - different invocation code -> no more success - contract and contract exclusive -> no more chance Any idea ? Thanks Regards, note : I regret the time of phpadnews. it was working much better without headaches. not as powerful in terms of possibilities but at least working

I did install it on an other server and it is working fine. The only difference I see is the php version : not working on php 5.3.29 but fine on 5.4. Does it make sense ? Or could it be something else than the php version ? note that when i was installing on 5.3.29, the css was not loading and plugins were not installed by default but needed to be installed manually, despite the fact that the install went well , meaning without error message on the screen. install on 5.5 is working fine too.

I started again from scratch, meaning resinstalling the whole code from the beginning (clean install), but with only 3 plugins. Maintenance is now runned as a cron. Issue is still the same ! there are more clicks than banners delivered (sometimes less, sometimes more).

I tried to use javascrip tag instead of local invocation tag but it didn't change anything. I did uninstall all plugins and then reinstall them but only 3 : the one for for stats. it doesn't change anything. The count of banners delivered seems to be correct. but the clicks are still high.