Advertisement
Guest User

fix for query

a guest
Jan 30th, 2015
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.28 KB | None | 0 0
  1. if($_POST['entry'] == ""){
  2. if($_POST['minlevel'] >= "81") {
  3. $sql = "INSERT INTO creature_template (entry, name, modelid1, subname, IconName, minlevel, maxlevel, faction, npcflag, rank, BaseAttackTime, RangeAttackTime, unit_class, lootid, HealthModifier, ManaModifier, ArmorModifier, mechanic_immune_mask)
  4. SELECT DISTINCT max(entry)+1, '$name', '$display', '$subname', '$iconname', '$minlvl', '$maxlvl', '$faction', '$npcflag', '$rank', '$attackdelay', '$attackdelay', '$unitclass', max(entry)+1, '$health', '$mana', '$armor', '$immunemask' FROM creature_template";
  5. }else{
  6. $sql = "INSERT INTO creature_template (entry, name, modelid1, subname, IconName, minlevel, maxlevel, faction, npcflag, rank, BaseAttackTime, RangeAttackTime, unit_class, lootid, HealthModifier, ManaModifier, ArmorModifier, mechanic_immune_mask)
  7. SELECT DISTINCT max(entry)+1, '$name', '$display', '$subname', '$iconname', '$minlvl', '$maxlvl', '$faction', '$npcflag', '$rank', '$attackdelay', '$attackdelay', '$unitclass', max(entry)+1, ($health/(SELECT basehp0 FROM creature_classlevelstats WHERE level = ROUND(($minlvl+$maxlvl)/2, 0) AND class = $unitclass)), '$mana', '$armor', '$immunemask' FROM creature_template";
  8. }}else{
  9. if($_POST['minlevel'] >= "81") {
  10. $sql = "INSERT INTO creature_template (entry, name, modelid1, subname, IconName, minlevel, maxlevel, faction, npcflag, rank, BaseAttackTime, RangeAttackTime, unit_class, lootid, HealthModifier, ManaModifier, ArmorModifier, mechanic_immune_mask)
  11. VALUES ('$entry', '$name', '$display', '$subname', '$iconname', '$minlvl', '$maxlvl', '$faction', '$npcflag', '$rank', '$attackdelay', '$attackdelay', '$unitclass', '$entry', '$health', '$mana', '$armor', '$immunemask')";
  12. }else{
  13. $entry = $_POST['entry'];
  14. $sql = "INSERT INTO creature_template (entry, name, modelid1, subname, IconName, minlevel, maxlevel, faction, npcflag, rank, BaseAttackTime, RangeAttackTime, unit_class, lootid, HealthModifier, ManaModifier, ArmorModifier, mechanic_immune_mask)
  15. VALUES ('$entry', '$name', '$display', '$subname', '$iconname', '$minlvl', '$maxlvl', '$faction', '$npcflag', '$rank', '$attackdelay', '$attackdelay', '$unitclass', '$entry', ($health/(SELECT basehp0 FROM creature_classlevelstats WHERE level = ROUND(($minlvl+$maxlvl)/2, 0) AND class = $unitclass)), '$mana', '$armor', '$immunemask')";
  16. }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement