[Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

Well, one more question ?....
Check out that... i'm already create a new account for AHBot (should the account be GM level 3 or 0 ?) ... after that i create a new character 1 level in game with name: Ahbot -> after that i log in with that character in game and i'm didn't do anything else... just logout with him... the next step what i make it was to open my sqlyog and saw the Account ID and char guid numbers
Check out that pic (Click to enlarge):
Attachment 444
and let you check the mangosd.config it's right on what you said of me before some posts:
Attachment 445
That's right ?? I didn't see the reasen which don't work the bot ;(

Quote:

---

Originally Posted by CthulhuFtagn

For those who want to know what changes have been made from release to update 0021:

Major Changes

MaNGOS 10351 - 10429

Code:

---

Stability enhancement 8MB reserved stack size.
Aspeed, Speed, Flyspeed, Swimspeed updated from 10-255.
For item 50351 and 50706 fixed work in case no offhand weapon.
Implement support explcitly started timed achievements.
Avoid access to DB at view GM tickets by chat commands.
Use time constants instead of hard coded values for STOP_TIME_FOR_PLAYER
Correctly clearUnitState at Interrupt of WaypointMovementGenerator for creature.
Drop unneeded groupFlag and rename it properly.
PacketLog.* not used in core some time already so drop it.
A small spoon of changes and cleanup for WaypointMovementGenerator.
Restore triggered auras cleanup at main aura expire after auraholders adding.
Send proper error message at password check fail.
Remove trailing space.
Implement creature_movement_template.
More wide use ObjectGuid in way remove MAKE_NEW_GUID uses.
Restore build with gcc and cleanup includes a bit.
Implement ACTION_T_MOUNT_TO_ENTRY_OR_MODEL (43) for creature eventAI.
Add portable way for hash specialization adding.
Making sure CreaturesAddon are re-loaded after creature evade.
Use AI function DoCastSpellIfCan for eventAI ACTION_T_CAST
Implement UNORDERED_SET support.
Rename UnorderedMap.h -> UnorderedMapSet.h
More wide use ObjectGuid in group code.
Implement EFLAG_RANDOM_ACTION
Drop unused team-argument in ChooseDisplayId -function.
Fixes for EFLAG_RANDOM_ACTION
Updated MySQL client libs to 5.1.49
Fixed build at VS90 with TR1
Simplify use Guild::BroadcastEvent
Avoid double lookup member slot in guild operations.
More wide use ObjectGuid in arena team code.
Finaly drop MAKE_NEW_GUID.
Implement generic system for racial model selection.
Add missing holiday id<->battleground id definitions for AB
Store guid instaed pointer for first user of GAMEOBJECT_TYPE_SUMMONING_RITUAL
Fixed reset time calculation for some cases.
Traditional post-commit typo fix.
Remove Unit::GetUnit and update it callers.
Correct creature entry selection for raid difficulties.
Fixed quote parsing after optional arg in chat commands.
Make spawntime arg really optional as before for .gobject add
Typo fixes.
Add several new script calls for InstanceData.
Restore build at Unix after Unit::GetUnit drop.
Small correction in SetReputation to avoid confusion.
Add script call for InstanceData, OnPlayerDeath
Remove redundant use of this-> in recent implemented script calls.
No debug log output when a certain ability is active.
Send GMTicket to SendGMTicketGetTicket instead text.
Fixed wrong difficulty selection and possible crash.
Fix mixed up FactionEntry to lookup in SetReputation
Fixed typo in doc/EventAI.txt
Fixed crash in .aura command for spell without auras.
Some code style cleanups.
Use ObjectGuid in packets and fix some uint32 guids cases.
Stricted name check at chat command data loading from 'command' table.
Additional checks for call assist.
Restore remove spell affect 58427 after stealth fade.
Fixed work .learn and other spell commands with unlearned talent shift-link.
Add -o <outfile> option to genrevision.
Fix mistake in recent debug log output change (ref 10395)
Restore work of 47230 and ranks.
Fix wrong sql.
Fix broken sqls for spell_proc_event.
Add a BindIP warning to worldd/realmd config files
Add some missing class/struct forward declarations and includes.
Constantify some functions in InstanceSave.
Sort triggered spell chains 44203 and 42231 in proper place `spell_chain` data.
Fix 71611 proc and remove check for family name if no spell_proc_event is defined.
Fix Battle/Guardian elixirs stacking.
Merge not-skill linked spell lists in `spell_chain`.
Check redundant single rank spell data in `spell_chain`.
Avoid send stop packet in PointMovementGenerator when unit is not moving.
Correct typo in function name.
Fix 71642 proc conditions.
Load most spell chains data from SkillLineAbility.dbc
Fix 50334 additional targets part.
Add comment in Aura::CanProcFrom
Remove not needed checks from IsNoStackAuraDueToAura
Drop redundant data from `spell_proc_event` after recent spell chain changes.
Fix line ends.
Some format string fixes.
Improve detection removed ranks for spell in `spell_chain`

---

ScriptDev2 1778 - 1815

Code:

---

Minor code cleanup for ebon_hold.cpp
Correct two typos in boss_cthun. Patch by zergtmn.
Restore compile after changes in KilledMonsterCredit function. Requires Mangos 10363.
Add the missing .sql update for rev 1780
Update sources with changed ChooseDisplayId -function. Req Mangos 10373
Added support for boss Galdarah in Gundrak. Based on Gelu's work.
Added reworked version of Stratholme instance script. Blame Schmoozerd for any errors inside.
Added long time missing texts for arena event in BRD. Thanks to DaemonCantor.
Code cleanup in old_hillsbrad scripts and also move related gossip texts to database.
Re-design instance_old_hillsbrad
Added basic abilities of boss Drakkari Colossus in Gundrak.
Mortal Strikes proc rate might need adjusting.
Add a few missing texts in old_hillsbrad scripts. Correct a few existing and also added part of end-event.
Added a slightly more reliable way to prevent thrall from proceeding with waypoints before he should. Requires Mangos 10390
Fix r1786 sql, thanks Pandore.
Add more missing texts for old_hillsbrad and implement end event for the escort.
Reset old_hillsbrad escort at respawn.
Add lost call to escortAI JustRespawned, so escort variables are reset properly.
Removed obsolate code for boss Rockmar the Crackler in Slave Pens. Already implemented in ACID.
Reworked instance Gundrak.
Added cleaned up version of DasBlub's cleanup patch. Note: might need additional cleanup.
Added support for quests 5097 and 5098. Patch by virusav.
Might need additional core support.
Added support for quest 12916. Patch by virusav.
Corrected typo in dalaran.cpp. Patch by klark20.
Added support for quest 7603. Patch by Schmoozerd.
Fixed compile after r1798.
Fixed sql files from r1791.
Not check distance to group/player when escort is paused.
Fix crash after login, for the second time!! (ref revision 1267)
Add SetCurrentWaypoint for escortAi.
Can be used for escorts where points may be skipped (or continue from earlier reached) under special circumstances.
Implement relocation of thrall in case escort fail for any reason. Different locations are used, depending on overall progression.
Add missing semicolon in sql.
Some code cleanup, SD2 code style and enclose nested if's in () for readability.
Move some gossip texts to database.
Correct VC100 project file.
Use HandleEmote() also in DoScriptText function.
Move some crusader's gossip to database. Patch by patman.
In addition correct some bad style naming's and add missing for scriptloader.
Let boss_volkhan shatter only once. Patch by rise2.
Make sure cast is ok before yell and emote anything for volkhan shatter.
Add teleports related to quest 12548. Patch by crackm.
Remove some unwanted tabs and whitespace.
Manually reset button at unworthy initiate respawn.

---

YTDB 338 - 340

Code:

---

UPDATE 562_(10408)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 130 caches (3.3.5a)

UPDATE 561_(10372)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 117 caches (3.3.5a)

UPDATE 560_(10344) "Balthalionus"
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 107 caches (3.3.5a)

---

---

btw great job about the updates :) and thanks for all that on you and your team :)

