Simple-Pokes/install.php at master · SMFTricks/Simple-Pokes · 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
<?php

/**
 * @package Simple Pokes
 * @version 2.1
 * @author Diego Andrés <diegoandres_cortes@outlook.com>
 * @copyright Copyright (c) 2022, SMF Tricks
 * @license https://www.mozilla.org/en-US/MPL/2.0/
 */

	if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
		require_once(dirname(__FILE__) . '/SSI.php');

	elseif (!defined('SMF'))
		exit('<b>Error:</b> Cannot install - please verify you put this in the same place as SMF\'s index.php.');

	global $smcFunc, $context;

	db_extend('packages');

	if (empty($context['uninstalling']))
	{
		// Enable the alert by default
		$smcFunc['db_insert'](
			'ignore',
			'{db_prefix}user_alerts_prefs',
			array(
				'id_member' => 'int',
				'alert_pref' => 'string',
				'alert_value' => 'int',
			),
			array(
				array(
					0,
					'poked',
					1,
				),
			),
			array('id_task')
		);

		// Pokes log
		$tables[] = array(
			'table_name' => '{db_prefix}pokes',
			'columns' => array(
				array(
					'name' => 'id_member',
					'type' => 'mediumint',
					'size' => 8,
					'not_null' => true,
					'default' => 0,
					'unsigned' => true,
				),
				array(
					'name' => 'id_poker',
					'type' => 'mediumint',
					'size' => 8,
					'not_null' => true,
					'default' => 0,
					'unsigned' => true,
				),
				array(
					'name' => 'date',
					'type' => 'int',
					'size' => 10,
					'not_null' => true,
					'default' => '0',
					'unsigned' => true,
				),
			),
			'indexes' => array(
				array(
					'type' => 'primary',
					'columns' => array('id_member', 'id_poker')
				),
			),
			'if_exists' => 'ignore',
			'error' => 'fatal',
			'parameters' => array(),
		);

		// Installing
		foreach ($tables as $table)
			$smcFunc['db_create_table']($table['table_name'], $table['columns'], $table['indexes'], $table['parameters'], $table['if_exists'], $table['error']);
	}