All pastes #194173 Raw Edit

Someone

public text v1 · immutable
·published 2006-10-07 16:37 UTC
rendered paste body
select least(`notoriety` * 0.2 + 6, 200) as maximum from `mm_master` where `mid` = '10'
select sum(`number`) as count from `mm_minion` where `master_id` = '10'

then i have some if's

if (`count` =< `maximum` - 6){
   addme = 6
}elseif (`count` < `maximum`) {
   addme = `maximum` - `count`
}

then 

insert into `mm_minion` (`mid`,`number`) values ('10',`addme`) 
  on duplicate key update `number` = `number` + `addme` where `master_id` = '10'

#####
`notoriety` is between 1 and 1000
`number` is between 1 and 200