| christiand |
21-03-2009 07:36 PM |
e +ou- dessa forma q vc vai por
Código:
-- this sql updates db to make diff intial items.
update char_templates set `items1`= 24 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); -- chest/ bone breast plate
update char_templates set `items2`= 31 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); -- legs/ bone gaiters
update char_templates set `items3`= 219 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); -- sword breaker
update char_templates set `items4`= 44 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter');-- leather helmet
update char_templates set `items5`= 38 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter');-- low boots
update char_templates set `items1`= 430 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); --robe of evotion,
update char_templates set `items2`= 1104 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); -- stocking of devotion
update char_templates set `items3`= 100 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); --vood do dool
update char_templates set `items4`= 49 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); -- gloves
update char_templates set `items5`= 44 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage');-- leather helmet
querendo mudar ou por mais itens é so seguir a logica. |
