Pessoal peguei um script de um forum a muito tempo de troca banners www.forumscripts.com, mais acontece que ewsta com erros a maioria dos erros já arrumei mais a parte que faz a contagem das estatisticas a pagina responsavél por capturar os banners no banco de dados não esta aparecendo para serem clicados a pagina esta abaixo sera que é possivél identificar algum erro
<?php
/////////////////CHECKS AGAINST DUMMY CLICKS/////////////
function valid()
{
return (1);
}
///// READ INPUT VARIABLES//////////////////////////////////////////////////
if ( isset( $_REQUEST["size"] ) )
{$size=$_REQUEST["size"];}
else
{$size=1;}
if ( isset( $_REQUEST["id"] ) )
{
$id=$_REQUEST["id"];
}
else
{
$id=0;
}
mt_srand((double)microtime()*1000000);
/////////READ CONFIGURATION /////////////////////
include_once("myconnect.php");
$config=mysql_fetch_array(mysql_query ("select * from sbbanners_config "));
$root=$config["site_root"];
$ratio1=$config["ratio1"];
$ratio2=$config["ratio2"];
$click_reward=$config["click_reward"];
///////////////////////////////////////
$campaign_query=mysql_query ("select * from sbbanners_campaigns where id=" . $id);
if ($campaign=mysql_fetch_array($campaign_query))
{
if(valid())
{
/////////////OUTPUT IMAGE NAME /////////////////////////////
$sql="select * from sbbanners_ads,sbbanners_campaigns where sbbanners_ads.campaign_id = sbbanners_campaigns.id and sbbanners_ads.size_id=$size and receive='yes' and sbbanners_campaigns.approved='yes' and sbbanners_ads.approved='yes' and round(displays_gen/$ratio1 * $ratio2)+$click_reward * clicks_gen - displays_rec + credits >0 and adv_id<>" . $campaign["adv_id"];
//echo $sql;
$rs_t_query=mysql_query ($sql);
$rcount=mysql_num_rows($rs_t_query);
if ($rcount<>0)
{
//echo "Valid campaigns: $rcount <br>";
$rnum= mt_rand(1,$rcount);
//echo "Random number : $rnum <br>";
//echo "Rejected Campaigns : ";
$jmpcnt=0;
while ($jmpcnt<$rnum && $rs_t=mysql_fetch_array($rs_t_query) )
{
$jmpcnt = $jmpcnt + 1;
//echo $rs_t["campaign_name"] . ", ";
}
//echo "<br>Campaign Choosen : " . $rs_t["campaign_name"] . "<bR>";
//////////// CHOOSE BANNER FOR CAMPAIGN //////////////
$sql1="select * from sbbanners_ads where size_id=$size and approved<>'no' and campaign_id=" .$rs_t["id"];
//echo $sql1 . "<br>";
$rs_t1_query=mysql_query ($sql1);
$total=0;
$jmpcnt=0;
while ($rs_t1=mysql_fetch_array($rs_t1_query) )
{
$jmpcnt = $jmpcnt + 1;
$total+=$rs_t1["banner_weight"];
}
$rnum1= mt_rand(1,$total);
$sql1="select * from sbbanners_ads where size_id=$size and approved<>'no' and campaign_id=" .$rs_t["id"];
$rs_t1_query=mysql_query ($sql1);
$rcount=mysql_num_rows($rs_t1_query);
//echo "Banners Found :" . $rcount . "<br>";
//echo "Total Weight :" . $total . "<br>";
//echo "Choosen Weight :" . $rnum1 . "<br>";
$total=0;
$jmpcnt=0;
while ( $total<$rnum1 && ( $rs_t1=mysql_fetch_array($rs_t1_query) ) )
{
$jmpcnt = $jmpcnt + 1;
$total+=$rs_t1["banner_weight"];
}
$sql2="select * from sbbanners_sizes where id=$size";
$rs_t2_query=mysql_query ($sql2);
$rs_t2=mysql_fetch_array($rs_t2_query);
$height= $rs_t2["height"];
$width= $rs_t2["width"];
echo "<a target='_other' href='$root/gotourl.php?id=". $rs_t["id"] ."&fid=$id&bid=".$rs_t1["id"]."' ><img border=0 height=$height width=$width src='$root/admin/banners/" . $rs_t1["bannerurl"] . " ' ></a>";
$cheating=0;
if($config["anticheat"]=="yes")
{
$rst=mysql_num_rows(mysql_query("select * from sbbanners_member_ips where adv_id=".$campaign["adv_id"]." and ip_address='".$_SERVER['REMOTE_ADDR']."'"));
if($rst>0)
{
$cheating=1;
}
}
if($cheating==0)
{
$sql1="update sbbanners_campaigns set displays_gen=displays_gen+1 where id=" .$id;
mysql_query ($sql1);
$sql1="update sbbanners_campaigns set displays_rec=displays_rec+1 where id=" .$rs_t["id"];
mysql_query ($sql1);
$sql1="update sbbanners_ads set displays=displays+1 where id=" .$rs_t1["id"];
mysql_query ($sql1);
$sql1="insert into sbbanners_displays (adv_id,campaign_id,ondate) values(" .$rs_t["adv_id"].",".$rs_t["id"].",'".date("YmdHis",time())."')";
mysql_query ($sql1);
$sql1="insert into sbbanners_displays_generated (adv_id,campaign_id,ondate) values(" .$campaign["adv_id"].",".$id.",'".date("YmdHis",time())."')";
mysql_query ($sql1);
}
}
else
{
////// SHOW DEFAULT BANNER //
$sql1="select * from sbbanners_sizes where id=$size";
$rs_t1_query=mysql_query ($sql1);
$rs_t1=mysql_fetch_array($rs_t1_query);
$height= $rs_t1["height"];
$width= $rs_t1["width"];
echo "<a target='_other' href='$root/index.php' ><img border=0 height=$height width=$width src='$root/admin/uploadedimages/" . $rs_t1["default_banner"]."' ></a>";
///////////////////////////
}
/////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////
}
}
?>
Esta pagina abaixo é que gera o codigo html para ser colocado na pagina
<?
include_once("logincheck.php");
include_once("myconnect.php");
include_once("left_mem.php");
function main()
{
$config=mysql_fetch_array(mysql_query ("select * from sbbanners_config "));
if(!isset($_REQUEST["id"])||($_REQUEST["id"]==""))
{
echo "<br><br><br><div align='center'><font size=2 color='#333333' face='Arial, Helvetica, sans-serif'>Nenhuma Campanha encontrada. Click <a href='ad_home.php' class='insidelink'>Aqui</a> para continuar</font></div><p> </p><p> </p><p> </p><p> </p>";
return;
}
$campaign=mysql_fetch_array(mysql_query("select * from sbbanners_campaigns where id=" . $_REQUEST["id"]));
?><form action="" method="post" name="form123" id="form123" >
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr align="center">
<td width="154" align="right" valign="top">
<?php left();?>
</td>
<td align="right" valign="top">
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="5" class="maintablestyle">
<tr>
<td height="25" class="titlestyle"><strong> Codigos para campanha
<? echo $campaign["campaign_name"]; ?></strong></td>
</tr>
<tr>
<td><div align="justify"><font size="2" face="Arial, Helvetica, sans-serif">O copie o código abaixo e cola-o no Html de eu site. Você não pode mudar qualquer parte deste código. Se você modificar, será suspenço imediatamente do programa da troca de banner e todos seus créditos serão perdidos. </font></div></td>
</tr>
<?
$sql="select * from sbbanners_sizes order by width";
$size_query=mysql_query ($sql);
while ( $size=mysql_fetch_array($size_query) )
{
?>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Tamanho:
</strong><?php echo $size["width"]."x".$size["height"];?></font></td>
</tr>
<tr>
<td><textarea name="textarea" cols="65" rows="7" readonly ><center> <iframe src="<?php echo $config["site_root"];?>/image.php?id=<? echo $campaign["id"]; ?>&size=<?php echo $size["id"];?>" width="<?php echo $size["width"];?>" height="<?php echo $size["height"];?>" scrolling="no" frameborder="0" marginheight="0" marginwidth="0" vspace="0" hspace="0"></iframe><br><a target="_blank" href="http://www.portaldowebmaster.com/trocabanners/"><img src="http://www.portaldowebmaster.com/trocabanners/<?php echo $size["width"];?>.gif" border=0></a></center></textarea></td>
</tr>
<?
}
?>
</table>
<br> </td>
</tr>
</table>
</form>
<?
}// end main
include_once "template.php";
?>
Não da erro algum se algupem se interresar em me ajudar o script esta online para testa-lo percebi que os codigo gerados é sempre o mesmo e não faz a rotatividade do banner
Pergunta
matrix2003
Pessoal peguei um script de um forum a muito tempo de troca banners www.forumscripts.com, mais acontece que ewsta com erros a maioria dos erros já arrumei mais a parte que faz a contagem das estatisticas a pagina responsavél por capturar os banners no banco de dados não esta aparecendo para serem clicados a pagina esta abaixo sera que é possivél identificar algum erro
<?php /////////////////CHECKS AGAINST DUMMY CLICKS///////////// function valid() { return (1); } ///// READ INPUT VARIABLES////////////////////////////////////////////////// if ( isset( $_REQUEST["size"] ) ) {$size=$_REQUEST["size"];} else {$size=1;} if ( isset( $_REQUEST["id"] ) ) { $id=$_REQUEST["id"]; } else { $id=0; } mt_srand((double)microtime()*1000000); /////////READ CONFIGURATION ///////////////////// include_once("myconnect.php"); $config=mysql_fetch_array(mysql_query ("select * from sbbanners_config ")); $root=$config["site_root"]; $ratio1=$config["ratio1"]; $ratio2=$config["ratio2"]; $click_reward=$config["click_reward"]; /////////////////////////////////////// $campaign_query=mysql_query ("select * from sbbanners_campaigns where id=" . $id); if ($campaign=mysql_fetch_array($campaign_query)) { if(valid()) { /////////////OUTPUT IMAGE NAME ///////////////////////////// $sql="select * from sbbanners_ads,sbbanners_campaigns where sbbanners_ads.campaign_id = sbbanners_campaigns.id and sbbanners_ads.size_id=$size and receive='yes' and sbbanners_campaigns.approved='yes' and sbbanners_ads.approved='yes' and round(displays_gen/$ratio1 * $ratio2)+$click_reward * clicks_gen - displays_rec + credits >0 and adv_id<>" . $campaign["adv_id"]; //echo $sql; $rs_t_query=mysql_query ($sql); $rcount=mysql_num_rows($rs_t_query); if ($rcount<>0) { //echo "Valid campaigns: $rcount <br>"; $rnum= mt_rand(1,$rcount); //echo "Random number : $rnum <br>"; //echo "Rejected Campaigns : "; $jmpcnt=0; while ($jmpcnt<$rnum && $rs_t=mysql_fetch_array($rs_t_query) ) { $jmpcnt = $jmpcnt + 1; //echo $rs_t["campaign_name"] . ", "; } //echo "<br>Campaign Choosen : " . $rs_t["campaign_name"] . "<bR>"; //////////// CHOOSE BANNER FOR CAMPAIGN ////////////// $sql1="select * from sbbanners_ads where size_id=$size and approved<>'no' and campaign_id=" .$rs_t["id"]; //echo $sql1 . "<br>"; $rs_t1_query=mysql_query ($sql1); $total=0; $jmpcnt=0; while ($rs_t1=mysql_fetch_array($rs_t1_query) ) { $jmpcnt = $jmpcnt + 1; $total+=$rs_t1["banner_weight"]; } $rnum1= mt_rand(1,$total); $sql1="select * from sbbanners_ads where size_id=$size and approved<>'no' and campaign_id=" .$rs_t["id"]; $rs_t1_query=mysql_query ($sql1); $rcount=mysql_num_rows($rs_t1_query); //echo "Banners Found :" . $rcount . "<br>"; //echo "Total Weight :" . $total . "<br>"; //echo "Choosen Weight :" . $rnum1 . "<br>"; $total=0; $jmpcnt=0; while ( $total<$rnum1 && ( $rs_t1=mysql_fetch_array($rs_t1_query) ) ) { $jmpcnt = $jmpcnt + 1; $total+=$rs_t1["banner_weight"]; } $sql2="select * from sbbanners_sizes where id=$size"; $rs_t2_query=mysql_query ($sql2); $rs_t2=mysql_fetch_array($rs_t2_query); $height= $rs_t2["height"]; $width= $rs_t2["width"]; echo "<a target='_other' href='$root/gotourl.php?id=". $rs_t["id"] ."&fid=$id&bid=".$rs_t1["id"]."' ><img border=0 height=$height width=$width src='$root/admin/banners/" . $rs_t1["bannerurl"] . " ' ></a>"; $cheating=0; if($config["anticheat"]=="yes") { $rst=mysql_num_rows(mysql_query("select * from sbbanners_member_ips where adv_id=".$campaign["adv_id"]." and ip_address='".$_SERVER['REMOTE_ADDR']."'")); if($rst>0) { $cheating=1; } } if($cheating==0) { $sql1="update sbbanners_campaigns set displays_gen=displays_gen+1 where id=" .$id; mysql_query ($sql1); $sql1="update sbbanners_campaigns set displays_rec=displays_rec+1 where id=" .$rs_t["id"]; mysql_query ($sql1); $sql1="update sbbanners_ads set displays=displays+1 where id=" .$rs_t1["id"]; mysql_query ($sql1); $sql1="insert into sbbanners_displays (adv_id,campaign_id,ondate) values(" .$rs_t["adv_id"].",".$rs_t["id"].",'".date("YmdHis",time())."')"; mysql_query ($sql1); $sql1="insert into sbbanners_displays_generated (adv_id,campaign_id,ondate) values(" .$campaign["adv_id"].",".$id.",'".date("YmdHis",time())."')"; mysql_query ($sql1); } } else { ////// SHOW DEFAULT BANNER // $sql1="select * from sbbanners_sizes where id=$size"; $rs_t1_query=mysql_query ($sql1); $rs_t1=mysql_fetch_array($rs_t1_query); $height= $rs_t1["height"]; $width= $rs_t1["width"]; echo "<a target='_other' href='$root/index.php' ><img border=0 height=$height width=$width src='$root/admin/uploadedimages/" . $rs_t1["default_banner"]."' ></a>"; /////////////////////////// } ///////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////// } } ?>Esta pagina abaixo é que gera o codigo html para ser colocado na pagina<? include_once("logincheck.php"); include_once("myconnect.php"); include_once("left_mem.php"); function main() { $config=mysql_fetch_array(mysql_query ("select * from sbbanners_config ")); if(!isset($_REQUEST["id"])||($_REQUEST["id"]=="")) { echo "<br><br><br><div align='center'><font size=2 color='#333333' face='Arial, Helvetica, sans-serif'>Nenhuma Campanha encontrada. Click <a href='ad_home.php' class='insidelink'>Aqui</a> para continuar</font></div><p> </p><p> </p><p> </p><p> </p>"; return; } $campaign=mysql_fetch_array(mysql_query("select * from sbbanners_campaigns where id=" . $_REQUEST["id"])); ?><form action="" method="post" name="form123" id="form123" > <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td valign="top"> </td> <td valign="top"> </td> </tr> <tr align="center"> <td width="154" align="right" valign="top"> <?php left();?> </td> <td align="right" valign="top"> <table width="80%" border="0" align="center" cellpadding="2" cellspacing="5" class="maintablestyle"> <tr> <td height="25" class="titlestyle"><strong> Codigos para campanha <? echo $campaign["campaign_name"]; ?></strong></td> </tr> <tr> <td><div align="justify"><font size="2" face="Arial, Helvetica, sans-serif">O copie o código abaixo e cola-o no Html de eu site. Você não pode mudar qualquer parte deste código. Se você modificar, será suspenço imediatamente do programa da troca de banner e todos seus créditos serão perdidos. </font></div></td> </tr> <? $sql="select * from sbbanners_sizes order by width"; $size_query=mysql_query ($sql); while ( $size=mysql_fetch_array($size_query) ) { ?> <tr> <td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Tamanho: </strong><?php echo $size["width"]."x".$size["height"];?></font></td> </tr> <tr> <td><textarea name="textarea" cols="65" rows="7" readonly ><center> <iframe src="<?php echo $config["site_root"];?>/image.php?id=<? echo $campaign["id"]; ?>&size=<?php echo $size["id"];?>" width="<?php echo $size["width"];?>" height="<?php echo $size["height"];?>" scrolling="no" frameborder="0" marginheight="0" marginwidth="0" vspace="0" hspace="0"></iframe><br><a target="_blank" href="http://www.portaldowebmaster.com/trocabanners/"><img src="http://www.portaldowebmaster.com/trocabanners/<?php echo $size["width"];?>.gif" border=0></a></center></textarea></td> </tr> <? } ?> </table> <br> </td> </tr> </table> </form> <? }// end main include_once "template.php"; ?>Não da erro algum se algupem se interresar em me ajudar o script esta online para testa-lo percebi que os codigo gerados é sempre o mesmo e não faz a rotatividade do banner
Link para o comentário
Compartilhar em outros sites
4 respostass a esta questão
Posts Recomendados
Participe da discussão
Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.