Printable View
I do all correct.
My problem just is this
ps: my Datadir is ""
Map file './maps/0004331.map' is non-compatible version (outdated?). Please, cre
ate new using ad.exe program.
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.
alright dude I had this same prob to start with, ok first make sure you have extracted the maps from the client and have the folder called maps in your mangos server folder. if you have, then it might be asking you to install vmaps I dont knwo why because it didnt happen with me. But it might also be the fact that your mangos core version is not compatible with the client you extracted the maps and dbc from.
This mixture of files works for me without any probs if it helps man
Core server files: 4855
UDB: 9.0
Client: 2.3.0
PS I posted earlier asking what client version I should use its ok guys sorted it out
I solved the problem.
I used the AD.EXE
of directory of mangos.
and not the ad.exe uploaded into topic!
thanks anyway
thats ok dude no probs
Hi , i am here again haha..
Now are other problem
look that
>> Loaded 2182 equipment template
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there sh
ould be 64 fields in sql).
I have no idea to solve this.
Edit___
Solved again..
i used this query to solve
-- 5986
DELETE FROM `spell_proc_event` WHERE `entry` IN (46832);
INSERT INTO `spell_proc_event` VALUES
(46832,0,0,0,7,0x0000000000000001,0x00004000,0);
-- 5965
DELETE FROM mangos_string WHERE entry in (468,470);
INSERT INTO `mangos_string` VALUES
(468,'id: %d eff: %d type: %d duration: %d maxduration: %d name: %s%s%s caster: %s %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(470,'id: %d eff: %d name: %s%s%s caster: %s %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-- 5973
DELETE FROM `spell_proc_event` WHERE `entry` IN (44835);
INSERT INTO `spell_proc_event` VALUES
(44835,0,0,0,7,0x0000008000000000,0x00008000,0);
-- 5982
DROP TABLE playercreateinfo_skill;
DROP TABLE spell_learn_skill;
-- 5986
DELETE FROM `spell_proc_event` WHERE `entry` IN (46832);
INSERT INTO `spell_proc_event` VALUES
(46832,0,0,0,7,0x0000000000000001,0x00004000,0);
-- 5999
DELETE FROM `spell_proc_event` WHERE `entry` IN (37528);
INSERT INTO `spell_proc_event` VALUES
(37528,0,0,0,4,0x0000000000000004,0x00000001,0);
-- 6016
DELETE FROM `spell_proc_event` WHERE `entry` IN (37173);
INSERT INTO `spell_proc_event` VALUES
(37173,0,0,0,8,0x000001062cbc0598,0x000a0001,0);
DELETE FROM `spell_proc_event` WHERE `entry` IN (30881,30883,30884,30885,30886);
INSERT INTO `spell_proc_event` VALUES
(30881,0,0,0,0,0x0000000000000000,0x00008000,0),
(30883,0,0,0,0,0x0000000000000000,0x00008000,0),
(30884,0,0,0,0,0x0000000000000000,0x00008000,0),
(30885,0,0,0,0,0x0000000000000000,0x00008000,0),
(30886,0,0,0,0,0x0000000000000000,0x00008000,0);
-- 6017
DELETE FROM `spell_proc_event` WHERE `entry` IN (37170);
INSERT INTO `spell_proc_event` VALUES
(37170,0,0,0,0,0x0000000000000000,0x00000001,1);
-- 6022
DELETE FROM `spell_proc_event` WHERE `entry` IN (12322,12999,13000,13001,13002);
INSERT INTO `spell_proc_event` VALUES
(12322,0,0,0,0,0x0000000000000000,0x00000001,2),
(12999,0,0,0,0,0x0000000000000000,0x00000001,4),
(13000,0,0,0,0,0x0000000000000000,0x00000001,6),
(13001,0,0,0,0,0x0000000000000000,0x00000001,8),
(13002,0,0,0,0,0x0000000000000000,0x00000001,10);
-- 6023
DELETE FROM `mangos_string` WHERE `entry` IN (314,315,316);
INSERT INTO `mangos_string` VALUES
(314, ' [peace forced]',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(315, ' [hidden]',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(316, ' [invisible forced]',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-- 6027
DELETE FROM `spell_affect` WHERE `entry` IN
(12873,12872,11095,11252,12605,20244,20245,23565,16040,16113,16114,16115,16116,22804,14171,14172,14173,12290,12963,16858,16859,16860,16861,16862,
17815,17833,17834,17835,17836,21744,12866,12325,12863,12864,12865,12866,16194,16218,16219,16220,16221,23236,14143,14149,14151,26130,27848);
DELETE FROM `spell_affect` WHERE `entry` IN (12945,16544,18372) AND `effectId` = 0;
DELETE FROM `spell_affect` WHERE `entry` IN (14075,14074,14073,14072,14057,16544,23566) AND `effectId` = 1;
INSERT INTO `spell_affect` VALUES
(14143,0,0x0000000004000206),
(14149,0,0x0000000004000206);
-- 6032
ALTER TABLE `petcreateinfo_spell` DROP `FamilyPassive`;
-- 6037
-- (38398) Reduced Cleave Cost ()
DELETE FROM `spell_affect` WHERE `entry` IN (38398);
INSERT INTO `spell_affect` VALUES (38398, 0, 0x0000000020000000);
-- (40389) Crow Discount ()
DELETE FROM `spell_affect` WHERE `entry` IN (40389);
INSERT INTO `spell_affect` VALUES (40389, 0, 0x0000800000000000);
-- 6038
ALTER TABLE `creature_template`
ADD COLUMN `PetSpellDataId` mediumint(8) unsigned NOT NULL default '0' AFTER `spell4`;
-- 6049
INSERT INTO `spell_proc_event` VALUES
(20784,0,0,0,0,0,4096,0),
(32850,0,0,0,0,0,1,0),
(34457,0,0,0,0,0,4096,0);
-- 6052
ALTER TABLE `creature_loot_template`
DROP freeforall;
ALTER TABLE `disenchant_loot_template`
DROP freeforall;
ALTER TABLE `fishing_loot_template`
DROP freeforall;
ALTER TABLE `gameobject_loot_template`
DROP freeforall;
ALTER TABLE `item_loot_template`
DROP freeforall;
ALTER TABLE `pickpocketing_loot_template`
DROP freeforall;
ALTER TABLE `prospecting_loot_template`
DROP freeforall;
ALTER TABLE `skinning_loot_template`
DROP freeforall;
-- 6058
DELETE FROM `spell_learn_spell` WHERE `entry` = 71;
DELETE FROM `spell_learn_spell` WHERE `entry` = 2842;
INSERT INTO `spell_learn_spell` VALUES (2842,8681);
-- 6061
DROP TABLE IF EXISTS `quest_mail_loot_template`;
CREATE TABLE `quest_mail_loot_template` (
`entry` mediumint(8) unsigned NOT NULL default '0',
`item` mediumint(8) unsigned NOT NULL default '0',
`ChanceOrQuestChance` float NOT NULL default '100',
`groupid` tinyint(3) unsigned NOT NULL default '0',
`mincountOrRef` mediumint(9) NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`lootcondition` tinyint(3) unsigned NOT NULL default '0',
`condition_value1` mediumint(8) unsigned NOT NULL default '0',
`condition_value2` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
ALTER TABLE quest_template
ADD COLUMN `RewMailTemplateId` mediumint(8) unsigned NOT NULL default '0' AFTER `RewSpellCast`,
ADD COLUMN `RewMailDelaySecs` int(11) unsigned NOT NULL default '0' AFTER `RewMailTemplateId`;
-- 6062
DELETE FROM spell_proc_event WHERE entry = 13743 OR entry = 13875;
DELETE FROM spell_proc_event WHERE entry = 14076 OR entry = 14094;
UPDATE spell_proc_event SET Category = 0, SkillId = 0 WHERE entry = 12797 OR entry = 12799 OR entry = 12800;
UPDATE spell_proc_event SET Category = 0 WHERE entry = 13754 OR entry = 13867;
UPDATE spell_proc_event SET Category = 0 WHERE entry = 40458;
UPDATE spell_proc_event SET SkillId = 0 WHERE entry = 16850 OR entry = 16923 OR entry = 16924;
UPDATE spell_proc_event SET SkillId = 0 WHERE entry = 17793 OR entry = 17796 OR entry = 17801 OR entry = 17802 OR entry = 17803;
UPDATE spell_proc_event SET SkillId = 0, SchoolMask = 0 WHERE entry = 23721;
UPDATE spell_proc_event SET SkillId = 0, SchoolMask = 0 WHERE entry = 28809;
UPDATE spell_proc_event SET SkillId = 0, SchoolMask = 0 WHERE entry = 28823;
UPDATE spell_proc_event SET SkillId = 0 WHERE entry = 23695;
UPDATE spell_proc_event SET SchoolMask = 0, SpellFamilyMask = 0x8000000060 WHERE entry = 18073 OR entry = 18096;
UPDATE spell_proc_event SET SchoolMask = 0 WHERE entry = 19407 OR entry = 19412 OR entry = 19413 OR entry = 19414 OR entry = 19415;
UPDATE spell_proc_event SET SchoolMask = 0 WHERE entry = 20234 OR entry = 20235;
UPDATE spell_proc_event SET SchoolMask = 0 WHERE entry = 23551 OR entry = 23572;
UPDATE spell_proc_event SET SchoolMask = 0 WHERE entry = 38394;
i'm sorry. i just realized that mangos has updated their ad.exe file. i'll upload the new one.
and you can also get the client by making a trial account on the real wow. or otherwise go to http://www.wowwiki.com/Patch_mirrors for manual updates.
I'm sorry for being very late on all of this. I was on vacation in Florida =)
sqlyog - to manage your mysql. link - sqlyog
the wow client - self explanatory. link - client
ad.exe - used to extract maps. link - ad.rar
dbc extractor - extracts dbc files from client. link - dbc_extract
mangos core - obviously the main component. link - Filebeam - Free Fast File Hosting
udb - the database. link - udb database
note: you have to make an account to get.
mysql - needed for db - link mysql
vmap extract - extracts vmaps from client - link vmap_extract
I'd host these files myself but I have dialup lolz.
anyone could reupload these files cus ther ant working on the link there just bring them back to this page grrrrrr
2008-06-29 03:17:05 Using configuration file mangosd.conf.
2008-06-29 03:17:05 MaNGOS daemon /0.11.0-SVN (Revision 6122) (Win32)
2008-06-29 03:17:05 <Ctrl-C> to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2008-06-29 03:17:05 World Database: 82.47.168.117;3306;root;test;mangos
2008-06-29 03:17:05 ERROR:Could not connect to MySQL database at 82.47.168.117: Host 'advent01' is not allowed to connect to this MySQL server
2008-06-29 03:17:05 ERROR:Cannot connect to world database 82.47.168.117;3306;root;test;mangos
could someone tell why it dont connect to the database please asap
RealmID = 1
DataDir = ""
LogsDir = ""
LoginDatabaseInfo = "82.47.168.117;3306;root;test;mangos;realmd"
WorldDatabaseInfo = "82.47.168.117;3306;root;test;mangos"
CharacterDatabaseInfo = "82.47.168.117;3306;root;test;mangos;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
iv set it up with wampserver not mysql 5 do i need to set the mysql bin dir any place also
Quote:
Originally Posted by MasterKill
ok got server working on 127.0.0.1 but not from my main ip or local network ip some silly reason
2008-06-29 03:36:38 ERROR:Check existing of map file './maps/5301243.map': not exist!
2008-06-29 03:36:38 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
and some map files are missing but i ran ot for 40 mins
I got server working correctly but no one can connect to the ip .... what am i doing wrong?
for that map error. i need more info... is your client using the burning crusade?
and the reason others cannot connect to your server is because you need to set the ip in the realmd database to your external ip.
burning crusade??
World of Warcraft The Burning Crusade US Client Part 1 2.2MB
World of Warcraft The Burning Crusade US Client Part 2 620.66MB
World of Warcraft The Burning Crusade US Client Part 3 619.74MB
World of Warcraft The Burning Crusade US Client Part 4 619.92MB
World of Warcraft The Burning Crusade US Client Part 5 202.96MB
so i need to install all of this patches to wow client now ?????
why didnt u say that in the guild now i have to start all over again!!!
client is 2.4.2 version
oh and this server pack uptodate ? cus ut says 2007 on first post or there any links for uptodate server pack