subhuman_bob

And is there any program, which allows you to "see" maps?

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/

But what about copyright?

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

or the "sniffing" of packets for any reason

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.

You are not afraid of the police?

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

+ if(target->getRace() == RACE_HUMAN)

+ *data << uint32(1);

+ else if(target->getRace() == RACE_ORC)

+ *data << uint32(2);

+ else if(target->getRace() == RACE_DWARF)

+ *data << uint32(3);

+ else if(target->getRace() == RACE_NIGHTELF)

+ *data << uint32(4);

+ else if(target->getRace() == RACE_UNDEAD_PLAYER)

+ *data << uint32(5);

+ else if(target->getRace() == RACE_TAUREN)

+ *data << uint32(6);

+ else if(target->getRace() == RACE_GNOME)

+ *data << uint32(115);

+ else if(target->getRace() == RACE_TROLL)

+ *data << uint32(116);

+ else if(target->getRace() == RACE_BLOODELF)

+ *data << uint32(1610);

+ else if(target->getRace() == RACE_DRAENEI)

+ *data << uint32(1629);

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

But Ambal, After Oracle adquire Mysql, is very probable that dont continue free license.

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.

what would your responce be to it?

My first response would be to this:

I FEEL IT IS A RIGHT OF MINE AS A SUPPORTER OF MANGOS

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.

i cant find the post, but i beleive the issue is that editing the hosts file in this way causes the client to be "redirected" to another source for the news. This is expressley forbidden in the client EULA and ToU.

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

Compression - ? Not really sure what to say here for compression 1, 5 and 9. Will it create more latency when compressed? or will it create less?

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.

I used info gathered from the UDB wiki page

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

atleast we should add an anticheat which can be enabled through the config files. it should be disabled on a clean mangos source and can be enabled if wished.

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.

Yes, but not everyone has access to such tools.

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

I wouldn't mind IP range banning (for those who have dynamic IPs but limited to a small subset of IPs)

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.

As soon as you step into an instance, or a mob is created in the world, the loot that's going to drop has already been determined.

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.

you are right subhuman_bob, 5ms is slow; honestly I expected better results when I began this. I think (hope) there is room for optimisations.

if it cant be optimized, a thread is an option, even a separate server as long as the latency is low. data exchanges would be quite small.

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!