Re: XC SEO v1.1.0 Released
 

Hello all,

I do have the same problem. But I do use a multilingual site.
As I'm not a coder I was hoping that you would have a solution :-)

Thanks anyway.

Re: XC SEO v1.1.0 Released
 

4.1.3, get_language.php modification

Find:


Replace With:

Re: XC SEO v1.1.0 Released
 

Thank you Intel!

Re: XC SEO v1.1.0 Released
 

Can i ask if i should consider incorperating this in my newly purchased x-cart.

Re: XC SEO v1.1.0 Released
 

My opinion: Absolutely. Especially if you don't want to change urls in your cart after they have been indexed by the search engines.

Re: XC SEO v1.1.0 Released
 

Just downloaded this file and unzipped it, uploaded it but the thing is where should it be enabled. I am assuming its in modules but i cannot see it.

So to give a beeter understanding of how i uploaded it:

catalog/.htaccess into = /public_html/mystore/catalog/
modules/XC_SEO = /public_html/mystore/modules/ *
sql/xcseo.sql,xcseo_remove.sql,xcseo_lng_US.sql = /public_html/mystore/sql/
x-cart-seo docs = /public_html/mystore/ *
.htaccess = /public_html/mystore/
robots.txt = /public_html/mystore/
secure.htaccess = /public_html/mystore/

The two with a red * i am unsure if this is correct or whether the files in these folders are to be entered.

As it stands i just put the whole XC_SEO folder into /public_html/mystore/modules/ as i did with the x-cart-seo docs into the /public_html/mystore/


Thanks again if someone can help[me out here

Richard

Re: XC SEO v1.1.0 Released
 

ezi, you've uploaded the files properly, now you need to execute the SQL commands as noted in the docs (look in the xcseo docs folder, the install file for your version).

additionally there are a few files you need to edit, as noted in the docs

Re: XC SEO v1.1.0 Released
 

I have followed the install instruction to INSTALL 4.1.3 under x-cart-seo docs but when doing so i receive the follow error:

This is what i entered into the 'Apply SQL patch' in admin:

Refer to the following files for SQL commands:
sql/xcseo.sql
sql/xcseo_lng_US.sql

INVALID SQL: 1064: You have an error in your syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near ▒Refer to the following files for SQL commands: sql/xcseo.sql sql/xcseo_lng_US.▓at line 1
SQL QUERY FAILURE: Refer to the following files for SQL commands: sql/xcseo.sql sql/xcseo_lng_US.sql

Any advice will be most welcome,

Thanks

Richard

Re: XC SEO v1.1.0 Released
 

Wow, 2nd person to do this in this thread...

you need to open the following files for SQL commands:
sql/xcseo.sql
sql/xcseo_lng_US.sql

Re: XC SEO v1.1.0 Released
 

Awesome mod ! this is truly THE best mod for xcart out. Can't wait for the catagory rewrites that will make this mod even greater :)

Keep up the good work intel :)

Heres the site im working on: http://www.consoleasia.com . Great Design, works great with clean urls :)

Re: XC SEO v1.1.0 Released
 

intel, I'm having a different problem with Froogle export now. Per you suggestion, I replaced my Froogle.php with a clean one from 4.0.19 and then inserted your udpated code. The export file truncates the link to my store root. If I remove the XC_SEO code from froogle.php it exports the link correctly. I think I remember there being a fix to this somewhere, but I can't remember or find it.

BTW, my froogle problem with invalid characters might be a Google Base issue with the bulk upload feature.

Scott

XC SEO v1.1.0 Released
 

I know i sound thich but can you explain what you mean by;

you need to open the following files for SQL commands:
sql/xcseo.sql
sql/xcseo_lng_US.sql


Real sorry for asking again intel

Thanks

Richard

Re: XC SEO v1.1.0 Released
 

You need to open the file xcseo.sql and copy it to your admin patch section, and then apply the patch.

So for the first one xcseo.sql, select the sql patch text inside the file (by highlighting all the text, and pressing "Ctrl + C") and then log into your admin section, select the "Patch/Upgrade" under the Administration section, then look for the Apply SQL patch box which is the last box, and in the SQL query(ies): box paste the code inside it (by pressing "Ctrl + V") from the file xcseo.sql.

Once this is done then click on the Apply button to apply this to your MySql database.

Hope the above makes sense.

Re: XC SEO v1.1.0 Released
 

