is_loggedin()) { $info = $SDK->get_info(); $num_miembro = $info['id']; }; $nsecid = 1 ; $torneo = 34; $nentradas = 63; $ndownload = 13; $galeria = "category_id = 57"; switch ($npagid) { case 0: $tmain = "inicio.html"; break; case 1: $tmain = "mapas.html"; break; case 2: $tmain = "participantes.html"; break; case 3: $tmain = "rondas.html"; break; case 4: $tmain = "posiciones.html"; break; default: $tmain = "inicio.html"; break; } $t->set_file(array( "mainpage" => $tmain, "tparticipantes" => "templates/template_participantes.htm", "entradas" => $path."_templates/tVariosNews.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 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, ibf_topics.forum_id FROM ibf_topics, ibf_posts WHERE ibf_topics.forum_id=63 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()); $c = 0; $n = 0; $totaln = 10; while (list( $tid, $title, $autor, $starter_id, $start_date, $last_poster, $last_poster_id, $posts, $last_post, $text, $foro) = mysql_fetch_row($result)) { $title = strtolower ($title); $title2 = $title; $MAX_LENGTH = 40; $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); } $a = 0; $b = 0; $a = strpos($text, '
0) { $text = substr($text, 0, $a); $t->set_var("Mas",''); } else { $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); //$text = utf8_encode_seguro($text); $fecha=date("j M Y, h:i A",$start_date); $last_post_date=date("j M Y, h:i A",$last_post); $n = $n + 1; if ($c == 0){ $t->set_var("clase",'rowPar'); $c = 1; } else { $t->set_var("clase",'rowImpar'); $c = 0; } $t->set_var("tid",$tid); $t->set_var("post_date",$fecha); $t->set_var("topic_title",$title); $t->set_var("topic_title2",$title2); $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); $avatar = "http://www.gamingcr.com/forums/html/forumicons/"; flogos ($foro,$bigicon,$smallicon,$fornombre); if ($n <= $totaln){ $t->set_var("avatar",$bigicon); $t->parse("ultimas_noticias","noticias",true); } $t->set_var("fornombre",$fornombre); $t->set_var("logo",$smallicon); $t->parse("ultimos_posts","entradas",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 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 6"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $i = 0; while (list( $fid, $fname) = mysql_fetch_row($result)) { $i = $i + 1; $fname = strtolower ($fname); $MAX_LENGTH = 40; $str_to_count = html_entity_decode($fname); if (strlen($str_to_count) >= $MAX_LENGTH) { $s2 = substr($str_to_count, 0, $MAX_LENGTH - 3); $s2 .= "..."; $fname = ($s2); } $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 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 6"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $i = 0; while (list( $tid, $title, $autor, $starter_id, $start_date, $last_poster, $last_poster_id, $posts, $last_post, $text) = mysql_fetch_row($result)) { $i = $i + 1; $title = strtolower ($title); $title2 = $title; $MAX_LENGTH = 40; $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("i",$i); $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 5"; $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 5"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $i = 0; while (list( $tid, $title, $autor, $starter_id, $start_date, $last_poster, $last_poster_id, $posts, $last_post, $text) = mysql_fetch_row($result)) { $i = $i + 1; $title = strtolower ($title); $title2 = $title; $MAX_LENGTH = 40; $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("i",$i); $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); } } } $i = $i + 1; while ($i < 13 ){ $t->set_var("i",$i); $t->set_var("equipo","Disponible"); $t->set_var("nick",""); $t->parse("elista","tlista",true); $i = $i + 1; } $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, u.fecha_inscripcion, members.mgroup FROM tor_jugador u, ibf_members members left join ibf_pfields_content as detalle ON (members.id = detalle.member_id) WHERE idtournament = '39' AND members.id = u.idgamer AND members.mgroup = '18' ORDER BY fecha_inscripcion ASC"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $i = 0; $c = 0; while (list( $id, $nick, $fecha, $premium) = mysql_fetch_row($result)){ $equipo = $clan; $t->set_var("id",$id); $t->set_var("nick",$nick); $i = $i + 1; if ($c == 0){ $t->set_var("color",'#ECE9D8'); $c = 1; } else { $t->set_var("color",'#F5F4EB'); $c = 0; } $fecha=date("j M Y, h:i A",$fecha); $t->set_var("i",$i); $t->set_var("id",$id); $t->set_var("nick",$nick); $t->set_var("fecha",$fecha); $t->set_var("premium","Premium Member"); if ($i > 1 ){ $t->parse("vejugadores","tparticipantes",true); } else { $t->parse("vjugadores","tparticipantes",true); } } $query = "SELECT members.id, members.members_display_name, u.fecha_inscripcion, members.mgroup FROM tor_jugador u, ibf_members members left join ibf_pfields_content as detalle ON (members.id = detalle.member_id) WHERE idtournament = '39' AND members.id = u.idgamer AND members.mgroup <> '18' ORDER BY fecha_inscripcion ASC"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); while (list( $id, $nick, $fecha, $premium) = mysql_fetch_row($result)){ $equipo = $clan; $t->set_var("id",$id); $t->set_var("nick",$nick); $i = $i + 1; if ($c == 0){ $t->set_var("color",'#ECE9D8'); $c = 1; } else { $t->set_var("color",'#F5F4EB'); $c = 0; } $fecha=date("j M Y, h:i A",$fecha); $t->set_var("i",$i); $t->set_var("id",$id); $t->set_var("nick",$nick); $t->set_var("fecha",$fecha); $t->set_var("premium","-"); if ($i < 9 ){ $t->parse("vjugadores","tparticipantes",true); } else { $t->parse("vejugadores","tparticipantes",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("colDerecha",$colDerecha); $t->set_var("colIzquierda",$colIzquierda); $t->set_var("rss_01",$rss_code_01); $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); ?>