Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Dave86

Archived
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    David

Dave86's Achievements

  1. Hi, No problem, i was happy to help you. I was on this problem alone, i find the issue on working on it 18 hours a day during 2 weeks. It's was a so weak problem... but no body to help me. Check all the file to be sure there are no other problems, See you later ++ :)
  2. Hi Mr.JTX, I solved this problem by changing one file ; Find in catalog/includes/functions/redemptions.php and look after 207 (between 200 and 208) Find this line tep_db_query("update " . TABLE_CUSTOMERS . " set customers_shopping_points = customers_shopping_points - '". $customer_shopping_points_spending ."' where customers_id = '". (int)$customer_id ."' limit 1"); } else { tep_db_query("update " . TABLE_CUSTOMERS . " set customers_shopping_points = null, customers_points_expires = null where customers_id = '". (int)$customer_id ."' limit 1"); } and change to this : tep_db_query("update " . TABLE_CUSTOMERS . " set customers_shopping_points = customers_shopping_points - '". $customer_shopping_points_spending ."' where customers_id = '". (int)$customer_id ."' limit 1"); } else { tep_db_query("update " . TABLE_CUSTOMERS . " set customers_shopping_points =[b] '0.00'[/b], customers_points_expires = null where customers_id = '". (int)$customer_id ."' limit 1"); } it's would be fine now bye
  3. Thanks men to help me to solve my problem , i'am very grateful to you and i ll send you some royal chocolade of my country, let's give me your address if we find my problem i checked all you write : point 1, 2 and 3, even 4 does not work... 1. have you defined in languages/FRENCH/checkout_process.php OK define('VARSTYLE', '<link rel="stylesheet" type="text/css" href="stylesheetmail.css">'); //location of email css file. OK define('VARHTTP', '<base href="' . HTTP_SERVER . DIR_WS_CATALOG . '">'); //Do not change OK Here is my configure.php file define('HTTP_SERVER', 'http://localhost'); define('HTTPS_SERVER', 'http://localhost'); define('ENABLE_SSL', false); define('HTTP_COOKIE_DOMAIN', 'localhost'); define('HTTPS_COOKIE_DOMAIN', 'localhost'); define('HTTP_COOKIE_PATH', '/bijoux/osc/'); define('HTTPS_COOKIE_PATH', '/bijoux/osc/'); define('DIR_WS_HTTP_CATALOG', '/bijoux/osc/'); define('DIR_WS_HTTPS_CATALOG', '/bijoux/osc/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', 'C:/wamp/www/bijoux/osc/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); 2 . 2. in checkout_process.php something like $Varhttp = ''.VARHTTP.''; OK $Varstyle = ''.VARSTYLE.''; OK 3. $html_email_order .= "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\"> "; OK $html_email_order .= "$Varhttp "; OK $html_email_order .= "$Varstyle "; OK 4. if you try to include the stylesheet.css directly than try it with something like $html_email_order .= "<base href=\"' . HTTP_SERVER . DIR_WS_CATALOG . '\"><link rel=\"stylesheet\" type=\"text/css\" href=\"stylesheetmail.css\">"; be aware that you have defined the base element I CHANGED BUT NOT WORK <?php $html_email_order = "<html>"; $html_email_order .= "<head>"; $html_email_order .= "<base href=\"' . HTTP_SERVER . DIR_WS_CATALOG . '\"><link rel=\"stylesheet\" type=\"text/css\" href=\"stylesheetmail.css\">"; OK $html_email_order .= "$Varhttp "; $html_email_order .= "$Varstyle "; $html_email_order .= "</head>"; $html_email_order .= "<body>"; $html_email_order .= "<table width=\"600\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"; $html_email_order .= " <tr>"; $html_email_order .= " <td><table width=\"600\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"; $html_email_order .= " <tr> "; $html_email_order .= " <td>$Vartable1"; $html_email_order .= " <tr> "; $html_email_order .= " <td><font face=\"verdana, arial\" size=\"-1\">$Varlogo</font></td>"; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr> "; $html_email_order .= " <td>$Vartable2 "; $html_email_order .= " <tr> "; $html_email_order .= " <td class=\"main\">$Vartext1</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr height=\"14\" class=\"detail\"> "; $html_email_order .= " <td height=\"14\"> </td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr class=\"detail\"> "; $html_email_order .= " <td class=\"main\">$Vartext2</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr height=\"14\"> "; $html_email_order .= " <td height=\"14\"> </td>"; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr>"; $html_email_order .= " <td><table width=\"600\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=white>"; $html_email_order .= " <tr> "; $html_email_order .= " <td class=\"boxmail\" align=\"left\" width=\"300\">$VarArticles</td>"; $html_email_order .= " <td class=\"boxmail\" align=\"left\" width=\"160\">$VarModele</td>"; $html_email_order .= " <td class=\"boxmail\" align=\"center\" width=\"40\">$VarQte</td>"; $html_email_order .= " <td class=\"boxmail\" align=\"right\" width=\"100\">$VarTotal</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr> "; $html_email_order .= " <td width=\"300\" valign=\"top\" align=\"left\" class=\"boxmailgris\">$products_name</td>"; $html_email_order .= " <td width=\"160\" valign=\"top\" align=\"left\" class=\"boxmailgris\">$products_model</td>"; $html_email_order .= " <td width=\"40\" valign=\"top\" align=\"center\" class=\"boxmailgris\">$products_quantity</td>"; $html_email_order .= " <td width=\"100\" valign=\"top\" align=\"right\" class=\"boxmailgris\">$products_price</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr height=\"14\"> "; $html_email_order .= " <td height=\"14\" width=\"300\" valign=\"top\" align=\"left\" class=\"tableur\">$Vardetail</td>"; $html_email_order .= " <td colspan=\"3\" width=\"300\" valign=\"top\" align=\"right\" class=\"tableur\">$Vartaxe</td>"; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr>"; $html_email_order .= " <td><table width=\"600\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=white>"; $html_email_order .= " <tr> "; $html_email_order .= " <td width=\"300\" class=\"boxmail\">$VarAddresship</td>"; $html_email_order .= " <td width=\"300\" class=\"boxmail\">$VarAddressbill</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr> "; $html_email_order .= " <td width=\"300\" valign=\"top\" align=\"left\" class=\"boxmailgris\">$Varshipaddress</td>"; $html_email_order .= " <td width=\"300\" valign=\"top\" align=\"left\" class=\"boxmailgris\">$Varadpay</td> "; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr>"; $html_email_order .= " <td><table width=\"600\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=white>"; $html_email_order .= " <tr> "; $html_email_order .= " <td class=\"boxmail\">$Varmetodpaye</td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr> "; $html_email_order .= " <td class=\"boxmailgris\">$Varmodpay</td> "; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr>"; $html_email_order .= " <td><table width=\"600\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=white>"; $html_email_order .= " <tr height=\"14\"> "; $html_email_order .= " <td height=\"14\"> </td>"; $html_email_order .= " </tr>"; $html_email_order .= " <tr class=\"main\"> "; $html_email_order .= " <td class=\"footer\">$Varmailfooter</td> "; $html_email_order .= " </tr>"; $html_email_order .= " </table></td>"; $html_email_order .= " </tr>"; $html_email_order .= "</table></td>"; $html_email_order .= "</tr>"; $html_email_order .= "</table>"; $html_email_order .= "</body>"; $html_email_order .= "</html>"; ?> The stylesheetmail.css is in /osc/stylesheetmail.css
  4. men i installed ten times, it's not working, it's only the stylesheetmail , even i copy the content of the stylesheet in the html_checkout_process.php ,it's not working men. $html_email_order = "<html>"; $html_email_order .= "<head>"; $html_email_order .= "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\"> "; $html_email_order .= " stylesheetmail.css </head>";
  5. the contribution suxx i installed and stylesheetmail not work, he didn't recognize , after hours of fixing, searching, nothing works, it's bullshit
  6. Hello, I installed this contribution and i have this problem when i'am on "checkout_confirmation.php". When i click on "validate checkout" this message appear on my navigator : 1048 - Column 'customers_shopping_points' cannot be null update customers set customers_shopping_points = null, customers_points_expires = null where customers_id = '13' limit 1 [TEP STOP] Can you help me please ? Thank you, and sorry for my english.
×
×
  • Create New...