Private server.. help? :p

[Zaye]

Hi there,

I am currently unable to access my WoW account so I was wondering if I could have some fun trying to be a GM in my own server.

Now, I have Mangos, the latest version. I already changed the .WTF file from set realmlist wow.logon etc. to "set realmlist "my internal IP 192.168.1.6"

But I'm still kind of clueless with what to do next. I've got

To view the content, you need to sign in or register

to help me a little bit but it doesn't explain what to do with mysql.

I already read throuhg the topics here so no need to link me, I just plainly don't get MysQL.

My msn is [email protected] so if anyone wants to help me out one time, it would be very appreciated.


Thanks in advance,

Martin
​

 

[THE_Wolfman]

You could use an editor for MySQL databases (like phpMyAdmin), or you can:

1. Change directory to the installation directory of your MySQL installation.
2. Create a text file and paste the following into it:

@echo off

set user=root
set pass=password
set host=localhost

mysql --host=%host% --user=%user% --password=%pass%

3. Rename the textfile to MySQL-Prompt.bat
4. Edit MySQL-Prompt.bat giving it proper 'set' values for your configuration.
5. Run MySQL-Prompt.bat
6. In the new prompt, type in each of the following lines, each followed by the enter key:

use realmd;
UPDATE `realmlist` SET `address` = '192.168.1.6' WHERE `id` =1 LIMIT 1 ;
\q

This will change the IP address in your realmlist table of the realmd database, to 192.168.1.6.

Keep the new batch file for later use in directly entering MySQL commands.

 

[Zaye]

Thanks alot for your detailed reply! But what directory do I need to change to my MysQL directory?

Thanks again!

 

[Zaye]

Dude... Is that like your standart answer or something?...

hehe, I don't pay attention to answers like the first reply in this topic. I already said that I had searched through many topics and that I am too much of a noob to understand.

I really need someone to help me on msn or something.

 

[Phoenixdk]

hehe, I don't pay attention to answers like the first reply in this topic. I already said that I had searched through many topics and that I am too much of a noob to understand.

I really need someone to help me on msn or something.

As for your problem.. You wrote that you used your internal IP... Is the server meant only for you to be GM?... Cause then you just need to set the ip to 127.0.0.1...
Still having problems.. PM me. And i

 

[Cobra101]

Now now boys and girls. lol. I do have to admit he's got a point. Forums are cluttered due to the lack of usage of that button. Heaven knows it's helped me a great deal. BUT, don't get all bent out of shape. Chances are they aren't totally blind and stupid, he did post a question. Which means you snapping at him isn't going to help.