14-12-2009, 05:28 PM
|
#1 (permalink)
|
|
Membro - General
Registrado em: Sep 2009
Localização: Porto Alegre RS
Posts: 217
Agradecido 86 Vezes em 51 Posts
Achei Ruim:
Acharam ruim Vezes em Posts
Meu Estado:
Nome Real: Bruno Luis Russo Veronezi
|
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
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
|
|
|