RE: [Phphelpdesk-help] Date Opened

[Joe H. <jo...@jo...>]

Zamir,
 
Here is the code that is used when adding a job to the database.  I'm
pretty sure that the date() function may be UNIX specific.  I have tried
PHP Helpdesk on a Windows box, but not recently, and I didn't
specifically check that function..
 
 
  $current_date = date("ymdHi");                //set timestamp
 
  $txtDetail1 = addslashes($txtDetail);
  $txtSummary1 = addslashes($txtSummary);
  $txtLocation1 = addslashes($txtLocation);
  $txtUserFirstName1 = addslashes($txtUserFirstName);
  $txtUserLastName1 = addslashes($txtUserLastName);
  $txtUserTelephone1 = addslashes($txtUserTelephone);
  $txtUserEmail1 = addslashes($txtUserEmail);
 
  // Insert ticked into the tickets table
  $query = "INSERT INTO ticket";
  $query .= " (t_id, t_category, t_detail, t_priority, t_user, ";
  $query .= "t_timestamp_opened, t_department, t_location, t_summary, ";
  $query .= "t_userfirstname, t_userlastname, t_usertelephone,
t_useremail)";
  $query .= " VALUES (NULL, '$lstCategory', '$txtDetail1',
'$optPriority', '$user', ";
  $query .= "'$current_date', '$Company', '$txtLocation1',
'$txtSummary1', ";
  $query .= "'$txtUserFirstName1', '$txtUserLastName1',
'$txtUserTelephone1', '$txtUserEmail1');";
  $mysql_result = mysql_query($query, $mysql_link);
 
 
 
I don't have these problems, so I can't really troubleshoot it very
easily.  I hope this helps.
 
Joe.
-----Original Message-----
From: Mohamad Zaamzamir A.Jalil [mailto:za...@mi...] 
Sent: Sunday, May 20, 2001 6:03 PM
To: Joe Hoot
Subject: Re: [Phphelpdesk-help] Date Opened
 
All right Joe, then i install phphelpdesk on my server...then i run the
"add Job" fuction. What happend is, the time is also different from my
server time..where it should be the same as my PC time. Wht's wrong with
that?
 
 
Zamir
ICQ: 113867526
----- Original Message ----- 
From: Joe Hoot <mailto:jo...@jo...>  
To: 'Mohamad Zaamzamir A.Jalil' <mailto:za...@mi...>  
Cc: php...@li... 
Sent: Friday, May 18, 2001 10:23 PM
Subject: RE: [Phphelpdesk-help] Date Opened
 
Ahh. this is because it is the time that PHP gets from the server.  If a
users PC clock is off, you would want the server to say that the ticket
was submitted at the correct time (assuming that your server is keeping
time). 
 
-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
Mohamad Zaamzamir A.Jalil
Sent: Friday, May 18, 2001 1:39 AM
To: php...@li...
Subject: [Phphelpdesk-help] Date Opened
 
Hello,
 
I have a question.. if you go to demo page and key in one sample
input..after that you click view job. Please pay attention here, the
time at the "date opened" column is not the same as the system time (PC
time). What does "date opened" column means?
 
Zamir