snubbr.com

Looking for a Singapore proxy, need it to be Verisign SSL enabled. Thx?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Question I have... Looking for a Singapore proxy, need it to be Verisign SSL enabled. Thx? Many thanks for any answer or 2. Second question.. Hello,.

The time for my server is correct, and when I'm in whois_online.php I can see that the time is correct, but when I make any updates on orders, the time is 2 hours back. Which files do I need to edit, and how can I do it?.

I hope some one of your can help me out of this problem..

Regards..

Comments (58)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some poking around and get back to you if I find an anything. You should email the people at Verisign as they probably could give you help..

Comment #1

My server time is the same as my local time..

Comment #2

Go to the screen where you make the amendments to the orders and the file you need to edit is shown in the address bar.

Www.mysite.co.uk/admin/orders.php......

Means.

/admin/orders.php.

Strange that someone has changed the time by 2 hrs, is it a template?.

G..

Comment #3

I dont know who has changed it, it is not a template but can you tell me which code it is?.

Because I cant find anything there ? But on exactly that sections, the time is 2 hours back.

This post has been edited by.

Supplementler.

: 23 December 2008, 11:24..

Comment #4

Here is the code:.

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

$order_updated = false;.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$check_status = tep_db_fetch_array($check_status_query);.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

$customer_notified = '0';.

If (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {.

$notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments)"\n\n";.

}.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

$customer_notified = '1';.

}.

######## Points/Rewards Module V2.00 BOF ##################.

If ((isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on'))||(isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on'))) {.

$comments = ENTRY_CONFIRMED_POINTS$comments;.

$customer_query = tep_db_query("SELECT customer_id, points_pending from "TABLE_CUSTOMERS_POINTS_PENDING" WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '"$oID"'");.

$customer_points = tep_db_fetch_array($customer_query);.

If (tep_db_num_rows($customer_query)) {.

If (tep_not_null(POINTS_AUTO_EXPIRES)){.

$expire = date('Y-m-d', strtotime('+ '. POINTS_AUTO_EXPIRES .' month'));.

Tep_db_query("UPDATE "TABLE_CUSTOMERS" SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."', customers_points_expires = '". $expire ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'");.

} else {.

Tep_db_query("UPDATE "TABLE_CUSTOMERS" SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'");.

}.

If (isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on')) {.

Tep_db_query("DELETE FROM "TABLE_CUSTOMERS_POINTS_PENDING" WHERE orders_id = '"$oID"' AND points_type = 'SP' LIMIT 1");.

}.

If (isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on')) {.

Tep_db_query("UPDATE "TABLE_CUSTOMERS_POINTS_PENDING" SET points_status = 2 WHERE orders_id = '"$oID"' AND points_type = 'SP' LIMIT 1");.

}.

}.

}.

######## Points/Rewards Module V2.00 EOF ##################.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

Case 'deleteconfirm':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

Include(DIR_WS_CLASSES'order.php');.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/ajax.js"></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<div id="add-Product" class="addProduct">.

<div><?php echo DIV_ADD_PRODUCT_HEADING; ?></div>.

<div id="add-product-product" class="addProductContents"><?php echo ADD_PRODUCT_SELECT_PRODUCT; ?></div>.

<div id="addProductSearch" class="addProductContentsSearch"><?php require (DIR_WS_INCLUDES'advanced_search.php'); ?></div>.

<div id="addProductFind">&nbsp;</div>.

<div id="ProdAttr">&nbsp;</div>.

<a href="java script: hideAddProducts();"><?php echo tep_image(DIR_WS_LANGUAGES$language'/images/buttons/button_cancel.gif'); ?></a>.

</div>.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<! PWA BOF >.

<td class="pageHeading"><?php echo HEADING_TITLE(($order->customer['is_dummy_account'])? ' <b>no account!</b>':''); ?></td>.

<! PWA EOF >.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a>'; ?></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>', 'customers_', $oID); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'customers_telephone', '<?php echo $order->customer['telephone']; ?>');" class="ajaxLink"><?php echo $order->customer['telephone']; ?></a></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'customers_email_address', '<?php echo $order->customer['email_address']; ?>');" class="ajaxLink"><?php echo $order->customer['email_address']'</a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>', 'delivery_', $oID); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>', 'billing_', $oID); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'payment_method', '<?php echo addslashes($order->info['payment_method']); ?>');" class="ajaxLink"><?php echo $order->info['payment_method']; ?></a></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'cc_type', '<?php echo $order->info['cc_type']; ?>');" class="ajaxLink"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></a></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'cc_owner', '<?php echo $order->info['cc_owner']; ?>');" class="ajaxLink"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></a></td>.

<td class="main"><?php echo $order->info['cc_owner']; ?></td>.

</tr>.

