• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Send item as mail - Aion 5.8

emundus

Newbie Spellweaver
Joined
Jun 10, 2022
Messages
74
Reaction score
7
Hey, how are you?
Can someone teachs me how to send an item by mailbox, using database?

I saw that the attached_item_id is different from the item id, so how do you do it?
 
Sort by date Sort by votes
V

Voidstar

Banned
Banned
Joined
May 26, 2020
Messages
235
Reaction score
100
Example;

Code: 
INSERT INTO `ad58_server_gs`.`mail`(`mail_unique_id`, `mail_recipient_id`, `sender_name`, `mail_title`, `mail_message`, `unread`, `attached_item_id`, `attached_kinah_count`, `attached_ap_count`, `express`, `recieved_time`, `price`) VALUES (393352, 101046648, 'Gamemaster', 'Reward', 'Voting Reward', 1, 164002023, 0, 0, 1, '2023-02-01 15:42:38', 0);

mail_unique_id = 393352 (unique number)
393352 = mail_recipient_id (table players, player "id")
Gamemaster = sender_name
mail_title = Reward
mail_message = 'Voting Reward
attached_item_id = 164002023
 
Upvote 0

StingerOne

Experienced Elementalist
Joined
Aug 6, 2021
Messages
220
Reaction score
55
Send mail and then check the database, you will see how it's filled in then you can insert a row with new info to send another mail.
 
Upvote 0

emundus

Newbie Spellweaver
Joined
Jun 10, 2022
Messages
74
Reaction score
7
I did the code normally, but the mail is empty with the item..
 
Upvote 0
You must log in or register to reply here.