public function exportSameData($directory = '')
{
$shopId = $this->context->shop->id;
if ($directory) {
self::$sameDatas = $directory;
}
$langId = Context::getContext()->language->id;
$link = mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
mysql_select_db(_DB_NAME_, $link);
$currentOption = Configuration::get('OVIC_CURRENT_DIR');
if ($currentOption) {
$currentOption .= '.';
} else {
$currentOption = '';
}
foreach (self::$tables as $table => $type) {
$fields = array();
$query2 = mysql_query('SHOW COLUMNS FROM ' . _DB_PREFIX_ . $table);
while ($row = mysql_fetch_row($query2)) {
$fields[] = $row[0];
}
$return = '';
if ($type == 'lang') {
$query1 = mysql_query('SELECT * FROM ' . _DB_PREFIX_ . $table . " Where id_lang = " . $langId);
$num_fields = mysql_num_fields($query1);
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($query1)) {
$return .= 'INSERT INTO PREFIX_' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace(array("\n", "\r"), '', $row[$j]);
if (isset($row[$j])) {
if ($fields[$j] == 'id_lang') {
$return .= '"id_lang"';
} else {
$return .= '"' . $row[$j] . '"';
}
} else {
$return .= '""';
}
if ($j < $num_fields - 1) {
$return .= ',';
}
}
$return .= ");\n";
}
}
} else {
$query1 = mysql_query('SELECT * FROM ' . _DB_PREFIX_ . $table);
$num_fields = mysql_num_fields($query1);
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($query1)) {
$return .= 'INSERT INTO PREFIX_' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace(array("\n", "\r"), '', $row[$j]);
if (isset($row[$j])) {
$return .= '"' . $row[$j] . '"';
} else {
$return .= '""';
}
if ($j < $num_fields - 1) {
$return .= ',';
}
}
$return .= ");\n";
}
}
}
$return .= "\n";
//$handle = fopen(self::$sameDatas.'store'.$shopId.'.'.$currentOption.$table.'.sql','w+');
$handle = fopen(self::$sameDatas . $currentOption . $table . '.sql', 'w+');
fwrite($handle, $return);
fclose($handle);
}
return true;
}
/**
* generate html user table
*
* @access protected
*
* @author patrick.kracht, thorsten.moll
*/
protected function show_user_table($limit = 10)
{
$this->set_table_order("user_table", array("mid", "email", "firstname", "lastname", "groupname"), 0);
$query = "SELECT COUNT( email ) AS total FROM tr_users;";
$entry = $_SESSION[$_SESSION["_SqlType"]]->query_first($query);
$plink = new PageLink("user_table", $entry["total"]);
$query = "SELECT u.mid AS MID, u.email AS Email, ";
$query .= "u.firstname AS Vorname, u.lastname AS Nachname, g.groupname AS Gruppe ";
$query .= "FROM tr_users u ";
$query .= "LEFT JOIN tr_groups g USING ( gid ) ";
$query .= "GROUP BY mid ";
$query .= "ORDER BY " . $_SESSION["_OrderBy"]["user_table"] . " " . $plink->get_query_limit();
$users = $this->query2table($query, "user_table", array(60, 290, 200, 200), true, true);
$_SESSION["HTML"]->assign("users.html", "<!--USER_TABLE-->", $users);
$_SESSION["HTML"]->assign("users.html", "<!--USER_PAGE_LINK-->", $plink);
}
<?php
require_once dirname(__FILE__) . '../../../config/config.inc.php';
require_once dirname(__FILE__) . '../../../init.php';
require_once dirname(__FILE__) . '/pagelink.php';
$module = new PageLink();
$response = new stdClass();
if (!Tools::isSubmit('secure_key') || Tools::getValue('secure_key') != $module->secure_key) {
$response->status = 0;
$response->fileName = "";
$response->msg = $module->l("you need to login with the admin account.");
} else {
$fileType = strtolower(pathinfo($_FILES["uploader"]["name"], PATHINFO_EXTENSION));
$fileName = time() . '.' . $fileType;
$fileTemp = $module->pathImage . 'temps/' . $fileName;
if (isset($_POST['width']) && intval($_POST['width']) > 0) {
$width = intval($_POST['width']);
} else {
$width = null;
}
if (isset($_POST['height']) && intval($_POST['height']) > 0) {
$height = intval($_POST['height']);
} else {
$height = null;
}
if (isset($_POST['maxFileSize']) && $_POST['maxFileSize']) {
$maxFileSize = $_POST['maxFileSize'];
}
$maxFileSize = 1;
// MB
if (isset($_POST['uploadType']) && $_POST['uploadType']) {