summary refs log tree commit diff stats
Commit message (Collapse)AuthorAgeFilesLines
* Changed comments' user indexStarla Insigna2009-01-055-12/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Previously, the comments table referenced users by username. However, if user ever changed their username, everything would become messed up. To fix this, the index has been changed to the user ID. This change obviously requires maintenance: This SQL must be run: "ALTER TABLE `comments` ADD `user_id` INT( 11 ) NOT NULL AFTER `page_id`;" This PHP will generate some SQL that must be run: <?php $getusers = "SELECT DISTINCT username FROM comments WHERE is_anon = 0"; $getusers2 = mysql_query($getusers); while ($getusers3 = mysql_fetch_array($getusers2)) { $getuser = "SELECT * FROM phpbb_users WHERE username = \"" . $getusers3['username'] . "\""; $getuser2 = mysql_query($getuser); $getuser3 = mysql_fetch_array($getuser2); echo("UPDATE comments SET user_id = " . $getuser3['user_id'] . " WHERE username = \"" . $getuser3['username'] . "\" AND is_anon = 0;<BR>"); } $getusers = "SELECT * FROM anon_commenters"; $getusers2 = mysql_query($getusers); while ($getusers3 = mysql_fetch_array($getusers2)) { echo("UPDATE comments SET user_id = " . $getusers3['id'] . " WHERE username = \"" . $getusers3['username'] . "\" AND is_anon = 1;<BR>"); } ?> This SQL must be run: "ALTER TABLE `comments` DROP `username`;"
* Improved anonymous commentingStarla Insigna2009-01-054-53/+37
| | | | | There was a bug where, if an anonymous commenter used a username that was being used by an actual member, Four Island would think the anonymous commentor was actually the member.
* Restricted Admin panel to AdminsStarla Insigna2009-01-051-1/+1
| | | | | Previously, when phpBB3 was integrated, the user group 2 was mistaken as the Admin group when it was actually the Registered group, thus allowing anyone who could log in to access the admin panel.
* Added Admin link to navbarStarla Insigna2009-01-052-0/+12
|
* Integreated Fourm usersStarla Insigna2009-01-0510-149/+104
|
* Fixed POTW form linebreak errorStarla Insigna2009-01-041-0/+2
|
* Merged unforgiving headsStarla Insigna2009-01-042-0/+31
|\
| * Added fuhsdiufgsadiufgaisfioasStarla Insigna2009-01-042-0/+31
| |
* | Modified some image ALTsStarla Insigna2009-01-032-4/+4
| |
* | Added :D smileyStarla Insigna2009-01-032-0/+1
| |
* | Removed some unnecessary theme imagesStarla Insigna2009-01-028-0/+0
| |
* | Fixed some night bugs in Layout 6.1Starla Insigna2009-01-023-18/+0
| |
* | Created layout 6.1Starla Insigna2009-01-014-64/+47
| |
* | Added revision stampingStarla Insigna2008-12-302-1/+4
|/
* Fixed some more HTML validation errorsStarla Insigna2008-12-262-5/+5
|
* Modfied Quotes module's night visionStarla Insigna2008-12-246-9/+18
|
* Fixed many HTML validation errorsStarla Insigna2008-12-2114-141/+127
|
* Removed jQuery libraryStarla Insigna2008-12-212-66/+0
| | | | | Because Four Island is now usable in IE, there is no reason to turn back IE 6 users. Thusly, the jQuery library has been deleted, which also saves bandwidth, as the file was 60K.
* Eased usability in IEStarla Insigna2008-12-212-2/+12
| | | | | | Previously, IE had a problem with IE 6 that made it impossible to use Four Island. The rightbar was cleared to the bottom, the posts' text were invisible, the top-fade obscured text and The Fourm was illegiable. This has (mostly) been fixed with a conditional stylesheet. Four Island doesn't look perfect in IE yet (and probably never will) but at least now it's usable.
* Re-did 404 pageStarla Insigna2008-12-213-69/+109
| | | | | | For some reason, the 404 page was previously filled with terrible semantics, IE classes and it didn't look great. Now, the HTML has been improved. The Search clause has been fixed, there was a bug with displaying the search terms. Also, the error document has been set to the 404 page so the 404 page is actually shown when a page cannot be found.
* Rearranged .htaccess fileStarla Insigna2008-12-211-3/+3
| | | | | | | The whole pingback RSS error was, at the core, the fault of bad redirection. The problem was that the redirection from the "www" subdomain was the last priority in the file, while it should have been the first.
* Relocated includes/functions_quotes.phpStarla Insigna2008-12-212-197/+170
| | | | | | As the functions defined in functions_quotes.php are only used in the quotes.php module, there is no reason to have them located in a seperate include file.
* Removed splash screenStarla Insigna2008-12-216-540/+0
|
* Removed legacy pages/fourm.phpStarla Insigna2008-12-211-31/+0
| | | | | Ages ago, Four Island used mod_rewrite and a module called fourm.php to integrate The Fourm into the main site. However, now that task is accomplished by The Fourm itself by including the Four Island header.php and footer.php
* Fixed gender pronounsStarla Insigna2008-12-201-21/+21
|
* Added Maintenance switcher to AdminStarla Insigna2008-12-206-5/+59
| | | | | | Also fixed spelling of maintenance in places where it was incorrectly spelled. Maintenance Required: Rename "mantainenceMode" config to "maintenanceMode"
* Added HG Update to AdminStarla Insigna2008-12-203-0/+16
| | | | Now, changes can be remotely pushed to the central repository and updated using the Admin panel.
* Included parsers.php into RSS feedStarla Insigna2008-12-2013-1/+1
| | | | | Previously, the RSS feed wouldn't display because it attempted to display parsed blog posts, but the parseText() function was not defined as parsers.php was not included.
* Replaced addslashes()Starla Insigna2008-12-193-13/+13
| | | | | Many SQL queries were using the function addslashes() to escape their content. They have been replaced with the more secure mysql_real_escape_string() function.
* Fixed Draft->Pending deletion bugStarla Insigna2008-12-191-1/+1
| | | | | | Previously, if a draft was being moved into the pending queue, it would be deleted instead. The problem turned out to be the fact that when the tag system was changed (409d99f03471), the single instance in the admin panel of a draft being changed into a pending post was not fixed as the rest were. The extra column in the "INSERT" query annoyed MySQL as that column no longer exists.
* Added [thumb] BBCodeStarla Insigna2008-12-193-1/+3
| | | | | The [thumb] bbcode takes the content and creates a thumbnail of it. The thumbnail fits perfectly inside the post bubble and is wrapped with a link to the original image.
* Fixed Admin's movePending post deletion bugStarla Insigna2008-12-191-5/+5
| | | | | | | | | | | | Certain posts, when moved around, were strangely deleted from the pending queue. This was actually two seperate bugs, both causing the same problem. 1. When looking for the post to swap with, the movePending command would search for the next post with an ID greater than or less than the current ID, but it wouldn't actually sort the results correctly so that the corrent posts wouldn't neccessarily always be the post shown. This resulted in a seemingly random pending posts being deleted. This has been fixed by adding a simply "ORDER BY" clause to the SQL "SELECT" commands. 2. When re-inserting the pending posts into the queue (after swapping IDs), if one of the posts contained invalid characters requiring escaping, MySQL would reject the post without error and simply not insert it, resulting in one or more of the posts involved in the switch to be deleted. This has been fixed by wrapping the text of the post in the mysql_real_escape_string() function.
* Fixed Admin's movePending EIIEOIAFOA syndromeStarla Insigna2008-12-191-4/+4
| | | | | The admin panel's movePending was suffering the same Every Item Is Exactly One ID Away From One Another syndrome that the main blog was facing in changeset 8c0096629f88 (Fixed blog post Next/Previous links)
* Fixed Admin's movePending outputStarla Insigna2008-12-191-18/+11
| | | | | | | | | | | | The movePending command is used to re-arrange the pending queue. However, it's output had two errors: 1. If the move completed sucessfully, the pending queue would be shown again. However, the URL would still be the movePending command, with it's parameters. Because of this, if the user refreshed, it would try to re-arrange the queue again, which could cause some strange things to happen as the post in question had already been moved. This problem has been fixed by redirecting to the managePending command after executing the movePending command instead of simply running the managePending command internally as used to be the problem. 2. As a collary of the preceding error, if the move failed, the error would simply back up the browser's history and refresh. If the previous page was the output of a sucessful movePending command, strange things would happen. This was fixed dually by the previous solution and the fact that now the error messages simply link to the managePending command.
* Added Smiley-parsing to Quotes DBStarla Insigna2008-12-181-1/+1
|
* Added sad ":(" smileyStarla Insigna2008-12-172-0/+1
|
* Added an emoticon parsing systemStarla Insigna2008-12-1712-12/+112
| | | | | I decided that, because I use the :) emoticon so often, I might as well replace it with an actual image. I've added a Smiley parsing system to complement the BBCode parsing one.
* Prettified the footerStarla Insigna2008-12-141-0/+5
|
* Adjusted Rightbar for FouripediaStarla Insigna2008-12-143-266/+274
|
* Fixed NavBar for Fourm and FouripediaStarla Insigna2008-12-143-0/+16
|
* Major design and code overhaulStarla Insigna2008-12-1419-229/+287
| | | | I don't know, a lot of stuffses happened that I don't quite remember anymore. Goodness, that's not good.
* Fixed BBCode parsing glitchStarla Insigna2008-12-131-4/+6
| | | | | | | | | | | | As previously seen in the 24 Ways post, there was a strange BBCode parsing glitch caused by a few circumstances. There had to be a BBCode tag that had a parametered definition and a non-parametered definition. Both had to appear in the same post and the parametered had to appear before the non-parametered. Because the Four Island BBCode parsing system parses non-parametered tags first, it finds the opening tag of the non-parametered tag first, but when it tries to find the closing tag, because it is searching from the beginning of the tag, it finds the closing tag of the parametered tag. This causes strange things to happen. This has been fixed by forcing the parsing system to start searching for the closing tag after the position where the starting tag is.
* Fixed blog post Next/Previous linksStarla Insigna2008-12-131-2/+2
| | | | | Previously, when a post was deleted, it's adjacent posts displayed nothing for the respective Next/Previous link because there was no post with an ID exactly one before or after it. Now, blog.php just looks for the next or previous ID, regardless of if it's actually adjacent.
* Optimized postingStarla Insigna2008-12-132-17/+13
| | | | | Previously, Four Island posted a blog, and then searched through the table looking for it so it could retrieve its ID. Now, the "mysql_insert_id()" function is used instead.
* Fixed unique_id overridingStarla Insigna2008-12-121-20/+23
|
* Replaced JS bubblesStarla Insigna2008-12-124-297/+20
| | | | | Now, instead of creating bubbles using JavaScript, they are created using the CSS3 style "border-radius" commands.
* Merged headsStarla Insigna2008-12-111-0/+1
|\
| * Fixed RSS feedStarla Insigna2008-12-111-0/+1
| | | | | | | | | | When the BBCode parsing engine declared a dependency on a function in the functions.php file, the RSS feed was never updated to include it, so the BBCode parser failed and the feed remained empty. This has now been fixed.
* | Added Pyro's blog to the blogrollStarla Insigna2008-12-111-0/+5
|/
* Created own bbcode systemStarla Insigna2008-12-102-118/+104
| | | | | To be able to test for Internet Explorer troubles, the dependency on the bbcode PECL module had to be dropped, and so it has been. Hopefully this BBCode module works.