kageb0shi

Edit: I just looked at UDB forum and apparently they haven't updated anything in months, soooo I guess I just cant use mangos til they update... which sux. Either wait or go back to an older server core (I think im going to wait cuz I don't want to have two installs of wow on my computer just to use an old/supported core and db)... wondering why UDB is so far behind mangos team lol

no. you use UDB, and after you apply, FULL_DB, then the 382, you'll apply the sql updates from mangos/sql/updates and I have posted on this very thread about how to apply those updates. there are also many posts on UDB, because I have posted there, about applying UDB and updates. that there is db_version table for each database, and in that table there is a specific column you want to pay attention to, it is the far right column on that table.

you say you HAVE TO use the files in /sql/ folder correct?

i loaded everything from the udb server and its all working perfect and can connect fine.

if you only loaded it from UDB then you're missing out on some DB fixes which are contained in the mangos/sql folder.

I have a single question. The instructions tell me to move the exe files, dll files, and pdb files from the compile folder to the MaNGOS folder, but what is the difference between them? I have a single MaNGOS folder (with the little subfolders that Git made) that contains all the files already, nothing else. I don't know where I'm supposed to be moving them or whatever else it's telling me to do.

u move them to somewhere where you'll be placing your dbc and map files you don't want those things in your bin folder because you have to recompile mangos everytime you update and that bin folder is the result of the compile. I have my mangos launch directory at c:\\mangos\\

my dbc and map files are at c:\\mangos\\dbc and c:\\mangos\\maps

i did everything exactly the same as in the guide no errors no problems BUT when i try to login somewhere else that is not the server pc it says success! and nothing else happens if i clic cancel and i can see the realms then i clic on them and it says logging into the server but nothing happens i return after a few sec to the realmlist screen if i change the realmlist in the database to the local ip address of the pc 192.168.0.6 and change the realmlist.wtf to that same ip the it works BUT that will not work for the people that is trying to connect form outside of my network i also thought it was the ports so i changed it to DMZ to avoid any trouble but nothing yet

does anyone knows why it could be

please give me some hint idea w/e that will help me find out what is wrong...

thxs

read the FAQ which is linked in my signature, FAQ 5.b or 5.c. Also google realmlist loop.

perhaps look around the forums and you might find your answer. Pssst: It's called MangAdmin.

also it appears to occur with void walker.

There doesn't seem to be an "Open" option in the dialog box in C++ Express.

-Open Visual C++ and in the menu bar at the top, click "Tools" then Options

-Click the "+" next to Projects and Solutions, then click VC++ Directories

-Make sure the drop down menu days "Executable Files"

-Click the open button near the right of the dialog window, and make sure the path is:

There is the [...] box on each of the lines of text in the list, for example the first one "$(VcInstallDir)Bin". But if I'm supposed to alter one of those the guide doesn't say which.

Am I in the wrong menu? Wrong C++ Express version? I've followed the directions as closely as I can but there is no "Open" button in the dialog.

I just want to be able to roam around in WoW's scenery again every once in a while since I don't play any more .

no you're not altering any of them you're just confirming that your executable, include, and library files are where they are supposed to be. and usually they are. That step is just to make sure your developement environment is setup properly.

how about possibly navigation bar on top, or left, and perhaps link to twitter page, or perhaps throw in RSS feed somewhere. Just a couple of ideas to throw out there for consideration:)

How about a way to link current(latest) revision from github? Just have somewhere at top like "Latest Revision: xxxx "

other than that, it looks good and functional:)

Best repack ever available here!

perhaps refer it to that diablotail user who keeps spamming that his crappy repack realmd won't work. lol

perhaps remove the link the op posted to repack site? I know from experience links to repack sites aren't welcomed here:)

update your database:)

or type this in query editor

first confirm entry is in table

use mangos;
select * from creature_loot_template where entry=80000;

and

use mangos;
select * from creature_template where entry=80000;

next

use mangos;
delete from creature_loot_template where entry=80000;
delete from creature_template where entry=80000;

I have latest db and 80000 is not listed in creature_loot_template or creature_template. Apparently chickens are supposed to drop loot.

hmmmmm...db issue

pointers are much more efficient to move around.

function doSomething(Player thePlayer); // will copy the Player struct each time it is called, will delete it when it returns, will not modify the original Player if the function modify (or call a member function modifying) thePlayer

function doSomething(Player* thePlayer); // none of the above

so the second version is faster and use less memory.

ah I see. Instead of passing by value (which makes a copy if I understand it) it is actually passing the variable, so then the original variable is modified and not some copy. I see!

Thanks to you, and I would send you cookies if that was possible, solved all of my problems

good to hear:) I like oatmeal cookies

ok so i get everything fine and i connect to SQLyog and the get the DB up but realmd and mangos.exe open for a split second then close and i followed this exactly i have no idea whats wrong

also none of those sql updates work besides the mangos one...i just get errors for the realmd and characters

You will need to open a command prompt and browse to where the mangosd.exe is located and run it there. or if you have logging enabled, browse to your log files and look in them.

ah I see. Thank you so much for helping me understand that.

just as, for example

int a[5] = { 3, 4, 8, 9}

int b = 2;

int value = a;

value would equal 8.

I understand to a certain degree. Though I am certain a pointer is more complex than an array. I had not yet covered pointers in my C++ class. next semester i think I will see it.

I have a little bit of experience in C++, but evidently not enough. Digging around in Mangos source I keep seeing this operator(?)

->

