Gabriele1021

50330 is now using a Visual Studio 2010 project, however it is still at .NET 3.5 SP1 (need to read some more about .NET 4 before upgrading the project).

50331 effectively disables Ingame Mail and Player Mail from functioning. Need to do this until I figure out how to display items properly with mail given the changes in 9692.

Nice to see that this project is still alive! Basically left my server high and dry, to fend for itself, until someone found out how to contact me about the lack of functionality on my website... Just so happens that I've been updating MaNGOS and completely forgetting about µManager... Nothing else to say except keep up the good work!

What do you guys think of this theme?

http://micromanager.codeplex.com/wikipage?title=SVN%20Project%20ScreeN%20Captures&referringTitle=Home

I Love it!!! :-P

In this thread? No, it doesn't. But you can click the > arrow under the Last Post column when you're looking at the forum.

Or, you could click the button w/ ">>last" button..?

Hey rilex, 'Dyou get that thing i sent ya? (heh, Hippo from Harvey Bird Man)

Did you see the Pm's i sent ya?

And thanx for the constant updates.

If you need the queries, you can always look at the MiniManager source. gen_lib.php has the information for the in-game mail.

However, it also has a note that you should only use in-game mail when the server is offline. So you'll want to put a check to make sure that in-game mail is only selectable when the server is offline (specifically, mangosd -- realmd should be ok to be up and running).

right.

Hmmm, haven't heard that, Will definitely look at the miniManager script, but I didn't know about having Mangosd offline first... why does it have to be down, wouldn't it be the same thing as adding a sql in the mail table? I've done that for all acct's multiple times, and it has worked, of course it only shows up when after they re-log...

select SQL_CALC_FOUND_ROWS characters.guid, characters.account, mail.id, messagetype, sender, " & _

"receiver, subject, itemtextid, has_items, expire_time, " & _

"deliver_time, money, cod, checked, item_text.id, item_text.text AS Body, " & _

"(select name from " & characterDB & " where characters.guid=mail.sender) as MailFrom, " & _

"(select name from " & characterDB & " where characters.guid=mail.receiver) as MailTo " & _

"FROM Mail LEFT JOIN item_text ON mail.itemtextid = item_text.id " & _

"INNER JOIN characters ON receiver = characters.guid WHERE characters.account = '" & playerID & "' " & _

"ORDER BY mail.id DESC;

Found your post on the Minimanager forums

MaNGOS uses UNIX time for the date, something which we already deal with (in order to do anything time-dependent, like bans).

It is more of just getting around to implementing it and validating that it works correctly, showing/hiding the correct controls. Shouldn't be hard

Yeah, asked in the general section, and Davemm linked an explanation to me... Learning the way you made this site tick, taking some time.

--- Hope i can actually get a ingame mail thing working... even if you get one made... would make me feel better about my VB / SQL skillz

Thanks for the reply, yes it looks as if it is, Thanks, now all i have to do is figure out how to incorporate a conversion into the script...(Shouldn't be too hard...) Thanks again.

Hi, I was fumbling around with the mail table, and I noticed that the Sent_Time and the Expire_Time uses a seemingly random string for the times, i know it isn't random but I haven't really seen anything that relates to an actual date. so, does it use a type of relative dating or?

I was messing around with this because i was trying to make a script that would work as a sort of Reward type thing. Like for every so many hours a player was online, they would get better increments of gold/Items... ANYWAY, it seems as though I can't send it without knowing how MaNGOS makes the string of numbers...

"3"

Yeah, it is pretty easy to say if Ingame = true, don't include banned as an option. Just something I haven't explored yet (I don't use in game mail much myself). There is also the issue of ingame mail not working well with, IIRC, characters that are logged in.

Couldn't you just... going off a guess haven't really looked into it, use a SQL query to send the mail? You could probably even add a slot for items / gold... like..

Delare the variables for the subject, body, and recipient.(EDIT: and attachment) Then make a string as a Query builder, and then, insert the query into the table...? I''lll look into it.

----;'`-- Edit--`';

---/ New Issue. \\

--(___Times___)

The only part i am having trouble on is the sent time and the expire time, as mangos uses some different string of numbers to represent dates...?

other than that, you could build a form that acts as a query builder to insert into Item_Text, Mail, and Mail_item(?), tables, since they are all in the characters db, it shouldn't be too hard, should it?

Thanks for the quick reply (as usual).

I will check that out, but i have also noticed that SetupSQL.vb has a loop in it? maybe... There seemed to be an infinite amount of mysql exeptions. Just thought i might point this out, although its probably my imagination, or there for a good reason.

Thanks again.

----Edit----

Five minutes and one quick query later, all is well and working like a fine tuned machine. The user didn't have the permissions on the micromanager DB... (feels like a child...)

P.S. I love the idea of ingame mailing ability. If and when that is accessible are you going to keep the same mailing options? (Except for banned of course)

First of all, Nice work rilex!!!

Secondly, I love the color scheme you've got.

Now then, I've previously had this system working smoothly. I've been away from MaNGOS for a while now, but I've started anew with a fresh slate. I've got the source, and compiled the site (Non Express)

This is what I've done in the way of configuring it to work:

• * Set the ASP.NET service to automatic and started it
  * Edited the Web.config connection strings
  * Given the NetworkService all the necessery permissions
  * Updated to .NET 3.5
  

But when I try to login or create an account it just simply loads infinitely and does not actually load the page. The password reset page works, as well as the copyright, but nothing else.

Any help would be grately appreciated.

Thanks again for this wonderful project.