Secret Experience

Brunolan · 14-12-2009, 05:28 PM

Bom pessoal eu to editando uma sql afim de regular o hp mp p.atk etc... dos boss , eu nao entendo muito andei olhando aki uns tutoriais e fui testando pra ver, eu ja consegui chegar a deichar os boss de level 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, com o hp p.atk m.atk etc.. como eu queria... mas detalhe como nao especifica qual type de npc é ele acaba adicionando status de boss ate aos moobs e npcs eu queria q desse pra descrever na sql qual level do npc e type no caso l2raidboss e level 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70,
mas eu nao sei o q tem q fazer nem se isso é possivel ja testei de diversas formas

olha a sql q eu monteu, e me digam como eu faço pra atribuir as caracteristicas dos npcs q eu quero mudar no caso l2raidboss e os level deles

Código: [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

UPDATE npc SET hp='100000' where level='80';
UPDATE npc SET mp='5000' where level='80';
UPDATE npc SET patk='2500' where level='80';
UPDATE npc SET pdef='600' where level='80';
UPDATE npc SET mdef='400' where level='80';
UPDATE npc SET aggro='1' where level='80';
UPDATE npc SET runspd='200' where level='80';
UPDATE npc SET patk='1000' where level='80';
 
UPDATE npc SET hp='100000' where level='79';
UPDATE npc SET mp='5000' where level='79';
UPDATE npc SET patk='2500' where level='79';
UPDATE npc SET pdef='600' where level='79';
UPDATE npc SET mdef='400' where level='79';
UPDATE npc SET aggro='1' where level='79';
UPDATE npc SET runspd='200' where level='79';
UPDATE npc SET patk='1000' where level='79'; 

UPDATE npc SET hp='100000' where level='78';
UPDATE npc SET mp='5000' where level='78';
UPDATE npc SET patk='2500' where level='78';
UPDATE npc SET pdef='600' where level='78';
UPDATE npc SET mdef='400' where level='78';
UPDATE npc SET aggro='1' where level='78';
UPDATE npc SET runspd='200' where level='78';
UPDATE npc SET patk='1000' where level='78'; 

UPDATE npc SET hp='100000' where level='77';
UPDATE npc SET mp='5000' where level='77';
UPDATE npc SET patk='2500' where level='77';
UPDATE npc SET pdef='600' where level='77';
UPDATE npc SET mdef='400' where level='77';
UPDATE npc SET aggro='1' where level='77';
UPDATE npc SET runspd='200' where level='77';
UPDATE npc SET patk='1000' where level='77'; 

UPDATE npc SET hp='100000' where level='76';
UPDATE npc SET mp='5000' where level='76';
UPDATE npc SET patk='2500' where level='76';
UPDATE npc SET pdef='600' where level='76';
UPDATE npc SET mdef='400' where level='76';
UPDATE npc SET aggro='1' where level='76';
UPDATE npc SET runspd='200' where level='76';
UPDATE npc SET patk='1000' where level='76'; 

UPDATE npc SET hp='100000' where level='75';
UPDATE npc SET mp='5000' where level='75';
UPDATE npc SET patk='2500' where level='75';
UPDATE npc SET pdef='600' where level='75';
UPDATE npc SET mdef='400' where level='75';
UPDATE npc SET aggro='1' where level='75';
UPDATE npc SET runspd='200' where level='75';
UPDATE npc SET patk='1000' where level='75'; 

UPDATE npc SET hp='100000' where level='74';
UPDATE npc SET mp='5000' where level='74';
UPDATE npc SET patk='2500' where level='74';
UPDATE npc SET pdef='600' where level='74';
UPDATE npc SET mdef='400' where level='74';
UPDATE npc SET aggro='1' where level='74';
UPDATE npc SET runspd='200' where level='74';
UPDATE npc SET patk='1000' where level='74'; 

UPDATE npc SET hp='100000' where level='73';
UPDATE npc SET mp='5000' where level='73';
UPDATE npc SET patk='2500' where level='73';
UPDATE npc SET pdef='600' where level='73';
UPDATE npc SET mdef='400' where level='73';
UPDATE npc SET aggro='1' where level='73';
UPDATE npc SET runspd='200' where level='73';
UPDATE npc SET patk='1000' where level='73'; 

UPDATE npc SET hp='100000' where level='72';
UPDATE npc SET mp='5000' where level='72';
UPDATE npc SET patk='2500' where level='72';
UPDATE npc SET pdef='600' where level='72';
UPDATE npc SET mdef='400' where level='72';
UPDATE npc SET aggro='1' where level='72';
UPDATE npc SET runspd='200' where level='72';
UPDATE npc SET patk='1000' where level='72';
 
UPDATE npc SET hp='100000' where level='71';
UPDATE npc SET mp='5000' where level='71';
UPDATE npc SET patk='2500' where level='71';
UPDATE npc SET pdef='600' where level='71';
UPDATE npc SET mdef='400' where level='71';
UPDATE npc SET aggro='1' where level='71';
UPDATE npc SET runspd='200' where level='71';
UPDATE npc SET patk='1000' where level='71'; 

UPDATE npc SET hp='100000' where level='70';
UPDATE npc SET mp='5000' where level='70';
UPDATE npc SET patk='2500' where level='70';
UPDATE npc SET pdef='600' where level='70';
UPDATE npc SET mdef='400' where level='70';
UPDATE npc SET aggro='1' where level='70';
UPDATE npc SET runspd='200' where level='70';
UPDATE npc SET patk='1000' where level='70';

POR FAVOR ME AJUDEM QUEM MANJE DISSO MAIS DO Q EU xD...

Feliz natal a todos