| spider661 |
09-08-2008 09:17 AM |
sorry its groups in 1129
please delete my other topic i needed to change the name becuase i messed up.
anyways.
im getting a problem with groups disbanding all together when a player zones it took me awhile to see the problem.. om my gm i grouped up.. zoned out and was still in group but then when i zoned back in my group was gone. it cleared on both chars #refreshgroup did nothing
i put these dbs in
Code:
Required SQL:
CREATE TABLE `blocked_spells` (
`id` int(11) NOT NULL auto_increment,
`spellid` mediumint(8) unsigned NOT NULL default '0',
`type` tinyint(4) NOT NULL default '0',
`zoneid` int(4) NOT NULL default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`x_diff` float NOT NULL default '0',
`y_diff` float NOT NULL default '0',
`z_diff` float NOT NULL default '0',
`message` varchar(255) NOT NULL default 'You cannot cast that spell here',
`description` varchar(255) default NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `group_id` (
`groupid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`groupid`, `charid`)
)
ENGINE = InnoDB;
UPDATE npc_spells_entries SET type='512' WHERE spellid='48';
UPDATE npc_spells_entries SET type='512' WHERE spellid='49';
UPDATE npc_spells_entries SET type='512' WHERE spellid='1526';
UPDATE npc_spells_entries SET type='512' WHERE spellid='1697';
CREATE TABLE `group_leaders` (
`gid` int(4) NOT NULL,
`leadername` varchar(64) NOT NULL,
PRIMARY KEY (`gid`)
)
ENGINE = InnoDB;
patch_6.2.conf and patch_Titanium.conf files have changed be sure to update them.
|