[Andrew Green]

Originally Posted by shawnkaycie

This is a AWSOME add on!! Love it! but one problem when I try to Mass Cash Adjust I get an error...

Database error in vBulletin 3.8.2:

Invalid SQL:

UPDATE user
SET casino_cash = casino_cash + 300
WHERE usergroupid IN (admin1);

MySQL Error : Unknown column 'admin1' in 'where clause'
Error Number : 1054
Request Date : Saturday, July 11th 2009 @ 02:31:20 PM
Error Date : Saturday, July 11th 2009 @ 02:31:21 PM
Script : http://mysite.com/admincp/casino_set...it=Adjust+cash
Referrer : http://mysite.com/admincp/casino_settings.php
IP Address : 98.223.130.188
Username : Admin1
Classname : vB_Database
MySQL Version : 5.0.75-community-log

Any help?

Shawn

Use the user group ID, not user group Name. You are entering "Admin1" as a usergroupID, it should be the ID number associated to that usergroup