aderowbotham

<?php

# in public_html/index.php

/*
 * Where your CodeIgniter ENVIRONMENT is normally defined by the server environment
 * variables, and assuming your database settings are automatically set based on 
 * that environment, this causes a problem when running the application through
 * PHP on the command line e.g. in order to run CodeIgniter Migrations
 *

kijtra

DELIMITER //
DROP FUNCTION IF EXISTS `STRIP_TAGS`//
CREATE FUNCTION STRIP_TAGS( x longtext) RETURNS longtext
LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA
BEGIN
	DECLARE sstart INT UNSIGNED;
	DECLARE ends INT UNSIGNED;
	
	IF x IS NOT NULL THEN
		SET sstart = LOCATE('<', x, 1);