For example, if you have database called db_name that you want to copy to new_db_name, you would first create a “database dump” file using:
mysqldump -u db_name -p db_name > a.dump
It will prompt for db password enter it here.
Then create the new database via web hosting control panel
mysql -u new_db_name -p new_db_name < a.dump
It will prompt for db password enter it here

This web-based tool written in PHP makes it easy to search and replace text strings in a MySQL database.
Usually, I develop WordPress sites on a local development server and, when they are ready to launch, I move them to a live web server.
MySQL Search & Replace
For database-driven sites created with content management systems like WordPress, Drupal, and Joomla, this means moving any custom themes and plugins, and it often entails exporting data from the development server’s database and copying it to the live web server.
With small databases, your content management …

Ran into a problem on node form add: there is no nid assigned, so when you save the node the restrictions don’t get saved along with it. The node doesn’t exist, so at that point in the form it has no nid — a value of nid=0 was being added to {restricted content}.
What the user would see is the access restriction just not being saved. They’d have to go back in and edit the saved node, and then set the access again before it would “take.”
Here is the solution :
function …

Dynamic price updater is a module which u can use to update the price on the product info page of the Zen cart. When u select any check-box or select from drop down or input the quantity of the product it dynamically updates the price on the the product info page which is a very useful tool in the zen cart.
It uses the ajax and jscript to update the price dynamically. Click here to download the files

After downloading the file just include the files in your project as they are …

If you dont want that browser dont cache your web page just add the following code in header.

<?php
header(“Cache-Control: no-cache, must-revalidate”); // HTTP/1.1
header(“Pragma: no-cache”); // HTTP/1.0
?>

this will set server to not cache web content of this perticuler page.

When google analytics module stop working,
follow below steps to get back working
– check your modules compatibility if module has a new updates then update that module
– check your footer id there is function wp_footer() is there or not
– check your Analytics Account ID has right value

If you use PHP, you may need to use cURL, which is one of the most popular extension. PHP CURL functions are available through the use of libcurl, a library created by Daniel Stenberg, and allow you to connect and communicate with web servers using many
different types of protocols.
Assume you have already setup LAMP. To install or setup cURL on your Linux machine like Ubuntu, run the following line of shell command in your terminal:
sudo apt-get install curl libcurl3 libcurl3-dev php5-curl
Now you have PHP cURL installed, the next thing you …

If you want to set cron into cerberus helpdesk go into cPanel and set below command for cron jobs
“wget http://YOURDOMAIN_NAME/cron?loglevel=3″

In zen cart that is default that you can create admin coupon to give amount deduction or free shipping ,
you can not give customer both benefit of amount deduction as well as free shipping,
to do that you have to add code in two files that are
1) includes/modules/order_total/ot_coupon.php
2) includes/templates/[your template]/popup_coupon_help/tpl_main_page.php
In file 1 ot_coupon.php
find the code as

if ($od_amount['type'] == ‘S’) $order->info['shipping_cost'] = 0;
$order->info['total'] = $order->info['total'] – $od_amount['total'];
if (DISPLAY_PRICE_WITH_TAX == ‘true’) {
$od_amount['total'] …

When integrate wordpress in to zen cart using the Zen cart CEON module then we might face the problem in the URL of woprdpress pages, posts and other links.
To solve the above problem, just go to wordpress admin -> Settings -> Permalinks
From the permalink settings of wordpress admin, select Default and then Save Changes