Thanks for taking the time to explain that to him Shisha, I didn't have any time at work today :-\

ezi: you can apply a SQL patch by going to the admin patch area of X-Cart, scrolling down to the SQL area. there are 2 options, 1 is to upload a file from your harddrive, the other is to paste in the SQL commands directly. you can do either. you have to upload (or paste the contents) of both:
sql/xcseo.sql
sql/xcseo_lng_US.sql

into the X-Cart patch admin.

Hopefully the following link from the X-Cart manual will explain this better.
http://x-cart.com/xcart_manual/online_4x/applying_sql_patches.htm

Re: XC SEO v1.1.0 Released
 

Scott, if you'd like, I can take a look at your Froogle file for you. PM me the details to your installation, I'll check it tonight or tomorrow. Otherwise, I'd suggest trying the process with a fresh file one more time, paying careful attention to what you copy/paste/insert.

Re: XC SEO v1.1.0 Released
 

Hi Guys

Thanks for all your help and i am getting there, well im there all bar one one error

Parse error: syntax error, unexpected T_IF in /home/ezidesig/public_html/storedzine/include/get_language.php on line 206

Here is what the code looks like in that folder;

#
# $Id: get_language.php,v 1.70.2.3 2006/08/07 07:18:11 max Exp $
#
if ( !defined('XCART_SESSION_START') ) { header("Location: ../"); die("Access denied"); }
define("GET_LANGUAGE", 1);
x_session_register("old_lng");
if (!empty($edit_lng) && !empty($HTTP_GET_VARS['old_lng'])) {
$asl = $edit_lng;
$HTTP_POST_VARS['asl'] = $asl;
$old_lng = $HTTP_GET_VARS['old_lng'];
$QUERY_STRING = func_qs_remove($QUERY_STRING,"edit_lng");
$QUERY_STRING = func_qs_remove($QUERY_STRING,"old_lng");
$HTTP_REFERER = preg_replace("/[&\?]edit_lng=\w{2}/S", "", $HTTP_REFERER);
$HTTP_REFERER = preg_replace("/[&\?]old_lng=\w{2}/S", "", $HTTP_REFERER);
}
if (!empty($old_lng) && !defined("IS_MULTILANGUAGE")) {
if($config['Appearance']['restore_language_interface'] == 'Y') {
$asl = $old_lng;
$HTTP_POST_VARS['asl'] = $asl;
$HTTP_REFERER = $PHP_SELF."?".$QUERY_STRING;
}
$old_lng = "";
}
$e_langs = func_data_cache_get("charsets");
$d_langs = explode ("|", $config["disabled_languages"]);
if ($d_langs) {
$d_langs = func_array_map("trim", $d_langs);
foreach ($d_langs as $v) {
if (isset($e_langs[$v])) {
unset($e_langs[$v]);
}
}
}
if (!isset($e_langs[$config["default_customer_language"]]) && !empty($e_langs) && is_array($e_langs))
$config["default_customer_language"] = key($e_langs);
if (!isset($e_langs[$config["default_admin_language"]]) && !empty($e_langs) && is_array($e_langs))
$config["default_admin_language"] = key($e_langs);
# Define redirect URL
if ($is_https_redirect == 'Y') {
# Redirect from HTTP
$l_redirect = func_qs_remove($PHP_SELF."?".$QUERY_STRING, "is_https_redirect", "sl", $XCART_SESSION_NAME);
} elseif (empty($HTTP_REFERER) || strstr($HTTP_REFERER, "error=disabled_cookies")) {
# First request or redirect from Disabled cookies error page
$l_redirect = func_qs_remove($PHP_SELF."?".$QUERY_STRING, "sl", $XCART_SESSION_NAME);
} else {
$l_redirect = func_qs_remove($HTTP_REFERER, "sl", $XCART_SESSION_NAME);
}
if ($smarty->webmaster_mode || $smarty->debugging)
$predefined_lng_variables = array("lbl_xcart_debugging_console", "lbl_included_templates_config_files");
else
$predefined_lng_variables = array();
if ($login) unset($store_language);
if (!empty($HTTP_GET_VARS["sl"]))
$store_language = $HTTP_GET_VARS["sl"];
$shop_language = '';
if (empty($current_area) || @$current_area == "C" || @$current_area == "B") {
if (empty($store_language) && !empty($login)) {
$store_language = func_query_first_cell ("SELECT $sql_tbl[customers].language FROM $sql_tbl[customers], $sql_tbl[languages] WHERE $sql_tbl[customers].login='$login' AND $sql_tbl[customers].language = $sql_tbl[languages].code LIMIT 1");
}
if (!empty($store_language)) {
if (!isset($e_langs[$store_language])) {
$store_language = "";
}
}
if (empty($store_language))
$store_language = $config["default_customer_language"];
if (!isset($e_langs[$store_language])) {
if (!isset($e_langs[$config["default_customer_language"]]) && !empty($e_langs) && is_array($e_langs)) {
$store_language = key($e_langs);
} else {
$store_language = $config["default_customer_language"];
}
}
$shop_language = $store_language;
}
else {
x_session_register("current_language");
if (@$HTTP_POST_VARS["asl"] && $login) {
$res = func_query_first ("SELECT charset FROM $sql_tbl[countries] WHERE code='".$HTTP_POST_VARS["asl"]."'");
if ($res) {
$current_language = $HTTP_POST_VARS["asl"];
}
func_header_location($l_redirect);
}
if (!isset($current_language) || empty($current_language))
$current_language = $config["default_admin_language"];
if (!isset($e_langs[$current_language])) {
if (!isset($e_langs[$config["default_admin_language"]])) {
$current_language = key($e_langs);
reset($e_langs);
} else {
$current_language = $config["default_admin_language"];
}
}
$smarty->assign ('current_language', $current_language);
$shop_language = $current_language;
}
$smarty->assign ('default_charset', $e_langs[$shop_language]);
x_session_register("editor_mode");
if ($login)
db_query ("UPDATE $sql_tbl[customers] SET language='$shop_language' WHERE login='$login'");
if (@$current_area == "C" || @$current_area == "B") {
#
# Set cookies
#
if ($store_language != @$HTTP_COOKIE_VARS["store_language"] && !defined('NOCOOKIE')) {
setcookie ("store_language", "", time()-31536000);
setcookie ("store_language", $store_language, time()+31536000); # for one year
if ($xcart_http_host != $xcart_https_host) {
#
# Set cookies for HTTPS host
#
setcookie ("store_language", "", time()-31536000, "/", $xcart_https_host, 1);
setcookie ("store_language", $store_language, time()+31536000, "/", $xcart_https_host, 1); # for one year
}
}
}
$all_languages = func_data_cache_get("languages", array($shop_language));
if (empty($all_languages)) {
$def_language = ($current_area == 'C' ? $config["default_customer_language"] : $config["default_admin_language"]);
$all_languages = func_data_cache_get("languages", array($def_language));
if (empty($all_languages)) {
$all_languages = func_data_cache_get("languages", array(key($e_langs)));
reset($e_langs);
}
}
$n_langs = array ();
if ($all_languages) {
$avail_languages = $all_languages;
foreach ($all_languages as $value) {
if (!in_array($value["code"], $d_langs))
$n_langs [] = $value;
}
}
if (
($current_area == "C" || $current_area == "B") &&
!empty($HTTP_GET_VARS["sl"]) &&
!defined('IS_ROBOT') &&
################################################## ##########
# X-CART-SEO Mod :: http://code.google.com/p/x-cart-seo/
################################################## ##########
if (!empty($active_modules["XC_SEO"])) {
func_header_location($l_redirect);
}else{
if (!preg_match('!(\.htm(l)?|/$)!',$_tmp["path"])) {
func_header_location($l_redirect);
}
}
# End SEO {
func_header_location($l_redirect);
$all_languages = $n_langs;
$smarty->assign ("all_languages", $all_languages);
$smarty->assign ("store_language", @$store_language);
$smarty->assign ("shop_language", @$shop_language);
$smarty->assign ("all_languages_cnt", sizeof($all_languages));
$config["Company"]["location_country_name"] = func_get_country($config["Company"]["location_country"]);
$config["Company"]["location_state_name"] = func_get_state($config["Company"]["location_state"], $config["Company"]["location_country"]);
$smarty->assign("config",$config);
$mail_smarty->assign("config",$config);
if (!empty($config['r2l_languages'][$shop_language]))
$smarty->assign('reading_direction_tag', ' dir="RTL"');
else
$smarty->assign('reading_direction_tag', '');
?>

Re: XC SEO v1.1.0 Released
 

ezi, it's hard to read your code as posted, please post it within CODE blocks

additionally, a T_IF means you modified the code incorrectly. best troubleshooting method is to replace your get_language file with the original file, and try applying the modifications from scratch

Re: XC SEO v1.1.0 Released
 

I have to say this again but WOW! This software is great, My customers seem to enjoy the easy to read urls more then the session id's lol. Can't wait until the category to folder features are integrated :)

