set_file(array(
"mainpage" => "koth_stats.htm",
"enlaces" => "template_noticias.htm",
"stats_raza" => "template_stats_raza.htm",
"stats_mapa" => "template_stats_mapa.htm",
"stats_mapa_raza" => "template_stats_raza_mapa.htm"));
$link = mysql_connect("$dbHost", "$dbUser", "$dbPass")
or die("Could not connect : " . mysql_error());
mysql_select_db("$dbDatabase1") or die("Could not select database");
$c = 0;
$query = "SELECT
cfg_raza.razaid,
cfg_raza.raza_acronymo,
sum(rep_participante.par_gano),
count(rep_participante.par_gano),
cfg_raza.raza_avatar,
sum(rep_participante.par_gano)/count(rep_participante.par_gano) as factor
FROM
rep_replay,
rep_participante,
cfg_raza
WHERE
cfg_raza.razaid = rep_participante.par_raza AND
rep_participante.par_repid = rep_replay.repid AND
rep_replay.rep_origen = 2
GROUP BY
cfg_raza.razaid
ORDER BY
factor DESC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$raza,
$gano,
$participo,
$avatar) = mysql_fetch_row($result)){
$porcentaje = ($gano/$participo)*100;
$porcentaje = number_format($porcentaje, 1);
$perdidas = $participo - $gano;
if ($c == 0){
$t->set_var("color",'#F5F3E8');
$c = 1;
}
else {
$t->set_var("color",'#E2E2E2');
$c = 0;
}
$t->set_var("id",$id);
$t->set_var("raza",$raza);
$t->set_var("gano",$gano);
$t->set_var("participo",$participo);
$t->set_var("avatar",$avatar);
$t->set_var("perdidas",$perdidas);
$t->set_var("porcentaje",$porcentaje);
$t->parse("statsraza","stats_raza",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
count( rep_replay.repid )
FROM
rep_replay
WHERE
rep_origen =2
GROUP BY
rep_origen";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $numero_replays) = mysql_fetch_row($result)){
$numero=$numero_replays;
}
$c = 0;
$query = "SELECT
id,
cfg_mapa.link,
cfg_mapa.name,
count(cfg_mapa.id)as mapas
FROM
rep_replay,
cfg_mapa
WHERE
cfg_mapa.id = rep_replay.rep_mapa AND
rep_replay.rep_origen = 2
GROUP BY
cfg_mapa.id
ORDER BY
mapas DESC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$mapalink,
$mapa,
$partidas) = mysql_fetch_row($result)){
$porcentaje = ($partidas/$numero)*100;
$porcentaje = number_format($porcentaje, 1);
if ($c == 0){
$t->set_var("color",'#F5F3E8');
$c = 1;
}
else {
$t->set_var("color",'#E2E2E2');
$c = 0;
}
$t->set_var("id",$id);
$t->set_var("link",$mapalink);
$t->set_var("mapa",$mapa);
$t->set_var("partidas",$partidas);
$t->set_var("porcentaje",$porcentaje);
$t->parse("statsmapa","stats_mapa",true);
}
$c = 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
cfg_mapa.id,
cfg_mapa.link,
cfg_mapa.name,
sum(par_gano),
count(par_gano),
par_raza,
sum(par_gano)/count(par_gano) as factor
FROM
rep_replay,
rep_participante,
cfg_mapa
WHERE
cfg_mapa.id = rep_replay.rep_mapa AND
rep_participante.par_repid = rep_replay.repid AND
par_raza <> 0 AND
rep_replay.rep_origen = 2
GROUP BY
par_raza,
rep_mapa
ORDER BY
par_raza,
factor DESC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id2,
$mapalink,
$mapa,
$gano,
$participo,
$raza) = mysql_fetch_row($result)){
$porcentaje = ($gano/$participo)*100;
$porcentaje = number_format($porcentaje, 1);
$perdidas = $participo - $gano;
if ($c == 0){
$t->set_var("color",'#F5F3E8');
$c = 1;
}
else {
$t->set_var("color",'#E2E2E2');
$c = 0;
}
$t->set_var("id2",$id2);
$t->set_var("link",$mapalink);
$t->set_var("mapa",$mapa);
$t->set_var("raza",$raza);
$t->set_var("gano",$gano);
$t->set_var("participo",$participo);
$t->set_var("avatar",$avatar);
$t->set_var("perdidas",$perdidas);
$t->set_var("porcentaje",$porcentaje);
switch ($raza) {
case "1":
$t->parse("maphumans","stats_mapa_raza",true);
break;
case "2":
$t->parse("maporcos","stats_mapa_raza",true);
break;
case "3":
$t->parse("mapundeads","stats_mapa_raza",true);
break;
case "4":
$t->parse("mapne","stats_mapa_raza",true);
break;
}
}
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $retadores) = mysql_fetch_row($result)){
$t->set_var("retadores",$retadores);
}
$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);
}
$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)){
$eliminatoria= date("d.M.y",$eliminatoria);
$t->set_var("eliminatoria",$eliminatoria);
}
$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
`koh_reto`
WHERE
reto_activo = 1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $retadores) = mysql_fetch_row($result)){
$t->set_var("retadores",$retadores);
}
$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)){
$eliminatoria= date("d.M.y",$eliminatoria);
$t->set_var("eliminatoria",$eliminatoria);
}
$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
`koh_reto`
WHERE
reto_activo = 1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $retadores) = mysql_fetch_row($result)){
$t->set_var("retadores",$retadores);
}
$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);
?>