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
Printable View
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/Quote:
Originally Posted by Randompolygamy
hm... tryed it and it did not work, i get a few errors on the 2368_world_worldmap_info.sql update
and now i accidently deleted my worldmap_info table Ooops...Code: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
but yeah i cant recover from that sql file.. it errors out :/
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...Quote:
Originally Posted by Randompolygamy
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...
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..
bhQuote:
Originally Posted by Randompolygamy
Ok so figure out the weapon master id's and publish your fixed fix :P