Changeset 13

Show
Ignore:
Timestamp:
2007-11-22 00:13:40 (5 years ago)
Author:
hannes
Message:

one successful installation from the ground up with this code base!

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/admin/classes/pages/Addforum.php

    r1 r13  
    3232    public function __construct() { 
    3333        global $LANG, $C, $F, $SETTINGS, $LANG; 
    34         global $commit, $newcategory, $all; 
     34        global $commit, $newcategory, $all, $id; 
    3535        // define location and title parameter 
    3636        $this->title = ''; 

  • trunk/admin/classes/pages/Settings.php

    r8 r13  
    8181                    fwrite($file, "\$SETTINGS['defaultstyle'] = '" . $newdefaultstyle . "'; // default stylesheet of the board\n"); 
    8282                    fwrite($file, "\$SETTINGS['expire'] = " . $newexpire . "; // cookie expiration in days\n"); 
    83                     fwrite($file, "\$SETTINGS['debug'] = " . $newdebug . "; // debug mode (0: off, 1: on, 2: admins only\n"); 
     83                    fwrite($file, "\$SETTINGS['debug'] = " . $newdebug . "; // debug mode (0: off, 1: on, 2: admins only)\n"); 
    8484                    fwrite($file, "\$SETTINGS['hash'] = '" . $newhash . "'; // hash algorithm used for the passwords\n"); 
    8585                    fwrite($file, '?>'); 

  • trunk/classes/pages/Category.php

    r1 r13  
    8080                    $row3 = $q3->fetchObject(); 
    8181                    // number of posts 
    82                     $q4 = $C->prepare('SELECT COUNT(postid) AS posts FROM ' . $SETTINGS['dbtableprefix'] . 'posts WHERE topic IN (SELECT topicid FROM sb_topics WHERE forum=:forum)'); 
     82                    $q4 = $C->prepare('SELECT COUNT(postid) AS posts FROM ' . $SETTINGS['dbtableprefix'] . 'posts WHERE topic IN (SELECT topicid FROM ' . $SETTINGS['dbtableprefix'] . 'topics WHERE forum=:forum)'); 
    8383                    $q4->bindParam(':forum', $row2->forumid, PDO::PARAM_INT,12); 
    8484                    $q4->execute(); 
    8585                    $row4 = $q4->fetchObject(); 
    8686                    // last activity 
    87                     $q5 = $C->prepare('SELECT t.topicid AS topicid,t.topictitle AS topictitle, p.posttime AS posttime, p.poster AS poster, p.postedbymember AS postedbymember FROM ' . $SETTINGS['dbtableprefix'] . 'posts p, sb_topics t WHERE t.forum=:forum AND p.topic=t.topicid ORDER BY p.posttime DESC LIMIT 0,1'); 
     87                    $q5 = $C->prepare('SELECT t.topicid AS topicid,t.topictitle AS topictitle, p.posttime AS posttime, p.poster AS poster, p.postedbymember AS postedbymember FROM ' . $SETTINGS['dbtableprefix'] . 'posts p, ' . $SETTINGS['dbtableprefix'] . 'topics t WHERE t.forum=:forum AND p.topic=t.topicid ORDER BY p.posttime DESC LIMIT 0,1'); 
    8888                    $q5->bindParam(':forum', $row2->forumid, PDO::PARAM_INT,12); 
    8989                    $q5->execute(); 

  • trunk/db/spamboard.sql

    r11 r13  
    1 CREATE TABLE sb_categories ( 
     1CREATE TABLE %prefix%categories ( 
    22  category_id INTEGER  NOT NULL, 
    33  category_name VARCHAR(255) NOT NULL, 
    …… 
    66); 
    77 
    8 CREATE TABLE sb_forums ( 
     8CREATE TABLE %prefix%forums ( 
    99  forumid INTEGER NOT NULL, 
    1010  forumtitle VARCHAR(255) NOT NULL, 
    …… 
    1515); 
    1616 
    17 CREATE TABLE sb_messages ( 
     17CREATE TABLE %prefix%messages ( 
    1818  messageid INTEGER NOT NULL, 
    1919  messagesender INTEGER NOT NULL, 
    …… 
    2727); 
    2828 
    29 CREATE TABLE sb_online ( 
     29CREATE TABLE %prefix%online ( 
    3030  onlinememberid INTEGER NOT NULL, 
    3131  onlinetime INTEGER NOT NULL, 
    …… 
    3535); 
    3636 
    37 CREATE TABLE sb_polls ( 
     37CREATE TABLE %prefix%polls ( 
    3838  pollid INTEGER NOT NULL, 
    3939  pollchoices TEXT NOT NULL, 
    …… 
    4343); 
    4444 
    45 CREATE TABLE sb_posts ( 
     45CREATE TABLE %prefix%posts ( 
    4646  postid INTEGER NOT NULL, 
    4747  topic INTEGER NOT NULL, 
    …… 
    5858); 
    5959 
    60 CREATE TABLE sb_topics ( 
     60CREATE TABLE %prefix%topics ( 
    6161  topicid INTEGER NOT NULL, 
    6262  forum INTEGER NOT NULL, 
    …… 
    6969); 
    7070 
    71 CREATE TABLE sb_groupmemberships ( 
     71CREATE TABLE %prefix%groupmemberships ( 
    7272    member INTEGER, 
    7373    usergroup INTEGER 
    7474); 
    7575 
    76 CREATE TABLE sb_rights ( 
     76CREATE TABLE %prefix%rights ( 
    7777    page VARCHAR(255), 
    7878    usergroup INTEGER, 
    …… 
    8181    PRIMARY KEY (page,usergroup) 
    8282); 
    83 INSERT INTO "sb_rights" VALUES('Profile',1,1,0); 
    84 INSERT INTO "sb_rights" VALUES('Profile',2,1,0); 
    85 INSERT INTO "sb_rights" VALUES('Profile',4,1,0); 
    86 INSERT INTO "sb_rights" VALUES('Profile',5,0,0); 
    87 INSERT INTO "sb_rights" VALUES('admin/',1,1,1); 
    88 INSERT INTO "sb_rights" VALUES('Lostpassword',1,1,1); 
    89 INSERT INTO "sb_rights" VALUES('Lostpassword',2,1,1); 
    90 INSERT INTO "sb_rights" VALUES('Lostpassword',4,1,1); 
    91 INSERT INTO "sb_rights" VALUES('Lostpassword',5,1,1); 
    92 INSERT INTO "sb_rights" VALUES('Login',1,1,1); 
    93 INSERT INTO "sb_rights" VALUES('Login',2,1,1); 
    94 INSERT INTO "sb_rights" VALUES('Login',4,1,1); 
    95 INSERT INTO "sb_rights" VALUES('Login',5,1,1); 
    96 INSERT INTO "sb_rights" VALUES('Calendar',1,1,1); 
    97 INSERT INTO "sb_rights" VALUES('Calendar',2,1,1); 
    98 INSERT INTO "sb_rights" VALUES('Calendar',4,1,1); 
    99 INSERT INTO "sb_rights" VALUES('Calendar',5,1,1); 
    100 INSERT INTO "sb_rights" VALUES('Register',1,1,1); 
    101 INSERT INTO "sb_rights" VALUES('Register',2,1,1); 
    102 INSERT INTO "sb_rights" VALUES('Register',4,1,1); 
    103 INSERT INTO "sb_rights" VALUES('Register',5,1,1); 
    104 INSERT INTO "sb_rights" VALUES('Members',1,1,0); 
    105 INSERT INTO "sb_rights" VALUES('Members',2,1,0); 
    106 INSERT INTO "sb_rights" VALUES('Members',4,1,0); 
    107 INSERT INTO "sb_rights" VALUES('Members',5,1,0); 
    108 INSERT INTO "sb_rights" VALUES('Search',1,1,1); 
    109 INSERT INTO "sb_rights" VALUES('Search',2,1,1); 
    110 INSERT INTO "sb_rights" VALUES('Search',4,1,1); 
    111 INSERT INTO "sb_rights" VALUES('Search',5,1,1); 
    112 INSERT INTO "sb_rights" VALUES('Mail',1,1,1); 
    113 INSERT INTO "sb_rights" VALUES('Mail',2,1,1); 
    114 INSERT INTO "sb_rights" VALUES('Mail',4,1,1); 
    115 INSERT INTO "sb_rights" VALUES('Mail',5,0,0); 
    116 INSERT INTO "sb_rights" VALUES('Attachments',1,1,1); 
    117 INSERT INTO "sb_rights" VALUES('Attachments',2,1,1); 
    118 INSERT INTO "sb_rights" VALUES('Attachments',4,1,1); 
    119 INSERT INTO "sb_rights" VALUES('Attachments',5,0,0); 
    120 INSERT INTO "sb_rights" VALUES('Markasread',1,1,1); 
    121 INSERT INTO "sb_rights" VALUES('Markasread',2,1,1); 
    122 INSERT INTO "sb_rights" VALUES('Markasread',4,1,1); 
    123 INSERT INTO "sb_rights" VALUES('Markasread',5,1,1); 
    124 INSERT INTO "sb_rights" VALUES('Rules',1,1,1); 
    125 INSERT INTO "sb_rights" VALUES('Rules',2,1,1); 
    126 INSERT INTO "sb_rights" VALUES('Rules',4,1,1); 
    127 INSERT INTO "sb_rights" VALUES('Rules',5,1,1); 
    128 INSERT INTO "sb_rights" VALUES('Help',1,1,1); 
    129 INSERT INTO "sb_rights" VALUES('Help',2,1,1); 
    130 INSERT INTO "sb_rights" VALUES('Help',4,1,1); 
    131 INSERT INTO "sb_rights" VALUES('Help',5,1,1); 
    132 INSERT INTO "sb_rights" VALUES('Pollvote',1,1,1); 
    133 INSERT INTO "sb_rights" VALUES('Pollvote',2,1,1); 
    134 INSERT INTO "sb_rights" VALUES('Pollvote',4,1,1); 
    135 INSERT INTO "sb_rights" VALUES('Pollvote',5,1,0); 
    136 INSERT INTO "sb_rights" VALUES('Showip',1,1,1); 
    137 INSERT INTO "sb_rights" VALUES('Showip',2,1,1); 
    138 INSERT INTO "sb_rights" VALUES('Showip',4,0,0); 
    139 INSERT INTO "sb_rights" VALUES('Showip',5,0,0); 
    140 INSERT INTO "sb_rights" VALUES('Messenger',1,1,1); 
    141 INSERT INTO "sb_rights" VALUES('Messenger',2,1,1); 
    142 INSERT INTO "sb_rights" VALUES('Messenger',4,1,1); 
    143 INSERT INTO "sb_rights" VALUES('Messenger',5,0,0); 
    144 INSERT INTO "sb_rights" VALUES('Postinghelp',1,1,1); 
    145 INSERT INTO "sb_rights" VALUES('Postinghelp',2,1,1); 
    146 INSERT INTO "sb_rights" VALUES('Postinghelp',4,1,1); 
    147 INSERT INTO "sb_rights" VALUES('Postinghelp',5,1,1); 
    148 INSERT INTO "sb_rights" VALUES('Preview',1,1,1); 
    149 INSERT INTO "sb_rights" VALUES('Preview',2,1,1); 
    150 INSERT INTO "sb_rights" VALUES('Preview',4,1,1); 
    151 INSERT INTO "sb_rights" VALUES('Preview',5,1,1); 
    152 INSERT INTO "sb_rights" VALUES('Edit_Title',1,1,1); 
    153 INSERT INTO "sb_rights" VALUES('Edit_Title',2,1,1); 
    154 INSERT INTO "sb_rights" VALUES('Edit_Title',4,0,0); 
    155 INSERT INTO "sb_rights" VALUES('Edit_Title',5,0,0); 
    156 INSERT INTO "sb_rights" VALUES('Lock',1,1,1); 
    157 INSERT INTO "sb_rights" VALUES('Lock',2,1,1); 
    158 INSERT INTO "sb_rights" VALUES('Lock',4,0,0); 
    159 INSERT INTO "sb_rights" VALUES('Lock',5,0,0); 
    160 INSERT INTO "sb_rights" VALUES('Unlock',1,1,1); 
    161 INSERT INTO "sb_rights" VALUES('Unlock',2,1,1); 
    162 INSERT INTO "sb_rights" VALUES('Unlock',4,0,0); 
    163 INSERT INTO "sb_rights" VALUES('Unlock',5,0,0); 
    164 INSERT INTO "sb_rights" VALUES('Delete_Topic',1,1,1); 
    165 INSERT INTO "sb_rights" VALUES('Delete_Topic',2,1,1); 
    166 INSERT INTO "sb_rights" VALUES('Delete_Topic',4,0,0); 
    167 INSERT INTO "sb_rights" VALUES('Delete_Topic',5,0,0); 
    168 INSERT INTO "sb_rights" VALUES('Pin',1,1,1); 
    169 INSERT INTO "sb_rights" VALUES('Pin',2,1,1); 
    170 INSERT INTO "sb_rights" VALUES('Pin',4,0,0); 
    171 INSERT INTO "sb_rights" VALUES('Pin',5,0,0); 
    172 INSERT INTO "sb_rights" VALUES('Unpin',1,1,1); 
    173 INSERT INTO "sb_rights" VALUES('Unpin',2,1,1); 
    174 INSERT INTO "sb_rights" VALUES('Unpin',4,0,0); 
    175 INSERT INTO "sb_rights" VALUES('Unpin',5,0,0); 
    176 INSERT INTO "sb_rights" VALUES('Move',1,1,1); 
    177 INSERT INTO "sb_rights" VALUES('Move',2,1,1); 
    178 INSERT INTO "sb_rights" VALUES('Move',4,0,0); 
    179 INSERT INTO "sb_rights" VALUES('Move',5,0,0); 
    180 INSERT INTO "sb_rights" VALUES('Merge',1,1,1); 
    181 INSERT INTO "sb_rights" VALUES('Merge',2,1,1); 
    182 INSERT INTO "sb_rights" VALUES('Merge',4,0,0); 
    183 INSERT INTO "sb_rights" VALUES('Merge',5,0,0); 
    184 INSERT INTO "sb_rights" VALUES('Split',5,0,0); 
    185 INSERT INTO "sb_rights" VALUES('Split',4,0,0); 
    186 INSERT INTO "sb_rights" VALUES('Split',2,1,1); 
    187 INSERT INTO "sb_rights" VALUES('Split',1,1,1); 
    188 INSERT INTO "sb_rights" VALUES('Delete',1,1,1); 
    189 INSERT INTO "sb_rights" VALUES('Delete',2,1,1); 
    190 INSERT INTO "sb_rights" VALUES('Delete',4,0,0); 
    191 INSERT INTO "sb_rights" VALUES('Delete',5,0,0); 
    192 INSERT INTO "sb_rights" VALUES('Edit',1,1,1); 
    193 INSERT INTO "sb_rights" VALUES('Edit',2,1,1); 
    194 INSERT INTO "sb_rights" VALUES('Edit',4,0,0); 
    195 INSERT INTO "sb_rights" VALUES('Edit',5,0,0); 
    196 INSERT INTO "sb_rights" VALUES('Profile',3,1,0); 
    197 INSERT INTO "sb_rights" VALUES('Lostpassword',3,1,1); 
    198 INSERT INTO "sb_rights" VALUES('Login',3,1,1); 
    199 INSERT INTO "sb_rights" VALUES('Calendar',3,1,1); 
    200 INSERT INTO "sb_rights" VALUES('Register',3,1,1); 
    201 INSERT INTO "sb_rights" VALUES('Members',3,1,0); 
    202 INSERT INTO "sb_rights" VALUES('Search',3,1,1); 
    203 INSERT INTO "sb_rights" VALUES('Mail',3,1,1); 
    204 INSERT INTO "sb_rights" VALUES('Attachments',3,1,1); 
    205 INSERT INTO "sb_rights" VALUES('Markasread',3,1,1); 
    206 INSERT INTO "sb_rights" VALUES('Rules',3,1,1); 
    207 INSERT INTO "sb_rights" VALUES('Help',3,1,1); 
    208 INSERT INTO "sb_rights" VALUES('Pollvote',3,1,1); 
    209 INSERT INTO "sb_rights" VALUES('Showip',3,0,0); 
    210 INSERT INTO "sb_rights" VALUES('Messenger',3,1,1); 
    211 INSERT INTO "sb_rights" VALUES('Postinghelp',3,1,1); 
    212 INSERT INTO "sb_rights" VALUES('Preview',3,1,1); 
    213 INSERT INTO "sb_rights" VALUES('Edit_Title',3,0,0); 
    214 INSERT INTO "sb_rights" VALUES('Lock',3,0,0); 
    215 INSERT INTO "sb_rights" VALUES('Unlock',3,0,0); 
    216 INSERT INTO "sb_rights" VALUES('Delete_Topic',3,0,0); 
    217 INSERT INTO "sb_rights" VALUES('Pin',3,0,0); 
    218 INSERT INTO "sb_rights" VALUES('Unpin',3,0,0); 
    219 INSERT INTO "sb_rights" VALUES('Move',3,0,0); 
    220 INSERT INTO "sb_rights" VALUES('Merge',3,0,0); 
    221 INSERT INTO "sb_rights" VALUES('Split',3,0,0); 
    222 INSERT INTO "sb_rights" VALUES('Delete',3,0,0); 
    223 INSERT INTO "sb_rights" VALUES('Edit',3,0,0); 
    224 INSERT INTO "sb_rights" VALUES('Uploadavatar',1,1,1); 
    225 INSERT INTO "sb_rights" VALUES('Uploadavatar',2,1,1); 
    226 INSERT INTO "sb_rights" VALUES('Uploadavatar',3,1,1); 
    227 INSERT INTO "sb_rights" VALUES('Uploadavatar',4,1,1); 
    228 INSERT INTO "sb_rights" VALUES('Uploadavatar',5,0,0); 
    229 INSERT INTO "sb_rights" VALUES('Userpanel',1,1,1); 
    230 INSERT INTO "sb_rights" VALUES('Userpanel',2,1,1); 
    231 INSERT INTO "sb_rights" VALUES('Userpanel',3,1,1); 
    232 INSERT INTO "sb_rights" VALUES('Userpanel',4,1,1); 
    233 INSERT INTO "sb_rights" VALUES('Userpanel',5,0,0); 
    234  
    235 CREATE TABLE sb_rights_default ( 
     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); 
     234 
     235CREATE TABLE %prefix%rights_default ( 
    236236    page VARCHAR(255), 
    237237    usergroup INTEGER, 
    …… 
    240240    PRIMARY KEY (page,usergroup) 
    241241); 
    242 INSERT INTO "sb_rights_default" VALUES('Profile',1,1,0); 
    243 INSERT INTO "sb_rights_default" VALUES('Profile',2,1,0); 
    244 INSERT INTO "sb_rights_default" VALUES('Profile',4,1,0); 
    245 INSERT INTO "sb_rights_default" VALUES('Profile',5,0,0); 
    246 INSERT INTO "sb_rights_default" VALUES('admin/',1,1,1); 
    247 INSERT INTO "sb_rights_default" VALUES('Lostpassword',1,1,1); 
    248 INSERT INTO "sb_rights_default" VALUES('Lostpassword',2,1,1); 
    249 INSERT INTO "sb_rights_default" VALUES('Lostpassword',4,1,1); 
    250 INSERT INTO "sb_rights_default" VALUES('Lostpassword',5,1,1); 
    251 INSERT INTO "sb_rights_default" VALUES('Login',1,1,1); 
    252 INSERT INTO "sb_rights_default" VALUES('Login',2,1,1); 
    253 INSERT INTO "sb_rights_default" VALUES('Login',4,1,1); 
    254 INSERT INTO "sb_rights_default" VALUES('Login',5,1,1); 
    255 INSERT INTO "sb_rights_default" VALUES('Calendar',1,1,1); 
    256 INSERT INTO "sb_rights_default" VALUES('Calendar',2,1,1); 
    257 INSERT INTO "sb_rights_default" VALUES('Calendar',4,1,1); 
    258 INSERT INTO "sb_rights_default" VALUES('Calendar',5,1,1); 
    259 INSERT INTO "sb_rights_default" VALUES('Register',1,1,1); 
    260 INSERT INTO "sb_rights_default" VALUES('Register',2,1,1); 
    261 INSERT INTO "sb_rights_default" VALUES('Register',4,1,1); 
    262 INSERT INTO "sb_rights_default" VALUES('Register',5,1,1); 
    263 INSERT INTO "sb_rights_default" VALUES('Members',1,1,0); 
    264 INSERT INTO "sb_rights_default" VALUES('Members',2,1,0); 
    265 INSERT INTO "sb_rights_default" VALUES('Members',4,1,0); 
    266 INSERT INTO "sb_rights_default" VALUES('Members',5,1,0); 
    267 INSERT INTO "sb_rights_default" VALUES('Search',1,1,1); 
    268 INSERT INTO "sb_rights_default" VALUES('Search',2,1,1); 
    269 INSERT INTO "sb_rights_default" VALUES('Search',4,1,1); 
    270 INSERT INTO "sb_rights_default" VALUES('Search',5,1,1); 
    271 INSERT INTO "sb_rights_default" VALUES('Mail',1,1,1); 
    272 INSERT INTO "sb_rights_default" VALUES('Mail',2,1,1); 
    273 INSERT INTO "sb_rights_default" VALUES('Mail',4,1,1); 
    274 INSERT INTO "sb_rights_default" VALUES('Mail',5,0,0); 
    275 INSERT INTO "sb_rights_default" VALUES('Attachments',1,1,1); 
    276 INSERT INTO "sb_rights_default" VALUES('Attachments',2,1,1); 
    277 INSERT INTO "sb_rights_default" VALUES('Attachments',4,1,1); 
    278 INSERT INTO "sb_rights_default" VALUES('Attachments',5,0,0); 
    279 INSERT INTO "sb_rights_default" VALUES('Markasread',1,1,1); 
    280 INSERT INTO "sb_rights_default" VALUES('Markasread',2,1,1); 
    281 INSERT INTO "sb_rights_default" VALUES('Markasread',4,1,1); 
    282 INSERT INTO "sb_rights_default" VALUES('Markasread',5,1,1); 
    283 INSERT INTO "sb_rights_default" VALUES('Rules',1,1,1); 
    284 INSERT INTO "sb_rights_default" VALUES('Rules',2,1,1); 
    285 INSERT INTO "sb_rights_default" VALUES('Rules',4,1,1); 
    286 INSERT INTO "sb_rights_default" VALUES('Rules',5,1,1); 
    287 INSERT INTO "sb_rights_default" VALUES('Help',1,1,1); 
    288 INSERT INTO "sb_rights_default" VALUES('Help',2,1,1); 
    289 INSERT INTO "sb_rights_default" VALUES('Help',4,1,1); 
    290 INSERT INTO "sb_rights_default" VALUES('Help',5,1,1); 
    291 INSERT INTO "sb_rights_default" VALUES('Pollvote',1,1,1); 
    292 INSERT INTO "sb_rights_default" VALUES('Pollvote',2,1,1); 
    293 INSERT INTO "sb_rights_default" VALUES('Pollvote',4,1,1); 
    294 INSERT INTO "sb_rights_default" VALUES('Pollvote',5,1,0); 
    295 INSERT INTO "sb_rights_default" VALUES('Showip',1,1,1); 
    296 INSERT INTO "sb_rights_default" VALUES('Showip',2,1,1); 
    297 INSERT INTO "sb_rights_default" VALUES('Showip',4,0,0); 
    298 INSERT INTO "sb_rights_default" VALUES('Showip',5,0,0); 
    299 INSERT INTO "sb_rights_default" VALUES('Messenger',1,1,1); 
    300 INSERT INTO "sb_rights_default" VALUES('Messenger',2,1,1); 
    301 INSERT INTO "sb_rights_default" VALUES('Messenger',4,1,1); 
    302 INSERT INTO "sb_rights_default" VALUES('Messenger',5,0,0); 
    303 INSERT INTO "sb_rights_default" VALUES('Postinghelp',1,1,1); 
    304 INSERT INTO "sb_rights_default" VALUES('Postinghelp',2,1,1); 
    305 INSERT INTO "sb_rights_default" VALUES('Postinghelp',4,1,1); 
    306 INSERT INTO "sb_rights_default" VALUES('Postinghelp',5,1,1); 
    307 INSERT INTO "sb_rights_default" VALUES('Preview',1,1,1); 
    308 INSERT INTO "sb_rights_default" VALUES('Preview',2,1,1); 
    309 INSERT INTO "sb_rights_default" VALUES('Preview',4,1,1); 
    310 INSERT INTO "sb_rights_default" VALUES('Preview',5,1,1); 
    311 INSERT INTO "sb_rights_default" VALUES('Edit_Title',1,1,1); 
    312 INSERT INTO "sb_rights_default" VALUES('Edit_Title',2,1,1); 
    313 INSERT INTO "sb_rights_default" VALUES('Edit_Title',4,0,0); 
    314 INSERT INTO "sb_rights_default" VALUES('Edit_Title',5,0,0); 
    315 INSERT INTO "sb_rights_default" VALUES('Lock',1,1,1); 
    316 INSERT INTO "sb_rights_default" VALUES('Lock',2,1,1); 
    317 INSERT INTO "sb_rights_default" VALUES('Lock',4,0,0); 
    318 INSERT INTO "sb_rights_default" VALUES('Lock',5,0,0); 
    319 INSERT INTO "sb_rights_default" VALUES('Unlock',1,1,1); 
    320 INSERT INTO "sb_rights_default" VALUES('Unlock',2,1,1); 
    321 INSERT INTO "sb_rights_default" VALUES('Unlock',4,0,0); 
    322 INSERT INTO "sb_rights_default" VALUES('Unlock',5,0,0); 
    323 INSERT INTO "sb_rights_default" VALUES('Delete_Topic',1,1,1); 
    324 INSERT INTO "sb_rights_default" VALUES('Delete_Topic',2,1,1); 
    325 INSERT INTO "sb_rights_default" VALUES('Delete_Topic',4,0,0); 
    326 INSERT INTO "sb_rights_default" VALUES('Delete_Topic',5,0,0); 
    327 INSERT INTO "sb_rights_default" VALUES('Pin',1,1,1); 
    328 INSERT INTO "sb_rights_default" VALUES('Pin',2,1,1); 
    329 INSERT INTO "sb_rights_default" VALUES('Pin',4,0,0); 
    330 INSERT INTO "sb_rights_default" VALUES('Pin',5,0,0); 
    331 INSERT INTO "sb_rights_default" VALUES('Unpin',1,1,1); 
    332 INSERT INTO "sb_rights_default" VALUES('Unpin',2,1,1); 
    333 INSERT INTO "sb_rights_default" VALUES('Unpin',4,0,0); 
    334 INSERT INTO "sb_rights_default" VALUES('Unpin',5,0,0); 
    335 INSERT INTO "sb_rights_default" VALUES('Move',1,1,1); 
    336 INSERT INTO "sb_rights_default" VALUES('Move',2,1,1); 
    337 INSERT INTO "sb_rights_default" VALUES('Move',4,0,0); 
    338 INSERT INTO "sb_rights_default" VALUES('Move',5,0,0); 
    339 INSERT INTO "sb_rights_default" VALUES('Merge',1,1,1); 
    340 INSERT INTO "sb_rights_default" VALUES('Merge',2,1,1); 
    341 INSERT INTO "sb_rights_default" VALUES('Merge',4,0,0); 
    342 INSERT INTO "sb_rights_default" VALUES('Merge',5,0,0); 
    343 INSERT INTO "sb_rights_default" VALUES('Split',5,0,0); 
    344 INSERT INTO "sb_rights_default" VALUES('Split',4,0,0); 
    345 INSERT INTO "sb_rights_default" VALUES('Split',2,1,1); 
    346 INSERT INTO "sb_rights_default" VALUES('Split',1,1,1); 
    347 INSERT INTO "sb_rights_default" VALUES('Delete',1,1,1); 
    348 INSERT INTO "sb_rights_default" VALUES('Delete',2,1,1); 
    349 INSERT INTO "sb_rights_default" VALUES('Delete',4,0,0); 
    350 INSERT INTO "sb_rights_default" VALUES('Delete',5,0,0); 
    351 INSERT INTO "sb_rights_default" VALUES('Edit',1,1,1); 
    352 INSERT INTO "sb_rights_default" VALUES('Edit',2,1,1); 
    353 INSERT INTO "sb_rights_default" VALUES('Edit',4,0,0); 
    354 INSERT INTO "sb_rights_default" VALUES('Edit',5,0,0); 
    355 INSERT INTO "sb_rights_default" VALUES('Profile',3,1,0); 
    356 INSERT INTO "sb_rights_default" VALUES('Lostpassword',3,1,1); 
    357 INSERT INTO "sb_rights_default" VALUES('Login',3,1,1); 
    358 INSERT INTO "sb_rights_default" VALUES('Calendar',3,1,1); 
    359 INSERT INTO "sb_rights_default" VALUES('Register',3,1,1); 
    360 INSERT INTO "sb_rights_default" VALUES('Members',3,1,0); 
    361 INSERT INTO "sb_rights_default" VALUES('Search',3,1,1); 
    362 INSERT INTO "sb_rights_default" VALUES('Mail',3,1,1); 
    363 INSERT INTO "sb_rights_default" VALUES('Attachments',3,1,1); 
    364 INSERT INTO "sb_rights_default" VALUES('Markasread',3,1,1); 
    365 INSERT INTO "sb_rights_default" VALUES('Rules',3,1,1); 
    366 INSERT INTO "sb_rights_default" VALUES('Help',3,1,1); 
    367 INSERT INTO "sb_rights_default" VALUES('Pollvote',3,1,1); 
    368 INSERT INTO "sb_rights_default" VALUES('Showip',3,0,0); 
    369 INSERT INTO "sb_rights_default" VALUES('Messenger',3,1,1); 
    370 INSERT INTO "sb_rights_default" VALUES('Postinghelp',3,1,1); 
    371 INSERT INTO "sb_rights_default" VALUES('Preview',3,1,1); 
    372 INSERT INTO "sb_rights_default" VALUES('Edit_Title',3,0,0); 
    373 INSERT INTO "sb_rights_default" VALUES('Lock',3,0,0); 
    374 INSERT INTO "sb_rights_default" VALUES('Unlock',3,0,0); 
    375 INSERT INTO "sb_rights_default" VALUES('Delete_Topic',3,0,0); 
    376 INSERT INTO "sb_rights_default" VALUES('Pin',3,0,0); 
    377 INSERT INTO "sb_rights_default" VALUES('Unpin',3,0,0); 
    378 INSERT INTO "sb_rights_default" VALUES('Move',3,0,0); 
    379 INSERT INTO "sb_rights_default" VALUES('Merge',3,0,0); 
    380 INSERT INTO "sb_rights_default" VALUES('Split',3,0,0); 
    381 INSERT INTO "sb_rights_default" VALUES('Delete',3,0,0); 
    382 INSERT INTO "sb_rights_default" VALUES('Edit',3,0,0); 
    383 INSERT INTO "sb_rights_default" VALUES('Uploadavatar',1,1,1); 
    384 INSERT INTO "sb_rights_default" VALUES('Uploadavatar',2,1,1); 
    385 INSERT INTO "sb_rights_default" VALUES('Uploadavatar',3,1,1); 
    386 INSERT INTO "sb_rights_default" VALUES('Uploadavatar',4,1,1); 
    387 INSERT INTO "sb_rights_default" VALUES('Uploadavatar',5,0,0); 
    388 INSERT INTO "sb_rights_default" VALUES('Userpanel',1,1,1); 
    389 INSERT INTO "sb_rights_default" VALUES('Userpanel',2,1,1); 
    390 INSERT INTO "sb_rights_default" VALUES('Userpanel',3,1,1); 
    391 INSERT INTO "sb_rights_default" VALUES('Userpanel',4,1,1); 
    392 INSERT INTO "sb_rights_default" VALUES('Userpanel',5,0,0); 
    393  
    394 CREATE TABLE sb_usergroups ( 
     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); 
     393 
     394CREATE TABLE %prefix%usergroups ( 
    395395  id INTEGER, 
    396396  name VARCHAR(255), 
    …… 
    399399); 
    400400 
    401 INSERT INTO "sb_usergroups" VALUES(1,'Admin',0); 
    402 INSERT INTO "sb_usergroups" VALUES(2,'Global Moderator',0); 
    403 INSERT INTO "sb_usergroups" VALUES(3,'Moderator',0); 
    404 INSERT INTO "sb_usergroups" VALUES(4,'Member',0); 
    405 INSERT INTO "sb_usergroups" VALUES(5,'Guest',0); 
    406  
    407 CREATE TABLE sb_members ( 
     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); 
     406 
     407CREATE TABLE %prefix%members ( 
    408408  memberid INTEGER NOT NULL, 
    409409  membername VARCHAR(255) NOT NULL, 
    …… 
    420420  msn VARCHAR(255) NULL, 
    421421  signature VARCHAR(255) NULL, 
    422   lastvisit DATETIME NOT NULL, 
     422  lastvisit DATETIME NULL, 
    423423  boardstyle VARCHAR(32) NULL, 
    424424  addressbook TEXT NULL, 
    …… 
    433433); 
    434434 
    435 CREATE TABLE sb_mails ( 
     435CREATE TABLE %prefix%mails ( 
    436436  id INTEGER NOT NULL, 
    437437  receipient VARCHAR(255) NOT NULL, 
    …… 
    441441); 
    442442 
    443 CREATE TABLE sb_moderators ( 
     443CREATE TABLE %prefix%moderators ( 
    444444    forum INTEGER NOT NULL, 
    445445    member INTEGER NOT NULL 
    446446); 
    447447 
    448 CREATE TABLE sb_subscriptions ( 
     448CREATE TABLE %prefix%subscriptions ( 
    449449    topic INTEGER NOT NULL, 
    450450    member INTEGER NOT NULL 

  • trunk/includes/lang/en.php

    r12 r13  
    395395$LANG['installer_config_success'] = 'The configuration files have been set up successfully.'; 
    396396$LANG['installer_database_success'] = 'The database has been set up successfully.'; 
    397 $LANG['installer_overall_success'] = "Congratulations! Your Spam Board has been fully set up. If you didn't see any error messages or warnings, it should now be fully functional.<br /><br />You still have some work to do, of course:<ol><li>delete this installer script</li><li>go to %boardurl%</li><li>log in with the admin account you just created</li><li>go to the Administration Panel</li><li>set up at least one category and one forum</li><li>set appropriate permissions on this forum</li><li>deactive maintainance mode in the settings</li></ol>"; 
     397$LANG['installer_overall_success'] = "Congratulations! Your Spam Board has been fully set up. If you didn't see any error messages or warnings, it should now be fully functional.<br /><br />You still have some work to do, of course:<ol><li>delete this installer script</li><li>go to <a href=\"%boardurl%\">your board</a></li><li>log in with the admin account you just created</li><li>go to the Administration Panel</li><li>set up at least one category and one forum</li><li>set appropriate permissions on this forum</li><li>deactive maintainance mode in the settings</li></ol>"; 
    398398 
    399399/* error messages */ 

  • trunk/index.php

    r10 r13  
    2323 **/ 
    2424 
    25 //disable output of error messages and warnings 
     25// disable output of error messages and warnings 
    2626ini_set('display_errors','Off'); 
    2727 

  • trunk/install.php

    r12 r13  
    7979        // set file permissions 
    8080        if ($SETUPDATA['set_permissions'] == 1) { 
    81             if (@chmod('775', 'attachments')) { 
    82                 if (@chmod('770', 'db')) { 
    83                     if (@chmod('770', 'sessions')) { 
    84                         if (@chmod('775', 'images/avatars')) { 
    85                             if (@chmod('770', 'includes/config')) { 
    86                                 if (@chmod('770', 'includes/wrappers')) { 
     81            if (@chmod('attachments', 0775)) { 
     82                if (@chmod('db', 0770)) { 
     83                    if (@chmod('sessions', 0770)) { 
     84                        if (@chmod('images/avatars', 0775)) { 
     85                            if (@chmod('includes/config', 0770)) { 
     86                                if (@chmod('includes/wrappers', 0770)) { 
    8787                                    $ok = 1; 
    8888                                } else { $ok = 0; } 
    …… 
    105105                    if (@fwrite($handle, "RewriteEngine On\n\nRewriteBase " . $SETUPDATA['webpath'] . "\n\nRewriteRule ^index\.php$ index.php [L]\nRewriteRule ^([a-z]+)\.php$ index.php?show=$1&%{QUERY_STRING} [L]\n\nOptions -Indexes\n")) { 
    106106                        // set chmod 
    107                         if (@chmod('660', '.htaccess')) { 
    108                             $ok = 1; 
    109                         } else { $ok = 0; } 
     107                        @chmod('.htaccess', 0660); 
    110108                    } else { $ok = 0; } 
    111109                } else { $ok = 0; } 
    …… 
    114112                    if (@fwrite($handle, "RewriteEngine On\n\nRewriteBase " . $SETUPDATA['webpath'] . "admin/\n\nRewriteRule ^index\.php$ index.php [L]\nRewriteRule ^([a-z]+)\.php$ index.php?show=$1&%{QUERY_STRING} [L]\n\nOptions -Indexes\n")) { 
    115113                        // set chmod 
    116                         if (@chmod('660', 'admin/.htaccess')) { 
    117                             $ok = 1; 
    118                         } else { $ok = 0; } 
     114                        @chmod('admin/.htaccess', 0660); 
    119115                    } else { $ok = 0; } 
    120116                } else { $ok = 0; } 
    …… 
    132128                    fwrite($file, "<?php\n\n"); 
    133129                    fwrite($file, "/**\n * Package: Spam Board 5\n * File: includes/config/settings.php\n * Description: global board settings (usually modified through admin panel)\n **/\n\n"); 
    134                     fwrite($file, "\$SETTINGS['maintainancemode'] = " . $SETTINGS['maintainencemode'] . "; // put the board into maintainance mode (1/0); only admins can use it then\n"); 
     130                    fwrite($file, "\$SETTINGS['maintainancemode'] = " . $SETTINGS['maintainancemode'] . "; // put the board into maintainance mode (1/0); only admins can use it then\n"); 
    135131                    fwrite($file, "\$SETTINGS['sqltype'] = '" . $SETUPDATA['sqltype'] . "'; // type of SQL database (e.g. SQLite)\n"); 
    136132                    fwrite($file, "\$SETTINGS['sqlhost'] = '" . $SETUPDATA['sqlhost'] . "'; // hostname for the SQL database (usually localhost)\n"); 
    …… 
    164160                    fwrite($file, "\$SETTINGS['defaultstyle'] = '" . $SETTINGS['defaultstyle'] . "'; // default stylesheet of the board\n"); 
    165161                    fwrite($file, "\$SETTINGS['expire'] = " . $SETTINGS['expire'] . "; // cookie expiration in days\n"); 
    166                     fwrite($file, "\$SETTINGS['debug'] = " . $SETTINGS['debug'] . "; // debug mode (0: off, 1: on, 2: admins only\n"); 
     162                    fwrite($file, "\$SETTINGS['debug'] = " . $SETTINGS['debug'] . "; // debug mode (0: off, 1: on, 2: admins only)\n"); 
    167163                    fwrite($file, "\$SETTINGS['hash'] = '" . $SETUPDATA['hash'] . "'; // hash algorithm used for the passwords\n"); 
    168164                    fwrite($file, '?>'); 
    …… 
    170166                    @fclose($file); 
    171167                    // set chmod 
    172                     @chmod('660', 'includes/config/settings.php'); 
     168                    @chmod('includes/config/settings.php', 0660); 
    173169                    // include new settings again 
    174170                    require('includes/config/settings.php'); 
    …… 
    178174                /* initialize crypto module */ 
    179175                require('classes/misc/Password.php'); 
    180                 $key = new Password(512); 
    181                 $padding = new Password(512); 
     176                $key = new Password(); 
     177                $key->generate(512); 
     178                $padding = new Password(); 
     179                $padding->generate(512); 
    182180                // read template 
    183181                if ($template = @file_get_contents('includes/config/crypt.tmpl')) { 
    …… 
    185183                    if ($file = @fopen('includes/config/crypt.php', 'w')) { 
    186184                        // write settings 
    187                         if (@fwrite($file, str_replace(Array('%key%', '%padding%'), Array($key, $padding), $template))) { 
    188                             fclose($file); 
     185                        if (@fwrite($file, str_replace(Array('%key%', '%padding%'), Array($key->get(), $padding->get()), $template))) { 
     186                            @fclose($file); 
     187                            // set permissions 
     188                            @chmod('includes/config/crypt.php', 0660); 
    189189                            // remove template 
    190190                            unlink('includes/config/crypt.tmpl'); 
    …… 
    196196                /* move other template files to their actual names */ 
    197197                if (@rename('includes/config/bans.tmpl', 'includes/config/bans.php')) { 
    198                     @chmod('660', 'includes/config/bans.php'); 
     198                    @chmod('includes/config/bans.php', 0660); 
    199199                } else { $ok = 0; } 
    200200                if (@rename('includes/config/logins.tmpl', 'includes/config/logins.php')) { 
    201                     @chmod('660', 'includes/config/logins.php'); 
     201                    @chmod('includes/config/logins.php', 0660); 
    202202                } else { $ok = 0; } 
    203203                if (@rename('includes/config/memberstages.tmpl', 'includes/config/memberstages.php')) { 
    204                     @chmod('660', 'includes/config/memberstages.php'); 
     204                    @chmod('includes/config/memberstages.php', 0660); 
    205205                } else { $ok = 0; } 
    206206                if ($ok == 1) { 
    …… 
    209209                    print($LANG['error_installer_config']); 
    210210                } 
     211                // set permissions for version.php 
     212                @chmod('includes/config/version.php', 0660); 
    211213                if ($ok == 1) { 
    212214                    /* set up database */ 
    213215                    require('classes/misc/Connection.php'); 
     216                    // create database file if needed 
     217                    if ($SETTINGS['sqltype'] == 'sqlite' && !is_file('db/' . $SETTINGS['dbname'])) { 
     218                        @touch('db/' . $SETTINGS['dbname']); 
     219                    } 
    214220                    // open SQL connection 
    215221                    if ($C = new Connection()) { 
    …… 
    219225                            $db = explode(';', $db); 
    220226                            foreach ($db as $query) { 
    221                                 $C->query($query); 
     227                                $C->query(str_replace('%prefix%', $SETTINGS['dbtableprefix'], $query)); 
    222228                            } 
    223229                            // write the admin account 
    …… 
    226232                            $q->bindParam(':name', $SETUPDATA['forumadmin'], PDO::PARAM_STR); 
    227233                            $q->bindParam(':email', $SETUPDATA['forumadminemail'], PDO::PARAM_STR); 
    228                             $q->bindValue(':ppassword', '*', PDO::PARAM_STR); 
     234                            $q->bindValue(':password', '*', PDO::PARAM_STR); 
    229235                            $q->bindParam(':registered', $_t->format('Y-m-d H:i:s'), PDO::PARAM_STR, 19); 
    230236                            $q->bindValue(':status', 'Admin', PDO::PARAM_STR); 
    …… 
    247253                            // permissions 
    248254                            if ($SETUPDATA['sqltype'] == 'sqlite') { 
    249                                 @chmod('660', 'db/' . $SETUPDATA['sqldatabase']); 
     255                                @chmod('db/' . $SETUPDATA['sqldatabase'], 0660); 
    250256                            } 
    251257