update `badges` set `cat_point` =
CASE WHEN level >= 1 THEN POW(2, `level` - 1) ELSE 0 END
where name not like '%Steam%';
if level >=1 :
cat_point = POW(2, `level` - 1)
else:
cat_point = 0
update `badges` set `cat_point` =
CASE WHEN level >= 1 THEN POW(2, `level` - 1) ELSE 0 END
where name not like '%Steam%';
if level >=1 :
cat_point = POW(2, `level` - 1)
else:
cat_point = 0