https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 13:21:15 +0000 Tue, 05 Dec 2006 09:26:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22024 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117941.html#117941 Author: xjmajor
Subject: 22024
Posted: 05 December 2006 at 9:26am

Thank you. But it send back to function

internationalDateTime

I think I must add 6 hours to this function, to have correct session time.

This function is in functions/functions_common.asp, around line 1230, I pasted the snippet some message above.

I need to write the time in this function 6 hours up.
]]> Tue, 05 Dec 2006 09:26:27 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117941.html#117941 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117932.html#117932 Author: dpyers
Subject: 22024
Posted: 05 December 2006 at 12:45am

The session last visit stuff is done in functions/functions_login.asp

Starts around line # 360
]]> Tue, 05 Dec 2006 00:45:02 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117932.html#117932 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117887.html#117887 Author: xjmajor
Subject: 22024
Posted: 04 December 2006 at 9:22am

I can't access to the server located in the USA, where I just can operate on SQL database. The issue affects just the session time, not the time of messages.
Now, like the time of messages can be shifted by changing profile, I guess I can add somewhere 6 hours to the session date, but I'm not able to understand where.
Thanks.
]]> Mon, 04 Dec 2006 09:22:38 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117887.html#117887 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117866.html#117866 Author: SMR Group
Subject: 22024
Posted: 03 December 2006 at 5:59pm

Can't you just change the time on your server?  Or do you not have root access via Remote Desktop (or similar)?]]> Sun, 03 Dec 2006 17:59:27 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117866.html#117866 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117791.html#117791 Author: xjmajor
Subject: 22024
Posted: 02 December 2006 at 10:11am

Can I hope in somebody's help or I have to give up?
Thank you again!
]]> Sat, 02 Dec 2006 10:11:57 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117791.html#117791 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117618.html#117618 Author: xjmajor
Subject: 22024
Posted: 27 November 2006 at 11:51pm

I looked at the code, I guess I need to modify the function in function_common.asp, adding a DATEADD somewhere. Can someone help me?
Here's the snippet I think to be modified. After modifying Variable internationalDateTime would be +6 hours shift. Where to insert a DATEADD?

'**********************************************
'***  Format ISO International Date/Time   ****
'**********************************************

'Function to format the present date and time into international formats to prevent systems crashes on foriegn servers
Private Function internationalDateTime(dtmDate)

    Dim strYear
    Dim strMonth
    Dim strDay
    Dim strHour
    Dim strMinute
    Dim strSecound

    strYear = Year(dtmDate)
    strMonth = Month(dtmDate)
    strDay = Day(dtmDate)
    strHour = Hour(dtmDate)
    strMinute = Minute(dtmDate)
    strSecound = Second(dtmDate)

    'Place 0 infront of minutes under 10
    If strMonth < 10 then strMonth = "0" & strMonth
    If strDay < 10 then strDay = "0" & strDay
    If strHour < 10 then strHour = "0" & strHour
    If strMinute < 10 then strMinute = "0" & strMinute
    If strSecound < 10 then strSecound = "0" & strSecound

    'This function returns the ISO internation date and time formats:- yyyy-mm-dd hh:mm:ss
    'Dashes prevent systems that use periods etc. from crashing
    internationalDateTime = strYear & "-" & strMonth & "-" & strDay & " " & strHour & ":" & strMinute& ":" & strSecound
End Function


]]> Mon, 27 Nov 2006 23:51:31 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117618.html#117618 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117561.html#117561 Author: xjmajor
Subject: 22024
Posted: 26 November 2006 at 11:50am

Ok, I know my english is ridicolous, so I try to explain better.

Thanks to MadDog, but the problem is NOT the time / date in the profile, but time/date set by cookies and sessions.

My asp page are on italian server, my SQL db is on East Coast server.

Time and date, in the profile, indicate the correct timing in Italy, so when I write a message or a PM, the time is correct.

But if I look at the main forum page, I see by example:
Time is 12.00 pm.
Last visit is at 6.00 am.

And if I go to active topics, the last visit time is shifted on the db server time, 6 hours back from Italy and server with asp pages time.

There is a function, in function_common.asp, about
internationalDateTime (or something similar, I haven't the code now).

This function renders time of database server (the one in the USA).

I need to shift the time rendered by this function 6 hours later, so it is  synchronized with time of the server with asp pages in Italy.

Thank you again,

Damiano
]]> Sun, 26 Nov 2006 11:50:17 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117561.html#117561 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117540.html#117540 Author: MadDog
Subject: 22024
Posted: 25 November 2006 at 7:17pm

You cant. The only option you have is to edit your profile and change the date format.]]> Sat, 25 Nov 2006 19:17:40 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117540.html#117540 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117524.html#117524 Author: xjmajor
Subject: 22024
Posted: 25 November 2006 at 12:21pm

Hi,
I'm running a MSSQL 2005 version of WWF.

The ASP pages are on an Italian server, the Database is on a USA (east coast) server.

So, the behaviour of date is: all OK with date of posts, PM etc, international date for cookies and sessions is 6 hours back, according with date generated by DB server.

Where can I correct the code to shift the date for cookies and sessions 6 hours later?

I guess it is a simply operation (write +6 somewhere), but before I make mistakes, I ask for your help.

Thank you for all,

Damiano Morelli


Edited by xjmajor - 25 November 2006 at 1:38pm]]> Sat, 25 Nov 2006 12:21:55 +0000 https://forums.webwiz.net/last-visit-day-and-server-in-usa_topic22024_post117524.html#117524