Ti estás aquí > Inicio / Xéneros /
= CURRENT_DATE and MONTH(Cod_data_rmte) = meses.numero AND sop_mega = 'mega' AND estado IN ('publicar', 'portada') ORDER BY Cod_data_inco ASC", $colname_rs_axenda); $rs_axenda = mysql_query($query_rs_axenda, $con_cultur) or die(mysql_error()); $row_rs_axenda = mysql_fetch_assoc($rs_axenda); $totalRows_rs_axenda = mysql_num_rows($rs_axenda); $maxRows_rs_certames = 3; $pageNum_rs_certames = 0; if (isset($_GET['pageNum_rs_certames'])) { $pageNum_rs_certames = $_GET['pageNum_rs_certames']; } $startRow_rs_certames = $pageNum_rs_certames * $maxRows_rs_certames; mysql_select_db($database_con_cultur, $con_cultur); $query_rs_certames = "SELECT titulo, DAYOFMONTH(prazo), galego FROM certames, meses WHERE categoria = 'Música' AND prazo <= CURDATE() AND estado IN ('publicar', 'portada') AND MONTH(prazo) = numero ORDER BY prazo ASC"; $query_limit_rs_certames = sprintf("%s LIMIT %d, %d", $query_rs_certames, $startRow_rs_certames, $maxRows_rs_certames); $rs_certames = mysql_query($query_limit_rs_certames, $con_cultur) or die(mysql_error()); $row_rs_certames = mysql_fetch_assoc($rs_certames); if (isset($_GET['totalRows_rs_certames'])) { $totalRows_rs_certames = $_GET['totalRows_rs_certames']; } else { $all_rs_certames = mysql_query($query_rs_certames); $totalRows_rs_certames = mysql_num_rows($all_rs_certames); } $totalPages_rs_certames = ceil($totalRows_rs_certames/$maxRows_rs_certames)-1; $maxRows_rs_Biblioteca = 5; $pageNum_rs_Biblioteca = 0; if (isset($_GET['pageNum_rs_Biblioteca'])) { $pageNum_rs_Biblioteca = $_GET['pageNum_rs_Biblioteca']; } $startRow_rs_Biblioteca = $pageNum_rs_Biblioteca * $maxRows_rs_Biblioteca; mysql_select_db($database_con_cultur, $con_cultur); $query_rs_Biblioteca = "SELECT id, titulo, entradinha, url_recurso FROM biblioteca WHERE categoria = 'Música' and estado = 'publicar' ORDER BY id DESC"; $query_limit_rs_Biblioteca = sprintf("%s LIMIT %d, %d", $query_rs_Biblioteca, $startRow_rs_Biblioteca, $maxRows_rs_Biblioteca); $rs_Biblioteca = mysql_query($query_limit_rs_Biblioteca, $con_cultur) or die(mysql_error()); $row_rs_Biblioteca = mysql_fetch_assoc($rs_Biblioteca); if (isset($_GET['totalRows_rs_Biblioteca'])) { $totalRows_rs_Biblioteca = $_GET['totalRows_rs_Biblioteca']; } else { $all_rs_Biblioteca = mysql_query($query_rs_Biblioteca); $totalRows_rs_Biblioteca = mysql_num_rows($all_rs_Biblioteca); } $totalPages_rs_Biblioteca = ceil($totalRows_rs_Biblioteca/$maxRows_rs_Biblioteca)-1; $maxRows_rs_temadia = 1; $pageNum_rs_temadia = 0; if (isset($_GET['pageNum_rs_temadia'])) { $pageNum_rs_temadia = $_GET['pageNum_rs_temadia']; } $startRow_rs_temadia = $pageNum_rs_temadia * $maxRows_rs_temadia; $colname_rs_temadia = "-1"; if (isset($_GET['xenero'])) { $colname_rs_temadia = (get_magic_quotes_gpc()) ? $_GET['xenero'] : addslashes($_GET['xenero']); } mysql_select_db($database_con_cultur, $con_cultur); $query_rs_temadia = sprintf("SELECT imaxe, id, titular, subtitulo, DAYOFMONTH(data), MONTH(data), YEAR(data), categoria FROM noticias, mega_cod_xenero WHERE extras = xen_cod AND xen_significado = '%s' AND estado IN ( 'publicar', 'sns') AND soportal = 'rcg' AND categoria IN ('temadia', 'sns') ORDER BY data DESC, id DESC", $colname_rs_temadia); $query_limit_rs_temadia = sprintf("%s LIMIT %d, %d", $query_rs_temadia, $startRow_rs_temadia, $maxRows_rs_temadia); $rs_temadia = mysql_query($query_limit_rs_temadia, $con_cultur) or die(mysql_error()); $row_rs_temadia = mysql_fetch_assoc($rs_temadia); if (isset($_GET['totalRows_rs_temadia'])) { $totalRows_rs_temadia = $_GET['totalRows_rs_temadia']; } else { $all_rs_temadia = mysql_query($query_rs_temadia); $totalRows_rs_temadia = mysql_num_rows($all_rs_temadia); } $totalPages_rs_temadia = ceil($totalRows_rs_temadia/$maxRows_rs_temadia)-1; $maxRows_rs_musica = 7; $pageNum_rs_musica = 0; if (isset($_GET['pageNum_rs_musica'])) { $pageNum_rs_musica = $_GET['pageNum_rs_musica']; } $startRow_rs_musica = $pageNum_rs_musica * $maxRows_rs_musica; $colname_rs_musica = "-1"; if (isset($_GET['xenero'])) { $colname_rs_musica = (get_magic_quotes_gpc()) ? $_GET['xenero'] : addslashes($_GET['xenero']); } mysql_select_db($database_con_bdmega, $con_bdmega); $query_rs_musica = sprintf("SELECT titulo, detalle, texto, relne_idnova, relne_artista FROM mega_cod_xenero, extras, mega_rel_novas_extras WHERE xen_significado = '%s' AND xen_cod = relne_xenero AND relne_idextra = id AND cntdo_extra IN ('can30', 'cancion') ORDER BY id DESC", $colname_rs_musica); $query_limit_rs_musica = sprintf("%s LIMIT %d, %d", $query_rs_musica, $startRow_rs_musica, $maxRows_rs_musica); $rs_musica = mysql_query($query_limit_rs_musica, $con_bdmega) or die(mysql_error()); $row_rs_musica = mysql_fetch_assoc($rs_musica); if (isset($_GET['totalRows_rs_musica'])) { $totalRows_rs_musica = $_GET['totalRows_rs_musica']; } else { $all_rs_musica = mysql_query($query_rs_musica); $totalRows_rs_musica = mysql_num_rows($all_rs_musica); } $totalPages_rs_musica = ceil($totalRows_rs_musica/$maxRows_rs_musica)-1; $maxRows_rs_ultimosdiscos = 5; $pageNum_rs_ultimosdiscos = 0; if (isset($_GET['pageNum_rs_ultimosdiscos'])) { $pageNum_rs_ultimosdiscos = $_GET['pageNum_rs_ultimosdiscos']; } $startRow_rs_ultimosdiscos = $pageNum_rs_ultimosdiscos * $maxRows_rs_ultimosdiscos; $colname_rs_ultimosdiscos = "-1"; if (isset($_GET['xenero'])) { $colname_rs_ultimosdiscos = (get_magic_quotes_gpc()) ? $_GET['xenero'] : addslashes($_GET['xenero']); } mysql_select_db($database_con_cultur, $con_cultur); $query_rs_ultimosdiscos = sprintf("SELECT DISTINCT id, relacionado, dia, YEAR(data), xen_significado, imaxe FROM noticias, mega_cod_xenero WHERE xen_significado = '%s' AND xen_cod = extras AND ano = 'DISCO' GROUP BY dia ORDER BY id DESC", $colname_rs_ultimosdiscos); $query_limit_rs_ultimosdiscos = sprintf("%s LIMIT %d, %d", $query_rs_ultimosdiscos, $startRow_rs_ultimosdiscos, $maxRows_rs_ultimosdiscos); $rs_ultimosdiscos = mysql_query($query_limit_rs_ultimosdiscos, $con_cultur) or die(mysql_error()); $row_rs_ultimosdiscos = mysql_fetch_assoc($rs_ultimosdiscos); if (isset($_GET['totalRows_rs_ultimosdiscos'])) { $totalRows_rs_ultimosdiscos = $_GET['totalRows_rs_ultimosdiscos']; } else { $all_rs_ultimosdiscos = mysql_query($query_rs_ultimosdiscos); $totalRows_rs_ultimosdiscos = mysql_num_rows($all_rs_ultimosdiscos); } $totalPages_rs_ultimosdiscos = ceil($totalRows_rs_ultimosdiscos/$maxRows_rs_ultimosdiscos)-1; $maxRows_rs_videos = 3; $pageNum_rs_videos = 0; if (isset($_GET['pageNum_rs_videos'])) { $pageNum_rs_videos = $_GET['pageNum_rs_videos']; } $startRow_rs_videos = $pageNum_rs_videos * $maxRows_rs_videos; $colname_rs_videos = "-1"; if (isset($_GET['xenero'])) { $colname_rs_videos = (get_magic_quotes_gpc()) ? $_GET['xenero'] : addslashes($_GET['xenero']); } mysql_select_db($database_con_bdmega, $con_bdmega); $query_rs_videos = sprintf("SELECT id, titulo, detalle,texto, relne_idnova, relne_xenero, relne_artista FROM mega_cod_xenero, extras, mega_rel_novas_extras WHERE xen_significado = '%s' AND xen_cod = relne_xenero AND relne_idextra = id AND cntdo_extra IN ('video', 'entre', 'makin') ORDER BY id DESC", $colname_rs_videos); $query_limit_rs_videos = sprintf("%s LIMIT %d, %d", $query_rs_videos, $startRow_rs_videos, $maxRows_rs_videos); $rs_videos = mysql_query($query_limit_rs_videos, $con_bdmega) or die(mysql_error()); $row_rs_videos = mysql_fetch_assoc($rs_videos); if (isset($_GET['totalRows_rs_videos'])) { $totalRows_rs_videos = $_GET['totalRows_rs_videos']; } else { $all_rs_videos = mysql_query($query_rs_videos); $totalRows_rs_videos = mysql_num_rows($all_rs_videos); } $totalPages_rs_videos = ceil($totalRows_rs_videos/$maxRows_rs_videos)-1; $colname_rs_imaxes = "-1"; if (isset($_GET['xenero'])) { $colname_rs_imaxes = (get_magic_quotes_gpc()) ? $_GET['xenero'] : addslashes($_GET['xenero']); } mysql_select_db($database_con_bdmega, $con_bdmega); $query_rs_imaxes = sprintf("SELECT DISTINCT relne_idnova, titulo, detalle,texto, relne_xenero, relne_artista, id FROM mega_cod_xenero, extras, mega_rel_novas_extras WHERE xen_significado = '%s' AND xen_cod = relne_xenero AND relne_idextra = id AND cntdo_extra = 'gale' GROUP BY relne_idnova ORDER BY relne_idnova DESC", $colname_rs_imaxes); $rs_imaxes = mysql_query($query_rs_imaxes, $con_bdmega) or die(mysql_error()); $row_rs_imaxes = mysql_fetch_assoc($rs_imaxes); $totalRows_rs_imaxes = mysql_num_rows($rs_imaxes); mysql_select_db($database_con_cultur, $con_cultur); $query_rs_discosminiaturas = "SELECT DISTINCT imaxe FROM noticias WHERE ano = 'DISCO' ORDER BY id DESC"; $rs_discosminiaturas = mysql_query($query_rs_discosminiaturas, $con_cultur) or die(mysql_error()); $row_rs_discosminiaturas = mysql_fetch_assoc($rs_discosminiaturas); $totalRows_rs_discosminiaturas = mysql_num_rows($rs_discosminiaturas); function dyn_thumbnail($folder="",$img_name="",$thumb_width,$thumb_height,$thumb_var="thumb",$add_popup="false",$alt_img){ if(($folder!="" && (strlen(strrchr($folder,"/"))>1)) || $folder==".."){ $folder=$folder."/"; } $web_img_name=$folder.$img_name; $local_img_name=realpath($web_img_name); $img_ext=substr(strrchr($img_name,"."),1); if($img_name!="" && file_exists($local_img_name)&&(($img_ext=="jpg")||($img_ext=="jpeg"))){ $img_type=getimagesize($local_img_name); $img_type=$img_type[2]; if ($img_type==2){ $file_ok="ok"; } } $web_folder_name=substr($web_img_name,0,(strlen($web_img_name)-strlen($img_name))); $local_folder_name=realpath($folder); if($local_folder_name!=""){ $local_folder_name=$local_folder_name."/"; } $thumb_name=$thumb_var.$thumb_width."_".$img_name; $local_thumb_name=$local_folder_name.$thumb_name; $web_thumb_name=$web_folder_name.$thumb_name; if(!file_exists($local_thumb_name)&&($file_ok=="ok")){ tcn_make_thumbnail($local_img_name,$local_thumb_name,$thumb_width); } if($file_ok="ok" && file_exists($local_thumb_name)){ $thumb_dimensions = getimagesize($local_thumb_name); $dimensions=$thumb_dimensions[3]; $popup_dimensions=getimagesize($local_img_name); $pop_width=$popup_dimensions[0]+30; $pop_height=$popup_dimensions[1]+30; if ($add_popup=="true"){ $link_start=""; $attr="border=\"0\" title=\"Click to enlarge\" alt=\"".$img_name."\" "; $call_script="onClick=\"window.open('$web_img_name','tcn_pop','fullscreen=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,directories=no,location=no,width=$pop_width,height=$pop_height,left=0,top=0');\""; $link_end=""; echo $link_start."".$link_end; }else{ echo ""; } }else{ if($alt_img!=""){ $alt_local_img=realpath($alt_img); $alt_dimensions = getimagesize($alt_local_img); echo (""); }else{echo("");} } } function tcn_make_thumbnail($image,$output_image,$thumb_width){ //$thumb_width; $img=imagecreatefromjpeg($image); $img_size=getimagesize($image); $proportion=$img_size[0]/$thumb_width; //gd1 and gd2 compatible if($thumbnail=@imagecreatetruecolor($img_size[0]/$proportion,$img_size[1]/$proportion)){ imagecopyresampled($thumbnail,$img,0,0,0,0,$img_size[0]/$proportion,$img_size[1]/$proportion,$img_size[0],$img_size[1]); }else{ $thumbnail=imagecreate($img_size[0]/$proportion,$img_size[1]/$proportion); imagecopyresized($thumbnail,$img,0,0,0,0,$img_size[0]/$proportion,$img_size[1]/$proportion,$img_size[0],$img_size[1]); } imagejpeg($thumbnail,$output_image); imagedestroy($img); imagedestroy($thumbnail); } ?>
Ti estás aquí > Inicio / Xéneros /