|
adon126
8 posts Location:
n.a. |
31.01.2011 19:50Re: Change date formatHere is solution:
Just have to edit two file
1. (your joomla root)\components\com_primezilla\models\inbox.php
2. (your joomla root)\components\com_primezilla\models\outbox.php
Do the same step as below:
1. Find what (as line 132 to line 140)
$selectQuery =
......
return $selectQuery;
2. Select these line, and replace with
In inbox.php:
$selectQuery = "SELECT id, user_id, user_from_id,
DATE_FORMAT( msg_date, '%d/%m/%Y') AS msg_date,
msg_time, subject, message,
flag_read, flag_answered, flag_deleted
FROM ".$db->nameQuote('#__primezilla_inbox')."
WHERE user_id = '".$_user_id."' AND flag_deleted != '1'
ORDER BY id DESC, msg_time DESC";
return $selectQuery;
In outbox.php:
$selectQuery = "SELECT id, user_id, user_to_id,
DATE_FORMAT( msg_date, '%d/%m/%Y') AS msg_date,
msg_time, subject, message,
flag_read, flag_answered, flag_deleted
FROM " . $db->nameQuote( '#__primezilla_outbox') . "
WHERE user_id = '" . $_user_id . "' AND flag_deleted != '1'
ORDER BY id DESC, msg_time DESC";
return $selectQuery;
3. It's almost done. Enjoy yourself by change '%d/%m/%Y' to your favor date format.
Edited by adon126 - 31.01.2011 19:52
|
Facebook
Twitter
LinkedIn
Google+
