source: extensions/adult_content/maintain.inc.php @ 21047

Last change on this file since 21047 was 21047, checked in by flop25, 11 years ago

-compatibility 2.5 (only)
-changing config variables (assoc array)
-adding a pwg stuffs block

ToDo: enable the option for the block
File size: 6.4 KB
Line 
1<?php
2
3function plugin_install()
4{
5  global $conf;
6
7////////////créer groupe////////////
8  $query = '
9INSERT INTO '.GROUPS_TABLE.'
10  (name)
11  VALUES
12  (\'+18\')
13;';
14  pwg_query($query);
15  $query = '
16INSERT INTO '.GROUPS_TABLE.'
17  (name)
18  VALUES
19  (\'16-17\')
20;';
21  pwg_query($query);
22  $query = '
23INSERT INTO '.GROUPS_TABLE.'
24  (name)
25  VALUES
26  (\'nothing\')
27;';
28  pwg_query($query);
29////////////créer user////////////
30        include_once(PHPWG_ROOT_PATH.'include/functions_user.inc.php');
31        register_user('18', 'adult_content', '');
32        register_user('16', 'adult_content', '');
33
34////////////placer dans group 16////////////
35    $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'16-17\') ;');
36    $data_group = pwg_db_fetch_array($result);
37          pwg_query('INSERT INTO '.USER_GROUP_TABLE.' VALUES(\''.get_userid('16').'\', \''.$data_group['id'].'\' )' );
38
39////////////placer dans group 18////////////
40  $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'+18\') ;');
41  $data_group = pwg_db_fetch_array($result);
42          pwg_query('INSERT INTO '.USER_GROUP_TABLE.' VALUES(\''.get_userid('18').'\', \''.$data_group['id'].'\' )' );
43
44////////////placer dans group nothing////////////
45  $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'nothing\') ;');
46  $data_group = pwg_db_fetch_array($result);
47          pwg_query('INSERT INTO '.USER_GROUP_TABLE.' VALUES(\''.$conf['guest_id'].'\', \''.$data_group['id'].'\' )' );
48
49/////////////Config plugin
50    $config_start=array('menublock_for_guest'=>true,'block_on_index'=>false,'manage_what'=>'both');
51    $q = '
52INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment)
53        VALUES
54        ("ad_c_plugin" , "'.pwg_db_real_escape_string(serialize($config_start)).'" , "Plugin adult_content : menublock_for_guest, block_on_index, manage_what");';
55    pwg_query($q);
56
57}
58
59
60
61function plugin_activate()
62{
63  global $conf;
64///user exist ?///
65        $query = '
66        SELECT COUNT(*) AS result FROM '.USERS_TABLE.'
67        WHERE username IN (\'18\')
68        ;';
69        $data_user = pwg_db_fetch_array(pwg_query($query));
70        $exist = $data_user['result'];
71        if ( $exist == 0 )
72        {
73                register_user('18', 'adult_content', '');
74        }
75       
76        $query = '
77        SELECT COUNT(*) AS result FROM '.USERS_TABLE.'
78        WHERE username IN (\'16\')
79        ;';
80        $data_user = pwg_db_fetch_array(pwg_query($query));
81        $exist = $data_user['result'];
82        if ( $exist == 0 )
83        {
84                register_user('16', 'adult_content', '');
85        }
86///groups///
87  $query = 'INSERT IGNORE INTO '.GROUPS_TABLE.' (name) VALUES (\'+18\'),(\'16-17\'),(\'nothing\') ;';
88        pwg_query($query);
89////////////placer dans group 18////////////
90  $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'+18\') ;');
91  $data_group = pwg_db_fetch_array($result);
92  pwg_query('INSERT IGNORE INTO '.USER_GROUP_TABLE.' VALUES(\''.get_userid('18').'\', \''.$data_group['id'].'\' )' );
93////////////placer dans group 16////////////
94  $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'16-17\') ;');
95  $data_group = pwg_db_fetch_array($result);
96  pwg_query('INSERT IGNORE INTO '.USER_GROUP_TABLE.' VALUES(\''.get_userid('16').'\', \''.$data_group['id'].'\' )' );
97////////////placer dans group nothing////////////
98  $result = pwg_query('SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'nothing\') ;');
99  $data_group = pwg_db_fetch_array($result);
100  pwg_query('INSERT IGNORE INTO '.USER_GROUP_TABLE.' VALUES(\''.$conf['guest_id'].'\', \''.$data_group['id'].'\' )' );
101       
102        ////////////mis en generic////////////
103        $query = '
104        UPDATE '.USER_INFOS_TABLE.'
105        SET status=\'generic\'
106        WHERE user_id IN (\''.get_userid('16').'\')
107        ;';
108        pwg_query($query);
109       
110        $query = '
111        UPDATE '.USER_INFOS_TABLE.'
112        SET status=\'generic\'
113        WHERE user_id IN (\''.get_userid('18').'\')
114        ;';
115        pwg_query($query);
116       
117        //////////// Check Config
118        $query = '
119        SELECT COUNT(*) AS result FROM '.CONFIG_TABLE.'
120        WHERE param IN (\'ad_c_plugin\')
121        ;';
122        $data_table = pwg_db_fetch_array(pwg_query($query));
123        $exist = $data_table['result'];
124        if ( $exist == 0 )
125        {
126          $config_start=array('menublock_for_guest'=>true,'block_on_index'=>false,'manage_what'=>'both');
127    $q = '
128    INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment)
129    VALUES
130      ("ad_c_plugin" , "'.pwg_db_real_escape_string(serialize($config_start)).'" , "Plugin adult_content : menublock_for_guest, block_on_index, manage_what");';
131    pwg_query($q);
132        } 
133        else {
134                $query = '
135    SELECT value FROM '.CONFIG_TABLE.'
136    WHERE param IN (\'ad_c_plugin\')
137    ;';
138    $data_conf = pwg_db_fetch_array(pwg_query($query));
139    $cf=@unserialize($data_conf);
140    $nbr=count($cf);
141       
142          if ($nbr!=3)
143          {
144      $config_start=array('menublock_for_guest'=>true,'block_on_index'=>false,'manage_what'=>'both');
145      $q = '
146      UPDATE ' . CONFIG_TABLE . ' SET
147      param="ad_c_plugin", value="'.pwg_db_real_escape_string(serialize($config_start)).'", comment="Plugin adult_content : menublock_for_guest, block_on_index, manage_what"
148      WHERE param IN (\'ad_c_plugin\');';
149      pwg_query($q);
150    }
151        }
152       
153}//fin active
154
155
156
157
158function plugin_uninstall()
159{
160  include_once(PHPWG_ROOT_PATH.'include/functions_user.inc.php');
161////////////suppr user////////////
162  delete_user(get_userid('18'));
163  delete_user(get_userid('16'));
164 
165////////////suppr assoc user all /groupe 16////////////
166    $query = '
167SELECT id FROM '.GROUPS_TABLE.'
168  WHERE name IN (\'16-17\')
169;';
170    $data_group = pwg_db_fetch_array(pwg_query($query));
171          pwg_query('DELETE FROM '.USER_GROUP_TABLE.' WHERE group_id IN (\''.$data_group['id'].'\')' );
172         
173////////////suppr assoc user all /groupe 18////////////
174    $query = '
175SELECT id FROM '.GROUPS_TABLE.'
176  WHERE name IN (\'+18\')
177;';
178    $data_group = pwg_db_fetch_array(pwg_query($query));
179          pwg_query('DELETE FROM '.USER_GROUP_TABLE.' WHERE group_id IN (\''.$data_group['id'].'\')' );
180
181////////////suppr assoc user all /groupe nothing////////////
182    $query = '
183SELECT id FROM '.GROUPS_TABLE.'
184  WHERE name IN (\'nothing\')
185;';
186    $data_group = pwg_db_fetch_array(pwg_query($query));
187          pwg_query('DELETE FROM '.USER_GROUP_TABLE.' WHERE group_id IN (\''.$data_group['id'].'\')' );
188 
189 
190////////////suppr groupe////////////
191  $query = '
192DELETE FROM '.GROUPS_TABLE.'
193  WHERE name IN (\'+18\')
194;';
195  pwg_query($query);
196 
197  $query = '
198DELETE FROM '.GROUPS_TABLE.'
199  WHERE name IN (\'16-17\')
200;';
201  pwg_query($query);
202  $query = '
203DELETE FROM '.GROUPS_TABLE.'
204  WHERE name IN (\'nothing\')
205;';
206  pwg_query($query);
207
208//////////////// Delete config
209  pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param IN (\'ad_c_plugin\')');
210}//fin uninstall
211
212
213?>
Note: See TracBrowser for help on using the repository browser.