Printable View
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
:):
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
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
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.Quote:
Originally Posted by shivajiva101
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. :thumbup1:
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 ----------
you sir need to wake up, there is no fully non-bugged server, dont disrespect people for their hard work its very rude.Quote:
Originally Posted by catalin090
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.
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! :huh:Quote:
Originally Posted by balonyiadam
You must Change the Min/Max Items in the Database.Quote:
Originally Posted by kamenhr
Quote:
Originally Posted by yggdrazil
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.Code: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
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!
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
Thanks guys!
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:Quote:
Originally Posted by ixoworda
Code: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;
}
well nice reply
Thank you for telling me how to make an encrypted password :D: 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 :thumbup: but If I create another account, I get it again until I enter a email address for that account as well so I dunno :laugh:.Quote:
Originally Posted by Darkicon
Quote:
Originally Posted by ixoworda
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
Sad to say but looks like the amber projects are dead, no progress and no new releases in long long time.
Probably the author can give some details about the upcoming release or if is dead.
Well after waiting a year for a update I decided the project was dead so I updated the core & db and copied them into the amber dir.Quote:
Originally Posted by agua
The gui still works with no problems
I am now running mangos 11811 with the new 12,2 udb.
Hopefully shiva does do a full update but I would not hold my breath
I did the same ran in to a few problems but worked them out, I all so compiled the Skyfire build which is alive and kicking.Quote:
Originally Posted by nighthawk1000
man.. the server works.. the only problem is, i can't go to outland or northend cause it requires a TBC or WOTLK.. but i extracted everything from WOTLK client cause im playing a 3.3.5a server.. anyone has an idea?
Quote:
Originally Posted by scarface12
Change entry to your account GUID.Code:UPDATE realmd.account SET expansion = '2' WHERE entry = 1;
Quote:
Originally Posted by nighthawk1000
Hey Nighthawk1000 are you going to post your upgrade?:thumbup:
hi
nevermind this amber is fine woking on my sec comp from other it gave me lots err as was installing...
at last it works...
but auktionhouse(BOT) hade err in sql it no end with BOT just have del but now show me diff err
Array
(
[code] => 1054
[message] => Unknown column 'id' in 'field list'
[query] => SELECT count(*) FROM pms WHERE owner_id='1' AND showed=0
[context] => x:\xxxxxxx\xxxxxx\MaNGOS\miniServer\www\core\class.auth.php line 125
)
how do ifix this
YTDB 0.14.0 CS573 + MaNGOS 0.17.0 v10316-v10771 . Link downloads error .
pless help link for me
Hey guys, I just need some advice on setting this server up to have friends outside logging in. I can log in from my LAN no problem.
I followed the instructions in the /doc, and I'm still with no luck.
I'm running Win 7 64bit, closed my firewalls, opened ports in my router. I ran ( cports ), and they are open. I allowed all rules in the firewall setting in Win 7 just in case.
Ports that are open:
8085 TCP and UDP
3724 TCP and UDP
80 TCP and UDP
The only thing I changed as indicated in the /doc instructions is the:
- address in realmd db from 127.0.0.0 to blackrock.no-ip.info
- added these in the etc/hosts
<external IP> blackrock.no-ip.info
<Computer IP> blackrock.no-ip.info
I did not touch any settings in the following files that shows 127.0.0.1 because if I do, when I start Amber GUI, it just shuts down and says it cant connect to db.
Amber.ini
scriptdev2
realmd
mangosd
Have I missed something?
Update: From outside my network, I'm able to ping blackrock.no-ip.info.
Is there any update for YTDB 0.14.0 CS573 + MaNGOS 0.17.0 v10771???
Any YTDB 0.14.0 CS573 + MaNGOS 0.17.0 v10771-xxxxx?
or the version "YTDB 0.14.0 CS573 + MaNGOS 0.17.0 v10771" have all bugs / instances 100% finished?
Thx for this great emulator! is the best!