rilex

vladonix, can you PM me? Looks like your PM is disabled.

More updates in 34465. Converted CharacterInventory.aspx to a ListView. Fixed some other ListViews that didn't show the sort arrow on sorting.

Bump for an update. Patch 3.2.2a is now supported! I've posted 0.82-dev for those that do not want to compile their own. This release includes a full version of the micromanager database.

For those using a previous revision, changeset 34444 supports 3.2.2a. Note that this release includes a full version of the micromanager database or you can simply apply 2009-10-06_offset_322.sql to your existing micromanager database. For those who imported the micromanager database from 34247, please note that the database was misnamed in my MySQL dump. It was dumped as "micromanager_en-US". It should just be named "micromanager", so please make sure to rename your database in MySQL.

Once you've installed the new version or have imported the offset_322 table, go to Tools -> Setup and change the Client Patch Level to 3.2.2a and you should be all set!

34444 also makes a minor correction to CharacterReputation.aspx and changes CharacterQuests.aspx to a ListView.

Wow, that was bad English

I've fixed those two issues and have added your Greek translation. Both are in 34374.

All of that looks correct (the NULLs are there because either they aren't used in MM yet, or you have filled in the fields). I'm not quite sure why it is failing, at this point. Can you attempt to save your settings and then check the Error Log for me again? Fill in all of the fields in Setup (even if they're dummy values).

If you haven't played with MySQL permissions and the password you used is correct in the web.config, then root should have full control.

Open up the micromanager database with SQLyog or what ever you use. Look at the 'configuration' table. Are there any values there? How about the 'globalconfiguration' table? In the 'globalconfiguration' table, there should be some default values (e.g. ID = 1, DefaultRealmID = 1...).

What rights in MySQL did you give the user in the web.config for the micromanager connection string?

Ingame mail is extremely risky so it isn't implemented. When it is implemented, it will only function while the realm is offline.

The only functionality requiring MaNGOS to be run as a Windows Service is the Tools -> Service Control page.

Yeah the user account is a PC admin and has all priviledges on the whole path (I even checked the files individually) . Yes I'm running the web server from the same machine mangos runs, launching μmanager in localhost.

I might have asked already, but what OS are you using? FYI setup instructions for IIS6 and 7 are here:

http://micromanager.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=24818

I don't have instructions for IIS5 or 7.5, but 7.5 should be identical to 7.

Would be nice, but I'd want it to update dynamically as it is done on the console. Someone could even take it as far as filtering for example battle messages from area updates/battleground resets etc to have an even better overview of what's going on. Another great feature would be a simple search function in both items list and game objects I could give you a hand with the SQLs if you want (ok I'll stop asking for more features now hehe).

Great program though

Search is coming, it needs to be done, just have to implement it. Understood about the console, but it would have be an RA session.

If you want to provide SQL queries for searching, feel free

rogermangos, can you try changeset 34332 to see if it resolves the below issue?

Yes, Please, I followed exact sql order as instructed above, I 'm able to get login screen, but when try to login i got this

Please sort out code version respect to sql version like udb did. Jumping here and there apply sql is really a pain in ass.

Does your user account running the Application Pool have access to that path? Is the mangos install on the same server as the web server (it doesn't have to be, but if it isn't, you have to use a UNC)?

Wouldn't that hide the console logs from me?

It would hide the console from you, yes. Currently the only thing microManager exposes are the crash logs and config files... Should be simple to set up one that exposes the console logs.

The paths are relative to the web server. So if you're running MaNGOS and the microManager on the same server, you would add:

C:\\mypath\\mangsod.conf (or use quotes if there are spaces)

Also, the user account running the Application Pool must have at least read access (if you want to view) or Modify access (if you want to be able to write) to the config files.

The user running the Application Pool also needs similar rights as a service, though off hand I forget what that is (although for testing purposes only, promoting the user to an administrator will work -- OR using the same user for the App Pool that you use to run the Mangos services). Of course, you need to set Mangos to run as a service

What kind of encoding does the DB need? I recall reading somewhere it needs some specific encoding, maybe that's why I'm having trouble.

Database is UTF8. See this for that particular error:

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

I think my Mysql.ini is set to 64M.

rogermangos, when I get home I'll fix that. We shouldn't be returning a string to an int.

A translation how-to is at:

http://micromanager.codeplex.com/Wiki/View.aspx?title=Creating%20Translations

34247 contains a packaged template database for what will be release 0.8. You can find it at:

\\MicroManager\\Setup\\Full_DB_0.8

This is for en-US (English) only -- I'm not an expert at any other languages This database will _DROP_ your existing microManager database and does NOT contain any new updates since the last SQL updates in 2009-07-11. I don't plan on making any changes between now and the release of 0.8.

I hope this works for you guys that were having trouble with all of the updates that have come out since 0.7.5.

I'll have to export a new base copy of the database to make it easier. Seems like that is a pain-point

Yep, I will.

You have to apply them in order of date. I think what I may do in the future is instead of seperating them out between folders, is to just append _en-US, _gr-GR, etc. to the file name.

By deleting:

rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/")

...you're not even opening the web.config file to get the connection string, so the browser will hang. There is something wrong with the way you pulled the project.

Cool...some day I'll get those SQL files sorted properly...

You shouldn't have any errors.

If you can start fresh on your MicroManager database, apply the following:

Extract:

\\Setup\\Full_DB_0.7.5\\en_US\\microManager_sql

microManager.sql will create the microManager database.

Then apply, in the following order (these are mixed between Global_Updates and the en_US folder):

2009-01-03_configuration.sql

2009-01-11_lookup_spellfilename.sql

2009-01-11_lookup_talent_spells.sql

2009-01-12_lookup_item_displayid.sql

2009-01-15_lookup_maps.sql

2009-02-24_configuration.sql

2009-03-05_configuration.sql

2009-03-28_configuration.sql

2009-03-28_globalconfiguration.sql

2009-04-04_acctunlock.sql

2009-04-04_globalconfiguration.sql

2009-4-27_expansion.sql

2009-06-10_offset_313.sql

2009-07-11_offset_313.sql

2009-07-11_lookup_allegiance.sql

2009-07-11_lookup_class.sql

2009-07-11_lookup_race.sql

2009-07-11_lookup_rank.sql

Shouldn't be a permissions issue -- your user account should have full control of the files in your Projects dir, and you have to run VS (you have SP1 installed, right?) as administrator (requirement for Vista, since you're debugging a project).

EDIT: You shouldn't have any errors in the Global_Updates directory, by the way. That only contains SQL files and no source files at all... You may be right, you may have a permissions issue if you're getting errors there.

Is the web.config located at the root of the web?

You need to run Visual Studio with an admin token, so right click on the VS icon and select Run as Administrator.

Is this while running the site via Visual Studio? If so, are you using VS on Vista, 2008, Win7, or 2008 R2?

The localization files are in /App_GlobalResources. Specifically, you'll want to make a copy of Resource.resx in the same folder with the LCID you want to translate for (e.g. Resource.de-DE.resx is German/Germany). A complete listing of LCIDs is at http://msdn.microsoft.com/en-us/library/0h88fahh(VS.85).aspx.