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