MySQL Function Import

CREATE DATABASE  IF NOT EXISTS `ni31914_4sql2` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `ni31914_4sql2`;-- MySQL dump 10.13  Distrib 5.6.13, for Win32 (x86)---- Host: localhost    Database: ni31914_4sql2-- -------------------------------------------------------- Server version	5.6.17/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Dumping routines for database 'ni31914_4sql2'--/*!50003 DROP FUNCTION IF EXISTS `getHouseListForPlayer` */;/*!50003 SET @saved_cs_client      = @@character_set_client */ ;/*!50003 SET @saved_cs_results     = @@character_set_results */ ;/*!50003 SET @saved_col_connection = @@collation_connection */ ;/*!50003 SET character_set_client  = utf8 */ ;/*!50003 SET character_set_results = utf8 */ ;/*!50003 SET collation_connection  = utf8_general_ci */ ;/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;DELIMITER ;;CREATE DEFINER=`root`@`localhost` FUNCTION `getHouseListForPlayer`(listPosX FLOAT, listPosY FLOAT, listPosZ FLOAT, radius FLOAT) RETURNS varchar(128) CHARSET utf8    READS SQL DATA    DETERMINISTICBEGIN DECLARE hID INT; DECLARE summary VARCHAR(1024);DECLARE no_more_rows BOOLEAN;DECLARE loop_cntr INT DEFAULT 0;DECLARE num_rows INT DEFAULT 0;DECLARE houseID_fetch CURSOR FORSELECT HouseIDFROM samp_house_infoWHERE SQRT(POWER(ABS(listposX-PosX),2)+POWER(ABS(listposY-PosY),2)+POWER(ABS(listposZ-PosZ),2)) < radiusORDER BY SQRT(POWER(ABS(listposX-PosX),2)+POWER(ABS(listposY-PosY),2)+POWER(ABS(listposZ-PosZ),2)) ASCLIMIT 1;DECLARE CONTINUE HANDLER FOR NOT FOUNDSET no_more_rows = TRUE;OPEN houseID_fetch;select FOUND_ROWS() into num_rows;SET summary = CONVERT(num_rows, CHAR(8));the_loop: LOOPFETCH houseID_fetchINTO hID;IF no_more_rows THENCLOSE houseID_fetch;LEAVE the_loop;END IF;SET summary = CONCAT(summary, '|', CONVERT(hID, CHAR(8)));SET loop_cntr = loop_cntr + 1;END LOOP the_loop;RETURN summary;END ;;DELIMITER ;/*!50003 SET sql_mode              = @saved_sql_mode */ ;/*!50003 SET character_set_client  = @saved_cs_client */ ;/*!50003 SET character_set_results = @saved_cs_results */ ;/*!50003 SET collation_connection  = @saved_col_connection */ ;/*!50003 DROP FUNCTION IF EXISTS `isFieldExisting` */;/*!50003 SET @saved_cs_client      = @@character_set_client */ ;/*!50003 SET @saved_cs_results     = @@character_set_results */ ;/*!50003 SET @saved_col_connection = @@collation_connection */ ;/*!50003 SET character_set_client  = utf8 */ ;/*!50003 SET character_set_results = utf8 */ ;/*!50003 SET collation_connection  = utf8_general_ci */ ;/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;DELIMITER ;;CREATE DEFINER=`root`@`localhost` FUNCTION `isFieldExisting`(table_name_IN VARCHAR(100), field_name_IN VARCHAR(100)) RETURNS int(11)RETURN (    SELECT COUNT(COLUMN_NAME)     FROM INFORMATION_SCHEMA.columns     WHERE TABLE_SCHEMA = DATABASE()     AND TABLE_NAME = table_name_IN     AND COLUMN_NAME = field_name_IN) ;;DELIMITER ;/*!50003 SET sql_mode              = @saved_sql_mode */ ;/*!50003 SET character_set_client  = @saved_cs_client */ ;/*!50003 SET character_set_results = @saved_cs_results */ ;/*!50003 SET collation_connection  = @saved_col_connection */ ;/*!50003 DROP PROCEDURE IF EXISTS `addFieldIfNotExists` */;/*!50003 SET @saved_cs_client      = @@character_set_client */ ;/*!50003 SET @saved_cs_results     = @@character_set_results */ ;/*!50003 SET @saved_col_connection = @@collation_connection */ ;/*!50003 SET character_set_client  = utf8 */ ;/*!50003 SET character_set_results = utf8 */ ;/*!50003 SET collation_connection  = utf8_general_ci */ ;/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `addFieldIfNotExists`(    IN table_name_IN VARCHAR(100)    , IN field_name_IN VARCHAR(100)    , IN field_definition_IN VARCHAR(100))BEGIN    -- http://javajon.blogspot.com/2012/10/mysql-alter-table-add-column-if-not.html    SET @isFieldThere = isFieldExisting(table_name_IN, field_name_IN);    IF (@isFieldThere = 0) THEN        SET @ddl = CONCAT('ALTER TABLE ', table_name_IN);        SET @ddl = CONCAT(@ddl, ' ', 'ADD COLUMN') ;        SET @ddl = CONCAT(@ddl, ' ', field_name_IN);        SET @ddl = CONCAT(@ddl, ' ', field_definition_IN);        PREPARE stmt FROM @ddl;        EXECUTE stmt;        DEALLOCATE PREPARE stmt;    END IF;END ;;DELIMITER ;/*!50003 SET sql_mode              = @saved_sql_mode */ ;/*!50003 SET character_set_client  = @saved_cs_client */ ;/*!50003 SET character_set_results = @saved_cs_results */ ;/*!50003 SET collation_connection  = @saved_col_connection */ ;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2014-10-02 19:44:43