Under 3.0.x, my site has been using vCash for my bookie events. I'm moving my production site to 3.5.x tonight, and I really want to change that to uCash, but my users really want to keep their totals from the last year, except for some who were recently shorted their starting totals because of a configuration mistake.
So two questions/calls for help as I struggle with mysql;
1. Does anyone know of a way (been looking around for about an hour, and haven't found anything), perhaps a query, to copy all vcash values to ucash in the database?
2. Can anyone suggest a query that would give all users with less than X ucash, Y as a new balance -- but only if their userid is greater than Z?
Thanks in advance.
|