[cmbehan]

I love this hack, and our users love it as well.

On our site, we have different usergroups, and when we rolled vbookie out I assigned different levels of points to the usergroups.
I made a php file with the following code with the intention of bumping people back up to their starting levels once a month.

    $rs = mysql_query('UPDATE vb_user SET vbookie_cash = (500) WHERE vbookie_cash < (500)');
    $rs = mysql_query('UPDATE vb_user SET vbookie_cash = (750) WHERE usergroupid=(x) AND vbookie_cash < (750)');
    $rs = mysql_query('UPDATE vb_user SET vbookie_cash = (1000) WHERE usergroupid=(y) AND vbookie_cash < (1000)');
    $rs = mysql_query('UPDATE vb_user SET vbookie_cash = (1250) WHERE usergroupid=(q) AND vbookie_cash < (1250)');
    $rs = mysql_query('UPDATE vb_user SET vbookie_cash = (1500) WHERE usergroupid=(z) AND vbookie_cash < (1500)');

It works well, and I made a cron job to run it, but we've decided to change our system to just give everyone an "allowance" of 500 vcash per month.

I know I've seen the SQL query to simply add (x) vcash to each user somewhere here, but I can't find it now.

Can anyone point me in the right direction?

Thanks!