My mail doesnt send properly. Ok so my mailbox is the default one that came with my ascentlogon, here it is:
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_guid` bigint(20) unsigned NOT NULL default '0',
`external_attached_item_guid` bigint(20) 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;
So i read something about this but it said : (HOw do i run updates, and if some1 has working mailbox, please dump ur SQL into a file and post here, plz)
"did u run these updates:
Code:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid;
and
Code:
alter table mailbox drop column external_attached_item_guid;
alter table mailbox change column attached_item_guid attached_item_guids varchar(200) not null default "";
drop table playeritems_external;