set_file(array(
"mainpage" => "galeria_detalle.htm",
"mainpage_admin" => "galeria_detalle_admin.htm",
"comments" => "template_comentarios.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 = "UPDATE
wow_pics
SET
wow_picsvista = wow_picsvista + 1
WHERE
(gamerid = $viajero) AND
(wowpicsid = $num) ";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$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
wow_pics
WHERE
gamerid = $viajero";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $registros) = mysql_fetch_row($result)) {
if ($num == $registros) {
$siguiente = 1;
} else {
$siguiente = ($num + 1);
}
if ($num > 1){
$anterior = ($num - 1);
} else {
$anterior = $registros;
}
$siguiente = "http://www.gamingcr.com/Paginas/Galerias/wow/search.php?viajero=$viajero&num=$siguiente";
$anterior = "http://www.gamingcr.com/Paginas/Galerias/wow/search.php?viajero=$viajero&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
wowpicsid,
wow_pics.gamerid,
wow_picstitulo,
wow_picsfecha,
wow_picslink,
wow_picssmall,
wow_picsvista,
wow_picsdescripcion,
members.name,
members.id
FROM
wow_pics,
ibf_members members
WHERE
wow_pics.gamerid = $viajero AND
members.id = $viajero AND
wowpicsid = $num
GROUP BY
wow_pics.gamerid
ORDER BY
wow_picsfecha ASC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$gamer,
$titulo,
$fecha,
$enlace,
$small,
$visitas,
$descripcion,
$nombre,
$autorid) = mysql_fetch_row($result)) {
$fecha = date("d.M.y",$fecha);
$t->set_var("game",$id);
$t->set_var("gamer",$gamer);
$t->set_var("nombre",$nombre);
$t->set_var("fecha",$fecha);
$t->set_var("imagen",$enlace);
$t->set_var("small",$small);
$t->set_var("titulo",$titulo);
$t->set_var("visitas",$visitas);
$t->set_var("descripcion",$descripcion);
//$t->parse("lista","listado",true);
}
$c = 0;
$query = "SELECT
wow_comtexto,
wow_comfecha,
members.id,
members.name
FROM
wow_comentario,
ibf_members members
WHERE
wow_comentario.wowpicsid = $num AND
wow_comentario.wow_viajero = $viajero AND
members.id = wow_comentario.gamerid";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $comentarios,
$fecha,
$autorid,
$autor) = mysql_fetch_row($result)){
$fecha = date("j M Y, h:i A",$fecha);
$t->set_var("texto_comentario",$comentarios);
$t->set_var("fecha",$fecha);
$t->set_var("autorid",$autorid);
$t->set_var("autor_comentario",$autor);
$t->parse("comentarios","comments",true);
$c = 1;
}
if ($c == 0){
$t->set_var("comentarios",'No se han realizado comentarios de esta entrada.');
}
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);
?>