seanb

I used to do the same. My system hosted the SQL, the server, an HTTP server (windows apache), and i played wow on it. Had no problems, neither did the ~10 users connecting.

Years and years ago i was a Guide on Everquest. Back then it meant a lot more than it does now. We were mini GM's, in contact with the administration, etc etc.

Anyway, just before a very large expansion a player wrote in with a "suggestion". He was angry that all the servers were going to be taken down for 24 hours to apply the expansion. His message was something like this....

(keep in mind that at the time, there were 43 live servers and 2 test servers available to the public)

" I'm a server administrator, and i've found through experience that it's better to take servers offline 5-7 at a time, rather than you guys taking all 45 offline at the same time. It's more efficient that way"

Wow, did i want to reach out and smack this knowitall. He clearly was NOT a "server administrator", because if he'd had any experience with servers at all, he'd have known how much bullshit his suggestion was. Further to that, the 45 game servers were not represented by 45 physical machines. The 45 game servers were backed by more than 1000 physical machines. Some global, some individual, some purely redundant. It was near impossible to take "5-7 down at a time", because once you started updating the code, they simply could not talk to each other any more.

No, he's wondering if the auctionhouse could be run on a second server.

Temporary, you've written some amazing help posts. if it wasn't for several of them, i wouldn't be running my server the way it is today. I'm surprised you would ask this, but i'm happy to lend a hand.

If you are asking about the auction house BOT addon, which places and removes auctions randomly, simulating a bigger markeplace than is actually there, then i would suggest people remove the auctionhouse bot code when the server gets big enough that you don't need it. Problem solved.

if you are asking about the auctionhouse itself, it's just a simple query manager. It can't really create lag. The network traffic made by the auction house is minimal compared to even a simple combat.

As for running it on a second server, no, that's not exactly possible. However you could move your SQL server to a second machine.

both actually, i just wanted something rather simple to use as a starting point. I will give GaME a try.

In regards to the first post, is that all it takes to add more levels? Do i just need to make that one simple edit to enum AccountTypes? And in what file would i find that?

my subject pretty much sums up my question. Looks like umanager and minimanager are either dead, or i'm looking in the wrong places. at the osh.nu site, one of the most recent threads was a "is this project dead" thread. I installed minimanager but the latest version does not seem to work with 3.3.3a or 3.3.5 at all. Something wrong with the database as far as i can tell.

If there isn't another option, I would like to learn how to make my own tools, but i'm still a novice at php and sql. I'm learning, but i need somewhere to start from.

To start I want to make some tools to mess around with account creation, editing, password resets, etc. I'm trying to learn from minimanager. I've got login.php open, but it's waay over my head so far.

If there isn't another option, where should i start?

head back to the install support forum, and find the windows install guide by temporary. he does a much better job of answering this question than i could ever do.

Awesome information, more than i could find anywhere else!

oops doublepost

I've been running my Mangos server on my own computer for the past 5 weeks, but now i've bought a server computer, and i'm going to be migrating it to that system. It will be in a closet somewhere on a better line than i can provide it in my home.

I'm having a little trouble finding any documentation on remote tools though. I'l have a website set up in the next couple of days, so i'm going to write some php scripts to handle account management (since minimanager is outdated), but what i really need help understanding is SOAP, and Remote Access.

There are flags in the mangosd.conf file, but i'm not sure what they do, what software connects to them, etc. If i google "Mangos SOAP", i get a couple forum links, but that is it. Nothing helpful.

Can anyone point me to somewhere i can get more information, and maybe even some documentation?

I have a question that's related enough to not make another thread, but not enough that it wont seem like hijacking. Sorry

I've installed a couple patches. When i want to update (via git.gui) what happens when it wants to update a file i've made changes to?

So you wanna make an AI bot to fill out the ranks of an underpopulated PVP game?

Nope, I think you are on your own there.

I also prefer to do my patches by hand, but i havn't had time to learn the format of git code and figure out how yet

I don't doubt your code works fine, hopefully i can just get in my server!

I'l update if i figure out .patch file formats enough to make the change.

EDIT: Ahh, i think i get this. Thanks!

EDIT2: One thing i have found that needs fixing. For some reason in the group.cpp code, it's calling "UNIT_FIELD_FACTIONTEMPLA TE" instead of "UNIT_FIELD_FACTIONTEMPLATE" (notice the extra space making template templa te)

I've tried qgit, tortoise, and both are giving me an error at line 16. Has anyone successfully used the latest (june 9) version?

I copied all the updated text from the OP into a file called c:\\mangos\\faction.patch

then i did as you said, opened c:\\mangos in qgit, and went file>apply patch, and selected the patch. It asked me if i wanted to commit or just apply to working dir, which i said working dir.

it said "patch format detection failed"

i've tried renaming it as faction.diff and faction.eml and those don't work either.

Sorry, file moved

http://www.mediafire.com/file/lztwvbgyytt/dual.sql.rar

EDIT: It works! with one little hiccup. When i use .send items to give it to a player by mail, the icon shows up right in the mail slot, but when it's in their inventory, it shows as a red ? icon.

The scroll works to give them dual spec though!

I know this is probably the wrong place to ask this, but how the heck do you use it? I've got git gui, and i'm pretty sure this is a case where i'm supposed to commit something, but i'm stuck as to how to go about that.

That workaround is nice, but it causes problems on some servers.

what I plan to do, if i have time tonight, is make an item that requires lvl 40 to buy, binds on pickup, is unique 1, and has a right click effect that casts spell 63624 on the player. That will grant them dual spec. Also, it will cost 1000 gold with no faction discount. Then i'm going to add it to every bag vendor in the game (this is where i stick custom stuff i've made, since the bag vendors are generally empty anyway)

If anyone is energetic you might get this done before i get home. I imagine you could copy the template for any stat scroll in the game. The ones that give you int, stam, or whatever for 20-30 minutes.

EDIT: Did it, i think

K, the code box doesn't really allow me to show much off. The code boxes at the UDB forums are better.

basically I copied item 1180, the Scroll Of Stamina. I changed the price, level, unique, etc etc.

I'l reset my server when i get home and see if it works.

See if this works for you

http://www.mediafire.com/file/lztwvbgyytt/dual.sql.rar

NOTE! This file includes structure, of which you probably do not entirely need.

Yup, you've hit the nail on the head. I'm going to try that patch later today.

EDIT: Nope, see below

I've tried gametype 1 and 4, and in both cases the players can group up and fight together, but cannot heal or buff each other.

is there a gametype that allows 100% friendly interaction, at least inside groups?

Thanks.

i've seen it active on 3.3.3a servers, but alas, it's not available from trainers on my server either.

Would love an answer on this issue.

Trying to figure out what the dates are referencing in the DB. Sometimes there's an actual timestamp, but the majority of the time it appears to be a count after an epoch.

I'm using a windows system, so i'm thinking the standard would be Jan 1 1600, but the number is too small for that i think.

EDIT: I'm very sorry, my entire answer was meaningless because i thought you were asking about a completely different command

What i did was put my external ip (from whatismyip.com) in the realmlist database entry, then used my router to forward the port to MY IP.

Now both me (on the same computer as the server), my wife (on the lan), and my friends (from home) can all connect, with only one realmlist entry in the DB, and we all have the same realmlist.wtf file as well.

i wouldn't worry about it if everything works right. It's trying to delete an unnecessary table row, and not finding it.