- MaNGOS ~Amber~ Releases 3.x.x

Quote:

---

Originally Posted by shivajiva101

Ok thats the update done as well...

FYI my laptop gpu failing is only half the story behind the delay in releasing. I needed to wait whilst the miniManager was updated due to the removal of the data blob field in the characters table. This has a knock-on effect for the website pages using the data blob as it contained gender,level,honor info etc.
Consequently I've removed the armory from the website and updated the code to reflect the changes to the data stores, it makes the website more usable for the repaq as its more managable to modify for major changes, reducing the timescale for producing releases affected by major database changes. Feel free to replace it with whatever floats your boat!

As the data on my laptop hd was intact the recovery process finally decided upon was to ghost the primary partition and convert this backup to a virtual machine, which is now running on my main pc...superb...all programs fully functional, db's intact etc..well worth the trawl/learning curve! Plus you get to take the backups you should have made to re-install from scratch. Recommend you try this when needed...

---

Just a quick note... I had been running version 3.3.2 for a few weeks now... it keeps blowing up my computer. I operate Windows 7 on a Intel Quad core 2.50GHz 64-bit operating system with 6GB of RAM... more then enough to handle this task of running a private server. I also do NOT have many other programs operating in the background as I was using this computer as my game server. Yet... each time I play WoW using Amber Mangos 3.3.2 the computer sounds like it is grinding away at the hard drive and the play time lasts about one hour only..then >POOF< the whole computer freezes and shuts down.

This did not occur on version 3.3.0 ... it also did not occur when I trialled an Arcemu server emulator. I have stripped everything out of my computer that I can.. and I trialled 3.3.2 again this morning to see how long it would work...Same thing... one hour and then >POOF< the system crashes. I checked the Server notes and this is all that it said (it lost the last hour of activity as I started playing around 6AM and it crashed at 7AM):

2010-04-25 05:58:15 AuctionHouseBot [AHBot-004-HotFix-07] is now loaded
2010-04-25 05:58:15 AuctionHouseBot updated by Naicisum (original by ChrisK and Paradox)
2010-04-25 05:58:15 AuctionHouseBot now includes AHBuyer by Kerbe and Paradox
2010-04-25 05:58:15 WORLD: World initialized
2010-04-25 05:58:15 SERVER STARTUP TIME: 0 minutes 59 seconds
2010-04-25 05:58:15
2010-04-25 05:58:15 mangosd process priority class set to HIGH
2010-04-25 05:58:15
2010-04-25 05:58:15 Starting up anti-freeze thread (30 seconds max stuck time)...
2010-04-25 05:59:50 ERROR:SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)
2010-04-25 06:00:02 GameEvent 14 "Fishing Extravaganza Announce" started.
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 42718 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 42719 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 42720 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 42721 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 42722 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 46242 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 46243 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 46244 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 46245 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:00:08 ERROR:WORLD: CMSG_ITEM_NAME_QUERY for item 46246 failed (item listed in Item.dbc but not exist in DB)
2010-04-25 06:02:23 ERROR:Creature 47640 (Entry: 17105) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.
2010-04-25 06:02:24 ERROR:SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)

So,... I put this up JUST IN CASE someone else is having the same issue. It may be a Windows 7 quirk... but it could be an issue with this version of Amber MaNGOS..not sure.. I just know that I can run 3.3.0 without trouble. Am gonna try 3.3.3a today and see what happens.

Spanish
------------------------------------------------------------------

Sigue estando bug las quest del dk, porque no se soluciona? que hace falta para solucionarlo? donde se puede buscar información sobre como solucionarlo? Alguien puede ayudarme sobre el tema? gracias.

English
------------------------------------------------------------------

It is still bug the quest of dk, because it is fixed? it takes
to solve it? where you can find information on how to fix it?
Can someone help on the subject? thanks

It Works! only one error - "SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)"

Hey guys, i've never used ambers repack before and am pretty new to it, so I have a few questions that I would like answers if thats not too much of a problem :D

I ran into a problem changing the password of root for my mysql database. I managed to do it using the mysqladmin.exe and using a few commands. I now have a password thats not amber, but now this brings a problem, whenever I use the amber GUI it says some mysql error in which i've attached the picture so you can see. I've changed all the passwords to match the one I changed my root password to, and yet it ambergui still doesnt want to work. amber.ini has the password and still no avail.

