<?php
if(isset($_POST['install'])){
include ("_mysql.php");
mysql_connect($host, $user, $pwd) or die ('No connection to mySQL server');
mysql_select_db($db) or die ('Cannot connect to database: "'.$db.'"');
mysql_query("DROP TABLE IF EXISTS ".PREFIX."shop_categories");
mysql_query("CREATE TABLE ".PREFIX."shop_categories (
catID int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
pic varchar(255) NOT NULL default '',
PRIMARY KEY (catID)
) TYPE=MyISAM AUTO_INCREMENT=1");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."shop_products");
mysql_query("CREATE TABLE ".PREFIX."shop_products (
produktID int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
preis float(8,2) NOT NULL,
cat int(11) NOT NULL default '0',
lager varchar(255) NOT NULL default '',
lieferzeit varchar(255) NOT NULL default '',
beschreibung text NOT NULL,
artikelnr char(15) NOT NULL default '',
pic varchar(255) NOT NULL default '',
comments int(1) NOT NULL DEFAULT '0',
brand text NOT NULL,
weight text NOT NULL,
share int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (produktID)
) TYPE=MyISAM AUTO_INCREMENT=1");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."shop_warenkorb");
mysql_query("CREATE TABLE ".PREFIX."shop_warenkorb (
korbID int(11) NOT NULL auto_increment,
ip varchar(255) NOT NULL default '',
user int(11) NOT NULL default '0',
anzahl varchar(255) NOT NULL default '',
produktID int(11) NOT NULL default '0',
PRIMARY KEY (korbID)
) TYPE=MyISAM AUTO_INCREMENT=1");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."shop_config");
mysql_query("CREATE TABLE ".PREFIX."shop_config(
ID int(1) NOT NULL default '1',
bankname varchar(255) NOT NULL default '',
ktno varchar(255) NOT NULL default '',
blz varchar(255) NOT NULL default '',
iban text NOT NULL,
bic text NOT NULL,
firma text NOT NULL,
inhaber text NOT NULL,
anschrift text NOT NULL,
fplz varchar(50) NOT NULL default '0',
fstadt text NOT NULL,
telefax text NOT NULL default '',
url text NOT NULL,
agb text NOT NULL,
currency text NOT NULL,
emaillogo text NOT NULL,
mwst float(8,2) NOT NULL,
checkouts int(1) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;");
/*Insert data*/
mysql_query("INSERT INTO ".PREFIX."shop_config VALUES (
'1',
'".mysql_escape_string($_POST['bankname'])."',
'".mysql_escape_string($_POST['ktno'])."',
'".mysql_escape_string($_POST['blz'])."',
'".mysql_escape_string($_POST['iban'])."',
'".mysql_escape_string($_POST['bic'])."',
'".mysql_escape_string($_POST['firma'])."',
'".mysql_escape_string($_POST['inhaber'])."',
'".mysql_escape_string($_POST['anschrift'])."',
'".mysql_escape_string($_POST['fplz'])."',
'".mysql_escape_string($_POST['fstadt'])."',
'".mysql_escape_string($_POST['telefax'])."',
'".mysql_escape_string($_POST['url'])."',
'".mysql_escape_string($_POST['agb'])."',
'".mysql_escape_string($_POST['currency'])."',
'".mysql_escape_string($_POST['emaillogo'])."',
'".mysql_escape_string($_POST['mwst'])."',
'".mysql_escape_string($_POST['checkouts'])."'
);");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."invoice");
mysql_query("CREATE TABLE ".PREFIX."invoice(
invoiceID int(11) NOT NULL AUTO_INCREMENT,
client varchar(255) NOT NULL,
date text NOT NULL,
status varchar(255) NOT NULL DEFAULT '1',
email text NOT NULL,
ordered text NOT NULL,
cost text NOT NULL,
PRIMARY KEY (invoiceID)
) TYPE=MyISAM AUTO_INCREMENT=1");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."orders");
mysql_query("CREATE TABLE ".PREFIX."orders(
orderID int(11) NOT NULL AUTO_INCREMENT,
client text NOT NULL,
total text NOT NULL,
order_email text NOT NULL,
c_firstname text NOT NULL,
c_lastname text NOT NULL,
stat int(1) NOT NULL DEFAULT '2',
date int(14) NOT NULL DEFAULT '0',
ordered text NOT NULL,
PRIMARY KEY (orderID)
) TYPE=MyISAM AUTO_INCREMENT=1");
/*SUPPORT SYSTEM*/
mysql_query("DROP TABLE IF EXISTS ".PREFIX."support");
mysql_query("CREATE TABLE `".PREFIX."support` (
`ID` int(5) NOT NULL auto_increment,
`sender` int(5) NOT NULL,
`email` varchar(255) collate latin1_general_ci NOT NULL,
`subject` varchar(255) collate latin1_general_ci NOT NULL,
`topic` int(5) NOT NULL,
`msg` text collate latin1_general_ci NOT NULL,
`date` varchar(20) collate latin1_general_ci NOT NULL,
`time` varchar(20) collate latin1_general_ci NOT NULL,
`timestamp` varchar(20) collate latin1_general_ci NOT NULL,
`status` varchar(10) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."support_topics");
mysql_query("CREATE TABLE `".PREFIX."support_topics` (
`ID` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`topic_name` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;");
mysql_query("DROP TABLE IF EXISTS ".PREFIX."support_rights");
mysql_query("CREATE TABLE `".PREFIX."support_rights` (
`userID` INT( 5 ) NOT NULL ,
`topicID` INT( 5 ) NOT NULL
) ENGINE = MYISAM ;");
mysql_query("ALTER TABLE `".PREFIX."settings` ADD `autoclose` VARCHAR( 1 ) NOT NULL ;");
mysql_query("ALTER TABLE `".PREFIX."settings` ADD `answerper` VARCHAR( 10 ) NOT NULL ;");
/*shop admin*/
mysql_query("ALTER TABLE `".PREFIX."user_groups` ADD `shop` INT( 1 ) NOT NULL AFTER `gallery` ;");
}
?> | 
« ‹ 1 2 3 4 5 6 › »
18.05.2013 - 16:29 - 2 Replies
28.03.2013 -