is_loggedin()) {
$info = $SDK->get_info();
$num_miembro = $ipb->member['id'];
};
$t = new Template("./");
$numero = $ipb->member['id'];
$t->set_file(array(
"mainpage" => "koth_retos.htm",
"enlaces" => "template_noticias.htm",
"listado" => "template_lista.htm",
"listado_dec" => "template_lista_dec.htm",
"listado_hide" => "template_lista_hide.htm",
"listado_rep" => "template_lista_rep.htm",
"listado_reyes" => "template_lista_reyes.htm",
"listado_fecha" => "template_lista_fecha.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
members.id,
members.name,
king_start,
king_end,
sum(par_gano) AS ganadas,
count(par_gano) AS total
FROM
rep_participante p,
koh_king king,
ibf_members members,
rep_replay r
WHERE
members.id = king.king_gamerid AND
par_gamer = king.king_gamerid AND
par_observer <> 1 AND
r.repid = p.par_repid AND
r.rep_origen = 2 AND
king_end = 0
GROUP BY
members.id";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $kothid,
$nick,
$start,
$end,
$ganadas,
$total) = mysql_fetch_row($result)){
$periodo = time() - $start;
$start_timestamp = $start;
$end_timestamp = time();
$perdidas = $total - $ganadas;
$days_seconds_star= (23 * 56 * 60) + 4.091; // Star Day
$days_seconds_sun= 24 * 60 * 60; // Sun Day
$difference_seconds= $end_timestamp - $start_timestamp;
$periodo= round(($difference_seconds / $days_seconds_sun),0);
//return 'approx. '.$difference_hours.' Days';
$porcentaje = ($ganadas/$total)*100;
$kpo = number_format($porcentaje, 1);
if ($periodo == 1) {
$leyenda = ' día';
}
else {
$leyenda = ' días';
}
$t->set_var("kothid",$kothid);
$t->set_var("p",$periodo);
$t->set_var("koth",$nick);
$t->set_var("dias",$leyenda);
$t->set_var("kt",$total);
$t->set_var("kg",$ganadas);
$t->set_var("kp",$perdidas);
$t->set_var("ko",$kpo);
}
$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
fecha_eliminatoria
FROM
koh_fecha
WHERE
fecha_eliminatoria < now() AND
fecha_activa = 1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $eliminatoria) = mysql_fetch_row($result)){
$una_semana = $eliminatoria + 604800;
$dos_semanas = $eliminatoria + 1209600;
$eliminatoria= date("d.M.y",$eliminatoria);
$dos_semanas= date("d.M.y",$dos_semanas);
$una_semana= date("d.M.y",$una_semana);
$t->set_var("eliminatoria",$eliminatoria);
$t->set_var("dos_semanas",$dos_semanas);
$t->set_var("una_semana",$una_semana);
}
$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
fecha_reto
FROM
koh_fecha
WHERE
(fecha_reto < now() OR
fecha_reto = now()) AND
fecha_activa = 1
ORDER BY
fecha_reto ASC
LIMIT
1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $reto) = mysql_fetch_row($result)){
$reto= date("d.M.y",$reto);
$t->set_var("reto",$reto);
}
$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
SUM(game_resultado),
COUNT(game_resultado)
FROM
koh_resultado,
koh_king
WHERE
game_koth = kingid
GROUP BY
game_koth";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$i = 0;
while (list( $wins,
$total) = mysql_fetch_row($result)){
$perdidas = $total - $wins;
$t->set_var("total",$total);
$t->set_var("victorias",$wins);
$t->set_var("derrotas",$perdidas);
$i = $i + 1;
}
if ($i==0){
$total = 0;
$t->set_var("total",$total );
$t->set_var("victorias",$total );
$t->set_var("derrotas",$total );
}
$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
members.id,
members.name,
reto_fecha,
reto_retador,
decid
FROM
ibf_members members,
koh_reto LEFT JOIN
koh_declaraciones
ON (reto_gamer = dec_gamer)
WHERE
members.id = reto_gamer AND
reto_activo = 1 AND
reto_retador = 0
ORDER BY
reto_fecha ASC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$i = 1;
$c = 0;
while (list( $id,
$nick,
$fecha,
$reto_retador,
$decid) = mysql_fetch_row($result)){
$fecha = date("d.M.y",$fecha);
$t->set_var("id",$id);
$t->set_var("nick",$nick);
$t->set_var("fecha",$fecha);
$t->set_var("lugar",$i);
$t->set_var("decid",$decid);
if ($i < 3){
if ($c == 0){
$t->set_var("color",'#CBD1D9');
$c = 1;
}
else {
$t->set_var("color",'#E5E8EC');
$c = 0;
}
if ($decid > 0) {
$t->parse("retadores","listado_dec",true);
}
else {
$t->parse("retadores","listado",true);
}
}
else {
if ($i < 5){
if ($c == 0){
$t->set_var("color",'#CBD1D9');
$c = 1;
}
else {
$t->set_var("color",'#E5E8EC');
$c = 0;
}
$t->parse("cola","listado",true);
}
else {
if ($c == 0){
$t->set_var("color",'#ECE9D8');
$c = 1;
}
else {
$t->set_var("color",'#F5F4EB');
$c = 0;
}
if ($numero <> 0) {
if (($numero == $id) OR ($numero == 2)) {
$t->parse("ocultos","listado",true);
} else{
$t->parse("ocultos","listado_hide",true);
}
} else {
$t->parse("ocultos","listado_hide",true);
}
}
}
$i = $i + 1;
}
$i = 1;
$d = 1;
$c = 1;
$f = 0;
$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
members.id,
members.name,
reto_fecha,
reto_retador,
decid,
reto_eliminado
FROM
ibf_members members,
koh_reto LEFT JOIN
koh_declaraciones
ON (reto_gamer = dec_gamer)
WHERE
members.id = reto_gamer AND
reto_activo = 0 AND
reto_eliminado <> 0
ORDER BY
reto_fecha ASC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$nick,
$fecha,
$reto_retador,
$decid,
$eliminados) = mysql_fetch_row($result)){
$fecha = date("d.M.y",$eliminados);
$t->set_var("id",$id);
$t->set_var("nick",$nick);
$t->set_var("fecha",$fecha);
$t->set_var("decid",$decid);
if ($reto_retador == 0) {
$t->set_var("lugar",$i);
if ($c == 0){
$t->set_var("color",'#F5F3E8');
$c = 1;
}
else {
$t->set_var("color",'#E2E2E2');
$c = 0;
}
$t->parse("eliminados","listado_rep",true);
$i = $i + 1;
}
else {
$t->set_var("lugar",$d);
if ($f == 0){
$t->set_var("color",'#F5F3E8');
$f = 1;
}
else {
$t->set_var("color",'#F5F4EB');
$f = 0;
}
$t->parse("derrotados","listado_rep",true);
$d = $d + 1;
}
}
$t->set_var("retador","Sin definir");
$r = 0;
$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
members.id,
members.name
FROM
koh_reto,
ibf_members members
WHERE
members.id = reto_gamer AND
reto_retador = 1 AND
reto_eliminado = 0 AND
reto_activo <> 0
ORDER BY
reto_fecha ASC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$nick) = mysql_fetch_row($result)){
$t->set_var("id",$id);
$t->set_var("retador",$nick);
// $codigo = '{retador}';
$codigo = $nick;
$t->set_var("codigo",$codigo);
$r = 1;
}
if ($r == 0) {
$codigo = 'No Clasificado';
$t->set_var("codigo",$codigo);
}
$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
members.id,
members.name,
king_start,
king_end
FROM
koh_king,
ibf_members members
WHERE
members.id = king_gamerid AND
king_end <>0";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$i = 0;
$f = 1;
while (list( $id,
$nick,
$king_start,
$king_end) = mysql_fetch_row($result)){
$periodo = $king_end - $king_start;
$start_timestamp = $king_start;
$end_timestamp = $king_end;
$days_seconds_star= (23 * 56 * 60) + 4.091; // Star Day
$days_seconds_sun= 24 * 60 * 60; // Sun Day
$difference_seconds= $end_timestamp - $start_timestamp;
$periodo= round(($difference_seconds / $days_seconds_sun),0);
//return 'approx. '.$difference_hours.' Days';
if ($periodo == 1) {
$leyenda = ' día';
}
else {
$leyenda = ' días';
}
if ($f == 0){
$t->set_var("color",'#F5F3E8');
$f = 1;
}
else {
$t->set_var("color",'#E2E2E2');
$f = 0;
}
$t->set_var("id",$id);
$t->set_var("nick",$nick);
$t->set_var("sal_periodo",$periodo);
$t->set_var("sal_dias",$leyenda);
$i = $i + 1;
$t->set_var("lugar",$i);
$t->parse("reyes","listado_reyes",true);
}
$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
ibf_topics.tid,
ibf_topics.title,
ibf_topics.starter_name,
ibf_topics.starter_id,
ibf_topics.start_date,
ibf_topics.last_poster_name,
ibf_topics.last_poster_id,
ibf_topics.posts,
ibf_topics.last_post,
ibf_posts.post
FROM
ibf_topics,
ibf_posts
WHERE
(ibf_topics.forum_id=56 OR
ibf_topics.forum_id=136) AND
new_topic = 1 AND
ibf_posts.topic_id = ibf_topics.tid AND
ibf_topics.approved = 1
ORDER BY
ibf_topics.start_date DESC
LIMIT 10";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $tid,
$title,
$autor,
$starter_id,
$start_date,
$last_poster,
$last_poster_id,
$posts,
$last_post,
$text) = mysql_fetch_row($result)) {
$title2 = $title;
$MAX_LENGTH = 27;
$str_to_count = html_entity_decode($title);
if (strlen($str_to_count) >= $MAX_LENGTH) {
$s2 = substr($str_to_count, 0, $MAX_LENGTH - 3);
$s2 .= "...";
$title = ($s2);
}
$fecha=date("j.M.y",$start_date);
$last_post_date=date("j M Y, h:i A",$last_post);
$t->set_var("tid",$tid);
$t->set_var("post_date",$fecha);
$t->set_var("topic_title",$title);
$t->set_var("member_name",$autor);
$t->set_var("autor_id",$starter_id);
$t->set_var("last_poster",$last_poster);
$t->set_var("last_poster_id",$last_poster_id);
$t->set_var("replies",$posts);
$t->set_var("posts",$posts);
$t->set_var("post",$text);
$t->set_var("last_post",$last_post_date);
$t->parse("encabezados","enlaces",true);
}
$t->set_var("teamspeak",$teamspeak);
$t->set_var("gid",$nsecid);
$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);
?>