Is there a "simple" way to re-enable all the downloads for a specific customer?
Is there a "simple" way to re-enable all the downloads for a specific customer?
Here's a SQL query that you can copy/paste into your admin's Tools :: Install SQL Patches that will do that. This will set the number of days-to-download as no maximum and the number of downloads to 100 for the specified customer.
You just need to navigate to Customers :: Customers so that you know the to-be-enabled customer's id. Back up your database first!
Code:UPDATE orders_products_download opd INNER JOIN orders o ON o.orders_id = opd.orders_id SET opd.download_maxdays = 0, opd.download_count = 100 WHERE o.customers_id = xx;
Probably a "silly" question, but is there a way to know which database is actually the one for my store? Over time, I have had MANY databases set up, including when I was upgrading my store a few years ago and I was testing. I probably need to clean things up but now, is there somewhere in the admin panel that can state what is its name?
Log into your cpanel
find file manager, click includes/ configure.php
here you’ll see the database your site is using
Mark
Hare Do
Not a silly question at all. In 1.5.7, a small feature was added to the Version tab to show your database.
https://docs.zen-cart.com/user/admin...s/server_info/
The database is (d) in the first diagram.
You can always pull the file includes/configure.php or admin/includes/configure.php and look at the value DB_DATABASE as well, as Haredo noted.
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
I did a backup, and now, applying that code, it is not working. Here is what I get:
https://www.loom.com/share/8a88b16f5...de5d7e2528e9ed
Am I doing it wrong?
You might need to do this in phpMyAdmin instead of Zen Admin, remembering to add the table prefixes.
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Bookmarks