Changeset 14

Show
Ignore:
Timestamp:
2007-11-22 17:29:48 (5 years ago)
Author:
hannes
Message:

fixes for MySQL installation

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/db/spamboard.sql

    r13 r14  
    8181    PRIMARY KEY (page,usergroup) 
    8282); 
    83 INSERT INTO "%prefix%rights" VALUES('Profile',1,1,0); 
    84 INSERT INTO "%prefix%rights" VALUES('Profile',2,1,0); 
    85 INSERT INTO "%prefix%rights" VALUES('Profile',4,1,0); 
    86 INSERT INTO "%prefix%rights" VALUES('Profile',5,0,0); 
    87 INSERT INTO "%prefix%rights" VALUES('admin/',1,1,1); 
    88 INSERT INTO "%prefix%rights" VALUES('Lostpassword',1,1,1); 
    89 INSERT INTO "%prefix%rights" VALUES('Lostpassword',2,1,1); 
    90 INSERT INTO "%prefix%rights" VALUES('Lostpassword',4,1,1); 
    91 INSERT INTO "%prefix%rights" VALUES('Lostpassword',5,1,1); 
    92 INSERT INTO "%prefix%rights" VALUES('Login',1,1,1); 
    93 INSERT INTO "%prefix%rights" VALUES('Login',2,1,1); 
    94 INSERT INTO "%prefix%rights" VALUES('Login',4,1,1); 
    95 INSERT INTO "%prefix%rights" VALUES('Login',5,1,1); 
    96 INSERT INTO "%prefix%rights" VALUES('Calendar',1,1,1); 
    97 INSERT INTO "%prefix%rights" VALUES('Calendar',2,1,1); 
    98 INSERT INTO "%prefix%rights" VALUES('Calendar',4,1,1); 
    99 INSERT INTO "%prefix%rights" VALUES('Calendar',5,1,1); 
    100 INSERT INTO "%prefix%rights" VALUES('Register',1,1,1); 
    101 INSERT INTO "%prefix%rights" VALUES('Register',2,1,1); 
    102 INSERT INTO "%prefix%rights" VALUES('Register',4,1,1); 
    103 INSERT INTO "%prefix%rights" VALUES('Register',5,1,1); 
    104 INSERT INTO "%prefix%rights" VALUES('Members',1,1,0); 
    105 INSERT INTO "%prefix%rights" VALUES('Members',2,1,0); 
    106 INSERT INTO "%prefix%rights" VALUES('Members',4,1,0); 
    107 INSERT INTO "%prefix%rights" VALUES('Members',5,1,0); 
    108 INSERT INTO "%prefix%rights" VALUES('Search',1,1,1); 
    109 INSERT INTO "%prefix%rights" VALUES('Search',2,1,1); 
    110 INSERT INTO "%prefix%rights" VALUES('Search',4,1,1); 
    111 INSERT INTO "%prefix%rights" VALUES('Search',5,1,1); 
    112 INSERT INTO "%prefix%rights" VALUES('Mail',1,1,1); 
    113 INSERT INTO "%prefix%rights" VALUES('Mail',2,1,1); 
    114 INSERT INTO "%prefix%rights" VALUES('Mail',4,1,1); 
    115 INSERT INTO "%prefix%rights" VALUES('Mail',5,0,0); 
    116 INSERT INTO "%prefix%rights" VALUES('Attachments',1,1,1); 
    117 INSERT INTO "%prefix%rights" VALUES('Attachments',2,1,1); 
    118 INSERT INTO "%prefix%rights" VALUES('Attachments',4,1,1); 
    119 INSERT INTO "%prefix%rights" VALUES('Attachments',5,0,0); 
    120 INSERT INTO "%prefix%rights" VALUES('Markasread',1,1,1); 
    121 INSERT INTO "%prefix%rights" VALUES('Markasread',2,1,1); 
    122 INSERT INTO "%prefix%rights" VALUES('Markasread',4,1,1); 
    123 INSERT INTO "%prefix%rights" VALUES('Markasread',5,1,1); 
    124 INSERT INTO "%prefix%rights" VALUES('Rules',1,1,1); 
    125 INSERT INTO "%prefix%rights" VALUES('Rules',2,1,1); 
    126 INSERT INTO "%prefix%rights" VALUES('Rules',4,1,1); 
    127 INSERT INTO "%prefix%rights" VALUES('Rules',5,1,1); 
    128 INSERT INTO "%prefix%rights" VALUES('Help',1,1,1); 
    129 INSERT INTO "%prefix%rights" VALUES('Help',2,1,1); 
    130 INSERT INTO "%prefix%rights" VALUES('Help',4,1,1); 
    131 INSERT INTO "%prefix%rights" VALUES('Help',5,1,1); 
    132 INSERT INTO "%prefix%rights" VALUES('Pollvote',1,1,1); 
    133 INSERT INTO "%prefix%rights" VALUES('Pollvote',2,1,1); 
    134 INSERT INTO "%prefix%rights" VALUES('Pollvote',4,1,1); 
    135 INSERT INTO "%prefix%rights" VALUES('Pollvote',5,1,0); 
    136 INSERT INTO "%prefix%rights" VALUES('Showip',1,1,1); 
    137 INSERT INTO "%prefix%rights" VALUES('Showip',2,1,1); 
    138 INSERT INTO "%prefix%rights" VALUES('Showip',4,0,0); 
    139 INSERT INTO "%prefix%rights" VALUES('Showip',5,0,0); 
    140 INSERT INTO "%prefix%rights" VALUES('Messenger',1,1,1); 
    141 INSERT INTO "%prefix%rights" VALUES('Messenger',2,1,1); 
    142 INSERT INTO "%prefix%rights" VALUES('Messenger',4,1,1); 
    143 INSERT INTO "%prefix%rights" VALUES('Messenger',5,0,0); 
    144 INSERT INTO "%prefix%rights" VALUES('Postinghelp',1,1,1); 
    145 INSERT INTO "%prefix%rights" VALUES('Postinghelp',2,1,1); 
    146 INSERT INTO "%prefix%rights" VALUES('Postinghelp',4,1,1); 
    147 INSERT INTO "%prefix%rights" VALUES('Postinghelp',5,1,1); 
    148 INSERT INTO "%prefix%rights" VALUES('Preview',1,1,1); 
    149 INSERT INTO "%prefix%rights" VALUES('Preview',2,1,1); 
    150 INSERT INTO "%prefix%rights" VALUES('Preview',4,1,1); 
    151 INSERT INTO "%prefix%rights" VALUES('Preview',5,1,1); 
    152 INSERT INTO "%prefix%rights" VALUES('Edit_Title',1,1,1); 
    153 INSERT INTO "%prefix%rights" VALUES('Edit_Title',2,1,1); 
    154 INSERT INTO "%prefix%rights" VALUES('Edit_Title',4,0,0); 
    155 INSERT INTO "%prefix%rights" VALUES('Edit_Title',5,0,0); 
    156 INSERT INTO "%prefix%rights" VALUES('Lock',1,1,1); 
    157 INSERT INTO "%prefix%rights" VALUES('Lock',2,1,1); 
    158 INSERT INTO "%prefix%rights" VALUES('Lock',4,0,0); 
    159 INSERT INTO "%prefix%rights" VALUES('Lock',5,0,0); 
    160 INSERT INTO "%prefix%rights" VALUES('Unlock',1,1,1); 
    161 INSERT INTO "%prefix%rights" VALUES('Unlock',2,1,1); 
    162 INSERT INTO "%prefix%rights" VALUES('Unlock',4,0,0); 
    163 INSERT INTO "%prefix%rights" VALUES('Unlock',5,0,0); 
    164 INSERT INTO "%prefix%rights" VALUES('Delete_Topic',1,1,1); 
    165 INSERT INTO "%prefix%rights" VALUES('Delete_Topic',2,1,1); 
    166 INSERT INTO "%prefix%rights" VALUES('Delete_Topic',4,0,0); 
    167 INSERT INTO "%prefix%rights" VALUES('Delete_Topic',5,0,0); 
    168 INSERT INTO "%prefix%rights" VALUES('Pin',1,1,1); 
    169 INSERT INTO "%prefix%rights" VALUES('Pin',2,1,1); 
    170 INSERT INTO "%prefix%rights" VALUES('Pin',4,0,0); 
    171 INSERT INTO "%prefix%rights" VALUES('Pin',5,0,0); 
    172 INSERT INTO "%prefix%rights" VALUES('Unpin',1,1,1); 
    173 INSERT INTO "%prefix%rights" VALUES('Unpin',2,1,1); 
    174 INSERT INTO "%prefix%rights" VALUES('Unpin',4,0,0); 
    175 INSERT INTO "%prefix%rights" VALUES('Unpin',5,0,0); 
    176 INSERT INTO "%prefix%rights" VALUES('Move',1,1,1); 
    177 INSERT INTO "%prefix%rights" VALUES('Move',2,1,1); 
    178 INSERT INTO "%prefix%rights" VALUES('Move',4,0,0); 
    179 INSERT INTO "%prefix%rights" VALUES('Move',5,0,0); 
    180 INSERT INTO "%prefix%rights" VALUES('Merge',1,1,1); 
    181 INSERT INTO "%prefix%rights" VALUES('Merge',2,1,1); 
    182 INSERT INTO "%prefix%rights" VALUES('Merge',4,0,0); 
    183 INSERT INTO "%prefix%rights" VALUES('Merge',5,0,0); 
    184 INSERT INTO "%prefix%rights" VALUES('Split',5,0,0); 
    185 INSERT INTO "%prefix%rights" VALUES('Split',4,0,0); 
    186 INSERT INTO "%prefix%rights" VALUES('Split',2,1,1); 
    187 INSERT INTO "%prefix%rights" VALUES('Split',1,1,1); 
    188 INSERT INTO "%prefix%rights" VALUES('Delete',1,1,1); 
    189 INSERT INTO "%prefix%rights" VALUES('Delete',2,1,1); 
    190 INSERT INTO "%prefix%rights" VALUES('Delete',4,0,0); 
    191 INSERT INTO "%prefix%rights" VALUES('Delete',5,0,0); 
    192 INSERT INTO "%prefix%rights" VALUES('Edit',1,1,1); 
    193 INSERT INTO "%prefix%rights" VALUES('Edit',2,1,1); 
    194 INSERT INTO "%prefix%rights" VALUES('Edit',4,0,0); 
    195 INSERT INTO "%prefix%rights" VALUES('Edit',5,0,0); 
    196 INSERT INTO "%prefix%rights" VALUES('Profile',3,1,0); 
    197 INSERT INTO "%prefix%rights" VALUES('Lostpassword',3,1,1); 
    198 INSERT INTO "%prefix%rights" VALUES('Login',3,1,1); 
    199 INSERT INTO "%prefix%rights" VALUES('Calendar',3,1,1); 
    200 INSERT INTO "%prefix%rights" VALUES('Register',3,1,1); 
    201 INSERT INTO "%prefix%rights" VALUES('Members',3,1,0); 
    202 INSERT INTO "%prefix%rights" VALUES('Search',3,1,1); 
    203 INSERT INTO "%prefix%rights" VALUES('Mail',3,1,1); 
    204 INSERT INTO "%prefix%rights" VALUES('Attachments',3,1,1); 
    205 INSERT INTO "%prefix%rights" VALUES('Markasread',3,1,1); 
    206 INSERT INTO "%prefix%rights" VALUES('Rules',3,1,1); 
    207 INSERT INTO "%prefix%rights" VALUES('Help',3,1,1); 
    208 INSERT INTO "%prefix%rights" VALUES('Pollvote',3,1,1); 
    209 INSERT INTO "%prefix%rights" VALUES('Showip',3,0,0); 
    210 INSERT INTO "%prefix%rights" VALUES('Messenger',3,1,1); 
    211 INSERT INTO "%prefix%rights" VALUES('Postinghelp',3,1,1); 
    212 INSERT INTO "%prefix%rights" VALUES('Preview',3,1,1); 
    213 INSERT INTO "%prefix%rights" VALUES('Edit_Title',3,0,0); 
    214 INSERT INTO "%prefix%rights" VALUES('Lock',3,0,0); 
    215 INSERT INTO "%prefix%rights" VALUES('Unlock',3,0,0); 
    216 INSERT INTO "%prefix%rights" VALUES('Delete_Topic',3,0,0); 
    217 INSERT INTO "%prefix%rights" VALUES('Pin',3,0,0); 
    218 INSERT INTO "%prefix%rights" VALUES('Unpin',3,0,0); 
    219 INSERT INTO "%prefix%rights" VALUES('Move',3,0,0); 
    220 INSERT INTO "%prefix%rights" VALUES('Merge',3,0,0); 
    221 INSERT INTO "%prefix%rights" VALUES('Split',3,0,0); 
    222 INSERT INTO "%prefix%rights" VALUES('Delete',3,0,0); 
    223 INSERT INTO "%prefix%rights" VALUES('Edit',3,0,0); 
    224 INSERT INTO "%prefix%rights" VALUES('Uploadavatar',1,1,1); 
    225 INSERT INTO "%prefix%rights" VALUES('Uploadavatar',2,1,1); 
    226 INSERT INTO "%prefix%rights" VALUES('Uploadavatar',3,1,1); 
    227 INSERT INTO "%prefix%rights" VALUES('Uploadavatar',4,1,1); 
    228 INSERT INTO "%prefix%rights" VALUES('Uploadavatar',5,0,0); 
    229 INSERT INTO "%prefix%rights" VALUES('Userpanel',1,1,1); 
    230 INSERT INTO "%prefix%rights" VALUES('Userpanel',2,1,1); 
    231 INSERT INTO "%prefix%rights" VALUES('Userpanel',3,1,1); 
    232 INSERT INTO "%prefix%rights" VALUES('Userpanel',4,1,1); 
    233 INSERT INTO "%prefix%rights" VALUES('Userpanel',5,0,0); 
     83INSERT INTO %prefix%rights VALUES('Profile',1,1,0); 
     84INSERT INTO %prefix%rights VALUES('Profile',2,1,0); 
     85INSERT INTO %prefix%rights VALUES('Profile',4,1,0); 
     86INSERT INTO %prefix%rights VALUES('Profile',5,0,0); 
     87INSERT INTO %prefix%rights VALUES('admin/',1,1,1); 
     88INSERT INTO %prefix%rights VALUES('Lostpassword',1,1,1); 
     89INSERT INTO %prefix%rights VALUES('Lostpassword',2,1,1); 
     90INSERT INTO %prefix%rights VALUES('Lostpassword',4,1,1); 
     91INSERT INTO %prefix%rights VALUES('Lostpassword',5,1,1); 
     92INSERT INTO %prefix%rights VALUES('Login',1,1,1); 
     93INSERT INTO %prefix%rights VALUES('Login',2,1,1); 
     94INSERT INTO %prefix%rights VALUES('Login',4,1,1); 
     95INSERT INTO %prefix%rights VALUES('Login',5,1,1); 
     96INSERT INTO %prefix%rights VALUES('Calendar',1,1,1); 
     97INSERT INTO %prefix%rights VALUES('Calendar',2,1,1); 
     98INSERT INTO %prefix%rights VALUES('Calendar',4,1,1); 
     99INSERT INTO %prefix%rights VALUES('Calendar',5,1,1); 
     100INSERT INTO %prefix%rights VALUES('Register',1,1,1); 
     101INSERT INTO %prefix%rights VALUES('Register',2,1,1); 
     102INSERT INTO %prefix%rights VALUES('Register',4,1,1); 
     103INSERT INTO %prefix%rights VALUES('Register',5,1,1); 
     104INSERT INTO %prefix%rights VALUES('Members',1,1,0); 
     105INSERT INTO %prefix%rights VALUES('Members',2,1,0); 
     106INSERT INTO %prefix%rights VALUES('Members',4,1,0); 
     107INSERT INTO %prefix%rights VALUES('Members',5,1,0); 
     108INSERT INTO %prefix%rights VALUES('Search',1,1,1); 
     109INSERT INTO %prefix%rights VALUES('Search',2,1,1); 
     110INSERT INTO %prefix%rights VALUES('Search',4,1,1); 
     111INSERT INTO %prefix%rights VALUES('Search',5,1,1); 
     112INSERT INTO %prefix%rights VALUES('Mail',1,1,1); 
     113INSERT INTO %prefix%rights VALUES('Mail',2,1,1); 
     114INSERT INTO %prefix%rights VALUES('Mail',4,1,1); 
     115INSERT INTO %prefix%rights VALUES('Mail',5,0,0); 
     116INSERT INTO %prefix%rights VALUES('Attachments',1,1,1); 
     117INSERT INTO %prefix%rights VALUES('Attachments',2,1,1); 
     118INSERT INTO %prefix%rights VALUES('Attachments',4,1,1); 
     119INSERT INTO %prefix%rights VALUES('Attachments',5,0,0); 
     120INSERT INTO %prefix%rights VALUES('Markasread',1,1,1); 
     121INSERT INTO %prefix%rights VALUES('Markasread',2,1,1); 
     122INSERT INTO %prefix%rights VALUES('Markasread',4,1,1); 
     123INSERT INTO %prefix%rights VALUES('Markasread',5,1,1); 
     124INSERT INTO %prefix%rights VALUES('Rules',1,1,1); 
     125INSERT INTO %prefix%rights VALUES('Rules',2,1,1); 
     126INSERT INTO %prefix%rights VALUES('Rules',4,1,1); 
     127INSERT INTO %prefix%rights VALUES('Rules',5,1,1); 
     128INSERT INTO %prefix%rights VALUES('Help',1,1,1); 
     129INSERT INTO %prefix%rights VALUES('Help',2,1,1); 
     130INSERT INTO %prefix%rights VALUES('Help',4,1,1); 
     131INSERT INTO %prefix%rights VALUES('Help',5,1,1); 
     132INSERT INTO %prefix%rights VALUES('Pollvote',1,1,1); 
     133INSERT INTO %prefix%rights VALUES('Pollvote',2,1,1); 
     134INSERT INTO %prefix%rights VALUES('Pollvote',4,1,1); 
     135INSERT INTO %prefix%rights VALUES('Pollvote',5,1,0); 
     136INSERT INTO %prefix%rights VALUES('Showip',1,1,1); 
     137INSERT INTO %prefix%rights VALUES('Showip',2,1,1); 
     138INSERT INTO %prefix%rights VALUES('Showip',4,0,0); 
     139INSERT INTO %prefix%rights VALUES('Showip',5,0,0); 
     140INSERT INTO %prefix%rights VALUES('Messenger',1,1,1); 
     141INSERT INTO %prefix%rights VALUES('Messenger',2,1,1); 
     142INSERT INTO %prefix%rights VALUES('Messenger',4,1,1); 
     143INSERT INTO %prefix%rights VALUES('Messenger',5,0,0); 
     144INSERT INTO %prefix%rights VALUES('Postinghelp',1,1,1); 
     145INSERT INTO %prefix%rights VALUES('Postinghelp',2,1,1); 
     146INSERT INTO %prefix%rights VALUES('Postinghelp',4,1,1); 
     147INSERT INTO %prefix%rights VALUES('Postinghelp',5,1,1); 
     148INSERT INTO %prefix%rights VALUES('Preview',1,1,1); 
     149INSERT INTO %prefix%rights VALUES('Preview',2,1,1); 
     150INSERT INTO %prefix%rights VALUES('Preview',4,1,1); 
     151INSERT INTO %prefix%rights VALUES('Preview',5,1,1); 
     152INSERT INTO %prefix%rights VALUES('Edit_Title',1,1,1); 
     153INSERT INTO %prefix%rights VALUES('Edit_Title',2,1,1); 
     154INSERT INTO %prefix%rights VALUES('Edit_Title',4,0,0); 
     155INSERT INTO %prefix%rights VALUES('Edit_Title',5,0,0); 
     156INSERT INTO %prefix%rights VALUES('Lock',1,1,1); 
     157INSERT INTO %prefix%rights VALUES('Lock',2,1,1); 
     158INSERT INTO %prefix%rights VALUES('Lock',4,0,0); 
     159INSERT INTO %prefix%rights VALUES('Lock',5,0,0); 
     160INSERT INTO %prefix%rights VALUES('Unlock',1,1,1); 
     161INSERT INTO %prefix%rights VALUES('Unlock',2,1,1); 
     162INSERT INTO %prefix%rights VALUES('Unlock',4,0,0); 
     163INSERT INTO %prefix%rights VALUES('Unlock',5,0,0); 
     164INSERT INTO %prefix%rights VALUES('Delete_Topic',1,1,1); 
     165INSERT INTO %prefix%rights VALUES('Delete_Topic',2,1,1); 
     166INSERT INTO %prefix%rights VALUES('Delete_Topic',4,0,0); 
     167INSERT INTO %prefix%rights VALUES('Delete_Topic',5,0,0); 
     168INSERT INTO %prefix%rights VALUES('Pin',1,1,1); 
     169INSERT INTO %prefix%rights VALUES('Pin',2,1,1); 
     170INSERT INTO %prefix%rights VALUES('Pin',4,0,0); 
     171INSERT INTO %prefix%rights VALUES('Pin',5,0,0); 
     172INSERT INTO %prefix%rights VALUES('Unpin',1,1,1); 
     173INSERT INTO %prefix%rights VALUES('Unpin',2,1,1); 
     174INSERT INTO %prefix%rights VALUES('Unpin',4,0,0); 
     175INSERT INTO %prefix%rights VALUES('Unpin',5,0,0); 
     176INSERT INTO %prefix%rights VALUES('Move',1,1,1); 
     177INSERT INTO %prefix%rights VALUES('Move',2,1,1); 
     178INSERT INTO %prefix%rights VALUES('Move',4,0,0); 
     179INSERT INTO %prefix%rights VALUES('Move',5,0,0); 
     180INSERT INTO %prefix%rights VALUES('Merge',1,1,1); 
     181INSERT INTO %prefix%rights VALUES('Merge',2,1,1); 
     182INSERT INTO %prefix%rights VALUES('Merge',4,0,0); 
     183INSERT INTO %prefix%rights VALUES('Merge',5,0,0); 
     184INSERT INTO %prefix%rights VALUES('Split',5,0,0); 
     185INSERT INTO %prefix%rights VALUES('Split',4,0,0); 
     186INSERT INTO %prefix%rights VALUES('Split',2,1,1); 
     187INSERT INTO %prefix%rights VALUES('Split',1,1,1); 
     188INSERT INTO %prefix%rights VALUES('Delete',1,1,1); 
     189INSERT INTO %prefix%rights VALUES('Delete',2,1,1); 
     190INSERT INTO %prefix%rights VALUES('Delete',4,0,0); 
     191INSERT INTO %prefix%rights VALUES('Delete',5,0,0); 
     192INSERT INTO %prefix%rights VALUES('Edit',1,1,1); 
     193INSERT INTO %prefix%rights VALUES('Edit',2,1,1); 
     194INSERT INTO %prefix%rights VALUES('Edit',4,0,0); 
     195INSERT INTO %prefix%rights VALUES('Edit',5,0,0); 
     196INSERT INTO %prefix%rights VALUES('Profile',3,1,0); 
     197INSERT INTO %prefix%rights VALUES('Lostpassword',3,1,1); 
     198INSERT INTO %prefix%rights VALUES('Login',3,1,1); 
     199INSERT INTO %prefix%rights VALUES('Calendar',3,1,1); 
     200INSERT INTO %prefix%rights VALUES('Register',3,1,1); 
     201INSERT INTO %prefix%rights VALUES('Members',3,1,0); 
     202INSERT INTO %prefix%rights VALUES('Search',3,1,1); 
     203INSERT INTO %prefix%rights VALUES('Mail',3,1,1); 
     204INSERT INTO %prefix%rights VALUES('Attachments',3,1,1); 
     205INSERT INTO %prefix%rights VALUES('Markasread',3,1,1); 
     206INSERT INTO %prefix%rights VALUES('Rules',3,1,1); 
     207INSERT INTO %prefix%rights VALUES('Help',3,1,1); 
     208INSERT INTO %prefix%rights VALUES('Pollvote',3,1,1); 
     209INSERT INTO %prefix%rights VALUES('Showip',3,0,0); 
     210INSERT INTO %prefix%rights VALUES('Messenger',3,1,1); 
     211INSERT INTO %prefix%rights VALUES('Postinghelp',3,1,1); 
     212INSERT INTO %prefix%rights VALUES('Preview',3,1,1); 
     213INSERT INTO %prefix%rights VALUES('Edit_Title',3,0,0); 
     214INSERT INTO %prefix%rights VALUES('Lock',3,0,0); 
     215INSERT INTO %prefix%rights VALUES('Unlock',3,0,0); 
     216INSERT INTO %prefix%rights VALUES('Delete_Topic',3,0,0); 
     217INSERT INTO %prefix%rights VALUES('Pin',3,0,0); 
     218INSERT INTO %prefix%rights VALUES('Unpin',3,0,0); 
     219INSERT INTO %prefix%rights VALUES('Move',3,0,0); 
     220INSERT INTO %prefix%rights VALUES('Merge',3,0,0); 
     221INSERT INTO %prefix%rights VALUES('Split',3,0,0); 
     222INSERT INTO %prefix%rights VALUES('Delete',3,0,0); 
     223INSERT INTO %prefix%rights VALUES('Edit',3,0,0); 
     224INSERT INTO %prefix%rights VALUES('Uploadavatar',1,1,1); 
     225INSERT INTO %prefix%rights VALUES('Uploadavatar',2,1,1); 
     226INSERT INTO %prefix%rights VALUES('Uploadavatar',3,1,1); 
     227INSERT INTO %prefix%rights VALUES('Uploadavatar',4,1,1); 
     228INSERT INTO %prefix%rights VALUES('Uploadavatar',5,0,0); 
     229INSERT INTO %prefix%rights VALUES('Userpanel',1,1,1); 
     230INSERT INTO %prefix%rights VALUES('Userpanel',2,1,1); 
     231INSERT INTO %prefix%rights VALUES('Userpanel',3,1,1); 
     232INSERT INTO %prefix%rights VALUES('Userpanel',4,1,1); 
     233INSERT INTO %prefix%rights VALUES('Userpanel',5,0,0); 
    234234 
    235235CREATE TABLE %prefix%rights_default ( 
    …… 
    240240    PRIMARY KEY (page,usergroup) 
    241241); 
    242 INSERT INTO "%prefix%rights_default" VALUES('Profile',1,1,0); 
    243 INSERT INTO "%prefix%rights_default" VALUES('Profile',2,1,0); 
    244 INSERT INTO "%prefix%rights_default" VALUES('Profile',4,1,0); 
    245 INSERT INTO "%prefix%rights_default" VALUES('Profile',5,0,0); 
    246 INSERT INTO "%prefix%rights_default" VALUES('admin/',1,1,1); 
    247 INSERT INTO "%prefix%rights_default" VALUES('Lostpassword',1,1,1); 
    248 INSERT INTO "%prefix%rights_default" VALUES('Lostpassword',2,1,1); 
    249 INSERT INTO "%prefix%rights_default" VALUES('Lostpassword',4,1,1); 
    250 INSERT INTO "%prefix%rights_default" VALUES('Lostpassword',5,1,1); 
    251 INSERT INTO "%prefix%rights_default" VALUES('Login',1,1,1); 
    252 INSERT INTO "%prefix%rights_default" VALUES('Login',2,1,1); 
    253 INSERT INTO "%prefix%rights_default" VALUES('Login',4,1,1); 
    254 INSERT INTO "%prefix%rights_default" VALUES('Login',5,1,1); 
    255 INSERT INTO "%prefix%rights_default" VALUES('Calendar',1,1,1); 
    256 INSERT INTO "%prefix%rights_default" VALUES('Calendar',2,1,1); 
    257 INSERT INTO "%prefix%rights_default" VALUES('Calendar',4,1,1); 
    258 INSERT INTO "%prefix%rights_default" VALUES('Calendar',5,1,1); 
    259 INSERT INTO "%prefix%rights_default" VALUES('Register',1,1,1); 
    260 INSERT INTO "%prefix%rights_default" VALUES('Register',2,1,1); 
    261 INSERT INTO "%prefix%rights_default" VALUES('Register',4,1,1); 
    262 INSERT INTO "%prefix%rights_default" VALUES('Register',5,1,1); 
    263 INSERT INTO "%prefix%rights_default" VALUES('Members',1,1,0); 
    264 INSERT INTO "%prefix%rights_default" VALUES('Members',2,1,0); 
    265 INSERT INTO "%prefix%rights_default" VALUES('Members',4,1,0); 
    266 INSERT INTO "%prefix%rights_default" VALUES('Members',5,1,0); 
    267 INSERT INTO "%prefix%rights_default" VALUES('Search',1,1,1); 
    268 INSERT INTO "%prefix%rights_default" VALUES('Search',2,1,1); 
    269 INSERT INTO "%prefix%rights_default" VALUES('Search',4,1,1); 
    270 INSERT INTO "%prefix%rights_default" VALUES('Search',5,1,1); 
    271 INSERT INTO "%prefix%rights_default" VALUES('Mail',1,1,1); 
    272 INSERT INTO "%prefix%rights_default" VALUES('Mail',2,1,1); 
    273 INSERT INTO "%prefix%rights_default" VALUES('Mail',4,1,1); 
    274 INSERT INTO "%prefix%rights_default" VALUES('Mail',5,0,0); 
    275 INSERT INTO "%prefix%rights_default" VALUES('Attachments',1,1,1); 
    276 INSERT INTO "%prefix%rights_default" VALUES('Attachments',2,1,1); 
    277 INSERT INTO "%prefix%rights_default" VALUES('Attachments',4,1,1); 
    278 INSERT INTO "%prefix%rights_default" VALUES('Attachments',5,0,0); 
    279 INSERT INTO "%prefix%rights_default" VALUES('Markasread',1,1,1); 
    280 INSERT INTO "%prefix%rights_default" VALUES('Markasread',2,1,1); 
    281 INSERT INTO "%prefix%rights_default" VALUES('Markasread',4,1,1); 
    282 INSERT INTO "%prefix%rights_default" VALUES('Markasread',5,1,1); 
    283 INSERT INTO "%prefix%rights_default" VALUES('Rules',1,1,1); 
    284 INSERT INTO "%prefix%rights_default" VALUES('Rules',2,1,1); 
    285 INSERT INTO "%prefix%rights_default" VALUES('Rules',4,1,1); 
    286 INSERT INTO "%prefix%rights_default" VALUES('Rules',5,1,1); 
    287 INSERT INTO "%prefix%rights_default" VALUES('Help',1,1,1); 
    288 INSERT INTO "%prefix%rights_default" VALUES('Help',2,1,1); 
    289 INSERT INTO "%prefix%rights_default" VALUES('Help',4,1,1); 
    290 INSERT INTO "%prefix%rights_default" VALUES('Help',5,1,1); 
    291 INSERT INTO "%prefix%rights_default" VALUES('Pollvote',1,1,1); 
    292 INSERT INTO "%prefix%rights_default" VALUES('Pollvote',2,1,1); 
    293 INSERT INTO "%prefix%rights_default" VALUES('Pollvote',4,1,1); 
    294 INSERT INTO "%prefix%rights_default" VALUES('Pollvote',5,1,0); 
    295 INSERT INTO "%prefix%rights_default" VALUES('Showip',1,1,1); 
    296 INSERT INTO "%prefix%rights_default" VALUES('Showip',2,1,1); 
    297 INSERT INTO "%prefix%rights_default" VALUES('Showip',4,0,0); 
    298 INSERT INTO "%prefix%rights_default" VALUES('Showip',5,0,0); 
    299 INSERT INTO "%prefix%rights_default" VALUES('Messenger',1,1,1); 
    300 INSERT INTO "%prefix%rights_default" VALUES('Messenger',2,1,1); 
    301 INSERT INTO "%prefix%rights_default" VALUES('Messenger',4,1,1); 
    302 INSERT INTO "%prefix%rights_default" VALUES('Messenger',5,0,0); 
    303 INSERT INTO "%prefix%rights_default" VALUES('Postinghelp',1,1,1); 
    304 INSERT INTO "%prefix%rights_default" VALUES('Postinghelp',2,1,1); 
    305 INSERT INTO "%prefix%rights_default" VALUES('Postinghelp',4,1,1); 
    306 INSERT INTO "%prefix%rights_default" VALUES('Postinghelp',5,1,1); 
    307 INSERT INTO "%prefix%rights_default" VALUES('Preview',1,1,1); 
    308 INSERT INTO "%prefix%rights_default" VALUES('Preview',2,1,1); 
    309 INSERT INTO "%prefix%rights_default" VALUES('Preview',4,1,1); 
    310 INSERT INTO "%prefix%rights_default" VALUES('Preview',5,1,1); 
    311 INSERT INTO "%prefix%rights_default" VALUES('Edit_Title',1,1,1); 
    312 INSERT INTO "%prefix%rights_default" VALUES('Edit_Title',2,1,1); 
    313 INSERT INTO "%prefix%rights_default" VALUES('Edit_Title',4,0,0); 
    314 INSERT INTO "%prefix%rights_default" VALUES('Edit_Title',5,0,0); 
    315 INSERT INTO "%prefix%rights_default" VALUES('Lock',1,1,1); 
    316 INSERT INTO "%prefix%rights_default" VALUES('Lock',2,1,1); 
    317 INSERT INTO "%prefix%rights_default" VALUES('Lock',4,0,0); 
    318 INSERT INTO "%prefix%rights_default" VALUES('Lock',5,0,0); 
    319 INSERT INTO "%prefix%rights_default" VALUES('Unlock',1,1,1); 
    320 INSERT INTO "%prefix%rights_default" VALUES('Unlock',2,1,1); 
    321 INSERT INTO "%prefix%rights_default" VALUES('Unlock',4,0,0); 
    322 INSERT INTO "%prefix%rights_default" VALUES('Unlock',5,0,0); 
    323 INSERT INTO "%prefix%rights_default" VALUES('Delete_Topic',1,1,1); 
    324 INSERT INTO "%prefix%rights_default" VALUES('Delete_Topic',2,1,1); 
    325 INSERT INTO "%prefix%rights_default" VALUES('Delete_Topic',4,0,0); 
    326 INSERT INTO "%prefix%rights_default" VALUES('Delete_Topic',5,0,0); 
    327 INSERT INTO "%prefix%rights_default" VALUES('Pin',1,1,1); 
    328 INSERT INTO "%prefix%rights_default" VALUES('Pin',2,1,1); 
    329 INSERT INTO "%prefix%rights_default" VALUES('Pin',4,0,0); 
    330 INSERT INTO "%prefix%rights_default" VALUES('Pin',5,0,0); 
    331 INSERT INTO "%prefix%rights_default" VALUES('Unpin',1,1,1); 
    332 INSERT INTO "%prefix%rights_default" VALUES('Unpin',2,1,1); 
    333 INSERT INTO "%prefix%rights_default" VALUES('Unpin',4,0,0); 
    334 INSERT INTO "%prefix%rights_default" VALUES('Unpin',5,0,0); 
    335 INSERT INTO "%prefix%rights_default" VALUES('Move',1,1,1); 
    336 INSERT INTO "%prefix%rights_default" VALUES('Move',2,1,1); 
    337 INSERT INTO "%prefix%rights_default" VALUES('Move',4,0,0); 
    338 INSERT INTO "%prefix%rights_default" VALUES('Move',5,0,0); 
    339 INSERT INTO "%prefix%rights_default" VALUES('Merge',1,1,1); 
    340 INSERT INTO "%prefix%rights_default" VALUES('Merge',2,1,1); 
    341 INSERT INTO "%prefix%rights_default" VALUES('Merge',4,0,0); 
    342 INSERT INTO "%prefix%rights_default" VALUES('Merge',5,0,0); 
    343 INSERT INTO "%prefix%rights_default" VALUES('Split',5,0,0); 
    344 INSERT INTO "%prefix%rights_default" VALUES('Split',4,0,0); 
    345 INSERT INTO "%prefix%rights_default" VALUES('Split',2,1,1); 
    346 INSERT INTO "%prefix%rights_default" VALUES('Split',1,1,1); 
    347 INSERT INTO "%prefix%rights_default" VALUES('Delete',1,1,1); 
    348 INSERT INTO "%prefix%rights_default" VALUES('Delete',2,1,1); 
    349 INSERT INTO "%prefix%rights_default" VALUES('Delete',4,0,0); 
    350 INSERT INTO "%prefix%rights_default" VALUES('Delete',5,0,0); 
    351 INSERT INTO "%prefix%rights_default" VALUES('Edit',1,1,1); 
    352 INSERT INTO "%prefix%rights_default" VALUES('Edit',2,1,1); 
    353 INSERT INTO "%prefix%rights_default" VALUES('Edit',4,0,0); 
    354 INSERT INTO "%prefix%rights_default" VALUES('Edit',5,0,0); 
    355 INSERT INTO "%prefix%rights_default" VALUES('Profile',3,1,0); 
    356 INSERT INTO "%prefix%rights_default" VALUES('Lostpassword',3,1,1); 
    357 INSERT INTO "%prefix%rights_default" VALUES('Login',3,1,1); 
    358 INSERT INTO "%prefix%rights_default" VALUES('Calendar',3,1,1); 
    359 INSERT INTO "%prefix%rights_default" VALUES('Register',3,1,1); 
    360 INSERT INTO "%prefix%rights_default" VALUES('Members',3,1,0); 
    361 INSERT INTO "%prefix%rights_default" VALUES('Search',3,1,1); 
    362 INSERT INTO "%prefix%rights_default" VALUES('Mail',3,1,1); 
    363 INSERT INTO "%prefix%rights_default" VALUES('Attachments',3,1,1); 
    364 INSERT INTO "%prefix%rights_default" VALUES('Markasread',3,1,1); 
    365 INSERT INTO "%prefix%rights_default" VALUES('Rules',3,1,1); 
    366 INSERT INTO "%prefix%rights_default" VALUES('Help',3,1,1); 
    367 INSERT INTO "%prefix%rights_default" VALUES('Pollvote',3,1,1); 
    368 INSERT INTO "%prefix%rights_default" VALUES('Showip',3,0,0); 
    369 INSERT INTO "%prefix%rights_default" VALUES('Messenger',3,1,1); 
    370 INSERT INTO "%prefix%rights_default" VALUES('Postinghelp',3,1,1); 
    371 INSERT INTO "%prefix%rights_default" VALUES('Preview',3,1,1); 
    372 INSERT INTO "%prefix%rights_default" VALUES('Edit_Title',3,0,0); 
    373 INSERT INTO "%prefix%rights_default" VALUES('Lock',3,0,0); 
    374 INSERT INTO "%prefix%rights_default" VALUES('Unlock',3,0,0); 
    375 INSERT INTO "%prefix%rights_default" VALUES('Delete_Topic',3,0,0); 
    376 INSERT INTO "%prefix%rights_default" VALUES('Pin',3,0,0); 
    377 INSERT INTO "%prefix%rights_default" VALUES('Unpin',3,0,0); 
    378 INSERT INTO "%prefix%rights_default" VALUES('Move',3,0,0); 
    379 INSERT INTO "%prefix%rights_default" VALUES('Merge',3,0,0); 
    380 INSERT INTO "%prefix%rights_default" VALUES('Split',3,0,0); 
    381 INSERT INTO "%prefix%rights_default" VALUES('Delete',3,0,0); 
    382 INSERT INTO "%prefix%rights_default" VALUES('Edit',3,0,0); 
    383 INSERT INTO "%prefix%rights_default" VALUES('Uploadavatar',1,1,1); 
    384 INSERT INTO "%prefix%rights_default" VALUES('Uploadavatar',2,1,1); 
    385 INSERT INTO "%prefix%rights_default" VALUES('Uploadavatar',3,1,1); 
    386 INSERT INTO "%prefix%rights_default" VALUES('Uploadavatar',4,1,1); 
    387 INSERT INTO "%prefix%rights_default" VALUES('Uploadavatar',5,0,0); 
    388 INSERT INTO "%prefix%rights_default" VALUES('Userpanel',1,1,1); 
    389 INSERT INTO "%prefix%rights_default" VALUES('Userpanel',2,1,1); 
    390 INSERT INTO "%prefix%rights_default" VALUES('Userpanel',3,1,1); 
    391 INSERT INTO "%prefix%rights_default" VALUES('Userpanel',4,1,1); 
    392 INSERT INTO "%prefix%rights_default" VALUES('Userpanel',5,0,0); 
     242INSERT INTO %prefix%rights_default VALUES('Profile',1,1,0); 
     243INSERT INTO %prefix%rights_default VALUES('Profile',2,1,0); 
     244INSERT INTO %prefix%rights_default VALUES('Profile',4,1,0); 
     245INSERT INTO %prefix%rights_default VALUES('Profile',5,0,0); 
     246INSERT INTO %prefix%rights_default VALUES('admin/',1,1,1); 
     247INSERT INTO %prefix%rights_default VALUES('Lostpassword',1,1,1); 
     248INSERT INTO %prefix%rights_default VALUES('Lostpassword',2,1,1); 
     249INSERT INTO %prefix%rights_default VALUES('Lostpassword',4,1,1); 
     250INSERT INTO %prefix%rights_default VALUES('Lostpassword',5,1,1); 
     251INSERT INTO %prefix%rights_default VALUES('Login',1,1,1); 
     252INSERT INTO %prefix%rights_default VALUES('Login',2,1,1); 
     253INSERT INTO %prefix%rights_default VALUES('Login',4,1,1); 
     254INSERT INTO %prefix%rights_default VALUES('Login',5,1,1); 
     255INSERT INTO %prefix%rights_default VALUES('Calendar',1,1,1); 
     256INSERT INTO %prefix%rights_default VALUES('Calendar',2,1,1); 
     257INSERT INTO %prefix%rights_default VALUES('Calendar',4,1,1); 
     258INSERT INTO %prefix%rights_default VALUES('Calendar',5,1,1); 
     259INSERT INTO %prefix%rights_default VALUES('Register',1,1,1); 
     260INSERT INTO %prefix%rights_default VALUES('Register',2,1,1); 
     261INSERT INTO %prefix%rights_default VALUES('Register',4,1,1); 
     262INSERT INTO %prefix%rights_default VALUES('Register',5,1,1); 
     263INSERT INTO %prefix%rights_default VALUES('Members',1,1,0); 
     264INSERT INTO %prefix%rights_default VALUES('Members',2,1,0); 
     265INSERT INTO %prefix%rights_default VALUES('Members',4,1,0); 
     266INSERT INTO %prefix%rights_default VALUES('Members',5,1,0); 
     267INSERT INTO %prefix%rights_default VALUES('Search',1,1,1); 
     268INSERT INTO %prefix%rights_default VALUES('Search',2,1,1); 
     269INSERT INTO %prefix%rights_default VALUES('Search',4,1,1); 
     270INSERT INTO %prefix%rights_default VALUES('Search',5,1,1); 
     271INSERT INTO %prefix%rights_default VALUES('Mail',1,1,1); 
     272INSERT INTO %prefix%rights_default VALUES('Mail',2,1,1); 
     273INSERT INTO %prefix%rights_default VALUES('Mail',4,1,1); 
     274INSERT INTO %prefix%rights_default VALUES('Mail',5,0,0); 
     275INSERT INTO %prefix%rights_default VALUES('Attachments',1,1,1); 
     276INSERT INTO %prefix%rights_default VALUES('Attachments',2,1,1); 
     277INSERT INTO %prefix%rights_default VALUES('Attachments',4,1,1); 
     278INSERT INTO %prefix%rights_default VALUES('Attachments',5,0,0); 
     279INSERT INTO %prefix%rights_default VALUES('Markasread',1,1,1); 
     280INSERT INTO %prefix%rights_default VALUES('Markasread',2,1,1); 
     281INSERT INTO %prefix%rights_default VALUES('Markasread',4,1,1); 
     282INSERT INTO %prefix%rights_default VALUES('Markasread',5,1,1); 
     283INSERT INTO %prefix%rights_default VALUES('Rules',1,1,1); 
     284INSERT INTO %prefix%rights_default VALUES('Rules',2,1,1); 
     285INSERT INTO %prefix%rights_default VALUES('Rules',4,1,1); 
     286INSERT INTO %prefix%rights_default VALUES('Rules',5,1,1); 
     287INSERT INTO %prefix%rights_default VALUES('Help',1,1,1); 
     288INSERT INTO %prefix%rights_default VALUES('Help',2,1,1); 
     289INSERT INTO %prefix%rights_default VALUES('Help',4,1,1); 
     290INSERT INTO %prefix%rights_default VALUES('Help',5,1,1); 
     291INSERT INTO %prefix%rights_default VALUES('Pollvote',1,1,1); 
     292INSERT INTO %prefix%rights_default VALUES('Pollvote',2,1,1); 
     293INSERT INTO %prefix%rights_default VALUES('Pollvote',4,1,1); 
     294INSERT INTO %prefix%rights_default VALUES('Pollvote',5,1,0); 
     295INSERT INTO %prefix%rights_default VALUES('Showip',1,1,1); 
     296INSERT INTO %prefix%rights_default VALUES('Showip',2,1,1); 
     297INSERT INTO %prefix%rights_default VALUES('Showip',4,0,0); 
     298INSERT INTO %prefix%rights_default VALUES('Showip',5,0,0); 
     299INSERT INTO %prefix%rights_default VALUES('Messenger',1,1,1); 
     300INSERT INTO %prefix%rights_default VALUES('Messenger',2,1,1); 
     301INSERT INTO %prefix%rights_default VALUES('Messenger',4,1,1); 
     302INSERT INTO %prefix%rights_default VALUES('Messenger',5,0,0); 
     303INSERT INTO %prefix%rights_default VALUES('Postinghelp',1,1,1); 
     304INSERT INTO %prefix%rights_default VALUES('Postinghelp',2,1,1); 
     305INSERT INTO %prefix%rights_default VALUES('Postinghelp',4,1,1); 
     306INSERT INTO %prefix%rights_default VALUES('Postinghelp',5,1,1); 
     307INSERT INTO %prefix%rights_default VALUES('Preview',1,1,1); 
     308INSERT INTO %prefix%rights_default VALUES('Preview',2,1,1); 
     309INSERT INTO %prefix%rights_default VALUES('Preview',4,1,1); 
     310INSERT INTO %prefix%rights_default VALUES('Preview',5,1,1); 
     311INSERT INTO %prefix%rights_default VALUES('Edit_Title',1,1,1); 
     312INSERT INTO %prefix%rights_default VALUES('Edit_Title',2,1,1); 
     313INSERT INTO %prefix%rights_default VALUES('Edit_Title',4,0,0); 
     314INSERT INTO %prefix%rights_default VALUES('Edit_Title',5,0,0); 
     315INSERT INTO %prefix%rights_default VALUES('Lock',1,1,1); 
     316INSERT INTO %prefix%rights_default VALUES('Lock',2,1,1); 
     317INSERT INTO %prefix%rights_default VALUES('Lock',4,0,0); 
     318INSERT INTO %prefix%rights_default VALUES('Lock',5,0,0); 
     319INSERT INTO %prefix%rights_default VALUES('Unlock',1,1,1); 
     320INSERT INTO %prefix%rights_default VALUES('Unlock',2,1,1); 
     321INSERT INTO %prefix%rights_default VALUES('Unlock',4,0,0); 
     322INSERT INTO %prefix%rights_default VALUES('Unlock',5,0,0); 
     323INSERT INTO %prefix%rights_default VALUES('Delete_Topic',1,1,1); 
     324INSERT INTO %prefix%rights_default VALUES('Delete_Topic',2,1,1); 
     325INSERT INTO %prefix%rights_default VALUES('Delete_Topic',4,0,0); 
     326INSERT INTO %prefix%rights_default VALUES('Delete_Topic',5,0,0); 
     327INSERT INTO %prefix%rights_default VALUES('Pin',1,1,1); 
     328INSERT INTO %prefix%rights_default VALUES('Pin',2,1,1); 
     329INSERT INTO %prefix%rights_default VALUES('Pin',4,0,0); 
     330INSERT INTO %prefix%rights_default VALUES('Pin',5,0,0); 
     331INSERT INTO %prefix%rights_default VALUES('Unpin',1,1,1); 
     332INSERT INTO %prefix%rights_default VALUES('Unpin',2,1,1); 
     333INSERT INTO %prefix%rights_default VALUES('Unpin',4,0,0); 
     334INSERT INTO %prefix%rights_default VALUES('Unpin',5,0,0); 
     335INSERT INTO %prefix%rights_default VALUES('Move',1,1,1); 
     336INSERT INTO %prefix%rights_default VALUES('Move',2,1,1); 
     337INSERT INTO %prefix%rights_default VALUES('Move',4,0,0); 
     338INSERT INTO %prefix%rights_default VALUES('Move',5,0,0); 
     339INSERT INTO %prefix%rights_default VALUES('Merge',1,1,1); 
     340INSERT INTO %prefix%rights_default VALUES('Merge',2,1,1); 
     341INSERT INTO %prefix%rights_default VALUES('Merge',4,0,0); 
     342INSERT INTO %prefix%rights_default VALUES('Merge',5,0,0); 
     343INSERT INTO %prefix%rights_default VALUES('Split',5,0,0); 
     344INSERT INTO %prefix%rights_default VALUES('Split',4,0,0); 
     345INSERT INTO %prefix%rights_default VALUES('Split',2,1,1); 
     346INSERT INTO %prefix%rights_default VALUES('Split',1,1,1); 
     347INSERT INTO %prefix%rights_default VALUES('Delete',1,1,1); 
     348INSERT INTO %prefix%rights_default VALUES('Delete',2,1,1); 
     349INSERT INTO %prefix%rights_default VALUES('Delete',4,0,0); 
     350INSERT INTO %prefix%rights_default VALUES('Delete',5,0,0); 
     351INSERT INTO %prefix%rights_default VALUES('Edit',1,1,1); 
     352INSERT INTO %prefix%rights_default VALUES('Edit',2,1,1); 
     353INSERT INTO %prefix%rights_default VALUES('Edit',4,0,0); 
     354INSERT INTO %prefix%rights_default VALUES('Edit',5,0,0); 
     355INSERT INTO %prefix%rights_default VALUES('Profile',3,1,0); 
     356INSERT INTO %prefix%rights_default VALUES('Lostpassword',3,1,1); 
     357INSERT INTO %prefix%rights_default VALUES('Login',3,1,1); 
     358INSERT INTO %prefix%rights_default VALUES('Calendar',3,1,1); 
     359INSERT INTO %prefix%rights_default VALUES('Register',3,1,1); 
     360INSERT INTO %prefix%rights_default VALUES('Members',3,1,0); 
     361INSERT INTO %prefix%rights_default VALUES('Search',3,1,1); 
     362INSERT INTO %prefix%rights_default VALUES('Mail',3,1,1); 
     363INSERT INTO %prefix%rights_default VALUES('Attachments',3,1,1); 
     364INSERT INTO %prefix%rights_default VALUES('Markasread',3,1,1); 
     365INSERT INTO %prefix%rights_default VALUES('Rules',3,1,1); 
     366INSERT INTO %prefix%rights_default VALUES('Help',3,1,1); 
     367INSERT INTO %prefix%rights_default VALUES('Pollvote',3,1,1); 
     368INSERT INTO %prefix%rights_default VALUES('Showip',3,0,0); 
     369INSERT INTO %prefix%rights_default VALUES('Messenger',3,1,1); 
     370INSERT INTO %prefix%rights_default VALUES('Postinghelp',3,1,1); 
     371INSERT INTO %prefix%rights_default VALUES('Preview',3,1,1); 
     372INSERT INTO %prefix%rights_default VALUES('Edit_Title',3,0,0); 
     373INSERT INTO %prefix%rights_default VALUES('Lock',3,0,0); 
     374INSERT INTO %prefix%rights_default VALUES('Unlock',3,0,0); 
     375INSERT INTO %prefix%rights_default VALUES('Delete_Topic',3,0,0); 
     376INSERT INTO %prefix%rights_default VALUES('Pin',3,0,0); 
     377INSERT INTO %prefix%rights_default VALUES('Unpin',3,0,0); 
     378INSERT INTO %prefix%rights_default VALUES('Move',3,0,0); 
     379INSERT INTO %prefix%rights_default VALUES('Merge',3,0,0); 
     380INSERT INTO %prefix%rights_default VALUES('Split',3,0,0); 
     381INSERT INTO %prefix%rights_default VALUES('Delete',3,0,0); 
     382INSERT INTO %prefix%rights_default VALUES('Edit',3,0,0); 
     383INSERT INTO %prefix%rights_default VALUES('Uploadavatar',1,1,1); 
     384INSERT INTO %prefix%rights_default VALUES('Uploadavatar',2,1,1); 
     385INSERT INTO %prefix%rights_default VALUES('Uploadavatar',3,1,1); 
     386INSERT INTO %prefix%rights_default VALUES('Uploadavatar',4,1,1); 
     387INSERT INTO %prefix%rights_default VALUES('Uploadavatar',5,0,0); 
     388INSERT INTO %prefix%rights_default VALUES('Userpanel',1,1,1); 
     389INSERT INTO %prefix%rights_default VALUES('Userpanel',2,1,1); 
     390INSERT INTO %prefix%rights_default VALUES('Userpanel',3,1,1); 
     391INSERT INTO %prefix%rights_default VALUES('Userpanel',4,1,1); 
     392INSERT INTO %prefix%rights_default VALUES('Userpanel',5,0,0); 
    393393 
    394394CREATE TABLE %prefix%usergroups ( 
    …… 
    399399); 
    400400 
    401 INSERT INTO "%prefix%usergroups" VALUES(1,'Admin',0); 
    402 INSERT INTO "%prefix%usergroups" VALUES(2,'Global Moderator',0); 
    403 INSERT INTO "%prefix%usergroups" VALUES(3,'Moderator',0); 
    404 INSERT INTO "%prefix%usergroups" VALUES(4,'Member',0); 
    405 INSERT INTO "%prefix%usergroups" VALUES(5,'Guest',0); 
     401INSERT INTO %prefix%usergroups VALUES(1,'Admin',0); 
     402INSERT INTO %prefix%usergroups VALUES(2,'Global Moderator',0); 
     403INSERT INTO %prefix%usergroups VALUES(3,'Moderator',0); 
     404INSERT INTO %prefix%usergroups VALUES(4,'Member',0); 
     405INSERT INTO %prefix%usergroups VALUES(5,'Guest',0); 
    406406 
    407407CREATE TABLE %prefix%members ( 

  • trunk/install.php

    r13 r14  
    227227                                $C->query(str_replace('%prefix%', $SETTINGS['dbtableprefix'], $query)); 
    228228                            } 
     229                            // MySQL specialities 
     230                            if ($SETTINGS['sqltype'] == 'mysql') { 
     231                                if ($db = @file_get_contents('db/mysql.sql')) { 
     232                                    // one SQL query at a time 
     233                                    $db = explode(';', $db); 
     234                                    foreach ($db as $query) { 
     235                                        $C->query(str_replace('%prefix%', $SETTINGS['dbtableprefix'], $query)); 
     236                                    } 
     237                                } else { $ok = 0; } 
     238                            } 
    229239                            // write the admin account 
    230240                            $q = $C->prepare('INSERT INTO ' . $SETTINGS['dbtableprefix'] . 'members (membername, memberemail, memberpassword, registered, memberstatus) VALUES (:name, :email, :password, :registered, :status)');