subhuman_bob

Umm... use the client??

Discussing the legality (or lack thereof) of databases is irrelevant at MaNGOS forum. As for the packet-sniffing brought up initially, all that Blizz can do is suspend or close your account. Violating their TOS != breaking the law. Monitoring traffic on your own LAN is not illegal. Examining data sent from your own PC to the internet is not illegal. You have the right to know exactly what data a program is sending from your computer to a remote computer. As much as Blizzard (and many other companies) would like to be able to legally prevent you from doing so, they can take no legal action.* * At least where I live. Contact a local lawyer to determine if this is the same where you live.

It depends on what they're doing. You should be able to find software that shows you how much network traffic is going to/from your computer. http://www.download3k.com/Network-tools/Network-monitoring/Download-Interface-Traffic-Indicator.html

Your answers lie here: http://www.scriptdev2.com/

What about it? Copyright law has nothing to do with me analyzing my network traffic.

You have a legal right- some might even say an obligation- to be aware of what data is being sent out over your internet connection. Notice that Blizzard does not threaten legal action for this, they threaten account suspension.

Now you're discussing content, which should be asked at your DB provider's forum.

Surely posting content at MaNGOS forums, and violating forum rules, will not fix it.

AFAIk a spell focus is a type=8 gameobject, not a creature. http://wiki.udbforums.org/index.php/Gameobject_template#type

Can't this be done as a switch? Ten "if(target->getRace() ==.....)" in a row has to be very inefficient.

You mean after Oracle acquires Sun, since Sun acquired MYSQL AB in Feb 2008. If you're concerned about this, you should also be concerned with PGSQL since Sun is currently a huge contributor to PGSQL. Personally, I think you're overreacting as Sun not supporting free software- even after it's acquired by another company- would be a huge change in their business strategy. You may as well claim that Java won't be available for free anymore.

My first response would be to this: First, perhaps you did make a donation. Let me enlighten you to the definition of donation: http://legal-dictionary.thefreedictionary.com/donation "DONATION, contracts. The act by which the owner of a thing, voluntarily transfers the title and possession of the same, from himself to another person, without any consideration; a gift" The key here is "without any consideration" meaing you get nothing out of it. If you were a contributor (which your current status does not reflect) that donation gives you no special favors or rights- by the simple definition of the word. http://www.thefreedictionary.com/donation <-- a donation is defined as a gift http://www.thefreedictionary.com/gift "1. Something that is bestowed voluntarily and without compensation." Now, on to your other complaints. MaNGOS Forums have never been the place for discussing content- which is what you're trying to do. I hold no special status here, but my personal opinion is that what you're trying to do does not belong on this forum. If those that administer MaNGOS Forums allow it to continue, that is of course their right. However, again in my opinion, you have no right to make demands of anyone. Typing in caps and red doesn't change forum policy.

As someone who received a ban warning here for discussing this topic several years ago, I would suggest that people tread carefully.

You trade more CPU processing time for smaller packets. Whether this will help or hurt depends on the source of your latency. If you have latency due to network congestion, higher compression may help. If you have latency due to processor congestion, lower compression may help. Note that it's also possible to trade one sort of latency for another (for example, to lose network latency but gain processing latency) and work out to no change. Also keep in mind that latency will always be higher than the round-trip ping from client to server. ping+processing time=latency In most cases, it is the router that is replying to a ping, not the actual server. Factoring in that data to/from server has this extra hop involved (x2, once inbound and again outbound) means you should add a few milliseconds on to the "baseline" value.

The data blob changes faster than we can keep that page updated. Assume that it's not 100% correct. If you're looking for general info on the blob, the wiki is fine. However if you need specifics (what each value means, for example) then your only good source of info is the mangos source code.

instance_template

It requires a spell focus (type=8 gameobject). The spell focus is a gameobject that must be nearby in order for the spell to be cast. http://wiki.udbforums.org/index.php/Gameobject_template#type

Look closer at the mangosd.conf; options like max_overspeed_ping started out as part of anticheat patches, but were moved into the core when they developed fully.

http://wiki.udbforums.org/index.php/Gameobject_template#type meeting stones are type=23 gameobjects: GAMEOBJECT_TYPE_MEETINGSTONE = 23 * data0: minLevel * data1: maxLevel You can just modify them via DB if you like. update gameobject_template set data0=1, data1=80 where type=23;

Full of assumptions here, because I assumed you could see the links to Linux and OS X versions at the PG2 homepage. Do you expect me to embed three separate links in a forum post? At some point in time, you have to do a little looking yourself and not expect others to do it all for you.

I understand. Sometimes it's too hard to click on the link embedded in my previous post.

Ok, time to bump an old thread. My opinion here: Any method of IP banning/MAC blocking done by MaNGOS would be less effective than already-existing programs that do exactly this. First, many routers can do this. Second, your firewall should be able to do this. Third, there are already-existing applications (such as PG2) that already do this.

This actually may not be a complete waste of resources. We're not positive about how the official loot system works; it's quite possible for example that in an instance one random trash mob will drop an epic item. In a condition such as this, loot would have to be generated "ass soon as you step into an instance" and it would mean that our loot system (and DB values) would need a total rewrite.

Jolan, don't take my post the wrong way. I did not mean to be negative about the work that is being done at all. The first step is to make it work- you're on your way to that point. After it works, no doubt many improvements to speed and memory usage will be found. The entire reason for my post was because I have no doubts that very soon we'll be hearing "Why isn't this committed?" "Can a dev commit this?" "I want to use this NOW!!!" etc, etc

Best repack ever available here!