Re: XC SEO v1.1.0 Released
 

I am not sure why but my site is not displayiing the pages, it show a page not found. I am not sure if my Mod Rewrite is correct.

Below is the code, Is my server not rewriting the URLs is that why I can get my to site to show product pages. Every time I hit a category or product the page shows not found, ANY Assistance would be appreciated..

Thanks

#####
# The following rules should be added
# to the TOP of your existing .htaccess file
# to prevent malicious users/bots from accessing
# x-cart files that aren't meant to be public.
#####

# block all smarty templates (no reason to have these exposed)
RedirectMatch gone ^/.*\.tpl$

# block all .log (log files), .sql (sql dump/export) and .conf (config files) files
# in case some day these files move to another directory
RedirectMatch gone ^.*\.(sql|log|conf)$

# block access to the 'Smarty-*' directory
RedirectMatch gone ^.*Smarty.*$

# block common X-Cart files that could reveal
# that you have X-Cart installed
RedirectMatch gone VERSION.*
RedirectMatch gone COPYRIGHT.*
RedirectMatch gone INSTALL.*
RedirectMatch gone NEW.*
RedirectMatch gone README.*
RedirectMatch gone UPGRADE.*

# block access to /upgrade
Redirect gone /upgrade

# block access to /skin1_original
Redirect gone /skin1_original

