[TEP-COMMIT] [CVS catalog] use the new database class

hpdl-OfajU3CKLf1/[email protected] 24 Feb 2005 01:19:20 -0000
Newsgroups gmane.comp.web.oscommerce.cvs
Message-ID <[email protected]>
<html>
<head>
<style><!--
  body {background-color:#ffffff;}
  .file {border:1px solid #eeeeee;margin-top:1em;margin-bottom:1em;}
  .pathname {font-family:monospace; float:right;}
  .fileheader {margin-bottom:.5em;}
  .diff {margin:0;}
  .tasklist {padding:4px;border:1px dashed #000000;margin-top:1em;}
  .tasklist ul {margin-top:0;margin-bottom:0;}
  tr.alt {background-color:#eeeeee}
  #added {background-color:#ddffdd;}
  #addedchars {background-color:#99ff99;font-weight:bolder;}
  tr.alt #added {background-color:#ccf7cc;}
  #removed {background-color:#ffdddd;}
  #removedchars {background-color:#ff9999;font-weight:bolder;}
  tr.alt #removed {background-color:#f7cccc;}
  #info {color:#888888;}
  #context {background-color:#eeeeee;}
  td {padding-left:.3em;padding-right:.3em;}
  tr.head {border-bottom-width:1px;border-bottom-style:solid;}
  tr.head td {padding:0;padding-top:.2em;}
  .task {background-color:#ffff00;}
  .comment {padding:4px;border:1px dashed #000000;background-color:#ffffdd}
  .error {color:red;}
  hr {border-width:0px;height:2px;background:black;}
--></style>
</head>
<body>
<table cellspacing="0" cellpadding="0" border="0" rules="cols">
<tr class="head"><td colspan="4">Commit in <b><tt>catalog/catalog/includes/modules/payment</tt></b><span id="info"> on MAIN</span></td></tr>
<tr><td><tt><a href="#file1">psigate.php</a></tt></td><td align="right" id="added">+6</td><td align="right" id="removed">-4</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php?rev=1.24&amp;content-type=text/vnd.viewcvs-markup">1.24</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php.diff?r1=1.24&amp;r2=1.25">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php?rev=1.25&amp;content-type=text/vnd.viewcvs-markup">1.25</a></td></tr>
</table>
<pre class="comment">
use the new database class
</pre>
<hr /><a name="file1" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules">modules</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment">payment</a><br /></span>
<div class="fileheader"><big><b>psigate.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php?rev=1.24&amp;content-type=text/vnd.viewcvs-markup">1.24</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php.diff?r1=1.24&amp;r2=1.25">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/payment/psigate.php?rev=1.25&amp;content-type=text/vnd.viewcvs-markup">1.25</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.24 -r1.25
--- psigate.php	2005/02/24 01:13:36	1.24
+++ psigate.php	2005/02/24 01:19:19	1.25
@@ -175,7 +175,7 @@
</small></pre><pre class="diff" id="context">     }
 
     function process_button() {
</pre><pre class="diff" id="removed">-      global $order, $osC_Currencies;
</pre><pre class="diff" id="added">+      global $o<span id="addedchars">sC_Database,&nbsp;$o</span>rder, $osC_Currencies;
</pre><pre class="diff" id="context"> 
       if (PHP_VERSION &lt; 4.1) {
         global $_POST;
</pre><pre class="diff"><small id="info">@@ -225,10 +225,12 @@
</small></pre><pre class="diff" id="context">                                osc_draw_hidden_field('Bcity', $order-&gt;billing['city']);
 
       if ($order-&gt;billing['country']['iso_code_2'] == 'US') {
</pre><pre class="diff" id="removed">-        $billing_state_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_id = '" . (int)$order-&gt;billing['zone_id'] . "'");
-        $billing_state = tep_db_fetch_array($billing_state_query);
</pre><pre class="diff" id="added">+        $Qstate = $osC_Database-&gt;query('select zone_code from :table_zones where zone_id = :zone_id');
+        $Qstate-&gt;bindTable(':table_zones', TABLE_ZONES);
+        $Qstate-&gt;bindInt(':zone_id', $order-&gt;billing['zone_id']);
+        $Qstate-&gt;execute();
</pre><pre class="diff" id="context"> 
</pre><pre class="diff" id="removed">-        $process_button_string .= osc_draw_hidden_field('Bstate', $<span id="removedchars">billing_state['zone_code']</span>);
</pre><pre class="diff" id="added">+        $process_button_string .= osc_draw_hidden_field('Bstate', $<span id="addedchars">Qstate-&gt;value('zone_code')</span>);
</pre><pre class="diff" id="context">       } else {
         $process_button_string .= osc_draw_hidden_field('Bstate', $order-&gt;billing['state']);
       }
</pre></div>
<center><small><a href="http://www.badgers-in-foil.co.uk/projects/cvsspam/" title="commit -&gt; email">CVSspam</a> 0.2.9</small></center>
</body></html>


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click