I think this also is leading to my problem with me not being able to connect to my realms too, so please if anyone knows why let me know :D

Ok try using GUI / Settings / MySQL / password textbox, type your new password and press enter, that should sort it out.

@Argordon - thats not normal behaviour for 3.3.2 server. Drive access should never grind unless the data being accessed is fragmented across the medium. Q. Do you run the servers in external or internal mode?

ahhhhhhhhhhhhh had to push enter hahahahahah!

Thanks shiva Is there a way to make it level past 80? Not sure how to do that. Do I have to make all the stats myself for it to recognize it?

Yup otherwise it would break the first time you messed with that field in the gui, all textbox settings are altered in the same way.

I know your new to this but have you looked in mangosd.conf ?
It contains the entry:
# MaxPlayerLevel
# Max level that can be reached by player for experience (in range from 1 to 100).
# Change not recommended
# Default: 80

Actually, yes I've changed it to 100 and tried other numbers but when I start mangosd it says something like must be between 1 and 80 using 80 as default, even if I change it in there...

So I dont know why its doing that any ideas?

oh btw while mangosd is running I get some error where it says:
worldsocket::handle_input_header: client sent malformed packet size = #### cmd = ##########

This is Shivajiva101 daily routine :)

3:00 p.m - get out of bed
3:05 - Chivas Regal Scotch with the morning papers,Dunhill cigarette
3:45 - cocaine
3:50 - Chivas,Dunhill
4:05 - first cup of coffee,Dunhill
4:15 - cocaine
4:16 - orange juice,Dunhill
4:30 - cocaine
4:54 - cocaine
5:05 - cocaine
5:11 - coffee,Dunhill
5:30 - more ice in Chivas
5:45 - cocaine
6:00 - grass to take the edge off
7:05 - Woody Creek tavern for lunch:Heineken,two margaritas,two cheeseburgers,two orders of fries,a plate of tomatoes,coleslaw,a taco salad,a double order of onion rings,carrot cake,ice cream,bean fritter,Dunhills,another Heineken,cocaine. for the ride home, a snow cone (a glass of shredded ice over which is poured three of four jiggers of Shivas)
9:00 - cocaine
10:00 - drops acid
11:00 - Chartreuse,cocaine,grass,Dunhills
11:30 - cocaine
Midnight - ready to program :)
12:05 - 6:00 a.m - Chartreuse,cocaine,grass,Chivas,coffee,Heineken,grapefruit,Dunhills,orange juice,gin
6:00 a.m - Hot Tub:Champagne,Dove Bars,fettucine Alfredo
8:00 a.m - Halcion
8:20 a.m - sleep

Thanks for the great work Shiv :wink:

Obviously Kubilius and I have the same daily routine but I manage 10 mins of coding a day instead of just 5! :w00t:

@pizzaman101 - In the interest of giving correct info I checked this out and your not wrong it seems mangos devs have it hard coded in the source using a value of 80 but it used to be 255! This is probably to stop errors with chars relating to >80 so Im not about to change it...

So basically, no more 255 support? :/

Oh well, I guess I can handle 80 until its changed.

Sorry :) Problem solved.

i will give it try man and tell you if something wrong with me

& but i want ask you for something

you looks like sound is gr8 so why you dont give a silkroad a try

we were long time ago keeping search about any thing emulator or server files .... etc whatever that can make silkroad work perfectly on the pc with out internet connection ( have no internet )

just man make a try about this and keep it up

am really waiting your words so hard ( i love this game )

Quote:

---

Originally Posted by shivajiva101

@Argordon - thats not normal behaviour for 3.3.2 server. Drive access should never grind unless the data being accessed is fragmented across the medium. Q. Do you run the servers in external or internal mode?

---

O.k., ... My computer is still crashing on me when I play 3.3.3a also.. BUT.. I think I know why now - there is a problem with my computer and the MySQL. Anytime I try to move or relocate or delete certain NPC's from the game to customize things... I keep blowing up the SQL database somehow and it jams and shuts down my whole computer. I have included a .jpg of the error message that now appears when I start the game. I am not sure why this has occured, but it is the activity that I was engaged in each time that things blew up.

