Add Item Meta Keywords/Description

Note: This modification requires you to change PHP files. Please make a backup of all of the following files before making any changes! It is strongly recommended that you make modifications in a text editor such as Win32Pad.

The following changes will allow the system to use the item's keywords and descriptions as meta keywords and descriptions in the item pages. To make adjustments, open the openinfo.php page in the /inc/ folder and change line 380 from:

// If customer chooses an item, find that item (for customizes)
else if ($item)
$searchquery .= " AND ID = '$item'";

to:

// If customer chooses an item, find that item (for customizes)
else if ($item)
{
$searchquery .= " AND ID = '$item'";
$metaquery = "SELECT SUBSTRING_INDEX(Description, ' ', 50), Keywords FROM Shop_Items WHERE ID='$item'";
$metaresult = mysql_query($metaquery)
if (mysql_num_rows($metaresult) == 1)
{
$metarow = mysql_fetch_row($metaresult);
if ($metarow[0])
$Meta_Description=strip_tags(str_replace('"', '', $metarow[0]));
if ($metarow[1])
$Meta_Keywords=stripslashes($metarow[1]);
}
}