How to fix your mailbox probelm!!!

[DarkSoulja FM]

1.Go into navicat
2. Go to ascentlogon and Delete your "mailbox".
3. Open notepad and type the following and save the following as an .sql

[IMGR] /*
MySQL Data Transfer
Source Host: localhost
Source Database: ascentlogon
Target Host: localhost
Target Database: ascentlogon
Date: 3/1/2008 6:44:30 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for mailbox
-- ----------------------------
CREATE TABLE `mailbox` (
`message_id` int(10) unsigned NOT NULL default '0',
`message_type` int(10) unsigned NOT NULL default '0',
`player_guid` int(10) unsigned NOT NULL default '0',
`sender_guid` int(10) unsigned NOT NULL default '0',
`subject` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`body` longtext collate utf8_unicode_ci NOT NULL,
`money` int(10) unsigned NOT NULL default '0',
`attached_item_guids` varchar(200) collate utf8_unicode_ci NOT NULL default '0',
`cod` int(10) unsigned NOT NULL default '0',
`stationary` int(10) unsigned NOT NULL default '0',
`expiry_time` int(10) unsigned NOT NULL default '0',
`delivery_time` int(10) unsigned NOT NULL default '0',
`copy_made` int(10) unsigned NOT NULL default '0',
`read_flag` tinyint(3) unsigned NOT NULL default '0',
`deleted_flag` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `mailbox` VALUES ('1', '0', '15', '6', 'Hello', 'Welcome to Arthas(PVP) !!!', '0', '', '0', '41', '1206941696', '1204349696', '0', '0', '0');
[/IMGR]


4. I dont think you need the Records bit, but keep it incase (its just a test mail i sent)

5. Now once u save the file as an .sql , open navicat, open the ascentlogon DB then right click and select "execute bacth file" and select the .sql file you have made earlier.

6. Now open/restart your server and try sending some mail.

NOTE: I have tested this and it worked, including with: money and items!!

IF this helped you please, please reply =p

[dentharg]

Thanks mate! Did the trick for me

[JECBoards]

OMG thanks ssssooooo much finnaly fixed the mailbox problem!

[DarkSoulja FM]

No problem =p