| [ Index ] |
|
Code source de GeekLog 1.4.1 |
1 <?php 2 3 $_SQL[a] = "CREATE TABLE {$_TABLES['access']} ( 4 acc_ft_id mediumint(8) NOT NULL default '0', 5 acc_grp_id mediumint(8) NOT NULL default '0', 6 PRIMARY KEY (acc_ft_id,acc_grp_id) 7 ) TYPE=MyISAM"; 8 9 $_SQL[b] = "ALTER TABLE {$_TABLES['blocks']} ADD name varchar(48) NOT NULL default ''"; 10 $_SQL[c] = "ALTER TABLE {$_TABLES['blocks']} DROP seclev"; 11 $_SQL[d] = "ALTER TABLE {$_TABLES['blocks']} ADD onleft tinyint(3) unsigned NOT NULL default '1'"; 12 $_SQL[e] = "ALTER TABLE {$_TABLES['blocks']} ADD phpblockfn varchar(64) default ''"; 13 $_SQL[f] = "ALTER TABLE {$_TABLES['blocks']} ADD group_id mediumint(8) unsigned NOT NULL default '1'"; 14 $_SQL[g] = "ALTER TABLE {$_TABLES['blocks']} ADD owner_id mediumint(8) unsigned NOT NULL default '0'"; 15 $_SQL[h] = "ALTER TABLE {$_TABLES['blocks']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 16 $_SQL[i] = "ALTER TABLE {$_TABLES['blocks']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 17 $_SQL[j] = "ALTER TABLE {$_TABLES['blocks']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 18 $_SQL[k] = "ALTER TABLE {$_TABLES['blocks']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 19 20 $_SQL[l] = "CREATE TABLE {$_TABLES['cookiecodes']} ( 21 cc_value int(8) unsigned NOT NULL default '0', 22 cc_descr varchar(20) NOT NULL default '', 23 PRIMARY KEY (cc_value) 24 ) TYPE=MyISAM"; 25 26 $_SQL[m] = "ALTER TABLE {$_TABLES['events']} MODIFY location varchar(128) default NULL"; 27 $_SQL[n] = "ALTER TABLE {$_TABLES['events']} ADD event_type varchar(40) NOT NULL default ''"; 28 $_SQL[o] = "ALTER TABLE {$_TABLES['events']} ADD timestart time default NULL"; 29 $_SQL[p] = "ALTER TABLE {$_TABLES['events']} ADD timeend time default NULL"; 30 $_SQL[q] = "ALTER TABLE {$_TABLES['events']} ADD allday tinyint(1) NOT NULL default '0'"; 31 $_SQL[r] = "ALTER TABLE {$_TABLES['events']} ADD address1 varchar(40) default NULL"; 32 $_SQL[s] = "ALTER TABLE {$_TABLES['events']} ADD address2 varchar(40) default NULL"; 33 $_SQL[t] = "ALTER TABLE {$_TABLES['events']} ADD city varchar(60) default NULL"; 34 $_SQL[u] = "ALTER TABLE {$_TABLES['events']} ADD state char(2) default NULL"; 35 $_SQL[v] = "ALTER TABLE {$_TABLES['events']} ADD zipcode varchar(5) default NULL"; 36 $_SQL[w] = "ALTER TABLE {$_TABLES['events']} ADD group_id mediumint(8) unsigned NOT NULL default '1'"; 37 $_SQL[x] = "ALTER TABLE {$_TABLES['events']} ADD owner_id mediumint(8) unsigned NOT NULL default '0'"; 38 $_SQL[y] = "ALTER TABLE {$_TABLES['events']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 39 $_SQL[z] = "ALTER TABLE {$_TABLES['events']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 40 $_SQL[a1] = "ALTER TABLE {$_TABLES['events']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 41 $_SQL[b1] = "ALTER TABLE {$_TABLES['events']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 42 43 $_SQL[c1] = "ALTER TABLE {$_TABLES['eventsubmission']} MODIFY location varchar(128) default NULL"; 44 $_SQL[d1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD event_type varchar(40) NOT NULL default ''"; 45 $_SQL[e1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD timestart time default NULL"; 46 $_SQL[f1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD timeend time default NULL"; 47 $_SQL[g1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD allday tinyint(1) NOT NULL default '0'"; 48 $_SQL[h1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD address1 varchar(40) default NULL"; 49 $_SQL[i1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD address2 varchar(40) default NULL"; 50 $_SQL[j1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD city varchar(60) default NULL"; 51 $_SQL[k1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD state char(2) default NULL"; 52 $_SQL[l1] = "ALTER TABLE {$_TABLES['eventsubmission']} ADD zipcode varchar(5) default NULL"; 53 54 $_SQL[m1] = "CREATE TABLE {$_TABLES['features']} ( 55 ft_id mediumint(8) NOT NULL auto_increment, 56 ft_name varchar(20) NOT NULL default '', 57 ft_descr varchar(255) NOT NULL default '', 58 ft_gl_core tinyint(1) NOT NULL default '0', 59 PRIMARY KEY (ft_id), 60 KEY ft_name (ft_name) 61 ) TYPE=MyISAM"; 62 63 $_SQL[n1] = "CREATE TABLE {$_TABLES['group_assignments']} ( 64 ug_main_grp_id mediumint(8) NOT NULL default '0', 65 ug_uid mediumint(8) unsigned default NULL, 66 ug_grp_id mediumint(8) unsigned default NULL, 67 KEY ug_main_grp_id (ug_main_grp_id) 68 ) TYPE=MyISAM"; 69 70 $_SQL[o1] = "CREATE TABLE {$_TABLES['groups']} ( 71 grp_id mediumint(8) NOT NULL auto_increment, 72 grp_name varchar(50) NOT NULL default '', 73 grp_descr varchar(255) NOT NULL default '', 74 grp_gl_core tinyint(1) unsigned NOT NULL default '0', 75 PRIMARY KEY (grp_id), 76 KEY grp_name (grp_name) 77 ) TYPE=MyISAM"; 78 79 $_SQL[p1] = "ALTER TABLE {$_TABLES['links']} ADD group_id mediumint(8) unsigned NOT NULL default '1'"; 80 $_SQL[q1] = "ALTER TABLE {$_TABLES['links']} ADD owner_id mediumint(8) unsigned NOT NULL default '0'"; 81 $_SQL[r1] = "ALTER TABLE {$_TABLES['links']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 82 $_SQL[s1] = "ALTER TABLE {$_TABLES['links']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 83 $_SQL[t1] = "ALTER TABLE {$_TABLES['links']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 84 $_SQL[u1] = "ALTER TABLE {$_TABLES['links']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 85 86 $_SQL[v1] = "CREATE TABLE {$_TABLES['personal_events']} ( 87 eid varchar(20) NOT NULL default '', 88 uid mediumint(8) NOT NULL default '0', 89 title varchar(128) default NULL, 90 event_type varchar(40) NOT NULL default '', 91 datestart date default NULL, 92 timestart time default NULL, 93 dateend date default NULL, 94 timeend time default NULL, 95 location varchar(128) default NULL, 96 address1 varchar(40) default NULL, 97 address2 varchar(40) default NULL, 98 city varchar(60) default NULL, 99 state char(2) default NULL, 100 zipcode varchar(5) default NULL, 101 allday tinyint(1) NOT NULL default '0', 102 url varchar(128) default NULL, 103 description text, 104 group_id mediumint(8) unsigned NOT NULL default '1', 105 owner_id mediumint(8) unsigned NOT NULL default '0', 106 perm_owner tinyint(1) unsigned NOT NULL default '3', 107 perm_group tinyint(1) unsigned NOT NULL default '3', 108 perm_members tinyint(1) unsigned NOT NULL default '2', 109 perm_anon tinyint(1) unsigned NOT NULL default '2', 110 PRIMARY KEY (eid) 111 ) TYPE=MyISAM"; 112 113 $_SQL[w1] = "CREATE TABLE {$_TABLES['plugins']} ( 114 pi_name varchar(30) NOT NULL default '', 115 pi_version varchar(20) NOT NULL default '', 116 pi_gl_version varchar(20) NOT NULL default '', 117 pi_enabled tinyint(3) unsigned NOT NULL default '1', 118 pi_homepage varchar(128) NOT NULL default '', 119 PRIMARY KEY (pi_name) 120 ) TYPE=MyISAM"; 121 122 $_SQL[x1] = "ALTER TABLE {$_TABLES['stories']} ADD numemails mediumint(8) unsigned NOT NULL default '0'"; 123 $_SQL[y1] = "ALTER TABLE {$_TABLES['stories']} ADD owner_id mediumint(8) NOT NULL default '0'"; 124 $_SQL[z1] = "ALTER TABLE {$_TABLES['stories']} ADD group_id mediumint(8) NOT NULL default '2'"; 125 $_SQL[a2] = "ALTER TABLE {$_TABLES['stories']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 126 $_SQL[b2] = "ALTER TABLE {$_TABLES['stories']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 127 $_SQL[c2] = "ALTER TABLE {$_TABLES['stories']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 128 $_SQL[d2] = "ALTER TABLE {$_TABLES['stories']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 129 130 $_SQL[e2] = "ALTER TABLE {$_TABLES['topics']} ADD group_id mediumint(8) unsigned NOT NULL default '1'"; 131 $_SQL[f2] = "ALTER TABLE {$_TABLES['topics']} ADD owner_id mediumint(8) unsigned NOT NULL default '0'"; 132 $_SQL[g2] = "ALTER TABLE {$_TABLES['topics']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 133 $_SQL[h2] = "ALTER TABLE {$_TABLES['topics']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 134 $_SQL[i2] = "ALTER TABLE {$_TABLES['topics']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 135 $_SQL[j2] = "ALTER TABLE {$_TABLES['topics']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 136 137 $_SQL[k2] = "DROP TABLE {$_TABLES['userevent']}"; 138 139 $_SQL[l2] = "ALTER TABLE {$_TABLES['users']} ADD regdate datetime NOT NULL default '0000-00-00 00:00:00'"; 140 $_SQL[m2] = "ALTER TABLE {$_TABLES['users']} ADD cookietimeout int(8) unsigned default '0'"; 141 $_SQL[n2] = "ALTER TABLE {$_TABLES['users']} ADD theme varchar(64) default NULL"; 142 $_SQL[o2] = "ALTER TABLE {$_TABLES['users']} DROP seclev"; 143 $_SQL[p2] = "ALTER TABLE {$_TABLES['users']} ADD language varchar(64) default NULL"; 144 145 // Now include needed data 146 $_SQL[1] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) "; 147 $_SQL[2] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (2,3) "; 148 $_SQL[3] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (3,5) "; 149 $_SQL[4] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (4,5) "; 150 $_SQL[5] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (5,9) "; 151 $_SQL[6] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (5,11) "; 152 $_SQL[7] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (6,9) "; 153 $_SQL[8] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (6,11) "; 154 $_SQL[9] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (8,7) "; 155 $_SQL[10] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (9,7) "; 156 $_SQL[11] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (10,4) "; 157 $_SQL[12] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (11,6) "; 158 $_SQL[13] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (12,8) "; 159 $_SQL[14] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (13,10) "; 160 $_SQL[15] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (14,11) "; 161 $_SQL[16] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (15,11) "; 162 $_SQL[17] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (16,4) "; 163 164 $_SQL[18] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('user_block','gldefault','User Block','all',2,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) "; 165 $_SQL[19] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('admin_block','gldefault','Admin Block','all',1,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) "; 166 $_SQL[20] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('section_block','gldefault','Section Block','all',0,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) "; 167 $_SQL[21] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('poll_block','gldefault','Poll Block','all',2,'','','0000-00-00 00:00:00',0,'0',1,2,3,3,2,2) "; 168 $_SQL[22] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('events_block','gldefault','Events Block','all',3,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) "; 169 $_SQL[23] = "INSERT INTO {$_TABLES['blocks']} (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('whats_new_block','gldefault','Whats New Block','all',3,'','','0000-00-00 00:00:00',0,'1',1,2,3,3,2,2) "; 170 171 $_SQL[40] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (3600,'1 Hour') "; 172 $_SQL[41] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (7200,'2 Hours') "; 173 $_SQL[42] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (10800,'3 Hours') "; 174 $_SQL[43] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (28800,'8 Hours') "; 175 $_SQL[44] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (86400,'1 Day') "; 176 $_SQL[45] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (604800,'1 Week') "; 177 $_SQL[46] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (2678400,'1 Month') "; 178 $_SQL[47] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (31536000,'1 Year') "; 179 180 $_SQL[69] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (1,'story.edit','Access to story editor',1) "; 181 $_SQL[70] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (2,'story.moderate','Ablility to moderate pending stories',1) "; 182 $_SQL[71] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (3,'link.moderate','Ablility to moderate pending links',1) "; 183 $_SQL[72] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (4,'link.edit','Access to link editor',1) "; 184 $_SQL[73] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (5,'user.edit','Access to user editor',1) "; 185 $_SQL[74] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (6,'user.delete','Ablility to delete a user',1) "; 186 $_SQL[75] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (7,'user.mail','Ablility to send email to members',1) "; 187 $_SQL[76] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (8,'event.moderate','Ablility to moderate pending events',1) "; 188 $_SQL[77] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (9,'event.edit','Access to event editor',1) "; 189 $_SQL[78] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (10,'block.edit','Access to block editor',1) ";$_SQL[79] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (11,'topic.edit','Access to topic editor',1) ";$_SQL[80] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (12,'poll.edit','Access to poll editor',1) "; 190 $_SQL[81] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (13,'plugin.edit','Access to plugin editor',1) 191 "; 192 $_SQL[82] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (14,'group.edit','Ability to edit groups',1) ";$_SQL[83] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (15,'group.delete','Ability to delete groups',1) "; 193 $_SQL[84] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (16,'block.delete','Ability to delete a block',1) "; 194 195 $_SQL[320] = "INSERT INTO {$_TABLES['users']} (username, fullname, passwd, email, homepage, sig, regdate, cookietimeout, theme) VALUES ('NewAdmin','Geeklog SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root@localhost','http://geekog.sourceforge.net','','0000-00-00 00:00:00',0,NULL) "; 196 $_SQL[87] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,1,NULL) "; 197 $_SQL[88] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,1) "; 198 $_SQL[89] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,NULL,1) "; 199 $_SQL[90] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,NULL,1) "; 200 $_SQL[91] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (5,NULL,1) "; 201 $_SQL[92] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,NULL,1) "; 202 $_SQL[93] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (7,NULL,1) "; 203 $_SQL[94] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (8,NULL,1) "; 204 $_SQL[95] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,1) "; 205 $_SQL[96] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,NULL,1) "; 206 $_SQL[97] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,NULL,1) "; 207 $_SQL[98] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (13,LAST_INSERT_ID(),NULL) "; 208 $_SQL[99] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,LAST_INSERT_ID(),NULL) "; 209 $_SQL[100] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,LAST_INSERT_ID(),NULL) "; 210 $_SQL[101] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,12) "; 211 $_SQL[102] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,10) "; 212 $_SQL[103] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,9) "; 213 $_SQL[104] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,8) "; 214 $_SQL[105] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,7) "; 215 $_SQL[106] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,6) "; 216 $_SQL[107] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,5) "; 217 $_SQL[108] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,4) "; 218 $_SQL[109] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,3) "; 219 $_SQL[110] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,NULL,1) "; 220 $_SQL[111] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,11) "; 221 $_SQL[112] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,11) "; 222 $_SQL[138] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,LAST_INSERT_ID(),NULL) "; 223 $_SQL[139] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,LAST_INSERT_ID(),NULL) "; 224 $_SQL[140] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (8,LAST_INSERT_ID(),NULL) "; 225 $_SQL[141] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (7,LAST_INSERT_ID(),NULL) "; 226 $_SQL[142] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,LAST_INSERT_ID(),NULL) "; 227 $_SQL[143] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (5,LAST_INSERT_ID(),NULL) "; 228 $_SQL[144] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,LAST_INSERT_ID(),NULL) "; 229 $_SQL[145] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,LAST_INSERT_ID(),NULL) "; 230 $_SQL[146] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,LAST_INSERT_ID(),NULL) "; 231 $_SQL[147] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (1,LAST_INSERT_ID(),NULL) "; 232 233 $_SQL[151] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (1,'Root','Has full access to the site',1) "; 234 $_SQL[152] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (2,'All Users','Group that a typical user is added to',1) "; 235 $_SQL[153] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (3,'Story Admin','Has full access to story features',1) "; 236 $_SQL[154] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (4,'Block Admin','Has full access to block features',1) "; 237 $_SQL[155] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (5,'Link Admin','Has full access to link features',1) "; 238 $_SQL[156] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (6,'Topic Admin','Has full access to topic features',1) "; 239 $_SQL[157] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (7,'Event Admin','Has full access to event features',1) "; 240 $_SQL[158] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (8,'Poll Admin','Has full access to poll features',1) "; 241 $_SQL[159] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (9,'User Admin','Has full access to user features',1) "; 242 $_SQL[160] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (10,'Plugin Admin','Has full access to plugin features',1) "; 243 $_SQL[161] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (11,'Group Admin','Is a User Admin with Acces to Groups too',1) "; 244 $_SQL[162] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (12,'Mail Admin','Can Use Mail Utility',1) "; 245 $_SQL[163] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (13,'Logged-in Users','All users except anonymous should belong to this group',1) "; 246 247 $_SQL[164] = "ALTER TABLE {$_TABLES['pollquestions']} ADD group_id mediumint(8) unsigned NOT NULL default '1'"; 248 $_SQL[165] = "ALTER TABLE {$_TABLES['pollquestions']} ADD owner_id mediumint(8) unsigned NOT NULL default '1'"; 249 $_SQL[166] = "ALTER TABLE {$_TABLES['pollquestions']} ADD perm_owner tinyint(1) unsigned NOT NULL default '3'"; 250 $_SQL[167] = "ALTER TABLE {$_TABLES['pollquestions']} ADD perm_group tinyint(1) unsigned NOT NULL default '3'"; 251 $_SQL[168] = "ALTER TABLE {$_TABLES['pollquestions']} ADD perm_members tinyint(1) unsigned NOT NULL default '2'"; 252 $_SQL[169] = "ALTER TABLE {$_TABLES['pollquestions']} ADD perm_anon tinyint(1) unsigned NOT NULL default '2'"; 253 ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Wed Nov 21 12:27:40 2007 | par Balluche grâce à PHPXref 0.7 |
|
|