eval('$bits .="' . fetch_template('GARS_banner_up_2') . '";'); eval('$output .="' . fetch_template('GARS_mod_container') . '";'); ?> if (!defined('VB_AREA') || !defined('DIR')) { exit(); } global $threadinfo, $post, $thread, $vbphrase; $elbyline=$vbulletin->db->query_first("SELECT vb_gars.byline FROM vb_gars WHERE vb_gars.threadid = " . $thread['threadid']); $displaygame = $vbulletin->db->query_first(" SELECT game. * , r.gameid FROM vb_psnstore AS game LEFT JOIN vb_r_juego_store AS r ON game.psnstore_id = r.psnstore_id LEFT JOIN vb_mindesticgcms_game AS ficha ON ficha.gameid = r.gameid WHERE ficha.gamename = '". $db->escape_string($elbyline['byline']) ."' "); // =========================================================================================== // Start displaying results found for games. (Edit by: Lucas) // =========================================================================================== eval('$output .="' . fetch_template('GARS_2014_noticias_relacionado') . '";'); ?> if (!defined('VB_AREA') || !defined('DIR')) { exit(); } global $threadinfo, $post, $thread, $vbphrase; $forumids = "2,120,43,72"; // Comma seperated list of forumids $limit = 10; // How many items to show $title = "Destacados"; // Module Title $featured = 0; // 1= Only featured items $url_to_default_image = "types/3/default.jpg"; //Relative URL to default image from geek/gars/images/ folder $vertical = 0; // 1= Vertical (only for template 1 or 3) $preview = 1; // 1= Show preview $ratings = 1; // 1=show ratings $template = 2; // 1=simple with pic, 2=big with pic, 3=Listing no pic $order = 1; // 0 = rand, 1=desc, 2=asc $maxchars = 300; // Maximum amount of chards to snip $customfields = ""; // comma seperated list of custom field ids to fetch too (i.e. gars1,gars4) switch ($order) { case 0: $order = "RAND()"; break; case 1: $order = "g.threadid DESC"; break; default: $order = "g.threadid ASC"; } if (!$limit) { $limit = "1"; } $sql = "SELECT g.threadid,g.header_image image, p.title, g.byline,t.forumid" . ($preview ? ", g.synopsis synopsis " : "") . ($ratings ? ",round((g.overall_rating/10),0) author_rating, g.overall_rating author_rating_percent,round((g.avg_rating/10),0) member_rating, g.avg_rating member_rating_percent " : "" ) . ",g.pagecount, g.custom2,t.replycount, t.dateline as postdateline, t.postusername, t.postuserid, t.views " . ($customfields ? ",$customfields " : "") . " FROM " . TABLE_PREFIX . "gars g INNER JOIN " . TABLE_PREFIX . "thread t ON g.threadid = t.threadid " . ($customfields ? " INNER JOIN " . TABLE_PREFIX . "gars_custom_values gcv ON gcv.custom_threadid = g.threadid " : "") . " INNER JOIN " . TABLE_PREFIX . "post p ON t.firstpostid = p.postid WHERE t.visible = 1 AND t.open != 10 AND t.dateline > " . (time() - (3600*168)) . " " . ($forumids ? " AND t.forumid in ($forumids) " : "" ) . " " . ($featured ? " AND g.feature_untill> " . TIMENOW : "") . " ORDER BY t.replycount DESC LIMIT 5"; $results = $db->query_read($sql); $modulehtml = ""; $x = 0; $bburl = $vbulletin->options['bburl']; if ($template==2) { $vertical = 1; } while ($result = $db->fetch_array($results)) { $getpics = $db->query_first("SELECT a.attachmentid as attach,a.filename as archivo from ".TABLE_PREFIX."thread as t LEFT JOIN ".TABLE_PREFIX."post as p on(t.firstpostid=p.postid) LEFT JOIN ".TABLE_PREFIX."attachment as a on(a.postid=p.postid) where t.threadid='" . $result['threadid'] . "' AND a.filename='reportada.jpg'"); $result['dateposted']=vbdate('M d, Y - g:i A', $result['postdateline'], '', ''); if (!$result['image']) { $result['image'] = "http://st.laps3.com/geek/gars/images/" . $url_to_default_image; } elseif (substr($result['image'], 0, 1) == ".") { $result['image'] = "http://st.laps3.com" . substr($result['image'], 1); } else { $result['image'] = "http://st.laps3.com" . $result['image']; } if ($parsebb && $template!=3) { $result['message'] = $bbcode_parser->do_parse($result['synopsis'], 0, 1, 1, 1); } else { $result['message'] = strip_bbcode($result['synopsis']); } if (strlen($result['message']) > $maxchars) { $result['message'] = substr($result['message'], 0, strrpos(substr($result['message'], 0, $maxchars), ' ')) . '...' . ($template!=3 ? construct_phrase($vbphrase['read_more'], $vbulletin->options['bburl'], $result['threadid'], $session['sessionurl']) : ""); } switch($result['forumid']) { case 2: $tipo_new="NOTICIA"; break; case 43: $tipo_new="ANALISIS"; break; case 72: $tipo_new="AVANCE"; break; case 120: $tipo_new="PSN"; break; default: $tipo_new="NOTICIA"; break; } include_once('/furanet/sites/laps3.com/web/htdocs/foro/dbtech/dbseo/includes/class_core.php'); DBSEO::init(); $th = fetch_threadinfo($result['threadid']); $raw = DBSEO_Url_Create::create('Thread_Thread', $th); $result['vbseourl'] = str_replace("2_noticias/", "noticias/", $raw); $result['vbseourl'] = str_replace("43_analisis_reviews/", "analisis/", $result['vbseourl']); $result['vbseourl'] = str_replace("72_avances/", "avances/", $result['vbseourl']); $result['vbseourl'] = str_replace("120_psn/", "psn/", $result['vbseourl']); $result['vbseourl'] = str_replace("_a.html", ".html", $result['vbseourl']); // 40_tutoriales_guias_de_laps3_com $result['vbseourl'] = str_replace("40_tutoriales_guias_de_laps3_com/", "tutoriales/", $result['vbseourl']); eval('$bits .="' . fetch_template('GARS_2013_comentadas_bits') . '";'); } eval('$output .="' . fetch_template('GARS_2013_comentadas') . '";'); ?> $unocu = rand(1,4); global $publixtra; global $urlpublixtra; switch ($unocu) { case 1: $publixtra="LAPS3_Tritton.jpg"; $urlpublixtra="http://www.xtralife.es/buscar/tritton/todos/0/96?utm_source=laps3&utm_medium=banner&utm_campaign=tritton"; break; case 2: $publixtra="LAPS3_Essentials.jpg"; $urlpublixtra="http://www.xtralife.es/playstation-3/juegos/essentials/0/todos/cant/48/order/nombre/0?utm_source=laps3&utm_medium=banner&utm_campaign=essentials"; break; case 3: $publixtra="LAPS3_AC3_Merchandising.jpg"; $urlpublixtra="http://www.xtralife.es/buscar/assassinscreed3/todos/0/98?utm_source=laps3&utm_medium=banner&utm_campaign=assassinscreed3"; break; case 4: $publixtra="Banner_300x250_OFERTA_3x2.jpg"; $urlpublixtra="http://www.xtralife.es/buscar/promo:53/todos/0/96?utm_source=laps3&utm_medium=banner&utm_campaign=3x2"; break; default: $publixtra="Banner_300x250_OFERTA_3x2.jpg"; $urlpublixtra="http://www.xtralife.es/buscar/promo:53/todos/0/96?utm_source=laps3&utm_medium=banner&utm_campaign=3x2"; break; } eval('$bits .="' . fetch_template('GARS_banner_UP') . '";'); eval('$output .="' . fetch_template('GARS_mod_container') . '";'); ?> if (!defined('VB_AREA') || !defined('DIR')) { exit(); } global $threadinfo, $post, $thread, $vbphrase; $forumids = "2,120"; // Comma seperated list of forumids $limit = 10; // How many items to show $title = "Destacados"; // Module Title $featured = 0; // 1= Only featured items $url_to_default_image = "types/3/default.jpg"; //Relative URL to default image from geek/gars/images/ folder $vertical = 0; // 1= Vertical (only for template 1 or 3) $preview = 1; // 1= Show preview $ratings = 1; // 1=show ratings $template = 2; // 1=simple with pic, 2=big with pic, 3=Listing no pic $order = 1; // 0 = rand, 1=desc, 2=asc $maxchars = 300; // Maximum amount of chards to snip $customfields = ""; // comma seperated list of custom field ids to fetch too (i.e. gars1,gars4) switch ($order) { case 0: $order = "RAND()"; break; case 1: $order = "g.threadid DESC"; break; default: $order = "g.threadid ASC"; } if (!$limit) { $limit = "1"; } $sql = "SELECT g.threadid,g.header_image image, p.title, g.byline,t.forumid" . ($preview ? ", g.synopsis synopsis " : "") . ($ratings ? ",round((g.overall_rating/10),0) author_rating, g.overall_rating author_rating_percent,round((g.avg_rating/10),0) member_rating, g.avg_rating member_rating_percent " : "" ) . ",g.pagecount, g.custom2,t.replycount, t.dateline as postdateline, t.postusername, t.postuserid, t.views " . ($customfields ? ",$customfields " : "") . " FROM " . TABLE_PREFIX . "gars g INNER JOIN " . TABLE_PREFIX . "thread t ON g.threadid = t.threadid " . ($customfields ? " INNER JOIN " . TABLE_PREFIX . "gars_custom_values gcv ON gcv.custom_threadid = g.threadid " : "") . " INNER JOIN " . TABLE_PREFIX . "post p ON t.firstpostid = p.postid WHERE t.visible = 1 AND t.open != 10 AND t.dateline > " . (time() - (3600*265)) . " " . ($forumids ? " AND t.forumid in ($forumids) " : "" ) . " " . ($featured ? " AND g.feature_untill> " . TIMENOW : "") . " AND t.threadid<>" . $threadinfo[threadid] . " ORDER BY t.dateline DESC LIMIT 10"; $results = $db->query_read($sql); $modulehtml = ""; $x = 0; $bburl = $vbulletin->options['bburl']; if ($template==2) { $vertical = 1; } while ($result = $db->fetch_array($results)) { $result['dateposted']=vbdate('M d, Y - g:i A', $result['postdateline'], '', ''); if (!$result['image']) { $result['image'] = "http://st.laps3.com/geek/gars/images/" . $url_to_default_image; } elseif (substr($result['image'], 0, 1) == ".") { $result['image'] = "http://st.laps3.com" . substr($result['image'], 1); } else { $result['image'] = "http://st.laps3.com" . $result['image']; } if ($parsebb && $template!=3) { $result['message'] = $bbcode_parser->do_parse($result['synopsis'], 0, 1, 1, 1); } else { $result['message'] = strip_bbcode($result['synopsis']); } if (strlen($result['message']) > $maxchars) { $result['message'] = substr($result['message'], 0, strrpos(substr($result['message'], 0, $maxchars), ' ')) . '...' . ($template!=3 ? construct_phrase($vbphrase['read_more'], $vbulletin->options['bburl'], $result['threadid'], $session['sessionurl']) : ""); } $th = fetch_threadinfo($result['threadid']); include_once('/furanet/sites/laps3.com/web/htdocs/foro/dbtech/dbseo/includes/class_core.php'); DBSEO::init(); $raw = DBSEO_Url_Create::create('Thread_Thread', $th); $result['vbseourl'] = str_replace("2_noticias/", "noticias/", $raw); $result['vbseourl'] = str_replace("43_analisis_reviews/", "analisis/", $result['vbseourl']); $result['vbseourl'] = str_replace("72_avances/", "avances/", $result['vbseourl']); $result['vbseourl'] = str_replace("120_psn/", "psn/", $result['vbseourl']); $result['vbseourl'] = str_replace("_a.html", ".html", $result['vbseourl']); // 40_tutoriales_guias_de_laps3_com $result['vbseourl'] = str_replace("40_tutoriales_guias_de_laps3_com/", "tutoriales/", $result['vbseourl']); eval('$bits .="' . fetch_template('GARS_2013_ultimas_bits') . '";'); } eval('$output .="' . fetch_template('GARS_2013_ultimas') . '";'); ?> if (!defined('VB_AREA') || !defined('DIR')) { exit(); } global $threadinfo, $post, $thread, $vbphrase; $autor=$vbulletin->db->query_first("SELECT * FROM vb_author WHERE userid=" . $thread[postuserid] ); eval('$output .="' . fetch_template('GARS_autor') . '";'); ?> if (!defined('VB_AREA') || !defined('DIR')) { exit(); } global $threadinfo, $post, $thread, $vbphrase; //$autor=$vbulletin->db->query_first("SELECT * FROM vb_author WHERE userid=" . $thread[postuserid] ); eval('$output .="' . fetch_template('GARS_comentarios') . '";'); ?>