[Release] Mangos WotLK Core 3.0.2.8905

**Nanos** · 10-03-2008

Originally Posted by stevamirkovic

Repack is ok, you can resolve this problem easy. Delete "Cache" and "WTF" folders from your Wotlk Beta folder...

Deleted both folders again, still happens.

Edit:

Only seems to apply to ".lookup quest $questname" other .lookup commands work.

Anyone else having this problem?

**Deathtrooper** · 10-03-2008

Sorry but the quest r all screwed up right now! Blizzard made their last patch a debug version, which is both bad and good. All should be fixed with more core and DB support!

Originally Posted by huongphieubat

Hi, i got to Northrend and ... nothing to kill! im deathkinght (alliance). Who know why?

Try Borean Tundra it's pretty much spawned a good percentage!

**tippythop** · 10-03-2008

Hey death can you include an auction house bot in 8982? or in the next core please

thx

i seen a mangosd that had this in it for the auction bot

Code:

###################################################################################################################
# AUCTION HOUSE BOT SETTINGS
# 
#    Auction House Bot character data
#        AuctionHouseBot.Account is the account number (in realmd->account table) of the player you want to run as the auction bot.
# 	    AuctionHouseBot.GUID is the GUID (in characters->characters table) of the player you want to run as the auction bot. 
#    Default: 0 (Auction House Bot disabled)
#
#    AuctionHouseBot.NoMail
#        This is a flag to disable mail for successfull auctions. 
#        A value of 0 will allow mail for successful auctions to be sent, which is the default.
#        Non-zero (e.g. AuctionHouseBot.NoMail = 1) will stop successful auction mail.
#    Default: 0 (Send auction successful mail)
# 
#    AuctionHouseBot.AllianceItems
#        This is the number of items you want to keep in the Alliance auction house.
#    AuctionHouseBot.HordeItems
#        This is the number of items you want to keep in the Horde auction house.
#    AuctionHouseBot.NeutralItems
#        This is the number of items you want to keep in the Neutral auction house.
#    Default: 0 (No items generated)
#        Note: If you enable AllowTwoSide.Interaction.Trade, ALL auction houses are linked to the neutral auction house.
#
#    AuctionHouseBot.MinAllianceItems
#        This is the minimum number of items you want to keep in the Alliance auction house.
#    AuctionHouseBot.MinHordeItems
#        This is the minimum number of items you want to keep in the Horde auction house.
#    AuctionHouseBot.MinNeutralItems
#        This is the minimum number of items you want to keep in the Neutral auction house.
#    Default: -1 (minimum will be the same as maximum)
# 
#    AuctionHouseBot.MinTime
#        Sets the minimum number of hours for an auction.
#    Default: 8
#
#    AuctionHouseBot.MaxTime
#        Sets the maximum number of hours for an auction.
#    Default: 24
#
#    Item distribution
#        Sets the percentage of the auction items that should be trade goods of white quality.
#        A value of 0 will disable.
#    AuctionHouseBot.PercentWhiteTradeGoods
#        Sets the percentage of the White Trade Goods auction items
#    Default: 30
#    AuctionHouseBot.PercentGreenTradeGoods
#        Sets the percentage of the Green Trade Goods auction items
#    Default: 13
#    AuctionHouseBot.PercentBlueTradeGoods
#        Sets the percentage of the Blue Trade Goods auction items
#    Default: 9
#    AuctionHouseBot.PercentPurpleTradeGoods
#        Sets the percentage of the Purple Trade Goods auction items
#    Default: 1
#        Note: All of the above values (AuctionHouseBot Percent TradeGoods) must add together to make 100 percent.
#
#    AuctionHouseBot.PercentWhiteItems
#        Sets the percentage of the non trade White auction items
#    Default: 6
#    AuctionHouseBot.PercentGreenItems
#        Sets the percentage of the non trade Green auction items
#    Default: 30
#    AuctionHouseBot.PercentBlueItems
#        Sets the percentage of the non trade Blue auction items
#    Default: 9
#    AuctionHouseBot.PercentPurpleItems
#        Sets the percentage of the non trade Purple auction items
#    Default: 2
#        Note: All of the above values (AuctionHouseBot Percent Items) must add together to make 100 percent.
#
#    Minimum and maximim price mark-up for items.  Percentage of vendor sale price.
#        Example: If a vendor would sell an item for 1g and MinPrice = 150 and MaxPrice = 250,
#        then that item would be randomly priced between 1g 50s and 2g 50s.
#    AuctionHouseBot.MinPriceWhite
#        Minimum price of White items.
#    Default: 150
#    AuctionHouseBot.MaxPriceWhite
#        Maximum price of White items.
#    Default: 250
#    AuctionHouseBot.MinPriceGreen
#        Minimum price of Green items.
#    Default: 200
#    AuctionHouseBot.MaxPriceGreen
#        Maximum price of Green items.
#    Default: 300
#    AuctionHouseBot.MinPriceBlue
#        Minimum price of Blue items.
#    Default: 250
#    AuctionHouseBot.MaxPriceBlue
#        Maximum price of Blue items.
#    Default: 350
#    AuctionHouseBot.MinPricePurple
#        Minimum price of Purple items.
#    Default: 300
#    AuctionHouseBot.MaxPricePurple
#        Maximum price of Purple items.
#    Default: 450
#
#    AuctionHouseBot.BidPrice
#    Starting bid price as a percentage of the randomly chosen buyout price
#    AuctionHouseBot.BidPriceWhite
#    Default: 100 (Bid and buyout price the same)
#    AuctionHouseBot.BidPriceGreen
#    Default: 100 (Bid and buyout price the same)
#    AuctionHouseBot.BidPriceBlue
#    Default: 100 (Bid and buyout price the same)
#    +AuctionHouseBot.BidPricePurple
#    Default: 100 (Bid and buyout price the same)
#
#    AuctionHouseBot.MaxStack
#        Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality,
#        which will allow the bot to create items in stack as large as the item allows.
#    AuctionHouseBot.MaxStackWhite
#    Default: 0
#    AuctionHouseBot.MaxStackGreen
#    Default: 3
#    AuctionHouseBot.MaxStackBlue
#    Default: 2
#    AuctionHouseBot.MaxStackPurple
#    Default: 1
#
###################################################################################################################