So, when you click Search at the Armory, what happens?

If, and I'm assuming you didn't read, the ReadmeAHBOT.txt file in the Cumulative Update Pack you would set your min and max items for the Auction House...

Here's my settings:

Code:

---

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";

---

I put the Readme files there for a reason.

You should get something like this when you click Search:
http://img641.imageshack.us/img641/6894/auctionsm.jpg

And, since I'm actually now CERTAIN you did not bother to read it... I'll post the portion you should have read.

Quote:

---

#These are the settings in the Database:
#Each Auctionhouse has it's own set of these

MinItems = 0
#The Minimum number of items you want to keep in the auction houses.
#(default 0 - minimum will be the same as maximum).
#If it is higher than the value of the corresponding maxItems setting,
#it will be set down to match the maxItems setting.

MaxItems = 0
#The Maximum number of items you want to keep in the auction houses.

MinTime = 8
#The minimum number of hours for an auction.

MaxTime = 24
#The maximum number of hours for an auction.

#These must add up to 100 each one is the percentage
#of the auction items that should be trade goods of
#that quality. A value of 0 will disable.

PercentGreyTradeGoods = 0
PercentWhiteTradeGoods = 27
PercentGreenTradeGoods = 12
PercentBlueTradeGoods = 10
PercentPurpleTradeGoods = 1
PercentOrangeTradeGoods = 0
PercentYellowTradeGoods = 0

