Issue #33: December 16, 2003

By Harald Ponce de Leon

December 16, 2003

osCommerce 2.2 Milestone 1 SQL Injection Vulnerability
Forum Searching
Development Progress
E-Commerce Regulations

Discussions regarding this weekly report can be found here:

https://forums.oscommerce.com/index.php?showtopic=70525

osCommerce 2.2 Milestone 1 SQL Injection Vulnerability

An SQL injection vulnerability exists in osCommerce 2.2 Milestone 1, due to variable types not being checked which has been addressed in the 2.2 Milestone 2 release.

The reported vulnerability exists during the customer account creation procedure, specifically in the create_account_process.php file, with the user submited country value being used rawly in SQL queries.

The functions involved in processing the vulnerable SQL queries are defined in includes/functions/general.php, and are called tep_get_zone_name() and tep_get_countries().

It is strongly recommended for stores running on 2.2 Milestone 1 to download the update package, to read the documentation within, and to apply the updates appropriately.

Although only two functions are vulnerable in this report, other functions could also be affected due to variable types not being checked. A replacement for the includes/functions/general.php file is provided in the update package to minimize further injection possibilities from occuring.

Although no further SQL injection reports are known, and as variable checking was implemented in 2.2 Milestone 2, Milestone 1 will remain in the risk zone, and is therefore recommended to update the remaining SQL queries appropriately or to upgrade to Milestone 2. Further information is available in the update package.

The update package can be downloaded here:

https://www.oscommerce.com/ext/oscommerce-22ms1-20031216.tar.gz

Forum Searching

The default searching algorithm for the forums has changed from an "or" based algorithm, to an "and" based algorithm.

This changes the results returned by returning posts containing all words searched for, instead of any words searched for.

Searches for "payment module" will now return posts containing both words, instead of either.

If the "or", or either, method is preferred, searching for "payment or module" is now required and will only return posts containing either words.

Development Progress

The following new classes have been implemented into CVS:

* osC_Customer
* osC_Session
* osC_Tax

All variables are now called in their respective scope, making the Catalog register_globals compatible, which includes using the new super global variables introduced in PHP 4.1.

Changes to the currencies class will be commited this week, which improves performance by querying the tax rate only when DISPLAY_PRICES_WITH_TAX is enabled.

The list of incompatibilities between Milestone 2 and Milestone 3 can be viewed on the Wiki site at the following address:

https://wiki.oscommerce.com/proposalMS2MS3Incompatibilities

Discussions regarding the progress of Milestone 3 are held in the following forum thread:

https://forums.oscommerce.com/index.php?showtopic=66462

E-Commerce Regulations

New parameters will be introduced to enable features legally needed in some countries, and to disable the same features where not needed.

The initial list of features that will be controlled via parameters can be seen on Workboard entry 69. The first feature of forcing the customer to accept the terms and conditions when proceeding through the checkout procedure has been implemented in CVS.

The second feature of forcing the customer to agree to the privacy notice when creating an account will be commited to CVS during the week.

Discussions regarding Workboard entry 69 are held in the following forum thread:

https://forums.oscommerce.com/index.php?showtopic=68739

 

Recent posts

Time limited offer to mark the arrival of osCommerce v4!

May 24, 2022
Valuable REWARDS to all Subscribers of osCommerce newsletter:   - 10 native osCommerce applications +   - discounted osCommerce hosting for 1 shop Subscribe now ...

osCommerce v4 Beta 2 Released

January 26, 2022
osCommerce v4 Beta 2 has been released today! Current Beta is closer to the planned release version. We have removed a number of add-ons to simplify the installation. They will be re-instated via the App store, most of them free. Beta 2 comes with: - installation tool - 2 demo front ends - osCommerce back end - data import tool to migrate data from old osCommerce 2.x - instructions on how to submit your feedback Download links have been emailed to all Beta testers. If you have not received your link, please check your "spam" folder just in case, and contact us via this Forum to have the link re-sent to you. If you wanted to try Beta 2 but didn't sign up - get in touch with us via the Forum or via the Contact form on the website and we will sort it for you. osCommerce v4 will be released shortly as a powerful modern modular optimised FREE open source Ecommerce solution! Kind regards, osCommerce team   ...

osCommerce v4 Beta 1 Released

November 17, 2021
osCommerce v4 Beta 1 has been made available to a limited number of first reviewers today. We will work with the feedback we receive over the next couple of weeks, and will release Beta 2 to registered Beta-testers in early December 2021. Want to become a Beta tester? Contact us via the main website to register your interest now and receive access to Beta 2 in December! Providing we continue to receive reasonable feedback from the Beta testers we are looking to launch osCommerce v4 in early January 2022. Keep checking the Forums for updates. The wait is over!   ...

