mediainfo php,media.php

require_once("configs.php");

$page_cat="media";

?>

<?php echo $website['title']; ?>

//

Core.staticUrl = '/wow/static';

Core.sharedStaticUrl= '/wow/static/local-common';

Core.baseUrl = '/wow/en';

Core.project = 'wow';

Core.locale = 'en-gb';

Core.buildRegion = 'eu';

Core.shortDateFormat= 'dd/MM/Y';

Core.loggedIn = false;

Flash.videoPlayer = 'http://eu.media.blizzard.com/wow/player/videoplayer.swf';

Flash.videoBase = 'http://eu.media.blizzard.com/wow/media/videos';

Flash.ratingImage = 'http://eu.media.blizzard.com/wow/player/rating-pegi.jpg';

var _gaq = _gaq || [];

_gaq.push(['_setAccount', 'UA-544112-16']);

_gaq.push(['_setDomainName', '.battle.net']);

_gaq.push(['_trackPageview']);

//]]>

1. <?php echo $website['title']; ?>
2. <?php echo $Media['Media']; ?>

$consulta0 = mysql_query(" SELECT * FROM media WHERE visible = 1 AND type = '0'");

$totalSql = mysql_num_rows($consulta0);

?>

视频欣赏 (<?php echo $totalSql; ?>)

$consulta1 = mysql_query("SELECT * FROM media WHERE visible = 1 AND type = '0' ORDER BY date DESC LIMIT 0,2");

while($video1 = mysql_fetch_assoc($consulta1)) {

?>

<?php echo substr(strip_tags($video1['description']),0,50); ?>...

上传时间: <?php echo date('d/m/Y', strtotime($video1['date'])); ?>

所有截图

$screen_all = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '2'");

$screen_total = mysql_num_rows($screen_all);

?>

游戏截图 (<?php echo $screen_total; ?>)

$pos = 0;

$screen_index = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '2' ORDER BY date DESC LIMIT 0,4");

while ($screen = mysql_fetch_assoc($screen_index)){

?>

href="media/images_visor.php?type=2&id=<?php echo $screen['id']; ?>#/<?php echo $screen['id']; ?>">

上传时间: <?php echo date('d/m/Y', strtotime($screen['date'])); ?>

$art_all = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '3'");

$art_total = mysql_num_rows($art_all);

?>

所有原画

原画欣赏 (<?php echo $art_total; ?>)

$pos = 0;

$art_index = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '3' ORDER BY date DESC LIMIT 0,2");

while ($art = mysql_fetch_assoc($art_index)){

?>

href="media/images_visor.php?type=3&id=<?php echo $art['id']; ?>#/<?php echo $art['id']; ?>">

上传时间: <?php echo date('d/m/Y', strtotime($art['date'])); ?>

$wall_all = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '1'");

$wall_total = mysql_num_rows($wall_all);

?>

所有壁纸

精美壁纸 (<?php echo $wall_total; ?>)

$pos = 0;

$wall_index = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '1' ORDER BY date DESC LIMIT 0,2");

while ($wall = mysql_fetch_assoc($wall_index)){

?>

href="media/images_visor.php?type=1&id=<?php echo $wall['id']; ?>#/<?php echo $wall['id']; ?>">

上传时间: <?php echo date('d/m/Y', strtotime($wall['date'])); ?>

$wall_all = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '4'");

$wall_total = mysql_num_rows($wall_all);

?>

所有漫画

精品漫画 (<?php echo $wall_total; ?>)

$pos = 0;

$wall_index = mysql_query("SELECT * FROM media WHERE visible = '1' AND type = '4' ORDER BY date DESC LIMIT 0,2");

while ($wall = mysql_fetch_assoc($wall_index)){

?>

href="media/images_visor.php?type=4&id=<?php echo $wall['id']; ?>#/<?php echo $wall['id']; ?>">

上传时间: <?php echo date('d/m/Y', strtotime($wall['date'])); ?>