Solution, work fine, very fine

macias <[email protected]> 30 Jul 2003 09:11:32 -0000
Newsgroups gmane.comp.web.oscommerce.devel
Message-ID <de3215936834e83b0eddf90ce441efbe@osCommerce-Forums>
This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=204218#204218
----------------------------------------------------------------

[code]
  function tep_db_query($query, $link = 'db_link') {
    global $$link, $logger;

	$query = str_replace( "now()",'now() + interval 9 hour' , $query ); //"'".tep_db_date_mysql()."'"


    if (STORE_DB_TRANSACTIONS == 'true') {
      if (!is_object($logger)) $logger = new logger;
      $logger->write($query, 'QUERY');
    }

    $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());

    if (STORE_DB_TRANSACTIONS == 'true') {
      if (mysql_error()) $logger->write(mysql_error(), 'ERROR');
    }

    return $result;
  }
[/code]