$sql = "SELECT sid, metak FROM nuke_stories WHERE sid = '$id' LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
$tags = "$riga[1]";
$pieces = explode(", ", $tags);
if ($pieces[0] !='')
{
$tag1 = "Tags:
$pieces[0]";
}else{
$tag1 = "";
}
//
if ($pieces[1] !='')
{
$tag2 = ",
$pieces[1]";
}else{
$tag2 = "";
}
//
if ($pieces[2] !='')
{
$tag3 = ",
$pieces[2]";
}else{
$tag3 = "";
}
//
if ($pieces[3] !='')
{
$tag4 = ",
$pieces[3]";
}else{
$tag4 = "";
}
}
$sql = "SELECT sid, title, informant, date_format(time, '%d.%m.20%y'), hometext FROM nuke_stories WHERE sid LIKE '$id'";
function creplace($msg)
{
// $msg = str_replace('à', 'à', $msg);
// $msg = str_replace('è', 'è', $msg);
// $msg = str_replace('é', 'é', $msg);
// $msg = str_replace('ì', 'ì', $msg);
// $msg = str_replace('ò', 'ò', $msg);
// $msg = str_replace('à', 'ù', $msg);
$msg = str_replace('ª', 'ª', $msg);
$msg = str_replace('
', '', $msg);
$msg = str_replace('', '', $msg);
$msg = str_replace('
', '
', $msg);
$msg = str_replace('“', '"', $msg);
$msg = str_replace('”', '"', $msg);
$msg = str_replace("’", "'", $msg);
$msg = str_replace('…', '...', $msg);
$msg = str_replace('border=0', 'border="0"', $msg);
$msg = str_replace('
$riga[1]
$riga[2] - $riga[3]

$tag1$tag2$tag3$tag4
$riga[4]
");
}
mysql_select_db( $dbname, $conn )
or die("impossibile selezionare il database");
$sql = "SELECT sid, foto1 FROM nuke_stories WHERE sid LIKE '$id' AND foto1 !=''";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
// echo "";
echo "";
}
?>
mysql_select_db( $dbname, $conn )
or die("impossibile selezionare il database");
$sql = "SELECT sid, title, informant, date_format(time, '%d.%m.20%y'), bodytext, file FROM nuke_stories WHERE sid LIKE '$id'";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
// echo "".creplace($riga[4])."";
echo ("$riga[4]");
$file = "$riga[5]";
}
?>
// contenitore
$sql = "SELECT sid, foto2, title FROM nuke_stories WHERE sid = '$id' and foto2 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
");
}
// 1
$sql = "SELECT sid, foto2, title FROM nuke_stories WHERE sid = '$id' and foto2 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 2
$sql = "SELECT sid, foto3, title FROM nuke_stories WHERE sid = '$id' and foto3 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 3
$sql = "SELECT sid, foto4, title FROM nuke_stories WHERE sid = '$id' and foto4 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 4
$sql = "SELECT sid, foto5, title FROM nuke_stories WHERE sid = '$id' and foto5 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 5
$sql = "SELECT sid, foto6, title FROM nuke_stories WHERE sid = '$id' and foto6 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 6
$sql = "SELECT sid, foto7, title FROM nuke_stories WHERE sid = '$id' and foto7 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 7
$sql = "SELECT sid, foto8, title FROM nuke_stories WHERE sid = '$id' and foto8 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 8
$sql = "SELECT sid, foto9, title FROM nuke_stories WHERE sid = '$id' and foto9 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 9
$sql = "SELECT sid, foto10, title FROM nuke_stories WHERE sid = '$id' and foto10 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 10
$sql = "SELECT sid, foto11, title FROM nuke_stories WHERE sid = '$id' and foto11 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 11
$sql = "SELECT sid, foto12, title FROM nuke_stories WHERE sid = '$id' and foto12 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 12
$sql = "SELECT sid, foto13, title FROM nuke_stories WHERE sid = '$id' and foto13 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 13
$sql = "SELECT sid, foto14, title FROM nuke_stories WHERE sid = '$id' and foto14 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 14
$sql = "SELECT sid, foto15, title FROM nuke_stories WHERE sid = '$id' and foto15 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 15
$sql = "SELECT sid, foto16, title FROM nuke_stories WHERE sid = '$id' and foto16 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 16
$sql = "SELECT sid, foto17, title FROM nuke_stories WHERE sid = '$id' and foto17 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 17
$sql = "SELECT sid, foto18, title FROM nuke_stories WHERE sid = '$id' and foto18 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 18
$sql = "SELECT sid, foto19, title FROM nuke_stories WHERE sid = '$id' and foto19 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 19
$sql = "SELECT sid, foto20, title FROM nuke_stories WHERE sid = '$id' and foto20 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 20
$sql = "SELECT sid, foto21, title FROM nuke_stories WHERE sid = '$id' and foto21 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 21
$sql = "SELECT sid, foto22, title FROM nuke_stories WHERE sid = '$id' and foto22 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 22
$sql = "SELECT sid, foto23, title FROM nuke_stories WHERE sid = '$id' and foto23 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
// 23
$sql = "SELECT sid, foto24, title FROM nuke_stories WHERE sid = '$id' and foto24 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("-
");
}
?>
// 1
$sql = "SELECT sid, foto2, title FROM nuke_stories WHERE sid = '$id' and foto2 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 1
";
}
// 2
$sql = "SELECT sid, foto3, title FROM nuke_stories WHERE sid = '$id' and foto3 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 2
";
}
// 3
$sql = "SELECT sid, foto4, title FROM nuke_stories WHERE sid = '$id' and foto4 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 3
";
}
// 4
$sql = "SELECT sid, foto5, title FROM nuke_stories WHERE sid = '$id' and foto5 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 4
";
}
// 5
$sql = "SELECT sid, foto6, title FROM nuke_stories WHERE sid = '$id' and foto6 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 5
";
}
// 6
$sql = "SELECT sid, foto7, title FROM nuke_stories WHERE sid = '$id' and foto7 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 6
";
}
// 7
$sql = "SELECT sid, foto8, title FROM nuke_stories WHERE sid = '$id' and foto8 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 7
";
}
// 8
$sql = "SELECT sid, foto9, title FROM nuke_stories WHERE sid = '$id' and foto9 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 8
";
}
// 9
$sql = "SELECT sid, foto10, title FROM nuke_stories WHERE sid = '$id' and foto10 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 9
";
}
// 10
$sql = "SELECT sid, foto11, title FROM nuke_stories WHERE sid = '$id' and foto11 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 10
";
}
// 11
$sql = "SELECT sid, foto12, title FROM nuke_stories WHERE sid = '$id' and foto12 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 11
";
}
// 12
$sql = "SELECT sid, foto13, title FROM nuke_stories WHERE sid = '$id' and foto13 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 12
";
}
// 13
$sql = "SELECT sid, foto14, title FROM nuke_stories WHERE sid = '$id' and foto14 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 13
";
}
// 14
$sql = "SELECT sid, foto15, title FROM nuke_stories WHERE sid = '$id' and foto15 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 14
";
}
// 15
$sql = "SELECT sid, foto16, title FROM nuke_stories WHERE sid = '$id' and foto16 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 15
";
}
// 16
$sql = "SELECT sid, foto17, title FROM nuke_stories WHERE sid = '$id' and foto17 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 16
";
}
// 17
$sql = "SELECT sid, foto18, title FROM nuke_stories WHERE sid = '$id' and foto18 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 17
";
}
// 18
$sql = "SELECT sid, foto19, title FROM nuke_stories WHERE sid = '$id' and foto19 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 18
";
}
// 19
$sql = "SELECT sid, foto20, title FROM nuke_stories WHERE sid = '$id' and foto20 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 19
";
}
// 20
$sql = "SELECT sid, foto21, title FROM nuke_stories WHERE sid = '$id' and foto21 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 20
";
}
// 21
$sql = "SELECT sid, foto22, title FROM nuke_stories WHERE sid = '$id' and foto22 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 21
";
}
// 22
$sql = "SELECT sid, foto23, title FROM nuke_stories WHERE sid = '$id' and foto23 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 22
";
}
// 23
$sql = "SELECT sid, foto24, title FROM nuke_stories WHERE sid = '$id' and foto24 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "- 23
";
}
?>
$sql = "SELECT sid, video FROM nuke_stories WHERE sid = '$id' and video !=''";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "
";
}
?>
$sql = "SELECT sid, art1, txtart1, hometext FROM nuke_stories WHERE sid = '$id' and txtart1 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
Articoli Correlati
$riga[2]
");
}
$sql = "SELECT sid, art2, txtart2, hometext FROM nuke_stories WHERE sid = '$id' and txtart2 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, art3, txtart3, hometext FROM nuke_stories WHERE sid = '$id' and txtart3 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, art4, txtart4, hometext FROM nuke_stories WHERE sid = '$id' and txtart4 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, art1, txtart1 FROM nuke_stories WHERE sid = '$id' and txtart1 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "
";
}
?>
$sql = "SELECT sid, linkest1, linkesttxt1, hometext FROM nuke_stories WHERE sid = '$id' and linkesttxt1 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
Link Consigliati
$riga[2]
");
}
$sql = "SELECT sid, linkest2, linkesttxt2, hometext FROM nuke_stories WHERE sid = '$id' and linkesttxt2 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, linkest3, linkesttxt3, hometext FROM nuke_stories WHERE sid = '$id' and linkesttxt3 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, linkest4, linkesttxt4, hometext FROM nuke_stories WHERE sid = '$id' and linkesttxt4 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
");
}
$sql = "SELECT sid, linkest1, linkesttxt1 FROM nuke_stories WHERE sid = '$id' and linkesttxt1 !='' ORDER BY time desc LIMIT 0,1";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "
";
}
?>
$sql = "SELECT autore, codice FROM adbanner WHERE autore LIKE '$nomeautore'";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
if ($riga = mysql_fetch_row($result)) {
$adcode = "$riga[1]";
}else{
$adcode = "pub-2363444704444816";
}
?>
NEWS
$sql="SELECT eid, aid, title, time, hometext, comments, counter, topic, informant, date_format(eventDate, '%d-%m-%Y') as eventDate, date_format(endDate, '%d-%m-%Y') as endDate, startTime, endTime, alldayevent, barcolor, citta, provincia FROM nuke_events WHERE eventDate LIKE '%2013-%' AND approvato LIKE 'si' ORDER BY eid DESC LIMIT 4";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo ("
$riga[2]
Città: $riga[15] - Provincia: $riga[16]
dal: $riga[9] al: $riga[10]
");
}
?>