This is a discussion on Links Manager II V 1.16 within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; */ SMALL UPDATE */ To use dutch categorie names ending with " 's " gave errors while executing an SQL ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| */ SMALL UPDATE */ To use dutch categorie names ending with " 's " gave errors while executing an SQL query on the links_categories_name. I added the addslashes function to those lines to fix this: NOTE: (ZIP FILE INCLUDES THIS TEXT) /include/functions/links.php line 306 $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $cat_name . "' LIMIT 1 "); to $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($cat_name) . "' LIMIT 1 "); admin/include/functions/links.php line 56 $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $cat_name . "' LIMIT 1 "); to $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($cat_name) . "' LIMIT 1 "); admin/links.php line 70 $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $_POST['links_category_new_parent'] . "'"); to $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($_POST['links_category_new_parent']) . "'"); line 209 $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $links_category . "'"); to $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($links_category) . "'"); More...
__________________ Michael Sasek osCMax Developer
|
| Sponsored Links | ||
| ||
| |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Links Manager II V 1.16 | michael_s | New osCommerce Contributions | 0 | 09-29-2007 05:01 AM |
| Links Manager II V 1.16 | michael_s | New osCommerce Contributions | 0 | 09-06-2007 11:30 AM |
| Links Manager II V 1.16 | michael_s | New osCommerce Contributions | 0 | 07-08-2007 08:21 PM |
| Links Manager II V 1.16 | michael_s | New osCommerce Contributions | 0 | 07-05-2007 07:56 PM |
| Links manager | jbennette | osCMax v1.7 Installation | 5 | 02-16-2004 03:43 PM |