mod-recycleurs/install.php at develop · OGSteam/mod-recycleurs · 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
<?php

/**
 * Fichier installation du mod recycleurs
 *
 * @author deusirae
 * @package recycleurs
 * @version 1.0a
 * @link https://ogsteam.eu
 **/

//L'appel direct est interdit
if (!defined('IN_SPYOGAME')) die("Hacking attempt");

global $db, $table_prefix;
$is_ok = false;
$mod_folder = "recycleurs";
$is_ok = install_mod($mod_folder);
mod_set_option('recy_limit', 10);
if ($is_ok == true) {
    define("TABLE_RECYCLEURS", $table_prefix . "recycleurs");
    define("TABLE_PHALANGES", $table_prefix . "phalanges");
    define("TABLE_XTENSE_CALLBACKS", $table_prefix . "xtense_callbacks");

    $query = "DROP TABLE IF EXISTS " . TABLE_PHALANGES;
    $db->sql_query($query);

    $query = "DROP TABLE IF EXISTS " . TABLE_RECYCLEURS;
    $db->sql_query($query);


    $query = "CREATE TABLE " . TABLE_RECYCLEURS . " (
            `id` INT NOT NULL AUTO_INCREMENT ,
            `user_name` VARCHAR( 255 ) NOT NULL default '0',
            `galaxie` VARCHAR( 2 ) NOT NULL ,
            `systeme` VARCHAR( 3 ) NOT NULL ,
            `position` VARCHAR( 2 ) NOT NULL ,
            `porte` VARCHAR( 50 ) NOT NULL ,
            `nombrerecy` VARCHAR( 255 ) NOT NULL ,
            `time` int(11) NOT NULL default '0',
            PRIMARY KEY ( `id` )
        )";
    $db->sql_query($query);

    $query = "CREATE TABLE " . TABLE_PHALANGES . " (
            `id` INT NOT NULL AUTO_INCREMENT ,
            `user_name` VARCHAR( 255 ) NOT NULL default '0',
            `galaxie` VARCHAR( 2 ) NOT NULL ,
            `systeme` VARCHAR( 3 ) NOT NULL ,
            `position` VARCHAR( 2 ) NOT NULL ,
            `systemea` VARCHAR( 3 ) NOT NULL ,
            `systemep` VARCHAR( 3 ) NOT NULL ,
            `time` int(11) NOT NULL default '0',
            PRIMARY KEY ( `id` )
        )";
    $db->sql_query($query);

    // Insertion de la liaison entre Xtense v2 et cdr
    // Quelle est l'ID du mod ?
    // On récupère le n° d'id du mod
    $query = "SELECT `id` FROM `" . TABLE_MOD . "` WHERE `action`='recycleurs' AND `active`='1' LIMIT 1";
    $result = $db->sql_query($query);
    $mod_id = $db->sql_fetch_row($result);
    $mod_id = $mod_id[0];

    // On regarde si la table xtense_callbacks existe :
    $result = $db->sql_query('SHOW tables LIKE "' . TABLE_XTENSE_CALLBACKS . '"');
    if ($db->sql_numrows($result) != 0) {
        // Maintenant on regarde si recycleurs est dedans
        $result = $db->sql_query("SELECT * FROM " . TABLE_XTENSE_CALLBACKS . " WHERE mod_id = '$mod_id'");
        $nresult = $db->sql_numrows($result);

        // S'il n'y est pas : alors on l'ajoute !

        if ($nresult == 0) {
            $db->sql_query("INSERT INTO " . TABLE_XTENSE_CALLBACKS . " (mod_id, function, type, active) VALUES ('" . $mod_id . "', 'recycleurs_import', 'fleet', '1')");
            $db->sql_query("INSERT INTO " . TABLE_XTENSE_CALLBACKS . " (mod_id, function, type, active) VALUES ('" . $mod_id . "', 'phalanx_import', 'buildings', '1')");
        }
    }
} else {
    echo "<script>alert('Désolé, un problème a eu lieu pendant l\'installation, corrigez les problèmes survenue et réessayez.');</script>";
}