summary refs log tree commit diff stats
path: root/includes/footer.php
Commit message (Collapse)AuthorAgeFilesLines
* Changed comments' user indexStarla Insigna2009-01-051-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-39/+26
| | | | | 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-12/+29
|
* Added revision stampingStarla Insigna2008-12-301-0/+2
|
* Adjusted Rightbar for FouripediaStarla Insigna2008-12-141-1/+4
|
* Major design and code overhaulStarla Insigna2008-12-141-27/+30
| | | | I don't know, a lot of stuffses happened that I don't quite remember anymore. Goodness, that's not good.
* Tweaked tag cloudStarla Insigna2008-12-091-1/+1
| | | | | 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.
* Enhanced tag cloudStarla Insigna2008-12-091-6/+7
|
* Added a tag cloudStarla Insigna2008-12-071-0/+27
|
* Moved pingbacks to a seperate tableStarla Insigna2008-12-071-6/+3
| | | | | 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.
* Created the 6th layoutStarla Insigna2008-11-221-2/+7
|
* Added commenting to Quotes moduleStarla Insigna2008-11-201-9/+24
|
* Fixed permissionsStarla Insigna2008-11-191-0/+0
|
* Imported sourcesStarla Insigna2008-11-191-0/+198