summary refs log tree commit diff stats
path: root/pages
Commit message (Collapse)AuthorAgeFilesLines
* Changed comments' user indexStarla Insigna2009-01-052-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-052-8/+4
| | | | | 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.
* Integreated Fourm usersStarla Insigna2009-01-054-86/+12
|
* Added fuhsdiufgsadiufgaisfioasStarla Insigna2009-01-041-0/+29
|
* Fixed many HTML validation errorsStarla Insigna2008-12-211-1/+1
|
* Re-did 404 pageStarla Insigna2008-12-211-5/+7
| | | | | | 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.
* Relocated includes/functions_quotes.phpStarla Insigna2008-12-211-2/+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-211-28/+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-201-0/+38
| | | | | | 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-201-0/+9
| | | | Now, changes can be remotely pushed to the central repository and updated using the Admin panel.
* Replaced addslashes()Starla Insigna2008-12-192-11/+11
| | | | | 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.
* 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 an emoticon parsing systemStarla Insigna2008-12-174-6/+6
| | | | | 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.
* Major design and code overhaulStarla Insigna2008-12-144-56/+59
| | | | I don't know, a lot of stuffses happened that I don't quite remember anymore. Goodness, that's not good.
* 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-131-12/+9
| | | | | 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.
* Replaced all "www" subdomain linksStarla Insigna2008-12-101-1/+0
| | | | | For some reason, the source is full of www subdomain links. The rewriting engine doesn't seem to rewrite correctly, so most www subdomain links forward to the original URL, not the rewritten URL, which is the base of the Pingback error.
* Fixed long-time poll glitchStarla Insigna2008-12-092-45/+43
| | | | | After you voted on the POTW, the resulting page used to be very strange and hideous. This has finally, after being like this since the beginning of the third layout, been fixed.
* Redid multiple tag systemStarla Insigna2008-12-073-21/+49
| | | | | | This new tag system has a seperate table for tags. This way, a tag cloud can be made much more easily than if using the previous system. This changeset requires manual maintinence.
* Moved pingbacks up in layoutStarla Insigna2008-12-071-17/+18
| | | | They look better up there. :)
* Removed "comic" moduleStarla Insigna2008-12-071-177/+0
| | | | | As KFM is pretty much dead, there is no need for an incomplete comic viewing module. Anyway, if I was ever going to start KFM again, the comics would be displayed on the main blog.
* Removed comment rating systemStarla Insigna2008-12-071-68/+20
|
* Moved pingbacks to a seperate tableStarla Insigna2008-12-071-0/+21
| | | | | Because pingbacks just aren't comments, they shouldn't be stored in the comments table. So, a new table has been created for them and the blog post view pages have been accomodated to show them at the bottom just like the related posts are shown.
* Added support for a variable amount of tagsStarla Insigna2008-12-073-40/+51
| | | | | | Previously, the blogging engine only allowed for three tags per post, and it also stored each in seperate fields. Now, all tags are stored in one field and there can be more than three. The only functionality that has been removed because of this is that now, on archive pages, tags are not shown next to the current month's posts as they used to be, because the Four Island templating system does not yet support sub-blocks of sub-blocks.
* Merged the backout of the revokal of Layout 6Starla Insigna2008-12-061-0/+3
|\
| * Revoked the revokal of Layout 6Starla Insigna2008-12-061-0/+3
| | | | | | | | | | Apparently people actually do like the sixth layout. It was just me being paranoid, they were busy over there.
* | Redirected blog post urlsStarla Insigna2008-12-061-0/+5
|/ | | | | It turns out that FeedBurner somehow gets a hold of the original URLs for blog posts instead of the rewritten ones, so users clicking on them go there. I've fixed the problem by checking for "index.php" in the URL in blog.php, and redirecting if it finds it. This was the problem with the Pingback thing.
* Reverted back to layout 4Starla Insigna2008-12-061-3/+0
| | | | Oh so many people complained at the new, pretty layout. The decision was reached in the Poll of the Week: Layout 6 had to go.
* Added Quotes option linksStarla Insigna2008-11-271-0/+3
|
* Created the 6th layoutStarla Insigna2008-11-223-32/+77
|
* Added commenting to Quotes moduleStarla Insigna2008-11-201-0/+2
|
* Fixed a few code nagsStarla Insigna2008-11-191-0/+1
|
* Removed includes/phpsvnclient.phpStarla Insigna2008-11-191-94/+0
| | | | | | phpsvnclient.php was previously used to interface the Four Island Subversion Repositories so changesets could be seen via the RSS feed, but not only not many people want this in their RSS feed, and the people that did could get a seperate feed, but Four Island no longer uses Subversion, instead it uses the better, distributive Mercurial.
* Removed 'wiki' moduleStarla Insigna2008-11-192-244/+0
| | | | Since MediaWiki was introduced to Four Island, the old wiki module hasn't been used, so it is not necessary to be present.
* Improved Quotes Admin moduleStarla Insigna2008-11-192-28/+39
| | | | | Fixed the Quotes Management module in the admin panel so that comments with line breaks in them would actually show up on individual lines. Also, the quotes can be distinguished from one another by every other row in the table being shaded differently.
* Removed reCaptcha from Login pageStarla Insigna2008-11-191-25/+7
| | | | Really, there is no reason to have a CAPTCHA on a Login page. reCaptcha can be re-added to Four Island when a registration page is created.
* Fixed permissionsStarla Insigna2008-11-1918-0/+0
|
* Imported sourcesStarla Insigna2008-11-1918-0/+2250