AuctionHouseBot.Account = 0
AuctionHouseBot.GUID = 0
AuctionHouseBot.NoMail = 0
AuctionHouseBot.AllianceItems = 0
AuctionHouseBot.HordeItems = 0
AuctionHouseBot.NeutralItems = 0
AuctionHouseBot.MinAllianceItems = -1
AuctionHouseBot.MinHordeItems = -1
AuctionHouseBot.MinNeutralItems = -1
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.MinPriceGreen = 200
AuctionHouseBot.MaxPriceGreen = 300
AuctionHouseBot.MinPriceBlue = 250
AuctionHouseBot.MaxPriceBlue = 350
AuctionHouseBot.MinPricePurple = 300
AuctionHouseBot.MaxPricePurple = 450
AuctionHouseBot.BidPriceWhite = 100
AuctionHouseBot.BidPriceGreen = 100
AuctionHouseBot.BidPriceBlue = 100
AuctionHouseBot.BidPricePurple = 100
AuctionHouseBot.MaxStackWhite = 0
AuctionHouseBot.MaxStackGreen = 3
AuctionHouseBot.MaxStackBlue = 2
AuctionHouseBot.MaxStackPurple = 1

**Deathtrooper** · 10-03-2008

Originally Posted by tippythop

Hey death can you include an auction house bot in 8982? or in the next core please

thx

i seen a mangosd that had this in it for the auction bot

