Changeset 11

Timestamp:

2007-11-21 22:50:58 (5 years ago)

Author:

hannes

Message:

blind programming of an installer (ticket #8)

Files:

• trunk/classes/pages/Register.php (modified) (3 diffs)
• trunk/db/spamboard.sql (modified) (2 diffs)
• trunk/includes/config/crypt.tmpl (modified) (1 diff)
• trunk/includes/config/settings.tmpl (modified) (1 diff)
• trunk/includes/lang/en.php (modified) (3 diffs)
• trunk/install.php (added)

trunk/classes/pages/Register.php

@@ -97 +97 @@
-                             * not every db supports this, but usually, it should work without locking, too; there just is the risk of a wrong member id being returned in the second query which is very unlikely - it can only occur on forums with very high traffic */
-                            @$C->query('LOCK TABLE ' . $SETTINGS['dbtableprefix'] . 'members WRITE');
-, memberavatar) VALUES (:user, :email, :pw, :ts, :member, :avata
+) VALUES (:user, :email, :pw, :ts, :membe
-                            // the actual password will be entered seperately
-                            $_pw = '*';
-                            $_member = 'Member';
-                            $_avatar = 'images/spacer.gif';
-                            $_t = new DateTime('now', new DateTimeZone('UTC'));
-                            $q->bindParam(':user', $user, PDO::PARAM_STR);
@@ -108 +107 @@
-                            $q->bindParam(':ts', $_t->format('Y-m-d H:i:s'), PDO::PARAM_STR, 19);
-                            $q->bindParam(':member', $_member, PDO::PARAM_STR, 6);
-                            $q->bindParam(':avatar',$_avatar, PDO::PARAM_STR, 17);
-                            $q->execute();
-                            $q = $C->query('SELECT MAX(memberid) AS id FROM ' . $SETTINGS['dbtableprefix'] . 'members');
@@ -117 +115 @@
-                            // set group membership to 'Member'
-                            $q = $C->prepare('SELECT id FROM ' . $SETTINGS['dbtableprefix'] . 'usergroups WHERE name=:member');
-PDO::PARAM_STR,
+ PDO::PARAM_STR, 
-                            $q->execute();
-                            $row2 = $q->fetchObject();
-                            $q = $C->prepare('INSERT INTO ' . $SETTINGS['dbtableprefix'] . 'groupmemberships (member, usergroup) VALUES (:member, :group)');
-
-
+ 
+ 
-                            $q->execute();
-                            // send e-mail

trunk/db/spamboard.sql

@@ -411 +411 @@
-  memberemailhidden INTEGER NOT NULL DEFAULT 0,
-  memberhomepage VARCHAR(255) NULL,
-
+ DEFAULT 'images/spacer.gif'
-  memberpassword TEXT NOT NULL,
-  memberstatus VARCHAR(255) NOT NULL,
@@ -421 +421 @@
-  signature VARCHAR(255) NULL,
-  lastvisit DATETIME NOT NULL,
-OT N
-
+
+ NULL
-  birthday DATE DEFAULT NULL,
-  messagenotification_email INTEGER NOT NULL DEFAULT 0,
-  messagenotification_popup INTEGER NOT NULL DEFAULT 1,
-  registered DATETIME NOT NULL,
-OT N
-OT N
-OT N
+
+
+
-  PRIMARY KEY (memberid)
-);

trunk/includes/config/crypt.tmpl

@@ -9 +9 @@
-
-// cipher key (512 bytes); randomized on install time
-
+%key%
-
-// padding for password hashes (512 bytes); randomized on install time
-
+%padding%
-
-$HASH['salt_length'] = 8;

trunk/includes/config/settings.tmpl

@@ -19 +19 @@
-$SETTINGS['slogan'] = 'The Tastiest Forum on Earth!'; // displayed in browser's title
-$SETTINGS['forumlogo'] = 'logo.png'; // has to be placed in the images directory
-
-
+Spam Board Website
+http://www.spamboard.net
-$SETTINGS['forumadmin'] = ''; // The admin's name. This'll be used to 'sign' all outgoing e-mail.
-$SETTINGS['forumadminemail'] = ''; // e-mail address for outgoing mail

trunk/includes/lang/en.php

