This script allows you to send mail to any existing character.
Change $sender_guid = 115; to the guid of the character that you want to send the mail to. You can find your characters guid by running this sql query
Code:
SELECT guid FROM characters WHERE name = 'name';
Be sure to change the config info
PHP
Code:
<!-- Made by Kyle102092 -->
<?php
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';
echo '<title>Ingame Mail</title>';
echo '<link href="style.css" rel="stylesheet" type="text/css">';
echo '</head><body>';
echo '<table border="0" align="center">';
$host = localhost;
$user = root;
$pass = pass;
$db = character;
if(isset($_POST['submit']))
{
// connect to the db
mysql_connect($host, $user, $pass) or die("Cannot connect: ".mysql_error());
mysql_select_db($db) or die("Cannot select database. ".mysql_error());
// get user inputs
$sender_guid = 115;
$receiver_guid = $_POST['character'];
$subject = $_POST['subject'];
$body = $_POST['body'];
$stationary = $_POST['stationary'];
$money = $_POST['money'];
$item_id = $_POST['item'];
$item_stack = $_POST['item_stack'];
//
$receiver_guid = mysql_real_escape_string(html_entity_decode(htmlentities($receiver_guid)));
$subject = mysql_real_escape_string(html_entity_decode(htmlentities($subject)));
$body = mysql_real_escape_string(html_entity_decode(htmlentities($body)));
$stationary = mysql_real_escape_string(html_entity_decode(htmlentities($stationary)));
$money = mysql_real_escape_string(html_entity_decode(htmlentities($money)));
$item_id = mysql_real_escape_string(html_entity_decode(htmlentities($item_id)));
$item_stack = mysql_real_escape_string(html_entity_decode(htmlentities($item_stack)));
$query = mysql_query("SELECT * from characters WHERE name = '".$receiver_guid."'");
while($result = mysql_fetch_array($query))
{
$guid = $result['guid'];
$query1 = "INSERT INTO mailbox_insert_queue(sender_guid, receiver_guid, subject, body, stationary, money, item_id, item_stack)
VALUES('$sender_guid', '$guid', '$subject', '$body', '$stationary', '$money', '$item_id', '$item_stack')";
$result = mysql_query($query1) or die(mysql_error());
echo "<tr><td align=center>";
echo "Mail inserted.";
echo "</td></tr>";
}
mysql_close();
}
else
{
echo '<form id="form1" name="form1" method="post" action="mailer.php">';
echo '<tr><td>Character: </td><td><input name="character" type="text" size="30" /></td></tr>';
echo '<tr><td>Subject: </td><td><input name="subject" type="text" size="30" value="Subject" /></td></tr>';
echo '<tr><td>Body: </td><td><textarea name="body" cols="30" rows="5"></textarea></td></tr>';
echo '<tr><td>Stationary: </td><td><select name="stationary"><option value="41">Regular</option><option value="61">Blizzard</option></select></td></tr>';
echo '<tr><td>Money: </td><td><input name="money" type="text" size="30" value="0" /></td></tr>';
echo '<tr><td>Item: </td><td><input name="item" type="text" size="30" value="0" /></td></tr>';
echo '<tr><td>Item Stack: </td><td><input name="item_stack" type="text" size="30" value="0" /></td></tr>';
echo '<td></td><td><input name="submit" type="submit" value="Submit" /> <input name="reset" type="reset" value="Reset" /></tr>';
}
echo '</form></table>';
echo '</body></html>';
?>
CSS
Code:
@charset "utf-8";
/* CSS Document */
body {
background-color: #000000;
}
body,td,th {
color: #FFFFFF;
}