PercentGreyItems = 0
PercentWhiteItems = 10
PercentGreenItems = 30
PercentBlueItems = 8
PercentPurpleItems = 2
PercentOrangeItems = 0
PercentYellowItems = 0

#MinPrice(Color) is the minimum price adjustment for items. For example the default is 150, which means 150%. So if an item vendors for 1g it would go to auction for a minimum of 1.5g.
#MaxPrice(Color) is the maximum price adjustment for items.
#MinBidPrice(Color) these two control the starting bid as a percent of the buyout price. For example, if MinBidPrice is 30 and MaxBidPrice is 80 the starting bid for the auction will randomly be between 30-80% of the randomly chosen buyout price.
#MaxBidPrice(Color) these two control the starting bid as a percent of the buyout price. For example, if MinBidPrice is 30 and MaxBidPrice is 80 the starting bid for the auction will randomly be between 30-80% of the randomly chosen buyout price.
#MaxStack(Color) is maximum stack size to create for this quality type. A value of zero will disable the maximum stack size for this quality allowing the bot to create stacks (of random size) of items as big as the item type allows.

MinPriceGrey = 100
MaxPriceGrey = 150
MinBidPriceGrey = 70
MaxBidPriceGrey = 100
MaxStackGrey = 0
MinPriceWhite = 150
MaxPriceWhite = 250
MinBidPriceWhite = 70
MaxBidPriceWhite = 100
MaxStackWhite = 0
MinPriceGreen = 800
MaxPriceGreen = 1400
MinBidPriceGreen = 80
MaxBidPriceGreen = 100
MaxStackGreen = 3
MinPriceBlue = 1250
MaxPriceBlue = 1750
MinBidPriceBlue = 75
MaxBidPriceBlue = 100
MaxStackBlue = 2
MinPricePurple = 2250
MaxPricePurple = 4550
MinBidPricePurple = 80
MaxBidPricePurple = 100
MaxStackPurple = 1
MinPriceOrange = 4250
MaxPriceOrange = 5550
MinBidPriceOrange = 80
MaxBidPriceOrange = 100
MaxStackOrange = 0
MinPriceYellow = 5250
MaxPriceYellow = 6550
MinBidPriceYellow = 80
MaxBidPriceYellow = 100
MaxStackYellow = 0

#These are the multipliers that are applied to the vendor price for an item, that determines if AHBot will buy it or not.
#1 means AHBot will pay the same as (or less than) a vendor would pay, 2 means up to twice as much, etc.

BuyerPriceGrey = 1
BuyerPriceWhite = 1
BuyerPriceGreen = 5
BuyerPriceBlue = 12
BuyerPricePurple = 15
BuyerPriceOrange = 20
BuyerPriceYellow = 22

#BuyerBiddingInterval is the time (in minutes) between bids.
#BuyerBidsPerInterval is the number of bids the buyer will make in a cycle

BuyerBiddingInterval = 1
BuyerBidsPerInterval = 1



How to use ahcommands from the console (CLI) or in game with GM level 3 players:
ahbotoptions - will display usage instructions
ahbotoptions help - will display the list of commands

ahexpire - will expire all the auctions in the requested auction house that were created by AHBot.
minitems - will set the minimum number of items in the AH before it starts being filled again.
maxitems - will set the maximum number of items in the AH.
mintime - will set the minimum time (in hours) for auctions to expire.
maxtime - will set the maximum time (in hours) for auctions to expire.
percentages - will set the percentage of each quality in the AH
minprice - will set the minimum price multiplier for auctions.
maxprice - will set the maximum price multiplier for auctions.
minbidprice - will set the minimum starting bid as a percent of the buyout price for auctions.
maxbidprice - will set the maximum starting bid as a percent of the buyout price for auctions.
maxstack - will set the maximum number of items in stacks for auctions. 0 will set the maximum to the maximum for that item type.
buyerprice - will set the bid price multiplier for auctions.
biddinginterval - will set the number of minutes between bids on auctions.
bidsperinterval - will set the number of bids to enter per cycle.

The auction house IDs are:
2 - Alliance
6 - Horde
7 - Neutral

AHBot Originally made by Chris K.
Much thanks to Chris K, grether and Dolomit6!
AHBot Now includes AHBuyer created by Kerbe as a derivative of AHBot, and later modified by Paradox

---

Quote:

---

Originally Posted by CthulhuFtagn

So, when you click Search at the Armory, what happens?

If, and I'm assuming you didn't read, the ReadmeAHBOT.txt file in the Cumulative Update Pack you would set your min and max items for the Auction House...

Here's my settings:

Code:

---

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";
 
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";
 
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";

---

I put the Readme files there for a reason.

You should get something like this when you click Search:

And, since I'm actually now CERTAIN you did not bother to read it... I'll post the portion you should have read.

---

Jesus Christ! Dude, you are my GOD :D ... i told ya i'm a newbie and i need more thorough explaination :) THANKS MAN !

Not a problem, maybe that'll help others who couldn't get it started right.

@CT:

all updates injected successfully server and auctionhouse working great keep up your great work man its appreciated on this end much

Awesome GJ, I will.

MySQL is reporting that my creature_respawn table from mangos DB is marked as broken and needs to be fixed, so I was wondering can anyone who's creature_respawn table isn't broken dump their SQL and share it with me to fix this ?

In SQLYog, click on the creature_respawn table then click Tools > Table Diagnostics then click Repair

So the repack works just fine. For some reason my friend who has the server can log in just fine yet when i go to connect, i get stuck in a loop at the realm selection screen. what would cause this and how can we fix it? thanks

Just a tip with the AHBot - the default "minitems" setting in the SQL database is inadequate if you want it to be like the real servers. Hitting "search" will usually come up with no items - you have to check the individual item headings and you will find some items.

I set my "minitems" to 100,000 and now when I click 'search' heaps of items show up just like the real servers.

First of all let me say a huge thanks to you TRM for all of your hard work on the updates and your absolute unwavering patience with some of the people that post here. +rep

Secondly on a diff note work has picked up like crazy for me recently so I ain't getting a lot of time free at the moment but had free 30 mins or so this morning got caught up with this thread and the updates. All I have to say after reading through this is DAMN and you sir deserve a medal.:D

Quote:

---

Originally Posted by CthulhuFtagn

Not a problem, maybe that'll help others who couldn't get it started right.

---

i really hope on that :) +rep from me for the hard work what you doin and for your updates :)

Quote:

---

So the repack works just fine. For some reason my friend who has the server can log in just fine yet when i go to connect, i get stuck in a loop at the realm selection screen. what would cause this and how can we fix it? thanks

---

Read my posts careful and you will find the answer to your problem :) it was my problem too :) but this great guy fixed it ;)
Thanks CF

I know that maybe this is not the right place to post this but i wonder if anyone knows this problem...the icons for the money gold coins silver coins just disappeared and i only see the g and s and c anyone knows how to fix this...? first it was on one computer and now it changed from those to the other like in one i see the icons and the others i dont...lolol twilight zone...ohh and the repair dont do nothing...any ideas...?
Thanks

Attachment 450
Do you know what this error is...?? connection refused???

Apologies for the mis information. I didnt realise that BG's ensured there were enough players online before letting you join. I realised i didnt have the min player requirement. I just thought id sit in the queue for eternity. Apreciate all your work... Myself and a few friends from work get much enjoyment from the work you have done. Cheers

Quote:

---

Originally Posted by CthulhuFtagn

For some battlegrounds you can use the command

Code:

---

.debug bg on

---

to "fake" as if you have 40 on each side. I have a question for those who keep saying I have "this & that" bug; Are you REALLY sure you are doing it right? If someone posts "This battleground doesn't work." and yet only have 2 or 3 players on the realm, then OF COURSE the queue will not be full to start up the battleground.

For example, I've seen users tell me "Titan's Grip doesn't work", and yet, all they did was .learn 46917 the Titan's Grip spell and yet forgot that Titan's Grip works in conjunction with Dual Wield (.learn 674), if you don't know how something works DO NOT POST A BUG ABOUT IT.

You obviously did NOT "do all step by step" that I told you or it would work, as it is working on my realm as well as GranpaJohn's from what he tells me.

If I had a dollar for every time I've read "I followed what you said and it didn't work" I'd be a very rich man... just look at some of my past topics and see how many 'morons' posted about the SAME ERROR when all they had to do was make sure the Server folder was directly under the C: drive, and then how many times they said "Oh, I didn't see THAT part"... no, they chose NOT to read the directions.

Update Compiling:

Code:

---

MaNGOS updated to 10429 (required_10427_01_mangos_spell_proc_event)

---

---

Quote:

---

Originally Posted by calarus

So the repack works just fine. For some reason my friend who has the server can log in just fine yet when i go to connect, i get stuck in a loop at the realm selection screen. what would cause this and how can we fix it? thanks

---

Make sure you have the correct ports forwarded in your router; from what I've read if you DO then some ISPs won't allow port forwarding you'll have to use Hamachi... this is not the thread to ask, there are plenty of tutorials all around these forums for that. As far as I know, as long as you have the realmd databases' realmlist IP address set to your external address (or if you have a DNS server the DNS address) and your friends realmlist.wtf file is set to that external address as well with ports forwarded it WILL connect.

Quote:

---

Originally Posted by agamoose

First of all let me say a huge thanks to you TRM for all of your hard work on the updates and your absolute unwavering patience with some of the people that post here. +rep

Secondly on a diff note work has picked up like crazy for me recently so I ain't getting a lot of time free at the moment but had free 30 mins or so this morning got caught up with this thread and the updates. All I have to say after reading through this is DAMN and you sir deserve a medal.:D

---

Thanks brotherman.

Quote:

---

Originally Posted by Narcoleptic

Attachment 450
Do you know what this error is...?? connection refused???

---

Code:

---

SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)

---

is for the new LFG (PUG) system, I will suppress the error codes in the next release as it is simply looking for other realms and doesn't find any.

Quote:

---

Originally Posted by skiik

Apologies for the mis information. I didnt realise that BG's ensured there were enough players online before letting you join. I realised i didnt have the min player requirement. I just thought id sit in the queue for eternity. Apreciate all your work... Myself and a few friends from work get much enjoyment from the work you have done. Cheers

---

Not a problem dude, glad you guys/gals enjoy it.

Update Available:

Code:

---

MaNGOS updated to 10431
- Correcting issues with flying creatures falling to ground at death.
Removed un-needed check for SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)
Removed un-needed check for SESSION: recieved not allowed opcode CMSG_LFD_PARTY_LOCK_INFO_REQUEST (0x0371)

---

CU_0022.zip (12.96 MB)

Thank you so much for the new update ;) you´re my God now... :)

