set_file(array(
"mainpage" => "galeria_indice.htm",
"detalle" => "template_imagen.htm",
"fechas" => "template_fechas.htm"));
$link = mysql_connect("$dbHost", "$dbUser", "$dbPass")
or die("Could not connect : " . mysql_error());
mysql_select_db("$dbDatabase1") or die("Could not select database");
$query = "SELECT
COUNT(*)
FROM
gal_index
WHERE
game = $juego AND
gal_index.media = $tipo";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $registros) = mysql_fetch_row($result)) {
if ($numero == $registros) {
$siguiente = 1;
} else {
$siguiente = ($numero + 1);
}
if ($numero > 1){
$anterior = ($numero - 1);
} else {
$anterior = $registros;
}
$siguiente = "http://www.gamingcr.com/Paginas/Galerias/search.php?game=$juego&media=$tipo&num=$siguiente";
$anterior = "http://www.gamingcr.com/Paginas/Galerias/search.php?game=$juego&media=$tipo&num=$anterior";
$t->set_var("siguiente",$siguiente);
$t->set_var("anterior",$anterior);
$t->set_var("total",$registros);
}
$link = mysql_connect("$dbHost", "$dbUser", "$dbPass")
or die("Could not connect : " . mysql_error());
mysql_select_db("$dbDatabase1") or die("Could not select database");
$query = "SELECT
buy,
id_game,
gal_index.media,
number,
date,
file,
comments,
name,
gal_media.media,
cfg_platform.acronym,
views
FROM
cfg_game,
gal_media,
cfg_platform,
gal_index
WHERE
gal_index.game = $juego AND
gal_index.media = $tipo AND
cfg_game.id_game = gal_index.game AND
gal_media.id_media = gal_index.media AND
cfg_platform.id_platform = cfg_game.platform
ORDER BY
date DESC,
number ASC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$publicacion = 0;
$i = 1;
while (list( $buy,
$id_game,
$id_media,
$number,
$date,
$file,
$comentarios,
$name,
$media,
$plataforma,
$vistas) = mysql_fetch_row($result)) {
$fecha = date("d.M.y",$date);
$file = str_replace ( ".jpg", "_small.jpg", $file);
$imagen = '
';
$t->set_var("imagen",$imagen);
$t->set_var("idgame",$juego);
$t->set_var("vistas",$vistas);
$t->set_var("buy",$buy);
$t->set_var("idmedia",$id_media);
$t->set_var("game",$name);
$t->set_var("number",$number);
$t->set_var("media",$media);
$t->set_var("fecha",$fecha);
$t->set_var("file",$file);
$t->set_var("plataforma",$plataforma);
$t->set_var("comentarios",$comentarios);
$t->set_var("codigo",$codigo);
switch ($i) {
case "1":
$codigo="";
$i = 2;
$t->parse("imagenes01","detalle",true);
break;
case "2":
$codigo="";
$i = 3;
$t->parse("imagenes02","detalle",true);
break;
case "3":
$codigo="";
$i = 4;
$t->parse("imagenes03","detalle",true);
break;
case "4":
/*$codigo='
';*/
$i=1;
$t->parse("imagenes04","detalle",true);
break;
}
/*if ($publicacion == 0){
$publicacion = $fecha ;
} else {
if ($publicacion <> $fecha ){
$t->set_var("fecha_grupo",$publicacion );
$publicacion = $fecha ;
$t->parse("fechas_imagenes","mainpage",true);
}
} */
}
$numero = $ipb->member['id'];
if ($SDK->is_loggedin()) {
$info = $SDK->get_info();
$username = $info['name'];
$numero = $info['id'];
$ultima = 'Logout';
$enlaces = 'Registrarse';
$member_titulo = $ipb->member['title'];
fpremium ($numero, $ispremium);
if ($ispremium = 0){
$member_status = $SDK->get_avatar();
$b = strpos($member_status, 'border=');
$member_status = substr($member_status, 10, $b - 12);
} else {
$member_status = $SDK->get_avatar();
$b = strpos($member_status, 'border=');
$member_status = substr($member_status, 10, $b - 12);
}
} else {
$username = 'Invitado';
$ultima ='Login';
$enlaces = 'Registrarse';
$member_status = "http://gamingcr.com/images/Mapas/nomap.gif";
$member_titulo = "Sin rango";
}
$t->set_var("username",$username);
$t->set_var("ultima",$ultima);
$t->set_var("leyenda",$leyenda);
$t->set_var("enlaces",$enlaces);
$t->set_var("controlpanel",$controlpanel);
$t->set_var("member_status",$member_status);
$t->set_var("member_titulo",$member_titulo);
$online = $SDK->list_online_members("1"); // Grab Online Members - Detailed Info
$details = $SDK->get_active_count();
$stats = $SDK->get_board_stats();
$totalonline = count($online); // Count up amount of people online
$list = ""; // Initalize Variable
$n = 0;
if (count($online)) {
foreach ($online as $i) {
$list = ''.$i['name'].'';
$t->set_var("lista",$list);
$n = $n + 1;
$t->set_var("i",$n);
$t->parse("usuarios_online","conectados",true);
}
}
$totals = $stats['total_topics'] + $stats['total_replies'];
$t->set_var("utotal",$details['total']);
$t->set_var("miembros",$details['members']);
$t->set_var("invitados",$details['guests']);
$t->set_var("anonimos",$details['anon']);
$t->set_var("tusers", $stats['mem_count']);
$t->set_var("treplies", $totals);
$t->pparse("output","mainpage"); // output the value of MyOutput (our parsed data)
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
?>