newnie need help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
doublebackflip
Forum Newbie
Posts: 3
Joined: Sat Nov 26, 2011 2:18 am

newnie need help

Post by doublebackflip »

I was editing old ptc sript, I was editing his part surf.php
so 1 ip can only click on ads 1 time
if the member already click ads your ad will crossed by brown lines,
otherwise if there are other members who login with the same IP with the previous members who have clicked your ad by previous members will look crossed with red lines
I've tried to edit it myself but found the problem

here sreenshot before an ad is clicked
Image

after the ad is clicked i refresh my browser
Image
but the ad become double. the brown line it mean i clicked and red line it mean IP IP has been used
But the 2nd ads I do not click but has also crossed
Here is my code

Code: Select all

<?php
$cats = array(  "1"  => "Arts & Entertainment",
"2" => "Business & Money",
"3" => "Computers & Internet",
"4" => "Health & Recreation",
"5" => "Reference & Education",
"6" => "Shopping & Spending",
"8" => "Travel & Accommodation",
"9" => "Charity & Nonprofit" );

foreach($cats as $k=>$v)
{
print '<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr style="BACKGROUND-COLOR:#ffffff;"> 
<td width="70%" class="class2" background="images/back.jpg" style="BACKGROUND-COLOR: #2753f4; FONT-FAMILY: Verdana; FONT-SIZE: 13px; border:solid 1px #999999; padding: 3px;"><span style="margin-left: 3px;"><strong><font color="white">
'.$v.'</font></strong></span></td>
<td width="10%" background="images/back.jpg" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; BACKGROUND-COLOR: #2753f4; border:solid 1px #999999; border-left:none;"><span style="margin-left: 3px;"><strong><font color="white">Member</font></strong></span></td>
<td width="10%" background="images/back.jpg" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; BACKGROUND-COLOR: #2753f4; border:solid 1px #999999; border-left:none;"><span style="margin-left: 3px;"><strong><font color="white">Outside</font></strong></span></td>
<td width="10%" background="images/back.jpg" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; BACKGROUND-COLOR: #2753f4; border:solid 1px #999999; border-left:none;"><span style="margin-left: 3px;"><strong><font color="white">Total</font></strong></span></td>
</tr>';

$premium = ($loggedin == 1 and $r["account"]=="premium") ? "" : " AND premium=0";
$ads = mysql_query("SELECT COUNT(*) AS cnt FROM ads WHERE clicksleft>'0' AND active='1' AND cat='$k'".$premium);
$ads = mysql_fetch_array($ads);
$ads = $ads['cnt'];
if($ads == 0)
{
print '<tr> 
<td colspan="4" class="class2" style="FONT-FAMILY: Verdana; FONT-SIZE: 11px; border:solid 1px #999999; border-top:none; padding: 4px;"><span style="margin-left: 3px;">
No Current Ads</span></td>
</tr>';}

else {
$premium = ($loggedin == 1 and $r["account"]=="premium") ? "" : " AND premium=0";
$quer = mysql_query("SELECT * FROM ads WHERE clicksleft>'0' AND active='1' AND cat='$k'".$premium);
while($ad = mysql_fetch_array($quer))
{
if($loggedin==1)
{
$checkvisit = mysql_query("SELECT COUNT(*) AS cnt FROM ad_clicks WHERE user='{$r['id']}' AND ad='{$ad['ad_id']}'") or die(mysql_error());
$checkvisit = mysql_fetch_array($checkvisit);
$checkvisit = $checkvisit["cnt"];
$laip = getRealip();
$ad_ip = mysql_query("SELECT ad_ip FROM ad_clicks WHERE ad_ip='$ad_ip'");
}
if($checkvisit > 0 and $loggedin ==1)
{
print '															
<tr> 
<td width="70%" class="class2" style="FONT-FAMILY: Verdana; FONT-SIZE: 11px; border:solid 1px #999999; border-top:none; padding: 4px;"><span style="margin-left: 3px; text-decoration:none; color: #787878;"><font color=#660000><strike>'.$ad['ad_description'].'</strike></font> 								  
</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['clicks'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['outside'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.($ad['outside']+$ad['clicks']).'</span></td>
</tr>';}

if($laip=$ad_ip and $loggedin ==1)
{
print '															
<tr> 
<td width="70%" class="class2" style="FONT-FAMILY: Verdana; FONT-SIZE: 11px; border:solid 1px #999999; border-top:none; padding: 4px;"><span style="margin-left: 3px; text-decoration:none; color: #787878;"><font color=red><strike>'.$ad['ad_description'].'</strike></font> 								  
</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['clicks'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['outside'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.($ad['outside']+$ad['clicks']).'</span></td>
</tr>';}

else {
print '															
<tr> 
<td width="70%" class="class2" style="FONT-FAMILY: Verdana; FONT-SIZE: 11px; border:solid 1px #999999; border-top:none; padding: 4px;"><span style="margin-left: 6px; text-decoration:none; color: #787878;"><div style="float:left;"><img src="images/design/rp2.png" width="20" height="23" border="0" /></div></span><div style="padding-top:6px; text-decoration:none; color: #787878;">&nbsp;
<a href=view.php?ad='.$ad['ad_id'].' target=_blank style="text-decoration:none; color: #3d4c00;">'.$ad['ad_description'].'</a> 								  
</div></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['clicks'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.$ad['outside'].'</span></td>
<td width="10%" style="FONT-FAMILY: Verdana;FONT-SIZE: 13px; border:solid 1px #999999; border-left:none; border-top:none;"><span style="margin-left: 3px;">
'.($ad['outside']+$ad['clicks']).'</span></td>
</tr>';}
}
}
print "</table><br />";
}
?>
sorry about my english :D i use google translate :D
anyone can help me Please :confused: been almost a week has not finished as well. thanks before ;)
maxx99
Forum Contributor
Posts: 142
Joined: Mon Nov 21, 2011 3:40 am

Re: newnie need help

Post by maxx99 »

Hard to get through thos &#40; and others :D

Check your IF statements first, try not to use if, if, if, else. Change it to if,else if, else if, else... (if that makes sense :) )

Code: Select all

 if&#40;$loggedin==1&#41;
{
..
}
 if&#40;$checkvisit > 0 and $loggedin ==1&#41;
{
...
}

 if&#40;$laip=$ad_ip and $loggedin ==1&#41;
{
...
}

else {...}
doublebackflip
Forum Newbie
Posts: 3
Joined: Sat Nov 26, 2011 2:18 am

Re: newnie need help

Post by doublebackflip »

Hi, Maxx99
Thanks I try n That Working Well Now :)
Thanks For Ur Answer :) You're My Hero Today :D
Post Reply