raw
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 ?>