module_info/install.php at master · aldus/module_info · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
<?php

/**
 *
 *  @module         Module Information
 *  @version        see info.php of this module
 *  @author         Dietrich Roland Pehlke
 *  @copyright      2009-2014 Dietrich Roland Pehlke
 *  @license        http://www.gnu.org/licenses/gpl.html
 *  @license terms  see info.php of this module
 *  @platform       see info.php of this module
 *
 *
 */

if (defined('LEPTON_PATH')) {
	include(LEPTON_PATH.'/framework/class.secure.php');
} else {
	$oneback = "../";
	$root = $oneback;
	$level = 1;
	while (($level < 10) && (!file_exists($root.'/framework/class.secure.php'))) {
		$root .= $oneback;
		$level += 1;
	}
	if (file_exists($root.'/framework/class.secure.php')) {
		include($root.'/framework/class.secure.php');
	} else {
		trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR);
	}
}

/**
 *	Looking for old installations!
 */
$old_name = "modul_info";
if (file_exists( LEPTON_PATH."/modules/".$old_name)) {
	require_once( __DIR__."/upgrade.php");
	return true; // exit
}

$table = TABLE_PREFIX ."mod_module_info";

$queries = array();

$queries[] = "DROP TABLE IF EXISTS ".$table;

$query  = "CREATE TABLE ".$table." (";
$query .= "section_id	INT(11) NOT NULL PRIMARY KEY,";
$query .= "page_id		INT(11) NOT NULL,";
$query .= "modul		varchar(255) default 'no_name',";
$query .= "type			varchar(255) default 'page',";
$query .= "license		varchar(255) default 'GPL', ";
$query .= "wb_name		varchar(255) default 'no_name',";
$query .= "author		varchar(255) default 'no_name',";
$query .= "contact		varchar(255) default '' ,";
$query .= "version		varchar(255) default '0.1.0', ";
$query .= "state		varchar(255) default 'dev', ";
$query .= "see_also		varchar(255) default '' ,";
$query .= "last_info	date,";
$query .= "download		varchar(255),";
$query .= "wb_thread	varchar(255),";
$query .= "web_link		varchar(255),";
$query .= "screen		varchar(255),";
$query .= "description	text ,";
$query .= "guid			VARCHAR( 36 ) NOT NULL ,";
$query .= "platform		VARCHAR( 64 ) NOT NULL default '2.7',";
$query .= "`group`		VARCHAR(255)  NOT NULL ,";
$query .= "requires		VARCHAR(255)  NOT NULL ,";
$query .= "counter		INT(11) NOT NULL DEFAULT '0',";	// !
$query .= "rating		VARCHAR(255)  NOT NULL  DEFAULT '',";	// !
$query .= "votes		INT(11) NOT NULL DEFAULT '0',"; // !
$query .= "info			text  )";

$queries[] = $query;

$queries[] = "DROP TABLE IF EXISTS ".$table."_images";

$query = "CREATE TABLE `".$table."_images` (
  `id`		int(11)		unsigned NOT NULL AUTO_INCREMENT,
  `active`	int(1)		unsigned DEFAULT '0',
  `page_id`	int(11)		unsigned DEFAULT NULL,
  `section_id` int(11)	unsigned DEFAULT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '1',
  `src`		tinytext,
  `title`	varchar(255) DEFAULT NULL,
  `alt`		varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
);";

$queries[] = $query;

foreach($queries as &$q) {

	$database->execute_query($q);

}

?>