Advertisement
Rochet2

Invalid stats on items

Jan 25th, 2015
350
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.72 KB | None | 0 0
  1. SELECT * FROM item_template WHERE statscount < 0
  2. UNION
  3. SELECT * FROM item_template WHERE stat_value1 <> 0 AND (statscount < 1)
  4. UNION
  5. SELECT * FROM item_template WHERE stat_value2 <> 0 AND (statscount < 2 OR stat_value1 = 0)
  6. UNION
  7. SELECT * FROM item_template WHERE stat_value3 <> 0 AND (statscount < 3 OR stat_value1 = 0 OR stat_value2 = 0)
  8. UNION
  9. SELECT * FROM item_template WHERE stat_value4 <> 0 AND (statscount < 4 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0)
  10. UNION
  11. SELECT * FROM item_template WHERE stat_value5 <> 0 AND (statscount < 5 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0)
  12. UNION
  13. SELECT * FROM item_template WHERE stat_value6 <> 0 AND (statscount < 6 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0)
  14. UNION
  15. SELECT * FROM item_template WHERE stat_value7 <> 0 AND (statscount < 7 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0)
  16. UNION
  17. SELECT * FROM item_template WHERE stat_value8 <> 0 AND (statscount < 8 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0)
  18. UNION
  19. SELECT * FROM item_template WHERE stat_value9 <> 0 AND (statscount < 9 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0 OR stat_value8 = 0)
  20. UNION
  21. SELECT * FROM item_template WHERE stat_value10 <> 0 AND (statscount < 10 OR stat_value1 = 0 OR stat_value2 = 0 OR stat_value3 = 0 OR stat_value4 = 0 OR stat_value5 = 0 OR stat_value6 = 0 OR stat_value7 = 0 OR stat_value8 = 0 OR stat_value9 = 0)
  22. UNION
  23. SELECT * FROM item_template WHERE statscount > 10
  24. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement