- MaNGOS ~Amber~ Releases 3.x.x

[Arsham]

SQL Error: Table 'characters.auctionhouse' doesn't exist at C:\MaNGOS\miniServer\www\core\class.auth.php line 125
Array
(
[code] => 1146
[message] => Table 'characters.auctionhouse' doesn't exist
[query] => SELECT count(*) FROM pms WHERE owner_id='12' AND showed=0
[context] => C:\MaNGOS\miniServer\www\core\class.auth.php line 125
)


Any ideas on this error for the Auction house on the MangOs web? please reply or add me to MSN gnrsamp@hotmail.com

[Peanut1337]

so say i want to make a few adjustments to ulduar but first i need to make a backup (of just that dungeon) where does one find these files, also are they the same as the ones to edit to make the changes? this dump will it contain all the mobs/bosses in the dump or do i need to backup something else if you can help me either add me on msn Mannell_9@hotmail.com or just email me as i do not check these forums enough to see a reply in time also is there like a guide to all editing in SQL for this server if so send it as a link to my email (even if its just where to find the files for things i am ok with the editing of things just dunno where to find them and gamble on finding them most of the time) and last but not least say i want to host the server over my internet to some friends but not to the world (sql also but not needed to be shared) how would one do this please dont reply here please reply to my email address as thats the way i will see it

[raeef]

best repack ever dont stop your work plz make the best cata mangos repack

i love mangos mangos is my best core and your repack is the best repack

plz dont stop

[Argordon]

You [are] correct in your assumption that i'm getting bored, mainly due to the creeping feeling that were being kept on a treadmill, I've been doing this long enough now that I've seen the devs modify the core resulting in a breakdown of the patches that bring the project closer to completion for a given version twice. First time you go with the necessary to take it forward line, second time leaves me wondering wtf...

Nvm I have the patience to watch it happen one more time...that may take it into 4.x.x hopefully.

I will make the src code available for the project anyway when I finally step off for a savvy user to base a new project on.

Shiva,... I am certain that I speak for many when I say that your work on this project has been amazing and of a high calibre. It is not unusual for anyone to get bored with a never-ending task, though. Blizzard is a business, and they make their own paying customers run on a treadmill as well... Regular updates, changes, etc are all designed to keep their business interest strong and profitable... So it is not surprising that you have become aware of being trapped on a treadmill.

The things you can do to stay motivated:

1. Get a solid team together to share work (as I am sure you already do),

2. Create a way to accept compensation for your efforts (a little monetary reward helps ease the pain for all the work that you put in to get these repacks working - donations are good & voluntary),

3. Mentor a replacement for yourself. Like in the movies, it is always good to have a burnt out old genius/expert (like yourself now) mentor a younger up-and-comer to take over the crown... There has to be someone in your circle of friends that you can train and start handing over things. Your role becomes more of a 'Yoda' guiding the process of making and realizing the project goals, while the more mundane challenges are passed to your 'Padawan.' It is all about continuity...

4. Finally,... you have loyal follwers. You earned loyalty and respect from many of the posters here. It is a small window of fame... but it is YOUR small window. Run with it.

I look forward to supporting your endeavours to put out a 4.x.x version. I would be happy to contribute in some way if you pursue this further.

[felixx89]

if there is any way for me to contribute to this, i would gladly help out. This is byfar the best and stable server software i have encountered so far. Its very user friendly & im really looking forward for 4.x support. My biggest question is: If i would make my base in 3.x, will i be able to use it in 4.x? As the spawn position will probably be altered. If there is a way for me to contribute in either database or scripting add me on msn or send me an email: Felixx89@live.nl

Thank you again for this great software.

---------- Post added at 03:53 PM ---------- Previous post was at 03:35 PM ----------

.. Thank you Sir I wanted to start a server, but I do not know to script and fix the bugs... so, this means bye bye server There is no use to start a server, if you can not keep it in a good shape and offer to players what is best. Thank you very much. Cya mate

you sir need to wake up, there is no fully non-bugged server, dont disrespect people for their hard work its very rude.

[herneshadow]

We are all in your debt shiv. I have your last repack and i have been running a private server for me and my friends for almost a year not using your work.

(Have added a few quests and bits of equipment) I hope this is in the spirit with which you made the server. We all love it and the AH Bot is awesome and never misses a beat.

I would love to offer any help i can to any project you require help on. you can contact me on herneshadow@hotmail.com if you would like to task me with anything. I have a team of friends behind me who would also love to help.

In closing. Please dont give up.. you have made the best repack server i managed to find and trust me i looked and looked for a long time befor i found yours.

[kamenhr]

hi guys

I need some help, because my ahbot doesn't working

this is my setup :

AuctionHouseBot.Seller.Enabled = 1
AuctionHouseBot.Buyer.Enabled = 1
AuctionHouseBot.Name = "Actionbot"

AuctionHouseBot.Items.Vendor = 0
AuctionHouseBot.Items.Loot = 1
AuctionHouseBot.Items.Misc = 0

AuctionHouseBot.Items.ItemLevel.Min = 0
AuctionHouseBot.Items.ItemLevel.Max = 0
AuctionHouseBot.Items.ReqLevel.Min = 0
AuctionHouseBot.Items.ReqLevel.Max = 0
AuctionHouseBot.Items.ReqSkill.Min = 0
AuctionHouseBot.Items.ReqSkill.Max = 0

