Spam Blocker v1.5

Spam Blocker is a CakePHP Behavior that automatically runs after a comment is made. Each comment is tested upon a point system to determine if they shall be approved or pending (high points), or marked as spam / deleted (low points).

Databasic Version Logs

Package: MySQL Database Handler
Category: PHP & MySQL

Below is a list of all files and every available version for the Databasic script.
Each file is accompanied by a change log. Be cautious in using older versions, they may buggy.

Version: 2.3.2
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Dec 1st 2009, 22:08

  • Fixed a problem with __formatType() not returning the correct type and causing major problems
  • Fixed store() referencing the wrong property
  • Fixed the regex that attempts to locate MySQL functions
  • Fixed the limit not working on update()

Version: 2.3
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Aug 18th 2009, 13:01

  • Skipped version 2.2 release because of bugs
  • The following operators within conditions are now available: LIKE, NOT LIKE, IS NULL, IS NOT NULL, IN, NOT IN
  • You may now pass the value as an array for IN operators to automatically build the list
  • Fixed a problem with nested arrays not being parsed into conditions correctly
  • Fixed a problem with conditions not being parsed correctly
  • Fixed a problem with a method using the wrong name
  • Fixed a bug with the __buildConditions() regex
  • Added the addBind() method to properly store binds for statements
  • Rewrote __buildConditions() to work with the new operators
  • Rewrote bind(), update(), delete(), insert(), select(), __formatType() to use the new binds system

Version: 2.1
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Jul 28th 2009, 22:34

  • Added support for AND/OR operators within conditions, in turn added the __formatConditions() method
  • Added more support for MySQL functions
  • Added the __encode() and __encodeMethod() methods
  • Added RAND() support for ordering within select()
  • Added a $persistent property so that you may use mysql_pconnect() instead of mysql_connect()
  • Rewrote create() to work more efficiently and added a "collate" setting
  • Rewrote bind to work correctly with MySQL functions
  • Rewrote delete(), insert() and update() to not run actions when execute is $false (optimized)
  • Rewrote __buildConditions() to support AND/OR operators, as well as the new format for value operations
  • Rewrote how operators (!=, <=, etc) are used in conditions
  • Optimized all methods to run faster and be cleaner

Version: 2.0
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Thu, Mar 12th 2009, 22:01

  • Added support for multiple databases
  • Added the store() method to store database connection information
  • Removed the database connection constants
  • Removed the $limit and $offset arguments for select(), they are now an index in the $options array
  • Fixed select()'s count return not working when being an object
  • Removed logic from __construct(), connecting is now done within getInstance(); changed for multiple db support
  • Added methods for drop(), truncate() and describe()
  • Rebuilt the optimize() method
  • Added a create() method that takes a schema array and creates database table

Version: 1.10.3
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Sun, Mar 1st 2009, 18:07

  • Fixed the insert() method (left comments/debug code in during testing)
  • Fixed the 'group' option in select(), should properly GROUP BY now
  • Fixed a problem when setting a column as NULL

Version: 1.10.2
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Fri, Feb 13th 2009, 12:50

  • Fixed a bug with the $dataBit argument not working correctly on execute()
  • Fixed the execution times when calling execute() stand alone

Version: 1.10.1
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Fri, Feb 13th 2009, 00:03

  • Added an "execution time" for queries in debug mode
  • Added the number of affected rows for queries in debug mode
  • Added a getAffected() method
  • Added a version number property
  • Fixed a bug in binds that caused an error when no binds were present
  • Fixed a problem with MySQL functions like NOW(), MD5(), etc (will need further testing)
  • Removed the $asObject argument from fetch() and fetchAll() but instead made a $asObject property in the class
  • Rebuilt the __formatColumnType() method
  • Added the __startLoadTime() and __endLoadTime methods for calculating load/process/execution times

Version: 1.10
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Mon, Feb 9th 2009, 17:05

  • First initial release of Databasic