For all the Russian users out there - here is the google.php that works on my site
it transliterates the categories and images names to become Google friendly. the transliteration function MUST be exactly identical to the one stored in sessions.php
<?
# Create Google Sitemap for 4images
# Created by Mai Minh (minh@maingo.com http://www.vna2z.com)
# Modified by Oliver van der Werf (info@flash-webdesign.de http://www.flash-webdesign.de)
# Date: 28/11/2006 | 02.01.2007
# You can send ping to Google with this request: http://www.google.com/webmasters/sitemaps/ping?sitemap=URL_TO_YOUR_SITEMAP
#---------------------------------
require("config.php");
//require(ROOT_PATH.'includes/sessions.php');
$link=mysql_connect("$db_host","$db_user","$db_password");
mysql_select_db("$db_name") or die ("Cannot connect database!");
# 4images top page (with trailing slash)
$gallery_url = 'http://www.fotodvor.com/';
# Priotity
//select between 0.0 and 1.0
//0.0 identifies the lowest priority page(s) on your website
//1.0 identifies the highest priority page(s) on your website
$prio_img = 0.5;
$prio_cat = 0.8;
$prio_profile = 0.1;
# Frequency
//"always", "hourly", "daily", "weekly", "monthly", "yearly" or "never"
$freq_img = 'daily';
$freq_cat = 'daily';
$freq_profile = 'monthly';
# Use Short URLs
$shortURL = 1; // 0 or 1
# Print XML header
xml_head();
# Print URLs
$categories = mysql_query('SELECT cat_id, cat_name FROM ' . $table_prefix . 'categories');
while ($category = mysql_fetch_array($categories))
{
$catid = $category['cat_id'];
$catname = strtr($category['cat_name'], " eeeaeauoiiaaABCDEFGHIJKLMNOPQRSTUVWXYZ","-eeeaeauoiiaaabcdefghijklmnopqrstuvwxyz");
$catname = fixname($catname);
if ($shortURL == 1) {
$cat_url = $gallery_url.'cat-'.$catname.'-'.$catid.'.htm';
}else {
$cat_url = $gallery_url.'categories.php?cat_id='.$catid;
}
print_xml($cat_url,$prio_cat,$lastmod,$freq_cat);
}
$images = mysql_query('SELECT image_id,image_name,image_active,image_date FROM ' . $table_prefix . 'images');
while ($image = mysql_fetch_array($images))
{
if ($image['image_active'] == 1) {
$imgid = $image['image_id'];
$imgname = strtr($image['image_name'], ", eeeaeauoiiaaABCDEFGHIJKLMNOPQRSTUVWXYZ","--eeeaeauoiiaaabcdefghijklmnopqrstuvwxyz");
$imgname = fixname ($imgname);
$date = $image['image_date'];
$lastmod = date("Y-m-d",$date)."T".date("H:i:s",$date)."+00:00";
if ($shortURL == 1) {
$img_url = $gallery_url.'img-'.$imgname.'-'.$imgid.'.htm';
}else{
$img_url = $gallery_url.'details.php?image_id='.$imgid;
}
print_xml($img_url,$prio_img,$lastmod,$freq_img);
}
}
$profiles = mysql_query('SELECT user_id, user_lastaction FROM ' . $table_prefix . 'users WHERE user_id >= "1"');
while ($profile = mysql_fetch_array($profiles))
{
$profileid = $profile['user_id'];
$date = $profile['user_lastaction'];
if ($date == 0) {
$date_ = time();
$date = date("Y-m-d",$date_)."T".date("H:i:s",$date_)."+00:00";
} else {
$date = date("Y-m-d",$date)."T".date("H:i:s",$date)."+00:00";
}
$profile_url = $gallery_url.'member.php?action=showprofile&user_id='.$profileid;
print_xml($profile_url,$prio_profile,$date,$freq_profile);
}
# Print XML footer
xml_foot();
function xml_head() {
$freq = 'daily';
$priority = '1.0';
$mod = date("Y-m-d")."T".date("H:i:s")."+00:00";
echo "<?xml version='1.0' encoding='UTF-8'?>
<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\"
xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
xsi:schemaLocation=\"http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd\">";
}
#-----------------------------------------------
# xml_foot
#-----------------------------------------------
function xml_foot() {
echo "
</urlset>";
}
#-----------------------------------------------
# print_xml
#-----------------------------------------------
function print_xml($url,$priority,$lastmod,$changefreq) {
$temp = "<url>
<loc>$url</loc>";
$temp .= " <priority>$priority</priority>";
if ($lastmod != '') {
$temp .=" <lastmod>$lastmod</lastmod>";
}
$temp .= " <changefreq>$changefreq</changefreq>
</url>";
echo $temp;
}
function fixname($text)
{
return strtolower(strtr(
$text,
array(
"e" => "e",
"e" => "e",
"e" => "e",
"a" => "a",
"e" => "e",
"a" => "a",
"u" => "a",
"o" => "o",
"i" => "i",
"a" => "a",
//russian UTF8 encoded alphabet (lower and upper cases)
"А" => "a",
"а" => "a",
"Б" => "b",
"б" => "b",
"В" => "v",
"в" => "v",
"Г" => "g",
"г" => "g",
"Д" => "d",
"д" => "d",
"Е" => "e",
"е" => "e",
"Ё" => "yo",
"ё" => "yo",
"Ж" => "zh",
"ж" => "zh",
"З" => "z",
"з" => "z",
"И" => "i",
"и" => "i",
"Й" => "j",
"й" => "j",
"К" => "k",
"к" => "k",
"Л" => "l",
"л" => "l",
"М" => "m",
"м" => "m",
"Н" => "n",
"н" => "n",
"О" => "o",
"о" => "o",
"П" => "p",
"п" => "p",
"Р" => "r",
"р" => "r",
"С" => "s",
"с" => "s",
"Т" => "t",
"т" => "t",
"У" => "u",
"у" => "u",
"Ф" => "f",
"ф" => "f",
"Х" => "h",
"х" => "h",
"Ц" => "c",
"ц" => "c",
"Ч" => "ch",
"ч" => "ch",
"Ш" => "sh",
"ш" => "sh",
"Щ" => "sch",
"щ" => "sch",
"Ъ" => "",
"ъ" => "",
"Ы" => "i",
"ы" => "i",
"Ь" => "'",
"ь" => "'",
"Э" => "e",
"э" => "e",
"Ю" => "yu",
"ю" => "yu",
"Я" => "ya",
"я" => "ya",
//russian 1251 encoded alphabet (lower and upper cases)
"а" => "a",
"А" => "a",
"б" => "b",
"Б" => "b",
"в" => "v",
"В" => "v",
"г" => "g",
"Г" => "g",
"д" => "d",
"Д" => "d",
"е" => "e",
"Е" => "e",
"ё" => "yo",
"Ё" => "yo",
"ж" => "zh",
"Ж" => "zh",
"з" => "z",
"З" => "z",
"и" => "i",
"И" => "i",
"й" => "j",
"Й" => "j",
"к" => "k",
"К" => "k",
"л" => "l",
"Л" => "l",
"м" => "m",
"М" => "m",
"н" => "n",
"Н" => "n",
"о" => "o",
"О" => "o",
"п" => "p",
"П" => "p",
"р" => "r",
"Р" => "r",
"с" => "s",
"С" => "s",
"т" => "t",
"Т" => "t",
"у" => "u",
"У" => "u",
"ф" => "f",
"Ф" => "f",
"х" => "h",
"Х" => "h",
"ц" => "c",
"Ц" => "c",
"ч" => "ch",
"Ч" => "ch",
"ш" => "sh",
"Ш" => "sh",
"щ" => "sch",
"Щ" => "sch",
"ъ" => "",
"Ъ" => "",
"ы" => "i",
"Ы" => "i",
"ь" => "'",
"Ь" => "'",
"э" => "e",
"Э" => "e",
"ю" => "yu",
"Ю" => "yu",
"я" => "ya",
"Я" => "ya",
"/" => "",
"&" => "-",
"№" => "",
"," => "-",
"°" => "",
"\"" => "",
"і" => "i", //ukranian i
"ї" => "i", //ukranian ї
"є" => "e", //ukranian є
"«" => "",
"»" => "",
)));
}
?>