Spawning Guards?
 

Hello ladies and gents,

Could anyone tell me how to spawn guards that will attack mobs that are on the players if they run up to them? Like the guards in Gfay, Quey2, and various other newbie zones? Can this be done in-world or does it have to be done somewhere in the db?

Erb2k

To get Guards protecting you, you need to correct the faction tables correctly.

Guards and Faction Tables
 

Ah ok so that's a database thing and cannot be done in-game then? Ok, thanks for your time :-)

erb2k

Also, I was wondering if anyone out there might know something about an error while trying to source MW055_alpha_02.sql and doorupdate in mysql? I keep getting this error. The creator of the guide i'm using didnt know what to do about it.

Hope someone else might be able to help. Currently running from a pre-compiled db provided by the guide creator untill I can figgure the problem out, or find someone who knows what the problem is. All files have been downloaded and extracted into the mysql/bin folder, re-extracted, re-downloaded.... dont know what the deal is lol.

erb

Are you putting the sql file in your /bin folder?

You do NOT have to put the files in your bin directory. They have been harping everyone about that forever and ever. I have put my files into my root C: directory, opened up cmd, cd'ed to my C: root directory, opened up mysql from there, then typed source yadda yadda and it works. How it HAS to be is, which ever folder you open your MYSQL from, the source files MUST be in there with it.


So say you open up cmd, then type mysql to start mysql

what wil happen is if your using windows xp, cmd will open up and go into your basic directory just before your desktop (EX: C:\Documents and Settings\Username\)

What will happen is, when you source without switching directories, its going to look in that same folder for the source files. So make sure to open up mysql from your C:\mysql\bin or wherever you put your source files.

Course if you have a link to your mysql program that is resting where your source files are, you hve nothing to worry about. Just launch your link and go on as you normally would. The only problem then would be mis-spelling the name

Source Prob
 

Hey,

Yea the source files are in the mysql/bin folder and thats also where I open up mysql from too so I dont know what the deal is. I've followed the tutorial to a 'T' and it's still giving me that error. :-(


Also I downloaded a pre-compiled database and having a diffrent error on that one, it's saying that eq.variables not found. :-/ An answer to either of these problems would get my server up and running, so I hope someone can help :-) I used bluejam's tutorial at http://www.eqemulator.net/forums/vie...a44c640a432f38 so it should be working. I've read the replies to his tutorial and nobody else seems to be having these same errors :-(

Hope someone can help.

Erb2k

when you source in your database , are you letting it scroll / run all the way thru ... ?

sourcing
 

Yep I sit there and let it go through untill it starts giving me the eq.variables does not exist and once it hits that point it just keeps trying over and over again. I let it try with the same error about 8-9 times before I decided to just go and ask if anyone else has run into this problem.

LOL I think mysql hates me ;-)

Erb2k

Something diffrent
 

Hey I think I've worked through some of the issues I've been talking about, here's what I'm getting as of right now when I run world.exe

And the url it gives doesnt work. LOL I've tried that one before /cry
Anyone know what's going on with it this time? lol

Erb2k