update creature_template set attackpower = round((maxdmg + mindmg) / 4 * 7) where entry in ('2069','2070','2071','2163','2164','2165','2172','2174','2185','2187','2188','2231','2232','2233','2234','2235','2236','2237','2321','2322','2323','3234','3235','3236','3237','3238','3239','3240','3242','3243','3244','3245','3246','3247','3248','3249','3250','3251','3252','3254','3255','3256','3415','3424','3425','3426','3461','3463','3466','3473','3619','3630','3631','3632','3633','3634','3636','3637','3641','3695','3797','3809','3810','3811','3812','3814','3816','3817','3818','3819','3820','3821','3823','3824','3825','3939','4005','4006','4007','4008','4009','4011','4012','4013','4014','4015','4018','4019','4031','4032','4041','4042','4044','4067','4127','4128','4129','4263','4316','5198','5774','5827','5829','5831','5834','6167','6788','6789','8236','10644','11921','12037','12123','12676','12678','17345','17347','17348','17349','17350','17522','17523','17525','17527','17530','17661','17673','17683','20797','5928');
update creature_template set mindmg = round(mindmg - attackpower / 7) where entry in ('2069','2070','2071','2163','2164','2165','2172','2174','2185','2187','2188','2231','2232','2233','2234','2235','2236','2237','2321','2322','2323','3234','3235','3236','3237','3238','3239','3240','3242','3243','3244','3245','3246','3247','3248','3249','3250','3251','3252','3254','3255','3256','3415','3424','3425','3426','3461','3463','3466','3473','3619','3630','3631','3632','3633','3634','3636','3637','3641','3695','3797','3809','3810','3811','3812','3814','3816','3817','3818','3819','3820','3821','3823','3824','3825','3939','4005','4006','4007','4008','4009','4011','4012','4013','4014','4015','4018','4019','4031','4032','4041','4042','4044','4067','4127','4128','4129','4263','4316','5198','5774','5827','5829','5831','5834','6167','6788','6789','8236','10644','11921','12037','12123','12676','12678','17345','17347','17348','17349','17350','17522','17523','17525','17527','17530','17661','17673','17683','20797','5928');
update creature_template set maxdmg = round(maxdmg - attackpower / 7) where entry in ('2069','2070','2071','2163','2164','2165','2172','2174','2185','2187','2188','2231','2232','2233','2234','2235','2236','2237','2321','2322','2323','3234','3235','3236','3237','3238','3239','3240','3242','3243','3244','3245','3246','3247','3248','3249','3250','3251','3252','3254','3255','3256','3415','3424','3425','3426','3461','3463','3466','3473','3619','3630','3631','3632','3633','3634','3636','3637','3641','3695','3797','3809','3810','3811','3812','3814','3816','3817','3818','3819','3820','3821','3823','3824','3825','3939','4005','4006','4007','4008','4009','4011','4012','4013','4014','4015','4018','4019','4031','4032','4041','4042','4044','4067','4127','4128','4129','4263','4316','5198','5774','5827','5829','5831','5834','6167','6788','6789','8236','10644','11921','12037','12123','12676','12678','17345','17347','17348','17349','17350','17522','17523','17525','17527','17530','17661','17673','17683','20797','5928');