Só que consegui modificar todos os scripts de cadastro, exclusão e tal.. mas o de listar está me matando...
No script abaixo de nome LISTA.php exibe os Banners 120x60 e 468x60 , porem no meu site exite os banners 88x31 e 140x140.
Gostaria de poder exibir o banner 140x140 e trocar o 120x60 pelo 88x31, mas só vejo erro!
Alguem pode me ajudar?
<?php
$s = mysql_query("SELECT * FROM sistema WHERE tipo='1'");
$s2 = mysql_query("SELECT * FROM sistema WHERE tipo='2'");
$tam = $_GET['tam'];
$tbanner = $_POST['tbanner'];
$form = $_POST['form'];
echo'<font face="tahoma" size="2" color="#808080">';
//FORM
if($log=="1"){
if(empty($form)){
echo'
<form method="post" action="?banner=lista">
<strong><font color="#999999" size="2" face="Tahoma">Selecione o tamanho do banner que deseja visualizar:</font></strong><br>
<BR><select name="tbanner" size="1">
<option value="1"> 468x60 </option>
<option value="2"> 120x60 </option>
</select>
<input type="hidden" name="form" value="1">
<BR><BR><input type="submit" value=" ENTRAR >>">
</form>
';
}
$tbanner = $_POST['tbanner'];
//BANNER 468
if(isset($form) and ($tbanner=="1")){
$n = mysql_num_rows($s);
echo '<b>Banners 468x60:</b>';
if($n>0){
while($r=mysql_fetch_array($s)){
$img = $r[img];
$ext = substr($img, -3);
echo'
<table width="600" border="1" cellpadding="0" cellspacing="4" bordercolor="#E8E8E8">
<tr bordercolor="#F4F4F4">
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Nome:
</font></strong></div></td>
<td width="161"><div align="center"><font face="tahoma" size="2">'.$r[nomesite].'</div></td>
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Clicks:</font></strong></div></td>
<td width="66"><div align="center"><font face="tahoma" size="2">'.$r[clicks].'</div></td>
<td width="39"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Views:</font></strong></div></td>
<td width="86"><div align="center"><font face="tahoma" size="2">'.$r[views].'</div></td>
<td width="144"> <div align="center"><strong><font color="#FF0000" size="1" face="Tahoma">
<a href="?banner=deletar&id='.$r[id].'">DELETAR</a> </font></strong><font color="#666666" size="1" face="Tahoma"><font color="#CCCCCC">|</font><strong><font color="#009900">
<a href="?banner=info&id='.$r[id].'">+ INFO</a></font></strong></font></div></td>
</tr>
<tr bordercolor="#F9F9F9" bgcolor="#FFFFFF">
<td colspan="7"><center>
';
$img = $r[img];
$ext = substr($img, -3);
if(ereg("(gif|jpeg|jpg|png|bmp|psd)", $ext)){
echo '
<a href="'.$r[link].'" target="_blank"><img src="'.$r[img].'" alt="'.$r[alt].'" border="0"></a>';
} else {
echo "
<object classid=\"clsid: 27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" width=\"468\" height=\"60\">";
echo "
<param name=\"movie\" value=\"$img\">
<param name=\"quality\" value=\"high\">
<embed src=\"$img\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"468\" height=\"60\"></embed></object>";
}
echo'</td></tr></table><BR>';
}// endwhile
} else { echo '<BR><BR>Não há banners para este tamanho!'; }
}
//BANNER 120
if(isset($form) and ($tbanner=="2")){
$n2 = mysql_num_rows($s2);
echo '<b>Banners 120x60:</b>';
if($n2>0){
while($r2=mysql_fetch_array($s2)){
echo'
<table width="600" border="1" cellpadding="0" cellspacing="4" bordercolor="#E8E8E8">
<tr bordercolor="#F4F4F4">
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Nome:
</font></strong></div></td>
<td width="161"><div align="center"><font face="tahoma" size="2">'.$r2[nomesite].'</div></td>
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Clicks:</font></strong></div></td>
<td width="66"><div align="center"><font face="tahoma" size="2">'.$r2[clicks].'</div></td>
<td width="39"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Views:</font></strong></div></td>
<td width="86"><div align="center"><font face="tahoma" size="2">'.$r2[views].'</div></td>
<td width="144"> <div align="center"><strong><font color="#FF0000" size="1" face="Tahoma">
<a href="?banner=info&id='.$r2[id].'">DELETAR</a> </font></strong><font color="#666666" size="1" face="Tahoma"><font color="#CCCCCC">|</font><strong><font color="#009900">
<a href="?banner=info&id='.$r2[id].'">+ INFO</a></font></strong></font></div></td>
</tr>
<tr bordercolor="#F9F9F9" bgcolor="#FFFFFF"><center>
';
$img2 = $r2[img];
$ext2 = substr($img2, -3);
if(ereg("(gif|jpeg|jpg|png|bmp|psd)", $ext2)){
echo '
<a href="'.$r2[link].'" target="_blank"><img src="'.$r2[img].'" alt="'.$r2[alt].'" border="0"></a>';
} else {
echo "
<object classid=\"clsid: 27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" width=\"120\" height=\"60\">";
echo "
<param name=\"movie\" value=\"$img2\">
<param name=\"quality\" value=\"high\">
<embed src=\"$img2\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"120\" height=\"60\"></embed></object>";
}
echo'</td></tr></table><BR>';
}// endwhile
} else { echo '<BR><BR>Não há banners para este tamanho!'; }
}
}
if($log=="2"){
$s3 = mysql_query("SELECT * FROM sistema WHERE login='$l'");
$n3 = mysql_num_rows($s3);
if($n3>0){
echo'<font face="tahoma" size="2" color="#808080"><b>Seu banner:</b></font><BR><BR>';
while($r3=mysql_fetch_array($s3)){
echo'
<table width="600" border="1" cellpadding="0" cellspacing="4" bordercolor="#E8E8E8">
<tr bordercolor="#F4F4F4">
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Nome:
</font></strong></div></td>
<td width="161"><div align="center"><font face="tahoma" size="2">'.$r3[nomesite].'</div></td>
<td width="44"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Clicks:</font></strong></div></td>
<td width="66"><div align="center"><font face="tahoma" size="2">'.$r3[clicks].'</div></td>
<td width="39"><div align="center"><strong><font color="#666666" size="1" face="Tahoma">Views:</font></strong></div></td>
<td width="86"><div align="center"><font face="tahoma" size="2">'.$r3[views].'</div></td>
<td width="144"> <div align="center"><strong><font color="#FF0000" size="1" face="Tahoma">
<a href="?banner=modificar">MODIFICAR</a></font></strong></font></div></td>
</tr>
<tr bordercolor="#F9F9F9" bgcolor="#FFFFFF">
<td colspan="7"><center>';
$img3 = $r3[img];
$ext3 = substr($img3, -3);
if($r3[tipo]=="1"){ $t=1; } else { $t=2; }
if(ereg("(gif|jpeg|jpg|png|bmp|psd)", $ext3)){
echo '
<a href="'.$r3[link].'" target="_blank"><img src="'.$r3[img].'" alt="'.$r3[alt].'" border="0"></a>';
} else {
echo "
<center><object classid=\"clsid: 27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" width=\""; echo ($t=="1") ? "468" : "120"; echo "\" height=\"60\">";
echo "
<param name=\"movie\" value=\"$img3\">
<param name=\"quality\" value=\"high\">
<embed src=\"$img3\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\""; echo ($t=="1") ? "468" : "120"; echo "\" height=\"60\"></embed></object>";
}
echo'</td></tr></table><BR>';
}
}
}
?>
