[Request]Spirit healers - NCDB Rev657

[Randompolygamy]

Ne one got a fix for the spirit healers giving a "how may i help u text" from lack of it being scripted in Rev657? would be greatly appreciated.

Thanks-
Random Out

[MentaL]

[Matt-One]

Ne one got a fix for the spirit healers giving a "how may i help u text" from lack of it being scripted in Rev657? would be greatly appreciated.

Thanks-
Random Out

try my fix http://forum.ragezone.com/f114/ascen...ev2383-327987/

[Randompolygamy]

hm... tryed it and it did not work, i get a few errors on the 2368_world_worldmap_info.sql update

Error occured at:2007-11-07 05:37:49
Line no.:1
Error Code: 1146 - Table 'world.playerpets' doesn't exist

Query:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`

Error occured at:2007-11-07 22:28:36
Line no.:1
Error Code: 1060 - Duplicate column name 'ReqCastSpellId1'

Query:
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`

Error occured at:2007-11-07 22:29:06
Line no.:2
Error Code: 1060 - Duplicate column name 'heroic_keyid_1'

Query:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`

Error occured at:2007-11-07 22:41:06
Line no.:1
Error Code: 1060 - Duplicate column name 'ReqCastSpellId1'

Query:
alter table accounts add column forceLanguage varchar(5) not null default "enUS"

Error occured at:2007-11-07 22:41:39
Line no.:1
Error Code: 1060 - Duplicate column name 'forceLanguage'

Query:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid

Error occured at:2007-11-07 22:42:39
Line no.:1
Error Code: 1060 - Duplicate column name 'external_attached_item_guid'

Query:
CREATE TABLE `playeritems_external` (
 `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
 `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
 `entry` int(10) unsigned NOT NULL DEFAULT '0',
 `creator` int(10) unsigned NOT NULL DEFAULT '0',
 `count` int(10) unsigned NOT NULL DEFAULT '0',
 `charges` int(10) unsigned NOT NULL DEFAULT '0',
 `flags` int(10) unsigned NOT NULL DEFAULT '0',
 `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
 `randomsuffix` int(30) NOT NULL,
 `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
 `durability` int(10) unsigned NOT NULL DEFAULT '0',
 `containerslot` int(11) DEFAULT '-1' COMMENT '',
 `slot` tinyint(4) NOT NULL DEFAULT '0',
 `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`guid`),
 UNIQUE KEY `guid` (`guid`),
 KEY `ownerguid` (`ownerguid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2007-11-07 22:43:09
Line no.:19
Error Code: 1050 - Table 'playeritems_external' already exists

Query:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`

Error occured at:2007-11-17 11:19:37
Line no.:1
Error Code: 1146 - Table 'character.creatureloot' doesn't exist

Query:
alter table worldmap_info add column viewingDistance float(0) not null default 80.0

Error occured at:2007-11-17 11:19:43
Line no.:1
Error Code: 1146 - Table 'character.worldmap_info' doesn't exist

Query:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid

Error occured at:2007-11-17 11:20:11
Line no.:1
Error Code: 1060 - Duplicate column name 'external_attached_item_guid'

Query:
CREATE TABLE `playeritems_external` (
  `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
  `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `entry` int(10) unsigned NOT NULL DEFAULT '0',
  `creator` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `charges` int(10) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
  `randomsuffix` int(30) NOT NULL,
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) DEFAULT '-1' COMMENT '',
  `slot` tinyint(4) NOT NULL DEFAULT '0',
  `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`guid`),
  UNIQUE KEY `guid` (`guid`),
  KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2007-11-17 11:20:15
Line no.:19
Error Code: 1050 - Table 'playeritems_external' already exists

Query:
CREATE TABLE `server_settings` (
  `setting_id` varchar(200) NOT NULL,
  `setting_value` int(50) NOT NULL,
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-17 11:20:21
Line no.:5
Error Code: 1050 - Table 'server_settings' already exists

Query:
/* -- Project Re-name --
In this project We've decided to start rename column names, and make them more understand able.
*/
ALTER TABLE `ai_agents` CHANGE `entryId` `entry` INT(11) UNSIGNED NOT NULL DEFAULT '0'

Error occured at:2007-11-20 07:24:56
Line no.:6
Error Code: 1054 - Unknown column 'entryId' in 'ai_agents'

Query:
alter table guild_ranks add column rankRights_1 int(30) not null default 0

Error occured at:2007-11-20 07:25:06
Line no.:1
Error Code: 1146 - Table 'world.guild_ranks' doesn't exist

Query:
CREATE TABLE `banned_phrases` (
  `phrase` varchar(250) NOT NULL,
  PRIMARY KEY  (`phrase`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-20 07:38:00
Line no.:4
Error Code: 1050 - Table 'banned_phrases' already exists

Query:
alter table worldmap_info add column required_checkpoint int(30) not null default 0

Error occured at:2007-11-20 07:38:10
Line no.:1
Error Code: 1060 - Duplicate column name 'required_checkpoint'

Query:
alter table worldmap_info add column required_checkpoint int(30) not null default 0

Error occured at:2007-11-20 07:39:13
Line no.:1
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
alter table worldmap_info add column required_checkpoint int(30) not null default 0

Error occured at:2007-11-20 07:40:40
Line no.:1
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

and now i accidently deleted my worldmap_info table Ooops...

but yeah i cant recover from that sql file.. it errors out :/

[Randompolygamy]

Oh and btw.. why don't these sql dumps meet the structure requirements ?

Error Code: 1146 - Table 'world.playerpets' doesn't exist

it doesn't exist cuz its a Character db table.


Btw Paco since i see you just got on.. you didn't happen to script it in your repack on qsave did you??

[Matt-One]

Oh and btw.. why don't these sql dumps meet the structure requirements ?

Error Code: 1146 - Table 'world.playerpets' doesn't exist

it doesn't exist cuz its a Character db table.


Btw Paco since i see you just got on.. you didn't happen to script it in your repack on qsave did you??

LOL have u download the NDCB 651 from this site and Updated to 657 with Changeset_65x.sql version in my package? THEN u have to execute in the world DB the other 3 .sql ...try with a NEW install of the world DB...

P.S.
Its impossible to have all that errors with the update of 2368_world_worldmap_info.sql if u have done as i have told u...

[Randompolygamy]

Yeah u got me there.. oh well... i gotta do a fresh install ne ways now.. and i really don't feel like getting into your code and tearing it apart right now.. due to lack of structure knowledge and a few flags missing

oh well..
Thanks ne ways..

[Matt-One]

Yeah u got me there.. oh well... i gotta do a fresh install ne ways now.. and i really don't feel like getting into your code and tearing it apart right now.. due to lack of structure knowledge and a few flags missing

oh well..
Thanks ne ways..

bh

[Randompolygamy]

Ok so figure out the weapon master id's and publish your fixed fix :P