Heru Kurniawan WebLog

CREATE TABLE `t_artikel` (
`no` INT(11) NOT NULL AUTO_INCREMENT,
`judul` VARCHAR(200) COLLATE latin1_general_ci DEFAULT NULL,
`isi` text COLLATE latin1_general_ci,
`tanggal` datetime DEFAULT NULL,
PRIMARY KEY  (`no`)
)

<!-- generator="batam gallery" --><!-- sitemap-generator-url="http://www.herukurniawan.com" --><!-- generated-on="JULY 19, 2009 12:53 pm" --><!-- Debug: Total comment count: 387 -->	
		http://'.$_SERVER['SERVER_NAME'].'/
		'.date('Y-m-d',strtotime("now")).'T14:00:00+00:00
		daily
1.0
	';
$sql="SELECT * FROM t_artikel ORDER BY no DESC";
			$rs = mysql_query($sql);
			while($fields = mysql_fetch_row($rs))
			{
					$no         = $fields[0];
					$title      = $fields[1];
					$date       = $fields[3];
$text = $text.'
	<!-- Debug: Start Postings --><!-- Debug: Priority report of postID '.$no.': Comments: 0 of 387 = 0 points -->	';
$text = $text.'
			http://'.$_SERVER['SERVER_NAME'].'/?p=album&amp;no='.$no.'
			'.$date.'T14:00:00+00:00
			monthly
0.2
			';
			}
$text = $text.'<!-- Debug: End Postings --><!-- Debug: Start Custom Pages --><!-- Debug: End Custom Pages --><!-- Debug: Start additional URLs --><!-- Debug: End additional URLs -->';
fputs($f, $text);
fclose($f);
?&gt;

	XML Sitemap
 
				<!--
					body {
						font-family:"Lucida Grande","Lucida Sans Unicode",Tahoma,Verdana;
						font-size:13px;
					}
 
					#intro {
						background-color:#CFEBF7;
						border:1px #2580B2 solid;
						padding:5px 13px 5px 13px;
						margin:10px;
					}
 
					#intro p {
						line-height:	16.8667px;
					}
 
					td {
						font-size:11px;
					}
 
					th {
						text-align:left;
						padding-right:30px;
						font-size:11px;
					}
 
					tr.high {
						background-color:whitesmoke;
					}
 
					#footer {
						padding:2px;
						margin:10px;
						font-size:8pt;
						color:gray;
					}
 
					#footer a {
						color:gray;
					}
 
					a {
						color:black;
					}
 
-->
<h1>XML Sitemap</h1>
<div id="intro">
 
						This is a XML Sitemap which is supposed to be processed by search engines like <a href="http://www.google.com">Google</a>, <a href="http://search.msn.com">MSN Search</a> and <a href="http://www.yahoo.com">YAHOO</a>.
 
						It was generated using the <a href="http://batamgallery.web.id/">Batam Gallery</a> and the <a title="Google Sitemap Generator Plugin for your coustum web" href="http://herukurniawan.com">Google Sitemap Generator </a> by <a href="http://herukurniawan.com/">Heru Kurniawan</a>.
 
						You can find more information about XML sitemaps on <a href="http://sitemaps.org">sitemaps.org</a> and Google's <a href="http://code.google.com/sm_thirdparty.html">list of sitemap programs</a>.</div>
<div id="content">
<table border="0" cellpadding="5">
<tbody>
<tr style="border-bottom:1px black solid;">
<th>URL</th>
<th>Priority</th>
<th>Change Frequency</th>
<th>LastChange</th>
</tr>
<tr>
 
									high
<td>
 
									<a href="{$itemURL}">
 
									</a></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody></table>
</div>
<div id="footer">
					Generated with <a title="Google Sitemap Generator Plugin" href="http://herukurniawan.com">Google Sitemap Generator</a> by <a href="http://herukurniawan.com">Heru Kurniawan</a> This XSLT template is released under GPL.</div>