context example:

                if(m_spellInfo->SpellIconID == 1648)        // Execute
               {
                   if(!m_targets.getUnitTarget() || m_targets.getUnitTarget()->GetHealth() > m_targets.getUnitTarget()->GetMaxHealth()*0.2)
                       return SPELL_FAILED_BAD_TARGETS;
               }

I recognize all the operators in that example, ! = NOT, || = OR, == equals to, > greater than, GetHealth() function, * multiply, ; end of statement, except I do not know what -> is

I have done google searches, but no relevant results.

That was just what I was talking about, but I am wondering in what order I would have to execute? In the guide it says that I have to do the blank ones from my SQL folder first, then download and update? But I am having problems with that

I have tried first executing the blank ones, then the 11.5 core from UDB, then all the updates from 11.5, but when I update I get errors. So as I said, my question is in what order should I execute sql's into the database?

You need blank sql files, then UDB CleanInstall, then UDB updates 380 and 381 files, then udb update file, then mangos\\sql\\updates. Pay attention to table db_version, last column says required_xxxx_xx_mangos/characters/realmd for each database. Each update sql file, 380, 381 and mangos\\sql\\update will change that column. You will see in sql files ALTER TABLE db_version CHANGE COLUMN required_xxx_xx_mangos...

realmd database has table realmd_db_version you apply xxxx_xx_realmd to that db

mangos db has table db_version you apply xxxx_xx_mangos... to that

characters has table characters_db_version and you apply xxxx_xx_characters updates to that

but keep an eye on that last column in that table and compare that number with the number on the name of sql update file. any sql update file that has number greater than the number in the column you need to apply in sequential order. Though, this is partially UDB related, so you should check out their forums. Look at the Resources thread which is linked in my signature.

Hello

After much work i got my server up and working, I can do everything on the server through my client (wich is on the same pc as the server). But when i try connect from a different pc it doesnt work. Either it says the Log in Server is Down or when i rester the Log in Server, a bunch of Html code comes up.

I have tried 127.0.0.1 and my own IP in the realmlist, config files (mangos + realmd) and db reamlist. I have tried different variations of them with no luck.

Any advice?

127.0.0.1 does nothing but loopback. No other computer will ever be able to connect to server if your using 127.0.0.1. Only time for 127.0.0.1 is in conf files. In database look at realmd in table realmlist. It will show mangos realm as id 1, you will see column name address. enter lan ip address there. also, for more info there is a sticky on this forum nameed hosting behind router. read up in there.

lol omg this thread is full of fun. a bumped necro'd thread that has nothing to do with mangos, or C/C++ for that matter...joy!

EDIT:

Nevermind, I found this on UDB forums:

In order to get from 0.11.0 (370) to 0.11.5 (371), apply these files:

* 371_corepatch_characters_7518_to_7681.sql <- apply to characters database

* 371_corepatch_realmd_7518_to_7681.sql <- apply to realmd database

* 371_corepatch_mangos_7518_to_7681.sql <- apply to mangos database

* 371_updatepack_mangos.sql <- apply to mangos database

These files are located in tags/0.11.0/Updates

Very freakin' logical / not.

its db related so you should post your query on udb's forums.

Not logical? Post your complaint on UDB's forums

"Same" what? I'm stuck there.

it means you're gonna create a total of 3 seperate databases and to follow same procedure for creating each database.

Adding Databases

-In the top left-hand side, right-click "root@(IP here)"

-Click "Create Database"

-For the database name type in "realmd"

-Do the same, except for two more databases named "mangos" and "characters"

Please i need help, i use mangos 7838 and psdb 208. I have a VPS in SiliconTower. I installed .net framework 3.5 and Visual c++ 2008 redistibutable x86. My vps is a Windows Server 2003 x64 and when i execute mangosd.exe i have the following error:

the VS C++ redistibutable package is if your running the mangos server on a different machine than you compiled it. And if you compiled mangos for x64 build than you should be using x64 C++ redistributable, not x86.

And you got this:

2009-06-30 08:08:03 Table `creature` have creature (GUID: 890015 Entry: 17830) with `creature_template`.`RegenHealth`=1 and low current health (1000), `creature_template`.`minhealth`=2400.

2009-06-30 08:08:40 >> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 3 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 6 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 30 (creature entry) not exist but used as loot id in DB.

2009-06-30 08:08:40 Table 'creature_loot_template' entry 36 (creature entry) not exist but used as loot id in DB....

which is a db problem and has nothing to do with mangos. mangos by itself, has empty databases. You will have to populate the databases from some other project(link in my signature), and if you are getting a problem related to a database then you need to post on that database project's forum, not on mangos forum.

same here lvl 23 pet raptor. The pet does not regen focus

Mangos 0.14.0 Rev 8090

UDB 0.11.5 (381)

edit: it appears to be sporadic and inconsistent when the focus does not regen.

what was it on D2 battleNet, you were considered a ghost if you died in hardcore mode? You should make it apply to lvl 50+. Make another realm for it and have the option to copy a character(s) over to it for the fun. Then upon death the player will never be able to res.

Medium level of newbness here. Have done arcemu not mangos. After reading the forums and placing my .conf, .exe and .dll files in the correct folder, the realmd.exe executes fine, but no go on the mangosd.exe

and what happens when you run mangosd.exe? does the console popup then disappears? if so where you placed the mangosd.exe there should be a logs directory. check that out and see what errors it shows.

One last thing, did you do the extract of the dbc files with ad.exe and copy the folder to the same directory you put .conf, .exe, and .dll? You did not mention you did that.

You really should look at UDB's forums. Basically you want to connect to your Mangos DB, look at table db_version, then look at column "required_xxxx_xx_mangos_xxxxx" the required_xxxx_xx will tell you what sql update to apply.