Core:8982/9014
Mangos Revision:6700
Scriptdev2:671
Wotlk Patch:19.1
FdbScripts:3e + Ahbot

Mangos WotLK Core 8982/9014 w/AhBot

Does that help?

**BrantX** · 10-03-2008

Gave you Rep x3 for the great releases/shares.
Hope to see more stuff from you. Enjoy!

**tippythop** · 10-04-2008

A hahahah thanks death

your the best

works like a charm

cant wait for the next release

**ViND_** · 10-04-2008

Code:

Query:
INSERT INTO `characters` VALUES ('4141', '2940', '4141 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 2063701207 4046458691 0 0 6687 7516 0 0 100 0 0 1005 7407 7953 1000 0 100 0 4 1005 70 1610 522 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1163575296 1157234688 1157234688 1053240066 1069547520 15476 15476 0 1141800960 1144422400 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 387 158 421 352 107 1132724224 1117650944 1133969408 1132756992 1100480512 0 0 0 0 0 8996 5 5 5 5 5 5 0 1084227584 1084227584 1084227584 1084227584 1084227584 1084227584 0 0 0 0 0 0 0 2953 3377 10240 964 40 0 148 40 0 1105124206 1105648494 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50987529 16777218 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29073 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28762 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29075 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24143 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29071 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28733 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29074 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28569 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28512 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29072 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28649 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28661 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34470 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28570 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 345218 1073741824 345443 1073741824 345180 1073741824 310621 1073741824 345224 1073741824 345426 1073741824 345228 1073741824 345298 1073741824 345286 1073741824 345226 1073741824 345347 1073741824 345343 1073741824 345446 1073741824 0 0 345295 1073741824 345553 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 310613 1073741824 310615 1073741824 310617 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 779700 95 22937950 0 43 22937950 0 55 22937950 0 162 22937950 0 594 65537 0 109 19661100 0 137 19661100 0 756 65537 0 413 65537 0 414 65537 0 415 65537 0 433 65537 0 293 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 61 2 0 0 1084227584 1088462572 0 0 0 1091818133 0 0 0 1095608794 1095608794 1095608794 1095608794 1095608794 1095608794 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33570816 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25731 2978000 0 220 220 220 220 220 220 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 220 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 57 57 57 49 49 113 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1101174635 1070386381 80 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', 'Óoóóoóóo', '10', '2', '5801.26', '589.694', '652.72', '571', '0', '4.9637', '0 0 131072 4 0 0 1048576 0 ', '0', '1', '357', '357', '1219093518', '0', '25731.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2817', '0', '')

Error occured at:2008-08-30 21:51:19
Line no.:3098592
Error Code: 1406 - Data too long for column 'name' at row 1

