[Archive] Batch In-Game Mail Sender
[Archive] Batch In-Game Mail Sender
11-04-2025, 12:45 PM
Original source
Quote: 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
Instructions1. 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(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.
![[Image: previeweu.jpg]](http://img801.imageshack.us/img801/7440/previeweu.jpg)
rektbyfaith
11-04-2025, 12:45 PM #1Archived author: Nadromar • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: 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
Instructions1. 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
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.
11-04-2025, 12:45 PM
Original source
Quote: This looks super awesome...
But can you upload it someone other than this site? lol
Thanks!
rektbyfaith
11-04-2025, 12:45 PM #2Archived author: CreativeXtent • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: This looks super awesome...
But can you upload it someone other than this site? lol
Thanks!
11-04-2025, 12:45 PM
Original source
Quote: Approved attachments, didn't see them initially.
rektbyfaith
11-04-2025, 12:45 PM #3Archived author: stoneharry • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: Approved attachments, didn't see them initially.
11-04-2025, 12:45 PM
Original source
Quote: 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)
rektbyfaith
11-04-2025, 12:45 PM #4Archived author: Tidan12 • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: 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)
11-04-2025, 12:45 PM
Original source
Quote: pretty nice gonna use this
![[Image: smile.png]](https://www.ownedcore.com/forums/images/smilies/smile.png)
rektbyfaith
11-04-2025, 12:45 PM #5Archived author: usb1y • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: pretty nice gonna use this
11-04-2025, 12:45 PM
Original source
Quote: Great Work...PLS can you tranform this program for TC2?
rektbyfaith
11-04-2025, 12:45 PM #6Archived author: Rohlik • Posted: 2025-11-04T13:45:09.803378
Original source
Quote: Great Work...PLS can you tranform this program for TC2?
11-04-2025, 12:45 PM
Original source
Quote:http://www.ownedcore.com/forums/worl...ser-1-3-a.html (Mail Tosser 1.3)
rektbyfaith
11-04-2025, 12:45 PM #7Archived author: Zaxer • Posted: 2025-11-04T13:45:09.803378
Original source
Quote:http://www.ownedcore.com/forums/worl...ser-1-3-a.html (Mail Tosser 1.3)
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)