<?php
set_time_limit(0);
ignore_user_abort(1);
include 'clickcount.php';
include 'imprsn.php';
if(file_exists('log_imp1') || file_exists('log_click1') || 1) {
echo '<pre>';
##### updating innodb for previous record #######################
include'config.php';
# updating impression for publisher
$sql="update pid set imp=(imp+imp_h), click=(click+click_h); ";
#udating impression for advertiser
$sql.="update aid set imp=(imp+imp_h), click=(click+click_h); ";
#reseting last hour
$sql.="update pid set imp_h=0 , click_h=0; ";
$sql.="update aid set imp_h=0 , click_h=0; ";
if(file_exists('log_imp1')){
$adm=imp(file('log_imp1'),1);
$pbm=imp(file('log_imp1'),0);
//publisher impression
foreach($pbm as $k=>$v){
$sql.="update pid set imp_h=$v where pid=$k; ";
// $sql.="update pid set point=(point+".($v/200).") where pid=$k;";
}
//advertiser impression
foreach($adm as $k=>$v)
{
$sql.="update aid set imp_h=$v where aid=$k; ";
}
}
if(file_exists('log_click1')){
$adc=click(file('log_click1'),1);
$pbc=click(file('log_click1'),0);
//advertiser click
foreach($adc as $k=>$v){
$sql.="update aid set click_h=$v where aid=$k; ";
$sql.="update pid set point=point-".($v*3)." where pid=(select pid from aid where aid=$k limit 1); ";
}
//publisher click
foreach($pbc as $k=>$v){
$sql.="update pid set click_h=$v where pid=$k; ";
$sql.="update pid set point=point+".($v*1.5)." where pid=$k; ";
}
}
#echo $sql; exit;
$time=time()+microtime();
$sql="START TRANSACTION;".$sql."COMMIT;";
if($mysqli->multi_query($sql)) {
echo "query executed\n";
@unlink('log_imp1');
@unlink('log_click1');
} else echo "ERROR: ".$mysqli->error;
$mysqli->close();
$mysqli=new mysqli('localhost','myuni_khizar','khizartarannum','myuni_ad');
echo $mysqli->query('truncate table ad')?'del':'error'.__line__;
$mysqli->close();
include'config.php';
$sqlite=new mysqli('localhost','myuni_khizar','khizartarannum','myuni_ad' ) or die('unable to connect on line'.__line__);
$sql='SELECT aid, img, title, url, point, adult,pid1
FROM aid, pid
WHERE pid.point >50
AND pid.pid = aid.pid
AND STATUS =1
AND run =1
AND approv=1
LIMIT 200';
if($result=$mysqli->query($sql)){
if($result->num_rows > 0){
$sql='BEGIN;';
while($row=$result->fetch_array()){
extract($row);
$title=str_replace("'",'`',$title);
$sql.="insert into ad (aid,img,title,url,point,adult,pid1) values('$aid','$img','$title','$url','$point','$adult','$pid1');";
// if ($sqlite->query($sql)) echo "recorded\n"; else echo "error\n$sql";
}
$sql.='COMMIT;';
if ($sqlite->multi_query($sql)) echo "recorded\n"; else echo "error\n$sql";
} else echo 'no result found';
#CREATE INDEX "INDEX_NAME" ON "TABLE_NAME" (COLUMN_NAME
// $sq="CREATE INDEX SPEED ON ad (aid,pid1,point,adult,title,url,img);";
// if ($result = $sqlite->query($sq)) echo 'index created'; else echo 'error in creating index';
$sqlite->close();
$sql1="SELECT count(*) FROM ad";
$sql2="SELECT count(*) FROM ad where adult=''";
$sql3="SELECT count(*) FROM ad where img=''";
$sql4="SELECT count(*) FROM ad where img='' and adult=''";
$mysqli->close();
$my=new mysqli('localhost','myuni_khizar','khizartarannum','myuni_ad');
if($r=$my->query($sql1))
{
$row=$r->fetch_array();
print_r($row);
$re[]=$row[0];
}
if($r=$my->query($sql2)){
print_r($row);
$row=$r->fetch_array();
$re[]=$row[0];
}
if($r=$my->query($sql3)){
$row=$r->fetch_array();
$re[]=$row[0];
}
if($r=$my->query($sql4)){
$row=$r->fetch_array();
$re[]=$row[0];
}
$line=implode("\n",$re);
file_put_contents("line.txt",$line);
} else echo 'query error '.$mysqli->error;
$sql="SELECT sum( imp + imp_h ) , sum( click + click_h ) FROM aid";
$result=$my->query($sql);
while($row=$result->fetch_array()){
$fd= "<div class=impa>Overall Impressions Served:<br />
<b>".ceil($row[0]*3)."</b><br />
Overall Clicks Served:<br />
<b>".ceil($row[1]*3)."</b> <br />
<u><b>This Stats are updated every hour</b></u>
</div>";
}
file_put_contents('imp.php',$fd);
echo ((time()+microtime())-$time);
}else echo 'file doesnt exist';
?>