# block access to the /sql directory
Redirect gone /sql

# block access to the /shipping directory
Redirect gone /shipping

# block access to the pgp directories
Redirect gone /.pgp
Redirect gone /.pgp.def

# block access to the pgp directories
Redirect gone /tmp
Redirect gone /var

# REWRITE RULES
Options +SymlinksIfOwnerMatch -Indexes

RewriteEngine on
RewriteBase /
RewriteCond %{HTTP_HOST} !^www\.mycleaningproducts\.com [NC]
RewriteRule ^(.*)$ http://www.mycleaningproducts.com/$1 [R=301,L]


# -FrontPage-

IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*

<Limit GET POST>
order deny,allow
deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>

Re: XC SEO v1.1.0 Released
 

there were 2 files included in the XC SEO download. 1 is ".htaccess", the other is "secure.htaccess". It appears you copied the text from the "secure" file, but neglected the text from the regular htaccess. The regular htaccess has what you need

Re: XC SEO v1.1.0 Released
 

Hi,

Will this mod only work with Apache because of the rewrite rules, will it work in IIS.

Regards,

Re: XC SEO v1.1.0 Released
 

if your installation of IIS has a type of mod rewrite installed, this product might work for you. the problem is, rewrite for IIS is usually an addon that has to be purchased, altho there are 1 or 2 free versions.

Re: XC SEO v1.1.0 Released
 

I never recieved a .htasccess file from the download, only the secure.htaccess one

Are positive I should have recieved it in the download.




Stop Black Mold

Re: XC SEO v1.1.0 Released
 

It is included with the download archive. You can view the htaccess here:

http://x-cart-seo.googlecode.com/svn/trunk/.htaccess

Re: XC SEO v1.1.0 Released
 

Ezi Designs, you will get this error as it is wrong.

Also the install 4.1.3 instructions are wrong a little bit.

The instructions say:

IV. includes/get_language.php
===================
OPTIONAL:
The change to "get_language.php" is to avoid issues with
sites that have the language selector enabled.
NOTE: This change is for X-Cart 4.1.x series. Owners of 4.0.x, please
verify if this alteration is needed.
-----------
Find Code:
-----------
------------
Replace With
------------

Well my virgin 4.1.3 file has at line 199


The instructions say find code:


Which does not exist in my x-cart 4.1.3

Re: XC SEO v1.1.0 Released
 

Intel352, although I explained to you some time ago that I'm not using or planning to install XC SEO or any other rewrite rule. BUT I still greatly admire your commitment to this forum!!

I'm still wondering why you're doing all those stuff... Is there a special reason for all this? Are you somekinda secret agent of Google? Or a new type of angel? I dunno, but I just wanna know! :)