edit: is there a way to create a guild without the sign paper stuff?? like a GM command??

Code:

---

.guild create YOURTOONSNAME "Guild name"

---

example:

Code:

---

.guild create Dreadbeard "Sons of Jorel"

---

Just Amazing...this guy should be president...

http://img547.imageshack.us/img547/3280/cthulhu.jpg

Quote:

---

Originally Posted by Narcoleptic

Read my posts careful and you will find the answer to your problem :) it was my problem too :) but this great guy fixed it ;)
Thanks CF

---

If i read your post right, your issue was for a LAN, not over the internet, if I'm wrong feel free to correct me. Though if I was right, there's a difference between connecting via LAN and connecting via the net.

Yeah but the way to fix it its the same :) i had this problem a long time but this great friend told me the only thing i need to hear...how to edit your realmlist :) after that you just need to enter the IP or the name you made for the server and voilá :) your friends just have to modify their realmlist.wtf to the IP or name you made ;)

CF - that pic is just Great!! lolol hey do you know anything about that problem i ask of the money icons don´t showing right...? i can´t see the coins i only see g s c for the money...

Quote:

---

Originally Posted by calarus

If i read your post right, your issue was for a LAN, not over the internet, if I'm wrong feel free to correct me. Though if I was right, there's a difference between connecting via LAN and connecting via the net.

---

There really is no difference.
1. You forward the ports in your router (80, 3306, 3724, 8085)
http://www.abyssunderground.co.uk/im...forwarding.gif

2. You open the ports in your firewall
http://img841.imageshack.us/img841/4547/firewall.jpg

3. You change your realmd databases' realmlist IP address to your EXTERNAL IP Address or DNS address
http://img695.imageshack.us/img695/9297/53200148.jpg

4. You change the remote machine's realmlist.wtf file to reflect the hosts machines IP Address or DNS address

Code:

---

set realmlist notreal.no-ip.org
set patchlist notreal.no-ip.org
set realmlistbn ""
set portal us

---

5. You create an account for the remote user either by manually doing it or through the website provided
6. They login

It's the same thing for a LAN except that the EXTERNAL IP is changed to an INTERNAL IP.

Quote:

---

Originally Posted by Narcoleptic

CF - that pic is just Great!! lolol hey do you know anything about that problem i ask of the money icons don´t showing right...? i can´t see the coins i only see g s c for the money...

---

I've never seen that one before, have you cleared the Cache folder? I know you said you did a repair so that's out the window... is it interfering with gameplay at all? Could it be caused by an addon?

http://img42.imageshack.us/img42/7992/goldnr.jpg

It´s no problem but i just don´t like the look of that :( but no problem friend :)
I notice a bug in the pets (Hunter) the pet don´t get the stamina he should get...i have a character lvl 13 with a pet lvl 13 and in the stamina it says that should up the stamina of pet by 12 and when i go to the pet window i only see a +1 on the stamina...can you repair this or is those bugs that stick around...?
Thanks

Quote:

---

Originally Posted by CthulhuFtagn

There really is no difference.
1. You forward the ports in your router (80, 3306, 3724, 8085)
http://www.abyssunderground.co.uk/im...forwarding.gif

2. You open the ports in your firewall
http://img841.imageshack.us/img841/4547/firewall.jpg

3. You change your realmd databases' realmlist IP address to your EXTERNAL IP Address or DNS address
http://img695.imageshack.us/img695/9297/53200148.jpg

4. You change the remote machine's realmlist.wtf file to reflect the hosts machines IP Address or DNS address

Code:

---

set realmlist notreal.no-ip.org
set patchlist notreal.no-ip.org
set realmlistbn ""
set portal us

---

5. You create an account for the remote user either by manually doing it or through the website provided
6. They login

It's the same thing for a LAN except that the EXTERNAL IP is changed to an INTERNAL IP.

---

Hmm, his config looks exactly like what you are showing except he's not using zone alarm. his firewall is just the windows firewall and he's got that disabled as well as the one on his router. His isp said they do not block the 4 ports required to connect. *bangs head agaisnt wall* We tried a website that checks to see if ports are blocked and it gives us an error saying it cannot connect to the service.

