AKOcomment and time

Pathos · 22.07.2004, 23:54

Hi, I love AKOcomment, but i saw the time that gets written down is the time on the server. Not the mambo-time. I tried to hack it a bit, but couldn't work it out. Anyone got a hint? How do i count 6 hours in a
$date = date( "Y-m-d H:i:s");

Tried several +6 and variations, but didn't work...

Greetz

scoobyfun · 05.10.2004, 18:27

Hallo, I have the same problem.

scoobyfun · 06.10.2004, 11:19

I made a change to the database to resolve the problem.

( system database query)
ALTER TABLE `mambo45`.`mos_akocomment` MODIFY COLUMN `date` text NOT NULL;

( in components\akocomment.php )
$date = strftime ("%A, %d %B %Y. %H:%M", time()+25200);

25200 = (time offset) * 60 * 60

( in administrator\components\com_akocomment\admin.akoc omment.php )
$row->date = strftime ("%A, %d %B %Y. %H:%M", time()+25200);

NSS · 06.10.2006, 00:43

Quote:

Originally Posted by scoobyfun

I made a change to the database to resolve the problem.

( system database query)
ALTER TABLE `mambo45`.`mos_akocomment` MODIFY COLUMN `date` text NOT NULL;

How should I put that in Joomla? I understand that I should swap `mos_akocomment` for `jos_akocomment`, but what is `mambo45`?