herrtrigger

Syntax: .reset stats [Playername] Resets(recalculate) all stats of the targeted player to their original VALUESat current level. & # CleanCharacterDB # Perform character db clean ups on start up # Default: 1 (Enable) # 0 (Disabled)

Well i tried around with a value of '10'. It also showed up ok in the client. But sometimes when i would refresh the ah listed items (ingame at auctioneer), it would get stuck (looked like it kept searching forever). The only thing helping to get the list again was to logout-login. But then after some more refreshes, it got stuck again. This is what happened in log at those times: 2010-06-01 21:30:13 ERROR:ERROR: Attempted to get in ByteBuffer (pos: 32 size: 46) value with size: 16 2010-06-01 21:30:13 ERROR:WorldSession::Update ByteBufferException occured while parsing a packet (opcode: 600) from client 192.168.30.2, accountid=23. 2010-06-01 21:30:49 ERROR:ERROR: Attempted to get in ByteBuffer (pos: 32 size: 46) value with size: 16 2010-06-01 21:30:49 ERROR:WorldSession::Update ByteBufferException occured while parsing a packet (opcode: 600) from client 192.168.30.2, accountid=23. 2010-06-01 21:31:11 ERROR:ERROR: Attempted to get in ByteBuffer (pos: 32 size: 46) value with size: 16 2010-06-01 21:31:11 ERROR:WorldSession::Update ByteBufferException occured while parsing a packet (opcode: 600) from client 192.168.30.2, accountid=23. 2010-06-01 21:32:17 ERROR:SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E) 2010-06-01 21:32:28 ERROR:ERROR: Attempted to get in ByteBuffer (pos: 32 size: 46) value with size: 16 2010-06-01 21:32:28 ERROR:WorldSession::Update ByteBufferException occured while parsing a packet (opcode: 600) from client 192.168.30.2, accountid=23. 2010-06-01 21:38:08 ERROR:ERROR: Attempted to get in ByteBuffer (pos: 32 size: 46) value with size: 16 2010-06-01 21:38:08 ERROR:WorldSession::Update ByteBufferException occured while parsing a packet (opcode: 600) from client 192.168.30.2, accountid=23. (i daily check logs and try to understand all errors/warnings. But i never saw those before, so i thought maybe worth mentioning)

Is Metallica still confirmed as closing act!? (bottom line: Just saying, congratulations and thanks to all that contribute to this amazing project & community. Cheers! )

I think they are referring to: http://github.com/mangos/mangos/commit/1d1ec20a02eccb9fb3fd43156146f7e71b482c19

http://github.com/mangos/mangos/commit/1d1ec20a02eccb9fb3fd43156146f7e71b482c19 Thank you!

Hunuza, that is just sounding awesome! Cheers & thx fellas.

Ok, thanks for the feedback guys. It's good to know where it originated from, and that the mentioned querry can be executed safely. Though, a question still remains: Since mangos maintains the character DB, shouldn't this querry be added to the sql-updates? -The skill, like mentioned here, doesn't exist anymore at all. -Characters-databases not having any guids with this skill, won't be hurt with running the querry. While (older) characters-databases that do have guids with this skill, will recieve a mini cleanup with running the querry, wich can only be a good thing imho.

I started using Mangos, UDB and SD2 (and eventAI/acid later) when the client was somewhere around 2.3.x. Think Mangos was around milestone 0.9 then if I remember correctly. Me and some 10-15 other accounts (family & friends) are still enjoying playing, and are very very thankfull to all that make this possible. I still have my very first realmd DB and character DB in use (dating +- 2 dec 2007). Now runing rev 9765 atm, always having applied sql updates along the way, with great care. (Big 'salute!' to you guys, since it shows that all realmd & characters sql-updates were/are nearly flawless! ) Not a single character on this server has ever had any gm-commands intervention in terms of stats/gear/spells/... . And core has never recieved any other patches than SD2. Yet is seems that some chars have some skills wich don't exist anymore. example: 2010-04-26 17:45:27 ERROR:Character 79 has skill 40 that does not exist. After checking here: http://wiki.udbforums.kicks-ass.net/index.php/SkillLine.dbc It indeed doesn't list 'skill 40' (I have no idea what 'skill 40' actually was) Some older(<-edit) chars do have these skills though in the DB, and one guid even learned it to max skill: http://img690.imageshack.us/img690/425/skill40.jpg Small possibility I missed an sql-update along the years, or one didn't get fully applied (but I think not (and hope not)). Should that not be the case, adding somethin like: DELETE FROM character_skills where skill=40; to the sql-updates of the char DB might be a good idea I think. Let alone for the long-time users who like to keep things clean. Cheers, Herr_Trigger

OT Tijd voor een ander inet abonnement dan.

... Soon™

Query's executed: 109441 Import Succesful 224298kb/224298kb Awesome!! Cheers & thanks Shadez!

First off, this is looking awesome. So I have been trying to get it running last night, but sadly I couldn't. The thing preventing me from being succesfull is purely my knowledge about sql. (complete noob, yet succeeded in getting MBA and mw-enh running before) So after googling all night yesterday i hope somebody would be so kind to show me some direction. Thing is I just can't get the huge sql file imported. (edit: talking about "wowarmory_rc1_r50.sql") Importing it with sqlyog ended up in the "Line no.:7758 Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes" error. Looking at your readme i fired up google and started searching. After tons of posts reading, I ended up adding these settings to the bottom of my "my.ini". max_allowed_packet=64M query_cache_size = 16M query_cache_limit = 2M max_connections=500 wait_timeout = 90 Restarted pc and tried again with sqlyog-> mysql crashed completely but got a lot further than before. So another pc restart. Opened up command line client and used: use [your database] source [path/to/file.sql] It started importing but after some time, again, mysql completely crashed. So I tried to overcome but i failed and i would really like to learn how to get it imported fine. Thanks in advance, [sCW]Hr_Trigger

Wonderfull guys. Cheers!

Posting working fine here. Great website btw.

Confirmed on 8802. Says 'need' in chat when u press X, but in fact it does 'pass'.

8745 compiled fine here, winxp 32bit, release.

Congratulations guys! And big cheers for making such awesomeness, time after time. [sCW]Hr_Trigger

Awesome

I liked it, witnessing it some days back..

lol n1! Have a wonderfull 2009 people!

Wonderfull, wonderfull work guys! Congratulations to each and all.