Quote:

---

Originally Posted by CthulhuFtagn

I've never seen that one before, have you cleared the Cache folder? I know you said you did a repair so that's out the window... is it interfering with gameplay at all? Could it be caused by an addon?

http://img42.imageshack.us/img42/7992/goldnr.jpg

---

DUH!! i solved the problem...on display uncheck the Colorblind mode and you will see all the stuff again :)

And about the pet problem do you know anything about it...? :)
Hugs

I may have found a patch that fixes it, I'll implement and test it before next release.

Okey man ... i've got some errors when my mangosd.exe loaded
Check out:

Code:

---

SD2: Loading C++ scripts
============================================== 100%
SD2: Script registering but ScriptName boss_archaedas is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName mob_archaeras_add is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName event_spell_altar_boss_aggro is not assigned in database. Script will not be used.
SD2: Script registering but scriptName instance_onyxias_lair is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName npc_kroshius is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName npc_barrett_ramsey is not assigne in database. Script will not be used.
SD2: Script registering but ScriptName mob_parasitic_shadowfiend is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName mob_shadowy_construct is not assigned in database. Script will not be used.
>>Loaded 835 C++ Scripts.

---

if i see other errors i'll post it :)

Will be fixed in next release.

Quote:

---

Originally Posted by CthulhuFtagn

Will be fixed in next release.

---

Man, you are just a Machine for fixing (BOW) amazing... thanks alot...

Try this to get rid of the bulk of those errors, for now. I'll also add this to the next release:

Code:

---

/* Archaedas */
UPDATE creature_template SET ScriptName = "boss_archaedas" WHERE entry = "2748";
/* Kroshius */
UPDATE creature_template SET ScriptName = "npc_kroshius" WHERE entry = "14467";
/* Barrett Ramsey */
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "34816";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35909";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35895";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35771";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35770";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35035";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35766";
/* Parasitic Shadowfiend */
UPDATE creature_template SET ScriptName = "mob_parasitic_shadowfiend" WHERE entry = "23498";
/* Shadowy Construct */
UPDATE creature_template SET ScriptName = "mob_shadowy_construct" WHERE entry = "23111";

---

I will also be consolidating the SQL updates into one big file (example: mangos_all.sql), this will contain all of the cumulative update SQLs for that database, only use this if you are re-downloading the repack to get up-to-date.

Quote:

---

Originally Posted by CthulhuFtagn

Try this to get rid of the bulk of those errors, for now. I'll also add this to the next release:

Code:

---

/* Archaedas */
UPDATE creature_template SET ScriptName = "boss_archaedas" WHERE entry = "2748";
/* Kroshius */
UPDATE creature_template SET ScriptName = "npc_kroshius" WHERE entry = "14467";
/* Barrett Ramsey */
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "34816";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35909";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35895";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35771";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35770";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35035";
UPDATE creature_template SET ScriptName = "npc_barrett_ramsey" WHERE entry = "35766";
/* Parasitic Shadowfiend */
UPDATE creature_template SET ScriptName = "mob_parasitic_shadowfiend" WHERE entry = "23498";
/* Shadowy Construct */
UPDATE creature_template SET ScriptName = "mob_shadowy_construct" WHERE entry = "23111";

---

I will also be consolidating the SQL updates into one big file (example: mangos_all.sql), this will contain all of the cumulative update SQLs for that database, only use this if you are re-downloading the repack to get up-to-date.

---

dude ... Have I told you that you are mildly speaking "unique" +rep
But these three are still here:

Code:

---

SD2: Script registering but ScriptName mob_archaeras_add is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName event_spell_altar_boss_aggro is not assigned in database. Script will not be used.
SD2: Script registering but scriptName instance_onyxias_lair is not assigned in database. Script will not be used.

---

and now i've got one more but these was on the last lines on my cmd (mangosd.exe):

Code:

---

