panicgripdesigns

I've been building some new interfaces on my shop, and have realized that I would like to use mysqli_fetch_all, so I added it into my database.php. It might be a useful function to have in osC. Just a proposal. function tep_db_fetch_all($db_query) { return mysqli_fetch_all($db_query, MYSQLI_ASSOC); }

Just as a notice, I got this email today. Haven't had a chance to see what they're changing. Web Tools Customer; January 26 USPS Web Tools Update: USPS Web Tools will be implementing changes and additional features to the U.S. Postal Service APIs listed below effective January 26, 2014 with testing available January 13th. Detailed release notes are available on the USPS Web Tools home page here. If you are a merchant using a 3rd party ecommerce or shipping software, please ensure that your IT professional is aware of the upcoming changes. The following APIs will be modified and/or enhanced beginning January 26: Domestic Label Retired APIs: DeliveryConfirmationPICV3 SignatureConfirmationPICV3 Rate API Updates: RateV3 API RateV4 API InternationalRateV2 API Domestic Label API Updates: ExpressMailLabel API HoldforPickupExpress Label API eVS Label API DeliveryConfirmation V2, V3, V4 APIs SignatureConfirmation V3, V4 APIs Priority Mail Open and Distribute API (OpenDistributePriorityV2) Priority Mail Hold for Pickup API (HoldForPickupPriority) First Class Mail Hold for Pickup API (HoldForPickupFirstClass) Merchandise Return Service API (MerchandiseReturnV2,V3, V4) International Label API Updates Priority Mail Express International Label API (ExpressMainIntl) Priority Mail International Label API (PriorityMailIntl) First Class Mail International Label API (FirstClassMailIntl) 2976 Custom Form API (CN22V2) Other API Updates: Track and Confirm APIs (Track, TrackV2) Address Verification API (GetAddress) You will find the January Release Notes under the Web Tools Announcements Section at USPS.com here. Please Follow us on twitter at @USPSWebTools for updates or contact the Web Tools team directly at WebTools@usps.gov with any questions or concerns. Take care, Ben Burgess

Understood Chris. Just pasting this here incase anyone else wants to modify their download of the contribution to use proper oscommerce functions. Figured I might save some people some time in the future. Also PHP 5.5 is a stable release... http://php.net/downloads.php

PROTIP: replace mysql_* and similar functions with tep_db_* This addon does not play nicely with the newest versions of MySQL / PHP Here's my server configuration: Database Host: localhost (127.0.0.1) Server OS: Linux 3.8.4-x86_64-linode31 Database: MySQL 5.5.30-log Server Date: 2013-08-05 15:49:09 -0400 EDT Database Date: 2013-08-05 19:49:09 Server Up Time: 19:49:09 up 89 days, 4:11, 1 user, load average: 0.39, 0.41, 0.41 HTTP Server: nginx/1.4.1 PHP Version: 5.5.0-pl0-gentoo (Zend: 2.5.0-dev) (This is how I fixed an issue where the admin page was not populating the database.)

I apologize for not having read the guidelines for this forum. I'm not sure where the best place to move this topic would be, and I don't know that I am able to move it. If a moderator could please relocate it, I would appreciate that. Also I apologize for double posting, I don't see an edit button anymore.

I've been learning about NoSQL Databases that use object models instead of traditional table-based implementations and it seems like something that would be helpful on osCommerce installations with heavy traffic. I'm working on an online store with over 8k products, 20k orders, and 50k products sold. It seems like one of these databases like MongoDB would be able to combine a ton of tables, like one staring with Customers, Orders, etc, into customer based records. My question: Has anyone ever heard of any projects to get a NoSQL database to work with osC? //Additional questions My main purpose in looking toward a NoSQL database is to try to speed up my site. Or: Does anyone know of any tips/tricks to really increase the performance of an osCommerce 2.3.x site? Also: Is anyone familiar with any type of query profiler, perhaps similiar to the CodeIgniter one, that would let me see what all is being run to generate each page?

Chris is right. But I'm SURE there are some talented designers/coders on here that would be willing to take it on freelance.