thanks
thanks
@student1: can you please update your client to 4079 with auctionhouse bot and rougepatch e.t.c, since efsanekan71's Version doesn't contain these patches.
Or can I use your latest rev for 2.1.3 as well?
ah bot already running :=)
[quote] :
How to use auction bot :
From Chris K :
Step 1.) Create a character that you are going to use as the auction house bot character. This character will be the auction's owner for all the items created by the bot.
Step 2.) Go into the realm database and note the account number for the character.
Step 3.) Go into the mangos database and note the character's GUID.
Step 4:) Modify the mangos ini with this information.
Step 5.) Log in at least once with this character.
,
try this and u can see that's working :=)
and rog patch already on server core side :=)
Yeah right, in student1's Version it is implemented!
In yours, too?!
Cause your mangosd.conf is missing the following passage, then: :tongue:
# Auction House Bot
AuctionHouseBot.Account = 0
AuctionHouseBot.GUID = 0
AuctionHouseBot.AllianceItems = 0
AuctionHouseBot.HordeItems = 0
AuctionHouseBot.NeutralItems = 0
AuctionHouseBot.MinTime = 8
AuctionHouseBot.MaxTime = 24
AuctionHouseBot.PercentWhiteTradeGoods = 30
AuctionHouseBot.PercentGreenTradeGoods = 13
AuctionHouseBot.PercentBlueTradeGoods = 9
AuctionHouseBot.PercentPurpleTradeGoods = 1
AuctionHouseBot.PercentWhiteItems = 6
AuctionHouseBot.PercentGreenItems = 30
AuctionHouseBot.PercentBlueItems = 9
AuctionHouseBot.PercentPurpleItems = 2
AuctionHouseBot.MinPriceWhite = 150
AuctionHouseBot.MaxPriceWhite = 250
AuctionHouseBot.BidPriceWhite = 100
AuctionHouseBot.MinPriceGreen = 200
AuctionHouseBot.MaxPriceGreen = 300
AuctionHouseBot.BidPriceGreen = 100
AuctionHouseBot.MinPriceBlue = 250
AuctionHouseBot.MaxPriceBlue = 350
AuctionHouseBot.BidPriceBlue = 100
AuctionHouseBot.MinPricePurple = 300
AuctionHouseBot.MaxPricePurple = 450
AuctionHouseBot.BidPricePurple = 100
So is it implemented in your build or not. :biggrin:
This was my question and the reason for my post.
GreetZ
When i extract using mpqe.exe (i had to find sfmpq.dll somewhere else too) I get an error patch-enus-2.mpq the syntax of the command is not correct.
When i run mangosd i get errors like:
2007-07-12 12:17:37 Initialize data stores...
2007-07-12 12:17:37 ERROR:
Some required *.dbc files (19 from 35) not found or not compatible:
./dbc/AreaTable.dbc (exist, but have 35 fields instead 27) Wrong client version DBC file?
./dbc/BattlemasterList.dbc (exist, but have 32 fields instead 24) Wrong client version DBC file?
./dbc/ChatChannels.dbc (exist, but have 37 fields instead 21) Wrong client version DBC file?
./dbc/ChrClasses.dbc (exist, but have 24 fields instead 18) Wrong client version DBC file?
./dbc/ChrRaces.dbc (exist, but have 35 fields instead 27) Wrong client version DBC file?
./dbc/CreatureFamily.dbc (exist, but have 26 fields instead 18) Wrong client version DBC file?
./dbc/Faction.dbc (exist, but have 53 fields instead 37) Wrong client version DBC file?
./dbc/ItemRandomProperties.dbc (exist, but have 24 fields instead 16) Wrong client version DBC file?
./dbc/ItemRandomSuffix.dbc (exist, but have 25 fields instead 17) Wrong client version DBC file?
./dbc/ItemSet.dbc (exist, but have 53 fields instead 45) Wrong client version DBC file?
./dbc/Map.dbc (exist, but have 123 fields instead 75) Wrong client version DBC file?
./dbc/SkillLine.dbc (exist, but have 38 fields instead 22) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 211 fields instead 179) Wrong client version DBC file?
./dbc/SpellItemEnchantment.dbc (exist, but have 34 fields instead 26) Wrong client version DBC file?
./dbc/SpellRange.dbc (exist, but have 38 fields instead 22) Wrong client version DBC file?
./dbc/TalentTab.dbc (exist, but have 23 fields instead 15) Wrong client version DBC file?
./dbc/TaxiNodes.dbc (exist, but have 24 fields instead 16) Wrong client version DBC file?
./dbc/TaxiPathNode.dbc (exist, but have 11 fields instead 9) Wrong client version DBC file?
./dbc/WorldSafeLocs.dbc (exist, but have 22 fields instead 14) Wrong client version DBC file?
Does any one have the 2.1.2 DBC? I've been trying to extract it and maybe someone already has it uploaded somewhere? Thanks!
Working DBC files for 2.1.3 TBC here
thanks a lot dudeQuote:
Originally Posted by LMuri
thanks, let me give these dbc a try.
One more question, I got it work , but I can not select the new tbc characters like blood elves. It's like TBC is gone or something. I can't teleport to silvermoon, it says that I don't have TBC installed (and of course i do). Anyone else having this problem? Any suggestions?
You have to go into the database realmd and select your account and under the tbc column put 1.
Great thanks again.
Easier solve than GenDeathRaiser's:Quote:
Originally Posted by peewee1
Mangosd.exe,command line: setbc <accountname> 1
Whoila:punk:
Hi . Need help.
I`ve tried the 4063 and 4079 core , both with sdb rev 10. when i open mangosd.exe, I get this error:
I tried to get a sql dump for item_template table from other revs, even googlesearch it. all had round 119-120 fields. what should I do?Quote:
2007-07-13 12:37:58 Using configuration file mangosd.conf.
2007-07-13 12:37:58 MaNGOS daemon /0.8-SVN (Win32)
2007-07-13 12:37:58 <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 MaNGOS community forums (Powered by Invision Power Board)
MMMMMM
2007-07-13 12:37:58 World Database: 127.0.0.1;3306;root;pass;mangos
2007-07-13 12:37:58 Login Database: 127.0.0.1;3306;root;pass;mangos
2007-07-13 12:37:58 Realm running as realm ID 1
2007-07-13 12:37:58 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-07-13 12:37:58 ERROR:SQL ERROR: Table 'mangos.account' doesn't exist
2007-07-13 12:37:59 Using DataDir ./
2007-07-13 12:37:59 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-13 12:37:59 WORLD: VMap data directory is: ./vmaps
2007-07-13 12:37:59 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-13 12:37:59 ERROR:SQL: UPDATE `realmlist` SET `icon` = 4 WHERE `id` = '1'
2007-07-13 12:37:59 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
2007-07-13 12:37:59 Initialize data stores...
2007-07-13 12:38:01
2007-07-13 12:38:01 >> Loaded 35 data stores
2007-07-13 12:38:01
2007-07-13 12:38:01 Using DBC Locale From Config (0).
2007-07-13 12:38:01 Cleaning up instances...
2007-07-13 12:38:02
2007-07-13 12:38:02 >> Initialized 0 instances, deleted 0 old instances
2007-07-13 12:38:02 Packing instances...
2007-07-13 12:38:02
2007-07-13 12:38:02 >> Instance numbers remapped, next instance id is 1
2007-07-13 12:38:02 Loading Game Object Templates...
2007-07-13 12:38:03 >> Loaded 12157 game object templates
2007-07-13 12:38:03
2007-07-13 12:38:03 Loading Spell Chain Data...
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 1914 spell chain records
2007-07-13 12:38:03 Loading Spell Learn Skills...
2007-07-13 12:38:03 ERROR:Spell 3386 listed in `spell_learn_skill` not exist
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 44 spell learn skills + found in DBC 74
2007-07-13 12:38:03 Loading Spell Learn Spells...
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 40 spell learn spells + found in DBC 5930
2007-07-13 12:38:03 Loading Spell Proc Event conditions...
2007-07-13 12:38:03 ERROR:SQL: SELECT `entry`,`SchoolMask`,`Category`,`SkillID`,`SpellFamilyName`,`SpellFamilyMask`,`procFlags`,`ppmRate` FROM `spell_proc_event`
2007-07-13 12:38:03 ERROR:query ERROR: Unknown column 'SpellFamilyName' in 'field list'
2007-07-13 12:38:03
2007-07-13 12:38:03 >> Loaded 0 spell proc event conditions
2007-07-13 12:38:03 Loading Aggro Spells Definitions...
2007-07-13 12:38:03 >> Loaded 101 aggro generating spells
2007-07-13 12:38:03
2007-07-13 12:38:03 Loading NPC Texts...
2007-07-13 12:38:04
2007-07-13 12:38:04 >> Loaded 3687 npc texts
2007-07-13 12:38:04 Loading Items...
2007-07-13 12:38:12 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 132 fields in sql).
fucking NOOBS read the FUCKING RULES OF THIS TOPIC NO SUPORT IN THIS TOPIC MAKE AN FUCKING NEW TOPIC FOR SUPORT .
Sorry for the ruthness but you fucking noobs cant read aperently .
Delete this post as well when cleaning topic please .
Problem with item_template: U must update your Database with Mangos core update, the files its called 4058.sql or use thisand thisCode:ALTER TABLE `item_template` ADD COLUMN `ArmorDamageModifier` float NOT NULL default '0' AFTER `RequiredDisenchantSkill`;
ALTER TABLE `item_template` DROP COLUMN `name2`, DROP COLUMN `name3`, DROP COLUMN `name4`;
Code:DELETE FROM `spell_affect` WHERE `entry` in(11370,12288,12288,12707,12707,14067,15019,16183,16823,16823,16825,16825,17325,18310,18311,18312,18313,29860,29861,29862,30440,30640,30649,33216,33217,34301);
DELETE FROM `spell_proc_event` WHERE `entry` in(114,637,646,648,1028,1034,1048,1707,2095,2852,4051,4161,4512,5575,5580,6134,6135,6592,6593,7601,7614,7615,7616,7618,9205,9793,9797,9801,9808,10095,10400,10727,10868,11830,11838,11961,12002,12038,12094,12546,12552,13078,13260,13320,13767,13987,14095,14150,14152,14154,15364,15365,15567,15568,15569,15644,15650,16140,16241,16242,16311,16312,16313,16423,16563,16925,16926,16955,16956,16957,16962,16963,16964,17000,17001,17079,17082,19195,19234,19235,19389,19390,19396,19640,20163,20169,20183,20204,20411,20412,20413,20414,20419,20421,20422,20423,20563,20809,20896,21387,21789,22283,22285,22286,22287,22288,22697,22716,23255,23301,23303,23305,23306,25592,25715,25727,25728,25729,25730,25731,25732,25733,25734,25745,25751,25752,25757,25926,25942,25945,26341,28130,28881,29526);