Repository navigation
Expand file tree
/
Copy pathsidebarads.php
More file actions
85 lines (76 loc) · 3.09 KB
/
Copy pathsidebarads.php
File metadata and controls
85 lines (76 loc) · 3.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<aside class="aa-blog-sidebar">
<div class="aa-sidebar-widget">
<h3>Advertisement</h3>
<div class="row">
<div class="col-md-12">
<div class="aa-blog-content">
<div class="row">
<?php
$sqlwebads= "SELECT webads.*,advertiser.advertisername FROM webads LEFT JOIN advertiser ON webads.advertiserid=advertiser.advertiserid WHERE webads.status='Active' ORDER BY webads.cpc desc ";
$qsqlwebads = mysqli_query($con,$sqlwebads);
echo mysqli_error($con);
while($rswebads = mysqli_fetch_array($qsqlwebads))
{
if($rswebads[3] == "")
{
$imgname = "img/noimage.jpg";
}
else if(file_exists("imgwebads/$rswebads[3]"))
{
$imgname = "imgwebads/$rswebads[3]";
}
else
{
$imgname = "img/noimage.jpg";
}
//#################################################
$sql= "SELECT sum(payment.paidamt) FROM payment LEFT JOIN advertiser ON advertiser.advertiserid=payment.advertiserid WHERE payment.paymenttype='WebAds' ";
$sql = $sql . " AND payment.advertiserid='$rswebads[advertiserid]'";
$qsql = mysqli_query($con,$sql);
$rs = mysqli_fetch_array($qsql);
$totamt = $rs[0];
//#################################################
$sql= "SELECT ifnull(sum(payment.paidamt),0) FROM payment LEFT JOIN advertiser ON advertiser.advertiserid=payment.advertiserid WHERE (payment.paymenttype='Banner Ads' OR payment.paymenttype='Text Ads') ";
$sql = $sql . " AND payment.advertiserid='$rswebads[advertiserid]'";
$qsql = mysqli_query($con,$sql);
$rs = mysqli_fetch_array($qsql);
$spentamt = $rs[0];
//#################################################
$balamt = $totamt - $spentamt;
//#################################################
if($balamt > 0 )
{
if($rswebads['advttype'] == "Banner Ads")
{
?>
<div class="col-md-12 col-sm-12 table table-bordered">
<article class="aa-blog-content-single">
<h4><a href="linkadvertisement.php?webadid=<?php echo $rswebads['webadid']; ?>" target="_blank"><?php echo $rswebads['advttitle']; ?></a></h4>
<figure class="aa-blog-img">
<a href="linkadvertisement.php?webadid=<?php echo $rswebads['webadid']; ?>" target="_blank"><img src="<?php echo $imgname; ?>" ></a>
</figure>
</article>
</div>
<?php
}
if($rswebads['advttype'] == "Text Ads")
{
?>
<div class="col-md-12 col-sm-12 table table-bordered">
<article class="aa-blog-content-single">
<h4><a href="linkadvertisement.php?webadid=<?php echo $rswebads['webadid']; ?>" target="_blank"><?php echo $rswebads['advttitle']; ?></a></h4>
<p><?php echo substr($rswebads["advtdescription"], 0, 100); ?></p>
</article>
</div>
<?php
}
}
}
?>
</div>
</div>
<!-- Blog Pagination -->
</div>
</div>
</div>
</aside>