@@ -306 +306 @@
-$LANG['Webserver_Path'] = 'Webserver Path';
-$LANG['New_Subscription'] = 'New Subscription';
+$LANG['Spam_Board_Installer'] = 'Spam Board Installer';
+$LANG['Start_Over'] = 'Start Over';
+$LANG['Next_Page'] = 'Next Page';
+$LANG['Set_Permissions'] = 'Set Permissions?';
-
-/* actual sentences */
@@ -379 +383 @@
-$LANG['subscriptions_updated'] = 'Your subscriptions have been updated successfully.';
-$LANG['group_memberships_updated'] = 'Your group memberships have been updated successfully.';
+$LANG['installer_intro'] = 'Hello and welcome to the Spam Board installer script! You are about to install version ' . $VERSION . " of this forum.<br /><br />We will ask you a few questions now. Don't worry, nothing will be committed before you had a chance to review all the options again. Please don't use your browser's back and forward buttons, as they'll break things. If you feel the need to change anything, you can start over at any time by using the respective button.";
+$LANG['installer_permissions'] = "To function properly, the board needs write permissions on certain directories and files. If your webserver runs on a UNIX-ish system, the script can attempt to set these permissions automatically for you. However, if you've just downloaded a release archive from the official website and extracted it directly on your webserver, this isn't necessary, as everything should already be set up correctly. If, however, you extracted the archive on another system (e.g. Microsoft Windows) first and uploaded the files to your webspace from there, the permissions have been lost. Check the box below if you want the script to set the permissions again.";
+$LANG['installer_database'] = "Now please enter some information about the database system you're going to use. If you select SQLite, you don't have to enter a username and password. For other database systems, the database you enter here already has to exist. The table prefix is put in front of the name of each table the board will create. This enabled you to run the board within a database which also contains other tables.";
+$LANG['installer_pathes'] = "Please enter two pathes which define the location you're installing the board to. The file system path is the board root in respect to the filesystem root. The web path is the directory tree after the top level domain (.com, .net, .org) to the board root. The installer script has already tried to guess them and entered these values into the respective fields. Usually, this should be correct. Only change these values if you know what you're doing.";
+$LANG['installer_board'] = "As you can see, it's getting less critical with every page. What you need to enter now is some general information about your forum and the site it should link back to.";
+$LANG['installer_admin_account'] = "This is the last page of the setup. You have to create an initial administrator account which you can use in the post-setup phase to customize everything even more. This account (including its e-mail address) will also be used to sign all outgoing mail. Of course, you can change these settings again later on. Finally, you have to select the hash algorithm which should be used to 'encrypt' the passwords. In case you don't know what that is, RIPEMD or SHA (greater 1) are common choices.<br /><br />After this page, you'll see all the settings you've chosen again and then you can choose whether to commit them or not.";
+$LANG['installer_overview'] = "Here's everything you entered once again. <i>Everything should have a value, with the exception of SQL username and password if you've selected SQLite!</i> If you've confirmed everything to be correct, proceed.";
+$LANG['installer_rewrite'] = "If you are running a webserver which is capable of URL rewriting, you can take advantage of that by using shorter URLs than otherwise. The installer script can set this up for you automatically if your webserver is Apache (requires mod_rewrite). Lighttpd can also rewrite your URLs, but you have to set up the rules for that webserver by hand for now. If you're unsure, don't select this, the board will run anyway then.";
+$LANG['installer_permissions_success'] = 'The file permissions have been set successfully.';
+$LANG['installer_rewriting_success'] = 'URL Rewriting has been set up successfully.';
+$LANG['installer_config_success'] = 'The configuration files have been set up successfully.';
+$LANG['installer_database_success'] = 'The database has been set up successfully.';
+$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></li></ol>";
-
-/* error messages */
@@ -429 +446 @@
-$LANG['error_avatar_filename'] = "Error: A file with the same name as the one you tried to upload already exists among the avatars. Please rename it and try again.";
-$LANG['error_avatar_move'] = "Error: Something unforseen went wrong with the upload. Please try again. If this error persists, contact the administrators.";
+$LANG['error_installer_permissions'] = "Error: Couldn't set file permissions. Please do it manually. Aborting.";
+$LANG['error_installer_rewriting'] = "Error: URL Rewriting couldn't be set up. Please do it manually or restart the installation without it. Aborting.";
+$LANG['error_installer_config'] = "Error: The configuration files couldn't be set up correctly. Aborting.";
+$LANG['error_installer_database'] = "Error: The database couldn't be set up correctly. Aborting.";
-
-?>