AuctionHouseBot.Tradegoods.ItemLevel.Min = 0
AuctionHouseBot.Tradegoods.ItemLevel.Max = 0
AuctionHouseBot.Tradegoods.ReqLevel.Min = 0
AuctionHouseBot.Tradegoods.ReqLevel.Max = 0
AuctionHouseBot.Tradegoods.ReqSkill.Min = 0
AuctionHouseBot.Tradegoods.ReqSkill.Max = 0

AuctionHouseBot.Bind.No = 1
AuctionHouseBot.Bind.Pickup = 0
AuctionHouseBot.Bind.Equip = 1
AuctionHouseBot.Bind.Use = 1
AuctionHouseBot.Bind.Quest = 0
AuctionHouseBot.ItemsPerCycle = 200
AuctionHouseBot.BuyPrice.Seller = 0
AuctionHouseBot.BuyPrice.Buyer = 0


but at the auction still empty :S:S

Hey everyone, it seems I have the same problem. At the bottom of the loading screen says there are loaded tons of items and that the AHBot is activated but when I log in there are no items in AH at all. Please someone help us out!

[yggdrazil]

Hey everyone, it seems I have the same problem. At the bottom of the loading screen says there are loaded tons of items and that the AHBot is activated but when I log in there are no items in AH at all. Please someone help us out!

You must Change the Min/Max Items in the Database.

[kamenhr]

You must Change the Min/Max Items in the Database.

   AuctionHouseBot.Items.ItemLevel.Min = 0
  AuctionHouseBot.Items.ItemLevel.Max = 0
  AuctionHouseBot.Items.ReqLevel.Min = 0
  AuctionHouseBot.Items.ReqLevel.Max = 0
  AuctionHouseBot.Items.ReqSkill.Min = 0
  AuctionHouseBot.Items.ReqSkill.Max = 0
  
  AuctionHouseBot.Tradegoods.ItemLevel.Min = 0
  AuctionHouseBot.Tradegoods.ItemLevel.Max = 0
  AuctionHouseBot.Tradegoods.ReqLevel.Min = 0
  AuctionHouseBot.Tradegoods.ReqLevel.Max = 0
  AuctionHouseBot.Tradegoods.ReqSkill.Min = 0
  AuctionHouseBot.Tradegoods.ReqSkill.Max = 0

You mean to change those numbers? I changed them, tried many combinations and still nothing. It says there are thousands of items loaded, still nothing. Can you specify to what numbers exactly I have to change these settings.

Thanks in advance!

EDIT: I got what you mean. Logged into Characters DB with SQLyog and edited the Min/Max number of items and now AH is populated with items. Thanks!

[ixoworda]

I get this error "Unhandled thread exception" whenever I try to create an Account using the GUI and I can't crate an Account using Navicat because the password column is Encrypted.I've searched the thread and found people that have had the same problem in the past and solved it themselves but they didn't have the common courtesy to post how they did it in case others ran into the same problem so help please?

I use Mangos 0.17.0 v10199 on a 3.3.5a client

[rzrgames]

Thanks guys!

[Darkicon]

I get this error "Unhandled thread exception" whenever I try to create an Account using the GUI and I can't crate an Account using Navicat because the password column is Encrypted.I've searched the thread and found people that have had the same problem in the past and solved it themselves but they didn't have the common courtesy to post how they did it in case others ran into the same problem so help please?

I use Mangos 0.17.0 v10199 on a 3.3.5a client

You can create an account in-game using the .account create username password command or whatever it is or simply make a new password encrypted in SHA1:

std::string AccountMgr::CalculateShaPassHash(std::string& name, std::string& password)
{
    Sha1Hash sha;
    sha.Initialize();
    sha.UpdateData(name);
    sha.UpdateData(":");
    sha.UpdateData(password);
    sha.Finalize();

    std::string encoded;
    hexEncodeByteArray(sha.GetDigest(), sha.GetLength(), encoded);

    return encoded;
}

[m3kara]

well nice reply

[ixoworda]

You can create an account in-game using the .account create username password command or whatever it is or simply make a new password encrypted in SHA1:

std::string AccountMgr::CalculateShaPassHash(std::string& name, std::string& password)
{
    Sha1Hash sha;
    sha.Initialize();
    sha.UpdateData(name);
    sha.UpdateData(":");
    sha.UpdateData(password);
    sha.Finalize();

    std::string encoded;
    hexEncodeByteArray(sha.GetDigest(), sha.GetLength(), encoded);

    return encoded;
}

Thank you for telling me how to make an encrypted password It seems the root of the problem for me is the email address some how because I went into navi cat and entered a email address in the empty line and Wah lah, No more error but If I create another account, I get it again until I enter a email address for that account as well so I dunno .

[HellCat_666]

Thank you for telling me how to make an encrypted password It seems the root of the problem for me is the email address some how because I went into navi cat and entered a email address in the empty line and Wah lah, No more error but If I create another account, I get it again until I enter a email address for that account as well so I dunno .

wel best you can do is get another registration page that uses emails as wel as only account and password so it wil auto insert it for you