EQoffline, bots and more..

#1 04-21-2008, 09:01 AM

awesome one question are you going to release the diffs so people can stay up to date on their own as well?

cubber · #2 04-21-2008, 06:14 PM

I am trying to update my peq database to 1106 from CVS, the system loaded in fine. But when I go to reload my bots with the bot_npcs.sql script generated by bot_npcs.sh i get the following error:

ERROR 1136 (21S01) at line 25: Column count doesn't match value count at row 1

any ideas how to fix this or do I need to start all my bots from scratch again?

**cavedude** · #3 04-21-2008, 06:27 PM

Add two 0s at the end of the queries in the file. Two new columns were added to npc_types.

kraulek · #4 04-21-2008, 06:28 PM

Here is a newly updated Shaman spell set. I ran queries for at least 40-70 to make sure that there was only ever 15 spells trying to load, including the best heal.

As an example, here's the 70 loadout. type 8 is buff, 2 is heal, 1 is slow or debuff, 256 is a dot, and 32 is the pet. I had to sacrifice DD (I have a mage for that) but am otherwise pretty happy with the loadout.

Code:

ID:	Name:				Type:
172	Swift Like the Wind		8
278	Spirit of Wolf			8
1588	Turgur's Insects		1
3378	Agility of the Wrulan		8
3380	Cloud of Grummus		1
3386	Malicious Decay			1
3394	Breath of Ultor			256
3395	Malos				1
3396	Blood of Saryrn			256
5389	Farrel's Companion		32
5395	Yoppa's Mending			2
5406	Talisman of Perseverance	8
5415	Talisman of Wunshi		8
5417	Champion			8
6667	Spirit of the Panther		8

SQL code for type 518:

Code:

--
-- Dumping data for table `npc_spells_entries`
--
-- WHERE:  npc_spells_id=518

