//////////////////////// DH ende
if (isset($_GET['kill'])) {
if ($_GET['anz'] == 1) {
echo '<p class="error">' . $lang['L_SQL_NOFIELDDELETE'] . '</p>';
} else {
$sql_alter = "ALTER TABLE `" . $databases['Name'][$dbid] . "`.`" . $_GET['tablename'] . "` DROP COLUMN `" . $_GET['kill'] . "`";
MSD_DoSQL($sql_alter);
echo '<div align="left" id="sqleditbox" style="font-size: 11px;width:90%;padding=6px;">';
echo '<p class="success">' . $lang['L_SQL_FIELDDELETE1'] . ' `' . $_GET['kill'] . '` ' . $lang['L_SQL_DELETED'] . '.</p>' . highlight_sql($out) . '</div>';
}
}
if (isset($_POST['tablecopysubmit'])) {
$table_edit_name = $_GET['tablename'];
if ($_POST['tablecopyname'] == "") {
echo '<p class="error">' . $lang['L_SQL_NODEST_COPY'] . '</p>';
} elseif (Table_Exists($databases['Name'][$dbid], $_POST['tablecopyname'])) {
echo '<p class="error">' . $lang['L_SQL_DESTTABLE_EXISTS'] . '</p>';
} else {
Table_Copy("`" . $databases['Name'][$dbid] . "`.`" . $table_edit_name . "`", $_POST['tablecopyname'], $_POST['copyatt']);
echo '<div align="left" id="sqleditbox">';
echo $_POST['copyatt'] == 0 ? '<p class="success">' . sprintf($lang['L_SQL_SCOPY'], $table_edit_name, $_POST['tablecopyname']) . '.</p>' : sprintf($lang['L_SQL_TCOPY'], $table_edit_name, $_POST['tablecopyname']) . '</p>';
echo highlight_sql($out) . '</div>';
$tablename = $_POST['tablecopyname'];
}
}
if (isset($_POST['newtablesubmit'])) {
if ($_POST['newtablename'] == "") {
echo '<p class="error">' . $lang['L_SQL_TABLENONAME'] . '</p>';
} else {
$sql_alter = "CREATE TABLE `" . $databases['Name'][$dbid] . "`.`" . $_POST['newtablename'] . "` (`id` int(11) unsigned not null AUTO_INCREMENT PRIMARY KEY ) " . (MSD_NEW_VERSION ? "ENGINE" : "TYPE") . "=MyISAM;";
MSD_DoSQL($sql_alter);
Copyright (c) 2002 osCommerce
Released under the GNU General Public License
*/
require 'includes/application_top.php';
function Table_Exists($table_name)
{
$Table = mysql_query("show tables like '" . $table_name . "'");
if (mysql_fetch_row($Table) === false) {
return false;
}
return true;
}
$filename = DIR_FS_CATALOG . '/temp/custgroups.csv';
if (Table_Exists("groups")) {
$group_query_raw = "SELECT groups_id, groups_name FROM " . TABLE_GROUPS;
$group_query = tep_db_query($group_query_raw);
// $num_rows = tep_db_num_rows($product_query);
while ($groups = tep_db_fetch_array($group_query)) {
// $rows++;
// if (strlen($rows) < 2) {
// $rows = '0' . $rows;
// }
$csv_accum .= $groups['groups_id'] . ";" . $groups['groups_name'] . "\n";
}
$melding = "Bestand klantgroepen werd aangemaakt: " . $filename;
} else {
$csv_accum = '';
$melding = "Tabel groups bestaat niet!";
}
