-
+ 45625E035CBEA08FA61043A3B871BBA311DBBA860DB8688743916615688917FDE8390A8D7D2A87FD97199D83E3EAF7328FCD5CA62DED13C2E7967F7317782EC7
mp-wp/wp_db_sitemap.php
(0 . 0)(1 . 21)
161285 <?^M
161286 ^M
161287 $db_name = 'fill your own';^M
161288 $db_user = 'fill your own';^M
161289 $db_pass = 'fill your own';^M
161290 $table_prefix = 'fill your own';^M
161291 ^M
161292 $nconnection = mysql_connect("localhost:3306", $db_user, $db_pass );^M
161293 mysql_select_db($db_name, $nconnection);^M
161294 ^M
161295 $query = 'SELECT post_name, post_date FROM '.$table_prefix.'posts WHERE post_type ="post" AND post_status = "publish" ORDER BY ID DESC';^M
161296 $record=mysql_query($query);^M
161297 ^M
161298 while ( $row = mysql_fetch_array($record, MYSQL_NUM)) {^M
161299 ^M
161300 $year = substr($row[1],0,4);^M
161301 $name = 'http://fill your own/'.$year.'/'.$row[0].'/';^M
161302 ^M
161303 echo $name,"\r";^M
161304 }^M
161305 ?>^M