LOCK TABLES `npc_spells_entries` WRITE;
/*!40000 ALTER TABLE `npc_spells_entries` DISABLE KEYS */;
INSERT INTO `npc_spells_entries` (`id`, `npc_spells_id`, `spellid`, `type`, `minlevel`, `maxlevel`, `manacost`, `recast_delay`, `priority`) VALUES (2662,518,12,2,19,28,-1,-1,1),(2663,518,15,2,29,48,-1,-1,1),(2661,518,17,2,9,18,-1,-1,1),(2647,518,39,8,29,43,-1,-1,90),(2621,518,40,8,1,18,-1,-1,1),(2549,518,75,256,5,18,-1,-1,1),(2530,518,93,1,1,9,-1,-1,1),(2562,518,110,1,19,33,-1,-1,1),(2563,518,111,1,34,48,-1,-1,1),(2666,518,144,2,24,38,-1,-1,1),(2667,518,145,8,39,51,-1,-1,1),(2635,518,146,8,24,28,-1,-1,1),(2622,518,147,8,19,28,-1,-1,1),(2629,518,148,8,19,33,-1,-1,1),(2642,518,149,8,24,33,-1,-1,1),(2623,518,151,8,29,38,-1,-1,1),(2637,518,152,8,39,48,-1,-1,1),(2624,518,153,8,39,48,-1,-1,1),(2644,518,158,8,44,53,-1,-1,1),(2630,518,160,8,34,43,-1,-1,1),(2643,518,161,8,34,43,-1,-1,1),(2576,518,162,1,29,43,-1,-1,1),(2577,518,163,1,44,52,-1,-1,2),(2669,518,164,32,34,38,-1,-1,1),(2671,518,165,32,41,44,-1,-1,1),(2672,518,166,32,49,54,-1,-1,1),(2614,518,167,8,34,9,-1,-1,1),(2615,518,168,8,44,9,-1,-1,1),(2648,518,170,8,44,55,-1,-1,1),(2649,518,171,8,56,62,-1,-1,1),(2650,518,172,8,63,255,-1,-1,1),(2660,518,200,2,1,8,-1,-1,1),(2588,518,201,1,1,38,-1,200,1),(2612,518,225,8,1,23,-1,-1,1),(2610,518,226,8,9,33,-1,-1,1),(2604,518,227,8,14,38,-1,-1,1),(2606,518,228,8,19,43,-1,-1,1),(2590,518,230,4,14,33,-1,-1,1),(2634,518,266,8,1,23,-1,-1,1),(2596,518,267,8,1,4,-1,-1,1),(2628,518,269,8,5,18,-1,-1,1),(2569,518,270,1,5,13,-1,-1,1),(2651,518,271,8,5,13,-1,-1,1),(2597,518,274,8,5,13,-1,-1,1),(2531,518,275,1,5,13,-1,-1,1),(2555,518,277,256,9,23,-1,-1,1),(2659,518,278,8,9,255,-1,-1,1),(2641,518,279,8,9,23,-1,-1,1),(2652,518,280,8,14,18,-1,-1,1),(2575,518,281,1,14,28,-1,-1,1),(2532,518,282,1,14,23,-1,-1,1),(2598,518,283,8,14,23,-1,-1,1),(2653,518,308,8,19,33,-1,-1,1),(2654,518,326,8,34,48,-1,-1,1),(2655,518,337,8,49,58,-1,-1,1),(2636,518,349,8,29,38,-1,-1,1),(2551,518,365,256,19,33,-1,-1,1),(2600,518,431,8,34,43,-1,-1,1),(2556,518,434,256,24,38,-1,-1,1),(2557,518,435,256,39,48,-1,-1,1),(2558,518,436,256,49,55,-1,-1,1),(2538,518,437,1,24,33,-1,-1,1),(2540,518,438,1,39,43,-1,-1,1),(2570,518,505,1,14,28,-1,-1,1),(2571,518,506,1,29,38,-1,-1,1),(2572,518,507,1,39,50,-1,-1,1),(2533,518,508,1,24,33,-1,-1,1),(2534,518,509,1,34,43,-1,-1,1),(2550,518,511,256,19,33,-1,-1,1),(2608,518,524,8,5,28,-1,-1,1),(2579,518,526,1,19,38,-1,-1,1),(2599,518,649,8,24,33,-1,-1,1),(3290,518,1290,2,55,61,-1,-1,1),(2539,518,1427,1,34,43,-1,-1,1),(2541,518,1429,1,44,48,-1,-1,1),(2618,518,1432,8,60,61,-1,-1,1),(2668,518,1568,8,52,60,-1,-1,1),(2673,518,1574,32,55,60,-1,-1,1),(2565,518,1577,1,57,59,-1,-1,2),(2566,518,1578,1,60,62,-1,-1,2),(2632,518,1579,8,53,61,-1,-1,1),(2573,518,1588,1,51,255,-1,-1,1),(2559,518,1590,1,56,59,-1,-1,2),(2553,518,1591,1,59,63,-1,-1,2),(2657,518,1598,8,60,64,-1,-1,1),(2656,518,1599,8,59,59,-1,-1,1),(2560,518,2113,256,60,64,-1,-1,1),(2617,518,2525,8,46,48,-1,-1,1),(2665,518,3233,2,62,67,-1,-1,1),(2619,518,3235,8,62,64,-1,-1,1),(2674,518,3377,32,61,66,-1,-1,1),(2633,518,3378,8,62,255,-1,-1,1),(2587,518,3380,1,61,255,-1,-1,2),(2582,518,3386,1,63,255,-1,-1,2),(2567,518,3387,1,63,64,-1,-1,2),(2554,518,3394,256,64,255,-1,-1,1),(2568,518,3395,1,65,255,-1,-1,2),(2561,518,3396,256,65,255,-1,-1,1),(2620,518,3397,8,65,69,-1,-1,1),(2658,518,3399,8,65,69,-1,-1,1),(3293,518,3433,8,61,68,-1,-1,1),(3292,518,3454,8,49,59,-1,-1,1),(2542,518,3573,1,49,53,-1,-1,2),(3299,518,5389,32,67,255,-1,-1,1),(3300,518,5395,2,68,255,-1,-1,1),(3294,518,5406,8,69,255,-1,-1,0),(3301,518,5415,8,70,255,-1,-1,1),(3298,518,5417,8,70,255,-1,-1,0),(3297,518,6667,8,69,255,-1,-1,0),(3289,518,6877,2,49,54,-1,-1,1),(3295,518,6906,8,50,56,-1,-1,0),(3296,518,6907,8,57,68,-1,-1,0);

