Batch In-Game Mail Sender

[Nadromar]

Hey everyone, It's been a while since I last contributed here but I made a little program for arcemu that sends a message to everyone on the server.
This can be used for things like announcements, donation requests, items for players (on holidays etc), you name it!

Features
- Send Mail to all characters on your ArcEmu server
- Send with different layouts
- Send items and gold
- Choose the character sending the mail (or send from "Customer Support")
- Choose to let the program send or export the mails as SQL file
- Option to remember your MySql login info

I've only tested it with the latest revision of ArcEmu but I'm fairly certain it will also work on older versions of ArcEmu.
If this application gets positive feedback I'll also make it compatible for other emulators.
Or if anyone needs it for a specific emulator, let me know and I'll make it compatible for you.

Here's what the program looks like:

Download Latest Version: ArcEmu Batch Mailer.zip

Instructions

1. On the left side of the box enter the subject and message you'd like to send. You can also select different layouts for your mail such as Blizzard Layout, Valentine layout and a bunch more.

2. Enter the correct ArcEmu MySql server info and the character database of the server where you would like the send the in-game mails.
Make sure that the MySql account you're using has permission to access the database with the SELECT and INSERT commands.
If you don't know what that means then just try and see if it works :P (Feel free to ask for help in the thread on OwnedCore).

3. (Optional) You can also choose to send money or items, you can do this by setting the message attachments on the right side.
In order to add items you have to enter the Item ID in the first column on the items menu and the amount of that item you'd like to send in the second.
You can send 12 items this way.
Note: You can find the ID of items in your world database under the items table or ingame with the command ".lookup item Thunderfury" for example.

4. You can now choose to either send the mail via the program or export your mails to an SQL file and import the mails manually.

- Automatically: You can do this by pressing the Auto-Send Mails button. This will instantly send the mails to all players on the server without requiring any other action from you. The mails should arrive shortly after having sent them.

- Manually: You can do this by clicking "Save to SQL File". Doing this will allow you to review the query but will require you to add submit the query to the characters database yourself via navicat or whichever database management program you use.

NOTE: If you choose this option, please don't wait too long before submitting this to the database. Otherwise any new characters won't receive your mail.

[CreativeXtent]

This looks super awesome...

But can you upload it someone other than this site? lol

Thanks!

[stoneharry]

Approved attachments, didn't see them initially.

[Tidan12]

I get an error when doing this Saying
************** Undantagstext **************
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'item_id2' in 'field list'
vid MySql.Data.MySqlClient.MySqlStream.ReadPacket()
vid MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
vid MySql.Data.MySqlClient.MySqlDataReader.NextResult()
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
vid BatchMailerArcemu.MySqlFunctions.SendBatchMails(String ConnectionString, String CharacterName, String Subject, String Body, Int32 stationary, Int32 money, String i1, String ic1, String i2, String ic2, String i3, String ic3, String i4, String ic4, String i5, String ic5, String i6, String ic6, String i7, String ic7, String i8, String ic8, String i9, String ic9, String i10, String ic10, String i11, String ic11, String i12, String ic12)
vid BatchMailerArcemu.Form1.SendMail_Click(Object sender, EventArgs e)
vid System.Windows.Forms.Control.OnClick(EventArgs e)
vid System.Windows.Forms.Button.OnClick(EventArgs e)
vid System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
vid System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
vid System.Windows.Forms.Control.WndProc(Message& m)
vid System.Windows.Forms.ButtonBase.WndProc(Message& m)
vid System.Windows.Forms.Button.WndProc(Message& m)
vid System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
vid System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
vid System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[usb1y]

pretty nice gonna use this

[Rohlik]

Great Work...PLS can you tranform this program for TC2?

[Zaxer]

http://www.ownedcore.com/forums/worl...ser-1-3-a.html (Mail Tosser 1.3)