Let’s say you have a problem: A recent DB migration has escaped a lot of quote marks within your fields and now your app is acting funny. Your task is to fix the problem, and do it FAST. Enter the replace() function in MySQL (assumed other RDBMs as well, such as Postgres and MSSQL) UPDATE …
Tag Archives: Web Apps
Fixing Zen Cart’s Tax Miscalculation When Using a Coupon
I was recently alerted to an error in Zen Cart by a client where the tax was being miscalculated when using a coupon. Here’s the fix. Around line 240 in /store/includes/modules/order_total/ot_coupon.php Remove these lines: //$od_amount[$tax_desc] += (($products[$j][‘final_price’] * $products[$j][‘quantity’]) * $tax_rate)/100 * $ratio; //$od_amount[$tax_desc] += round(((($products[$j][‘final_price’] * $products[$j][‘quantity’]) * $tax_rate) + .5)/100 * $ratio, 2); …
Continue reading “Fixing Zen Cart’s Tax Miscalculation When Using a Coupon”
Amberjack Media, RevealCMS
It’s official – I’m now Amberjack Media (amberjackmedia.com). The papers from the city just arrived, but the process with officially registering the DBA with the county is not yet complete. I have the domain, but it’s not yet set-up with any hosting space just yet. On another note, I’ve named the CMS i’m working on: …
__CMS milestone
I still haven’t decided on a name for my CMS, though I have a couple of good ideas that I’m going to think about in the next couple days/weeks. On the same note I’m also considering a name for my company. My First/Last name works well enough, but I’d like something a bit more formal …
DFL major release!
Lots of news over here at the Digital Fish Library. We just moved the production, qa, and dev staging sites to our new servers over the weekend, and at the same time made some major updates public that will surely allow the website to grow with few pains over the next several months. 1) Family …
SEO your URL
If you’re looking for some help on learning mod_rewrite, this post isn’t for you. sorry. Instead, I’m going to show you a neat little trick that will make sure you always have one the www in front of your domain name. Why is it important? Potentially for your stats package, definitely for search engine ranking …
Pre-QA isn’t good for interviews
I’m just going to throw this out there… if you have a piece of software, site, etc that isn’t quite at the QA stages, no matter how rockin’ in might be, you might want to consider holding off on showing it to others until you know the demo is going to work. I think I’m …
Mr. Fish Lite is coming
If you’re interested in the DFL project, you’ll be happy to know that German and I are tasked with a bit of a crack programming job in the next week or so. Actually, we told our boss the idea we had about making a “Lite” version of the data viewer program that runs through some …
Siggraph2006 Poster
We got the good news today: our poster for Siggraph2006 has been accepted! Look for Interactive 3D Graphics for Web-based Data Analysis and Visualization for the Digital Fish Library (DFL). I likely won’t be there for the conference, but German will – he is the first author, after all. DFL Publications.
Caching HTML Output with Smarty
I’ve begun using the Smarty template engine for my projects requiring dynamic content – you know, the good ol’ MVC (model-view-controller) approach to (web) applications. Because the sites I work on aren’t particularly high-traffic, I never really thought too hard about caching… until I actually began thinking about caching. The question is “why not?”. With …