Jump to content


Approved members
  • Content Count

  • Joined

  • Last visited

About checkad

  • Rank

Recent Profile Visitors

763 profile views
  1. 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
  2. Thank you for the clarification
  3. 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
  4. 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
  5. 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.
  6. 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.
  7. 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).
  8. 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
  9. 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)
  10. 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
  11. 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
  12. 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.
  13. 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('',''); $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,
  14. 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.
  15. 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
  • Create New...