'; echo ''; error_reporting( E_ERROR ); $fd = "../inc/dbvars.inc"; $fd = fopen($fd, 'r'); $vars = fgetcsv($fd, 500, ','); $db_name = $vars[0]; $db_user = $vars[1]; $db_pass = $vars[2]; mysql_pconnect("localhost", $db_user, $db_pass); mysql_select_db($db_name); $query = "SELECT * from preferences WHERE id = '1' "; $result = mysql_query($query); $row = mysql_fetch_array($result); $title = $row['title']; $pagetitle = $row['title']; $sitetitle = $title; $desc = $row['description']; $url = $row['url']; $query = "SELECT * from pages order by date desc"; $result = mysql_query($query); $num_results = mysql_num_rows($result); for ($i=1; $i <= $num_results; $i++) { $row = mysql_fetch_array($result); $ref = $row['ref']; $pagetitle = $row['title']; echo '' . "\n"; echo ''.$url.'/'.$ref.'.htm' . "\n"; // echo ''.date("d-m-Y", time()-86400).'' . "\n"; echo 'monthly' . "\n"; echo '0.8' . "\n"; echo '' . "\n"; } $query = "SELECT * from categories order by category asc"; $result = mysql_query($query); $num_results = mysql_num_rows($result); for ($i=1; $i <= $num_results; $i++) { $row = mysql_fetch_array($result); $id = $row['id']; $category = $row['category']; $filename = $url.'/'.$id.'.html'; echo '' . "\n"; echo ''.$url.'/'.$id.'.html' . "\n"; // echo ''.date("d-m-Y", time()-86400).'' . "\n"; echo 'monthly' . "\n"; echo '0.8' . "\n"; echo '' . "\n"; } $query = "SELECT * from domains order by added desc"; $result = mysql_query($query); $num_results = mysql_num_rows($result); for ($i=1; $i <= $num_results; $i++) { $row = mysql_fetch_array($result); $id = $row['id']; $dn = $row['domain']; $private = $row['private']; if ( $private != 'yes' ) { $dn_array = explode('.',$dn); $name = strtolower($dn_array[0]); echo '' . "\n"; echo ''.$url.'/'.$id.'-'.$name.'.html' . "\n"; // echo ''.date("d-m-Y", time()-86400).'' . "\n"; echo 'monthly' . "\n"; echo '0.8' . "\n"; echo '' . "\n"; } } echo ''; ?>