| Brunolan |
14-12-2009 05:28 PM |
Sql
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:
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 |
