g1bb0n

Yeah my wife accidentally used .learn all, and her spellbook was so junked up. Then she tried to remove all her spells, but she used .reset, rather than .unlearn. I think she used .reset all. This all happened while I was at work. I think I just fixed it with the following sql command: UPDATE characters SET at_login="0" WHERE at_login="6" I used 6 because it was a combination of the bitmasks 2 and 4, which according to that wiki, described the symptoms perfectly (talents and spells). Now I just need a way to delete all the mail I sent, which was supposed to be compensation, but is no longer needed! Is there an ingame command to delete mail from someone, or is that an sql edit as well? OK, I removed the mass mail with this: DELETE FROM mail WHERE sender="27"; Looking at the tables, I noticed my GM was sender 27. OMG huge sigh of relief here!

Awesome! I knew it wasn't too late. Is there a way to set this value to 0 on all characters in a short way? Or would I need to edit each sql entry manually?

So is there a way to undo a .reset command? Since it is at next character login, is there a way to prevent the damage to those characters who have not logged in yet?

Lillecarl, it is the first setup. Neither of the two connecting computers are on the server network. I dont have a hosting service, its just a seperate internet connection that I use for servers away from home (ssh for learning bash scrupting and stuff). I have already set my local IP accordingly in realmd.sql and have successfully connected over the net , showing i have forwarde the ports correctly. Since neither player account cant connect from one of the computers, maybe the fault lies with that client computer.

I am trying to connect from two different computers behind the same router (not on the servers network), and one of them connects fine from one computer but the other one doesn't. Is there a limit on how many users can connect from the same IP? I've looked at router settings, disabled firewalls, and tried all I can think of on the client ends. Does Mangos limit connections bt IP as a security feature or something?

I purged mysql-server from my system for a fresh start. So then what is happening when I try to import create_mysql.sql with this syntax: mysql -uroot -ppassword < create_mysql.sql and it gives the error: ERROR 1044 (42000) at line 1: Access denied for user 'root'@'localhost' to database 'mangos' Why is root unable to have access to something? it doesn't make any sense.

I did read through the README that the database comes with. It just says to edit mysql_info, then run mysql_import, which is what I did. The installation procedures that come with the server and the database are vague, making it difficult to follow unless you already know exactly what to do. That's probably one of the reasons there are so many different guides floating around... because there is an evident need for them.

My server compiled correctly, I have my maps/vmaps/dbc folders setup, but importing the database into mysql seems to be the one part I can't get right. I think this is why I can never get any npc's or monsters in my world. I have the mangos-zero database via "git clone git://github.com/mangos-zero/database", but unsure of what to do from there. Does anyone know what editing needs to be done to these files? Or any guide out there that works with the latest database? Seems like changing the user:password in the mysql_info file, and then running mysql_import, should be all I need to do, but that didn't work at all. It seems like the sql's that come in the server/sql folder, and the sql's that come in the database use completely different settings. Is there no consolidation for these database files? It just seems to mess everything up when I import, because it's always telling my root user that access is denied for such-and-such database. Which is odd considering it is a ROOT user, and I did specify root under the mysql_info file. I've learned a lot just getting to this point, but mysql is kicking my butt!

I just figured it out for those having problems. I was using extractor tools I found linked on the internet (it seems not many people run 1.12 servers, so the only tools you can find are for TBC and up). I couldn't find where to get the tools needed, but realized they come packaged in the Mangoz-Zero server files in git. If you dig in the folders you find the proper ad.exe and vmapextract_v3 that you need. Now all I need is an updated Mangoz-Zero walkthrough for Linux, and I'm set.

I just tried that, but same error. It says "Could not open data directory for reading... aborting", but the Data directory is right there, "C:\\World of Warcraft\\Data". I am running the .bat from "C:\\World of Warcraft". I notice that the moment I run the .bat files, I get a Windows 7 error telling me that "vmapextract_v2.exe has stopped working", and the only option from there is to "Close program". I do notice however that my game folder and data folders show up as Read-Only in properties, so I thought maybe that is getting in the way.. but the read-only status keeps coming back the moment I give it write access.

Hi! I wish my first post could be helpful rather than seeming desperate.... but I am having problems extracting files for a 1.12.1 server. I ran ad.exe from within the "C:\\Program Files(x86)\\World of Warcraft\\" folder (a 1.12.1 installation), and from that I received a maps folder with 2429 files, and a dbc folder with 158 files. I'm assuming that's all I need as far as maps and dbc files go. But I seem to be having a hard time getting any vmaps. I ran the makevmaps_SIMPLE.bat and the 'make vmaps.bat' files in the root WoW folder and I just get errors about there being no locales found. The version is vmapextract_v2.exe. Maybe this one doesn't work with 1.12.1? I'm not sure if that's the case. Does anyone have any ideas or another version they think will be able to extract vmaps?