osCommerce v4 features: Order Editor, Gift Vouchers, Loyalty points, Currencies and Rounding

March 19, 2021
Working through the feature list of osCommerce v4: Order Editor and MOTO orders: https://forums.oscommerce.com/topic/496930-order-editor/?tab=comments#comment-1821801 Gift Vouchers: https://forums.oscommerce.com/topic/496929-gift-vouchers/?tab=comments#comment-1821800 Loyalty points: https://forums.oscommerce.com/topic/496924-loyalty-or-bonus-points/?tab=comments#comment-1821793 Currencies and Rounding: https://forums.oscommerce.com/topic/496921-currencies-and-rounding/?tab=comments#comment-1821738 Have any questions or comments? Feel free to post them here! Questions about osCommerce shall be emailed to  hello@oscommerce.com Development Partners and Beta Testers are always welcome! Please sign up via our  Contact Page . We will notify you when the Beta version becomes available (likely in June 2021). Development Partners - we will make preview versions available to you, please indicate your interest when signing up for the Beta Program.   ...

osCommerce v4 updates: Payments, Shipping, Shipping Labels, Order Totals

March 12, 2021
Update on osCommerce v4 feature list Payment methods: https://forums.oscommerce.com/topic/496907-payment-methods/ Shipping solutions: https://forums.oscommerce.com/topic/496910-shipping-methods/ Shipping labels: https://forums.oscommerce.com/topic/496911-shipping-labels/ Order structure management: https://forums.oscommerce.com/topic/496912-order-structure-totals-modules/ Have any questions or comments? Feel free to post them here! Questions about osCommerce shall be emailed to  hello@oscommerce.com Development Partners and Beta Testers are always welcome! Please sign up via our  Contact Page . We will notify you when the Beta version becomes available (likely in June 2021). Development Partners - we will make preview versions available to you, please indicate your interest when signing up for the Beta Program.   ...

osCommerce v4 news: SEO and Menu Editor

March 06, 2021
osCommerce v4 features continue to be revealed. Today we published preview of on-site SEO system in osCommerce v4 on our Forums: https://forums.oscommerce.com/topic/496884-search-engine-optimisation-seo/ and its Menu editor: https://forums.oscommerce.com/topic/496886-menu-editor/ Questions about osCommerce shall be emailed to  hello@oscommerce.com Development Partners and Beta Testers are always welcome! Please sign up via our  Contact Page . We will notify you when the Beta version becomes available (likely in June 2021). Development Partners - we will make preview versions available to you, please indicate your interest when signing up for the Beta Program.   ...

osCommerce v4 news: Multiple Design Templates and Template Designer

March 02, 2021
osCommerce v4 features are being revealed. Today we share information about Design Templates and Template Designer of osCommerce v4 on our Forums: https://forums.oscommerce.com/topic/496786-multiple-design-templates-and-built-in-designer/ Questions about osCommerce shall be emailed to  hello@oscommerce.com Development Partners and Beta Testers are always welcome! Please sign up via our  Contact Page . We will notify you when the Beta version becomes available (likely in June 2021). Development Partners - we will make preview versions available to you, please indicate your interest when signing up for the Beta Program.   ...

New management and osCommerce v4

February 19, 2021
Assert Record Run SnapTest ...

Phoenix v1.0.7.15

February 10, 2021
v1.0.7.15 is a bugfix release. This should be considered the second release candidate for 1.0.8.0. Easy Updates Easy update zip and instructions are provided in the Phoenix Club for every minor and major update. Going from version to version could not be easier - you are supported by the Phoenix Team,  Certified Developers , and other Shop owners. This update takes 100 seconds from start to finish. Have your say at the Phoenix Club Instead of waiting for a perfect tomorrow, help us make a better today by joining the  Phoenix Club . Thank you Thank you to all Shop owners and Developers who are supporting the Project - you allow Phoenix to fly high and burn brightly.   ...

Phoenix v1.0.7.14

January 26, 2021
v1.0.7.14 is the final development release of the 1.0.7.* series. It finishes the templates system, including the ability to override the HTML templates and the language files. This should be considered the first release candidate for 1.0.8.0. Easy Updates Easy update zip and instructions are provided in the Phoenix Club for every minor and major update. Going from version to version could not be easier - you are supported by the Phoenix Team,  Certified Developers , and other Shop owners. This update takes 100 seconds from start to finish. Have your say at the Phoenix Club Instead of waiting for a perfect tomorrow, help us make a better today by joining the  Phoenix Club . Thank you Thank you to all Shop owners and Developers who are supporting the Project - you allow Phoenix to fly high and burn brightly.   ...
Products