· 7 years ago · Jan 14, 2019, 06:52 AM
1$sql = "CREATE TABLE IF NOT EXISTS `mod_limit_purchase_config` (
2 `name` varchar(255) NOT NULL,
3 `value` text NOT NULL,
4 PRIMARY KEY (`name`)
5 ) ENGINE=MyISAM DEFAULT CHARSET=utf8";
6$result = mysqli_query($sql);
7if($result)
8{
9 $sql = "INSERT INTO mod_limit_purchase_config (`name`,`value`) VALUES
10 ('localkey', ''),
11 ('version_check', '0'),
12 ('version_new', '')";
13 $result = mysqli_query($sql);
14}
15else
16{
17 $error[] = "Can't create the table `mod_limit_purchase_config`. SQL Error: " . mysqli_error();
18}
19$sql = "CREATE TABLE IF NOT EXISTS `mod_limit_purchase` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `product_id` int(11) NOT NULL DEFAULT '0',
22 `limit` int(11) NOT NULL DEFAULT '0',
23 `error` varchar(255) NOT NULL,
24 `active` tinyint(1) NOT NULL DEFAULT '0',
25 PRIMARY KEY (`id`)
26 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
27$result = mysqli_query($sql);
28if(!$result) $error[] = "Can't create the table `mod_limit_purchase`. SQL Error: " . mysqli_error();
29if(sizeof($error))
30{
31 limit_purchase_deactivate();
32}
33return array(
34 'status' => sizeof($error) ? 'error' : 'success',
35 'description' => sizeof($error) ? implode(" -> ", $error) : '',
36);