Tekkeryole

# HeidiSQL DUMP
#
# --------------------------------------------------------
# Host:                         127.0.0.1
# Database:                     world
# Server version:               5.0.45-community-nt
# Server OS:                    Win32
# Target compatibility:         ANSI SQL
# HeidiSQL version:             4.0
# DATE/TIME:                    2009-09-05 03:13:23
# --------------------------------------------------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


DROP TABLE IF EXISTS "guild_housing";

#
# TABLE structure FOR TABLE 'guild_housing'
#

CREATE TABLE "guild_housing" (
  "id" mediumint(8) unsigned NOT NULL auto_increment,
  "position_x" FLOAT NOT NULL DEFAULT '0',
  "position_y" FLOAT NOT NULL DEFAULT '0',
  "position_z" FLOAT NOT NULL DEFAULT '0',
  "orientation" FLOAT NOT NULL DEFAULT '0',
  "map" SMALLINT(5) unsigned NOT NULL DEFAULT '0',
  "name" VARCHAR(100) NOT NULL DEFAULT '',
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=100026 COMMENT='Housing Commands';

/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/


INSERT INTO `command` (`name`, `security`, `help`) VALUES ('lookup house', '1', 'Syntax: .lookup house $substring\r\n\r\nSearch and output all .house command locations with provide $substring in name.');
INSERT INTO `command` (`name`, `security`, `help`) VALUES ('house', '1', 'Syntax: .house #location\r\n\r\nTeleport player to a housing location by name.');
INSERT INTO `command` (`name`, `security`, `help`) VALUES ('house buy', '3', 'Syntax: .house buy $name\r\n\r\nAdd your current position to .house command target locations list with name $name.');
INSERT INTO `command` (`name`, `security`, `help`) VALUES ('house del', '5', 'Syntax: .house del $name\r\n\r\nRemove location with name $name for .house command locations list.');
INSERT INTO `command` (`name`, `security`, `help`) VALUES ('house portguild', '1', 'Syntax: .house guildport#location\r\n\r\nTeleport a selected player and his guild members to a given location.');
INSERT INTO `command` (`name`, `security`, `help`) VALUES ('house list', '1', 'Syntax: .house name [#playername] #location\r\n\r\nTeleport the given character to a given location. Character can be offline.');