Delete Gameobject (Entry: 31442 Guid: 200002) wotj SpellId 818 LinkedGo 0 that lost references to owner Player Griggs (Guid: 11) Go list. Crash possible later.
Delete Gameobject (Entry: 29784 Guid: 200001) with SpellId 818 LinkedGo 31442 that lost references to owner Player Griggs (Guid: 11) Go list. Crash possible later.

---

<-- this is from my normally character... without GM level.... i see that before save and shutdown the server for update...
And Friend... i've another question When you start your mangosd.exe , do you get any errors ?

:) and btw the last part of the quests on the Blood Elf Pally's for spell "Redemption" doesn't work ? "Redeeming the Dead" (q9685)
thanks for the patient and thank you in advance

I found this interesting post. Is this an accurate indication of whats working and whats not for this prepack too?

ACID and SD2 Development - Advanced Script Progress Tracking - SD2 Forum

Quote:

---

Originally Posted by Stefan30

dude ... Have I told you that you are mildly speaking "unique" +rep
But these three are still here:

Code:

---

SD2: Script registering but ScriptName mob_archaeras_add is not assigned in database. Script will not be used.
SD2: Script registering but ScriptName event_spell_altar_boss_aggro is not assigned in database. Script will not be used.
SD2: Script registering but scriptName instance_onyxias_lair is not assigned in database. Script will not be used.

---

and now i've got one more but these was on the last lines on my cmd (mangosd.exe):

Code:

---

Delete Gameobject (Entry: 31442 Guid: 200002) wotj SpellId 818 LinkedGo 0 that lost references to owner Player Griggs (Guid: 11) Go list. Crash possible later.
Delete Gameobject (Entry: 29784 Guid: 200001) with SpellId 818 LinkedGo 31442 that lost references to owner Player Griggs (Guid: 11) Go list. Crash possible later.

---

<-- this is from my normally character... without GM level.... i see that before save and shutdown the server for update...
And Friend... i've another question When you start your mangosd.exe , do you get any errors ?

:) and btw the last part of the quests on the Blood Elf Pally's for spell "Redemption" doesn't work ? "Redeeming the Dead" (q9685)
thanks for the patient and thank you in advance

---

I only get the three SD2 'errors' when I start mine. As I said above:

Quote:

---

... bulk of those errors

---

I do not get Delete GameObject errors at all. How are you shutting down your server?

Quote:

---

Originally Posted by skiik

I found this interesting post. Is this an accurate indication of whats working and whats not for this prepack too?

ACID and SD2 Development - Advanced Script Progress Tracking - SD2 Forum

---

That post was last edited in March, so no, it does not represent what is working or not.

Was thinking maybe i could start contributing in small ways like trying to find fixes to bugs so you wont have to go digging.

I found this post re: the death knight bug that might be worth trying out. Let me know if it proves useful and whether me doing some investigation provides any use to you.
mangos > the free, open source World of Warcraft server

Cheers

Quote:

---

Originally Posted by skiik

Has anyone tried to start a death knight. Seems one of the chain quests does not work "Death Comes From On High". Anyone know if death knight is playable on private server and how do i get past the quest where i have to control the ball and fly into the town below.

Thanks in advance

---

As I already have an account on both the MaNGOS and SD2 forums it is redundant for you to do searches for me, but thank you for trying. I have a long list of 'errors' that I am currently working on fixing.

Found this fix? for Armor Vellums not working with enchanting?
mangos > the free, open source World of Warcraft server

Quote:

---

Originally Posted by skiik

I thought id make a list fo bugs ive found so far from my travels in azeroth. Not sure what is fixable and whats not but ill list them anyway and update them as i find more

• Shaman EarthBind totem does not slow mobs when running away and dropping one as you run(i think the issue is around when it procs. On blizz wow server it procs on drop so you get to run away and avoid death)
• Death Knight quest "Death Comes From On High" cannot be completed as you cannot control the eye
• Armor Vellums cannot be used for enchanting.(More info here https://mangos.lighthouseapp.com/pro...g-enchantments)

Ill add to the list as i find more

Cheers

---

If you are going to ignore my posts, and continue to post things I already have access to you will be removed from posting here... just a heads up.