Henrique.nick
-
Total de itens
4 -
Registro em
-
Última visita
Tudo que Henrique.nick postou
-
Alguém que saiba PHP + Mysql Ajude-me! Por favor!
pergunta respondeu ao Henrique.nick de Henrique.nick em PHP
ESerra Certo, eu coloquei varchar e isso já me ajudaria porque n existe nenhum calculo em cima do número digitado, entaum poderia ser varchar tranquilo. Mas a bronca é que existe uma mascara nesse script q ainda n permite que eu coloque vírgula. O proprio PHP tá impedindo e eu n to conseguindo add essa permissão sem afetar outras coisas. -
Alguém que saiba PHP + Mysql Ajude-me! Por favor!
pergunta respondeu ao Henrique.nick de Henrique.nick em PHP
ESerra Eu entendi e obrigado. Mas ainda estou com problema. O caso é o seguinte, o meu site funciona igual o Mercado Livre, é o próprio usuário quem preenche o preço do produto. Logo complica para cada usuário saber que ele tem que colocar 1.000,00 assim 1000.00 Se eu quiser colocar no nome do produto isto "1.000,00" o nome do produto fica exatamente assim. Logo esse campo aceita normal qualquer tipo de caractere e é isto que eu queria. Gostaria de deixar o preço como um campo livre para se digitar o que quiser da forma que quiser mas n to sabendo tirar a mascara que existe hj nesse código sem afeta-lo. -
Pessoal, É a segunda vez q posto... Exista alguém que conhece pra me ajudar? Tenho um script em PHP + Mysql Ele funciona perfeitamente do jeito que está! Minha bronca é a seguinte: Ele só registra valores dos preços dos produtos com ' . ' (ponto) se eu colocar virgula ele diz que o caractere n é válido. Preciso tirar essa mascara ou add a permissão para colocar vírgula nesse campo mas n to conseguindo... Por favor... Ajudem-me! Obrigado. Sou novo aqui, perdoem-me qualquer erro no forúm! O NOME DO CAMPO ONDE DIGITO O VALOR É "MIN_BID" Segue o código ------------------------------------------------------------------------------------------------------ <? include_once "logincheck.php"; include_once "myconnect.php"; include_once "left_mem.php"; function RTESafe($strText) { //returns safe code for preloading in the RTE $tmpString = trim($strText); //convert all types of single quotes $tmpString = str_replace(chr(145), chr(39), $tmpString); $tmpString = str_replace(chr(146), chr(39), $tmpString); $tmpString = str_replace("'", "'", $tmpString); //convert all types of double quotes $tmpString = str_replace(chr(147), chr(34), $tmpString); $tmpString = str_replace(chr(148), chr(34), $tmpString); // $tmpString = str_replace("\"", "\"", $tmpString); //replace carriage returns & line feeds $tmpString = str_replace(chr(10), " ", $tmpString); $tmpString = str_replace(chr(13), " ", $tmpString); return $tmpString; } function main() { $product_name=""; $cat1=""; $aucid=""; $location=""; $quantity=""; $rte1=""; $ship_cost=0; $who_pay_sc=""; $auction_period=""; $auto_list=""; $min_bid=""; $max_price=0; $featured=""; $fp_featured=""; $highlight=""; $radio=""; $buy_price=""; $paypal_id=""; if(count($_POST)>0) { $product_name=$_POST["product_name"]; $cat1=$_POST["cat1"]; $aucid=$_POST["aucid"]; $location=$_POST["location"]; $quantity=$_POST["quantity"]; $rte1=$_POST["rte1"]; $ship_cost=$_POST["ship_cost"]; $who_pay_sc=$_POST["who_pay_sc"]; $auction_period=$_POST["auction_period"]; $auto_list=$_POST["auto_list"]; $min_bid=$_POST["min_bid"]; $max_price=$_POST["max_price"]; if(isset($_POST["featured"])) { $featured=$_POST["featured"]; } if(isset($_POST["fp_featured"])) { $fp_featured=$_POST["fp_featured"]; } if(isset($_POST["highlight"])) { $highlight=$_POST["highlight"]; } $radio=$_POST["radio"]; $buy_price=$_POST["buy_price"]; $paypal_id=$_POST["paypal_id"]; } $rate=mysql_fetch_array(mysql_query("select * from sbauctions_config")); $cur=mysql_fetch_array(mysql_query("select * from sbauctions_currency where id=".$rate["cur_id"])); $balance=mysql_fetch_array(mysql_query("select sum(amount) as total from sbauctions_transactions where uid=".$_SESSION["userid"]." group by uid")); if(!$balance) { $total=0; } else { $total=$balance["total"]; } ?> <script language="JavaScript" type="text/javascript" src="richtext.js"></script> <script language="javascript"> //<!-- function emailCheck (emailStr) { var emailPat=/^(.+)@(.+)$/ var specialChars="\\(\\)<>@,;:\\\\\\\"\\.\\[\\]" var validChars="\[^\\s" + specialChars + "\]" var quotedUser="(\"[^\"]*\")" var ipDomainPat=/^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/ var atom=validChars + '+' var word="(" + atom + "|" + quotedUser + ")" var userPat=new RegExp("^" + word + "(\\." + word + ")*$") var domainPat=new RegExp("^" + atom + "(\\." + atom +")*$") var matchArray=emailStr.match(emailPat) if (matchArray==null) { alert("Paypal ID seems incorrect (check @ and .'s)") return false } var user=matchArray[1] var domain=matchArray[2] if (user.match(userPat)==null) { alert("The username doesn't seem to be valid.") return false } var IPArray=domain.match(ipDomainPat) if (IPArray!=null) { // this is an IP address for (var i=1;i<=4;i++) { if (IPArray[i]>255) { alert("Destination IP address is invalid!") return false } } return true } var domainArray=domain.match(domainPat) if (domainArray==null) { alert("The domain name doesn't seem to be valid.") return false } var atomPat=new RegExp(atom,"g") var domArr=domain.match(atomPat) var len=domArr.length if (domArr[domArr.length-1].length<2 || domArr[domArr.length-1].length>3) { alert("The address must end in a three-letter domain, or two letter country.") return false } if (len<2) { var errStr="This address is missing a hostname!" alert(errStr) return false } return true; } function total_check(form) { var t=0; switch(form.aucid.selectedIndex) { case 1: t=t+<? echo $rate["auction_item_fees"];?>; break; case 2: t=t+<? echo $rate["dutch_item_fees"];?>; break; case 3: t=t+<? echo $rate["fixed_item_fees"];?>; break; case 4: t=t+<? echo $rate["classified_item_fees"];?>; break; } if(form.featured.checked==true) { t=t+<? echo $rate["featured_rate"];?>; } if(form.fp_featured.checked==true) { t=t+<? echo $rate["fp_featured_rate"];?>; } if(form.highlight.checked==true) { t=t+<? echo $rate["highlight_rate"];?>; } <? if($total>=$rate["buy_now"]) { ?> if(form.paypal_id.value!="") { t=t+<? echo $rate["buy_now"];?>; } <? } ?> if(t > <? echo $total;?>) { //t=round(t,2); alert('O custo total para este anúncio excede o saldo da sua conta.\n\nO saldo atual da sua conta é \t= <? echo $cur["cur_name"].$total;?>\nO custo Total para este anúncio é\t\t= <? echo $cur["cur_name"];?>'+t+'\n\nPor favor, remova alguns recursos pagos para continuar.'); return false; } else { //t=round(t,2); return confirm('O saldo atual da sua conta é \t= <? echo $cur["cur_name"].$total;?>\nO custo total para este anúncio é\t= <? echo $cur["cur_name"];?>'+t+'\n\nDeseja continuar?'); } } function Validate(form) { updateRTEs(); if(form.product_name.value == "") { alert('Digite o nome do produto.'); form.product_name.focus(); return false; } if(form.product_name.value.match(/[&<>]+/)) { alert("Por favor, remova caracteres inválidos de Nome do Produto (e.g. & < >)"); form.product_name.focus(); return(false); } if(form.cat1.value == "") { alert('Por favor, escolha uma categoria para o produto'); form.cat1.focus(); return false; } if(form.aucid.value == "") { alert('Por favor, escolha um tipo de anúncio válido'); form.aucid.focus(); return false; } if(form.location.value == "") { alert('Por favor, indique a localização do produto.'); form.location.focus(); return false; } if(form.location.value.match(/[&<>]+/)) { alert("Por favor, remova os caracteres inválidos a partir da localização do produto (e.g. & < >)"); form.location.focus(); return(false); } if(form.quantity.value == "") { alert('Por favor, indique a quantidade disponível do produto.'); form.quantity.focus(); return false; } if(form.quantity.value.match(/[&<>]+/)) { alert("Por favor, remova caracteres inválidos de quantidade disponível do produto (e.g. & < >)"); form.quantity.focus(); return(false); } if(isNaN(form.quantity.value)||form.quantity.value<=0) { alert('Por favor, indique um valor numérico não negativo para a quantidade disponível.'); form.quantity.focus(); return false; } if(form.rte1.value == "") { alert('Por favor, digite a descrição do produto.'); return false; } if(isNaN(form.ship_cost.value) || (form.ship_cost.value<0)) { alert('Por favor, indique valor numérico não negativo para o custo de entrega.'); form.ship_cost.focus(); return false; } if(isNaN(form.min_bid.value) || (form.min_bid.value == "") || (form.min_bid.value <=0)) { alert('Por favor, indique valor numérico não negativo para lance mínimo do produto.'); form.min_bid.focus(); return false; } return total_check(form); } function submit_form() { document.frm1.action="insert_product.php"; if(Validate(document.frm1)) { document.frm1.target="_self"; document.frm1.submit(); } else { return false; } } function submit_form2() { document.frm1.action="preview_product.php"; if(Validate(document.frm1)) { // window.open("preview","win","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=330,height=420,loca tion=no,directories=no,scrollbars=yes"); document.frm1.target="preview"; document.frm1.submit(); } else { return false; } } //--> </script> </head> <style type="text/css"> <!-- .onepxtable tr td div font b font strong font b { color: #333; font-size: 12px; } .jk {color: #C60001 [; font-weight: bold; font-family: Arial, Helvetica, sans-serif; color: #666; } .ytr {font-size: 14px; } .ççç { color: #666; font-weight: bold; font-size: 14px; } .onepxtable tr td div font b font strong font { font-family: Arial, Helvetica, sans-serif; } --> </style> <body> <table width="939" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <tr> <td colspan="2" valign="top"> </td> </tr> <tr> <td width="9%" valign="top"> <p> </p></td> <td width="91%" valign="top"><table width="99%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <tr> <td valign="top" bgcolor="#FFFFFF"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr align="center"> <td valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><? $min_item_fees=$rate["auction_item_fees"]; if($rate["dutch_item_fees"]<$min_item_fees) $min_item_fees=$rate["dutch_item_fees"]; if($rate["fixed_item_fees"]<$min_item_fees) $min_item_fees=$rate["fixed_item_fees"]; if($rate["classified_item_fees"]<$min_item_fees) $min_item_fees=$rate["classified_item_fees"]; if($min_item_fees>$total) { ?> <font color="#FF0000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong> Your current Balance is <? echo $cur["cur_name"]; echo $total;?>.You must have more than <? echo $cur["cur_name"]; echo $min_item_fees;?> to post an item. </strong></font> <font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><a href="addmoney.php" class="insidelink"><br> Add Money</a></strong></font> <? } else { ?> <table width="229" height="55" border="5" align="center" cellpadding="2" cellspacing="0" bordercolor="f8f8f8" bgcolor="#f8f8f8"> <tr> <td width="213" bgcolor="ce0002"><div align="center"><font color="#ce0002" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong> <font color="#FFFFFF">Seu saldo atual é<? echo $cur["cur_name"];?><? echo $total;?></font><br> </strong><a href="addmoney.php" class="insidelink"><font color="#FFFF00" size="1"><strong>Adicionar mais dinheiro</strong></font></a></font></div></td> </tr> </table> <div align="left"></div></td> </tr> <tr align="center"> <td height="31" valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"> <p class="ççç"><span class="ytr"><span class="jk">Adicionar um produto</span></span> </p> </div></td> </tr> <tr> <td height="25" align="left" valign="top" bordercolor="#FFFFFF"><form name="frm1" onSubmit="return Validate(this);" method="post"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="5" bgcolor="#FFFFFF" class="onepxtable"> <tr bgcolor="#CCCCCC"> <td height="25" colspan="3" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><FONT color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>INFORMAÇÕES GERAIS</b></font></strong></FONT></b></font></div></td> </tr> <tr> <td width="37%" height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Nome do Produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td width="62%" valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="product_name" style="font-family: courier,monospace;" MAXLENGTH="120" SIZE="50" value="<? echo $product_name;?>"> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Categoria :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <TD valign="middle" bgcolor="#FFFFFF"> <div align="left"><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#666666"> </font><font size="2" face="Arial, Helvetica, sans-serif"> <select style="font-family: Arial, Helvetica, sans-serif" name="cat1" id="select" > <option value="" selected>Selecionar</option> <? $rs_query=mysql_query("select * from sbauctions_categories order by pid"); while($rst=mysql_fetch_array($rs_query)) { $cat_path=""; $child=mysql_fetch_array(mysql_query("select * from sbauctions_categories where pid=".$rst["id"])); if($child) { continue; } $cat_path.=$rst["cat_name"]; $par=mysql_query("select * from sbauctions_categories where id=".$rst["pid"]); while($parent=mysql_fetch_array($par)) { $cat_path=$parent["cat_name"].">".$cat_path; $par=mysql_query("select * from sbauctions_categories where id=".$parent["pid"]); } ?> <option value="<? echo $rst["id"];?>" <? if($cat1==$rst["id"]) echo "selected";?>><? echo $cat_path;?></option> <? } ?> </select> </font><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><br> </font></div></TD> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Tipo do Anuncio :</b> </font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <select style="font-family: Arial, Helvetica, sans-serif" name="aucid"> <option value="" selected>Selecionar</option> <? $cats=mysql_query("select * from sbauctions_auction_types order by id"); while($rst=mysql_fetch_array($cats)) { ?> <option value="<? echo $rst["id"]; ?>" <? if($aucid==$rst["id"]) echo " selected"; ?>><? echo $rst["auction_name"]; ?> ( <? echo $cur["cur_name"]; switch($rst["id"]) { case 1: echo $rate["auction_item_fees"]; break; case 2: echo $rate["dutch_item_fees"]; break; case 3: echo $rate["fixed_item_fees"]; break; case 4: echo $rate["classified_item_fees"]; break; } ?> )</option> <? }//end while ?> </select> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Localização :</b></font><font size="2" face="Arial, Helvetica, sans-serif"> </font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="location" type="text" style="font-family: courier,monospace;" value="<? echo $location;?>" SIZE="25" MAXLENGTH="255"> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><b>Quantidade disponível do produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="quantity" type="text" style="font-family: courier,monospace;" value="<? echo $quantity;?>" SIZE="4" MAXLENGTH="10"> </font></td> </tr> <tr> <td width="37%" height="36" align="left" valign="middle" bgcolor="#F8F8F8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Descrição do Produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></TD> <TD valign="middle" bgcolor="#FFFFFF"> <script language="JavaScript" type="text/javascript"> <!-- <? $content = $rte1; $content = RTESafe($content); ?>//Usage: initRTE(imagesPath, includesPath, cssFile) initRTE("images/", "", ""); //Usage: writeRichText(fieldname, html, width, height, buttons) writeRichText('rte1', '<?=$content?>', 450, 200, true, false); //uncomment the following to see a demo of multiple RTEs on one page //document.writeln('<br><br>'); //writeRichText('rte2', 'read-only text', 450, 100, true, false); //--> </script> <noscript> </noscript></TD> </tr> <tr bgcolor="#CCCCCC"> <td height="24" colspan="3" bgcolor="#FFFFFF"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td> </tr> <tr bgcolor="#CCCCCC"> <td height="28" colspan="3" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>INFORMAÇÕES ESPECÍFICAS</b></font></b></font></strong></font></b></font></div></td> </tr> <tr> <td width="37%" height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Custo do envio :</b> </font></div></td> <td width="1%" align="center" valign="middle"> </td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="ship_cost" MAXLENGTH="120" SIZE="10" style="font-family: courier,monospace;" value=<? echo $ship_cost;?>> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b><SPAN id="result_box"><SPAN title="Who will pay Shipping Cost:" closure_hashCode_dieh8r="22">Quem pagar o envio </SPAN></SPAN>:</b> </font></div></td> <TD align=center valign="middle"> </TD> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="who_pay_sc"> <option value="seller">Vendedor</option> <option value="buyer">Comprador</option> </select> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Duração do anúncio </b><font size="1">(em dias) </font><b>:</b> </font></div></td> <td align="center" valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="auction_period"> <? for($i=1; $i<=$rate["max_period"];$i++) { ?> <option value="<? echo $i; ?>" selected <? if($auction_period==$i) echo "selected";?>><? echo $i; ?></option> <? } ?> </select> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Auto Recadastrar :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="auto_list"> <option value="0">Nenhuma vez</option> <option value="1">1 vez</option> <option value="2">2 vezes</option> <option value="3">3 vezes</option> </select> <br> <font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">Se o seu produto não for vendido.</font></font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Preço :</b> </font></div></td> <td align="center" valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="min_bid" MAXLENGTH="120" SIZE="10" style="font-family: courier,monospace;" value="<? echo $min_bid;?>"> </font></td> </tr> <tr> <td height="27" colspan="3" align="left" valign="middle"> </td> </tr> <tr> <td height="28" colspan="3" align="left" valign="middle" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>OPÇÕES DE DESTAQUE</b></font></b></font></strong></font></b></font></div></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Primeiros lugares nas buscas :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <input type="checkbox" name="featured" value="yes" <? if($featured<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Lista Destaque ( Taxa R$ <? echo $rate["featured_rate"];?> )</b></font><font size="2" face="Arial, Helvetica, sans-serif"><br> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Ganhe destaque nos resultados das buscas</font></font></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Aparecer na Página Inicial :</b> <font size="2" face="Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br> </font></font></font></div></td> <td align="center" valign="middle"> </td> <td> <input name="fp_featured" type="checkbox" id="fp_featured" value="yes" <? if($fp_featured<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Página Inicial ( Taxa R$ <? echo $rate["fp_featured_rate"];?> )</b></font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <br> Escolhidos aleatoriamente pelo sistema</font></font><b> </b></font></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><b>Aparecer com Cor Diferenciada :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <input type="checkbox" name="highlight" value="yes" <? if($highlight<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Super Destaque ( Taxa R$ <? echo $rate["highlight_rate"];?> )</b></font> <font size="2" face="Arial, Helvetica, sans-serif"><br> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Seu anuncio aparecerá com cor de fundo diferenciada</font></font></td> </tr> <tr> <td height="25" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Contador de Visualizações :</b> <input name="buy_price" type="hidden" id="buy_price" style="font-family: courier,monospace;" value="<? echo $buy_price;?>" size="10" maxlength="120"> <input name="paypal_id" type="hidden" id="paypal_id2" style="font-family: courier,monospace;" value="<? echo $paypal_id;?>" size="25" maxlength="120"> </font></div></td> <td align="center" valign="middle"> </td> <td valign="top"> <table border="0" cellspacing="5" cellpadding="0"> <tr> <TD align=left valign="middle"> <input type="radio" name="radio" value="0" checked></TD> <td colspan="10"><font size="2" face="Arial, Helvetica, sans-serif"><b>Sem contador </b></font></td> </tr> <? $sql=mysql_query("select * from sbauctions_counters"); $cnt=1; while($counter=mysql_fetch_array($sql)) {?> <TR> <TD align=left valign="middle"><input type="radio" name="radio" value="<? echo $cnt;?>" <? if($radio==$cnt) { echo " checked";} ?>></TD> <TD align=left valign="middle"><img src="admin/uploadedimages/<? echo $counter["zero"];?>"></TD> <TD valign="middle"><img src="admin/uploadedimages/<? echo $counter["one"];?>"></TD> <TD valign="middle"><img src="admin/uploadedimages/<? echo $counter["two"];?>"></TD> <TD valign="middle"><img src="admin/uploadedimages/<? echo $counter["three"];?>"></TD> </TR> <? $cnt++;}?> </table></td> </tr> <tr> <td height="45" valign="middle" bgcolor="#f8f8f8"><font size="2" face="Arial, Helvetica, sans-serif"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="max_price" type="text" id="max_price" style="font-family: courier,monospace;" value=<? echo $max_price;?> size="10" maxlength="120"> </font></font></td> <td align="center" valign="middle"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td> <td><font size="2" face="Arial, Helvetica, sans-serif"> <INPUT type=button value="Concluir" name=Button onClick="submit_form();"> <input type="button" name="Button" value="Visualizar" onClick="submit_form2();"> </font></td> </tr> </table> </form> <? }?> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td colspan="2"> </td> </tr> </table> <? }// end main include "template.php"; ?> [/codebox]------------------------------------------------------------------------------------------------------
-
Pessoal, Tenho um script em PHP + Mysql Ele funciona perfeitamente do jeito que está! Minha bronca é a seguinte: Ele só registra valores dos preços dos produtos com ' . ' (ponto) se eu colocar virgula ele diz que o caractere n é válido. Então eu fui no script e modifiquei para deixar livre o campo, mas acontece o seguinte: Ele registra os dados por cima do produto que eu cadastrei anteriormente. Entederam: se eu colocar o valor do produto tipo : 1.000 tudo bem ele aceita e cria um novo produto se eu colocar 1.000,55 ou 33,33 ele apenas joga dos dados por cima do produto anterior. vou a página do script onde se encontra o problema! Por favor... Ajudem-me! Obrigado. Sou novo aqui, perdoem-me qualquer erro no forúm! O NOME DO CAMPO ONDE DIGITO O VALOR É "MIN_BID" Segue o código ------------------------------------------------------------------------------------------------------ <? include_once "logincheck.php"; include_once "myconnect.php"; include_once "left_mem.php"; function RTESafe($strText) { //returns safe code for preloading in the RTE $tmpString = trim($strText); //convert all types of single quotes $tmpString = str_replace(chr(145), chr(39), $tmpString); $tmpString = str_replace(chr(146), chr(39), $tmpString); $tmpString = str_replace("'", "'", $tmpString); //convert all types of double quotes $tmpString = str_replace(chr(147), chr(34), $tmpString); $tmpString = str_replace(chr(148), chr(34), $tmpString); // $tmpString = str_replace("\"", "\"", $tmpString); //replace carriage returns & line feeds $tmpString = str_replace(chr(10), " ", $tmpString); $tmpString = str_replace(chr(13), " ", $tmpString); return $tmpString; } function main() { $product_name=""; $cat1=""; $aucid=""; $location=""; $quantity=""; $rte1=""; $ship_cost=0; $who_pay_sc=""; $auction_period=""; $auto_list=""; $min_bid=""; $max_price=0; $featured=""; $fp_featured=""; $highlight=""; $radio=""; $buy_price=""; $paypal_id=""; if(count($_POST)>0) { $product_name=$_POST["product_name"]; $cat1=$_POST["cat1"]; $aucid=$_POST["aucid"]; $location=$_POST["location"]; $quantity=$_POST["quantity"]; $rte1=$_POST["rte1"]; $ship_cost=$_POST["ship_cost"]; $who_pay_sc=$_POST["who_pay_sc"]; $auction_period=$_POST["auction_period"]; $auto_list=$_POST["auto_list"]; $min_bid=$_POST["min_bid"]; $max_price=$_POST["max_price"]; if(isset($_POST["featured"])) { $featured=$_POST["featured"]; } if(isset($_POST["fp_featured"])) { $fp_featured=$_POST["fp_featured"]; } if(isset($_POST["highlight"])) { $highlight=$_POST["highlight"]; } $radio=$_POST["radio"]; $buy_price=$_POST["buy_price"]; $paypal_id=$_POST["paypal_id"]; } $rate=mysql_fetch_array(mysql_query("select * from sbauctions_config")); $cur=mysql_fetch_array(mysql_query("select * from sbauctions_currency where id=.$rate["cur_id])); $balance=mysql_fetch_array(mysql_query("select sum(amount) as total from sbauctions_transactions where uid=".$_SESSION["userid"]." group by uid")); if(!$balance) { $total=0; } else { $total=$balance["total"]; } ?> <script language=JavaScript" type="text/javascript" src="richtext.js"></script> <script language="javascript"> //<!-- function emailCheck (emailStr) { var emailPat=/^(.+)@(.+)$/ var specialChars="\\(\\)<>@,;:\\\\\\\"\\.\\[\\]" var validChars="\[^\\s" + specialChars + "\]" var quotedUser="(\"[^\]*\")" var ipDomainPat=/^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/ var atom=validChars + '+' var word=(" + atom + "|" + quotedUser + ")" var userPat=new RegExp("^" + word + "(\\." + word + ")*$") var domainPat=new RegExp("^" + atom + "(\\." + atom +")*$") var matchArray=emailStr.match(emailPat) if (matchArray==null) { alert("Paypal ID seems incorrect (check @ and .'s)") return false } var user=matchArray[1] var domain=matchArray[2] if (user.match(userPat)==null) { alert("The username doesn't seem to be valid.") return false } var IPArray=domain.match(ipDomainPat) if (IPArray!=null) { // this is an IP address for (var i=1;i<=4;i++) { if (IPArray>255) { alert("Destination IP address is invalid!") return false } } return true } var domainArray=domain.match(domainPat) if (domainArray==null) { alert("The domain name doesn't seem to be valid.") return false } var atomPat=new RegExp(atom,"g") var domArr=domain.match(atomPat) var len=domArr.length if (domArr[domArr.length-1].length<2 || domArr[domArr.length-1].length>3) { alert("The address must end in a three-letter domain, or two letter country.") return false } if (len<2) { var errStr="This address is missing a hostname!" alert(errStr) return false } return true; } function total_check(form) { var t=0; switch(form.aucid.selectedIndex) { case 1: t=t+<? echo $rate["auction_item_fees];?>; break; case 2: t=t+<? echo $rate["dutch_item_fees"];?>; break; case 3: t=t+<? echo $rate["fixed_item_fees"];?>; break; case 4: t=t+<? echo $rate["classified_item_fees"];?>; break; } if(form.featured.checked==true) { t=t+<? echo $rate["featured_rate"];?>; } if(form.fp_featured.checked==true) { t=t+<? echo $rate["fp_featured_rate"];?>; } if(form.highlight.checked==true) { t=t+<? echo $rate["highlight_rate"];?>; } <? if($total>=$rate["buy_now"]) { ?> if(form.paypal_id.value!=") { t=t+<? echo $rate["buy_now];?>; } <? } ?> if(t > <? echo $total;?>) { //t=round(t,2); alert('O custo total para este anúncio excede o saldo da sua conta.\n\nO saldo atual da sua conta é \t= <? echo $cur["cur_name"].$total;?>\nO custo Total para este anúncio é\t\t= <? echo $cur["cur_name"];?>'+t+'\n\nPor favor, remova alguns recursos pagos para continuar.'); return false; } else { //t=round(t,2); return confirm('O saldo atual da sua conta é \t= <? echo $cur["cur_name"].$total;?>\nO custo total para este anúncio é\t= <? echo $cur["cur_name"];?>'+t+'\n\nDeseja continuar?'); } } function Validate(form) { updateRTEs(); if(form.product_name.value == "") { alert('Digite o nome do produto.'); form.product_name.focus(); return false; } if(form.product_name.value.match(/[&<>]+/)) { alert("Por favor, remova caracteres inválidos de Nome do Produto (e.g. & < >)"); form.product_name.focus(); return(false); } if(form.cat1.value == "") { alert('Por favor, escolha uma categoria para o produto'); form.cat1.focus(); return false; } if(form.aucid.value == "") { alert('Por favor, escolha um tipo de anúncio válido'); form.aucid.focus(); return false; } if(form.location.value == "") { alert('Por favor, indique a localização do produto.'); form.location.focus(); return false; } if(form.location.value.match(/[&<>]+/)) { alert("Por favor, remova os caracteres inválidos a partir da localização do produto (e.g. & < >)"); form.location.focus(); return(false); } if(form.quantity.value == "") { alert('Por favor, indique a quantidade disponível do produto.'); form.quantity.focus(); return false; } if(form.quantity.value.match(/[&<>]+/)) { alert("Por favor, remova caracteres inválidos de quantidade disponível do produto (e.g. & < >)"); form.quantity.focus(); return(false); } if(isNaN(form.quantity.value)||form.quantity.value<=0) { alert('Por favor, indique um valor numérico não negativo para a quantidade disponível.'); form.quantity.focus(); return false; } if(form.rte1.value == "") { alert('Por favor, digite a descrição do produto.'); return false; } if(isNaN(form.ship_cost.value) || (form.ship_cost.value<0)) { alert('Por favor, indique valor numérico não negativo para o custo de entrega.'); form.ship_cost.focus(); return false; } if(isNaN(form.min_bid.value) || (form.min_bid.value == "") || (form.min_bid.value <=0)) { alert('Por favor, indique valor numérico não negativo para lance mínimo do produto.'); form.min_bid.focus(); return false; } return total_check(form); } function submit_form() { document.frm1.action=insert_product.php"; if(Validate(document.frm1)) { document.frm1.target="_self"; document.frm1.submit(); } else { return false; } } function submit_form2() { document.frm1.action="preview_product.php"; if(Validate(document.frm1)) { // window.open("preview","win","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=330,height=420,location=no,directories=no,scrollbars=yes"); document.frm1.target="preview"; document.frm1.submit(); } else { return false; } } //--> </script> </head> <style type="text/css"> <!-- .onepxtable tr td div font b font strong font b { color: #333; font-size: 12px; } .jk {color: #C60001 [; font-weight: bold; font-family: Arial, Helvetica, sans-serif; color: #666; } .ytr {font-size: 14px; } .ççç { color: #666; font-weight: bold; font-size: 14px; } .onepxtable tr td div font b font strong font { font-family: Arial, Helvetica, sans-serif; } --> </style> <body> <table width="939" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <tr> <td colspan="2" valign="top"> </td> </tr> <tr> <td width="9%" valign="top"> <p> </p></td> <td width="91%" valign="top"><table width="99%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <tr> <td valign="top" bgcolor="#FFFFFF"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr align="center"> <td valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><? $min_item_fees=$rate["auction_item_fees]; if($rate["dutch_item_fees"]<$min_item_fees) $min_item_fees=$rate["dutch_item_fees"]; if($rate["fixed_item_fees"]<$min_item_fees) $min_item_fees=$rate["fixed_item_fees"]; if($rate["classified_item_fees"]<$min_item_fees) $min_item_fees=$rate["classified_item_fees"]; if($min_item_fees>$total) { ?> <font color=#FF0000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong> Your current Balance is <? echo $cur["cur_name]; echo $total;?>.You must have more than <? echo $cur["cur_name"]; echo $min_item_fees;?> to post an item. </strong></font> <font color=#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><a href="addmoney.php" class="insidelink"><br> Add Money</a></strong></font> <? } else { ?> <table width="229" height="55" border="5" align="center" cellpadding="2" cellspacing="0" bordercolor="f8f8f8" bgcolor="#f8f8f8"> <tr> <td width="213" bgcolor="ce0002"><div align="center"><font color="#ce0002" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong> <font color="#FFFFFF">Seu saldo atual é<? echo $cur["cur_name];?><? echo $total;?></font><br> </strong><a href="addmoney.php" class="insidelink"><font color="#FFFF00" size="1"><strong>Adicionar mais dinheiro</strong></font></a></font></div></td> </tr> </table> <div align="left"></div></td> </tr> <tr align="center"> <td height="31" valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"> <p class="ççç"><span class="ytr"><span class="jk">Adicionar um produto</span></span> </p> </div></td> </tr> <tr> <td height="25" align="left" valign="top" bordercolor="#FFFFFF"><form name="frm1" onSubmit="return Validate(this);" method="post"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="5" bgcolor="#FFFFFF" class="onepxtable"> <tr bgcolor="#CCCCCC"> <td height="25" colspan="3" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><FONT color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>INFORMAÇÕES GERAIS</b></font></strong></FONT></b></font></div></td> </tr> <tr> <td width="37%" height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Nome do Produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td width="62%" valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="product_name" style="font-family: courier,monospace;" MAXLENGTH="120" SIZE="50" value="<? echo $product_name;?>"> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Categoria :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <TD valign="middle" bgcolor="#FFFFFF"> <div align="left"><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#666666"> </font><font size="2" face="Arial, Helvetica, sans-serif"> <select style="font-family: Arial, Helvetica, sans-serif" name="cat1" id="select" > <option value="" selected>Selecionar</option> <? $rs_query=mysql_query("select * from sbauctions_categories order by pid"); while($rst=mysql_fetch_array($rs_query)) { $cat_path=""; $child=mysql_fetch_array(mysql_query("select * from sbauctions_categories where pid=".$rst["id"])); if($child) { continue; } $cat_path.=$rst["cat_name"]; $par=mysql_query("select * from sbauctions_categories where id=.$rst["pid]); while($parent=mysql_fetch_array($par)) { $cat_path=$parent["cat_name"].">".$cat_path; $par=mysql_query("select * from sbauctions_categories where id=.$parent["pid]); } ?> <option value="<? echo $rst["id"];?>" <? if($cat1==$rst["id"]) echo "selected";?>><? echo $cat_path;?></option> <? } ?> </select> </font><font color=#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><br> </font></div></TD> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Tipo do Anuncio :</b> </font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <select style="font-family: Arial, Helvetica, sans-serif" name="aucid"> <option value="" selected>Selecionar</option> <? $cats=mysql_query("select * from sbauctions_auction_types order by id"); while($rst=mysql_fetch_array($cats)) { ?> <option value="<? echo $rst["id]; ?>" <? if($aucid==$rst["id"]) echo " selected"; ?>><? echo $rst["auction_name"]; ?> ( <? echo $cur["cur_name"]; switch($rst["id"]) { case 1: echo $rate["auction_item_fees"]; break; case 2: echo $rate["dutch_item_fees"]; break; case 3: echo $rate["fixed_item_fees"]; break; case 4: echo $rate["classified_item_fees"]; break; } ?> )</option> <? }//end while ?> </select> </font></td> </tr> <tr> <td height=40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Localização :</b></font><font size="2" face="Arial, Helvetica, sans-serif"> </font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="location" type="text" style="font-family: courier,monospace;" value="<? echo $location;?>" SIZE="25" MAXLENGTH="255"> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><b>Quantidade disponível do produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><div align="center"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></div></TD> <td valign="middle" bgcolor="#FFFFFF"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="quantity" type="text" style="font-family: courier,monospace;" value="<? echo $quantity;?>" SIZE="4" MAXLENGTH="10"> </font></td> </tr> <tr> <td width="37%" height="36" align="left" valign="middle" bgcolor="#F8F8F8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Descrição do Produto :</b> <b> </b></font></div></td> <TD align=center valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></TD> <TD valign="middle" bgcolor="#FFFFFF"> <script language="JavaScript" type="text/javascript"> <!-- <? $content = $rte1; $content = RTESafe($content); ?>//Usage: initRTE(imagesPath, includesPath, cssFile) initRTE("images/", "", ""); //Usage: writeRichText(fieldname, html, width, height, buttons) writeRichText('rte1', '<?=$content?>', 450, 200, true, false); //uncomment the following to see a demo of multiple RTEs on one page //document.writeln('<br><br>'); //writeRichText('rte2', 'read-only text', 450, 100, true, false); //--> </script> <noscript> </noscript></TD> </tr> <tr bgcolor="#CCCCCC"> <td height="24" colspan="3" bgcolor="#FFFFFF"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td> </tr> <tr bgcolor="#CCCCCC"> <td height="28" colspan="3" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>INFORMAÇÕES ESPECÍFICAS</b></font></b></font></strong></font></b></font></div></td> </tr> <tr> <td width="37%" height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Custo do envio :</b> </font></div></td> <td width="1%" align="center" valign="middle"> </td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="ship_cost" MAXLENGTH="120" SIZE="10" style="font-family: courier,monospace;" value=<? echo $ship_cost;?>> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b><SPAN id="result_box"><SPAN title="Who will pay Shipping Cost:" closure_hashCode_dieh8r="22">Quem pagar o envio </SPAN></SPAN>:</b> </font></div></td> <TD align=center valign="middle"> </TD> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="who_pay_sc"> <option value="seller">Vendedor</option> <option value="buyer">Comprador</option> </select> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Duração do anúncio </b><font size="1">(em dias) </font><b>:</b> </font></div></td> <td align="center" valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="auction_period"> <? for($i=1; $i<=$rate["max_period];$i++) { ?> <option value="<? echo $i; ?>" selected <? if($auction_period==$i) echo "selected";?>><? echo $i; ?></option> <? } ?> </select> </font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Auto Recadastrar :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name="auto_list"> <option value="0">Nenhuma vez</option> <option value="1">1 vez</option> <option value="2">2 vezes</option> <option value="3">3 vezes</option> </select> <br> <font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">Se o seu produto não for vendido.</font></font></td> </tr> <tr> <td height="40" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Preço :</b> </font></div></td> <td align="center" valign="middle"><FONT color=red size=2 face="Arial, Helvetica, sans-serif">*</FONT></td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <input type="text" name="min_bid" MAXLENGTH="120" SIZE="10" style="font-family: courier,monospace;" value="<? echo $min_bid;?>"> </font></td> </tr> <tr> <td height="27" colspan="3" align="left" valign="middle"> </td> </tr> <tr> <td height="28" colspan="3" align="left" valign="middle" bgcolor="#F4F4F4"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color=#0099FF><strong><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>OPÇÕES DE DESTAQUE</b></font></b></font></strong></font></b></font></div></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Primeiros lugares nas buscas :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <input type="checkbox" name="featured" value="yes" <? if($featured<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Lista Destaque ( Taxa R$ <? echo $rate["featured_rate"];?> )</b></font><font size=2" face="Arial, Helvetica, sans-serif"><br> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Ganhe destaque nos resultados das buscas</font></font></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Aparecer na Página Inicial :</b> <font size="2" face="Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br> </font></font></font></div></td> <td align="center" valign="middle"> </td> <td> <input name="fp_featured" type="checkbox" id="fp_featured" value="yes" <? if($fp_featured<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Página Inicial ( Taxa R$ <? echo $rate["fp_featured_rate];?> )</b></font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <br> Escolhidos aleatoriamente pelo sistema</font></font><b> </b></font></td> </tr> <tr> <td height="50" align="left" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><b>Aparecer com Cor Diferenciada :</b> </font></div></td> <td align="center" valign="middle"> </td> <td> <input type="checkbox" name="highlight" value="yes" <? if($highlight<>"") echo " checked";?>> <font size="2" face="Arial, Helvetica, sans-serif"><b>Super Destaque ( Taxa R$ <? echo $rate["highlight_rate"];?> )</b></font> <font size=2" face="Arial, Helvetica, sans-serif"><br> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Seu anuncio aparecerá com cor de fundo diferenciada</font></font></td> </tr> <tr> <td height="25" valign="middle" bgcolor="#f8f8f8"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"> <b>Contador de Visualizações :</b> <input name="buy_price" type="hidden" id="buy_price" style="font-family: courier,monospace;" value="<? echo $buy_price;?>" size="10" maxlength="120"> <input name="paypal_id" type="hidden" id="paypal_id2" style="font-family: courier,monospace;" value="<? echo $paypal_id;?>" size="25" maxlength="120"> </font></div></td> <td align="center" valign="middle"> </td> <td valign="top"> <table border="0" cellspacing="5" cellpadding="0"> <tr> <TD align=left valign="middle"> <input type="radio" name="radio" value="0" checked></TD> <td colspan="10"><font size="2" face="Arial, Helvetica, sans-serif"><b>Sem contador </b></font></td> </tr> <? $sql=mysql_query("select * from sbauctions_counters"); $cnt=1; while($counter=mysql_fetch_array($sql)) {?> <TR> <TD align=left valign="middle"><input type="radio" name="radio" value="<? echo $cnt;?>" <? if($radio==$cnt) { echo " checked";} ?>></TD> <TD align=left valign="middle"><img src="admin/uploadedimages/<? echo $counter["zero];?>"></TD> <TD valign="middle"><img src="admin/uploadedimages/<? echo $counter["one"];?>"></TD> <TD valign=middle"><img src="admin/uploadedimages/<? echo $counter["two];?>"></TD> <TD valign="middle"><img src="admin/uploadedimages/<? echo $counter["three"];?>"></TD> </TR> <? $cnt++;}?> </table></td> </tr> <tr> <td height="45" valign="middle" bgcolor="#f8f8f8"><font size="2" face="Arial, Helvetica, sans-serif"> <font size="2" face="Arial, Helvetica, sans-serif"> <input name="max_price" type="text" id="max_price" style="font-family: courier,monospace;" value=<? echo $max_price;?> size="10" maxlength="120"> </font></font></td> <td align="center" valign="middle"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td> <td><font size="2" face="Arial, Helvetica, sans-serif"> <INPUT type=button value="Concluir" name=Button onClick="submit_form();"> <input type="button" name="Button" value="Visualizar" onClick="submit_form2();"> </font></td> </tr> </table> </form> <? }?> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td colspan="2"> </td> </tr> </table> <? }// end main include "template.php"; ?> ------------------------------------------------------------------------------------------------------