TBDev Forum
Programming board
Main Page Forum Rules Privacy Policy Members Contact Us
Welcome Guest (Login | Register)
TBDev Forum TBDev.net - Help General Support Invite and Signup Times

Invite and Signup Times

2006-07-31 06:23:00
Group: Member
Posts: 194
Topics participated: 95
Topics started: 11
First post: 2006-07-20 11:23:00
Last post: 2007-06-29 20:32:00
Hello guys,

When I send an invite, I check the database for invited user, and the time is incorrect (added time).. e.g. It must be 07:00, but its 06:00 I got some error in signup..
 
2006-07-31 06:43:00
Group: Member
Posts: 194
Topics participated: 95
Topics started: 11
First post: 2006-07-20 11:23:00
Last post: 2007-06-29 20:32:00
I added below mod from this link
http://www.tbsource.info/index.php?showtopic=2972&hl=timezone


[codebox]It's because there is 2 different time settings.

User Time and Server Time.

Easiest way to rectify would be to add timezone settings.

Step 1: Add a column to the users table called "tzoffset" of type smallint.


CODE
ALTER TABLE `users` ADD `tzoffset` TINYINT (2) NOT NULL default '0'


Step 2: Add this to global.php

CODE
$tzs["-720"] = "(GMT - 12:00 hours) Enitwetok, Kwajalien";
$tzs["-660"] = "(GMT - 11:00 hours) Midway Island, Samoa";
$tzs["-600"] = "(GMT - 10:00 hours) Hawaii";
$tzs["-540"] = "(GMT - 9:00 hours) Alaska";
$tzs["-480"] = "(GMT - 8:00 hours) Pacific Time (US & Canada)";
$tzs["-420"] = "(GMT - 7:00 hours) Mountain Time (US & Canada)";
$tzs["-360"] = "(GMT - 6:00 hours) Central Time (US & Canada), Mexico City";
$tzs["-300"] = "(GMT - 5:00 hours) Eastern Time (US & Canada), Bogota, Lima, Quito";
$tzs["-240"] = "(GMT - 4:00 hours) Atlantic Time (Canada), Caracas, La Paz";
$tzs["-210"] = "(GMT - 3:30 hours) Newfoundland";
$tzs["-180"] = "(GMT - 3:00 hours) Brazil, Buenos Aires, Georgetown, Falkland Isl.";
$tzs["-120"] = "(GMT - 2:00 hours) Mid-Atlantic, Ascention Isl., St Helena";
$tzs["-60"]
 
2006-07-31 09:08:00
Group: Member
Posts: 453
Topics participated: 212
Topics started: 26
First post: 2006-05-01 01:45:00
Last post: 2008-04-09 16:53:00
USE CODEBOX TAGS


and $invite_timeout = 86400 * 3; <== That means 30 mins?

86400 is seconds. Divide 86400 by 60 twice, you reach 24, the number of hours in a day... * 3, is 3 days.
 
2006-08-03 06:53:00
Group: Member
Posts: 194
Topics participated: 95
Topics started: 11
First post: 2006-07-20 11:23:00
Last post: 2007-06-29 20:32:00
USE CODEBOX TAGS


and $invite_timeout = 86400 * 3; <== That means 30 mins?

86400 is seconds. Divide 86400 by 60 twice, you reach 24, the number of hours in a day... * 3, is 3 days.


Why my invited users deleting every 30 mins :o
 
2006-08-03 14:10:00
Group: Member
Posts: 461
Topics participated: 232
Topics started: 10
First post: 2006-03-21 13:50:00
Last post: 2008-12-23 18:24:00
Make sure that you update the 'last_access' field to the current time when creating the account, rather than the default of '0000-00-00 00:00:00' otherwise system will calculate that the user account is older than the X days specified in the cleanup routine...
 
2006-08-04 08:39:00
Group: Member
Posts: 194
Topics participated: 95
Topics started: 11
First post: 2006-07-20 11:23:00
Last post: 2007-06-29 20:32:00
Make sure that you update the 'last_access' field to the current time when creating the account, rather than the default of '0000-00-00 00:00:00' otherwise system will calculate that the user account is older than the X days specified in the cleanup routine...


Hmmm...... I must update every1 last_access fields?? I think it must be automatic after registration or invition..
e.g.. I've registered a new account, and I look it with phpmyadmin, last_access field: 0000-00-00 00:00:00.. I didnt confirmated it yet..
 
2006-08-06 12:28:00
Group: Member
Posts: 461
Topics participated: 232
Topics started: 10
First post: 2006-03-21 13:50:00
Last post: 2008-12-23 18:24:00
Post your pending account cleanup code...

Mine is...

 
2006-08-06 01:49:00
Group: Member
Posts: 194
Topics participated: 95
Topics started: 11
First post: 2006-07-20 11:23:00
Last post: 2007-06-29 20:32:00
Here:
$deadtime = time() - $signup_timeout;
 

Similar threads

Topic Posts Last post
Invite Signup 3 2007-07-10 14:53:00
Im behind times 5 2006-08-08 17:08:00
50 times pm to poweruser 3 2007-02-24 11:16:00
Times downloaded 2 2008-12-13 14:02:00
login 2 times 2 2007-03-04 18:04:00