is_loggedin()) {
$info = $SDK->get_info();
$num_miembro = $info['id'];
};
$nsecid = 15 ;
$torneo = 34;
$nentradas = 36;
$ndownload = 2;
$galeria = "category_id = 94 OR category_id = 95 OR category_id = 96";
switch ($npagid) {
case 0:
$tmain = "inicio.html";
break;
case 2:
$tmain = "reglamento.html";
break;
case 3:
$tmain = "inscripcion.html";
break;
case 4:
$tmain = "equipos.html";
break;
case 5:
$tmain = "llaves.html";
break;
case 6:
$tmain = "confirmacion.html";
break;
default:
$tmain = "inicio.html";
break;
}
$t->set_file(array(
"mainpage" => $tmain,
"downloads" => "template_downloads.htm",
"tequipo" => "template_clanes.htm",
"tequipo_admin" => "template_clanes_admin.htm",
"tmiembros" => "template_miembros.htm",
"tadmin" => "template_miembros_admin.htm",
"tlista" => "template_lista.htm",
"tlista_admin" => "template_lista_admin.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
d.file_id,
d.file_name,
d.file_downloads
FROM
ibf_downloads_files d
WHERE
d.file_cat = $ndownload AND
d.file_open = 1
ORDER BY
d.file_updated DESC
LIMIT 10";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$i = 0;
while (list( $fid,
$fname) = mysql_fetch_row($result)) {
$i = $i + 1;
$t->set_var("i",$i);
$t->set_var("id",$fid);
$t->set_var("name",$fname);
$t->parse("archivos","downloads",true);
}
$link = mysql_connect("$dbHost2", "$dbUser2", "$dbPass2")
or die("Could not connect : " . mysql_error());
mysql_select_db("$dbDatabase2") or die("Could not select database");
$query = "SELECT
s.sec_titulo,
s.sec_desc,
s.sec_foros,
s.sec_news,
s.sec_galerias,
s.sec_banner
FROM
cfg_secciones s
WHERE
s.secid = $nsecid";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $vtitle,
$vdescripcion,
$vforo,
$vnews,
$vgaleria,
$vbanner) = mysql_fetch_row($result)) {
$t->set_var("descripcion",$vdescripcion);
$t->set_var("title",$vtitle);
$t->set_var("banner",$vbanner);
$nforo = $vforo;
$fnews = $vnews;
}
$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
tor_clan
WHERE
idtournament = $torneo";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $vEquipos) = mysql_fetch_row($result)) {
$t->set_var("vequipos",$vEquipos);
}
$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=($nentradas)) 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 = 100;
$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
t.tid,
t.title,
t.starter_name,
t.starter_id,
t.start_date,
t.last_poster_name,
t.last_poster_id,
t.posts,
t.last_post,
p.post,
f.name,
f.parent_id,
f.id
FROM
ibf_topics t,
ibf_posts p,
ibf_forums f
WHERE
($nforo) AND
not($fnews) AND
t.forum_id = f.id AND
new_topic = 1 AND
p.topic_id = t.tid AND
t.approved = 1
ORDER BY
t.last_post DESC
LIMIT 15";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$c = 0;
while (list( $tid,
$title,
$autor,
$starter_id,
$start_date,
$last_poster,
$last_poster_id,
$posts,
$last_post,
$text,
$nforo,
$parent,
$fid) = mysql_fetch_row($result)) {
$a = 0;
$b = 0;
$title = strtolower ($title);
$a = strpos($text, '
');
$t->set_var("Mas",'');
if ($a > 0) {
$b = strpos($text, '
',$a+1);
//$c = $a + $b;
if ($b > 0){
$b = strpos($text, '
',$b+1);
if ($b > 0){
$text = substr($text, 0, $b);
$t->set_var("Mas",'
');
}
}
}
reemplazo($text);
if ($c == 0){
$t->set_var("color",'#ECE9D8');
$c = 1;
}
else {
$t->set_var("color",'#F5F4EB');
$c = 0;
}
$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->set_var("nforo",$nforo);
flogos ($parent,$bigicon,$smallicon,$fornombre);
$t->set_var("logo",$smallicon);
$t->parse("entradas","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
t.tid,
t.title,
t.starter_name,
t.starter_id,
t.start_date,
t.last_poster_name,
t.last_poster_id,
t.posts,
t.last_post,
p.post,
x.avatar_location,
x.avatar_type,
x.signature,
x.avatar_size
FROM
ibf_topics t,
ibf_posts p,
ibf_member_extra x
WHERE
($fnews) AND
new_topic = 1 AND
p.topic_id = t.tid AND
t.approved = 1 AND
x.id = t.starter_id
ORDER BY
t.last_post DESC
LIMIT 5";
$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,
$avatar_url,
$tipo,
$signature,
$size) = mysql_fetch_row($result)) {
$a = 0;
$b = 0;
if ($tipo == "url"){
$t->set_var("avatar",$avatar_url);
} else {
if ($tipo == "upload"){
$avatar_url = str_replace("upload:", "", $avatar_url);
$avatar_url = "http://www.gamingcr.com/forums/uploads/".$avatar_url;
$t->set_var("avatar",$avatar_url);
} else {
$t->set_var("avatar", "http://gamingcr.com/images/Mapas/nomap.gif");
}
}
$a = strpos($text, '
');
$t->set_var("Mas",'');
if ($a > 0) {
$b = strpos($text, '
',$a+1);
//$c = $a + $b;
if ($b > 0){
$b = strpos($text, '
',$b+1);
if ($b > 0){
$text = substr($text, 0, $b);
$t->set_var("Mas",'');
}
}
}
reemplazo($text);
$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("foros","news",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
t.tid,
t.title,
t.starter_name,
t.starter_id,
t.start_date,
t.last_poster_name,
t.last_poster_id,
t.posts,
t.last_post,
p.post
FROM
ibf_topics t,
ibf_posts p
WHERE
($fnews) AND
new_topic = 1 AND
p.topic_id = t.tid AND
t.approved = 1
ORDER BY
t.last_post 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)) {
$title = strtolower ($title);
$title2 = $title;
$MAX_LENGTH = 100;
$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("noticias","enlaces",true);
}
//INFORMACION DE EQUIPOS//
$link = mysql_connect("$dbHost", "$dbUser", "$dbPass")
or die("Could not connect : " . mysql_error());
mysql_select_db("$dbDatabase1") or die("Could not select database");
/*$clan_manager = 0;*/
$i = 0;
$query = "SELECT
members.id,
members.members_display_name,
c.name,
c.initials,
c.slogan,
c.mail,
c.web,
c.recorddate,
c.avatar,
c.idclan,
c.iduser,
field_1 as nombre,
field_2 as apellido
FROM
tor_clan c,
ibf_members members left join
ibf_pfields_content as detalle
ON (members.id = detalle.member_id)
WHERE
idtournament= $torneo AND
members.id = c.iduser
ORDER BY
c.IdClan";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $id,
$nick,
$clan,
$iniciales,
$slogan,
$mail,
$web,
$inscripcion,
$avatar,
$idclan,
$iduser,
$nombre,
$apellido) = mysql_fetch_row($result)){
$i = $i + 1;
$t->set_var("equipo",$clan);
$t->set_var("idclan",$idclan);
$t->set_var("fecha",$inscripcion);
$t->set_var("iniciales",$iniciales);
$t->set_var("id",$id);
$t->set_var("nick",$nick);
$t->set_var("nombre",$nombre);
$t->set_var("apellido",$apellido);
$t->set_var("i",$i);
if ($i < 17) {
if ($c == 0){
$t->set_var("color",'#CBD1D9');
$c = 1;
}
else {
$t->set_var("color",'#E5E8EC');
$c = 0;
}
if ($iduser == $num_miembro){
$t->parse("elista","tlista_admin",true);
} else {
$t->parse("elista","tlista",true);
}
}
else
{
if ($c == 0){
$t->set_var("color",'#ECE9D8');
$c = 1;
}
else {
$t->set_var("color",'#F5F4EB');
$c = 0;
}
if ($iduser == $num_miembro){
$t->parse("lista_espera","tlista_admin",true);
} else {
$t->parse("lista_espera","tlista",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
members.id,
members.members_display_name,
PrimaryContact,
c.name,
c.initials,
c.slogan,
c.mail,
c.web,
c.recorddate,
c.avatar,
field_1 as nombre,
field_2 as apellido,
c.idclan,
c.iduser
FROM
tor_clan c left join
tor_clan_users u
ON (c.idclan = u.IdClan ),
ibf_members members left join
ibf_pfields_content as detalle
ON (members.id = detalle.member_id)
WHERE
idtournament= $torneo AND
members.id = u.iduser
ORDER BY
c.IdClan,
PrimaryContact DESC";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$equipo = "";
$i = 0;
while (list( $id,
$nick,
$contact,
$clan,
$iniciales,
$slogan,
$mail,
$web,
$inscripcion,
$avatar,
$nombre,
$apellido,
$idclan,
$iduser) = mysql_fetch_row($result)){
if ($equipo <> $clan){
$equipo = $clan;
$t->set_var("clan",$clan);
$t->set_var("idclan",$idclan);
$t->set_var("fecha",$inscripcion);
$t->set_var("iniciales",$iniciales);
$t->set_var("id",null);
$t->set_var("nick",null);
if ($iduser == $num_miembro){
$t->parse("clanes","tequipo_admin",true);
} else {
$t->parse("clanes","tequipo",true);
}
$c = 0;
}
if ($c == 0){
$t->set_var("color",'#ECE9D8');
$c = 1;
}
else {
$t->set_var("color",'#F5F4EB');
$c = 0;
}
if ($contact == 's'){
$titulo = 'Capitán';
$t->set_var("opcion","[Modificar Equipo]");
} else {
$titulo = '';
}
$t->set_var("titulo",$titulo);
$t->set_var("id",$id);
$t->set_var("idclan",$idclan);
$t->set_var("nick",$nick);
$t->set_var("nombre",$nombre);
$t->set_var("apellido",$apellido);
$t->set_var("dia",$dia);
$t->set_var("mes",$mes);
$t->set_var("anno",$anno);
if ($iduser == $num_miembro){
$t->parse("clanes","tadmin",true);
} else {
$t->parse("clanes","tmiembros",true);
}
}
//INFORMACION DE EQUIPOS//
$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
id,
masked_file_name,
directory
FROM
ibf_gallery_images
WHERE
$galeria
ORDER BY
RAND( NOW( ) )
LIMIT 1 ";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while (list( $tid,
$file,
$directorio) = mysql_fetch_row($result)) {
$file = 'http://www.gamingcr.com/forums/uploads/'.$directorio.'/'.$file;
$t->set_var("file",$file);
$t->set_var("file_tid",$tid);
}
$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);
?>