1
Mods & Plugins (Releases & Support) / Re: [MOD] Google Sitemap for your gallery
« on: July 03, 2015, 08:06:30 PM »
A little update for this mod.
Looks like the old schema validation did not work.
here is a good site to validate your sitemap
http://www.xmlcheck.com/
Here is my google.php (with my conversion from win1251 to utf-8)
<?
# 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
#---------------------------------
define('ROOT_PATH', './');
require("config.php");
include(ROOT_PATH.'global.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
$prio_cat
$prio_profile
# Frequency
//"always", "hourly", "daily", "weekly", "monthly", "yearly" or "never"
$freq_img
$freq_cat
$freq_profile
# Use Short URLs
$shortURL
# 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))
{
}
$images = mysql_query('SELECT image_id,image_name,image_active,image_date FROM ' . $table_prefix . 'images');
while ($image = mysql_fetch_array($images))
{
$imgname = strtr($image['image_name'], ", eeeaeauoiiaaABCDEFGHIJKLMNOPQRSTUVWXYZ","--eeeaeauoiiaaabcdefghijklmnopqrstuvwxyz");
}
$profiles = mysql_query('SELECT user_id, user_lastaction FROM ' . $table_prefix . 'users WHERE user_id >= "1"');
while ($profile = mysql_fetch_array($profiles))
{
}
# Print XML footer
xml_foot();
function xml_head() {
}
#-----------------------------------------------
# xml_foot
#-----------------------------------------------
function xml_foot() {
</urlset>";
}
#-----------------------------------------------
# print_xml
#-----------------------------------------------
function print_xml($url,$priority,$lastmod,$changefreq) {
}
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)
"&#1040;" => "a",
"&#1072;" => "a",
"&#1041;" => "b",
"&#1073;" => "b",
"&#1042;" => "v",
"&#1074;" => "v",
"&#1043;" => "g",
"&#1075;" => "g",
"&#1044;" => "d",
"&#1076;" => "d",
"&#1045;" => "e",
"&#1077;" => "e",
"&#1025;" => "yo",
"&#1105;" => "yo",
"&#1046;" => "zh",
"&#1078;" => "zh",
"&#1047;" => "z",
"&#1079;" => "z",
"&#1048;" => "i",
"&#1080;" => "i",
"&#1049;" => "j",
"&#1081;" => "j",
"&#1050;" => "k",
"&#1082;" => "k",
"&#1051;" => "l",
"&#1083;" => "l",
"&#1052;" => "m",
"&#1084;" => "m",
"&#1053;" => "n",
"&#1085;" => "n",
"&#1054;" => "o",
"&#1086;" => "o",
"&#1055;" => "p",
"&#1087;" => "p",
"&#1056;" => "r",
"&#1088;" => "r",
"&#1057;" => "s",
"&#1089;" => "s",
"&#1058;" => "t",
"&#1090;" => "t",
"&#1059;" => "u",
"&#1091;" => "u",
"&#1060;" => "f",
"&#1092;" => "f",
"&#1061;" => "h",
"&#1093;" => "h",
"&#1062;" => "c",
"&#1094;" => "c",
"&#1063;" => "ch",
"&#1095;" => "ch",
"&#1064;" => "sh",
"&#1096;" => "sh",
"&#1065;" => "sch",
"&#1097;" => "sch",
"&#1066;" => "",
"&#1098;" => "",
"&#1067;" => "i",
"&#1099;" => "i",
"&#1068;" => "'",
"&#1100;" => "'",
"&#1069;" => "e",
"&#1101;" => "e",
"&#1070;" => "yu",
"&#1102;" => "yu",
"&#1071;" => "ya",
"&#1103;" => "ya",
"а" => "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",
"/" => "",
)));
}
?>
Looks like the old schema validation did not work.
here is a good site to validate your sitemap
http://www.xmlcheck.com/
Here is my google.php (with my conversion from win1251 to utf-8)
<?
# 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
#---------------------------------
define('ROOT_PATH', './');
require("config.php");
include(ROOT_PATH.'global.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(multilang($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.sitemaps.org/schemas/sitemap/0.9\">";
}
#-----------------------------------------------
# xml_foot
#-----------------------------------------------
function xml_foot() {
echo "
</urlset>";
}
#-----------------------------------------------
# print_xml
#-----------------------------------------------
function print_xml($url,$priority,$lastmod,$changefreq) {
$temp = "<url>
<loc>$url</loc>";
if ($lastmod != '') {
$temp .=" <lastmod>$lastmod</lastmod>";
}
$temp .= " <changefreq>$changefreq</changefreq>";
$temp .= " <priority>$priority</priority>
</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)
"&#1040;" => "a",
"&#1072;" => "a",
"&#1041;" => "b",
"&#1073;" => "b",
"&#1042;" => "v",
"&#1074;" => "v",
"&#1043;" => "g",
"&#1075;" => "g",
"&#1044;" => "d",
"&#1076;" => "d",
"&#1045;" => "e",
"&#1077;" => "e",
"&#1025;" => "yo",
"&#1105;" => "yo",
"&#1046;" => "zh",
"&#1078;" => "zh",
"&#1047;" => "z",
"&#1079;" => "z",
"&#1048;" => "i",
"&#1080;" => "i",
"&#1049;" => "j",
"&#1081;" => "j",
"&#1050;" => "k",
"&#1082;" => "k",
"&#1051;" => "l",
"&#1083;" => "l",
"&#1052;" => "m",
"&#1084;" => "m",
"&#1053;" => "n",
"&#1085;" => "n",
"&#1054;" => "o",
"&#1086;" => "o",
"&#1055;" => "p",
"&#1087;" => "p",
"&#1056;" => "r",
"&#1088;" => "r",
"&#1057;" => "s",
"&#1089;" => "s",
"&#1058;" => "t",
"&#1090;" => "t",
"&#1059;" => "u",
"&#1091;" => "u",
"&#1060;" => "f",
"&#1092;" => "f",
"&#1061;" => "h",
"&#1093;" => "h",
"&#1062;" => "c",
"&#1094;" => "c",
"&#1063;" => "ch",
"&#1095;" => "ch",
"&#1064;" => "sh",
"&#1096;" => "sh",
"&#1065;" => "sch",
"&#1097;" => "sch",
"&#1066;" => "",
"&#1098;" => "",
"&#1067;" => "i",
"&#1099;" => "i",
"&#1068;" => "'",
"&#1100;" => "'",
"&#1069;" => "e",
"&#1101;" => "e",
"&#1070;" => "yu",
"&#1102;" => "yu",
"&#1071;" => "ya",
"&#1103;" => "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 i
"ї" => "i", //ukranian ї
"є" => "e", //ukranian є
"«" => "",
"»" => "",
"*" => "",
"?" => "",
"!" => "",
")" => "",
"(" => "",
"=" => "",
"." => "",
"#" => "",
"%" => "",
"–" => ""
)));
}
?>