<tr>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'cc_number', '<?php echo $order->info['cc_number']; ?>');" class="ajaxLink"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></a></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><a href="java script: updateOrderField('<?php echo $oID; ?>', 'orders', 'cc_expires', '<?php echo $order->info['cc_expires']; ?>');" class="ajaxLink"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></a></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo sprintf(TABLE_HEADING_PRODUCTS, $oID); ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right"><a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'\', \'eliminate\', \'\', \'\');"><font color="red"><b>X</b></font></a>&nbsp;<a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'products_quantity\', \'update\', \'\', \''$order->products[$i]['qty']'\');"><u>'$order->products[$i]['qty']'&nbsp;x</u></a></td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - <a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'options\', \'update\', \''$order->products[$i]['attributes'][$j]['option']'\', \''$order->products[$i]['attributes'][$j]['value']'\');"><u>'$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</u></a></i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top"><a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'products_model\', \'update\', \'\', \''$order->products[$i]['model']'\');"><u>'$order->products[$i]['model']'</u></a></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b><a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'products_price_excl\', \'update\', \'\', \''$order->products[$i]['final_price']'\');"><u>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</u></a></b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b><a href="java script: updateProduct(\''$oID'\', \''$order->products[$i]['id']'\', \'products_price_incl\', \'update\', \'\', \''tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax'])'\');"><u>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</u></a></b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

If (($order->totals[$i]['class'] != 'ot_subtotal') && ($order->totals[$i]['class'] != 'ot_total') && ($order->totals[$i]['class'] != 'ot_tax')) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText"><a href="java script: updateOrdersTotal(\''$oID'\', \''$order->totals[$i]['class']'\', \''addslashes(htmlspecialchars($order->totals[$i]['title']))'\', \'title\')"><u>'$order->totals[$i]['title']'</u></a></td>'"\n" ..

' <td align="right" class="smallText"><a href="java script: updateOrdersTotal(\''$oID'\', \''$order->totals[$i]['class']'\', \''$order->totals[$i]['value']'\', \'value\')"><u>'$order->totals[$i]['text']'</u></a></td>'"\n" ..

' </tr>'"\n";.

} else {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

}.

//link to create a new order_total.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText" colspan="2"><a href="java script: createOrdersTotal(\''$oID'\')"><u>Aadir un campo</u></a></td>'"\n" ..

' </tr>'"\n";.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<?php.

$orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! // Points/Rewards Module V2.00 check_box_bof //>.

<?php.

$p_status_query = tep_db_query("SELECT points_status FROM "TABLE_CUSTOMERS_POINTS_PENDING" WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '"$oID"'");.

If (tep_db_num_rows($p_status_query)) {.

Echo '<tr><td class="main"><b>'ENTRY_NOTIFY_POINTS'</b>&nbsp;'ENTRY_QUE_POINTStep_draw_checkbox_field('confirm_points', '', false)'&nbsp;'ENTRY_QUE_DEL_POINTStep_draw_checkbox_field('delete_points', '', false)'&nbsp;&nbsp;</td></tr>';.

}.

?>.

<! // Points/Rewards Module V2.00 check_box_eof //>.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$HTTP_GET_VARS['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$HTTP_GET_VARS['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a>'; ?></td>.

</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'">'tep_image(DIR_WS_IMAGES'icon_info.gif', IMAGE_ICON_INFO)'</a>'; } ?>&nbsp;</td>.

</tr>.

<?php.

}.

?>.

<tr>.

<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr>.

<td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>.

<td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

<?php.

$heading = array();.

$contents = array();.

Switch ($action) {.

Case 'delete':.

$heading[] = array('text' => '<b>'TEXT_INFO_HEADING_DELETE_ORDER'</b>');.

$contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=deleteconfirm'));.

$contents[] = array('text' => TEXT_INFO_DELETE_INTRO'<br><br><b>'$cInfo->customers_firstname' '$cInfo->customers_lastname'</b>');.

$contents[] = array('text' => '<br>'tep_draw_checkbox_field('restock')' 'TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);.

$contents[] = array('align' => 'center', 'text' => '<br>'tep_image_submit('button_delete.gif', IMAGE_DELETE)' <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id)'">'tep_image_button('button_cancel.gif', IMAGE_CANCEL)'</a>');.

Break;.

Default:.

If (isset($oInfo) && is_object($oInfo)) {.

$heading[] = array('text' => '<b>['$oInfo->orders_id']&nbsp;&nbsp;'tep_datetime_short($oInfo->date_purchased)'</b>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=delete')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$oInfo->orders_id)'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$oInfo->orders_id)'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a>');.

$contents[] = array('text' => '<br>'TEXT_DATE_ORDER_CREATED' 'tep_date_short($oInfo->date_purchased));.

If (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED' 'tep_date_short($oInfo->last_modified));.

$contents[] = array('text' => '<br>'TEXT_INFO_PAYMENT_METHOD' '$oInfo->payment_method);.

}.

Break;.

}.

If ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {.

Echo ' <td width="25%" valign="top">'"\n";.

$box = new box;.

Echo $box->infoBox($heading, $contents);.

Echo ' </td>'"\n";.

}.

?>.

</tr>.

</table></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

<! body_text_eof //>.

</tr>.

</table>.

<! body_eof //>.

<! footer //>.

<?php require(DIR_WS_INCLUDES'footer.php'); ?>.

<! footer_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>..

Comment #5

Hello,.

The time for my server is correct, and when I'm in whois_online.php I can see that the time is correct, but when I make any updates on orders, the time is 2 hours back. Which files do I need to edit, and how can I do it?.

I hope some one of your can help me out of this problem..

Regards..

Comment #6

I believe there is a contribution to adjust your server time to local time..

G..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.