From 02ccbd72df039de1a22a1f9e834b55978695ad27 Mon Sep 17 00:00:00 2001 From: ultramage Date: Fri, 16 May 2008 16:11:16 +0000 Subject: Fixed 64bit timestamps messing up auction/storage (bugreport:1454) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12713 54d463be-8e91-2dee-dedb-b68131a5f0ec --- src/char_sql/int_mail.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/char_sql/int_mail.c') diff --git a/src/char_sql/int_mail.c b/src/char_sql/int_mail.c index a70b30b99..968ddf3ee 100644 --- a/src/char_sql/int_mail.c +++ b/src/char_sql/int_mail.c @@ -109,8 +109,8 @@ int mail_savemessage(struct mail_message* msg) StringBuf_Printf(&buf, "INSERT INTO `%s` (`send_name`, `send_id`, `dest_name`, `dest_id`, `title`, `message`, `time`, `status`, `zeny`, `amount`, `nameid`, `refine`, `attribute`, `identify`", mail_db); for (j = 0; j < MAX_SLOTS; j++) StringBuf_Printf(&buf, ", `card%d`", j); - StringBuf_Printf(&buf, ") VALUES (?, '%d', ?, '%d', ?, ?, '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d'", - msg->send_id, msg->dest_id, msg->timestamp, msg->status, msg->zeny, msg->item.amount, msg->item.nameid, msg->item.refine, msg->item.attribute, msg->item.identify); + StringBuf_Printf(&buf, ") VALUES (?, '%d', ?, '%d', ?, ?, '%lu', '%d', '%d', '%d', '%d', '%d', '%d', '%d'", + msg->send_id, msg->dest_id, (unsigned long)msg->timestamp, msg->status, msg->zeny, msg->item.amount, msg->item.nameid, msg->item.refine, msg->item.attribute, msg->item.identify); for (j = 0; j < MAX_SLOTS; j++) StringBuf_Printf(&buf, ", '%d'", msg->item.card[j]); StringBuf_AppendStr(&buf, ")"); -- cgit v1.2.3-70-g09d2