Saturday, May 1
I reloaded the emulator (which cleared up the first error that is shown below in the jpg) but still ended up with the same problem. I am just running the server locally for my own use - realm is set to 127.0.0.1 . The game works magnificently and is pretty smooth but after a short period of time (this time I moved three creatures and deleted one at the Human start point) it still freezes my computer - not even giving me a warning message - just stops all functions and screen goes blank and the computer ceases to respond to anything (I have to hard boot it). So, the only changes I have made recently are: 1) updated my game server to version 3.3.2 and now..3.3.3a AND 2) I got a new computer to work as a server... a 'Gateway' running Windows 7 and I am using NETframeworks 4. I am wondering if maybe there is a problem with 64bit Windows 7 running this? Anyone else experiencing any trouble? I never had this happen before.

Sunday, May 2
O.k. I spent a little time trying to look over the mySQL error log... here is what it said:


100321 22:01:13 [Note] Event Scheduler: Purging the queue. 0 events
100321 22:01:13 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: Shutdown complete

100321 22:01:20 [Note] Plugin 'FEDERATED' is disabled.
100321 22:01:20 [Note] Plugin 'InnoDB' is disabled.
100321 22:01:20 [Note] Event Scheduler: Loaded 0 events
100321 22:01:20 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: ready for connections.
Version: '5.1.45-community' socket: '' port: 3308 MySQL Community Server (GPL)
100321 22:02:31 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: Normal shutdown

100321 22:02:31 [Note] Event Scheduler: Purging the queue. 0 events
100321 22:02:31 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: Shutdown complete

100321 22:02:31 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=38256648
read_buffer_size=65536
max_used_connections=1
max_threads=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 50791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
7D64F053 ntdll.dll!RtlValidateHeap()
7D628596 ntdll.dll!RtlCheckForOrphanedCriticalSections()
0067D540 mysqld-opt.exe!pthread_cond_timedwait()
558B51EC
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
100321 22:02:55 [Note] Plugin 'FEDERATED' is disabled.
100321 22:02:55 [Note] Plugin 'InnoDB' is disabled.
100321 22:02:55 [Note] Event Scheduler: Loaded 0 events
100321 22:02:55 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: ready for connections.
Version: '5.1.45-community' socket: '' port: 3308 MySQL Community Server (GPL)
100321 22:03:05 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: Normal shutdown

100321 22:03:05 [Note] Event Scheduler: Purging the queue. 0 events
100321 22:03:05 [Note] D:/miniServer/usr/local/mysql/bin/mysqld-opt.exe: Shutdown complete

100321 23:39:06 [Note] Plugin 'FEDERATED' is disabled.
100321 23:39:06 [Note] Plugin 'InnoDB' is disabled.
100321 23:39:07 [Note] Event Scheduler: Loaded 0 events
100321 23:39:07 [Note] D:\Amber_test_server\miniServer\usr\local\mysql\bin\mysqld-opt.exe: ready for connections.
Version: '5.1.45-community' socket: '' port: 3308 MySQL Community Server (GPL)

100501 20:20:36 [ERROR] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: Table '.\mangos\creature_respawn' is marked as crashed and should be repaired
100501 20:21:24 [ERROR] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: Table '.\mangos\creature_respawn' is marked as crashed and should be repaired
100501 20:21:24 [ERROR] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: Table '.\mangos\creature_respawn' is marked as crashed and should be repaired
100501 20:21:54 [ERROR] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: Table '.\mangos\creature_respawn' is marked as crashed and should be repaired
100501 20:21:54 [ERROR] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: Table '.\mangos\creature_respawn' is marked as crashed and should be repaired

Version: '5.1.45-community' socket: '' port: 3308 MySQL Community Server (GPL)
100502 7:47:41 [Note] Plugin 'FEDERATED' is disabled.
100502 7:47:41 [Note] Plugin 'InnoDB' is disabled.
100502 7:47:41 [Note] Event Scheduler: Loaded 0 events
100502 7:47:41 [Note] C:\MaNGOS\miniServer\usr\local\mysql\bin\mysqld-opt.exe: ready for connections.
Version: '5.1.45-community' socket: '' port: 3308 MySQL Community Server (GPL)
100502 7:48:56 [ERROR] Got error 127 when reading table '.\mangos\creature_respawn'

Just downloaded and installed. Very nice! Well done and keep up the good work.

Can I just ask if you will ever add a player Bot script of some kind?