Couple of questions about Database and other.
So I have been reading through these forums mostly here and the Quest:Q:A section.
I am attempting to make it so that most things on my server are doable with a group of players and bots not requiring a raid. Maybe 2 groups at the most.
I have an idea how to do this using a SQL for Npc_Types that lowers values such as Update Npc_Types set hp = (hp * 0.25) where (XXXXXX); or something and then going from there with the rest of the values hp regen and such.
The question I have is how do XXXXXX in my made up query above.
Is there a reliable way to select only a creature regarded as a boss?
It doesnt seem that using Level is a good indicator as alot of the trash at POP levels are higher level than bosses from say Velious.
Its possible that I could use HP itself as an indicator i suppose...
something like
Update npc_types set ac = (ac * 0.6) where hp > 30000;
Update npc_types set mindmg = (mindmg * 0.5) where hp >30000;
Update npc_types set maxdmg = (maxdmg * 0.5) where hp >30000;
Update npc_types set hp_regen_rate = (hp_regen_rate * 0.3) where hp >30000;
Update npc_types set hp = (hp * 0.7) where hp > 30000 and hp < 60000;
Update npc_types set hp = (hp * 0.4) where hp > 60000 and hp < 90000;
Update npc_types set hp = (hp * 0.2) where hp > 90000;
****DISCLAIMER**** I am aware the above code would probably not run I literally only wrote it to show what I had in mind.
What would be a good way to ensure my code only gets ran on creatures that are raid or boss targets...
Also another question.
I create an NPC using the #spawn command.
If i do not enter anything for Priweapon or Secweapon i cannot seem to use #npcedit do change that after.
using #wc 7 1 for instance only makes them hold it til restart or repop.
Is there a command im missing that can do this or is database editing the only option then?
|
Threaded Mode
