Send Old Mail To RoDex

[astralprojection 35]

I was trying to figure out how to send those pending message from old mail to RoDex since newer client don't open the old mail already.  I made some script to do this but i need clarification on the query.

table `mail` has column `status`.  What is the meaning of this values?

0 =

1 =

2 =

https://pastebin.com/HEyScmz1

Thank you guys.

[4144 367]

See values for status here: https://github.com/HerculesWS/Hercules/blob/master/src/common/mmo.h#L657-L659

First one is 0, then 1, then 2

[astralprojection 35]

Thank you, now i know its all at mmo.h 

now another question is :

1.  if player collect item/zeny from old mail.  will that zeny, nameid, qty value in db will become zero?  so that i can add to query to filter only with nameid and zeny regardless if mail is read or not.

2.  how about that items with unique_id in old mail?  rodex_sendmail2 will generate new unique_id?