<%
// incluir librerias
include("config.inc.php3");
//include("../jugadores/config.inc.php3");
// standard header
standar_header();
// se crea el objeto de conexion a la base de datos
$table = new my_dbsearcher;
%>
Federación Colombiana de Golf
<%
$qidj = db_query("SELECT * FROM Jugador WHERE Publicar = 'S' ORDER by Rand()");
$rj = db_fetch_object($qidj);
$ruta="$folder_img_jugadores/$rj->Foto1";
%>
<%
$select="SELECT
m.nombre as mod_nombre,
s.nombre as nom_sec,
m.id_modulo as mod_id,
s.id_seccion as sec_id,
m.path as path ";
$from= " FROM
modulo as m
LEFT JOIN
seccion as s
ON
m.id_modulo = s.id_modulo ";
$where = " WHERE
s.activo = 'S' OR
s.id_modulo is NULL
ORDER BY
m.orden ASC,
s.orden ASC";
$query=$select.$from.$where;
$table->sql_query($query);
$cur_module="";
while ($row = $table->sql_fetch_object()){
if ($cur_module != $row->mod_id) {
$cur_module = $row->mod_id;
%>
<%
// seleccionar todos los comentarios vigentes y publicados
// ubicados en $modulo
$query="SELECT
c.texto,
c.foto,
n.titular,
n.subtitular,
c.id_news
FROM
news as n,
comentario as c,
seccion as s
WHERE
n.id_news = c.id_news AND
s.id_seccion = n.id_seccion AND
s.id_modulo = '$modulo' AND
INSTR(c.id_tipo_ubicacion,'3') > 0 AND
c.publicar = 'S' AND
TO_DAYS(NOW()) >= TO_DAYS(c.fecha_inicio) AND
TO_DAYS(now()) <= TO_DAYS(c.fecha_fin)
ORDER BY
c.orden ASC";
$table->sql_query($query);
while($datos=$table->sql_fetch_row()){
$texto=$datos[0];
$foto=$datos[1];
$titular=$datos[2];
$subtitular=$datos[3];
$nt=$datos[4];
%>
