<*sigh*> where to begin. First of all, never give a teenager L3 GM access to your server. If you fail to heed this advice, you will be here, in this forum asking this same question.
Yup, They set a lot of critters to level 1 so that they could kill them. (they didn't bother reading the Docs I sent them with all the commands.) and now I have slowly built up a LOT of database errors when loading the creatures that they are set MUCH too low in the HP area...no suprises there...so. without loading the whole thing from scratch, is there a 'quick-fix' for this, like runing the Arcane-Fire.bat again? Or a simple SQL command that I could import the creature database that came with Arcane-Fire?
Reloading creature tables.( How to... )
7 posts
-
Posted 1 year ago » Permalink
-
Yep, you should just do the database again, meaning just execute appropriate (for mangos database) .sql file (or you can do it through Arcane-Fire.bat, I guess there is an option to build the database). Or, if you're good in SQL, you can edit the existing .sql file and thus get to create new tables only related to creatures.
Posted 1 year ago » Permalink
-
Unfortunately there really is no simple way to fix this, personally I would simply back up your current database and re-install it from scratch. Then simply delete the characters, realmd & scriptdev2 folders from the fresh database and replace with your old ones. Unless you've made any changes in the mangos folder (custom items etc) in which case copy over everything bar the creature related tables. While you could simply rip the tables from the sql files and install them stand alone, you would also have to work out if any patches have been applied to the table after the core version has been installed, entirely possible but quite probably easier and quicker just to redo the lot.
Posted 1 year ago » Permalink
-
I'll give it a shot and see how it goes....after backing up some files.
Posted 1 year ago » Permalink
-
YES! Thank you both, it worked like a charm. backed up those 3 folders, backed up characters and database using A-F batch file...just in case, then did reinstall for A-F, then the A-F patch-up, then the bug fix.. all is good with the world once again.
Posted 1 year ago » Permalink
-
Have re-installed Arcane Fire base: Arcane Fire update : Arcane-Fire patch for creature database : and now.... well...
Okay, I'll admit it.. I was partly wrong. The REALMD and the MANGOSD both run fine without a problem. Have recreated my account in MANGOSD so I can log in, *however*, when I do log in, it says I'm connected to "MaNGOS" server, and not the name I am suposed to be connecting to, my private server name, that is, AND, once I create a character, it bumps me back to character creation screen and no characters are showing. Hmm.. I've looked through the install docs again, and at this point SHOULD be able to log right in and create characters and play on the server. So...what did I miss? Realmd.conf looks good, mangosd.conf looks good. Scriptdev2.conf looks good, my "hosts" file is still configured properly....at least I think since it shows my 192.168.x.x bound to the DynDNS I have registered. Not sure what I have messed up.
Posted 1 year ago » Permalink
-
It sounds like your realmd is the one created with the new install, not your previous version. The name for your server is stored in the realmlist table under realmd and shouldn't have changed if you were using your previous version of it.
Posted 1 year ago » Permalink
Reply
You must log in to post.