query("select text from piesne_text where idpiesne='$idpiesne'");
@$pocet = mysqli_Num_Rows($result);
if($pocet==0)
{ echo "Chyba - nenajdena piesen."; exit; }
$text = stripslashes(db_Result($result, 0, "text"));
$text = str_replace("","",$text);
$text = str_replace(" ","",$text);
$text = str_replace("][",", ",$text);
$text = str_replace("] [",", ",$text);
$i = 0;
$pocet = strlen($text);
$allakordy = "";
$idakordu = 0;
// echo2($cachuj,$fd,"");
$JeAkord = 0;
while ($i<$pocet):
$znak = substr($text,$i,1);
if ($znak == "[")
{
$JeAkord = 1;
$akord_name = "";
$znak = "";
if(!$TEXT)
{
echo2($cachuj,$fd,$znak);
}
$znak = "";
}
if ($znak == "]")
{
$JeAkord = 2;
$znak = "X";
if($modulacia)
{
if(strpos($akord_name,"/"))
{
# echo substr($akord_name,0,strpos($akord_name,"/"));
# echo ":";
# echo substr($akord_name,strpos($akord_name,"/")+1);
# echo ":";
$akord_name = modulacia(substr($akord_name,0,strpos($akord_name,"/")),$modulacia)."/".modulacia(substr($akord_name,strpos($akord_name,"/")+1),$modulacia);
}
else
$akord_name = modulacia($akord_name,$modulacia);
}
if ($akord_name != "") {
if (!$TEXT) {
// Ošetrenie vstupu pred SQL dotazom
$escaped_akord_name = $mysqli->real_escape_string($akord_name);
@$result8 = $mysqli->query("SELECT kod FROM akordy WHERE akord = '$escaped_akord_name'");
@$kodakordu = db_Result($result8, 0, "kod");
$idakordu++;
$allakordy .= " " . $akord_name;
echo2($cachuj, $fd, "$akord_name");
$akordnum++;
$akordfield[$akordnum] = $akord_name;
}
}
$znak = "";
if(!$TEXT)
{
echo2($cachuj,$fd,$znak);
}
}
else
{
if(($JeAkord==1))
{
if ((($znak==" ")or($znak==".")or($znak==",")or($znak=="(")or($znak==")")or($znak=="<")))
{
if ($akord_name<>"")
{
if(!$TEXT)
{
if($modulacia)
$akord_name = modulacia($akord_name,$modulacia);
$escaped_akord_name = $mysqli->real_escape_string($akord_name);
$result8 = $mysqli->query("SELECT kod FROM akordy WHERE akord = '$escaped_akord_name'");
if (!$result8) {
// Spracovanie chyby
error_log("MySQL chyba: " . $mysqli->error);
}
@$kodakordu = db_Result($result8, 0, "kod");
$idakordu++;
$allakordy .= " ".$akord_name;
echo2($cachuj,$fd,"$akord_name");
# echo2($cachuj,$fd,"$akord_name");
}
}
if (($znak==" ")or($znak==",")or($znak=="(")or($znak==")")or($znak=="."))
if(!$TEXT)
{
echo2($cachuj,$fd,$znak);
}
$akord_name = "";
}
else
$nezobrazuj = 0;
if($znak=="<")
{
$nezobrazuj = 1;
if ($akord_name<>"")
{
if(!$TEXT)
{
$escaped_akord_name = $mysqli->real_escape_string($akord_name);
@$result8 = $mysqli->query( "select kod from akordy where akord = '$escaped_akord_name'");
@$kodakordu = db_Result($result8, 0, "kod");
$idakordu++;
$allakordy .= " ".$akord_name;
echo2($cachuj,$fd,"$akord_name");
# echo2($cachuj,$fd,"$akord_name");
}
}
$akord_name = "";
}
if(($nezobrazuj==0)and(($znak<>" ")and($znak<>",")and($znak<>"(")and($znak<>")")and($znak<>".")))
$akord_name = $akord_name.$znak;
if($znak==">")
{
$nezobrazuj = 0;
$akord_name = "";
}
if(ord($znak)==10)
if(substr($allakordy,strlen($allakordy),1) <> ">") { $allakordy.="
"; }
}
else
{
if(!$TEXT):
{
echo2($cachuj,$fd,str_replace(chr(10),"
",str_replace(chr(10).chr(10),"",($znak))));
if(ord($znak)==10)
if(substr($allakordy,strlen($allakordy),1) <> ">") { $allakordy.="
"; }
}
else:
if($JeAkord==0)
{
echo2($cachuj,$fd,str_replace(chr(10),"
",str_replace(chr(10).chr(10)," ",($znak))));
if(substr($allakordy,strlen($allakordy),1) <> ">") $allakordy.="
";
}
endif;
}
}
if($JeAkord==2)
$JeAkord=0;
$i ++;
endwhile;
echo2($cachuj,$fd,$output);
# if((!$TEXT)and(!$modulacia))
# {
# fclose($fd);
# }
}
else
{
# echo "z cache
";
# include("cache/piesne/".$idpiesne.".htm");
}
# $cachuj = 0;
// @$result = mysql_db_query("www_supermusic_sk","update LOW_PRIORITY piesne_views set views_act=views_act+1 where idpiesne=$idpiesne");
$cachuj = NULL;
$maxakordov = $idakordu;
?>
|
Buena Vista Social Club:
Buena Vista Live:
