Есть скрипт создающий video sitemap, проблемма в том, что он ничего толком не создаёт Есть какая-то ошибка Если что вот копия see.php и index.php http://file.qip.ru/file/GbSQOlh4/_see.html http://file.qip.ru/file/u39gfmE_/_3___index.html вот сам скрипт: PHP: <? include "config.php"; echo '<?xml version="1.0" encoding="UTF-8"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns="http://www.sitemaps.org/schemas/sitemap-image/1.1" xmlns="http://www.sitemaps.org/schemas/sitemap-video/1.1">'; $query_see = mysql_query("select id_video from video order by rand() limit 20000;"); while($data_see = mysql_fetch_array($query_see)){ $num = $parts_url[2]; $num = str_replace(".html", "", $num); if(empty($num)) $num = 1; if($num){ $query_video = mysql_query("select * from video where id_video='".$num."';"); $data_video = mysql_fetch_array($query_video); $open = fopen("http://www.pornhub.com/embed_player_v3.php?id=".$data_video['id'], "r"); $read = fread($open, 10000); $part = explode("<flv_url>", $read); $url = explode("</flv_url>", $part[1]); $part2 = explode("<img_url>", $read); $img = explode("</img_url>", $part2[1]); echo("<url> <loc>http://".$_SERVER['HTTP_HOST']."/see/".$data_see['id_video'].".html</loc> <image:image> <image:loc>$img[0]</image:loc> </image:image> <video:video> <video:content_loc>$url[0]</video:content_loc> <video:title>$n</video:title> </video> <priority>0.5</priority> </url>"); } } echo("</urlset>"); ?>
Ты либо весь скрипт выкладывай, либо Я не знаю. while($data_see = mysql_fetch_array($query_see)){ $num = $parts_url[2]; может всё таки $num = $data_see [2]; ?? Хотя нет вроду только 1 столбец выбирается.
index php PHP: <? include "config.php"; $url = $_SERVER['REQUEST_URI']; $parts_url = explode("/", $url); if(empty($parts_url[1])) $parts_url[1] = "main"; //Array ( [0] => [1] => video [2] => cat3 [3] => page3.html ) elseif($parts_url[1] == "video") { if(stripos($parts_url[2],".html")) { $parts_url[1] = "page"; } } $vstavka = ""; $query_all = mysql_query("select * from znacheniya;"); $data_all = mysql_fetch_array($query_all); $query_cat = mysql_query("select id, rus, video from category;"); include "meta.php"; //0 - 1 - 2 - 3 - 4 $nastroiki = explode("-", $data_all['nastroiki']); $menu = explode("!", $data_all['menu']); ?> </html> see.php PHP: <table border='0'> <? $num = $parts_url[2]; $num = str_replace(".html", "", $num); if(empty($num)) $num = 1; if($num){ $query_video = mysql_query("select * from video where id_video='".$num."';"); $data_video = mysql_fetch_array($query_video); $open = fopen("http://www.pornhub.com/embed_player_v3.php?id=".$data_video['id'], "r"); $read = fread($open, 10000); $part = explode("<flv_url>", $read); $url = explode("</flv_url>", $part[1]); $part2 = explode("<img_url>", $read); $img = explode("</img_url>", $part2[1]); $prosmotr = $data_video['prosmotr'] + 0.0001; $prosmotr = mysql_query("update video set prosmotr='".$prosmotr."' where id_video='".$num."';"); function added($dobavleno){ $date = $dobavleno; ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date, $regs); $month = array("","January","February","March","April","May","June","July","August","September","October","November","December"); $r_month = str_replace("0","",$regs[2]); $day = $regs[3]; if($regs[3] < 10) $day = str_replace("0","",$regs[3]); $date_dob = $day." ".$month[$r_month]; return $date_dob; } ?><td colspan='3'> <p align='center'><font class='silka'><? echo($data_video['name']); ?>...</font></p> <div id="player" align="center"><b>Please install Flash player.</b></div> <center><script type="text/javascript"> var s1 = new SWFObject("/player.swf","player","500","403","8"); s1.addParam("allowfullscreen","true"); s1.addVariable("width", "500"); s1.addVariable("height", "403"); s1.addVariable("file","<? echo($url[0]); ?>"); s1.addVariable("image", "<? echo($img[0]); ?>"); s1.addVariable("autostart", "false"); s1.addVariable("streamscript", 'lighttpd'); s1.write("player"); </script> <a href="http://hd.pornmixture.com"><img src="/images/hd.jpg"></a></center><br> </td></tr><tr> <td colspan='3' align='center'><center> <!-- AddThis Button BEGIN --> <div class="addthis_toolbox addthis_default_style"> <a href="http://www.addthis.com/bookmark.php?v=250&username=xa-4bdc22da4023161a" class="addthis_button_compact">Share</a> <span class="addthis_separator">|</span> <a class="addthis_button_facebook"></a> <a class="addthis_button_myspace"></a> <a class="addthis_button_google"></a> <a class="addthis_button_twitter"></a> </div> <script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=xa-4bdc22da4023161a"></script></center> <!-- AddThis Button END --> views: <? echo($data_video['prosmotr']*10000);?> | rating: <? echo(round($data_video['point']/ $data_video['golos'],1));?> | added: <? echo(added($data_video['putdate'])); ?> | <a href='<? echo($url[0]); ?>'><b>Download for free!</td><br /></tr> <? if($nastroiki[4] == 'true'){ echo("<tr><td colspan='3'><iframe src='/vote.php?id_video=".$data_video['id_video']."' frameborder='0' scrolling='no' height='190' width='300'>Please change your browser =)</iframe></td></tr>"); } ?> <tr><td>Comment:<br> <? $q_c = mysql_query("select msg from comment where id_video='".$num."' order by id_msg desc limit 10;"); while($data_com = mysql_fetch_array($q_c)){ echo($data_com['msg']."<hr style='color: #063ed5'>"); } echo("</td></tr>"); }//if $num ?> <tr><td colspan='3'><font class='tbl'><b>Random porn:</b></font></td></tr> <tr> <? $query_r_v = mysql_query("select * from video order by rand() limit 12;"); $i = 0; while($data_r_v = mysql_fetch_array($query_r_v)){ $i++; $data_r_v['vremya'] *= 10000; $minut = explode(".",$data_r_v['vremya']/60); $sec = round($data_r_v['vremya'] - $minut[0]*60,0); if($sec < 10) $sec = "0".$sec; if($minut[0]<10) $minut[0] = "0".$minut[0]; $vremya = $minut[0].":".$sec; ?><td align='center'> <div class = "video_box"> <a href="http://<? echo($_SERVER['HTTP_HOST']); ?>/see/<? echo($data_r_v['id_video']); ?>.html"> <img src="http://p1.pornhub.com/thumbs/<? echo($data_r_v['foto_small']); ?>/small.jpg?cache_control=0" alt="<? echo($data_r_v['name']);?>" width="160" height="120" id="<? echo($data_r_v['foto']); ?>" onmouseover="startThumbChange('<? echo($data_r_v['foto']); ?>', 16, 'http://pics1.pornhub.com/thumbs/<? echo($data_r_v['foto_small']); ?>/');" onmouseout="endThumbChange('<? echo($data_r_v['foto']); ?>', 'http://pics1.pornhub.com/thumbs/<? echo($data_r_v['foto_small']); ?>/');" border="0"/> </a></div> <? if($nastroiki[0] == "true"){ if($nastroiki[3] == "false") { $simbol = 23; } else{ $simbol = 18; } echo(substr($data_r_v['name'],0,$simbol)."..."); } if($nastroiki[0] == "true" && $nastroiki[3] == "true") echo(" | "); if($nastroiki[3] == "true"){ echo($vremya); } echo("<br>"); if($nastroiki[2] == "true"){ echo("<img src='/images/eye.gif' alt='views:'> ".$data_r_v['prosmotr']*10000); $e=1; } if($nastroiki[2] == "true" && $nastroiki[1] == "true") echo(" | "); if($nastroiki[1] == "true"){ echo(added($data_r_v['putdate'])); } echo("</td>"); if($i == 3){ echo("</tr><tr>"); $i = 0; } } ?> </tr> </table>