Quote:
Notice that I added two statements:
Code:
AND tblorders.status = 'C' OR tblorders.status = 'P'
|
Hi,
People seem to be having trouble implementing this, I just wanted to let you know that it works perfect for me so you wouldn't feel that the script only worked on your server. Couple of comments though, the above code I mentioned above does not work, it will cause the script to only list one product and credit it with insane sales of 99 in qty and 300,000 in total. The right code is:
Code:
AND tblorders.status = 'C' OR 'P'
I don't think it would be that difficult to implement this into xcart's admin area, you just have to take out the non php related material and save that as the tpl file, create a link in the menu, and link it in the home.tpl area. I'm pretty sure someone will crack it.
Thanks for the mod, its excellent!