Closed silascutler closed 5 years ago
Update existing users
UPDATE tbl_users set query_base = 2000 where query_base=1000;
Update defaults
ALTER TABLE tbl_users ALTER query_base SET DEFAULT 2000;
ALTER TABLE tbl_users ALTER query_limit SET DEFAULT 2000;
Updated scheduled event:
ALTER EVENT reset_limits DO UPDATE tbl_users SET query_limit=query_base WHERE ((query_base = 1000 or query_base = 2000) AND query_limit < 1000) or query_base > 1000000;```
(Slight change to schedule event:)
ALTER EVENT reset_limits DO UPDATE tbl_users SET query_limit=query_base WHERE ((query_base = 1000 or query_base = 2000) AND query_limit < 2000) or query_base > 1000000;```
^ As title says