One Hat Cyber Team

Edit File: shop-rescue.php

<?php 
if(!@include 'approve.php') die( "approve.php was not found!");
$input = $_GET;

/* get default language: we use this for the categories, manufacturers */
$query="select value from ". _DB_PREFIX_."configuration WHERE name='PS_LANG_DEFAULT'";
$res=dbquery($query);
$row = mysqli_fetch_array($res);
$id_lang = $row['value'];
?><!DOCTYPE html> 
<html lang="en"><head><meta charset="utf-8">
<title>Prestashop Shop Rescue</title>
<style>
.comment {background-color:#aabbcc}
table.spacer td {
	padding:12px;
	border: 1px solid #c3c3c3;
	border-collapse: collapse;
}

table.alterna tr:nth-of-type(4n+3) {
  background: #f5f5f5;
}

</style>
<script type="text/javascript" src="utils8.js"></script>
<script type="text/javascript" src="sorter.js"></script>
<script>
function RowSubmit(idx)
{ rowform.id_shop.value = eval("configform.id_shop"+idx+".value");
  rowform.id_shop_group.value = eval("configform.id_shop_group"+idx+".value");
  rowform.cvalue.value = eval("configform.cvalue"+idx+".value");
  rowform.fieldname.value = eval("configform.fieldname"+idx+".value");
  rowform.id_configuration.value = eval("configform.id_configuration"+idx+".value"); 
  rowform.verbose.value = configform.verbose.checked;  
  rowform.id_row.value = idx;
  document.rowform.submit();
}

function ipaddress2long()
{ var ip = document.getElementById("ipaddress");
  var long = document.getElementById("ipaddresslong");
  var parts = ip.value.split('.');
  var result = parseInt(parts[3]) + 256*parseInt(parts[2]) + 65536*parseInt(parts[1]) + 16777216*parseInt(parts[0]);
  long.value = result;
}

function long2ipaddress()
{ var ip = document.getElementById("ipaddress");
  var long = document.getElementById("ipaddresslong");
  var longv = long.value;
  var result = [longv >>> 24 & 0xFF, longv >>> 16 & 0xFF, longv >>> 8 & 0xFF, longv & 0xFF].join('.');
  ip.value = result;
}

</script>
<link rel="stylesheet" href="style1.css" type="text/css" />
</head><body>
<?php print_menubar(); ?>
<div style="float:right; "><iframe name=tank width=230 height=93></iframe></div>
<h1>Shop Rescue</h1>
This page provides a set of functions to help you when your shop is stuck behind a PHP or javascript error 
and have no longer access to your back office. The main section deals with some configuration flags. 
These are very powerful options - so take care to set them back to their original values when your 
problem is solved.<p>
<?php
   /* check that the physical_uri field in ps_shop_url refers to the actual path; if not there will be a redirect for which we must warn */
   $query = "SELECT su.*,s.active, s.name FROM "._DB_PREFIX_."shop_url su";
   $query .= " LEFT JOIN "._DB_PREFIX_."shop s ON s.id_shop = su.id_shop";
   $query .= " ORDER BY s.active DESC";
   $res=dbquery($query);
   $foundshop = false;
   if(isset($_SERVER['HTTPS']) && ($_SERVER['HTTPS'] != "off"))
   { $https = true;
   }
   else
   { $https = false;
   }
   $block = '';
   while ($row=mysqli_fetch_array($res))
   { if($https) $domain = $row["domain_ssl"]; else $domain = $row["domain"];
	 $block .= '
<br> &nbsp; &nbsp; &nbsp; &nbsp; Shop '.$row["id_shop"].': Domain=<b style="color:red;">'.$domain.'</b> AND path=<b style="color:red;">'.$row["physical_uri"].'</b>';
	 if(($row["physical_uri"] == $shoppath) && ($_SERVER['SERVER_NAME'] = $domain))
	 { $foundshop = $row["id_shop"];
	   $foundshopname = $row["name"];
	   $active = $row["active"];
	 }
   }
   if(!$foundshop)
   { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	 echo '<h1>Warning</h1>';
	 echo 'The database redirects to a different url than where your webshop is now:<br>';
	 echo ' &nbsp; &nbsp; &nbsp; &nbsp; Present shop has domain=<b style="color:red;">'.$_SERVER['SERVER_NAME'].'</b> AND path=<b style="color:red;">'.$shoppath.'</b><br>';
	 echo 'The database contains the following shop urls:';
	 echo $block.'</div>
';
     $query = "SELECT id_shop, active, name FROM "._DB_PREFIX_."shop";
     $query .= " ORDER BY deleted, active DESC, id_shop LIMIT 1";
     $res=dbquery($query);
	 list($foundshop, $active, $foundshopname) = mysqli_fetch_row($res);
   }
   
   /* the exact minimum PHP versionfor later PS 1.7 versions can be found in the file /install/install_version.php
      in the constant _PS_INSTALL_MINIMUM_PHP_VERSION_
	*/
   if(version_compare(_PS_VERSION_ , "1.6.1", "<") || defined('_TB_VERSION_'))
   { 
   }
   else if(version_compare(_PS_VERSION_ , "1.7.0", "<"))
   { if ((version_compare(phpversion(), "5.2", "<")) || (version_compare(phpversion(), "7.1", ">")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 5.2 and at most 7.1<p/></div>';
	 }
   }
   else if(version_compare(_PS_VERSION_ , "1.7.4", "<")) /* 1.7.3.x */
   { if ((version_compare(phpversion(), "5.4", "<")) || (version_compare(phpversion(), "7.2", ">=")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 5.4 and at most 7.1<p/></div>';
	 }
   }
   else if(version_compare(_PS_VERSION_ , "1.7.5", "<")) /* 1.7.4.x */
   { if ((version_compare(phpversion(), "5.6", "<")) || (version_compare(phpversion(), "7.2", ">=")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 5.6 and at most 7.1<p/></div>';
	 }
   }
   else if(version_compare(_PS_VERSION_ , "1.7.7", "<")) /* 1.7.5.x or 1.7.6.x */
   { if ((version_compare(phpversion(), "5.6", "<")) || (version_compare(phpversion(), "7.3", ">=")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 5.6 and at most 7.2<p/></div>';
	 }
   }
   else if(version_compare(_PS_VERSION_ , "1.7.8", "<")) /* 1.7.7.x */
   { if ((version_compare(phpversion(), "7.1.3", "<")) || (version_compare(phpversion(), "7.4", ">=")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 7.1.3 and at most 7.3<p/></div>';
	 }
   }
   else if(version_compare(_PS_VERSION_ , "1.7.9", "<")) /* 1.7.8.x */
   { if ((version_compare(phpversion(), "7.1", "<")) || (version_compare(phpversion(), "7.5", ">=")))
	 { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'You are running Prestashop version '._PS_VERSION_.' with PHP version '.phpversion();
	   echo '<br>The requirements for your Prestashop version are that the PHP version is at least 7.1 and at most 7.4<p/></div>';
	 }
   }
   
   if(function_exists('posix_getpwuid'))
   { $stat = stat($triplepath);
     $owner = posix_getpwuid($stat['uid']);
     if($owner["name"] == "root")
     { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	   echo '<h1>Warning</h1>';
	   echo 'The owner of shop\'s root directory is root instead of the usual www-data. This may cause problems.<p/></div>';
	 }
   }
   
 if (version_compare(_PS_VERSION_ , "1.5.0.1", ">=")) /* table is created in 1.5.0.1 */
 { $query = "SELECT count(*) AS xcount FROM "._DB_PREFIX_."cart_rule_combination";
   $res=dbquery($query);
   $row=mysqli_fetch_array($res);
   if(intval($row["xcount"]) > 1000000)
   { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	 echo '<h1>Warning</h1>';
	 echo 'You have a very big '._DB_PREFIX_.'cart_rule_combination table that could slow down your shop. 
	 If this is a deliberate choice it is ok. 
	 However, it may be related to <a href="https://github.com/PrestaShop/PrestaShop/issues/10003" target=_blank>this bug</a>. So you may consult that discussion.<p/></div>';
   }
 }
   
   
/* This value is not or not always updated
   $ps_version_db = get_configuration_value('PS_VERSION_DB');
   if(!defined('_TB_VERSION_') && ($ps_version_db != _PS_VERSION_))
   { echo '<div style="width:100%; min-height:60px; background-color:yellow; padding-left:50px; color:#666666;">';
	 echo '<h1>Warning</h1>';
	 echo 'The version of your Prestashop files ('._PS_VERSION_.') does not match with that stored in the database('.$ps_version_db.'). This may have been caused by a problematic upgrade.<p/></div>';
   }
*/  
   if (version_compare(_PS_VERSION_ , "1.7", ">="))
   { $tquery = "SELECT theme_name AS name FROM "._DB_PREFIX_."shop";
     $tquery .= " WHERE id_shop=".$foundshop;
     $tres=dbquery($tquery);
     $trow=mysqli_fetch_array($tres);
   }
   else
   { $tquery = "SELECT t.name FROM "._DB_PREFIX_."theme t";
	 $tquery .= " LEFT JOIN "._DB_PREFIX_."shop s ON t.id_theme=s.id_theme";
	 $tquery .= " WHERE id_shop=".$foundshop;
     $tres=dbquery($tquery);
     $trow=mysqli_fetch_array($tres);
   }
   
   echo 'You are now using database <b>'._DB_NAME_.'</b> for shop <b>'.$foundshopname.'</b> (<b>'.$_SERVER['SERVER_NAME'].$shoppath.'</b>; id_shop='.$foundshop.') with theme <b>'.$trow["name"].'</b>';
   if (version_compare(_PS_VERSION_ , "1.7", "<"))
   { if(file_exists($triplepath."themes/".$trow["name"]."/config.xml"))
	   $contents = file_get_contents($triplepath."themes/".$trow["name"]."/config.xml");
	 else if(file_exists($triplepath."themes/".$trow["name"]."/Config.xml"))
	   $contents = file_get_contents($triplepath."themes/".$trow["name"]."/Config.xml");
	 else echo " <b>No config.xml found</b>";
	 if(isset($contents))
     { $elts = new SimpleXMLElement($contents);
	   if($elts->version['value'])
	     $version = $elts->version['value'];
	   else 
	     $version = $elts['version'];
	   echo " (version ".$version.")";
	 }
   }
   else
   { $contents = file($triplepath."themes/".$trow["name"]."/config/theme.yml");
     $parent = "";
     foreach($contents AS $content)
	 { $content = trim($content);
	   if(substr($content,0,7) == "parent:")
	   { $parent = trim(substr($content,7));
	   }
	 }
	 if($parent != "")
	 { $contents = file($triplepath."themes/".$parent."/config/theme.yml");
	 }
	 $version = "";
     foreach($contents AS $content)
	 { $content = trim($content);
	   if(substr($content,0,8) == "version:")
	   { $version = trim(substr($content,8));
	   }
	 }
	 if($parent != "")
	   echo " (childtheme of ".$parent." version ".$version.")";
	 else
	   echo " (version ".$version.")";
   } 
   echo '. ';
   if($active == 0) echo " Shop is <b>not active</b>.";
   
   echo '<br>You php.ini is located at '.php_ini_loaded_file();

$index = 0;
echo '<form name=configform><p>';
echo '<input type=checkbox name=verbose> verbose';
echo '<table class="triplemain alterna" style="margin-top:-15px">';
echo '<thead><tr style="background-color:#fff"><td colspan=6><b>Configuration flags</b></td></tr>';
echo '<tr><td colspan=6>At the top of this page you can set some configuration settings. 
By default only settings for all shops/shopgroups (NULL-NULL) are shown. 
More specific settings will only be shown when they are already in the database.
The default options are underlined.<br>
Lines with a yellow background are showstoppers for a functioning shop.
<p>The bottom half of this page offers some tools that can help fixing a faulty webshop.
</td></tr>';
echo '<tr style="background-color:#fff"><td>Field</td><td>shopgroup</td><td>shop</td><td>Value</td><td></td><td>Comment</td></tr></thead><tbody>';

print_config_row("PS_SHOP_ENABLE","",1,"Enable shop vs maintenance mode");
  $index++;
  print_config_row("PS_REWRITING_SETTINGS","",1,"Friendly url");
  $index++;
  print_config_row("PS_SSL_ENABLED","",0,"Enable SSL");
  $index++;  
  print_config_row("PS_SSL_ENABLED_EVERYWHERE","",0,"SSL everywhere");
  $index++;  
  print_config_row("PS_ALLOW_ACCENTED_CHARS_URL","",0,"Accented url");
  $index++;
  print_config_row("PS_DISABLE_OVERRIDES","",0,"Disable all overrides");  
  $index++;
  print_config_row("PS_DISABLE_NON_NATIVE_MODULE","",0,"Disable non PrestaShop modules");  
  $index++;
  print_config_row("PS_CSS_THEME_CACHE","",0,"Smart cache for CSS");  
  $index++;
  print_config_row("PS_JS_THEME_CACHE","",0,"Smart cache for JavaScript");  
  $index++;
  print_config_row("PS_JS_DEFER","",0,"Move JavaScript to the end");  
  $index++;
  print_config_row("PS_HTML_THEME_COMPRESSION","",0,"Minify HTML");  
  $index++;
  print_config_row("PS_JS_HTML_THEME_COMPRESSION","",0,"Compress inline JavaScript in HTML");
  $index++;
  print_config_row("PS_HTACCESS_CACHE_CONTROL","",0,"Apache optimization"); 
  $index++;
  print_config_row("PS_SMARTY_CACHE","",1,"enable cache"); 
  $index++;  
  print_config_row("PS_SMARTY_CLEAR_CACHE",array("everytime"=>"Clear cache everytime something has been modified","never"=>"Never clear cache files"),"everytime",""); 
  $index++;  
  print_config_row("PS_SMARTY_FORCE_COMPILE",array("0"=>"Never recompile template files","1"=>"Recompile templates if the files have been updated","2"=>"Force compilation"),0,""); 
  $index++; 
  print_config_row("PS_HTACCESS_DISABLE_MULTIVIEWS","",0,"Disable Apache's MultiViews option");
  $index++;
  print_config_row("PS_HTACCESS_DISABLE_MODSEC","",0,"Disable Apache's mod_security module"); 
  $index++;
  print_config_row("PS_COOKIE_CHECKIP","",1,"Check the cookie's IP address"); 
  $index++;
  print_config_row("PRESTASTORE_LIVE","",1,"Automatically check for module updates");

echo '</tbody></table></form>';
  
  echo '<p>';

echo '<table class="spacer" style="width:100%">';
  echo '<tr><td><b>Reset Cacheflags</b><br>';
  echo 'Prestashop maintains cache flags in the product tables that check whether a product has attachments and what its default attribute is.
  This function will check and correct those values.';
  echo '</td><td>';
  echo '<form name=cacheflagsform action="shop-rescue-proc.php" method=post target=tank onsubmit=formprepare("cacheflagsform")>';
  echo '<input type=hidden name="subject" value="resetcacheflags" ><input type=hidden name=verbose>';
  echo '<input type=submit value="reset cacheflags"></form></td></tr>';
  
  echo '<tr><td><b>Clear Prestashop Cookies</b><br>';
  echo 'Empty Prestashop cookies on this browser.';
  echo '</td><td>';
  echo '
  <form name=cookieform action="cleanup-proc.php" method=post target=tank onsubmit=formprepare("cookieform")>';
  echo '<input type=hidden name="subject" value="clearPScookies" ><input type=hidden name=verbose>';
  echo '<input type=submit value="clear Prestashop Cookies"></form></td></tr>';
  
  echo '<tr><td><b>Look for zero length files</b><br>';
  echo 'A common source of trouble is file corruption. Many of those concern zero length files. Possible cause: ftp errors.';
  echo '<br><form name=zerofileform action="shop-rescue-proc.php" method=post target=_blank onsubmit=formprepare("zerofileform")>';
  echo '<input type=checkbox name="includeimgs"> include image directory ';
  echo '</td><td>';
  echo '<input type=hidden name="subject" value="zerolengthcheck" ><input type=hidden name=verbose>';
  echo '<input type=submit value="check for zerolengths"></form></td></tr>';
  
  echo '<tr><td><b>Server settings</b><br>';
  echo 'Check the server settings: Are the recommended php and Apache modules loaded? Are the recommended php.ini settings 
  matched?';
  echo '</td><td>';
  echo '<form name=requireform action="server-settings.php" method=post target=_blank>';
  echo '<input type=hidden name=verbose>';
  echo '<input type=submit value="server settings"></form></td></tr>';
  
  echo '<tr><td><b>Database version check</b><br>';
  echo 'Some people use dubious upgrade methods that leave the database in some intermediate state.';
  echo 'This function helps to find out whether a shop has been abused in such a way.';
  echo '</td><td>';
  echo '<a href="dbversioncheck.php?dbname='._DB_NAME_.'" target=_blank style="background-color:#2c82c9; color:white; text-decoration:none; padding:5px;">database version check</a>';
  echo '</td></tr>';
  
  echo '<tr><td><b>Excess tables and fields</b><br>';
  echo 'This function shows you a list of the database tables that do not belong to Prestashop itself
  and thus likely belong to one of the modules. It searches the modules to determine to which one.<br>';
  echo 'This function is meant as a tool for old shops to find out which tables belong to deleted modules
  and thus might be deleted themselves too.<br>';
  echo '<b>At the moment the list of fields comes from PS 1.6. So under 1.7 you may see some normal fields listed as excess</b><br>';
  echo 'As this script does a text search on the disk it may take some time.<br>';
  echo 'Excess fields list looks for fields that are not present in any Prestashop version. So it will overlook fields that belong in newer versions.<br>';
  echo 'This tool is not perfect. Use your common sense too.';
  echo '</td><td>';
  echo '<a href="excess-tables.php" target=_blank style="color:white; text-decoration:none;"><button style="background-color:#2c82c9;">excess tables<br>and fields</button></a>';
  echo '</td></tr>';
  
  echo '<tr><td>';
  echo '<b>Database calibrate</b><br>';
  echo 'Many problems are caused by incorrect updates that left the database not fully compatible 
  with a new version. This function compares the database of your shop with the database of a fresh Prestashop or Thirty Bees installation of the same version. ';
  echo '<br>For the compare databases the version as stored in the database is used.<hr>';
//  $query = 'SELECT * FROM '._DB_PREFIX_.'configuration WHERE name="PS_VERSION_DB"';
//  $result = dbquery($query);
//  $row = mysqli_fetch_array($result);
//  $version = $row["value"];
  $version = _PS_VERSION_;
  if($version == "1.6.1.999")
  { echo "For Thirty Bees database version cannot be determined. You should make sure both databases are up to date.<br>";
	$version = "Thirty Bees";
  }
  else
    echo "Your shop has now version ".$version." &nbsp; &nbsp; &nbsp; ";

echo '<form name="calibrateform" action="database-calibrate.php" method=post target=_blank onsubmit=\'return formprepare("calibrateform")\'>';
  echo '<input type=hidden name=prefix value="">';
  echo '<input type=hidden name=verbose>';
  echo "Calibrate with <select name='calibratedb'><option>Select a database</option>";
  $squery = "SELECT TABLE_SCHEMA,TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%configuration_lang'";
  $sres = dbquery($squery); 
  $numrows = mysqli_num_rows($sres);
  while ($srow=mysqli_fetch_array($sres))   
  { if($srow["TABLE_SCHEMA"]==_DB_NAME_) continue;

$prefix = str_replace("configuration_lang","",$srow["TABLE_NAME"]);
    $vquery = 'SELECT value FROM `'.$srow["TABLE_SCHEMA"].'`.'.$prefix.'configuration WHERE name="PS_VERSION_DB"';
	$vres = dbquery($vquery); 
	$vrow=mysqli_fetch_array($vres);
	if($vrow["value"] == "1.6.1.999")
		$vrow["value"] = "Thirty Bees";
	echo "<option data-prefix='".$prefix."'>".$srow["TABLE_SCHEMA"]." (".$vrow["value"].")</option>";
  }
  echo "</select>";
  echo '</td><td>';
  if($numrows > 1)
    echo '
  <input type=submit value="database calibrate"></form>';
  echo '</td></tr>';
 
  echo '<tr><td><b>Config compare</b><br>';
  echo 'This function allows you to export the contents of the ps_configuration table and to compare it to a similar export from another shop.';
  echo 'This can help to find problematic settings.';
  echo '</td><td>';
  echo '<a href="configcompare.php" target=_blank style="background-color:#2c82c9; color:white; text-decoration:none; padding:5px;">config compare</a>';
  echo '</td></tr>';
  
if(version_compare(_PS_VERSION_ , "1.7.6", ">="))
{ echo '<tr><td><b>Repair ps_currency_lang issues</b><br>';
  echo '<form name=zerofileform action="shop-rescue-proc.php" method=post target=_blank>';
  echo '<input type=hidden name="subject" value="currencyrepair" ><input type=hidden name=verbose>';
  echo 'Prestashop introduced in version 1.7.6 a new table ps_currency_lang. In version 1.7.7 it added 
  a field "pattern" to this table. Many errors are related to this table not being correctly filled.
  This function checks and corrects that.';
  echo '</td><td>';
  echo '<input type=submit value="Repair ps_currency_lang"></form></td></tr>';
  echo '</td></tr>';
} 
  
  echo '<tr><td><b>File list export</b><br>';
  echo 'On the <a href="export.php">Export page</a> you will find a tool to export a file list so that you can compare the files of two shops.</td><td>';
  echo '</td></tr>';
  
  echo '<tr><td><b>Restore database</b><br>';
  echo 'After a failed upgrade it is often impossible to restore the backup that Prestashop made during the upgrade process. This function takes the backup files in which a copy of the database was stored and restores it to an empty database that you indicate.';
  echo '</td><td>';
  echo '<a href="db-restore.php" target=_blank style="background-color:#2c82c9; color:white; text-decoration:none; padding:5px;">restore database</a>';
  echo '</td></tr>';
  
  echo '<tr><td><b>Unique Maker</b><br>';
  echo 'In old shops sometimes some unique indexes have been deleted and re-imposing 
  them is impossible because doing so will produce a duplicate key error. This function
  allows you to see which values are double and to delete those doubles.';
  echo '</td><td>';
  echo '<a href="uniquemaker.php" target=_blank style="background-color:#2c82c9; color:white; text-decoration:none; padding:5px;">Unique Maker</a>';
  echo '</td></tr>';
  
  echo '<tr><td><b>Filter PHP error log</b><br>';
  echo 'PHP error logs often contain the same error many times. ';
  echo 'This function processes your error log outputs a file where each error message is listed once - with the last datetime when it happened. Note that when your error file is very big you may experience problems with either a timeout or the upload size limit setting of your server. As a bonus it can put the last first.';
  echo '<br><form name=errorlogform action="export-proc.php" method=post target=_blank enctype="multipart/form-data" onsubmit=formprepare("errorlogform")>';
  echo 'Select the errorlog: <input type=file name="logfile">';
  echo ' &nbsp; &nbsp; <input type=checkbox name=reversed checked> reverse order';
  echo '</td><td>';
  echo '<input type=hidden name="task" value="errorlog" ><input type=hidden name=verbose>';
  echo '<button>Filter PHP<br>error log</button></form></td></tr>';
  
  
  
  
  echo '</table>';

echo '<p><center><b>Which Carriers belong to this cart?</b><br>';
  echo 'This function helps analyze why a customer sees certain carriers and others not.';
  echo '<form name="cartcarrierform" target=_blank action="cartcarriers.php">Cart id <input size=2 name=cart_id>';
  echo ' &nbsp; <input type=submit value="Get carrier settings"></form>';
  
  echo '<p><center><b>Translate IP addresses</b><br>';
  echo 'The database stores IP addresses in the connections table as long integers.<br>';
  echo 'IP address <input size=12 id="ipaddress"> &nbsp; <img src="add.gif" onclick="ipaddress2long()" style="vertical-align:middle">';
  echo ' &nbsp; <img src="remove.gif" onclick="long2ipaddress()" style="vertical-align:middle"> &nbsp; <input size=12 id="ipaddresslong"> long';

/* rowform is used for setting the configuration flags */
  echo '<div style="display:block;"><form name=rowform action="shop-rescue-proc.php" method=post target=tank>
  <table id=subtable></table>';
  echo '<input type=hidden name=fieldname><input type=hidden name=id_shop><input type=hidden name=id_shop_group>';
  echo '<input type=hidden name=cvalue><input type=hidden name=id_configuration>'; 
  echo '<input type=hidden name="subject" value="configuration">';
  echo '<input type=hidden name=id_row><input type=hidden name=verbose>';
  echo '</form></div><p>';
  
  include "footer1.php";	  
  echo '</body></html>';

echo '<img src="enter.png" title="submit row '.$index.'" onclick="RowSubmit('.$index.')"></td><td>'.$comment.'</td></tr>';
  $lastshop = $lastshopgroup = "NULL";
  while($crow = mysqli_fetch_array($cres))
  { if(($crow["id_shop"] == $lastshop) && ($crow["id_shop_group"] == $lastshopgroup))
	{ /* prevent doubles. */
	  dbquery("DELETE from ". _DB_PREFIX_."configuration WHERE id_configuration='".$crow["id_configuration"]."'");
	  continue;
	}
	$index++;
    $lastshop = $crow["id_shop"];
    $lastshopgroup = $crow["id_shop_group"];	
	echo '<tr><td>'.$configfield.'</td><td>'.$crow["id_shop_group"].'</td><td>'.$crow["id_shop"].'</td><td>'.print_options($index, $options, $default, $crow["value"]).'</td>';
    echo '<td><input type=hidden name="fieldname'.$index.'" value="'.$configfield.'">';
    echo '<input type=hidden name="id_configuration'.$index.'" value="'.$crow["id_configuration"].'">';
    echo '<input type=hidden name="id_shop_group'.$index.'" value="'.$crow["id_shop_group"].'"><input type=hidden name="id_shop'.$index.'" value="'.$crow["id_shop"].'">';
    echo '<img src="enter.png" title="submit row '.$index.'" onclick="RowSubmit('.$index.')"></td></tr>';
  }
}