function riducitesto($testo,$caratteri){
if(strlen($testo)>$caratteri){
$risultato=substr($testo,0,$caratteri)."[...]";
}else{
$risultato=$testo;
}
print puliscitesto($risultato);
}
$prezzodb=@mysql_result($query3,0,2);
//Messaggio di inserimento o modifica del prezzo del prodotto
if(isset($_POST['salvaprezzi']) and strlen($_POST['salvaprezzi'])>0){
print $msg;
}
?> <form action="caricoprezzi.php" name="modprezzo" id="modprezzo" method="POST">
<table style="padding-left: 10px; color: #fff; background-color: #333; font-size: 16px; font-weight: bold; height: 30px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0">
<tr>
<td width="620px"><? print puliscitesto(strtoupper($nomemarca)." - ".utf8_encode($nomeprodotto)); ?></td>
</tr>
</table>
<table style="height: 50px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0">
<tr>
<td style="border: 1px solid #000; width: 100px;"><img src="<? print "../upload/".$prodottoprev; ?>" width="100px" height="100px"></td>
<td style="border: 1px solid #000; width: 400px;"><? print "<div style=\"font-family: Arial; font-size: 12px; padding-left: 10px;\">".puliscitesto(utf8_encode($descprodotto))."</div>"; ?></td>
<td style="border: 1px solid #000; width: 220px;">
<center>
<span style="font-family: Arial; font-size: 14px; font-weight: bold;">Prezzo dell'articolo:<br />
<input type="text" name="prezzo" id="prezzo" value="<? print $prezzodb; ?>" onkeypress="javascript: sistemaprezzo(this.value,this);">
<input type="hidden" name="idprodotto" id="idprodotto" value="<? print $_POST['idprodotto']; ?>">
<input type="hidden" name="salvaprezzi" id="salvaprezzi" value="1">
</center>
</td>
</tr>
</table>
<input type="Submit" name="cmd" id="cmd" value="Conferma" style="margin-left: 570px; height: 40px; width: 150px; margin-top: 10px;"/>
</form>
<? }else{
print "Seleziona un prodotto";
}
<?php
}
?>
</head>
<body bgcolor="#D5E2EB">
<select name="prodotti" id="prodotti" class="selectcambio" Onchange="javascript: scriviid(this.value);">
<?php
//Dati database, connessione e selezione del database
include "../config.php";
//connessione al database
$db = mysql_connect($host, $user, $psw) or die("Errore nella connessione. Verificare i parametri nel file config.inc.php");
//selezione del database
mysql_select_db($database) or die("Non riesco a selezionare il database");
//query prodotti per la marca selezionata
$queryprod = mysql_query("SELECT id,titolo FROM `prodotti` WHERE idmarca='" . $_GET['marca'] . "' order by titolo asc") or die("Query: prodotti non eseguita!");
while ($nomeprod = mysql_fetch_array($queryprod)) {
print "<option value='" . $nomeprod[0] . "'>" . utf8_encode(puliscitesto($nomeprod[1])) . "</option>";
}
mysql_close($db);
?>
</select>
<script type="text/javascript">
scriviid(document.getElementById('prodotti').value);
</script>
</body>
</html>
<hr />
<table border="0" width="500px">
<tr>
<td style="width: 500px; padding-top: 20px;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Link banner:</span><br />
<input type="text" name="titolo" id="titolo" value="<?php
print puliscitesto(utf8_encode($link_banner));
?>
" size="50">
</td>
</tr>
<tr>
<td style="width: 500px; padding-top: 20px;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Numero:</span><br />
<input type="text" id="descrizione" name="descrizione" value="<?php
print puliscitesto(utf8_encode($numero_banner));
?>
" size="50">
</td>
</tr>
<tr>
<td style="width: 500px; padding-top: 20px;">
<?php
if (strlen($nome_immagine) > 0) {
?>
<div style="width: 150px; float: left; text-align: center;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Immagine Attuale:</span><br />
<?php
if (strlen($nome_immagine) == 0) {
?>
<img src="/w-admin/immagini/noimg.jpg">
print $data[1];
?>
&visualizza=<?php
print $idvisualizza;
?>
" style="color: #fff;">X Elimina</a></td>
</tr>
</table>
<table style="height: 50px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0">
<tr>
<td style="border: 1px solid #000; width: 100px;"><img src="<?php
print "../upload/" . $prodottoprev;
?>
" width="100px" height="100px"></td>
<td style="border: 1px solid #000; width: 400px;" valign="top"><div style="font-family: Arial; font-size: 12px; padding-left: 10px; padding-top: 3px;"><?php
print puliscitesto(riducitesto($descprodotto, 200));
?>
</div></td>
<td style="border: 1px solid #000; width: 220px;">
<center>
<span style="font-family: Arial; font-size: 14px; font-weight: bold;">Prezzo dell'articolo:</span><br />
<input type="text" name="prezzo<?php
print $fine;
?>
" id="prezzo<?php
print $fine;
?>
" value="<?php
print $prezzodb;
?>
" onkeypress="javascript: sistemaprezzo(this.value,this);">
Modifica Marca
<? }else{
?> Inserimento Marca
<? }
?> <hr />
<table border="0" width="500px">
<tr>
<td style="width: 500px; padding-top: 20px;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Nome marca:</span><br />
<input type="text" name="titolo" id="titolo" value="<? print puliscitesto($nomec); ?>" size="50">
</td>
</tr>
<tr>
<td style="width: 500px; padding-top: 20px;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Descrizione marca:</span>
<textarea id="descrizione" name="descrizione" style="height: 200px; width: 400px;"><? print puliscitesto($descrizionec); ?></textarea>
<script language="JavaScript">
generate_wysiwyg('descrizione');
</script>
</td>
</tr>
<tr>
<td style="width: 500px; padding-top: 20px;">
<? if(strlen($immaginecat)>0){
?> <div style="width: 150px; float: left; text-align: center;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Immagine Attuale:</span><br />
<img src="../upload<? print $immaginecat; ?>" width="100" height="100">
</div>
<? }
?> <div style="width: 300px; float: left; padding-top: 80px;">
<span style="font-size: 14px; font-family: Arial; font-weight: bold;">Nuova Immagine marca:</span><br />
}
?>
<table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0">
<tr>
<td style="<?php
print $visualizza;
?>
border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><?php
print $data[0];
?>
</td>
<td style="<?php
print $visualizza;
?>
border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><?php
print puliscitesto(utf8_encode($data[1]));
?>
</td>
<td style="<?php
print $visualizza;
?>
border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<?php
print $data[0];
?>
"><img src="immagini/modifica.gif" border="0"></a></td>
<td style="<?php
print $visualizza;
?>
border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<?php
print $_SERVER['QUERY_STRING'] . $var;
?>
//prezzo
$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
$prezzodb=@mysql_result($queryprezzo,0,2);
//misure del prod
$misura="L. ".mysql_result($queryprod,0,5)." P. ".mysql_result($queryprod,0,6)." H. ".mysql_result($queryprod,0,7);
?> <div style="margin-bottom: 50px; overflow: hidden; width: 950px; height: <? if($cont>1){ print "1343px; background: url('../s-admin/immagini/sfondoanteprima.jpg') no-repeat; padding-top: 30px;";}else{ print "1034px;";}?>;">
<table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: <? if($cont>1){ print "20px;";}else{ print "15px;";}?>">
<tr>
<td height="40" width="900" style="padding-left: 20px; padding-top: 10px; background: url('../s-admin/immagini/riquadro4.jpg') no-repeat;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">€. ".sistemaprezzo($prezzodb)."</div>"; ?></td>
</tr>
<tr>
<td height="36" width="890" style="padding-left: 20px;">
<div style="height: 100px; width: 890px; overflow: hidden;">
<? print puliscitesto($descproddb,300); ?>
<? if($misura!="L. 0 P. 0 H. 0"){
print $misura;
}
?> </div>
</td>
</tr>
</table>
<table border="0" width="900" cellpadding="0" cellspacing="0" style="margin-left: 15px; ">
<tr>
<td width="900" align="center" height="<? if($cont>1){ print "956px;";}else{ print "650px;";}?>">
<div style="overflow: hidden; width: 900px; height: <? if($cont>1){ print "956px;";}else{ print "650px;";}?>">
<? //cartella sorgente dell'img
$percorsosorgente=$_SERVER['DOCUMENT_ROOT']."/upload/";
//prezzo
$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
$prezzodb=@mysql_result($queryprezzo,0,2);
$totale=$totale+$prezzodb;
//misure del prod
$misura="L. ".mysql_result($queryprod,0,4)." P. ".mysql_result($queryprod,0,5)." H. ".mysql_result($queryprod,0,6);
?> <table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: 10px;">
<tr>
<td height="40" width="900" style="padding-left: 20px; padding-top: 10px; border: 1px solid #000;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">€. ".sistemaprezzo($prezzodb)."</div>"; ?></td>
</tr>
<tr>
<td height="36" width="890" style="padding-left: 10px; border: 1px solid #000; font-size: 12px;">
<div style="width: 890px; height: 92px; overflow: hidden;">
<? print utf8_encode(puliscitesto($descproddb,300)); ?>
<? if($misura!="L. 0 P. 0 H. 0"){
print $misura;
}
?> </div>
</td>
</tr>
</table>
<table style="font-family: Arial;" border="0" cellpadding="0" cellspacing="0" style="margin-left: 15px; padding-left: 20px; font-weight: bold;">
<tr>
<td height="29" align="left" width="900">
<? if(strlen($notedb)>0){ print "N.B. ".html_entity_decode($notedb);}else{ print " ";} ?>
</td>
</tr>
</table>
<td style="width: 110px; text-align: center;">MODIFICA</td>
<td style="width: 110px; text-align: center;">ELIMINA</td>
</tr>
</table>
<? //connessione al database
$db = mysql_connect($host, $user, $psw) or die ("Errore nella connessione. Verificare i parametri nel file config.inc.php");
//selezione del database
mysql_select_db($database) or die ("Non riesco a selezionare il database");
$query="select * from marche order by id desc LIMIT ".$partenza.",".$num."";
$ris=mysql_query($query) or die ("Query: ".$query." non eseguita!");
if($righe>0){
while($data=mysql_fetch_array($ris)){
?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0">
<tr>
<td style="border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><? print $data[0]; ?></td>
<td style="border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><? print puliscitesto($data[1]); ?></td>
<td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<? print $data[0]; ?>"><img src="immagini/modifica.gif" border="0"></a></td>
<td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<? print $_SERVER['QUERY_STRING'].$var;?>elim=<? print $data[0]; ?>"><img src="immagini/elimina.gif" border="0"></a></td>
</tr>
</table>
<? }
}else{
print "Nessun marca inserita";
}
?> <div class="divpiede"> </div>
<table style="margin-top: 50px; width: 720px; height: 30px; font-family: Arial; font-weight: bold; font-size: 14px;" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 720px; text-align: center;"><? divisioneprodotti($corrente,$pagine); ?></td>
</tr>
</table>
</div>
$righeb=mysql_num_rows($bloc);
if($righeb>0){
?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 16px;" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 100px; background-color: #FF7575; border: 1px solid #000; text-align: center; font-weight: bold;"><? print $data[0]; ?></td>
<td style="width: 290px; background-color: #FF7575; border: 1px solid #000;"><? print puliscitesto($data[1]); ?></td>
<td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><img src="immagini/modificadis.gif" border="0"></td>
<td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><img src="immagini/eliminadis.gif" border="0"></td>
<td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><a href="inclusi/sblocca.php?<? print $_SERVER['QUERY_STRING'].$var;?>id=<? print $data[0]; ?>"><img src="immagini/sblocca.gif" border="0"></a></td>
</tr>
</table>
<? }else{
?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 16px;" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 100px; border: 1px solid #000; text-align: center; font-weight: bold;"><? print $data[0]; ?></td>
<td style="width: 290px; border: 1px solid #000;"><? print puliscitesto($data[1]); ?></td>
<td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="modificaprodotti.php?mod=<? print $data[0]; ?>"><img src="immagini/modifica.gif" border="0"></a></td>
<td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="gestioneprodotti.php?<? print $_SERVER['QUERY_STRING'].$var;?>elim=<? print $data[0]; ?>"><img src="immagini/elimina.gif" border="0"></a></td>
<td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="inclusi/blocca.php?<? print $_SERVER['QUERY_STRING'].$var;?>id=<? print $data[0]; ?>"><img src="immagini/blocca.gif" border="0"></a></td>
</tr>
</table>
<? }
}
}else{
print "Nessun prodotto inserito";
}
?>
<div class="divpiede"> </div>
<div class="pagine">
<? paginefooter($corrente,$pagine); ?>
</div>
<hr />
<form name="invio" id="invio" action="modificanewsletter.php?mod=<?php
print $_GET['mod'];
?>
" method="post">
<div class="contentitolo">
<div>Oggetto:</div><br />
<input type="text" name="titolo" id="titolo" value="<?php
print puliscitesto($titolo);
?>
" size="50">
</div><br />
<div class="contentitolo">
<div>Newsletter:</div><br />
<textarea id="descrizione" name="descrizione" style="height: 200px; width: 400px;"><?php
print puliscitesto($descrizione);
?>
</textarea>
<script language="JavaScript">
generate_wysiwyg('descrizione');
</script>
</div>
<div class="bottone">
<input type="hidden" name="modi" id="modi" value="<?php
print $_GET['mod'];
?>
">
<input type="Submit" name="cmd" id="cmd" value="Modifica newsletter">
</div>
</div>
</form>
$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
$prezzodb=@mysql_result($queryprezzo,0,2);
//misure del prod
$misura="L. ".@mysql_result($queryprod,0,5)." P. ".@mysql_result($queryprod,0,6)." H. ".@mysql_result($queryprod,0,7);
?> <div style="margin-bottom: 50px; overflow: hidden; margin-left: 20px; width: 950px; height: <?php if($cont>1){ print "1343px; background: url('immagini/sfondoanteprima.jpg') no-repeat; padding-top: 30px;";}else{ print "1034px;";}?>;">
<table style="font-family: Arial;" border="0" cellpadding="0" cellspacing="0" style="margin-left: 5px; padding-left: 20px; font-weight: bold;">
<tr>
<td height="29" align="left" width="900">
<?php if(strlen($notedb)>0){ print "N.B. ".html_entity_decode($notedb, ENT_COMPAT | ENT_HTML401, "UTF-8");}else{ print " ";} ?>
</td>
</tr>
</table>
<table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: <?php if($cont>1){ print "20px;";}else{ print "-4px;";}?>">
<tr>
<td height="40" width="900" style="padding-left: 20px; padding-top: 10px; background: url('immagini/riquadro4.jpg') no-repeat;"><?php print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper(htmlentities($nomemarcadb)))." - ".puliscitesto(htmlentities($nomeproddb))."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">Euro: ".sistemaprezzo($prezzodb)."</div>"; ?></td>
</tr>
<tr>
<td height="36" width="890" style="padding-left: 10px; font-size: 12px;">
<div style="height: 90px; width: 890px; overflow: hidden; margin-top: 10px;">
<?php print riducitesto(htmlspecialchars_decode(htmlentities($descproddb)),200)."<br />"; ?>
<?php if(strlen(@mysql_result($queryprod,0,5))>0 or strlen(@mysql_result($queryprod,0,6))>0 or strlen(@mysql_result($queryprod,0,7))>0){
print $misura;
}
?> </div>
</td>
</tr>
</table>
<table border="0" width="900" cellpadding="0" cellspacing="0">
<tr>
<td width="900" align="center" height="<?php if($cont>1){ print "956px;";}else{ print "650px;";}?>">
if ($data[4] == "1") {
$visualizza = "background-color: #FFD2D2;";
$bottonevis = "visualizza1.jpg";
} else {
$visualizza = "";
$bottonevis = "visualizza.jpg";
}
?>
<table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0">
<tr>
<td style="border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><?php
print $data[0];
?>
</td>
<td style="border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><?php
print puliscitesto($data[1]);
?>
</td>
<td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<?php
print $data[0];
?>
"><img src="immagini/modifica.gif" border="0"></a></td>
<td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<?php
print $_SERVER['QUERY_STRING'] . $var;
?>
elim=<?php
print $data[0];
?>
"><img src="immagini/elimina.gif" border="0"></a></td>
<td style="<?php
print $visualizza;