Keep up the GOOD WORK!!

Michael

Re: XC SEO v1.1.0 Released
 

Shisha, Please refer to this post for corrected instructions:

http://forum.x-cart.com/showthread.php?p=146906#post146906

Re: XC SEO v1.1.0 Released
 

Thanks, I appreciate it :-D

This work was started for the sake of my previous employer (didn't want to have to pay for an SEO solution), and the code was released as GNU GPL to hopefully generate a community around the module, so that there would be a good community for testing and improving the code. Additionally, since there wasn't a free SEO solution available, figured this would be a good free addition to x-cart ;-)

Re: XC SEO v1.1.0 Released
 

Hi there,

First of all thanks for the mod ;) much appreciated. I think i find another error under the froggle section.. here is the current (i'm using 4.13) section that i can find:

# Post string
$post = func_froogle_convert($product['product'], 80)."\t".
func_froogle_convert($product['descr'], 65536)."\t".
$http_location.constant("DIR_CUSTOMER")."/product.php?productid=".$product['productid']."\t".
$tmbn."\t".

Can you please take a look at it for us?

Regards,
Poy

Re: XC SEO v1.1.0 Released
 

Just an update for some people. I've been using this for a while now, and my catalog pages are starting to show up in google's index..woo

Re: XC SEO v1.1.0 Released
 

Mine are starting to show up too.

:-)

Re: XC SEO v1.1.0 Released
 

actually i just noticed sadly, that they're showing up in the supplemental index.

Re: XC SEO v1.1.0 Released
 

Regarding the supplemental index, Sound Choice Store has a large number of pages showing up as supplemental, yet our hits from users searching in Google has increased from ~300-500/wk to ~700-800/wk consistently, and this past week it has doubled to ~1500/wk

we're getting hits on a large number of varied user searches, with the most popular query only getting 63 hits, so we're actually hitting a wider selection of keywords, which is great.

the best things that can help you tho, are to have other sites linking to you, and especially having other sites linking *deep* into your site (whether into a deep category or specifically to a product).

Also, within your own website, link deep into your shop. Whether by having random "best sellers" or "featured" or whatever.

Re: XC SEO v1.1.0 Released
 

I looked closer and noticed that so far the only pages that have indexed are categories and manufacturers pages, so its not surprising that they ended up supplemental. Its also been talked that the supplemental index has become very large and is outgrowing the main google index.

I will say that every month I've had substantial increases in traffic. October the site had maybe 250 unique visitors and 350 visits, mostly from the existence of old RJR Products customers. November hit just over 920 unique visitors and almost 1200 visits, and November is looking like it might hit around 1500/2000. Besides submitting a urllist to yahoo, and this work with google webmaster tools, and froogle, is 1 banner ad on a small but growing off-road forum with some threads in the forum as well.

Now if I can only get some more appealing products in the store. Always waiting on someone...

Re: XC SEO v1.1.0 Released
 

Are you using Google Analytics or something similar to determine the actual source of your traffic? I've found that is a great help. Additionally, it can be used to determine what search terms people are using to find you.

Re: XC SEO v1.1.0 Released
 

I've been using AW Stats, it runs on the webserver, and most of my traffic isn't really coming from search engines just yet really. alot is just coming from the banner advertising and links from other websites listing vendors that were intact before I started the X-Cart store.

I did $1000 and some change in my first month, and I'm hoping to do $1500 this month, hoping. I've got to get to roughly $2500 a month to cover the cost of my own salary, so we've got a ways to go.

Re: XC SEO v1.1.0 Released
 

Were getting 4880 links not getting indexed by google might be the .htaccess file
should we have this at the start of it
(DirectoryIndex index.html index.php home.php)
when i put just DirectoryIndex home.php we get errors in iexplorer
And our xml sitemap genorator stopped working wont crawl the site all the pages show as broken links.
Any ideas what would be best for DirectoryIndex?
Thanks Greg
4.1.3

Re: XC SEO v1.1.0 Released
 

probably do:
DirectoryIndex home.php index.php index.html

Re: XC SEO v1.1.0 Released
 

AWESOME! I have been looking for something like this.

Installation was a breeze and everything looks good to go!

Thanks!

See it in action:

http://www.valuecushions.com

Re: XC SEO v1.1.0 Released
 

Can someone who's using 4.1.x post their Froggle section please?
I can't get mine to run properly.