yvoms
Exalted Member
hmm, so i thought i was smart and tried making an Sql query like
However it does not insert it, any idea on what i've done wrong here?
/* Affected rows: 0 Gevonden rijen: 0 Waarschuwingen: 0 Duur van 1 query: 0,016 sec. */
Code:
INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`)
select 1, l.level, 8121 * pow(1.05, l.level - 81), 0
from player_classlevelstats l
where l.level >= 81 and l.level <= 255
However it does not insert it, any idea on what i've done wrong here?
/* Affected rows: 0 Gevonden rijen: 0 Waarschuwingen: 0 Duur van 1 query: 0,016 sec. */