<?php

/**

 * Plugins may load this file to gain access to special helper functions for

 * plugin installation. This file is not included by WordPress and it is

 * recommended, to prevent fatal errors, that this file is included using

 * require_once().

 *

 * These functions are not optimized for speed, but they should only be used

 * once in a while, so speed shouldn't be a concern. If it is and you are

 * needing to use these functions a lot, you might experience time outs. If you

 * do, then it is advised to just write the SQL code yourself.

 *

 *     check_column( 'wp_links', 'link_description', 'mediumtext' );

 *     if ( check_column( $wpdb->comments, 'comment_author', 'tinytext' ) ) {

 *         echo "ok\n";

 *     }

 *

 *     $error_count = 0;

 *     $tablename = $wpdb->links;

 *     // Check the column.

 *     if ( ! check_column($wpdb->links, 'link_description', 'varchar( 255 )' ) ) {

 *         $ddl = "ALTER TABLE $wpdb->links MODIFY COLUMN link_description varchar(255) NOT NULL DEFAULT '' ";

 *         $q = $wpdb->query( $ddl );

 *     }

 *

 *     if ( check_column( $wpdb->links, 'link_description', 'varchar( 255 )' ) ) {

 *         $res .= $tablename . ' - ok <br />';

 *     } else {

 *         $res .= 'There was a problem with ' . $tablename . '<br />';

 *         ++$error_count;

 *     }

 *

 * @package WordPress

 * @subpackage Plugin

 */

/** Load WordPress Bootstrap */

		}

		}

	}

endif;

		}

		}

	}

endif;

/**

 * Drop column from database table, if it exists.

 *

 * @since 1.0.0

 *

 * @global wpdb $wpdb WordPress database abstraction object.

 *

 * @param string $table_name Table name

 * @param string $column_name Column name

 * @param string $drop_ddl SQL statement to drop column.

 * @return bool False on failure, true on success or doesn't exist.

 */

	global $wpdb;

			// Found it, so try to drop it.

			// We cannot directly tell that whether this succeeded!

					return false;

				}

			}

		}

	}

	// Else didn't find it.

	return true;

}

/**

 * Check column matches criteria.

 *

 * Uses the SQL DESC for retrieving the table info for the column. It will help

 * understand the parameters, if you do more research on what column information

 * is returned by the SQL statement. Pass in null to skip checking that

 * criteria.

 *

 * Column names returned from DESC table are case sensitive and are listed:

 *      Field

 *      Type

 *      Null

 *      Key

 *      Default

 *      Extra

 *

 * @since 1.0.0

 *

 * @global wpdb $wpdb WordPress database abstraction object.

 *

 * @param string $table_name Table name

 * @param string $col_name   Column name

 * @param string $col_type   Column type

 * @param bool   $is_null    Optional. Check is null.

 * @param mixed  $key        Optional. Key info.

 * @param mixed  $default    Optional. Default value.

 * @param mixed  $extra      Optional. Extra value.

 * @return bool True, if matches. False, if not matching.

 */

	global $wpdb;

			// Got our column, check the params.

				++$diffs;

			}

				++$diffs;

			}

				++$diffs;

			}

				++$diffs;

			}

				++$diffs;

			}

				return false;

			}

			return true;

		} // end if found our column

	}

	return false;

}