Attacker Level
Defender Tier
Weather
Failed to prepare statement:
SELECT
CONCAT(
' ',
attacking_type, ' '
) Type,
CONCAT(
LPAD(ROUND(ROUND(
EXP(SUM(LOG(COALESCE(factor,
1)))),
4
) * 100, 2), 6, '000'),
'%'
) Effectiveness
FROM
`type_effectiveness`
WHERE
defending_type IN(
SELECT TYPE
FROM
type_assignment
WHERE
species_id = 121
AND form_id = (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00)
)
GROUP BY TYPE
ORDER BY
LPAD(ROUND( EXP(SUM(LOG(COALESCE(factor, 1)))), 4 ),4, '0') DESC,
attacking_type
Failed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,15.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESCFailed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,20.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESCFailed to prepare statement:
select ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1) as IV, CONCAT(ROUND(((attack.iv + defense.iv + stamina.iv) * 100 / 45),1), ' %') as `IV %`, MIN(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))) `Min CP`, CONCAT(MAX(cp_with_iv_calculation(121,attack.iv, defense.iv, stamina.iv,25.0, (SELECT combat_form_id FROM effective_species WHERE id = 121 AND form_id = 00))),' ') `Max CP` FROM
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) attack,
(SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) defense,
( SELECT 10 iv UNION SELECT 11 iv UNION SELECT 12 iv UNION SELECT 13 iv UNION SELECT 14 iv UNION SELECT 15 iv) stamina
GROUP BY IV
ORDER BY IV DESC
Species Stats |
---|
data |
Starmie L40:
2215 - 2584 ATK: 210 DEF: 184 STM: 155 |
Basic PvE Moves | |||||
---|---|---|---|---|---|
Name | Power | Seconds | PPS | Energy | EPS |
Quick Attack | 8 | 0.80 | 10.00 | 10 | 12.50 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Tackle | 5 | 0.50 | 10.00 | 5 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Water Gun | 5 | 0.50 | 10.00 | 5 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Hidden Power | 15 | 1.50 | 10.00 | 15 | 10.00 |
Basic PvP Moves | |||||
---|---|---|---|---|---|
Name | Power | Seconds | PPS | Energy | EPS |
Water Gun | 3 | 0.50 | 6.00 | 3 | 6.00 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Hidden Power | 9 | 1.50 | 6.00 | 8 | 5.33 |
Tackle | 3 | 0.50 | 6.00 | 2 | 4.00 |
Quick Attack | 5 | 1.00 | 5.00 | 7 | 7.00 |
Charged PvE Moves | |||||
---|---|---|---|---|---|
Name | Power | Seconds | PPS | Energy | PPE |
Thunder | 100 | 2.40 | 41.67 | 100 | 1.00 |
Hydro Pump | 130 | 3.30 | 39.39 | 100 | 1.30 |
Psychic | 90 | 2.80 | 32.14 | 50 | 1.80 |
Power Gem | 80 | 2.90 | 27.59 | 50 | 1.60 |
Ice Beam | 90 | 3.30 | 27.27 | 50 | 1.80 |
Psybeam | 70 | 3.20 | 21.88 | 50 | 1.40 |
Charged PvP Moves | |||
---|---|---|---|
Name | Power | Energy | PPE |
Hydro Pump | 130 | 75 | 1.73 |
Thunder | 100 | 60 | 1.67 |
Psychic | 90 | 55 | 1.64 |
Ice Beam | 90 | 55 | 1.64 |
Power Gem | 80 | 60 | 1.33 |
Psybeam | 70 | 60 | 1.17 |