Reward Points Module for ZC v13x

I am working with my hosting company right now to get the MySQL file from a back up that was done by them on 7/31 which was a day before the wipe.

So As I am doing this, I also noticed that even with the updates, I am stll having a problem with my points going straight to earned. They are still being put into pending even when the sunrise period is set at zero.

Any ideas on that one? Thanks!

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:

Quote:

---

The main gist of this is that you're going to have to remove some drop commands and modify some inserts, save the file with the changes and then import the dump in PHPMyAdmin

---

So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

Quote:

---

Originally Posted by lauriesscraps

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:


So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

---

Laurie- just send the files to me, I think I still have access to your site.

Quote:

---

Originally Posted by nigelt74

PHP Version 5.2.12
MySQL 5.0.90-community

But it still doesn't work as in when i make an order and mark it as dispatched no reward points are awarded

I'll add a link to the rpd file

http://nigel.geek.nz/sbo_shop/rpd.php

---

Check this line in the RPD:

Quote:

---

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

---

Try reinstalling upgrade.sql

Quote:

---

Originally Posted by hem

Laurie- just send the files to me, I think I still have access to your site.

---

I only have one file. Should there be more? I also do not have your email, so if you could PM me with it that would be great!

You have access to my Zen Admin and to the FTP. They way they told me to do it required for me to import the file through the CPanel.

Let me know what you need.

Quote:

---

Originally Posted by lauriesscraps

I only have one file. Should there be more? I also do not have your email, so if you could PM me with it that would be great!

You have access to my Zen Admin and to the FTP. They way they told me to do it required for me to import the file through the CPanel.

Let me know what you need.

---

Actually, the file is in my root directory. Is is has my username and then zc01.sql. Let me know if you need anything else.

Thank you!

Quote:

---

Originally Posted by lauriesscraps

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:


So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

---

This actually was what I was talking to you about in my post in regards to the change some of the SQL coding from INSERT INTO to INSERT IGNORE INTO and remove the delete tables. But I think you're getting help on this already. :)

Quote:

---

Originally Posted by lauriesscraps

Actually, the file is in my root directory. Is is has my username and then zc01.sql. Let me know if you need anything else.

Thank you!

---

I don't see it. I can see a series of SimpleScript backups, is it one of those?

Quote:

---

Originally Posted by hem

I don't see it. I can see a series of SimpleScript backups, is it one of those?

---

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

OH MY GOSH!!! Thank you! I just have to add a few that look like got overrided from orders over the last couple weeks but that is much better than having 3 pages of reward points to add! THANK YOU! You, once again, rock my world. I promise I will try to leave you alone now. Hahaha, thank you!