Today I had to figure out the most efficient way to generate Emoji from ISO 3166-1 Alpha-2 country codes such as US, GB, etc. I opted to go for a for 100% SQL solution.
The most efficient way to convert each ASCII letter to their Unicode Regional Indicator Symbol Letter that I determined is provided below (simplified)…
Continue reading
A quick run-through to show you how to adjust the volume of individual Windows applications…
I realize LiveZilla has their own suggestion for performing input field validation, but here is my spin on the process.
Create `validation.php` in your main LiveZilla folder with the following code (update input field IDs accordingly)…
Continue reading
I wrote a post yesterday about testing your internet connectivity using a Windows batch file, but since I cannot leave well-enough alone, I decided to keep working on it.
A few things to keep in mind…
I have been having issues with my ISP‘s WiFi router, so I decided to create a batch file I could run as-needed to check internet connectivity.
@echo off cls set "router=192.168.0.1" set /p "router=Enter router IP address or press [ENTER] for default [%router%]: " @ping %router% -n 1 | FIND "Reply" @ping google.com -n 1 | FIND "Reply" @ping bing.com -n 1 | FIND "Reply" echo Press any key to exit... pause >nul
Save that as `ping.bat` and put in somewhere convenient. Then…
Continue reading
I was hardening a server this morning and decided my reference for disabling root access within Linux / cPanel / WHM may benefit someone else.
Note: Some may end up here trying to find out how to disable the WHM’s root user login. I do not believe that is possible.
Continue reading
I finally decided to tackle a site that had over 20GB of images in a single folder. I won’t say who created this monster (whoops), but while moving the site to a new dedicated server, I decided it was time to remedy the situation.
The first issue is with anything you want to (graphically) process folders is limited greatly by the GUI and how much data needs to be processed for each request. This is why I decided a hashed folder naming convention would be the best approach. The folder names do not matter, just so long as there is reasonable grouping and/or separation.
Continue reading
My most common request for help stems from the following error…
Error 4025: Invalid credentials
The credentials supplied in the authorization request are invalid.
This error indicates you are using the wrong credentials for the transaction server selected in your payment module’s settings. It can also indicate FirstData has not enabled web transactions for your terminal. Continue reading
Even though we are still finding bug in Open Cart 2.3.0.2, it is still a far cry better than what we’ve seen from 3.x by far.
You may have noticed the “Additional Alert Email” field simply will not save in your OpenCart “Store Settings” editor. This is a result of the OC devs renaming the input field in 2.3.0.2 without changing the references everywhere else. Continue reading
There are multiple ways to remove an application from most Macintosh operating systems. Choose the one that suits your tastes and environment. Continue reading
I always suggest Linux hosting for any OpenCart installations. The main OC developers either don’t know much about Windows IIS or neglect to include the necessary SEO URL configuration file for it to work.
This omission results in “not found” 404 (dead link) errors when you visit a page with an SEO URL assigned after enabling SEO URLs in your OpenCart store settings.
Continue reading
Here is a quick function I created to merge multiple arrays and sum or concatenate the values thereof. If the values are numeric they will be added together (sum). Otherwise the values will be appended to each other (concatenation).
function arrayMergedSumConcat() {
$out = array();
$num_args = func_num_args();
$arg_list = func_get_args();
for ($i = 0; $i < $num_args; $i++) { $in = $arg_list[$i]; foreach ($in as $key => $value) {
if (isset($out[$key])) {
if (is_numeric($in[$key]) && is_numeric($out[$key])) {
$out[$key] += $in[$key];
} else {
$out[$key] .= $in[$key];
}
} else {
$out[$key] = $in[$key];
}
}
}
return $out;
}