Mailbox insert queue

From ArcEmu-Wiki
Jump to: navigation, search

Contents

sender_guid

Guid of the character who sends the mail.

receiver_guid

Guid of the character who receives the mail.

subject

Title of the mail.

body

Body of the mail. It's the actual message.

stationary

(Background ID):

1 = plain + purple scroll icon
61 = Customer Service
62 = Auction House
64 = Valentine's Day
65 = Christmas
67 = Orphan's week

money

Amount of money sent.

item_id

Id of the item sent.

item_stack

Amount of the sent item.

SQL Structure

CREATE TABLE `mailbox_insert_queue` (
  `sender_guid` int(30) NOT NULL,
  `receiver_guid` int(30) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `body` varchar(500) NOT NULL,
  `stationary` int(30) NOT NULL,
  `money` int(30) NOT NULL,
  `item_id` int(30) NOT NULL,
  `item_stack` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools