How to reset zen-cart admin password?

If you lost your zen-cart admin password, and you can not reset the new passwords via email either, how to do then? We can reset the admin passwords via phpmyadmin.

If your zen-cart is v1.3.9.h or older, open your phpMyAdmin (supplied by your hosting company), select your store’s database, then click the “SQL” tab and run this query:
DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); Continue reading How to reset zen-cart admin password?

X-cart Customer Also Bought Settings Method

We need to 2 steps to set Customer Also Bought of X-cart. Fist login admin panel and go to Settings –> Appearance –> Count of columns in simple product list, and Fill in 2, then the products will display in 2 columns.

Second aslo at admin panel, go to Settings –> Modules –> Recommended Products, and click “Configure”, “Number of products to be displayed in recommended products list”, fill in 6, if you like to show 6 products.

The above method is tested successfully under X-Cart Gold V4.4.4

How to delete Zen-Cart un-approved Product Reviews in Bulk?

If there are so many spam products reviews, we can not delete them one by one. We will spend a lot of time if we do so. We can using mysql command to delet the spam or un-approved zen-cart reviews in bulk.

The product review id is save at 2 tables: reviews and reviews_description, the review status is save in pres_reviews, if the status is “0”, it means the review is not approved yet. And the reviews details is saved in reviews_description. Continue reading How to delete Zen-Cart un-approved Product Reviews in Bulk?

Is there any way I can change this Auth Code of X-cart ?

After a long time of the installaction, we may have fogor the Auth Code, then we can not reinstall the old x-cart. Is there any way I can change this Auth Code then?

The answer is yes!
You can edit …/store/include/install.php.
Open install.php under include, $installation_auth_code = “xxxx”; xxxx will be your Auth Code.

Note: Perhaps it would be best to delete or otherwise make inaccessible the file.

How to Disable Drupal User Registration

If you do not like others to register your drupal based websites, login your drupal based website admin panel. Go to User management -> User settings.

Under Public registrations, choose “Only site administrators can create new user accounts.”

Save and done. I have tested Drupal 6.22.

WordPress and SimplePie Skills

I have used SimplePie for 2 years, and found it very useful, here are 2 skills I’d like to share with you.

Skill 1: Prevent show disordered characters if your goal site is using non-UTF8 code, such as iso-8859-1.   Befor   $feed->init() add the following code:


Skill 2: Show multiple feeds ( feeds sort by time and date)