Code Duplication    Length = 45-71 lines in 3 locations

versions/extcal_2_28.php 1 location

@@ 20-90 (lines=71) @@
17
 * @author              JJDai <http://xoops.kiolo.com>
18
 **/
19
//----------------------------------------------------
20
class Extcal_2_28
21
{
22
    //----------------------------------------------------
23
24
    /**
25
     * @param XoopsModule $module
26
     * @param             $options
27
     */
28
    public function __construct(XoopsModule $module, $options)
29
    {
30
        global $xoopsDB;
31
32
        $this->addTable_etablissement();
33
        $this->alterTable_event();
34
    }
35
36
    //----------------------------------------------------
37
    public function alterTable_event()
38
    {
39
        global $xoopsDB;
40
41
        $tbl = $xoopsDB->prefix('extcal_event');
42
43
        $sql = <<<__sql__
44
ALTER TABLE `{$tbl}`
45
  add  `event_organisateur` varchar(255) NOT NULL default '',
46
  add  `event_picture1` varchar(255) NOT NULL,
47
  add  `event_picture2` varchar(255) NOT NULL,
48
  add  `event_price` varchar(255) NOT NULL default '',
49
  add  `event_etablissement` int(5) NOT NULL DEFAULT '1';
50
__sql__;
51
52
        $xoopsDB->queryF($sql);
53
    }
54
55
    //----------------------------------------------------
56
    public function addTable_etablissement()
57
    {
58
        global $xoopsDB;
59
60
        $tbl = $xoopsDB->prefix('extcal_etablissement');
61
62
        $sql = <<<__sql__
63
CREATE TABLE `{$tbl}` (
64
  `id` int(5) NOT NULL auto_increment,
65
  `nom` varchar(255) NOT NULL,
66
  `desc` text NOT NULL,
67
  `logo` varchar(255) NOT NULL,
68
  `categorie` varchar(255) NOT NULL,
69
  `adresse` varchar(255) NOT NULL,
70
  `adresse2` varchar(255) NOT NULL,
71
  `cp` varchar(10) NOT NULL,
72
  `ville` varchar(50) NOT NULL,
73
  `tel_fixe` varchar(20) NOT NULL,
74
  `tel_portable` varchar(20) NOT NULL,
75
  `mail` varchar(255) NOT NULL,
76
  `site` varchar(255) NOT NULL,
77
  `horaires` text NOT NULL,
78
  `divers` text NOT NULL,
79
  `tarifs` text NOT NULL,
80
  `map` text NOT NULL,
81
82
  PRIMARY KEY  (`id`)
83
) ENGINE = MYISAM ;
84
__sql__;
85
86
        $xoopsDB->queryF($sql);
87
        //---------------------------------------------------
88
    }
89
    //-----------------------------------------------------------------
90
}   // fin de la classe
91

versions/extcal_2_33.php 1 location

@@ 20-65 (lines=46) @@
17
 * @author              JJDai <http://xoops.kiolo.com>
18
 **/
19
//----------------------------------------------------
20
class Extcal_2_33
21
{
22
    //----------------------------------------------------
23
24
    /**
25
     * @param XoopsModule $module
26
     * @param             $options
27
     */
28
    public function __construct(XoopsModule $module, $options)
29
    {
30
        global $xoopsDB;
31
32
        $this->alterTable_cat();
33
        $this->alterTable_eventmember();
34
    }
35
36
    //----------------------------------------------------
37
    public function alterTable_cat()
38
    {
39
        global $xoopsDB;
40
        $tbl = $xoopsDB->prefix('extcal_cat');
41
42
        $sql = <<<__sql__
43
ALTER TABLE `{$tbl}`
44
  ADD `cat_weight` INT NOT NULL DEFAULT '0';
45
__sql__;
46
47
        $xoopsDB->queryF($sql);
48
    }
49
50
    //----------------------------------------------------
51
    public function alterTable_eventmember()
52
    {
53
        global $xoopsDB;
54
        $tbl = $xoopsDB->prefix('eventmember');
55
56
        $sql = <<<__sql__
57
ALTER TABLE `{$tbl}`
58
  ADD `status` INT NOT NULL DEFAULT '0';
59
__sql__;
60
61
        $xoopsDB->queryF($sql);
62
    }
63
64
    //-----------------------------------------------------------------
65
}   // fin de la classe
66

versions/extcal_2_37.php 1 location

@@ 20-64 (lines=45) @@
17
 * @author              JJDai <http://xoops.kiolo.com>
18
 **/
19
//----------------------------------------------------
20
class Extcal_2_37
21
{
22
    //----------------------------------------------------
23
24
    /**
25
     * @param XoopsModule $module
26
     * @param             $options
27
     */
28
    public function __construct(XoopsModule $module, $options)
29
    {
30
        global $xoopsDB;
31
32
        $this->alterTable_event();
33
        $this->alterTable_cat();
34
    }
35
36
    //----------------------------------------------------
37
    public function alterTable_event()
38
    {
39
        global $xoopsDB;
40
        $tbl = $xoopsDB->prefix('extcal_event');
41
42
        $sql = <<<__sql__
43
ALTER TABLE `{$tbl}` ADD `event_icone` VARCHAR(50) NOT NULL;
44
__sql__;
45
46
        $xoopsDB->queryF($sql);
47
    }
48
49
    //-----------------------------------------------------------------
50
51
    public function alterTable_cat()
52
    {
53
        global $xoopsDB;
54
        $tbl = $xoopsDB->prefix('extcal_cat');
55
56
        $sql = <<<__sql__
57
ALTER TABLE `{$tbl}` ADD `cat_icone` VARCHAR(50) NOT NULL ;
58
__sql__;
59
60
        $xoopsDB->queryF($sql);
61
    }
62
63
    //-----------------------------------------------------------------
64
}   // fin de la classe
65