Thread: RoF2 Bot Spells
View Single Post
  #13  
Old 07-09-2019, 07:22 PM
phantomghost
Hill Giant
 
Join Date: May 2015
Posts: 126
Default

I liked when the enchanter bots mezzed without the command, I actually saw Criimson's original bot enchanter changes on these forums when I tried to see if I could re-implement that back on my server. (Unsuccessfully of course since 99% of the changes I do on the server code is just me making adjustments and hoping they work before I revert back)

I thought not too long ago I saw a post from Uleat discussing the reason for the change but have not been able to find that recently.

I do look forward to any updates for bots, since I make my personal servers primarily around the bots. I appreciate all the work everyone has contributed in getting the bots to where they are at now.


Probably not much help, but my most recent server I have been working on, I added a column to the bot_spell_entries pages called: Spell_Name

Then ran this query:

Code:
update bot_spells_entries set Spell_Name=(select name from spells_new where id=spellid )
So, it puts the spell name from spells_new associated with the ID on my bot_spell_entries table, then I sort it by npc_spell_id (A-Z), type (A-Z), and minlevel (A-Z) to make working through the entries a bit faster. Primarily used this to adjust the bot spells from the current level of spells to match spells from PoP or before and old levels (1,4,8,12 etc for int casters).

Makes it a bit easier than looking up all of the spell id's that are already in the table (for me at least).


Regarding Engulfing Darkness, Engulfing Darkness was ID 178 (spell id 355) for me, on my unmodified bot_spell_entries and my modified version. 13320 in spells_new has all classes as 255 but is also named Engulfing Darkness:

Bot_spell_entries (this is from my modified database--- so it reflects old spell levels, not new):
"178" "3011" "355" "128" "12" "28" "-1" "-1" "1" \N "0" "0" "Engulfing Darkness"

Unmodified bot_spell_entires (other than adding the Spell_Name column):
"178" "3011" "355" "128" "11" "26" "-1" "-1" "1" \N "0" "0" "Engulfing Darkness"



Spells_New (unmodified database--- bolded/red the class levels):
"13320" "Engulfing Darkness" "PLAYER_1" "" "" "" "You are engulfed by darkness." " is engulfed by darkness." "The darkness fades." "200" "0" "0" "0" "2000" "1500" "4000" "7" "10" "0" "0" "-550" "-40" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2503" "2119" "-1" "-1" "-1" "-1" "1" "1" "1" "1" "-1" "-1" "-1" "-1" "100" "100" "100" "100" "100" "100" "100" "100" "100" "100" "100" "100" "0" "0" "0" "1" "0" "3" "254" "254" "254" "254" "254" "254" "254" "254" "254" "254" "5" "25" "14" "-1" "0" "0" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "255" "44" "13" "0" "22" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "100" "0" "160" "2" "0" "-350" "0" "0" "0" "1" "0" "0" "0" "13320" "0" "0" "0" "0" "-1" "-1" "0" "100" "-350" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "-350" "100" "-350" "7" "7" "4" "0" "0" "0" "0" "2" "6" "0" "60" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "1" "0" "-1" "0" "0" "0" "1" "0" "0" "1" "1" "1" "0" "-1" "0" "0" "0" "3" "19" "-1" "0" "1" "0" "0" "1" "0" "1" "0" "0" "0" "0" "0" "0"


"355" "Engulfing Darkness" "PLAYER_1" "" "" "" "You are engulfed by darkness." " is engulfed by darkness." "The darkness fades." "200" "0" "0" "0" "2000" "1500" "4000" "7" "10" "0" "60" "-11" "-30" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "11" "40" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2503" "2119" "-1" "-1" "-1" "-1" "1" "1" "1" "1" "-1" "-1" "-1" "-1" "100" "102" "100" "100" "100" "100" "100" "100" "100" "100" "100" "100" "0" "0" "0" "1" "0" "3" "254" "254" "254" "254" "254" "254" "254" "254" "254" "254" "5" "25" "14" "-1" "0" "0" "255" "255" "255" "255" "20" "255" "255" "255" "255" "255" "11" "255" "255" "255" "255" "255" "44" "13" "0" "22" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "100" "0" "160" "2" "0" "0" "0" "1" "0" "1" "0" "0" "0" "355" "20" "89" "0" "0" "-1" "-1" "0" "100" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "5" "101" "16" "7" "7" "4" "0" "0" "0" "0" "2" "6" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "0" "0" "-1" "0" "0" "0" "1" "0" "0" "1" "1" "1" "0" "-1" "0" "0" "0" "3" "19" "-1" "0" "1" "0" "0" "1" "0" "1" "0" "0" "0" "0" "0" "0"
Reply With Quote