cubber · #5 04-21-2008, 09:37 PM

After adding the 0's I was able to source my bots back in, thanks. However I ran into one other issue. I compiled the new bot source but when I log into the world and to a #bot spawn or pretty much any #bot command I get the following:

Command 'bot' not recognized.

The 1102 sources worked fine for me. Am I missing something with the new 1106 sources? Before with the 1102 I just needed to compile the zone binary, and move that over to my server folder. I have tried just the 1106 zone file, and I also tried compiling and using the included world and EMUSharemem with the same results. This is on linux.

Thanks

cubber · #6 04-21-2008, 09:44 PM

Never mind I think I figured out my issue, I forgot to edit the bot stuff into the makefiles.

**Congdar** · #7 04-22-2008, 09:24 AM

Quote:

Originally Posted by mburnett

awesome one question are you going to release the diffs so people can stay up to date on their own as well?

I'm not sure how to do that. I use DiffZilla to merge the bot changes with the latest source. Seems to work fine.

kraulek · #8 04-22-2008, 12:20 PM

One thing i have noticed with pet classes (at least Mages and Shaman) are that they tend to waste 2 slots on the same pet summon. I have not found a way to fix that in the database, so I'm guessing it's a bug in some code somewhere? I had thought it was just the shaman but I looked closer at the mage #bot debug spell list and saw that she had loaded an Earth, Fire, Wind, and Water pet ... and a 2nd Fire one.

**Congdar** · #9 04-22-2008, 02:13 PM

Spell lists for the caster bots are next on my list of things to work on. The current spell selections are for NPC's and the bots just kinda hijacked the entires. There has been some discussion on this, so the spell lists I come up with will use thier own database entries instead of the ones created for the NPC's. I have the Cleric done and I'll move down the list from there.

Jason1983 · #10 04-24-2008, 04:12 PM

Is there a way to cut off the social they are under attack or something? I am putting bots together at times that spam very fastly this social.

**Congdar** · #11 04-24-2008, 11:23 PM

I've seen the repeating text issue. This is because you've told your bots to attack and they don't have line-of-site with the target. Try #bot summon and if you have line of site, then they will too. I think this is what you are asking about, no?

Aramid · #12 04-24-2008, 11:41 PM

Any idea why the casters are always being interrupted? Sorry, I can't give any detailed info at this time, but I was just running thru innovation reeking havoc and even when they were told to guard, the casters are constantly having spells interrupted.

Jason1983 · #13 04-25-2008, 01:07 AM

Yes that is it. Actually for some strange reason they just start running that script for no reason. Not even attacking anything. Enchanters seem to be the worse.

**Congdar** · #14 04-25-2008, 10:15 AM

Quote:

Originally Posted by Aramid

Any idea why the casters are always being interrupted? Sorry, I can't give any detailed info at this time, but I was just running thru innovation reeking havoc and even when they were told to guard, the casters are constantly having spells interrupted.

My Ranger does this. Mage, Wiz, Cleric, Necro, Druid, Shaman, Paladin, Shadowknight, Enchanter i've tried and don't. I'll look and see if there is some ranger specific bot code somewhere. Do you have other casters do this?

Quote:

Originally Posted by Jason1983

Yes that is it. Actually for some strange reason they just start running that script for no reason. Not even attacking anything. Enchanters seem to be the worse.

Might be a different script? This would only happen if somebody has aggro and theres a line-of-site issue. If you have HTT installed you could cycle through your bots and see who has aggro. Summoning them has always fixed it for me.