Query:
CREATE TABLE `areatrigger_involvedrelation` (
 `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
 `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
 PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2008-10-04 16:53:30
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `areatrigger_involvedrelation` (
 `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
 `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
 PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2008-10-04 16:57:57
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

So... yeah... anyone can help? Received when importing mangos.sql with SQLyog...

**Deathtrooper** · 10-04-2008

Originally Posted by jimei

Code:

Query:
INSERT INTO `characters` VALUES ('4141', '2940', '4141 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 2063701207 4046458691 0 0 6687 7516 0 0 100 0 0 1005 7407 7953 1000 0 100 0 4 1005 70 1610 522 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1163575296 1157234688 1157234688 1053240066 1069547520 15476 15476 0 1141800960 1144422400 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 387 158 421 352 107 1132724224 1117650944 1133969408 1132756992 1100480512 0 0 0 0 0 8996 5 5 5 5 5 5 0 1084227584 1084227584 1084227584 1084227584 1084227584 1084227584 0 0 0 0 0 0 0 2953 3377 10240 964 40 0 148 40 0 1105124206 1105648494 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50987529 16777218 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29073 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28762 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29075 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24143 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29071 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28733 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29074 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28569 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28512 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29072 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28649 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28661 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34470 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28570 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 345218 1073741824 345443 1073741824 345180 1073741824 310621 1073741824 345224 1073741824 345426 1073741824 345228 1073741824 345298 1073741824 345286 1073741824 345226 1073741824 345347 1073741824 345343 1073741824 345446 1073741824 0 0 345295 1073741824 345553 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 310613 1073741824 310615 1073741824 310617 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 779700 95 22937950 0 43 22937950 0 55 22937950 0 162 22937950 0 594 65537 0 109 19661100 0 137 19661100 0 756 65537 0 413 65537 0 414 65537 0 415 65537 0 433 65537 0 293 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 61 2 0 0 1084227584 1088462572 0 0 0 1091818133 0 0 0 1095608794 1095608794 1095608794 1095608794 1095608794 1095608794 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33570816 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25731 2978000 0 220 220 220 220 220 220 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 220 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 57 57 57 49 49 113 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1101174635 1070386381 80 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', 'Óoóóoóóo', '10', '2', '5801.26', '589.694', '652.72', '571', '0', '4.9637', '0 0 131072 4 0 0 1048576 0 ', '0', '1', '357', '357', '1219093518', '0', '25731.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2817', '0', '')

Error occured at:2008-08-30 21:51:19
Line no.:3098592
Error Code: 1406 - Data too long for column 'name' at row 1

Query:
CREATE TABLE `areatrigger_involvedrelation` (
 `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
 `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
 PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2008-10-04 16:53:30
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `areatrigger_involvedrelation` (
 `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
 `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
 PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2008-10-04 16:57:57
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

So... yeah... anyone can help? Received when importing mangos.sql with SQLyog...

I can tell from the last line that u r tring to execute into mangosd that already has a DB there! Try empting ur DB first then try again!!

**ViND_** · 10-04-2008

Ok i did it and it worked. But when starting mangosd.exe it loads some stuff and finally it shows:

Code:

Loading items...
Error in item_template table, probably sql file format was updated (there should be 142 fields in sql)

How do i fix that one?

**Carriro** · 10-04-2008

Originally Posted by jimei

Ok i did it and it worked. But when starting mangosd.exe it loads some stuff and finally it shows:

Code:

Loading items...
Error in item_template table, probably sql file format was updated (there should be 142 fields in sql)

How do i fix that one?

Execute this in data base, and all will be ok...

ALTER TABLE `item_template`
ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;
ALTER TABLE `item_template`
ADD COLUMN `unk_flag2` mediumint(10) unsigned NOT NULL default '0' AFTER unk_flag1;

**ViND_** · 10-04-2008

Umm, i dont know how to make a .sql file to execute... sorry tell me pls.

**ViND_** · 10-04-2008

Originally Posted by Carriro

Execute this in data base, and all will be ok...

ALTER TABLE `item_template`
ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;
ALTER TABLE `item_template`
ADD COLUMN `unk_flag2` mediumint(10) unsigned NOT NULL default '0' AFTER unk_flag1;

Please tell me how to add it, i really need a WotLK Server

**Deathtrooper** · 10-04-2008

Originally Posted by jimei

Please tell me how to add it, i really need a WotLK Server

Open SQLyog, then click on mangosd(or just highlight it), then in the right hand box copy /paste the code from above, then right click in the same box and select execute query...done!

**ViND_** · 10-04-2008

Code:

Loading Vehicles...
SQL: SELECT MAX(entry) FROM creature_Vehicles
query ERROR: 'table mangos.creature_vehicles doesn't exist
Error loading creature_Vehicles table (not exist?)

I got through the items and this is what it shows me now...

**Nanos** · 10-04-2008

Blizz released another beta client patch today, 3.0.2.9038.

Avoid patching the client until Mangos/Repacks have been updated.

Shout-Out

User Tag List

Thread: [Release] Mangos WotLK Core 3.0.2.8905

Thread Tools

Search Thread

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino