many ���� appears

[jsarwar]

So, the readme associated with Numinix' plugin should provide some indication of what to do. Personally, I would/would have installed everything except for the one by numinix, (or in this caase uninstall it) add all the things I needed, and then install that plugin, or rewrite the sql statements like I did for the other two mods.

I do not at this time know what was added by numinix' mod and would have to see the SQL associated to be able to answer the question.

I have following two numinix

<?php
if (!defined('IS_ADMIN_FLAG'))
{
die('Illegal Access');
}
// add upgrade script
$fec_version = (defined('FAST_AND_EASY_CHECKOUT_VERSION') ? FAST_AND_EASY_CHECKOUT_VERSION : 'new');
$current_version = '1.14.6'; // change this each time a new version is ready to release
while ($fec_version != $current_version)
{
switch ($fec_version)
{
// add case for each previous version
case 'new':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/new.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/new.php');
$fec_version = '1.12.0';
break;
}
else
{
break 2;
}
case '1.11.2':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_0.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_0.php');
$fec_version = '1.12.0';
break;
}
else
{
break 2;
}
case '1.12.0':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_1.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_1.php');
$fec_version = '1.12.1';
break;
}
else
{
break 2;
}
case '1.12.1':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_2.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_2.php');
$fec_version = '1.12.2';
break;
}
else
{
break 2;
}
case '1.12.2':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_3.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_3.php');
$fec_version = '1.12.3';
break;
}
else
{
break 2;
}
case '1.12.3':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_0.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_0.php');
$fec_version = '1.13.0';
break;
}
else
{
break 2;
}
case '1.13.0':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_1.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_1.php');
$fec_version = '1.13.1';
break;
}
else
{
break 2;
}
case '1.13.1':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_2.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_2.php');
$fec_version = '1.13.2';
break;
}
else
{
break 2;
}
case '1.13.2':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_0.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_0.php');
$fec_version = '1.14.0';
break;
}
else
{
break 2;
}
case '1.14.0':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_1.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_1.php');
$fec_version = '1.14.1';
break;
}
else
{
break 2;
}
case '1.14.1':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_2.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_2.php');
$fec_version = '1.14.2';
break;
}
else
{
break 2;
}
case '1.14.2':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_3.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_3.php');
$fec_version = '1.14.3';
break;
}
else
{
break 2;
}
case '1.14.3':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_4.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_4.php');
$fec_version = '1.14.4';
break;
}
else
{
break 2;
}
case '1.14.4':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_5.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_5.php');
$fec_version = '1.14.5';
break;
}
else
{
break 2;
}
case '1.14.5':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_6.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_6.php');
$fec_version = '1.14.6';
break;
}
else
{
break 2;
}
case '1.14.6':
// perform upgrade
if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_7.php'))
{
include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_7.php');
$fec_version = '1.14.7';
break;
}
else
{
break 2;
}
default:
$fec_version = $current_version;
// break all the loops
break 2;
}
}




2nd



ALTER TABLE products ADD products_condition varchar(32) NULL default NULL;

INSERT INTO product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
(NULL, 'Show Condition', 'SHOW_PRODUCT_INFO_CONDITION', '0', 'Show product condition on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');





Current file need to modify is

<?php
//$messageStack->add('Ty Package Tracker v3.1.3 install started','success');

$typt_menu_title = 'Ty Package Tracker';
$typt_menu_text = 'Settings for Ty Package Tracker Features';

/* find if Ty Package Tracker Configuration Group Exists */
$sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = '".$typt_menu_title."'";
$original_config = $db->Execute($sql);

if($original_config->RecordCount())
{
// if exists updating the existing Ty Package Tracker configuration group entry
$sql = "UPDATE ".TABLE_CONFIGURATION_GROUP." SET
configuration_group_description = '".$typt_menu_text."'
WHERE configuration_group_title = '".typt_menu_title."'";
$db->Execute($sql);
$sort = $original_config->fields['sort_order'];

}else{
/* Find max sort order in the configuation group table -- add 2 to this value to create the Ty Package Tracker configuration group ID */
$sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_CONFIGURATION_GROUP;
$result = $db->Execute($sql);
$sort = $result->fields['sort'];

/* Create Ty Package Tracker configuration group */
$sql = "INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, '".$typt_menu_title."', '".$typt_menu_text."', ".$sort.", '1')";
$db->Execute($sql);
}

/* Find configuation group ID of Ty Package Tracker */
$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$typt_menu_title."' LIMIT 1";
$result = $db->Execute($sql);
$typt_configuration_id = $result->fields['configuration_group_id'];

/* Remove Ty Package Tracker items from the configuration table */
$sql = "DELETE FROM ".DB_PREFIX."configuration WHERE configuration_group_id ='".$typt_configuration_id."'";
$db->Execute($sql);

//-- ADD VALUES TO EDIT ORDERS CONFIGURATION GROUP (Admin > Configuration > Ty Package Tracker) --
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Status', 'CARRIER_STATUS_1', 'True', 'Enable Tracking for Carrier 1<br /><br />Set to false if you do NOT want Carrier 1 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Name', 'CARRIER_NAME_1', 'FedEx', 'Enter name of Carrier 1 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: FedEx)', '".$typt_configuration_id."', 95, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Tracking Link', 'CARRIER_LINK_1', 'http://www.fedex.com/Tracking?action=track&tracknumbers=', 'Enter the tracking link of Carrier 1<br /> <br /><strong>Example:</strong> http://www.fedex.com/Tracking?action...&tracknumbers=', '".$typt_configuration_id."', 100, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Status', 'CARRIER_STATUS_2', 'True', 'Enable Tracking for Carrier 2<br /><br />Set to false if you do NOT want Carrier 2 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 105, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Name', 'CARRIER_NAME_2', 'UPS', 'Enter name of Carrier 2 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: UPS)', '".$typt_configuration_id."', 110, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Tracking Link', 'CARRIER_LINK_2', 'http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&l oc=en_US&InquiryNumber1=', 'Enter the tracking link of Carrier 2<br /> <br /><strong>Example:</strong> http://www.fedex.com/Tracking?action...&tracknumbers=', '".$typt_configuration_id."', 115, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Status', 'CARRIER_STATUS_3', 'True', 'Enable Tracking for Carrier 3<br /><br />Set to false if you do NOT want Carrier 3 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 120, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Name', 'CARRIER_NAME_3', 'USPS', 'Enter name of Carrier 3 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: USPS)', '".$typt_configuration_id."', 125, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Tracking Link', 'CARRIER_LINK_3', 'https://tools.usps.com/go/TrackConfirmAction!input.action?tLabels=', 'Enter the tracking link of Carrier 3<br /> <br /><strong>Example:</strong> http://www.fedex.com/Tracking?action...&tracknumbers=', '".$typt_configuration_id."', 130, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Status', 'CARRIER_STATUS_4', 'False', 'Enable Tracking for Carrier 4<br /><br />Set to false if you do NOT want Carrier 4 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 140, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Name', 'CARRIER_NAME_4', '', 'Enter name of Carrier 4 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', '".$typt_configuration_id."', 145, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Tracking Link', 'CARRIER_LINK_4', '', 'Enter the tracking link of Carrier 4<br /> <br /><strong>Example:</strong> http://www.fedex.com/Tracking?action...&tracknumbers=', '".$typt_configuration_id."', 150, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Status', 'CARRIER_STATUS_5', 'False', 'Enable Tracking for Carrier 5<br /><br />Set to false if you do NOT want Carrier 5 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 155, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Name', 'CARRIER_NAME_5', '', 'Enter name of Carrier 5 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', '".$typt_configuration_id."', 160, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Tracking Link', 'CARRIER_LINK_5', '', 'Enter the tracking link of Carrier 5<br /> <br /><strong>Example:</strong> http://www.fedex.com/Tracking?action...&tracknumbers=', '".$typt_configuration_id."', 165, now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Max display for Track Order sidebox', 'MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX', '3', 'The maximum number of orders to display on the Track Order sidebox ', '".$typt_configuration_id."', '170', now(), now(), NULL, NULL)";
$db->Execute($sql);
$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Ty Package Tracker Module Switch', 'TY_TRACKER', 'False', 'If you have the either Edit Orders v4.x or Super Orders v4.x installed, set this option to TRUE so that the Ty Package Tracker fields will display in Edit Orders or Super Orders<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS v4.x OR SUPER ORDERS v4.x INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod\(s\) installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', '".$typt_configuration_id."', 175, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')";
$db->Execute($sql);

// add columns to order table
//check if track_id1 column exists
$sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id1%'";
$result = $db->Execute($sql);
if(!$result->RecordCount())
{
$sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id1 TEXT default NULL";
$db->Execute($sql);
}

//check if track_id2 column exists
$sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id2%'";
$result = $db->Execute($sql);
if(!$result->RecordCount())
{
$sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id2 TEXT default NULL";
$db->Execute($sql);
}
//check if track_id3 column exists
$sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id3%'";
$result = $db->Execute($sql);
if(!$result->RecordCount())
{
$sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id3 TEXT default NULL";
$db->Execute($sql);
}
//check if track_id4 column exists
$sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id4%'";
$result = $db->Execute($sql);
if(!$result->RecordCount())
{
$sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id4 TEXT default NULL";
$db->Execute($sql);
}
//check if track_id5 column exists
$sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id5%'";
$result = $db->Execute($sql);
if(!$result->RecordCount())
{
$sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id5 TEXT default NULL";
$db->Execute($sql);
}

if(file_exists(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.typt.php'))
{
if(!unlink(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.typt.php'))
{
$messageStack->add('The auto-loader '.DIR_FS_ADMIN.'includes/auto_loaders/config.typt.php has not been deleted. For this module to work you must delete this file manually.','error');
};
}

$messageStack->add('Ty Package Tracker v3.1.3 install completed!','success');

// find next sort order in admin_pages table
$sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_ADMIN_PAGES;
$result = $db->Execute($sql);
$admin_page_sort = $result->fields['sort'];

// now register the admin pages
// Admin Menu for Ty Package Tracker Configuration Menu
zen_deregister_admin_pages('configTyPackageTracker');
zen_register_admin_page('configTyPackageTracker',
'BOX_CONFIGURATION_TY_PACKAGE_TRACKER', 'FILENAME_CONFIGURATION',
'gID=' . $typt_configuration_id, 'configuration', 'Y',
$admin_page_sort);




Honestly, I went over two modifications you made yesterday for me but they are totally different so did not make sense to me.

[DrByte]

I guess you didn't read the article. I'll copy and paste it here for you:

1. Edit /admin/includes/languages/english.php (and all other language_name.php files in that folder) and set the define for CHARSET to 'utf-8'.
   Do the same with the non-admin /includes/languages/english.php (and other language_name.php files in that folder)
   ... AND ...
2. Also edit your two configure.php files to set DB_CHARSET to 'utf8':
   define('DB_CHARSET', 'utf8');
   (Remember, the configure.php files are most likely set to read-only on your server, so you'll need to change their permissions on the server to be writable before you can save the changes you're making.)
   (Remember, you must do this for both your /your_admin_folder/includes/configure.php and /includes/configure.php )

[jsarwar]

I guess you didn't read the article. I'll copy and paste it here for you:

I think I have already done this as I have

define('DB_CHARSET', 'utf8'); in both admin/non admin configure files.


and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.


and I just ran the converted and got following at bottom of page

Total processing tables 125, converted tables 0. Execution time 0.0232
DB statistic: show: 2 0.0121;

all tables have skip in action column.

[jsarwar]

I think I have already done this as I have

define('DB_CHARSET', 'utf8'); in both admin/non admin configure files.


and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.


and I just ran the converted and got following at bottom of page

Total processing tables 125, converted tables 0. Execution time 0.0232
DB statistic: show: 2 0.0121;

all tables have skip in action column.

I just have my hosting company check logs and recent log does not show following error anymore. So I think it is resolved. PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `utf8' not supported, assuming iso-8859-1 in



Thank you DrByte :)

[DrByte]

and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.

No, the instructions for CHARSET say to use utf-8, not utf8.

[jsarwar]

No, the instructions for CHARSET say to use utf-8, not utf8.

Thank you for pointing my mistake. I have changed utf8 to utf-8.

Do I need to upload and re run coverter file again?
Right now all fonts appearing ok on site and in admin.

[DrByte]

Thank you for pointing my mistake. I have changed utf8 to utf-8.

Do I need to upload and re run coverter file again?

No, the converter script wasn't based on those settings. Should be fine.

[jsarwar]

No, the converter script wasn't based on those settings. Should be fine.

Thank you. Can you please rearrange sql for me I posted above for TY track as I can't understand sql and how to put them together.

[jsarwar]

Stock Icons in Zencart

How I can increase the size of in stock image (Green light)?
When inspect element is shows 10"x10" but no where in css its mentioned. How I can increase it?
Thank you

[yaritai]

Stock Icons in Zencart

How I can increase the size of in stock image (Green light)?
When inspect element is shows 10"x10" but no where in css its mentioned. How I can increase it?
Thank you

Is this admin or catalog side? And are you speaking of the addon for stock icons?

Either way, the zen_image function is what pulls the relevant image. You will have to modify the width and height parameters from 10 and 10 to something else you want. But also keep in mind that if you go much bigger you will have to redo and upload the icon status images to avoid them being blury on the catalog side.