Bot pets give exp

[caylah023]

Found this out earlier tonight on my server and it appears to be kind of an underground bug atm.

Bot casters when they summon a pet can get rid of that pet with the cmd
#bot pet remove

when done and the pet is targeted this gets rid of the pet....it also gives the player experience that is at least substantial.

i got rid of this by removing pet summoning spells from my bot lineups but i would really like to see an actual fix for this. if anyone knows of a way to fix please let me know :)

[cavedude]

Moving this to bots forum.

[Congdar]

I'll take a look at this later today... shouldn't be too hard to fix.

[caylah023]

kewl beans. sorry if i posted it in the wrong spot but as i use bots with my public server figured bug reports was a good spot :p

thanks in advance for anything you can do with this.

[Congdar]

fixed in Rev533

[caylah023]

ok awesome. but my question now is this. i dont tend to update the db for ax's db since the few times i do it overwrites my customized spawns and stuff for zones as well as items db and a few other special things

how do i upgrade these databases without killing the customized stuff ive got put in?

[Congdar]

The way I keep from losing my custom stuff is to create an Updates.sql file with every change that I have made to the database. I haven't used the AX database, but the PEQ database has the bots_npcs.bat file to save the bots and the drop_system.sql file that cleans everything out except users stuff like character tables. Then there's the update sql file that puts in all the new stuff. Then I just source Updates.sql and source bot_npcs.sql and I'm back where I left off + the db updates.

[caylah023]

hmm ok i will have to talk to ax about this figure out the best way to do this

thanks a lot :)

[Nagus69]

The way I keep from losing my custom stuff is to create an Updates.sql file with every change that I have made to the database. I haven't used the AX database, but the PEQ database has the bots_npcs.bat file to save the bots and the drop_system.sql file that cleans everything out except users stuff like character tables. Then there's the update sql file that puts in all the new stuff. Then I just source Updates.sql and source bot_npcs.sql and I'm back where I left off + the db updates.

That sounds intersting - however im a total noob when it comes to SQL. Care to explain how that works in detail? How do your custom changes to into the custom.sql file? Is there a trick that i am missing?

Greatly appreciate any help!

[Congdar]

no trick, it's not for noobs. it's manually adding the sql code to the updates.sql file by hand. you will need to know sql commands. if you add a custom npc to the npc_types table, you will need to know the sql command to do that. If you use a tool that adds npc's, I think GeorgeS is adding some way to export the command used for his tool and then you would copy that command to your updates.sql file.