summary refs log tree commit diff stats
path: root/includes/comments.php
Commit message (Collapse)AuthorAgeFilesLines
* Changed comments' user indexStarla Insigna2009-01-051-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-051-6/+7
| | | | | 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-051-4/+4
|
* Added an emoticon parsing systemStarla Insigna2008-12-171-1/+1
| | | | | 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.
* Changed failsafe Gravatar to WavatarStarla Insigna2008-12-071-1/+0
|
* Removed comment rating systemStarla Insigna2008-12-071-9/+1
|
* Removed "title" field from commentsStarla Insigna2008-11-191-9/+1
| | | | | Previously, for about two weeks (while Four Island was down), Four Island used a threaded commenting system with comment titles (yes, like Slashdot). I quickly grew tired of this and was too lazy to completely remove the title field.
* Fixed permissionsStarla Insigna2008-11-191-0/+0
|
* Imported sourcesStarla Insigna2008-11-191-0/+97