Custom Quotes: 1-508-471-4711

Archive for July 2007

Cubecart multiple delete and re categorize admin hack

I am developing a new shopping cart using the cubecart system, the client has about 2500 parts in the database. After importing these products into the database I noticed that a good 500 were mis categorized and about 100 were out of date and had to be removed. Cubecart didnt have any support for multi re-categorize or multiple deletes so I created the following hack. This hack will allow you to check off all the products on the product view page and do 2 different things. Either delete the selected products or move the selected products to a different category. To enable this hack in your cubecart admin panel paste the code in the following areas . bad credit history loans300 cashmoney tree payday loans Due to people not being able to copy the code correctly I have pasted it in a text file which can be viewed here install_multi_delete_recat.txt You can also download my own index.php with the mod already installed, this will work perfect for you if you havent already modded your admin/products/index.php. Download that file here: install_multi_delete_recat-2.zip

Read more

mysql update from another table

Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process. Open up phpmyadmin or similar database editor view the sql query below UPDATE updatefrom p, updateto pp SET pp.last_name = p.last_name WHERE pp.visid = p.id payday loan lead generatorscompanys marketeosdesigns.com/amanda/ Lets say we have 2 tables one named main and one named updateto and one named updatefrom, In the first line we assign variables to these t tables (p and pp) from there we can call column names using this format table.columname. If we had first_name and last_name in both tables and wanted to update the “updateto” table with the info from “updatefrom” this is how you would write it.

Read more