Vault conversion

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 8:47 pm

The vault converter does not work for me. Is their any other web app or program I can download?

Post by **Geesu** » Mon Jul 25, 2005 8:51 pm

no let me look into fixing it, I've had to move my stuff around servers lately...

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 9:19 pm

Ok. When do you think it will be fixed?

Post by **Geesu** » Mon Jul 25, 2005 9:36 pm

ok give it a try now

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 9:38 pm

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '68.61.221.158' (10060) in D:\Websites\wc3mods.net\www\war3ft\vault.php on line 50
Could not connect : Can't connect to MySQL server on '68.61.221.158' (10060)

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 9:42 pm

If you've been moving ur stuff around servers, would the IP I have to allow to connect have changed?

Post by **Geesu** » Mon Jul 25, 2005 9:42 pm

do you have the port open on your server? You must allow my server access to yours...

Ping leapsmart.net, and allow that IP

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 9:49 pm

The IP I get from leapsmart is 209.213.115.9.
Ive forwarded all the ports from my router to the server.

Post by **Geesu** » Mon Jul 25, 2005 9:53 pm

no no.. you have to configure the username you're using... Like the MySQL username, does it allow connections from external hosts?

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:00 pm

Ive done it exactly how it says so in the mini how-to guide.

Post by **Geesu** » Mon Jul 25, 2005 10:02 pm

ok u might have to wait for a response from Lazarus, b/c I'm now confused, and I don't know mysql command-line stuff... I use phpmyadmin :/

Post by **Avanderik** » Mon Jul 25, 2005 10:03 pm

phpmyadmin saves a lot of time for sure!

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:08 pm

What does PHPMyAdmin do?
BTW does it have to do anything with the fact in my.ini I added bind-address=127.0.0.1?

Post by **Geesu** » Mon Jul 25, 2005 10:10 pm

yea I don't know what that means

Phpmyadmin is a web administration tool for mysql servers

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:11 pm

After removing the above, I get this:
Warning: mysql_connect() [function.mysql-connect]: Host '209.213.115.8' is not allowed to connect to this MySQL server in D:\Websites\wc3mods.net\www\war3ft\vault.php on line 50
Could not connect : Host '209.213.115.8' is not allowed to connect to this MySQL server

Ill add that ip and see if it works

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:16 pm

Did the above, and its some what working, by looking at the size of my amx mysql folder size changing...

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:17 pm

If my vault is over 1 meg, will the data table be the same size?

InfamousAngels · Post by **InfamousAngels** » Mon Jul 25, 2005 10:45 pm

It only did not even half of everyones xp

Post by **Lazarus Long** » Tue Jul 26, 2005 3:10 am

Hello, InfamousAngels:

Lets see if this can help.

One of your posts made me realize there is a missing step so temporary remove the "bind-address=127.0.0.1" from your my.ini file, after the conversion put it back (I'll update the HOWTO ASAP).

You followed the part of the MySQL for Warcraft 3 FT simple Mini-HOWTO regarding allowing access from the script, right? Now, since the servers went around, you will have to replace the following in the conversion section: wherever you find the IP 38.113.137.7 you will now replace it with the IP 209.213.115.8, wherever you find the domain name war3ft.com you will now replace it with the domain name leapsmart.net.

For future readers: This is a temporary fix until server location gets definitive so in future this might not apply anymore, when stable the correct IP and domain name will be put in the HOWTO.

You are behind a router/firewall right? That will be more difficult to set up since there are so many different ones with different configuration steps, but what you'll need to do is either put your game server temporary in the DMZ (or out of the firewall, or whatever your firewall calls it) or, if your firewall doesn't support DMZ, temporary port forward all ports to the game server IP. Got it? I'm sorry I can't be more specific with this but you get the idea.

I hope this helps,

InfamousAngels · Post by **InfamousAngels** » Tue Jul 26, 2005 3:36 am

Does the domain matter? I figured out the bind-address part, and changed the IP. I only added the IP for allowed access or w/e, and I did the conversion, and it seems it didnt get everyone, including me. Could that be related to not adding the domain address?

Post by **Lazarus Long** » Tue Jul 26, 2005 4:02 am

Hello, InfamousAngels:

InfamousAngels wrote:Does the domain matter? I figured out the bind-address part, and changed the IP. I only added the IP for allowed access or w/e, and I did the conversion, and it seems it didnt get everyone, including me. Could that be related to not adding the domain address?

No, it's just for sure, since it resolves to a different IP.

It failed the conversion? What do you mean it didn't get everyone? Names with spaces don't get converted, not with the Web Tool, those have to be by hand, but all others should.

Regards,

InfamousAngels · Post by **InfamousAngels** » Tue Jul 26, 2005 10:57 am

What I mean is, it says conversion successful, but not everyone got their XP back. I decided to tell the ppl that didnt get their XP that they ahve to start over.

Post by **Lazarus Long** » Tue Jul 26, 2005 11:11 am

InfamousAngels wrote:What I mean is, it says conversion successful, but not everyone got their XP back.

Shouldn't happen. How many lost their XP? Have any of them a space or the character " ' " in their name?

InfamousAngels · Post by **InfamousAngels** » Tue Jul 26, 2005 12:16 pm

IDK, and I dont really wanna check cus the vault is over 1.5 mb's. Alot of people lost XP in some races, not tottally. But its ok now, because everyone wants to "donate" to recive xp as a "gift" lol. Thanks for your help anyways though, without that guide I would never be able to do it