| Commit message (Collapse) | Author | Age | Files | Lines |
| |
|
| |
|
|
|
|
| |
It turned out that there actually was a problem with the algorithm.
|
|
|
|
|
| |
Now, Four Island doesn't look downright disgusting in IE, even though there are still a couple more problems to be fixed. Also, a small amount of CSS
housekeeping was done.
|
|
|
|
|
|
|
|
|
|
| |
Easter holidays were coming a day late, so a day was ticked off of the
Easter fourmula. It does concern me, however, that this issue wasn't
discovered last year. Either there was another Easter bug last year
(maybe during the time all Easter holidays were a month late?) or my
fourmula's wrong.
I also cleaned up some of the Special Dates code.
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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`;"
|
|
|
|
|
| |
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.
|
|
|
|
|
| |
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.
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
|
|
| |
Also fixed spelling of maintenance in places where it was incorrectly spelled.
Maintenance Required: Rename "mantainenceMode" config to "maintenanceMode"
|
|
|
|
| |
Now, changes can be remotely pushed to the central repository and updated using the Admin panel.
|
|
|
|
|
| |
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.
|
|
|
|
|
| |
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.
|
| |
|
| |
|
|
|
|
|
| |
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.
|
| |
|
| |
|
|
|
|
| |
I don't know, a lot of stuffses happened that I don't quite remember anymore. Goodness, that's not good.
|
|
|
|
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
|
| |
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.
|
|
|
|
|
| |
Previously, the tag cloud excluded tags which weren't used for "published" posts, but when counting the ones that were, it also counted any instances
of the tag in other types of posts. This has now been fixed.
|
|
|
|
| |
It was incorrectly fixed last time, but this time should be right.
|
| |
|
|
|
|
|
|
| |
The pending post automatic poster was accidentally not posting the tags
that go along with the posts because it was not updated when the new tag
system came out.
|
| |
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
|
|
| |
A mantainence has been created in the config table so that when it is on, users other than the localhost only see a temporarily down message, while
localhost can still access Four Island. This will be useful during times when changes in this repository do things that require the database schema
to be changed or scripts to be run, such as the previous three changesets.
|
| |
|
|
|
|
|
| |
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.
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
Saturday is Four Island's weekly poll day, so normal articles should not be posted on that day.
|
| |
|
| |
|
| |
|
| |
|