Thread: Bot Pet Buffs
View Single Post
  #5  
Old 08-31-2015, 02:17 AM
Midgett
Fire Beetle
 
Join Date: May 2009
Location: AL
Posts: 29
Default

Thanks for the response!

I have all those fields in my table. Here is a SQL generated by HeidiSQL of my botpetbuffs.

Code:
CREATE TABLE `botpetbuffs` (
	`BotPetBuffId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`BotPetsId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`SpellId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`CasterLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`Duration` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`BotPetBuffId`),
	INDEX `FK_botpetbuffs_1` (`BotPetsId`),
	CONSTRAINT `FK_botpetbuffs_1` FOREIGN KEY (`BotPetsId`) REFERENCES `botpets` (`BotPetsId`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
I did encounter a red error on the GM screen when I first added the bot tables but I followed the info contained in the following
threads to fix it:

http://www.eqemulator.org/forums/sho...light=dot_rune

http://www.eqemulator.org/forums/sho...light=dot_rune

I did have more fields missing than what was mentioned in these threads. I was missing: dot_rune, caston_x, caston_y, caston_z and ExtraDIChance.
After I added them, the red error went away.

My botbuffs table populates. My bots keep their buffs when zoning. They also keep their pets. Their pets don't keep their buffs. For some reason, the
botpetbuffs table won't populate.

Does your botpetbuffs table populate when you camp your bots? It feels like it may be server side??
Reply With Quote