View Single Post
  #1  
Old 09-19-2015, 09:59 AM
Trackye
Sarnak
 
Join Date: Feb 2008
Posts: 87
Default 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?
Reply With Quote