[Quick Question] AAC

[JDB]

Account Page:
Created: 31 December 1969, 19:00:00

Umm, why is that? And where can I change that?

//JDB

 

[HeberPcL]

I think this time is captured in the mysql schedule at the time of character creation.

 

[JDB]

I think this time is captured in the mysql schedule at the time of character creation.

So, there is no way to fix that? Because all account's created on my database are saying that date.

 

[Cykotitan]

Check the value in column 'created' and post it here

 

[JDB]

0

 

[HeberPcL]

I do not know the step by step but in phpmyadmin is changing.
Perhaps the link below helps you.
MySQL :: MySQL 5.1 Reference Manual :: 9.6 MySQL Server Time Zone Support


Edit:
Use the converter below, specifying the date of starting the server and change. You need to change the date of mysql as well.

http://www.onlineconversion.com/unix_time.htm

 

[Cykotitan]

It was bug in OTS_Account.php

Line 199:

        $this->db->query('INSERT INTO ' . $this->db->tableName('accounts') . ' (' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ') VALUES (' . $number . ', ' . $this->db->quote($name) . ', \'\', \'\')');

to:

        $this->db->query('INSERT INTO ' . $this->db->tableName('accounts') . ' (' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ', ' . $this->db->fieldName('created') . ') VALUES (' . $number . ', ' . $this->db->quote($name) . ', \'\', \'\',' . time() . ')');

 

[HeberPcL]

Cykotitan Nice!

=p

 

[JDB]

Yes, thank you.