summary refs log tree commit diff stats
path: root/pages/post.php
Commit message (Collapse)AuthorAgeFilesLines
* Made Four Island 2 a little more saneStarla Insigna2010-12-111-2/+2
| | | | | | | | | I spent the last few hours sanitizing the database and fixing huge bugs in the code. Among the changes made were: - "Theoretically related posts" have been removed due to the lack of FULLTEXT index support in InnoDB tables - Removed tons of stripslashes() calls that were used to remove slashes from records before I realized (while doing all of this work) that magic_quotes_gpc was on for some reason. I mean, like, come on! - Replaced all non-library uses of htmlentities() with htmlspecialchars(), which basically does the same thing except it doesn't mangle Unicode. - Completely eradicated polls. Note that this does mean that all database backups prior to December 11th 2010 are now incompatible with Four Island.
* Merged unforgiving heads (and...)Starla Insigna2010-08-171-5/+5
|\ | | | | | | | | Also updated public and private keys for reCAPTCHA. As well as the use of the new keys, Four Island now stores the private key along with the other protected information that is not source controlled, instead of with the public key.
| * Added back reCAPTCHAStarla Insigna2010-08-171-5/+6
|/ | | | | | Because of the lifting of the jail around my server, it can once again use reCAPTCHAs for security. Backed out changeset 9332c237adcd
* Added working CAPTCHAStarla Insigna2010-03-121-6/+5
| | | | | After a little digging, it turned out that the reason that reCAPTCHA always failed was because the reCAPTCHA server was blocked to the server. This should've been obvious as the reCAPTCHA always worked on the development server.
* Created layout 7Starla Insigna2009-08-091-44/+59
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | The following changes were also made in this revision: * All HTML was changed to XHTML and a !DOCTYPE was included to reflect this * Rewrote quotes tracking system to be much less complicated and actually working * Changed quotes rendering to look more like Chirpy than Rash * Fixed comment textarea bug * Rewrote a ton of CSS so it's not as bloated * Added a JavaScript confirmation when deleting a comment * AJAXified voting on the POTW * AJAXified voting and flagging quotes * AJAXified commenting * AJAXified voting on posts * Added DateFinder back after it was accidentally deleted in Layout 4.5 The following database changes must be performed as soon as possible: * Fix title of NO <!DOCTYPE> post (the &lt; is missing the semicolon) * Restore post Frasty Tha Snaman from a backup * Reset "flag" field of all rows in "rash_quotes" to 0 * Remove the "vote" and "flag" columns of "rash_tracking" * Rename the "quote_id" column of "rash_tracking" to "vote" The following external code changes must also be performed as soon as possible: * Add the following line to the end of the // Four Island block in The Fourm's functions.php: require('/svr/www/hatkirby/fourisland/main/includes/specialdates.php');
* Changed comments' user indexStarla Insigna2009-01-051-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-2/+2
| | | | | 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-3/+3
|
* Fixed gender pronounsStarla Insigna2008-12-201-21/+21
|
* Fixed permissionsStarla Insigna2008-11-191-0/+0
|
* Imported sourcesStarla Insigna2008-11-191-0/+107