Projects : mp-wp : mp-wp_genesis
| 1 | <? |
| 2 | |
| 3 | $db_name = 'fill your own'; |
| 4 | $db_user = 'fill your own'; |
| 5 | $db_pass = 'fill your own'; |
| 6 | $table_prefix = 'fill your own'; |
| 7 | |
| 8 | $nconnection = mysql_connect("localhost:3306", $db_user, $db_pass ); |
| 9 | mysql_select_db($db_name, $nconnection); |
| 10 | |
| 11 | $query = 'SELECT post_name, post_date FROM '.$table_prefix.'posts WHERE post_type ="post" AND post_status = "publish" ORDER BY ID DESC'; |
| 12 | $record=mysql_query($query); |
| 13 | |
| 14 | while ( $row = mysql_fetch_array($record, MYSQL_NUM)) { |
| 15 | |
| 16 | $year = substr($row[1],0,4); |
| 17 | $name = 'http://fill your own/'.$year.'/'.$row[0].'/'; |
| 18 | |
| 19 | echo $name,"\r"; |
| 20 | } |
| 21 | ?> |