User : thejasonparker
|Hide DIV scrollbars with CSS||TheJasonParker||CSS||div||
overflow: hidden; will hide both vertical and horizontal scrollbars overflow-y: hidden; will hide the vertical scrollbar overflow-x: hidden; will hide the horizontal scrollbar
|July 6, 2012|
Fooman GoogleAnalyticsPlus: http://www.magentocommerce.com/magento-connect/fooman-googleanalyticsplus.html
The key to seeing the different steps in your checkout is ensuring a page view is triggered each time one of the sections of the checkout is loaded. To do this we need to edit opcheckout.js this file should be in \skin\frontend\default\YOURTHEME\js if not then copy it there from \skin\frontend\base\default\js
Within this file search for “gotoSection: function(section)” to find the function we are interested in amending and add in the lines of code shown below.
If you are using the old analytics code then you will need to remove the slashes from the line “//pageTracker….” and comment out (add a double slash to the beginning of) the line beginning “_gaq.push…”.
Google Analytic Gaol Setup Goal Type: URL Destination Match Type: Head Match Goal URL: /checkout/onepage/success/
Step 1 URL: /checkout/onepage/ Name: Login or Register Step 2 URL: /checkout/onepage/billing/ Name: Billing Address Step 3 URL: /checkout/onepage/shipping/ Name: Shipping Address Step 4 URL: /checkout/onepage/shipping_method/ Name: Shipping Method Step 5 URL: /checkout/onepage/payment/ Name: Payment Details Step 6 URL: /checkout/onepage/review/ Name: Confirmation
|May 31, 2012|
|Magento Gallery Image Rollover||TheJasonParker||PHP||php||
Replace the code below in your templates 'media.phtml' file. This has mouseover and mouseout but can be removed it needed.
|March 17, 2012|
|How to check to see if a table exists in a mySQL database.||TheJasonParker||PHP||mysql||July 21, 2011|
|Drop a table if it exists with mySQL||TheJasonParker||MySQL||July 21, 2011|
|Delete & Recreate a table quickly with mySQL||TheJasonParker||MySQL||July 21, 2011|
|Restore MySQL database in WampServer||TheJasonParker||MySQL||wampserver||
Go to the Windows command line by going to Start -> Run and typing in cmd.
You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin.
Therefore, the command to change to this directory is: cd wamp\bin\mysql\mysql4.1.22\bin
Put the MySQL dump (SQL file) into the above directory
Create the new database in phpmyAdmin (or on the command line)
The actual restore command is slightly different to normal (see below).
Note that is says mysql.exe rather than the normal mysql. When it asks you for a password, just hit enter. There is no password associated with the database that you created (unless you prefer to have one. But as it is local, there is no need).
|April 19, 2011|
|Excuting sql files from Linux shell||TheJasonParker||MySQL||linux||
Ftp your *.sql file to the (remote) machine, login via SSH and then go to the directory where your sql file is and run this code.
|January 25, 2011|
|Decompress gz files in Linux||TheJasonParker||Other||linux||
Gunzip can currently decompress files created by gzip, zip, compress, compress -H or pack programs.
|January 25, 2011|
|Restoring a backup in Magento||TheJasonParker||MySQL||magento||
Wrap these two sets of commands around your sql backup if it hasn't come from a backup from the Magento admin interface (Magento adds this).
This stops foreign key checks and then restarts them.
The /*!40101 ---- */ code around the SET commands asks "If this version of mySQL is 4.1.1 or newer then run the SET command else do nothing." Older versions will not understand the statement.
This allows for easier compatibility with other versions of mySQL.
|January 21, 2011|
|Magento Memory Leak v220.127.116.11 (The Array of Death)||TheJasonParker||PHP||magento||
This fixes the way Magento imports data as it just keeps adding ‘straight join’ to the array which uses a lot of memory if your importing a lot of products and will kill the import.
Replace this function in /lib/Varien/Db/Select.php
This has been fixed in the next update and a discussion can be seen here...
|January 17, 2011|
|Magento Log File Contents Report||TheJasonParker||PHP||magento||
And a now, word on the log.php maintenance script that comes with Magento 1.4 which has one major shortcoming.
It doesn’t maintain your dataflowbatch* tables, said tables have been seen hiding in the wild at over a Gigabyte in size.
php -f ./shell/log.php help gives you a listing of the various options
php -f ./shell/log.php status gives you a listing of the log tables, how many rows and the size of storage space contained in the tables and indexes.
php -f ./shell/log.php clean --days 15 will clear all but the last 15 days of log contents (minimum 1 day)
php -f ./shell/log.php clean clears everthing per your settings in system setups under log maintenance
|January 17, 2011|
|Log & Cache Maintenance Script||TheJasonParker||PHP||magento||
Save the file to the directory where Magento resides.
|January 17, 2011|
|Delete All Category Products||TheJasonParker||PHP||magento||
Change the category id and store id at the top of the script before running it. You can also remove the echo statements if you don’t want any output.
|January 15, 2011|
|Remove a specific character from the end of a Excel cell||TheJasonParker||Visual Basic||excel||
Replace 'A1' with the cell and '-' with the character you want to remove.
|January 14, 2011|